Description

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

This role is on-site.

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 designing, developing, and supporting Oracle databases (version 11x, 12x, or later).
• 6+ years writing SQL for relational databases.
• 6+ years with Oracle performance tuning and troubleshooting.
• 6+ years writing stored procedures, views, managing database security, and developing reports.
• 5+ years documenting database design, processes, and interfaces.
• 5+ years supporting application development on J2EE and WebSphere platforms.
• 5+ years 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