Job Description :
Job ID: NC1011)

Oracle Data Architect with db design, operational data stores, data analysis, web publishing, SQL tuning and education/K-12 experience

Location: 301 N Wilmington St Raleigh NC (NCDPI)
Duration: 3 months
Inperson: Yes

Knowledge, Skills, and Abilities Requirements:
Must have a 4 year degree in computer science or similar field from an accredited university

Minimum Experience:
6+ years Oracle database design
6+ years Database Architecture expertise with experience architecting operational data stores
Ability to do complex data analysis
3+ years experience working with very large databases
Ability to develop/elicit and document data requirements
Ability to interpret data requirements, ask questions to gain clarity, and architect complex systems
Excellent oral and written communication skills

Preferred Experience:
Prefer some applications coding experience and web publishing experience
Prefer experience tuning SQL and writing Stored Procedures
Proven experience writing database views
Education Experience:

Description (including, but not limited to):
1. Technical expertise centered around a technology, technologies, or a portfolio of applications
2. Specialization in application, technical, domain, or solution architecture, including design and implementation of solutions
3. Successful development and maintenance of formal strategies, sourcing guidance, technical standards, blueprints, reference architectures, architecture patterns and technology roadmaps for a given architecture domain
4. Successful completion of technology projects within area of responsibility
5. Definition and management of team structure and resource levels to support business needs of functional area
6. Analyzing and estimating feasibility and compatibility of solutions with existing EA including hardware, network and other programs. Guide decision makers toward the final solution architecture which is most compliant with EA.
7. Conducting industry and market research of technologies and general themes in assigned architecture areas.
8. Engaging agency subject matter experts, business liaisons, and OITS representatives as to ensure proper alignment between business and IT
9.Understanding of PowerSchool architecture
10.Complete Oracle database design architecture as assigned by the NCDPI Database Team
11.Experience with architecting Operational Data Stores
12. Elicit, develop, and document architecture requirements and data integration requirements. Interpret data requirements.