Job Posting – Database Administrator (Postgres) at Contour Software

About the Job

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.

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, or 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, failover, 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 is 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 performing 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 on 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

• Bachelor’s Degree in CS or equivalent; with 7+ years of professional experience.
• Experience operating a large-scale production database environment.
• Technical and troubleshooting skills with relational databases (Postgres 9.3 and above).
• Proven hands-on experience working with AWS Aurora.
• Experience in independently performing root cause analysis and coming up with recommendations.
• Experience in performance tuning, query optimization, replication techniques, clustering, authentication, partitioning, and security issues.
• Experience with backups, restores, recovery.
• Experience with database security concepts, including access, auditing, and encryption.
• Knowledge and experience in Open Source solutions including vetting patches, applying patches to the database and the open-source tools, libraries, and daemons.
• Experience with High Availability and Disaster Recovery for Postgres.
• Experience with a cloud environment.
• SQL Development experience with the ability to write and troubleshoot SQL code (stored procedures, functions, tables, indexes, constraints).
• Experience with system monitoring tools.

Exciting Benefits We Offer

• Market-leading Salary.
• Medical Coverage Self & Dependents.
• Parents Medical Coverage.
• Provident Fund.
• Employee Performance-based bonuses.
• Home Internet Subsidy.
• Conveyance Allowance.
• Profit Sharing Plan [Tenured Employees Only].
• Life Benefit.
• Child Care Facility.
• Company Provided Lunch/Dinner.
• Professional Development Budget.
• Recreational area for in-house games.
• Sporadic On-shore training opportunities.
• Friendly work environment.
• Leave Encashment.