SQL DBA

Key Responsibilities:

•   Database Management:

     1. Install, configure, and maintain Microsoft SQL Server instances.

     2. Create and manage databases, tables, views, indexes, and stored procedures.

     3. Ensure data integrity and security through backups, restorations, and disaster recovery planning.

     4. Monitor database performance and proactively optimize queries and configurations.

     5. Implement database maintenance tasks such as indexing, defragmentation, and statistics updates.

•   Security and Compliance:

     1. Implement and enforce database security policies, access controls, and authentication mechanisms.

     2.  Stay up-to-date with industry best practices and ensure compliance with data protection regulations (e.g., GDPR, HIPAA).

•   Performance Tuning:

     1. Identify and resolve database performance issues by analyzing query execution plans and optimizing SQL code.

     2. Collaborate with application developers to fine-tune queries and database design for optimal performance.

•  High Availability and Disaster Recovery:

     1. Configure and maintain high availability solutions, such as SQL Server AlwaysOn Availability Groups and failover clustering.

     2. Develop and test disaster recovery plans and participate in regular drills.

•  Monitoring and Alerting:

     1. Set up monitoring tools to proactively detect and respond to database issues.

     2. Create and maintain alerting systems to notify the team of critical events.

•  Documentation:

    1. Maintain documentation related to database configurations, processes, and best practices.

•  Backup and Recovery:

     1. Regularly schedule and test database backups.

     2. Develop and maintain backup and recovery procedures to ensure data availability.

•  Capacity Planning:

   1. Monitor database growth trends and plan for capacity upgrades as needed.

•  Collaboration:

   1. Collaborate with cross-functional teams, including application developers, system administrators, and network engineers, to ensure seamless database operation.

Qualifications:

•             Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).

•             Proven experience as a Microsoft SQL Server Database Administrator in a production environment.

•             Proficiency in SQL Server installation, configuration, maintenance, and troubleshooting.

•             Knowledge of database security and compliance standards.

•             Strong SQL querying and performance tuning skills.

•             Familiarity with high availability and disaster recovery solutions.

•             Experience with database monitoring and alerting tools.

•             Excellent problem-solving and communication skills.

•             Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.