NorthBay Solutions

Database Migration Specialist (Postgres & Oracle)

Data Engineering - Karachi, Sindh, Pakistan - Full Time

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: Database Migration Specialist (Postgres & Oracle)
* Required fields
First name*
Last name*
Email address*
Location
Phone number*
Resume*

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?*
Human Check*