Senior Database Engineer - PostgreSQL

Overland Park, Kansas

• 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

• 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.

Salary will generally fall between $86,772 - $114,174 before adjustment for geographic differences. Recruiter can confirm if position is incentive eligible.

Come join us as we transform the public sector! Our mission, vision, and values guide everything we do. We're also frequently recognized as a great workplace locally and nationally. See our many awards and accolades.

Your health and well-being are important to us. That's why we invest in our team members by offering competitive benefits to support their health and financial wellness. Learn more about how we care for our people.