Senior Postgres DBA
Contour Software
Lahore, Punjab, PK
4d ago

The Division :

Enspire for Enterprise provides scalable digital marketing solutions for franchises combined with powerful analytics for decision-makers.

As a Franchise Digital Marketing Agency, Enspire has partnered with over 100 multi-location and franchise networks to support thousands of locations worldwide and clientele includes Affordable Dentures, Seasons Sunrooms, Hand and Stone, World Gym, Rebath, Johnson Controls, Mr.

Electric and Ace Hardware, to name a few.

The Position :

Enspire 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 office, working as part of the resource-center team, as an extension of the division-based Customer Support 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 databases 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 mechanism 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, 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 :

  • 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)
  • 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 to include 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 cloud environment.
  • SQL Development experience with 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
  • Company provided Lunch / Dinner
  • Child Care Facility Karachi & Lahore only
  • Professional Development Budget
  • Recreational area for in-house games Karachi & Lahore only
  • Sporadic On-shore training opportunities
  • Friendly work environment
  • Leave Encashment
  • 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 Karachi & Lahore only
  • Company Provided Lunch / Dinner
  • Professional Development Budget
  • Recreational area for in-house games Karachi & Lahore only
  • Sporadic On-shore training opportunities
  • Friendly work environment
  • Leave Encashment
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form