Job Description :
Must have 7-8 years Oracle and Postgres DBA working experience supporting databases used for data warehousing and OLAP/Analytics, direct data warehouse experience with Postgres strongly preferred (Oracle data warehouse experience is helpful)
ETL experience in a data warehouse
Knowledgable on best practices for set based processing, etc.
Well versed on Data warehouse vs. OLTP loading
Experienced with tuning and efficient use of transactions
Understanding of Postgres 11 new features and their impact on analytic queries and/or ETL processing
JIT Compilation
Parallel hash joins
Procedures
Parallel query functionality and tuning
Partitioning and inheritance
Deep understanding of Postgres specific transaction and commit processing of tuples, how transactions affect dead rows and bloats, and the usage of vacuums
Postgres server config, OS (kernel parameters, etc, storage tuning and troubleshooting
FDWs (oracle, postgres specifically, including troubleshooting)
Strong understanding of PL/pgSQL programming language
Understanding of indexing options in Postgres and when to use which type
upgrade experience between major versions
Database backups of large volume databases
Ability to work on many tasks simultaneously in a high-pressure environment.
Strong organizational and analytical skills.
Understanding of High Availability and Disaster Recovery requirements and solutions. Not Required, but Preferred:
Desire to learn and support other platforms
Experience in data modeling.
Understanding of or experience supporting J2EE application.
Understanding of or experience with virtual environments.
Goldengate, SQL Server 2008/2012/2014, MongoDB Education: BS/BA degree or equivalent experience in a related technical discipline.