Database Engineer

2 weeks ago

Hoboken, United States CareerBuilder Full time

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

  • Data Engineer

    5 days ago

    Hoboken, United States Global Soft Systems Full time

    Job DescriptionJob DescriptionData Engineer Location Sunnyvale, CA or Hoboken, NJ ( open to relo candidates, just have to be able to relocate asap)Must have: Python, SQL, Hadoop, Hive, Spark (pyspark), Tableau/LookerPreferred: Experience with apache kafka, databases Experience with adobe analytics / google analyticsWork with the stakeholders to understand...

  • Data Engineer

    7 days ago

    Hoboken, United States ThemeSoft Full time

    Position: Data Engineer Location: Hoboken, NJ (Hybrid - On-site 2-3 days per week) Employment Type: Full-time Requirements: Proficiency in Python for data manipulation, analysis, and scripting. Experience with Spark for big data processing and analytics . Nice-to-Haves: Familiarity with Tableau for data visualization. Knowledge of Google Cloud Platform...

  • Data Engineer

    Found in: Appcast US C2 - 1 week ago

    Hoboken, United States Themesoft Inc. Full time

    Position: Data EngineerLocation: Hoboken, NJ (Hybrid - On-site 2-3 days per week)Employment Type: Full-timeRequirements:Proficiency in Python for data manipulation, analysis, and scripting.Experience with Spark for big data processing and analytics.Nice-to-Haves:Familiarity with Tableau for data visualization.Knowledge of Google Cloud Platform (GCP) for...

  • Data Engineer

    Found in: Appcast Linkedin GBL C2 - 1 week ago

    Hoboken, United States Themesoft Inc. Full time

    Position: Data EngineerLocation: Hoboken, NJ (Hybrid - On-site 2-3 days per week)Employment Type: Full-timeRequirements:Proficiency in Python for data manipulation, analysis, and scripting.Experience with Spark for big data processing and analytics.Nice-to-Haves:Familiarity with Tableau for data visualization.Knowledge of Google Cloud Platform (GCP) for...

  • Data Engineer

    1 week ago

    Hoboken, United States Themesoft Inc. Full time

    Position: Data EngineerLocation: Hoboken, NJ (Hybrid - On-site 2-3 days per week)Employment Type: Full-timeRequirements:Proficiency in Python for data manipulation, analysis, and scripting.Experience with Spark for big data processing and analytics.Nice-to-Haves:Familiarity with Tableau for data visualization.Knowledge of Google Cloud Platform (GCP) for...

  • Senior Technical Support Engineer

    5 days ago

    Hoboken, United States NICE Full time

    Senior Technical Support Engineer - NYC Public SafetyOverall Purpose:Primary focus is deploying, maintaining and supporting NYC NexGen 911 Logging and Recording Solution for the 911 system.Assisting product teams to successfully introduce new products/versions. Champion supportability and preventative action on behalf of the customer.Scope and...

  • Marketing Coordinator

    4 days ago

    Hoboken, United States H & H Inc Full time

    H&H is offering an exciting opportunity for a Marketing Coordinator to join a fast-paced and dynamic team in Hoboken, NJ. This is a multi-faceted growth role covering all aspects of marketing.H&H is a full-service infrastructure engineering firm with more than 135 years of experience steeped in solving complex engineering challenges. Consulting firms,...

  • Senior Technical Support Engineer

    6 days ago

    Hoboken, United States NICE Full time

    Senior Technical Support Engineer - NYC Public Safety Overall Purpose: Primary focus is deploying, maintaining and supporting NYC NexGen 911 Logging and Recording Solution for the 911 system. Assisting product teams to successfully introduce new products/versions. Champion supportability and preventative action on behalf of the customer. Scope and...

  • Marketing Coordinator

    1 week ago

    Hoboken, United States H&H Full time

    Job DescriptionJob DescriptionH&H is offering an exciting opportunity for a Marketing Coordinator to join a fast-paced and dynamic team in Hoboken, NJ. This is a multi-faceted growth role covering all aspects of marketing.H&H is a full-service infrastructure engineering firm with more than 135 years of experience steeped in solving complex engineering...

  • Marketing Coordinator

    2 days ago

    Hoboken, United States H&H Full time

    Job DescriptionJob DescriptionH&H is offering an exciting opportunity for a Marketing Coordinator to join a fast-paced and dynamic team in Hoboken, NJ. This is a multi-faceted growth role covering all aspects of marketing.H&H is a full-service infrastructure engineering firm with more than 135 years of experience steeped in solving complex engineering...

  • Golang Developer Remote

    2 weeks ago

    Hoboken, United States tekHouse Full time

    Job DescriptionJob DescriptionMust be USC, GC, or Perm Resident HybridJob Type:- Contract & Hybrid Contract 1099 or Corp to CorpBuilding a Policy engine. They notice a pattern of production issues, connectivity problems, set up problems, consistent and common within repositories. Typically revolving around having to set up database or clusters.- They want to...

  • Senior Cloud Operations Engineer

    Found in: Talent US C2 - 2 weeks ago

    Hoboken, United States NICE Full time

    At NICE, we don’t limit our challenges. We challenge our limits. Constantly. We’re relentless. We’re ambitious. And we make an impact. Our NICErs bring their A game and spend each day turning it into an A+. And if you’re like us, we can offer you the kind of challenge that will light a fire within you.So, what’s the role all about?This is a rare...

  • Marketing Coordinator

    Found in: Resume Library US A2 - 2 weeks ago

    Hoboken, New Jersey, United States H&H Full time

    H&H is offering an exciting opportunity for a Marketing Coordinator to join a fast-paced and dynamic team in Hoboken, NJ. This is a multi-faceted growth role covering all aspects of marketing. H&H is a full-service infrastructure engineering firm with more than 135 years of experience steeped in solving complex engineering challenges. Consulting firms,...

  • Level 1/2 Help Desk Admin- End User Support

    2 weeks ago

    Hoboken, United States Contour Data Solutions Full time

    Job DescriptionJob DescriptionLevel 1/2 Help Desk Admin - End User Support Job Location: Hamilton, New JerseyFull time position Experience- 5+ years Salary: 45-65k depending on experienceJob Description:Contour Data Solutions is looking for a person wanting to make an immediate impact in a rapidly changing, fast paced environment. The position is part of a...

  • Level 1/2 Help Desk Admin End User Support

    2 weeks ago

    Hoboken, United States Contour Data Solutions Full time

    Level 1/2 Help Desk Admin - End User Support Job Location: Hamilton, New JerseyFull time position Experience- 5+ years Salary: 45-65k depending on experienceJob Description: Contour Data Solutions is looking for a person wanting to make an immediate impact in a rapidly changing, fast paced environment. The position is part of a technology team that has...

  • Senior Cloud Operations Engineer

    Found in: Jooble US O C2 - 3 weeks ago

    Hoboken, NJ, United States NICE Full time

    OVERVIEW: This is a rare opportunity to work with an innovative product launching in an area new to cloud services. The primary focus is deploying, maintaining and supporting state of the art cloud-deployed solutions for digital evidence management for Public Safety customers worldwide. Assisting product teams to successfully introduce new...

  • (USA) Senior Director, Product Management

    Found in: Jooble US O C2 - 3 weeks ago

    Hoboken, NJ, United States Walmart Canada Full time

    USA) Senior Director, Product Management - Transportation page is loaded (USA) Senior Director, Product Management - Transportation Apply locations Bentonville, AR Hoboken, NJ Sunnyvale, CA time type Full time posted on Posted 2 Days Ago job requisition id R-1835997 Position Summary... Walmart’s transportation systems help run one of the largest...