Functional Database Manager

$145,000 - $175,000/Yr

Savantage Solutions - Rockville, MD

Full-time - Senior

Rockville, MD

Professional, Scientific, and Technical Services

About the position

Savantage Solutions is seeking a Functional Database Manager to join our technical team. This position will lead a team of system operators, help desk personnel, application administrators, and DBAs in providing monitoring and production support of a mission-critical government IT system.

Responsibilities

• Act as manager and technical lead of a team performing 24x7 production database administration, support, and monitoring of a Federal Oracle and Teradata multi-platform database installation to ensure a stable, proactive environment
• Monitor and mitigate security vulnerabilities. Implement security measures to meet/maintain STIG requirements and best practices.
• Execution of an end-to-end technical refresh consisting of stand-up of an Oracle 19 RAC database installation on RedHat Enterprise Linux (RHEL) 8 and migration of the existing 12.2 RAC database environment to the new hardware/database.
• Lead technical refreshes of Teradata hardware. Provide technical input, installation of the COTS and Government product baselines on the equipment, lead data migration and testing.
• Write/implement shell scripts to monitor Oracle RAC availability, space utilization, (Oracle, Teradata), alert logs, and trace files on Red Hat Enterprise Linux.
• Monitor and maintain database incidents using Oracle tools (ADDM, ADRCI, TFA, etc.) and custom scripts.
• Schedule and perform maintenance/patching for all database, grid, and client instances.
• Monitor and maintain database-related cron jobs to create and maintain a stable, clutter-free environment and file system.
• Maintain and configure user accounts to include proper grants of profiles, roles, and privileges.
• Implement database architecture/schema changes as required by software development and sustainment requirements.
• Monitor, test, and tune disaster recovery and backup processes (e.g. RMAN) as needed.
• Plan, test, and document Oracle client installations and upgrades for implementation in Citrix and virtual desktop environments.
• Monitor and tune database server memory as needed.

Requirements

• Eligibility for Secret Clearance
• 8+ years of related work experience
• Significant Experience and familiarity with multiple items listed below:
• Oracle DB including RAC, Teradata DB
• SQL, PL/SQL
• At least 5 years of experience managing a medium to large Oracle RAC installation in a production environment
• Red Hat Enterprise Linux
• Apache Tomcat and comparable Linux-based Web Server experience is a plus

Nice-to-haves

• BA/BS degree
• One IGC CEC Residential certification such as:

Benefits

• $145k - $175k (based on the National Capital Region)