Senior SQL DBA Azure - Infrastructure Role

Senior SQL DBA Azure - Infrastructure Role

2COMS Consulting Private Limited
Chennai
12 - 18 Years
1900000 - 3000000 INR

Job Description


Roles and Responsibilities

  • Design, develop, and implement SQL database instances for the development and production environments in AZURE Cloud
  • Monitor and maintain database security and database software
  • Daily maintenance, monitoring, problem resolution and internal customer for production and dev support
  • On-call (24X7) for production databases
  • Test, validate and implement performance and resource optimization improvements in consultation with AZURE development Teams
  • Database Performance Healthchecking

  • Working knowledge of network, hardware, and application virtualization
  • Troubleshooting SQL Server including performance issue
  • Working on international projects in multicultural teams
  • Manage users permissions
  • Detailed knowledge of Microsoft SQL Server technology and how to Administer, create, upgrade, maintain, STIG, and customize manually and using SQL Queries
  • Ensure all database servers are backed up in a way that meets the businesss Recovery Point Objectives (RPO)

  • Test backups to ensure we can meet the business Recovery Time Objectives (RTO)
  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
  • Configure SQL Server monitoring utilities to minimize false alarms
  • As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
  • Install and configure new SQL Servers

  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Document the companys database environment
  • Backup and recovery tools of AZURE & traditional backup & recovery tools
  • Root cause analysis of production-related database issues

Desired Candidate Profile
12+yrs of experience in total
  • Strong Knowledge on ITIL based service delivery
  • ITIL certification is desired
  • Knowledge on quality
  • Knowledge on security processes

Renowned IT / ITES /BPO

Similar Jobs

People Also Considered

Career Advice to Find Better