Sr. SQL Server Development DBA

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

Azure SQL
SQL Server
TSQL
SQL
indexing

Job Details

Responsibilities:

  • Lead and execute the cloud migration projects from On-prem SQL Server to Azure SQL, ensuring a smooth transition with minimal downtime.
  • Provide expert counsel on database design principles, ensuring the development of scalable, high-performance solutions that align with industry best practices. Offer strategic insights to optimize database structures, enhancing efficiency, and fostering adherence to established best practices.
  • Implement best practices for database security and compliance with data privacy regulations, incorporating access controls, encryption, and auditing mechanisms.
  • Proactively identify and resolve performance bottlenecks, working closely with development teams to optimize query performance, indexing strategies, and resource utilization.
  • Implement and maintain robust monitoring solutions to provide real-time insights into database health, ensuring proactive issue resolution.
  • Conduct regular health checks, capacity planning, and upgrade/migration activities to maintain system reliability and stability.
  • Perform essential database administration tasks, including installation, configuration, monitoring, tuning, backup, recovery, and troubleshooting.
  • Innovate and implement automation solutions for routine tasks, reducing manual efforts and improving operational efficiency.
  • Implement and manage database replication, CDC, Always On, WFC, and high-availability solutions for continuous operation and disaster recovery.
  • Design, implement, and maintain SQL and Azure database solutions aligned with organizational requirements and industry best practices.
  • Collaborate with the teams to troubleshoot and resolve complex database issues efficiently using Azure Insights, Monitoring, DMVs, Query Store, etc.
  • Leverage TSQL, and PowerShell scripting to automate routine tasks, enabling proactive monitoring, maintenance, and issue resolution.

Requirements:

  • 10 years of experience as SQLServer DBA.
  • Experience migrating on-prem SQLServer to Azure SQL.
  • Troubleshooting and Optimizing Performance of Application Queries and DB performance.
  • Demonstrate expert knowledge of SQL, Transact-SQL, DMVs, Stored Procedures, user-defined functions, and Custom Types.

Education:

  • Bachelor's degree in Computer Science/Engineering or related field
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.