We are seeking an experienced Database Administrator with 5+ years of hands-on expertise. The role involves managing and optimizing SQL Server environments, ensuring database security, availability, and performance, while supporting development teams with query optimization and database design. The ideal candidate will have strong T-SQL skills, experience with high availability solutions, and proficiency in backup, recovery, and automation practices.
Key Responsibilities:
Install, configure, and maintain SQL Server database instances across development, testing, and production environments
Monitor database performance and implement optimization strategies for queries, indexes, and system resources
Design and implement backup and recovery procedures, including disaster recovery planning and testing
Manage database security including user access, permissions, and compliance with organizational policies
Perform database maintenance tasks including index rebuilding, statistics updates, and space management
Troubleshoot database connectivity issues and performance problems
Write and optimize complex SQL queries, stored procedures, and functions to support business requirements
Collaborate with development teams on database design and query optimization
Plan and execute database upgrades, patches, and migrations
Develop and maintain automation scripts for routine administrative tasks
Participate in on-call rotation for after-hours database support
Document database configurations, procedures, and incident responses
Required Qualifications:
Bachelor's degree in Computer Science, Information Technology, or related field
Minimum 5 years of hands-on SQL Server database administration experience
Strong proficiency in T-SQL programming and query optimization
Experience with SQL Server backup and recovery strategies (full, differential, transaction log)
Knowledge of SQL Server clustering, Always On Availability Groups, and replication
Proficiency with database monitoring tools and performance tuning techniques
Experience with Windows Server environments and PowerShell scripting
Understanding of database security best practices and compliance requirements
Ability to work independently and manage multiple priorities in a fast-paced environment
Strong analytical and problem-solving skills
Excellent communication skills for technical and non-technical stakeholders.
SQL Server Administration, T-SQL, Query Optimization, Backup And Recovery, Disaster Recovery, Clustering, Always On Availability Groups, Replication, Database Monitoring, Performance Tuning, Windows Server, PowerShell, Database Security, Compliance, Automation, Database Design, Troubleshooting, Documentation, Communication