Mid-Level/Intermediate Database Administrator - augmentjobs

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: Bachelor's 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:

   • 2-5 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 problem-solving 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.