Job Description:

Responsibilities:

1. Database Management and Administration:

   • Lead the management and administration of databases, including installation, configuration, and maintenance of database management systems (DBMS) such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.
   • Oversee database performance tuning and optimization efforts, including query optimization, index management, and database caching strategies.
   • Implement and enforce database security measures, access controls, and encryption to protect sensitive data.

2. Database Design and Architecture:

   • Lead the design and architecture of database solutions, including database schemas, tables, views, and stored procedures, to meet business requirements and support application development initiatives.
   • Collaborate with development teams to ensure optimal database design, performance, and scalability for applications.

3. High Availability and Disaster Recovery:

   • Implement and maintain high availability and disaster recovery solutions such as database clustering, replication, and failover configurations to ensure data availability and business continuity.
   • Develop and maintain database backup and recovery strategies, including regular backups, offsite storage, and recovery testing.

4. Database Monitoring and Alerting:

   • Implement database monitoring and alerting solutions to track database health, performance metrics, and capacity planning.
   • Proactively identify and resolve database issues, errors, and performance bottlenecks to minimize downtime and ensure optimal database performance.

5. Automation and Scripting:

   • Develop and maintain automation scripts and tools for database administration tasks such as backups, restores, and monitoring using scripting languages (e.g., PowerShell, Python).
   • Streamline database administration processes and tasks through automation to improve efficiency and reduce manual effort.

6. Documentation and Knowledge Sharing:

   • Document database configurations, procedures, and troubleshooting steps for reference and knowledge sharing.
   • Mentor and train junior database administrators and team members on database best practices, techniques, and tools.

Qualifications:

1. Education: Bachelor's degree in computer science, information technology, or related field. Advanced degrees or certifications such as Oracle Certified Master (OCM) or Microsoft Certified Solutions Expert (MCSE) are a plus.

2. Experience:

   • 5 years of relevant experience in database administration or related fields.
   • Proven experience managing and administering databases in large-scale production environments, including experience with high availability, disaster recovery, and database security.

3. Technical Skills:

   • Expert-level knowledge of database management systems such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.
   • Strong SQL skills and extensive experience writing and optimizing complex SQL queries.
   • Proficiency in database monitoring and management tools such as SQL Server Management Studio (SSMS), Oracle Enterprise Manager, or pgAdmin.

4. Soft Skills:

   • Strong leadership and communication skills, with the ability to lead and mentor a team of database administrators.
   • Excellent problem-solving skills and attention to detail.
   • Ability to work well in a fast-paced environment and prioritize tasks effectively.