Software Engineering
Overland Park,
Kansas
Description
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.