Database Engineer - PostgreSQL Hoboken, NJ ref
Hoboken, NJ, United States
Database Engineer - PostgreSQL Hoboken, NJ ref
Skills :VLDB (very large database), Tuning PostGresSQL performance, DB design, DB architecture, Linux Shell Scripting, Migration to Microsoft Azure PostgreSQL.
Database Engineer - PostgreSQL
As a Senior DB Engineer with PostGres and Oracle expertise, he/she will:
•Provide an extensive input into the architecture and processes for multiple large and complex PostGres and Oracle database environments.
•Be responsible for interacting with both the application and system infrastructure teams to design and implement complex databases and manages 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, DevOps engineers on the database needs of PostGres based applications and optimize them using PostGres.
•Work closely with Data Architects and DBAs to help implement migration strategies from Oracle to PostGres or wherever required.
•Work closely with the DBA leads on Budgeting and capacity planning, as well as systems performance and uptime management.
•Provide expert level guidance to a team of DBA's 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 team members for quick resolution.
•Align with 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
•Must have experience in Unix/Linux and Shell scripting .
•Minimum 3-4 years of experience in PostGres with expert level knowledge of DBA skills using PostGres 9.6 – 12.1. Minimum 8-10 years of experience in Oracle using Oracle Rac and standalone in 12c/11G versions.
•Must be able to perform Database Engineering tasks (backup /restore / data loads / performance tuning) and Architecture activities ( server build out and patching) in PostGres.
•Experience with table partitioning and sharing for distributed PostgreSQL XL or Citus / Greeenplum.
•Setup implement best practices in Backup recovery and Disaster recovery activities.
•Must have 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 & Troubleshooting skills and perform database maintenance and Optimizations tasks such as index usage analysis, AWR analysis, index management, statistics, partition management, data compression etc.
1. Have you built out distributed RDBS using Postgres? 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.
2. Please briefly outline VLDB you have worked on. What was the size of the database you designed in Postgres?
3. How did you go about database performance tuning in a Postgres DB? How did you assist application development teams in achieving code and query optimization?
4. What DB back-up strategies have you implemented?
5. How proficient are you with Shell scripting?
6. Have you migrated on-prem Postgres nodes to Azure Postgres? If so, what was your approach?
7. What is the candidate's expected salary?
#J-18808-Ljbffr