Database Administrator, Mid

The Database Administrator, Mid oversees the stability, performance, and security of enterprise databases that support mission-critical systems in a highly regulated government environment. The role designs and refines database structures, indexing strategies, and capacity plans to deliver scalable, high-performing data services across multiple business applications. It leads complex maintenance activities such as patching, upgrades, environment migrations, and recovery exercises while minimizing downtime and coordinating closely with development, infrastructure, and cybersecurity teams.

Key Responsibilities

• Administer and optimize production and non-production instances of platforms such as Oracle, SQL Server, MySQL, or PostgreSQL, including advanced schema design, partitioning strategies, and environment-specific configuration.
• Design and tune indexing, statistics, and query execution plans to resolve complex performance bottlenecks and ensure predictable response times for high-volume transactional and reporting workloads.
• Develop and execute robust backup, restore, and disaster recovery strategies (including full, differential, and transaction log approaches) and lead periodic recovery tests for mission-critical systems.
• Implement and review advanced security controls such as encryption at rest and in transit, role-based access models, privileged account management, and auditing to protect sensitive data in highly regulated environments.
• Lead planning and execution of database software upgrades, patching cycles, and cross-environment migrations, coordinating with application owners and operations teams to manage risk and downtime.
• Design and support data integration solutions using ETL tools and scripts to move, transform, and reconcile data across operational databases, data warehouses, and analytics platforms.
• Perform capacity planning and storage management, including growth forecasting, index maintenance strategies, and archival approaches to balance performance and cost.
• Troubleshoot complex incidents involving locking, deadlocks, blocking chains, failed jobs, and resource contention, using diagnostic tools and system views to quickly isolate root cause.

Required Qualifications

• Bachelor's degree (BA/BS) in Computer Science, Information Technology, or a related field, or equivalent relevant work experience.
• 4-7 years of progressive database administration experience with increasing ownership of production environments.
• Proficiency with relational database systems such as Oracle, SQL Server, MySQL, or PostgreSQL, including strong understanding of database structures, principles, and best practices.
• Demonstrated experience with database security, backup and recovery, disaster recovery planning, data warehousing, ETL processes, and data integration tools.
• Strong analytical, problem-solving, communication, and teamwork skills supporting cross-functional collaboration in enterprise environments.
• Active SECRET security clearance or ability to obtain and maintain clearance as required by the client.
• U.S. citizenship and willingness to travel less than 10% of the time.

Preferred Qualifications

• Experience with high-availability and resilience patterns such as clustering, always-on groups, replication, or other failover technologies in enterprise environments.
• Hands-on experience supporting data warehousing and business intelligence workloads, including star schema design and ETL performance tuning.
• Professional certifications such as Oracle Certified Professional or Microsoft Certified: Azure Database Administrator Associate.
• Prior experience supporting databases in highly regulated or federal IT environments with formal change, security, and compliance frameworks.

Compensation

Ranges Compensation ranges for ASM Research positions vary depending on multiple factors; including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees. EEO Requirements It is the policy of ASM that an individual's race, color, religion, sex, disability, age, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies. All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, disability, or age. All decisions on employment are made to abide by the principle of equal employment. Physical Requirements The physical requirements described in "Knowledge, Skills and Abilities" above are representative of those which must be met by an employee to successfully perform the primary functions of this job. (For example, "light office duties' or "lifting up to 50 pounds" or "some travel" required.) Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions. Disclaimer The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.