Description

Design, build, and maintain relational databases and data warehouses to support system remediation projects.

Responsibilities

• Design and build relational, multidimensional, and data warehouse databases.
• Develop strategies for data acquisition, archive recovery, and database implementation.
• Perform database maintenance including cleaning old data and managing metadata registries.
• Optimize database performance and conduct defect root cause analysis.
• Ensure all database administration interfaces and reporting outputs comply with EIR Accessibility standards.

Required Skills

• 6 years of experience designing, developing, and supporting Oracle databases (version 11x, 12x, or later).
• 6 years of experience writing SQL for relational databases.
• 6 years of experience with Oracle performance tuning and troubleshooting.
• 6 years of experience writing stored procedures, views, managing database security, and developing reports.
• 5 years of experience documenting database design, processes, and interfaces.
• 5 years of experience supporting application development on J2EE and WebSphere platforms.
• 5 years of experience working within Agile project management methodologies.
• Working knowledge of EIR Accessibility standards and assistive technologies.
• Ability to provide on-call support as needed.

Preferred Skills

• Experience working with a Client or other State Agency.

Key Skills

Education

Any Graduate