PostgreSQL Database Engineer

Role/Title

Remote or Onsite

Working Hours

Position Type

About the Team:

This team defines, designs, implements, tests and communicates the architectures, configurations, best practices and standards for optimal use of database technologies across the company, both on-prem and in the cloud. We evaluate new and upgraded database versions, features, components and extensions for performance, throughput, scalability, availability and security; and we partner with our hosting, database administration, and operational support teams to operationalize and harden OLTP technology for our top-tier financial applications.

Details:

A lot of activity going on and need someone with strong Postgres Database Engineering.

Teams responsibility is to determine what database technologies the Client should use and if they are good for running large-scale enterprises.

• Deploy DB on cloud, etc.
• Testing out new PG17 version and Patroni 4.x.x
• Figure out all of the ins and outs (secure it, encrypt it, handle thousands of transactions per second, run applications/codes against it, etc.)
• Are the dimensions solid enough to run?
• Ansible, terraform scripts
• Installing, testing, and setting up for highly global usage
• Previous DBA experience.
• Experience installing DBA software from scratch and doing upgrades on it, patching databases (does the vendor supply good patches and scripting).
• Experience doing and handling big migrations from 1 database to another.

Responsibilities:

• Installing, configuring, patching, upgrading, deploying and running Postgres databases.
• Evaluating and preparing new and upgraded Postgres and Postgres-compatible offerings for use across the company.
• Documenting, presenting and explaining the appropriate techniques, patterns and best practices for our hosting, database administration and operational support teams.
• Automating tasks like Failover, Switchover using Patroni cluster management

Qualifications:

• Bachelor's degree preferred.
• Solid knowledge of Postgresql DBMS concepts such as ACID, CAP and consistency.
• Experience with enterprise-scale Postgres deployments, including intra- and inter-data-center high availability configurations, fault tolerance and failover, physical and logical replication, cluster management, automated provisioning, rolling upgrade techniques, backup and restoration techniques, security mechanisms, health monitoring and alerting techniques, and troubleshooting.
• Knowledge of Postgres internals such as durability and replication settings, and performance tuning.
• Skilled at the Unix command line.
• Hands-on experience with HA tools like Patroni Cluster Manager.
• Ability to write code or script, e.g. for test harnesses or other database-related tools and utilities.
• Experience as a database administrator and/or a Unix system administrator.
• Knowledge of virtualization and cloud infrastructures, and of implementations using IaaC
• Knowledge of AWS, Google Cloud, Azure or other public cloud offerings.
• Knowledge of modern storage and compute technologies, including hyper-converged infrastructures.

Please send in your resume to hiring@datamongertechnologies.in if this role matches your career aspirations.