Database Migration Specialist (Postgres & Oracle)

Lahore, Punjab, Pakistan

Full Time

Data Engineering

Experienced

Experience: 8+ years
NorthBay is looking for talented database experts in general who are passionate about database migrations & modernization adopting novel cloud & automation technologies to solve real-world problems. Ideal candidates would be having solid experience/expertise with large-scale heterogeneous (different source/target) database migrations especially involving Postgres, Oracle & AWS Database Migration Services (AWS SCT & AWS DMS).

Requirements:

Overall 8+ years of experience involving large size heterogeneous database migrations, modernization, refactoring & optimization involving especially with Postgres, Oracle & AWS Aurora
Expert with AWS Database Migration Services e.g., AWS SCT & AWS DMS (Especially CDC) for large dataset migrations
Experience with heterogeneous database migration complexities, schema transformations, challenges and potential solutions in real world
Experience with automations especially in terms of database deployments and migrations would be a plus point e.g., AWS CloudFormation, Terraform, Ansible, Shell Scripting
Experience with database development and/or database code refactoring/migration involving procedural language e.g., Postgres PL/pgSQL, Oracle PLSQL, MSSQL TSQL
Proficient with database/data security best practices and solutions to compliance requirements e.g., PCI, HIPAA, GDPR, SOC, ISO
Proficiency with other database/data migration solutions/tools would be a plus point
Experience with other database platforms would be a plus e.g., Oracle RAC, MySQL, MSSQL, Snowflake, Redshift
Experience in database monitoring, troubleshooting, performance diagnostics and optimization especially in AWS cloud environment
Overall good understanding and best practices based on different type of workloads e.g., OLTP, DWH, OLAP
Good analytical, problem-solving & communication skills

Responsibilities:

Employ customer facing skills to represent NorthBay well within the customer’s environment and drive discussions regarding trade-offs among multiple options and potential risk mitigations
Work closely with Leads/Architects on all fronts (including customer) to help and ensure success of project/migration
Think strategically about business, product, and technical challenges in an enterprise environment
Develop and execute database migration strategies and solutions including defining database physical structure and functional capabilities, security, backup/recovery, HADR based on RTO/RPO
Automate solutions for repeatable tasks/requirements
Identify the potential risks and potential mitigations
Develop data validation plans and cases to demonstrate database readiness post migration
Work closely with application teams to ensure business functionality and SLAs are met.

What We Offer

Competitive salary and benefits
Fuel expense reimbursement
Paid holidays and vacations
Medical outpatient reimbursement & health insurance facility
Career path to make a difference in a highly productive environment

Apply for this position

Required*

Apply with

First Name*

Last Name*

Email Address*

Phone*

Address

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

How many years of experience do you have in database migrations, modernization, and optimization involving PostgreSQL and Oracle?*

What is your level of experience with AWS Database Migration Services (AWS SCT & AWS DMS, especially CDC) for large dataset migrations?*

How would you rate your proficiency in database development and refactoring using procedural languages such as Postgres PL/pgSQL and Oracle PL/SQL?*

Which of the following database security and compliance standards have you worked with?* PCIHIPAAGDPRSOCNone of the above

Human Check*

Submit Application