Database Design and Implementation: - Creating and optimizing database structures. - Collaborating with application developers to ensure proper data modeling. Performance Tuning: - Monitoring query performance and optimizing SQL queries. - Utilizing indexing and other optimization techniques to enhance database performance. Backup and Recovery: - Establishing and maintaining backup and recovery procedures. - Conducting regular tests to ensure data can be restored in case of failures. Security Management: - Managing user access and permissions. - Implementing security best practices to protect against unauthorized access and data breaches. Troubleshooting: - Identifying and resolving issues, such as connectivity problems, data corruption, or performance bottlenecks. -Ability to detect and troubleshoot SQL Server-related CPU, memory, I/O, and other resource contentions. - Implementing proactive monitoring to catch potential problems before they impact users Upgrades and Patching: - Planning and executing SQL Server upgrades and applying patches. - Ensuring compatibility with existing applications during the upgrade process. Capacity Planning: - Monitoring and analyzing database usage trends to plan for future resource requirements. - Scaling database infrastructure to accommodate growing data volumes. Documentation: - Maintaining comprehensive documentation for databases, including schema, configurations, and procedures. - Providing documentation for disaster recovery plans. Automation: - Developing and implementing automation scripts for routine tasks. - Leveraging tools for monitoring, alerting, and automating common DBA activities. High Availability (HA) Implementation: - Designing and implementing high availability solutions, such as SQL Server AlwaysOn Availability Groups - Ensuring databases are configured for maximum uptime and minimal downtime during planned or unplanned outages. Disaster Recovery (DR) Planning: - Developing and maintaining robust disaster recovery strategies with a focus on minimizing data loss and downtime. - Implementing technologies like SQL Server Failover Clustering for DR scenarios. Monitoring and Alerting: - Establishing proactive monitoring systems to detect potential issues. - RedGate Monitoring-Zabbix. Requirements 5 years+ of work experience as an SQL Database Administrator BSc degree in a computer discipline or relevant certification Hands-on experience with database standards and end-user applications Familiarity with programming languages and APIs Problem-solving skills and ability to think algorithmically Familiarity with NoSQL, MySql Provide 24x7 support for critical production systems