The Database Migration Specialist at NorthBay will lead large-scale database migrations and modernization projects utilizing cloud technologies. Responsibilities include developing migration strategies, automating tasks, managing potential risks, and collaborating with stakeholders to ensure project success.
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
Top Skills
Ansible
Aws Aurora
Aws Cloudformation
Aws Database Migration Services
Aws Dms
Aws Sct
Gdpr
Hipaa
Iso
Mssql Tsql
Oracle
Oracle Plsql
Pci
Postgres
Postgres Pl/Pgsql
Shell Scripting
Soc
Terraform
Similar Jobs
Edtech • Software • Database
As a Data Analyst, you will analyze large datasets, create reports and dashboards, and provide recommendations to enhance the platform's effectiveness. Collaborate with teams to align data analysis with business goals and support the data management process.
Fintech • Analytics
The Data Analyst will process and validate financial data, deliver team targets, and provide support to the content teams at S&P Global, ensuring high-quality and accurate financial insights for clients. They will also contribute ideas for new collection methods and enhance product capabilities.
Top Skills:
Content ManagementCorporate Financial ReportingData ProcessingFinancial AnalysisFinancial Data CollectionStandardization
Fintech • Analytics
The Lead Data Analyst will track and collect data for S&P Global's Private Markets Cluster, validating information through various sources. This role involves contributing ideas for collection methods, ensuring data accuracy, and meeting team targets while staying abreast of industry trends.
Top Skills:
Automation ToolsCapital MarketsCorporate FinanceData AnalysisDatabase ToolsFinancial StatementsOnline ResearchValuation Methodologies
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.
