Database Administrator

Company Overview

(No specific company information provided)

Job Summary

The Database Administrator (DBA) plays a crucial role in ensuring that databases operate efficiently and securely. This position requires a proactive approach to analyzing and resolving issues within defined Service Level Agreements (SLA). The DBA will exhibit a strong sense of ownership over problems and maintain effective communication with relevant teams to ensure timely resolution. Adherence to guidelines when implementing changes in production environments is also essential.

Responsibilities

• Manage and administer databases in on-premise and cloud-based environments.
• Monitor and optimize database performance and capacity proactively.
• Utilize MySQL, PostgreSQL, AWS RDS (MySQL/Aurora), Amazon Redshift, and Oracle Cloud Infrastructure (OCI) services.
• Conduct backups, restore processes, and maintain recovery models, emphasizing proactive housekeeping and data archiving.
• Troubleshoot database issues including integrity, performance, connectivity, and resource contention problems.
• Collaborate with various teams and raise support tickets with vendors such as AWS and Oracle for issue resolution.

Qualifications

• Technical Skills:

  • Proficiency in database administration for MySQL and PostgreSQL environments.
  • Familiarity with AWS RDS, Aurora, and Amazon Redshift.
  • Experience with Oracle Cloud Infrastructure (OCI), including DBCS and Autonomous Data Warehouse (ADW).
  • Understanding of Hadoop and command-line interfaces, particularly OCI CLI.
  • Strong experience in Python for operational automation.

• Soft Skills:

  • Effective communication and interpersonal skills.
  • Strong documentation practices and ability to keep stakeholders informed.

• Education: Relevant degree or certifications in Computer Science or a related field is preferred but not specified.

Preferred Skills

• Experience with database monitoring and alerting tools like SolarWinds DPA, CloudWatch, and Opsgenie.
• Familiarity with Oracle Container Database (CDB) and Pluggable Database (PDB) management.
• Ability to implement automation scripts using Shell, Perl, or Python.

Experience

• Work experience in database administration in both on-premise and cloud-based environments is essential – specific years of experience required are not mentioned.

Environment

(No specific work setting, location, or physical conditions provided)

Salary

(No salary range provided)

Growth Opportunities

(No specific growth opportunities mentioned)

Benefits

(No specific benefits listed)