SQL Server DBA (Washington D.C only)

Cyma Systems Inc
Washington, DC, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology Amazon Web Services Microsoft Azure Cloud Computing Cloud Database Cloud Engineering Cluster Analysis Databases Data Migration Database Security Disaster Recovery Microsoft SQL Server
+13 more
SQL Azure Windows Servers MySQL Cloud Services Azure DevOps Pipelines Shell Script SQL Databases Backup and Restore Delivery Pipeline Kubernetes Performance Monitor Terraform Docker

Job description

This service request is for on premise SQLServer, MySQL, and Azure, AWS cloud databases to perform physical infrastructure administration activities for our database team within the ITSPL unit of ITS VPU. The candidate will be responsible for a variety of tasks including the installation, configuration, patching, and maintenance of on-premises and cloud database resources. This includes managing MSFT clustering, HA, DR, Mirroring and resiliency technologies administration and maintenance. Moreover, the DBA will handle SQLserver, MySQL database performance management, assisting the development team and logical DBAs in identifying and resolving performance issues. They will also provide backup and restore functionality, implement database failover technologies, and ensure compliance with WBG database security standards for the database environment., * Install, configure, and maintain MS SQL Server on Windows server

  • Manage and maintain MS SQLServer with available clustering technologies to support HA and disaster recovery readiness.
  • Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments.
  • Provide backup and restore functions for MS SQL Server databases.
  • Execute upgrade activities with minimal downtime with optimal performance to upgraded systems.
  • Manage and Support Cloud native databases including Azure SQL, SQL MI, AWS SQL and MySQL databases.
  • Integrate cloud services with on-premises systems and other cloud services.
  • Assist developers and logical DBAs in detecting performance problems including analysis of SQL, client tools and drivers.
  • Tune database parameters for optimal system performance.
  • Ensure proper setting of system parameters for optimal database operation in collaboration with system administrators.
  • Follow ITIL processes for incident management, change management and problem management.
  • Develop and maintain Azure DevOps CI/CD pipelines for DB infrastructure deployment and follow-up.
  • Collaborate with cross functional teams ensure efficient service deliverables to WBG clients.
  • Closely follow and implement security controls and processes that follow WBG on premise and cloud database security standards.

Requirements

  • Extensive experience in SQL Server infrastructure operation, administration including cluster management.
  • Strong production experience in MSFT Clustering, HA, DR, Mirroring and other resiliency technologies.
  • Strong production experience in backup, recovery and data refresh management activities.
  • Proven operational support capabilities and expertise in SQL Server upgrade activities.
  • Extensive experience with Azure SQL, SQL MI, MySQL, AWS SQL provisioning and administration.
  • Relevant experience with data migration into cloud DBs.
  • Relevant experience with backup and recovery services in Azure and AWS.
  • Familiarity with cloud services integration.
  • Familiarity with Infrastructure as Code (IaC) development using Terraform or ARM template.
  • Experience with AWS, Azure cloud native databases and services.
  • Experience with Azure DevOps, and shell scripting for processes automation.
  • Relevant experience in use of ITIL processes.
  • Relevant experience for Sarbanes-Oxley (SOX/ICFR compliance of critical financial systems.
  • Excellent problem-solving skills and the ability to work in a fast-paced, dynamic environment
  • Experience in Terraform Cloud (TFC) modules development for cloud resources provisioning and implementation a big plus.
  • MS SQL Server/Azure /AWS DBA certification is a big plus

Desired Skills/Abilities

  • Experience with Kubernetes, Docker, and containers for database deployments is a plus.
  • Experience in Agile methodologies and SRE practice is a plus.
  • Good Technical Documenting Skills is a plus

Apply for this position

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

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…