Database Administrator

# 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)*