Oversees daily operations of production, non-production and redundant database environments on the cloud and on-premises implementations
Formulates policies, procedures, and standards relating to database management and monitors transaction activity and utilization
Reviews database design and integration of systems and makes recommendations regarding enhancement and/or improvements
Develops, manages and tests back-up and recovery plans ensuring that all procedures are functioning properly
Maintains security and integrity controls over the databases
Contributes to the development of a strategy for use of relational databases technology
Advises organization leaders on database concepts and functional capabilities and recommends system changes to programming staff.

Requirements

Bachelor’s Degree in Computer Science, Information Technology, Business or related field and five (5) or more years of experience in related field; or an equivalent combination of education, certification, training, and/or experience
Database Certification (Postgres or Oracle) preferred
Skill in AWS Glue and AWS Database Migration Service
Strong SQL development skills across OLTP and analytical data platforms
Skill in Amazon RDS and Amazon Aurora for PostgreSQL administration tasks
General understanding of Amazon Redshift architecture and service model, including role-based access control, user/group management, and security permissions
Hands-on experience with PostgreSQL database administration, including installation, configuration, upgrades, and patching
Strong expertise in PostgreSQL performance tuning, including query optimization, index strategy, vacuum/analyze tuning, and parameter configuration
Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability
Skill in AWS Lake Formation, data lake deployments and administration
Ability to organize work for timely completion
Ability to speak, write, read, and understand English
Ability to follow complex oral and written instructions
Ability to communicate effectively orally and in writing
Ability to establish and maintain effective and cooperative working relationships with those contacted in the course of work
Skill in Microsoft Office applications
Ability to travel up to 5% of the time

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQL developmentPostgreSQL administrationPostgreSQL performance tuningquery optimizationindex strategyvacuum/analyze tuningparameter configurationmonitoring and troubleshootingbackup and recovery plansdatabase management

Soft Skills

organizational skillseffective communicationrelationship buildingfollowing complex instructionstimely completion

Certifications

Database Certification (Postgres or Oracle)