Postgres Engineer

Role/Title: Postgres Engineer
Remote or Onsite: 90% Remote (occasional visits to the office)
Working Hours: Normal India Working Hours
Position Type: Long-Term Contract (1+ years or more)

Position Notes:
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.
• Teams responsibility is to determine what database technologies Client should use and if they are good for running large scale enterprises.
• Phase out DB2, deploy cloud, etc.
• Currently testing out new database Ugabite
• 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.
Job Description:
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.
Qualifications:
• Bachelor's degree preferred.
• Solid knowledge of 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.
• Skill at the Unix command line.
• 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 such as VMWare, OpenShift, Kubernetes and Docker.
• Knowledge of AWS, Google Cloud, Azure or other public cloud offerings.
• Knowledge of modern storage and compute technologies, including hyper-converged infrastructures