Senior Application SQL DBA

MAGNUS MANAGEMENT GROUP, LLC
Washington, DC, United States
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Configuration Management Databases Data Validation Data Migration Database Design Database Schema Database Security Disaster Recovery Microsoft SQL Server Operational Databases Performance Tuning
+10 more
Release Management Server Administration Software Deployment SQL Stored Procedures SQL Databases Transact-SQL Sql Server Database Administration Reliability of Systems Database Performance Database Backup

Job description

Serve as the lead SQL Server Database Administrator supporting production, test, and development environments. Maintain database integrity, availability, performance, and security across mission-critical applications. Perform routine database administration activities, including backups, recovery, monitoring, maintenance, and performance tuning. Design, develop, test, and implement database changes, scripts, stored procedures, views, and database objects. Support Production and User Acceptance Testing (UAT) database deployments and releases. Monitor and maintain SQL Server jobs, scheduled tasks, and database automation processes. Perform data corrections, data validation, database refreshes, and monthly database snapshot activities. Support data migration, database modernization, and transition activities associated with future case management initiatives. Troubleshoot database performance issues and implement corrective actions to improve system reliability and efficiency. Coordinate with developers, systems administrators, testers, and Government stakeholders to support application enhancements and operational requirements. Ensure compliance with Federal security, privacy, configuration management, and database management standards. Maintain technical documentation, database diagrams, deployment procedures, and operational support documentation.

Requirements

We are seeking a Senior Application SQL DBA with 10+ years of SQL Server Database Administration experience to support mission-critical applications. The ideal candidate will possess 7+ years of strong SQL Server administration expertise and experience supporting production databases, application deployments, database performance optimization, security management, backup and recovery operations, and database modernization initiatives., 7+ years of SQL Server Database Administration experience. Strong experience with Microsoft SQL Server, Transact-SQL (T-SQL), stored procedures, views, triggers, and database design. Experience supporting production database environments and mission-critical applications. Experience performing database backup, recovery, disaster recovery planning, and database security administration. Experience with database performance monitoring, optimization, and troubleshooting. Experience supporting database deployments, upgrades, and release management activities. Experience writing and executing SQL scripts for data analysis, data correction, and data migration activities. Strong analytical, troubleshooting, and problem-solving skills. Experience working directly with technical teams, business stakeholders, and Government customers.

Benefits & conditions

401(k) Dental insurance Health insurance Paid time off Vision insurance

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.wayup.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer · LIVE

1:36 min

Performing exploratory data analysis to uncover underlying patterns

Julian Joseph · LIVE

Videos

See all

Related articles

See all