Senior Database Engineer - PostgreSQL

Responsibilities

• Conceptualize and build architecture and lifecycle models and strategies for the on-premises and AWS PostgreSQL environments.
• Work with other divisional and corporate teams to develop strategic plans for cloud migrations and technology changes.
• Install, configure, upgrade, and maintain/administer PostgreSQL clusters.
• Work with service consumers to coordinate periodic DB management operations and upgrades.
• Provide recommendations and execute planned adjustments for optimizing performance on all PostgreSQL database instances.
• Manage monitoring of the PostgreSQL footprint.
• Manage replication administration and monitoring for the PostgreSQL footprint.
• Act as subject matter expert for troubleshooting and resolving PostgreSQL service and performance issues.
• Perform oncall rotations, serving as PostgreSQL SME and initial contact for other DB platforms.
• Perform administrative tasks in the PostgreSQL environment including but not limited to user administration, permissions, schema and instance creation, security adjustments, storage administration, backup and recovery, and service tickets.
• Collaborate with service consumers to optimize database design and queries
• Create basic automation scripts (Shell, Perl or Python), Jenkins experience a plus.
• Other Responsibilities Assigned by Manager
• Some Travel May be Required
•  

Qualifications

• Proactive and thorough communication skills with teammates, service consumers, and management are required to succeed in this role.
• 5+ Years supporting, maintain, administering PostgreSQL clusters in an enterprise environment.
• Strong experience with current versions of PostgreSQL and it’s derivatives
• Ability to enhance knowledge with other DB platforms will be required.
• Strong AWS environment experience required to succeed in this role.
• Strong experience with RedHat Linux (or derivatives)
• Intermediate experience scripting in Bash, Perl, and/or Python
• Must be able to participate in on-call rotation.
• Must have experience and be able to support operational tasks such as patching and administration.
• Should have experience in a 24x7x365 enterprise environment meeting uptime SLA’s of 99.99% or greater.