SQL Server DBA (Washington D.C only)


Cyma Systems Inc
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- SQL Server DBA
- Azure SQL
- SQL MI
- AWS SQL and MySQL databases.
Summary
Location: Washington D.C 20433 (Onsite) - Locals only
Duration: Long-term Contract
Position Overview
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.
Key Functions
- 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.
Required Skills/Abilities
- 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
- Dice Id: RTL327349
- Position Id: 9147238
- Posted 3 hours ago
Company Info
Cyma Systems is a technology solutions firm based in Connecticut serving mid-sized and Fortune 1000 businesses. We work with a range of corporate commercial clients as well as with the government sector. As a full-service consulting firm, we engage with our clients to share ideas on how we can help their businesses to become more profitable, to get a jump start on competitors by bringing products to market quickly, reducing costs, maximizing the use of existing technologies, driving more sales through the channel, and to bring additional value by forming a mutually beneficial partnership.
We think that the essence of a successful business is its ability to adapt and transform keeping ground realities in sight. At Cyma we work on leveraging the right synergies between technology and people that work towards transforming the outlook and results of your business.


