Database Administrator

Chenega Corporation - St. Louis, MO

Full-time - Mid Level

St. Louis, MO

Administrative and Support Services

About the position

The Database Administrator (DBA) at Chenega MIOS will manage Oracle and PostgreSQL databases, focusing on installation, configuration, design, and data migration within Aeronautical Production Systems. This role emphasizes modernization and cloud migration, particularly transitioning Oracle databases to AWS Cloud. The DBA will also support system improvements, develop data migration strategies, and document best practices, contributing to large-scale government operations.

Responsibilities

• Support Oracle database migration from on-premise to AWS Cloud leveraging RDS managed service.
• Analyze and evaluate system improvements, optimization, development, and maintenance efforts.
• Conduct feasibility studies of Oracle vs PostgreSQL database options across cloud system architectures.
• Provide Subject Matter Expertise (SME) level input to lead Engineering studies on proposed solutions.
• Develop long-term and short-term requirements for database administration and design.
• Create and implement data migration strategies.
• Modify Oracle functions to produce additional data outputs.
• Modernize databases to utilize and implement Spatial functionality.
• Document database procedures and best practices.
• Manage and maintain Oracle databases, including migration of version updates.
• Maintain and optimize spatial data in Oracle.
• Potentially convert Oracle database to PostgreSQL.
• Perform other duties as assigned.

Requirements

• Bachelor's Degree in a related discipline with 4+ years of relevant experience OR Master's Degree in a related discipline with 2+ years of relevant experience.
• Active TS/SCI Clearance.
• Experience in front end and back-end test verification.
• Experience maintaining operational Oracle databases for mission-critical systems.
• Experience scripting for views, functions, and queries.
• Experience with query tuning for database optimization.
• Experience with cloud-first, AWS native architectures and RDS managed service.
• Prior experience using Oracle SQL/PLSQL, and SQL in general.
• Previous experience scripting with Bash/Linux shell scripting.
• Familiarity with SAFe Agile and DevOps development environments.
• Ability to work independently and effectively within a team setting.
• Demonstrated ability to communicate and collaborate with diverse stakeholders.
• Excellent skills in Microsoft Word, Excel, and other Office applications.
• Ability to provide technical assistance and support over the phone.

Nice-to-haves

• Previous customer service experience strongly desired.
• Good problem-solving skills with the ability to visualize and abstractly solve problems.

Benefits

• Professional development opportunities.
• Well-being programs.
• Flexible work environment.
• Supportive company culture.
• Opportunities for hands-on experience in a fast-changing business world.