Senior-Level Database Administrator

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: Bachelors 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 largescale production environments including experience with high availability disaster recovery and database security.

3. Technical Skills:

   • Expertlevel 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 problemsolving skills and attention to detail.
   • Ability to work well in a fastpaced environment and prioritize tasks effectively.