Description

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.


 

Education

Any Graduate