Details:
A lot of activity going on and need someone with strong Postgres.
Teams responsibility is to determine what database technologies Amex should use and if they
are good for running large scale enterprises.
oPhase out DB2, deploy cloud, etc.
oCurrently 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?
oAnsible, terraform scripts
oInstalling, 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:
Bachelors 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.
Note: Its 24/7 Shift timings and WFO