SQL Server DBA

SQL Server DBA2

Key Responsibilities

Database Management:

Manage, configure, and maintain SQL Server databases in high-availability environments (Active-Active).
Ensure optimal database performance, tuning queries, and optimizing resources.
Monitor and resolve database performance issues, minimizing downtime.

Cluster Setup And Management

Design, implement, and support SQL Server AlwaysOn availability groups and failover clustering.
Ensure high availability and disaster recovery across multi-node SQL Server clusters.
Monitor and manage cluster health, replication, and failover processes.

On-Prem To AWS Migration

Lead and execute migration of on-premise SQL Server databases to AWS cloud, including RDS and EC2 setups.
Plan, architect, and execute database migration strategies with minimal downtime and risk.
Configure databases in AWS environments, ensuring scalability, performance, and security.

Backup, Recovery, And Disaster Recovery

Implement and manage backup and recovery strategies to safeguard critical data.
Test and maintain disaster recovery plans to ensure database availability during unforeseen events.
Manage database replication between on-premises and cloud infrastructure.

Security And Compliance

Ensure databases adhere to security and compliance policies, implementing data encryption, access control, and auditing.
Regularly conduct security audits and apply patches and updates to mitigate vulnerabilities.
Collaborate with security teams to meet industry compliance standards.

Support And Troubleshooting

Provide 24/7 support for production databases, ensuring rapid resolution of any issues.
Troubleshoot and resolve complex database issues related to performance, availability, and security.
Document procedures, guidelines, and best practices for maintaining and optimizing SQL Server environments.

Automation And Scripting

Automate routine database tasks, including backups, monitoring, and performance tuning using tools such as PowerShell, T-SQL, or other automation tools.
Continuously improve efficiency and reduce manual intervention in database operations.

Collaboration

Work closely with development, infrastructure, and operations teams to ensure smooth database operations across all environments.
Provide guidance and best practices for database design, development, and optimization.

Required Skills And Qualifications

5+ years of experience as a SQL Server DBA in enterprise environments.
Strong knowledge of SQL Server clustering, AlwaysOn availability groups, and Active-Active setups.
Experience with on-premises to AWS migration for SQL Server databases.
Expertise in AWS RDS, EC2, and other AWS database services.
Proven experience in performance tuning, query optimization, and database maintenance.
Strong understanding of backup, recovery, and disaster recovery strategies.
Proficiency in T-SQL, PowerShell, and other automation scripting languages.
Excellent troubleshooting, problem-solving, and communication skills.