Database Administrator (DBA)

Job Responsibilities:

• Design, implement, and maintain MS SQL Server databases based on business requirements and best practices.
• Perform routine maintenance tasks such as indexing, backups, restores, and monitoring.
• Monitor database performance and optimize SQL queries, indexes, and configurations to ensure optimal performance and reliability.
• Develop, implement, and manage backup and recovery plans to ensure data integrity and availability. Regularly test recovery procedures.
• Implement and manage database security measures, including user access controls, encryption, and auditing to protect sensitive data.
• Implement and manage high availability and disaster recovery solutions such as clustering, replication, log shipping, and Always On Availability Groups.
• Automate routine database tasks using scripts and tools to improve efficiency and reduce manual interventions.
• Plan and execute database updates, patches, and upgrades to ensure the database environment is up-to-date and secure.
• Ensure the accuracy, consistency, and reliability of data across the database environment.
• Provide support for database-related issues, troubleshoot problems, and ensure minimal disruption to business operations.
• Monitor database storage and resource usage, and plan for future capacity requirements to ensure optimal performance.
• Maintain comprehensive documentation for database configurations, processes, and procedures to ensure knowledge sharing and continuity.
• Ensure databases comply with industry standards, regulations, and best practices.
• Work closely with developers, system administrators, and other stakeholders to ensure smooth and efficient database operations.
• Identify opportunities for improving database performance, reliability, and efficiency, and implement changes as needed.

Job Requirements:

Education:

• Bachelors degree in computer science, Information Technology, or a related field. A master's degree is a plus.

Experience:

• Minimum of 5 years of experience as a DBA with a focus on MS SQL Server.
• Experience with cloud database services (e.g., Azure SQL Database, Amazon RDS for SQL Server).

Technical Skills:

• Proficiency in MS SQL Server installation, configuration, and management.
• Strong knowledge of SQL and database programming. 
• Experience with performance tuning and query optimization. 
• Knowledge of backup and recovery best practices and tools. 
• Experience with high availability and disaster recovery solutions (e.g., clustering, replication, Always On Availability Groups).
• Understanding of database security best practices and compliance standards.
• Familiarity with automation tools and scripting languages (e.g., PowerShell).
• Experience with cloud platforms and services (e.g., Microsoft Azure, AWS).

Soft Skills:

• Strong problem-solving and analytical skills. 
• Excellent communication and interpersonal skills. 
• Ability to work independently and collaboratively in a team environment.
• Strong attention to detail and organizational skills. 

Certifications:

• Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics are preferred.

Other Requirements:

• Proven track record of managing and optimizing MS SQL Server databases.