Apply now »

Sr. Consultant - Azure SQL DBA Job

Date:  Feb 3, 2023
Job Requisition Id:  51461
Job Category:  IT Infrastructure
Location: 

Pune, MH, IN

We are looking forward to hire “ Azure SQL DBA professionals for the Infrastructure team, who thrives on challenges and desire to make a real difference in the business world. With an environment of extraordinary innovation and unprecedented growth, this is an exciting opportunity for a self-starter who enjoys working in a fast-paced, quality-oriented, and team environment.

 

You are required to have skills in the following areas :

 

  • Experience in SQL Server Database Administration and support in Non-Production and Production environments within VMware and Hyper-V virtualization platform
  • Experienced in SQL Server Features like Replication, Always on, and Log Shipping.
  • Experienced in installation, configuration, and maintenance of SQL Server Standalone and FCI solutions, applying SQL patches and cumulative updates (CU).
  • Experience in implementing SQL Standards, and best practices and performing code reviews.
  • Experience in working with SSIS and reviewing the packages.
  • Experience in performing SQL Full/Diff/Transaction Log backups and recovery plans.
  • Experience in refreshing the databases from one environment to another environment.
  • Experience in providing access to SQL Databases using custom-defined roles.
  • Experience in working with SQL Maintenance jobs tasks like index management, and statistics
  • Extensive hands-on experience in automating several tasks in SQL Server using PowerShell, SQL/T-SQL and SQLCMD - automation of SQL DBA tasks (monitoring and alerting, health checks etc.), backup/recovery, and maintenance.

 

Responsibilities:

  • Participate in an on-call rotation for support of systems outside of normal business hours.
  • Set up High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
  • Work on issues related to performance tuning and Optimization (PTO), using native. monitoring and troubleshooting tools.
  • Migration, upgradation, Performance tuning
  • Implementing SQL encryption - TDE and Database backup.
  • 24/7 production support environment
  • Handling and maintaining PII, GDPR, and SOX systems and databases
  • Azure SQL PaaS -elastic pools, security, moving data between on-premises and cloud, copy database from production to non-production and other database administration tasks
  • End-to-end disaster-recovery (DR) planning and recovering SQL Servers as part of regular DR rehearsals.

Apply now »