Database Administrator(Postgres)

The Division:

At Jonas Fitness, we have over 30 years of experience in the industry and aim to be the leader in fitness software and billing services. Our solutions include enterprise fitness management software, credit card and ACH processing services, and full-service billing and member services to improve the efficiencies of your club and bottom line.

The Position:

JFI is seeking a Senior Postgres DBA who will be primarily responsible for the maintenance and performance of databases, to ensure the availability and optimal performance. This includes implementing a failsafe backup strategy, maintaining existing replication and coming up with strategic solutions to recurring problems.

The successful hire will be located and work out of the Contour Software Lahore , Karachi, Islamabad office, working as part of the resource-centre team, as an extension of the division-based Onshore R&D department.

Primary Responsibilities include:

In-depth knowledge of the Postgres architecture.

Drive end-to-end availability, performance monitoring, and capacity planning for Postgres, using different tools.

Administration of community edition Postgres database servers throughout the development and production lifecycles of various concurrent versions.

Perform installation and testing of Postgres database versions on Linux/Ubuntu/Unix, testing for performance, stability, fail over and managing extensions, planning migration strategy.

Implement/Support Master/Standby read-only Postgres clusters using Streaming Replication

Implement/Support Failover Solutions for Master/Standby read-only Postgres clusters

Manage Backup/Restores and PITR Disaster Recovery environment.

Proactively monitor and setup alerting mechanisms for both database and supporting hardware to ensure system health and maximum availability.

Monitor database performance such as distribution of data and amount of available memory, making necessary modifications to decrease database response times and increase processing performance.

Ensure that appropriate maintenance in place including backups, index maintenance, and routine vacuuming including determining optimum values for database attributes and stats refresh.

Experience in monitoring, alerting, troubleshooting and resolving performance-related Postgres database problems and perform Performance tuning.

Assist engineering and application team in the design of appropriate DB Schema and indexing strategy for performance and scalability.

Keep up to date with new releases of Postgres and provide advice of the aspects that pertain to them including the minor/major upgrades.

Perform capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects.

Plan and perform minor/major Postgres database server upgrades.

Ensure data integrity and security, define and monitor user permissions to ensure data is protected from unauthorized users. Create users, establish database security policies.

Document processes and procedures. Conduct technical reviews and walkthroughs of system design documentation with development and design team members.

Continue to learn new skills involved in being a Postgres DBA as the technology evolves.

Excellent problem-solving skills supporting a mission-critical database environment with 24×7 On-Call Support including weekends.

Desired Skills and Qualifications: