POSTGREE SQL DBA

THIS IS CORP 2 CORP ONSITE HYBRID CANDIATE LOCAL OR NEARBY STATES LIKE -VA/DC/PA/DE/MD

INTERVIEW PROCESS 2 HRS WITH CODING TEST.

ROLE: POSTGREE SQL DBA


OVERALL EXPEREINCE 9YRS
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/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)
•3+ years of experience with MySQL.
•3+ years of AWS RDS management experience.
Qualifications:
•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.
•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.