ESR Healthcare
Database Engineer - PostgreSQL Hoboken, NJ ref
ESR Healthcare, Hoboken, New Jersey, us, 07030
Database Engineer - PostgreSQL
Location:
Hoboken, NJ
Skills:
VLDB (very large database), Tuning PostgreSQL performance, DB design, DB architecture, Linux Shell Scripting, Migration to Microsoft Azure PostgreSQL.
Responsibilities:
Provide extensive input into the architecture and processes for multiple large and complex PostgreSQL and Oracle database environments.
Interact with both the application and system infrastructure teams to design and implement complex databases and manage the integration of these databases with applications.
Apply expert technical knowledge to significant deliverables and projects that have enterprise impact and involve multiple IT departments and business units.
Collaborate with Data Architects and DevOps engineers on the database needs of PostgreSQL based applications and optimize them.
Work closely with Data Architects and DBAs to help implement migration strategies from Oracle to PostgreSQL or wherever required.
Assist DBA leads on budgeting and capacity planning, as well as systems performance and uptime management.
Provide expert level guidance to a team of DBAs whose primary responsibilities include providing database administration for production databases, production Oracle application servers, and several development databases.
Act as a primary touchpoint on the most complex or escalated issues and provide direction and guidance to team members for quick resolution.
Align with the architecture team to bring in new databases and methodologies as required during the enterprise IT transformation and modernization efforts.
Qualifications/Experience Required:
BS – Computer Science, Information Technology, Management Information Systems or related field of study.
Experience in Unix/Linux and Shell scripting.
Minimum 3-4 years of experience in PostgreSQL with expert level knowledge of DBA skills using PostgreSQL 9.6 – 12.1.
Minimum 8-10 years of experience in Oracle using Oracle RAC and standalone in 12c/11G versions.
Ability to perform Database Engineering tasks (backup/restore/data loads/performance tuning) and Architecture activities (server build out and patching) in PostgreSQL.
Experience with table partitioning and sharing for distributed PostgreSQL XL or Citus/Greenplum.
Setup and implement best practices in backup recovery and disaster recovery activities.
Expertise in installation, configuration, upgrade, migration & administration of Oracle Real Application Cluster (RAC) for versions 11g/12c using ASM/ACFS.
Experience with Database Encryption technologies such as Oracle TDS and/or Vormetric is preferred.
Superior level performance tuning and troubleshooting skills and ability to perform database maintenance and optimization tasks such as index usage analysis, AWR analysis, index management, statistics, partition management, data compression, etc.
Interview Questions:
Have you built out distributed RDBS using PostgreSQL? How many nodes were used? How did you go about partitioning the DB? Did you implement third-party technologies such as PostgreSQL XL or Citus? Use specific examples, if you prefer.
Please briefly outline VLDB you have worked on. What was the size of the database you designed in PostgreSQL?
How did you go about database performance tuning in a PostgreSQL DB? How did you assist application development teams in achieving code and query optimization?
What DB backup strategies have you implemented?
How proficient are you with Shell scripting?
Have you migrated on-prem PostgreSQL nodes to Azure PostgreSQL? If so, what was your approach?
What is the candidate's expected salary?
#J-18808-Ljbffr
Location:
Hoboken, NJ
Skills:
VLDB (very large database), Tuning PostgreSQL performance, DB design, DB architecture, Linux Shell Scripting, Migration to Microsoft Azure PostgreSQL.
Responsibilities:
Provide extensive input into the architecture and processes for multiple large and complex PostgreSQL and Oracle database environments.
Interact with both the application and system infrastructure teams to design and implement complex databases and manage the integration of these databases with applications.
Apply expert technical knowledge to significant deliverables and projects that have enterprise impact and involve multiple IT departments and business units.
Collaborate with Data Architects and DevOps engineers on the database needs of PostgreSQL based applications and optimize them.
Work closely with Data Architects and DBAs to help implement migration strategies from Oracle to PostgreSQL or wherever required.
Assist DBA leads on budgeting and capacity planning, as well as systems performance and uptime management.
Provide expert level guidance to a team of DBAs whose primary responsibilities include providing database administration for production databases, production Oracle application servers, and several development databases.
Act as a primary touchpoint on the most complex or escalated issues and provide direction and guidance to team members for quick resolution.
Align with the architecture team to bring in new databases and methodologies as required during the enterprise IT transformation and modernization efforts.
Qualifications/Experience Required:
BS – Computer Science, Information Technology, Management Information Systems or related field of study.
Experience in Unix/Linux and Shell scripting.
Minimum 3-4 years of experience in PostgreSQL with expert level knowledge of DBA skills using PostgreSQL 9.6 – 12.1.
Minimum 8-10 years of experience in Oracle using Oracle RAC and standalone in 12c/11G versions.
Ability to perform Database Engineering tasks (backup/restore/data loads/performance tuning) and Architecture activities (server build out and patching) in PostgreSQL.
Experience with table partitioning and sharing for distributed PostgreSQL XL or Citus/Greenplum.
Setup and implement best practices in backup recovery and disaster recovery activities.
Expertise in installation, configuration, upgrade, migration & administration of Oracle Real Application Cluster (RAC) for versions 11g/12c using ASM/ACFS.
Experience with Database Encryption technologies such as Oracle TDS and/or Vormetric is preferred.
Superior level performance tuning and troubleshooting skills and ability to perform database maintenance and optimization tasks such as index usage analysis, AWR analysis, index management, statistics, partition management, data compression, etc.
Interview Questions:
Have you built out distributed RDBS using PostgreSQL? How many nodes were used? How did you go about partitioning the DB? Did you implement third-party technologies such as PostgreSQL XL or Citus? Use specific examples, if you prefer.
Please briefly outline VLDB you have worked on. What was the size of the database you designed in PostgreSQL?
How did you go about database performance tuning in a PostgreSQL DB? How did you assist application development teams in achieving code and query optimization?
What DB backup strategies have you implemented?
How proficient are you with Shell scripting?
Have you migrated on-prem PostgreSQL nodes to Azure PostgreSQL? If so, what was your approach?
What is the candidate's expected salary?
#J-18808-Ljbffr