Senior Database Administrator

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Conduct daily monitoring and administration of Microsoft SQL Server environments.

• Oversee database availability, performance, capacity, storage usage, job execution, and system alerts.

• Perform scheduled maintenance, integrity checks, indexing, statistics updates, and other authorized database maintenance tasks.

• Plan and execute approved database patches and updates, including pre-change assessments, validation, and rollback preparations.

• Manage database accounts, roles, permissions, and service access.

• Review access configurations and assist with periodic access validation efforts.

• Execute and monitor database backups, troubleshoot failures, and maintain backup documentation.

• Carry out database restores and recovery testing.

• Aid in outage restoration and database recovery in collaboration with architecture, infrastructure, application, and operations teams.

• Diagnose database connectivity issues, job failures, blocking, resource contention, integrity problems, and performance slowdowns.

• Optimize queries, indexes, configurations, and maintenance activities.

• Support database and warehouse operations, scheduled data loads, data refreshes, and integration dependencies.

• Implement approved schema modifications, database objects, and configuration updates.

• Coordinate changes with application, data engineering, analytics, and testing teams.

• Verify database health and dependent services after maintenance, patches, schema modifications, or restoration processes.

• Assist with database security monitoring and resolution of assigned findings.

• Maintain operational logs, incident records, change documentation, configuration records, and maintenance protocols.

• Update backup, recovery, troubleshooting, and administration runbooks.

• Escalate complex architectural, availability, security, or performance challenges.

• Facilitate operational handoffs, knowledge transfer, and ongoing enhancement of database administration practices.

⛳️ Requirements

• Active Secret clearance or higher.

• At least eight years of relevant professional experience.

• Bachelor’s degree in computer science, information technology, information systems, or a related field, or an equivalent qualification.

• Proficient in Microsoft SQL Server administration.

• Experience with database patching procedures.

• Skilled in administering database access controls.

• Expertise in database performance tuning.

• Experience in performing database backup and recovery operations.

• Capability to conduct daily database monitoring, maintenance, and troubleshooting.

• Ability to support warehouse operations, approved schema changes, and database documentation tasks.

• CompTIA Security+ CE or another recognized IAT Level II certification.

🏝️ Benefits

• Flexible remote work arrangement.

• Opportunity to contribute to mission applications, data analysis, AI-related data initiatives, and data warehouse operations.

• Collaboration with database architects, data engineers, application teams, infrastructure staff, cybersecurity experts, and government stakeholders.

• Opportunities for knowledge transfer and continuous improvement.