Oracle Database Administrator, Senior

About the Role

General Dynamics Information Technology (GDIT) seeks a highly motivated and experienced Senior Database Administrator to support a Defense Threat Reduction Agency (DTRA) mission in Albuquerque, NM. This position will support the Defense Stockpile Management Systems (DSMS), including DIAMONDS, JADE, NIMACS, GAT, and DATS.

Responsibilities

• Resolve complex issues involving database performance, capacity, resiliency, stability, replication, and other key aspects of distributed database technology.
• Perform testing, analysis, and modification of existing database SQL stored procedures.
• Evaluate, refine, and tune existing Oracle objects in support of applications.
• Install, upgrade, patch, secure, diagnose system problems, user accessibility, and troubleshoot Oracle Database versions 12.2 through 19.26.
• Digest onsite concepts, design, implementation, limitations, and configuration of complex database environments.
• Define, troubleshoot, document, and escalate issues as needed.
• Work closely with application development teams to implement and support data-oriented development efforts.
• Assist with analysis and documentation of user requirements.
• Implement system security patches and Security Technical Implementation Guides (STIGs).
• Maintain an electronic repository of all database baselines, changes, and documentation.
• Research and recommend solutions that best meet program needs and operational requirements.
• Evaluate existing database structures and propose solutions to enhance efficiency while maintaining data integrity.
• Create database schemas and objects such as tables, columns, triggers, stored procedures, and scheduled jobs.
• Create database models based on current and future requirements outlined by the customer.
• Evaluate, review, revise, and integrate database change requests.
• Utilize tools such as Visual Studio, Toad Data Modeler, SQLPLUS, Team Foundation Server, Azure DevOps, Jira, and SolarWinds Helpdesk.

Qualifications

• 5+ years of direct Oracle DBA experience working with Oracle Enterprise Editions.
• 7+ years of increasing responsibilities in Oracle Application Development and Database Administration.
• 5+ years of direct IT experience supporting database environments on RHEL and Windows system platforms.
• BS/BA degree in Computer Science/Software Engineering and/or Database Management plus 5 to 7 years of related work experience.
• Robust experience administering Oracle Database Enterprise Editions.
• Preferred certifications: Oracle 19c Certified Associate (OCA), Oracle 19c Certified Professional (OCP), and CompTIA Security+.
• Secret security clearance required, with the ability to gain and hold Top Secret.

Skills

• Advanced analytical and problem-solving skills.
• Strong time management and organizational skills.
• Ability to work independently and within a team.
• Strong understanding of Oracle Data Guard Replication and Recovery Manager.
• Experience with Linux and Windows-based operating systems administration and troubleshooting.
• Extensive knowledge of relational database concepts, modeling, design, and creation.
• Proficiency in creating database schemas and objects pursuant to industry standards and best practices.
• Ability to create, clone, plug, and unplug pluggable databases in a multitenant environment.
• Experience with programming languages such as SQL, PL/SQL, Shell Scripts, and Batch Scripts.
• Proven troubleshooting and problem-solving skills for critical database, application, network, and system administration issues.
• Ability to work efficiently under pressure and with a high degree of independence.
• Critical thinking skills and sound decision-making abilities.
• Strong knowledge of Oracle Database best practices, concepts, and technologies.
• Versatility, flexibility, and proactiveness in resolving technical issues.
• Graduate-level comprehension of the Open Systems Interconnection (OSI) model.
• Ability to demonstrate relational database constructs leveraging primary and foreign keys, check constraints, and creation of objects via command line.

Preferred Knowledge, Skills, And Abilities

• Positive experience in database administration with at least 7 years in a junior to mid-level position.
• Experience installing, configuring, and troubleshooting Oracle 19c software.
• Exposure to other RDBMS systems such as MSSQL and PostgreSQL is a plus.
• Bachelor’s degree in a related field, such as Computer Science, Data Processing, Information Systems, or equivalent experience.
• Experience with features such as Automatic Storage Management and Data Guard.
• Efficiency in developing PL/SQL code and genuine relational database management.

Benefits

• 401K with company match
• Comprehensive health and wellness packages
• Internal mobility team dedicated to career development
• Professional growth opportunities, including paid education and certifications
• Paid vacation and holidays

The likely salary range for this position is $114,750 - $155,250. Salary will be set based on experience, geographic location, and contractual requirements and could fall outside of this range.

Scheduled Weekly Hours: 40
Travel Required: None
Telecommuting Options: Onsite
Work Location: USA NM Albuquerque