Azure SQL Database Administrator - Hyderabad, India - YASH Technologies

    YASH Technologies background
    Technology / Internet
    Description

    Locations:: Indore, Pune, Hyderabad & Bangalore

    Shift: 24/7

    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