Senior SQL Database Administrator

Job Description:

Pay Range $45hr - $52hr

• Ensure the availability and optimization of the MSSQL 2016, 2017, 2019, 2022 in Hosted and IaaS SQL VM in Azure.
• Experience with Azure SQL Database and Managed.
• Instance databases in Azure.
• Make sure to follow technical standards and operational procedures to meet database performance, High Availability, replication, scalability, and security requirements in both hosted and cloud environments.
• The individual will need hands-on experience in design and troubleshooting real-time MSSQL related issues.
• Monitor performance on application databases, queries and suggest/apply continuous tuning.
• The responsibilities include working closely with application teams and other Stakeholders in identifying issues related to MSSQL.
• Must have experience in tuning database instances.
• Responsible for producing standards to ensure that all application design and code is produced with proper integrity, security, and performance.
• The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
• Has a good technical understanding and provides technical support to application development teams when necessary.
• Assist in resolving priority incidents to quickly eliminate impacts, participate in root-cause analysis, and support subsequent corrective and preventative actions.
• Work closely with Database Team Lead, collaborate with various Application support and engineering teams to optimize database performance and reliability.
• Senior Database Administrators are encouraged and supported to acquire relevant Azure certifications (e.g. DP-300, DP-900, AZ-900 Exam).
• Establish, maintain, and adhere to CRD technical standards, policies, and procedures.

Skill Set:

• MS SQL Database.
• Azure Databases.
• IaaS.
• Database Encryption.
• Database performance.
• Storage procedure.
• DB performance tools used.
• DB performance analysis.
• 3 stories where resources fixed the issues , what the issues and how resources were solved.
• Database is slow : how will candidate fix it or what are the possible reasons.
• Always ON.