Job Description :
PostgreSQL DBA

Bethesda, MD 

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.

• Proactivity monitors the health of databases and makes 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/pgSQL performance tuning, and best practice recommendations.

• Conduct code reviews with application developers.

• Automate database administration and maintenance activities.

• Assist with routine Oracle database administration tasks.

Must-Have:

• 5+ years of extensive experience as a Production PostgreSQL DBA. (Mandatory)

• 2+ years of experience with MySQL.

• 3+ years of AWS RDS management experience.

Qualifications:

• Preferred experience with Oracle.

• Proficient in the 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.

• Proficient with SQL and performance tuning.

• Ability to pay meticulous attention to detail.

• Self-driven and ability to meet goals and deadlines.

• Must have strong analytical and problem-solving skills.

• Ability to multi-task, prioritize and work under pressure in a fast-paced work environment.

• Strong scripting language experience.

• Fluent in Linux command-line utilities and operations.

• Ability to work directly with cross-functional teams to resolve application issues.

• Possess strong verbal and written communication skills.

• 24x7 on-call experience.

• Must be available for after-hours and weekend work.

             

Similar Jobs you may be interested in ..