Administrator - Enterprise Applications - IN

  • Gurugram
  • Unitedlex

Work Experience 3+ years of hands-on experience in providing DBA support for large 24X7 production database environment Technology Skills & Experience Strong knowledge and experience with Microsoft SQL Server 2016 or higher version. Very good understanding of SQL Server Architecture, backups, indexes, jobs, Transaction Logs etc. Hands-on experience in managing database backups, performing recovery/restore etc. Hands-on experience with SQL Server installation, security configuration, applying service packs and patches. Good understanding Microsoft failover clustering services and AlwsaysOn. Strong ability to write/develop SQL scripts for various database management activities and ad-hoc projects Good understanding of SQL Server security architecture. Manage Maintenance Plans Monitoring and Performance Tuning Monitor backups to ensure they are being performed regularly Having exposure to large databases and comfortable in managing 24X7 OLTP database services. Experience of providing DBA support for 24X7 production support for Microsoft SQL Server-based database services. Experience with DBCC commands for routine maintenance activities and writing scripts for database administration. Good understanding of database monitoring tools, responding alerts as well as follow-up actions on alerts Experience with Azure SQL, DevOps and other components of Azure is a plus Experience with any NoSQL product is preferred