Database Migration Specialist
BC Forward

Job Info

---

Database Migration Specialist BCforward is seeking a highly motivated and experienced Database Migration Specialist at RemoteRole: Database Migration SpecialistLocation : Plano, Texas (Once client office is opened)Expected Contract Duration : 6+ months Job Description:
As a migration specialist you are required to perform analysis, design, implementation and migration of data and application database code from Oracle to Aurora PostgreSQL and EDB PostgreSQL databases. You will be required to setup target AWS and On-premise database environments and its associated platforms and permissions required for applications to connect. You will be the single point of contact, drive this project Migration project from front, provide SME support for all solutions and issues during the data and code migrations, and tune the target Aurora PostgreSQL environments. You will drive the incumbent Database, ETL and Application teams in performing the migration.

About The Role:

• Work directly with customers' technical resources to devise and recommend solutions based on the understood requirements.
• Analyze on-premises Oracle databases migrations to Aurora-PostgreSQL and EDB PostgreSQL and provide the strategy and best practices.
• Consult for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance
• Work with ETL, Database and Application teams to convert/migrate and fine tune the data, database code and required database drivers.
• Setup Target Aurora PostgreSQL and EDB PostgreSQL environments with High available, Scalable and High Performance setups.
• Setup AWS Services and permissions required to host Aurora PostgreSQL environments.
• Setup Monitoring, Backup & Recovery, High Available and alerting notification systems on AWS and on-premise.
• Work closely with AWS Platform Service Engineering and Solution Architecture teams to help ensure the success of project consulting engagements with customer
• Employ customer facing skills to represent AWS within the customer's environment and drive discussions with senior personnel regarding trade-offs, standard methodologies, project management and risk mitigation.
• This is a technical position and the ideal candidate is someone who can dive deep in migrating customer data to AWS and EDB PostgreSQL.

Requirements:

• 10+ years of experience in Oracle and PostgreSQL development
• Design enterprise database systems, set standards, best practices and strategies for its operations management and security in the Cloud
• Experience with data modelling, ETL/ELT workflow management desired & ability to write, tune SQL queries desired.
• Experience writing complex SQL and procedural language artifacts: (e.g., PL/SQL and PG/PLSQL )
• Bachelor's degree in Computer science or equivalent experience

• Client is looking for a Database Migration Consultant to help our customers migrate their applications from Oracle databases to the AWS Aurora PostgreSQL and EDB PostgreSQL.
• You will focus on customer solutions such as defining migration complexities, resolving complex migration problems, providing best practices and working with DBA's and ETL team to design, implement and migrate the data and application code, architecting target AWS Aurora PostgreSQL and EDB environments monitoring, backup and security.
• You will collaborate with our customers and partners on key engagements and will deliver proof-of-concepts, technical workshops, and implementation projects to migrate Applications from Oracle databases to Aurora-PostgreSQL and EDB PostgreSQL.

Please share me the updated resumes to

Interested candidates please send resume in Word format Please reference job code 133210 when responding to this ad.

Recommended Skills

Analysis

Database Administration

Data Modeling

Pl/Sql

Databases

Oracle Databases

This job has expired.