SQL Database Admin

Description :Tasks :- Install, configure, and maintain SQL Server instances. Our architecture uses AG and DAG architectures.- Ensure high levels of performance, availability, sustainability, and security.- Analyse, solve, and correct issues in real-time.- Refine and automate regular processes, track issues, and document changes.- Assist developers with complex query tuning and schema refinement.- Maintain and configure Transaction Replication- Provide 24x7 support for critical production systems.- Perform scheduled maintenance and support release deployment activities after hours.- Implement and maintain database security (create and maintain users and roles, assign privileges).- Perform database tuning and performance monitoring.- Plan and implement backup and recovery strategies with Cohesity- Develop and maintain documentation for database configurations, procedures, and processes.- Collaborate with other team members and stakeholders.- 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 of system health and performance, to ensure high levels of performance, availability, and security.- Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.- Use Nutanix NDB to configure lower environments- Requirements:- 1-2 years of experience as a SQL Server DBA or similar role.- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.- Experience with backups, restores, and recovery models.- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.- Experience with Windows server, including Active Directory.- Excellent written and verbal communication.- Flexible, team player, 'get-it-done' personality.- Ability to organize and plan work independently.- Ability to work in a rapidly changing environment.- Ability to multi-task and context-switch effectively between different activities and teams.- MCSA, MCSE, or other related certifications are a plus.- Experience with Azure cloud services is a plus.- Knowledge of Oracle database administration is a plus.- Experience with automation tools and scripting languages (PowerShell, Python) is a plus.- Key Responsibilities:- Health Monitoring: Continuous surveillance of database performance, checking for server availability, connectivity, and critical hardware metrics like CPU, memory, and disk space.- Backup & Recovery Operations: Executing and verifying daily full, differential, and transaction log backups. Respond immediately to failed backup jobs by following standard operating procedures (SOPs).- Incident Management: Responding to system alerts and notifications. Resolve minor issues (e.g., failed scheduled jobs) and escalate complex or high-priority incidents (P1/P2) to L2 or L3 teams.- Access Control: Managing user permissions, including creating logins, resetting passwords, and assigning roles based on established security policies.- Routine Maintenance: Performing basic database "housekeeping" such as index defragmentation and statistics updates as part of regular maintenance plans.- Documentation: Recording all configuration changes, incident resolutions, and updates to internal knowledge bases. (ref:hirist.tech)