SQL Database Administrator

SQL Server Database Administrator (DBA) to join our team. You will be responsible for managing and maintaining SQL Server databases, ensuring their performance, security, availability, and integrity. The ideal candidate will have strong expertise in database administration, performance tuning, backup/recovery, and high availability configurations within SQL Server environments.

Key Responsibilities:

• Install, configure, and maintain SQL Server databases across various environments (development, staging, production).
• Monitor database performance and perform tuning to ensure optimal system performance, reliability, and scalability.
• Perform database backups and restores, including disaster recovery testing and planning.
• Implement and manage database security, including user roles, permissions, and auditing.
• Ensure high availability and disaster recovery solutions are in place (e.g., Always On Availability Groups, Log Shipping, Replication, Clustering).
• Troubleshoot and resolve database-related issues, including performance problems, deadlocks, and database corruption.
• Work closely with application teams to optimize SQL queries, stored procedures, and other database objects.
• Manage database migrations and upgrades to new versions or configurations.
• Maintain and monitor database logs, identifying and resolving any issues before they impact the system.
• Document database configurations, processes, and troubleshooting procedures.
• Assist with capacity planning and forecasting database growth.
• Automate routine database tasks using PowerShell, T-SQL, or other scripting languages.
• Provide on-call support for critical systems and respond to database-related incidents.

Required Qualifications:

• Proven experience as a SQL Server DBA, with hands-on experience in SQL Server 2012 or later.
• Strong expertise in database performance tuning and query optimization.
• Experience with database backup, recovery, and restoration processes.
• Hands-on experience with high availability solutions like AlwaysOn Availability Groups, SQL Server Clustering, Log Shipping, and Replication.