SQL Server Database Administrator (DBA)

Job Description

Job Description

Description :

As a SQL Server Database Administrator, you will be responsible for managing and optimizing on-premises SQL databases that support web applications. Your role will ensure high performance, availability, security, and sustainability of database systems through proactive maintenance and strategic planning.

Key Responsibilities :

• Database Management & Maintenance
• Configure, install, upgrade, and maintain Microsoft SQL Server databases in a production environment.
• Monitor database performance and conduct tuning procedures to ensure optimal operation.
• Create and manage scheduled jobs, data extracts, refreshes, loads, and replication processes.
• Performance, Availability & Security
• Ensure high levels of database performance, availability, and data integrity.
• Implement and manage high availability solutions such as Always On and SQL clustering.
• Apply Transparent Data Encryption (TDE) and manage encrypted database backups and restores.
• Replication & Automation
• Develop and implement merge and transactional replication strategies.
• Automate routine database tasks to improve efficiency and reduce manual intervention.
• Troubleshooting & Optimization
• Diagnose and resolve issues related to performance, blocking / deadlocks, replication, connectivity, and security.
• Perform data modeling, query optimization, and analysis of customer-provided data.
• Reporting & Analysis
• Write SQL queries and reports using existing data.
• Create and update records based on business requirements.
• Governance & Documentation
• Develop and enforce database policies and procedures to maintain system integrity and compliance.
• Maintain documentation for database configurations, processes, and troubleshooting steps.

Requirements : Technical Expertise