Vacancy expired!
Role: PostgreSQL DBA Location: Atlanta, GA / New York City
Responsibilities and Tasks:- Install, configure, administer and patch on-premises and Amazon RDS PostgreSQL and MySQL.
- Implement database backup and recovery strategy.
- Maintain data integrity and database performance, stability and scalability.
- Proactively monitors the health of databases and make recommendations to optimize performance and efficiency.
- Diagnose and resolve database, network, and firewall issues.
- Collaborate with various teams in developing system hardware layouts, configuring firewall rules, tuning, and load testing of mission-critical database systems.
- Comply with database security standards.
- Document database administration and management related processes and procedures.
- Provide support to the application developers, including, but not limited to data refresh, SQL and PL/PostgreSQL performance tuning and best practice recommendations.
- Conduct code reviews with application developers.
- Proficient with SQL and performance tuning.
- Preferred experience with Oracle.
- Proficient in relational database management system and principles, network and database security.
- Advanced understanding of database backup and recovery strategies.
- Advanced understanding of high availability solutions and strategies.
- Strong scripting language experience.
- Fluent in Linux command line utilities and operations.
- Automate database administration and maintenance activities.
- Assist with routine Oracle database administration tasks.
- 3-5 years of extensive experience as a Production PostgreSQL DBA. (Mandatory)
- 2+ years of experience with MySQL.
Vacancy expired!