Position Overview & Specifications
Our client, a leader in electric utilities, has an excellent opportunity for a SQL Server DBA to work on a 12-month contract-to-hire opportunity. Work will be a hybrid on-site/remote schedule in Washington, DC. The SQL Server DBA will design the database server architecture, to include installation, maintenance, and configuration. Perform troubleshooting and resolution management. Provide support for advanced user jobs and analytics.
This position is a contract opportunity, offering a comprehensive benefits package that includes medical, dental, vision, disability, and life insurance, plus 401(k), and weekly payment.
Responsibilities of the SQL Server DBA:Install, configure, and manage SQL Server instances (2019/2017/2016/2014/2012) in both prod/dev/test environments.Deploy and manage SQL Server on various platforms, including VMWare, Azure (IaaS/PaaS), and on-premises.Build and manage Azure managed instances and Azure managed databases.Facilitate database migration from on-premises environments to Azure.Execute SQL database upgrades, migrations, backups, and restores.Administer user access by provisioning SQL logins and users based on project requirements.Configure and troubleshoot database Always-on availability groups (AG) and AG-related issues.Establish AG listeners and add databases to Always On while handling failover scenarios.Implement and troubleshoot database mirroring solutions.Configure and troubleshoot database log shipping setups.Set up and troubleshoot database transaction replication configurations.Manage SQL clusters and resolve cluster-related issues.Monitor database conditions, proactively rebuild indexes, and perform routine maintenance tasks.Utilize monitoring and performance tuning skills to schedule automated activities, including database health checks, disk space monitoring, job alerts, index monitoring, and statistics tracking.Configure database mail for SQL job alerts.Install and configure SQL Server Reporting Services (SSRS), including report deployment and server security management.Apply Service Packs to SQL Server versions (2008R2, 2012, 2016, 2017, 2019) and patches to Windows Server versions (2003, 2003 R2, 2012, 2019).Create and manage incident/changes using the Service Now ticketing system.Provide exceptional on-demand customer service.Collaborate with application teams to troubleshoot application issues from a database perspective.Demonstrate expertise in Transparent Data Encryption (TDE).Implement SQL Server Security Technical Implementation Guides (STIG) compliance.
***Due to Gov't requirements, must be a US Citizen or Green Card holder for at least 3 years. Must be able to acquire Public Trust Clearance.***
Requirements of the SQL Server DBA:SQL ClusterAlways-On ClusterDistributed Always-On ClusterSQL ReplicationOn-premises to Azure MigrationAzure Managed InstanceSQL STIG (Security Technical Implementation Guides)TDE (Transparent Data Encryption)
Preferred Skills:Bachelor's degree or equivalent combination of education and experience.SQL Certified DP-300 Certification (a plus)
Job ID: 384195
This position is a contract opportunity, offering a comprehensive benefits package that includes medical, dental, vision, disability, and life insurance, plus 401(k), and weekly payment.
Responsibilities of the SQL Server DBA:Install, configure, and manage SQL Server instances (2019/2017/2016/2014/2012) in both prod/dev/test environments.Deploy and manage SQL Server on various platforms, including VMWare, Azure (IaaS/PaaS), and on-premises.Build and manage Azure managed instances and Azure managed databases.Facilitate database migration from on-premises environments to Azure.Execute SQL database upgrades, migrations, backups, and restores.Administer user access by provisioning SQL logins and users based on project requirements.Configure and troubleshoot database Always-on availability groups (AG) and AG-related issues.Establish AG listeners and add databases to Always On while handling failover scenarios.Implement and troubleshoot database mirroring solutions.Configure and troubleshoot database log shipping setups.Set up and troubleshoot database transaction replication configurations.Manage SQL clusters and resolve cluster-related issues.Monitor database conditions, proactively rebuild indexes, and perform routine maintenance tasks.Utilize monitoring and performance tuning skills to schedule automated activities, including database health checks, disk space monitoring, job alerts, index monitoring, and statistics tracking.Configure database mail for SQL job alerts.Install and configure SQL Server Reporting Services (SSRS), including report deployment and server security management.Apply Service Packs to SQL Server versions (2008R2, 2012, 2016, 2017, 2019) and patches to Windows Server versions (2003, 2003 R2, 2012, 2019).Create and manage incident/changes using the Service Now ticketing system.Provide exceptional on-demand customer service.Collaborate with application teams to troubleshoot application issues from a database perspective.Demonstrate expertise in Transparent Data Encryption (TDE).Implement SQL Server Security Technical Implementation Guides (STIG) compliance.
***Due to Gov't requirements, must be a US Citizen or Green Card holder for at least 3 years. Must be able to acquire Public Trust Clearance.***
Requirements of the SQL Server DBA:SQL ClusterAlways-On ClusterDistributed Always-On ClusterSQL ReplicationOn-premises to Azure MigrationAzure Managed InstanceSQL STIG (Security Technical Implementation Guides)TDE (Transparent Data Encryption)
Preferred Skills:Bachelor's degree or equivalent combination of education and experience.SQL Certified DP-300 Certification (a plus)
Job ID: 384195