Database Administrator

DRT Strategies; Silver Spring (MD); On-site; USD 90,000 - 130,000; Full time

Job summary

DRT Strategies supports FDA.gov web infrastructure with a dedicated Database Administrator for the Drupal-based CMS. The role focuses on independent database operations, connectivity, security, backups, data integrity, updates, and reporting for MySQL, Oracle, and SQL Server.

You will maintain high availability and performance, implement HA/DR solutions, and conduct regular backups and testing to ensure quick recovery in case of system failures, while aligning with FDA's public-facing web goals

Qualifications

• This position requires an experienced Database Administrator capable of working independently to assist with database operations, user connectivity to the database, database security, backup and recovery, data integrity, database updates, and database reporting.

Responsibilities

• Administer, maintain, and monitor database systems supporting the website, ensuring high availability, performance, and reliability. Database platforms within the project ecosystem include MySQL, Oracle, and SQL Server.
• Assist with database operations, user connectivity, database security, backup and recovery, data integrity, database updates, and database reporting
• Perform all aspects of database system administration, including installation of instances, tuning of instances and queries, space management, and database installation, configuration, and tuning to support optimal website performance and scalability
• Set up and maintain High-Availability (RAC) and Disaster Recovery (RMAN) solutions to ensure continuity of website operations and minimize downtime
• Determine and implement best practices for database setup, monitoring, backup and recovery, installation, tuning, and auditing
• Manage database backups and conduct regular recovery testing to ensure data can be restored quickly in the event of system failure

Job description

Overview

DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, state and local government and commercial clients in health care, technology, and financial services industries.

The three letters of our name, DRT, stand for Driving Resolution Together, which is the core philosophy on which the company was founded. That is, we collaborate with our clients to solve their most pressing challenges - together.

We are problem solvers dedicated to your success, combining Fortune 500 experience with small business responsiveness. We have established a reputation with our clients as a forward-thinking consulting firm with demonstrated success in implementing solutions that lead to meaningful results. Our world-class consultants unite people to work collaboratively to achieve project goals and make vision a reality.

Project Description

FDA.gov website experiences more than 670 million hits, 43.34 TB of data transferred, and 17.4 million visitors per month, making it the "front door" to the FDA for a substantial portion of the public. The site is a key component of FDA's mission to communicate effectively with healthcare professionals and the public, supporting the agency's Transparency and Open Government efforts and providing the public with numerous opportunities to interact directly with FDA.

This project supports the Food and Drug Administration (FDA) in translating business needs into technology solutions across FDA's public-facing web environment, providing administration, infrastructure support, and strategic planning for FDA's Web presence.

Support for FDA's web infrastructure, including its Content Management System (CMS), is intended to enhance the agency's ability to manage web content effectively. The current CMS, built on Drupal, supports FDA's public-facing site, which spans more than 65,000 documents and pages and is maintained by more than 600 active site contributors.

Job Summary

This position requires an experienced Database Administrator capable of working independently to assist with database operations, user connectivity to the database, database security, backup and recovery, data integrity, database updates, and database reporting.

Responsibilities

• Administer, maintain, and monitor database systems supporting the website, ensuring high availability, performance, and reliability. Database platforms within the project ecosystem include MySQL, Oracle, and SQL Server.
• Assist with database operations, user connectivity, database security, backup and recovery, data integrity, database updates, and database reporting
• Perform all aspects of database system administration, including installation of instances, tuning of instances and queries, space management, and database installation, configuration, and tuning to support optimal website performance and scalability
• Set up and maintain High-Availability (RAC) and Disaster Recovery (RMAN) solutions to ensure continuity of website operations and minimize downtime
• Determine and implement best practices for database setup, monitoring, backup and recovery, installation, tuning, and auditing
• Manage database backups and conduct regular recovery testing to ensure data can be restored quickly in the event of system failure