Sql Database Administrator

Key Responsibilities:

• Database Management: Install, configure, and maintain SQL Server databases.
• Performance Tuning: Optimize queries, indexes, and stored procedures for high performance.
• Backup & Recovery: Implement and manage backup/recovery strategies to ensure data integrity.
• Security & Compliance: Manage user access, roles, and permissions while ensuring database security and compliance with industry standards.
• Monitoring & Troubleshooting: Proactively monitor databases, identify issues, and resolve performance bottlenecks.
• High Availability & Replication: Implement and manage HA/DR solutions such as Always On Availability Groups, Log Shipping, and Replication.
• Automation & Scripting: Develop and maintain automation scripts using T-SQL, PowerShell, or other scripting languages.
• Collaboration: Work with developers, system administrators, and business teams to support database needs.
• Upgrades & Patching: Plan and execute database upgrades, patching, and migrations.
• Documentation: Maintain comprehensive documentation for database environments, processes, and configurations.

Required Skills

Experience: 15+ years as a SQL Server DBA.

Technical Skills:

• Strong expertise in Microsoft SQL Server (2016, 2019, 2022, or latest versions).
• Hands-on experience with T-SQL, Stored Procedures, Functions, Triggers, and Views.
• Experience with performance tuning, indexing, and query optimization.
• Knowledge of SQL Server clustering, Always On Availability Groups, Log Shipping, and Replication.
• Experience in SSIS, SSRS, and SSAS (optional but preferred).
• Proficiency in backup, recovery, and disaster recovery planning.
• Knowledge of cloud-based SQL solutions (Azure SQL, AWS RDS, etc.) is a plus.
• Scripting experience using PowerShell, Python, or Bash is a plus.