Senior Database Engineer - PostgreSQL

Company: Tyler Technologies, Inc.
Location: Overland Park
Posted on: November 6, 2024

Job Description:

Senior Database Engineer - PostgreSQLLocation: Overland Park, KansasResponsibilities

• 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 on-call 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, maintaining, and administering PostgreSQL clusters in an enterprise environment.
  • Strong experience with current versions of PostgreSQL and its 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.State-Specific Salary Range Disclosure RequirementsSalary will generally fall between $86,772 - $114,174 before adjustment for geographic differences. Recruiter can confirm if position is incentive eligible.
    #J-18808-Ljbffr

Keywords: Tyler Technologies, Inc., Lawrence , Senior Database Engineer - PostgreSQL, IT / Software / Systems , Overland Park, Kansas