Azure SQL Server DBA - Database (Azure) Engineer

Job Description

Azure SQL DBA
Azure Paas and Managed instances and Iaas
Azure administration skills
Terraform
Azure dev ops

Essential Duties and Responsibilities
• Manage Azure and On-Premise SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Assist developers with complex query tuning and schema refinement.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Skills and Qualifications
• Bachelor's degree in engineering and related fields
• 5+ years MS SQL Server Administration experience required
• Experience with Azure Synapse and Data Factory
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience with backups, restores and recovery models
• Experience with High Availability (HA) and Disaster Recovery (DR) options for azure and on-premise SQL Server
• Experience with Failover clustering and SAN replication
• Experience with SQL Server merge, peer to peer, or transactional replication
• Experience with LINQ, Entity Framework, NHibernate, or other ORMs
• Experience with Service Broker
• Experience with Analysis Services, Integration Services, or Reporting Services
• Writing T-SQL from scratch, C# code, or generally building anything from scratch
• Troubleshooting application logic or why numbers don’t add up in a report
• Experience working with Windows server, including Active Directory
• Excellent written and verbal communication
• Flexible, team player, “get-it-done” personality
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams