Mid-Level SQL DBA
AET FEDERAL INC
•$100,000 - $125,000•Remote
About The Position
AET Federal is seeking a Mid-Level SQL DBA to join a four-person team supporting a federal agency's server-based applications, which run on SQL Server and Oracle databases across every business unit. The team has a Senior and a Mid-Level DBA for SQL Server and the same pair for Oracle. The Mid-Level SQL DBA handles day-to-day SQL Server and SQL Cluster operations. That covers ServiceNow tickets, change requests, Idera and SolarWinds monitoring, and support for MySQL, MariaDB and PostgreSQL. The role reports to the Senior SQL DBA (Team Lead) and backs up that position.
Requirements
- 4+ years of hands-on database administration, with SQL Server as the primary platform
- Experience with SQL, SQL Server and SQL Clustering (Windows Server Failover Clustering and/or Always On availability groups)
- Strong SQL scripting (T-SQL) and automation skills, such as PowerShell or SQL Agent jobs
- Working experience with PostgreSQL, MySQL and MariaDB
- Experience troubleshooting MS Access databases
- Proven ability to create and manage standalone SQL Server databases
- Demonstrated experience with triage, server maintenance, software installation and patching, maintaining high-availability systems, and executing disaster recovery
- Experience working tickets and change requests in ServiceNow or a comparable ITSM tool
- Ability to work independently, collaborate across teams, and communicate clearly with staff and management at all levels
- Willing and able to pass a federal background investigation
- Able to work 8 hours per day within 7:30 AM–6:00 PM ET, with occasional scheduled after-hours work
- Willing to sign a letter of commitment for this proposal
Responsibilities
- Run daily health checks on SQL Server instances and SQL Clusters: backups, failed jobs, cluster and availability group state, errors
- Troubleshoot, set up, triage errors and configure SQL Server and SQL Cluster environments
- Manage ServiceNow requests from submission to closeout
- Use Idera and SolarWinds for proactive health monitoring and capacity planning, and tune alerts and dashboards
- Carry out assigned Requests for Change (RFCs), with implementation, validation and backout steps
- Apply SQL Server cumulative and security updates; plan and lead patch cycles in scheduled after-hours windows
- Perform routine maintenance: index and statistics upkeep, integrity checks (DBCC CHECKDB), log and storage management
- Resolve ServiceNow tickets within the customer's operational SLAs
- Help users build and configure standalone SQL Server databases
- Troubleshoot SQL Server and MS Access issues and application integrations, such as SharePoint, ODBC connections, linked servers and connection strings
- Support MySQL, MariaDB and PostgreSQL databases
- Review and tune T-SQL queries, stored procedures and indexes
- Implement and test failovers for SQL Server failover clusters and Always On availability groups
- Verify backups and perform restore and point-in-time recovery tests
- Execute DR runbooks under the direction of the Senior SQL DBA
- Contribute to the weekly support activity report delivered to the customer's COR
- Stay available on Microsoft Teams during core hours
- Cover for the Senior SQL DBA as needed
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
