Consultant - Azure SQL

  • Pune
  • Yash Technologies

Experience: 5-7 years

Location: Pune, Bangalore, Hyderabad and Indore

Notice Period: Immediate / 15 days / 30 days


Primary Skills:

Satisfactory knowledge of Cloud Computing (Azure or AWS)

SQL Server provisioning, Patching, Backup and troubleshooting.

Prepare and upload SOPS \ KB articles for SQL Servers, Azure SQL

Coach team members on newer azure features \ services

Has a good knowledge on assisting Senior management on SOWs \ RFPs \ Critical email communications

All versions of SQL Server standalone and Cluster environment database handling

Configuring and managing backup through native backup methods or popular third part backup tools

Cloning the databases based on the requirement

Listener creation, ODBC connectivity creations

Performance handling and automation of administrative tasks

SQL instance/database Upgradations

Experience on major ticketing tools

Exposure in automatic storage management

Experience in all database activities like HA,DR creation and maintenance

Establish the clustering environment and handling the cluster related issues

Experience on Log-Shipping, DB Mirroring, Always ON and Replications

Experience TDE, TLS creation

Troubleshooting all issues related to SQL Server

Patch upgradation for SQL Server instance

Handling the clients will be more additional asset


Certifications Required (any two Preferable)

SQL Server certification


Roles and Responsibilities

  • A successful candidate for this position will be able to demonstrate good knowledge of SQ Servers, SQL PaaS and troubleshooting skills.
  • Understand and document technical requirements from clients
  • Understand the SQL Cluster and DR strategies and participate in DR drills
  • Understand Security Guidelines and implement the best practices to improve the security of MS SQL
  • Set up process, services, and tools around cloud
  • Validate the environment to meets all security and compliance controls
  • Assist the team to develop offerings including proven architectures, proofs of concept, and best practices and procedures for deliver
  • Create SOPs, KB articles