Caelius Consulting Recruitment for SQL Server DBA at Mohali

Description

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring system health and performance, to ensure high performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Assist developers with complex query tuning and schema refinement.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Responsibilities

• Monitor performance of database systems resources and query throughput
• Optimize SQL Code as necessary
• Monitor and maintain database storage resources
• Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
• SQL Server Installation, Upgrades, Migrations, and Configuration
• Install database software service packs and cumulative updates as necessary
• Maintain database documentation as required
• Maintain and administer database security access
• Perform Ad-hoc database backups and restores
• Troubleshoot and resolve database connectivity issues
• Follow Change Management processes to implement database configuration changes
• Follow Problem Management processes to troubleshoot and resolve recurring issues
• Proactively monitor and respond to MSSQL database Alerts.
• Assist with general system administrator responsibilities:
• SQL Server 2008 to 2016
• Performance tuning
• Index management
• Replication/Availability Groups/ Database Mirroring experience
• On-call requirements to ensure 24 x 7 support of database operations