Mid-LevelIntermediate Database Administrator

Job Description:

Responsibilities:

1. Database Management:

   • Manage and administer databases including installation configuration and maintenance of database management systems (DBMS) such as MySQL Microsoft SQL Server Oracle or PostgreSQL.
   • Monitor database performance and proactively identify and resolve performance issues bottlenecks and errors.
   • Perform database backups restores and disaster recovery procedures to ensure data integrity and availability.

2. Database Optimization:

   • Optimize database performance and scalability through performance tuning query optimization and index management.
   • Implement database monitoring and alerting solutions to track database health performance metrics and capacity planning.

3. Security and Compliance:

   • Implement and enforce database security measures access controls and data encryption to protect sensitive data.
   • Ensure compliance with regulatory requirements industry standards and data privacy laws related to database security and data protection.

4. Database Design and Development:

   • Collaborate with development teams to design and implement database schemas tables views and stored procedures that meet application requirements.
   • Participate in database design reviews code reviews and performance testing to ensure optimal database design and functionality.

5. Documentation and Reporting:

   • Document database configurations procedures and troubleshooting steps for reference and knowledge sharing.
   • Generate reports and metrics related to database performance usage and capacity planning for management and stakeholders.

6. 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).

Qualifications:

1. Education: Bachelors degree in computer science information technology or related field. Advanced degrees or certifications such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA) are a plus.

2. Experience:

   • 25 years of relevant experience in database administration or related fields.
   • Proven experience managing and administering databases in production environments including experience with database performance tuning and optimization.

3. Technical Skills:

   • Proficiency in database management systems such as MySQL Microsoft SQL Server Oracle or PostgreSQL.
   • Strong SQL skills and experience writing and optimizing SQL queries.
   • Familiarity with database monitoring and management tools such as SQL Server Management Studio (SSMS) Oracle Enterprise Manager or pgAdmin.

4. Soft Skills:

   • Strong problemsolving skills and attention to detail.
   • Excellent communication and interpersonal skills with the ability to work well in a team environment.
   • Ability to prioritize and manage multiple tasks and projects effectively.