Lead Database Migration Consultant (Oracle To Postgresql) - Remote

Percona Austin , TX 78719

Posted 2 months ago

Percona is a respected thought leader in the open source community. We provide services and software for MySQL, MongoDB, PostgreSQL and MariaDB to open source users globally.

Percona is remote-first and globally dispersed; we have 250 people in almost 40 countries. We offer a collaborative, highly-engaged culture where your ideas are welcome and your voice is heard. The growth and development of our staff is a top priority; we provide funding for training, certifications, conferences and more.

Discover what it means to work with some of the smartest people in the industry, who also know how to have fun and are always willing to lend a helping hand. We offer flexible hours, the ability to work remotely and the amazing experience of working with a multinational team of experts.

As a Lead Database Migration Consultant, your primary responsibility is the successful migration of large datasets from an Oracle database system to a comparable PostgreSQL RDBMS.

The Oracle installations will range in both size and complexity. The migration operation itself may be simple or complex, requiring multiple steps over an extended span of time. The data-sets can be sized anywhere from several hundred gigabytes to many petabytes. The cluster's configuration will be variable and can be as simple as a standalone server or as complex as a multi-node cluster with automated failover between data centers with an uptime requirement of 4 9s.

You will execute "out of the box" solutions as you leverage the myriad technologies, methods and best practices in your arsenal. You are comfortable using the various PostgreSQL tools and extensions such as foreign data wrappers, and the ora2pg extension. Equally so, you are familiar with standard enterprise tools often seen in Oracle environments such as GoldenGate.

You will work remotely and most people work from their homes. Up to 50% travel is expected (as safety regulations permit), both for onsite projects and internal meetings.

What You Will Do

  • Assess the existing Oracle databases and gauge the complexity and estimate the efforts required for a migration

  • Determine the best migration target based on the nature of the application and the type of data and the business logic in the database, and if PostgreSQL or MySQL or any other Open source database suits better as a target database technology for migration

  • Prepare data migration strategies and designs for each project, including plans to avoid downtime when required

  • Lead migration projects and work closely with the database migration teams at Percona so that the project is aligned with the standards set by Percona

  • Train internal teams on the PostgreSQL development skill set and be a single point of contact for our Global Services teams on PostgreSQL development and migration-related assistance

  • Perform migration of PL/SQL code that includes Packages, Procedures and Functions from Oracle to PostgreSQL

Your Experience

  • At least 5 years of experience in performing Oracle to PostgreSQL migrations and in helping clients port applications from Oracle to PostgreSQL with alternate approaches that are open source

  • At least 5 years of experience in writing PLpgSQL and migrating Packages and Procedures from Oracle to PostgreSQL.

  • At least 1 year of experience in writing Oracle PL/SQL code

  • At least 1 year of experience coding in Python or Golang or Java - expertise in bash scripting is a must

  • Knowledgeable in various alternatives for syntax and features only applicable to Oracle e.g. Hierarchical queries in Oracle use CONNECT BY, Oracle uses rownum, etc., so you're able to find the best alternatives in PostgreSQL for various Oracle features

  • Knowledgeable in the target data types in PostgreSQL that suit the corresponding Oracle data types while migrating objects from Oracle

What Will Make You Stand Out

  • You've used migration tools like Ora2PG or Schema Conversion toolkit from AWS

  • You've migrated data from Oracle to PostgreSQL using FDW's or custom tools or existing open source tools. Knowledge on tools that enable continuous replication of data from Oracle to PostgreSQL is a plus

  • Experience with training development and delivery

  • Experience in a variety of complex environments in verticals such as finance, healthcare, government and consulting

  • Cross-over experience with MySQL or MongoDB

  • Project management experience/certifications

This position is for the Americas time zones, and you must be able to work full-time during US business hours. Travel requirement up to 50% as safety regulations permit.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle Database Administrator/Developer Remote


Posted 2 months ago

VIEW JOBS 10/16/2020 12:00:00 AM 2021-01-14T00:00 The Role: Hybrid Oracle Database Administrator and PL/SQL Developer comfortable with installation, configuration, upgrade, instance tuning, SQL tuning, backup & recovery, standby database installation and operation, with the ability to switch the "Production DBA" and "DEV DBA / DEV Ops" hats without jeopardizing data and existing processes. The position is centric around the Oracle databases for data retrieval and updating for both new and existing installations. As part of the database back-office team, you will work on solutions based on Oracle Database which stores and processes tolling system transactions and operations data. The systems are highly available and responsible for millions of micro-transactions per day, and represent the most accurate tolling system in the world. Responsibilities: * Install, maintain, tune and troubleshoot Oracle Databases * Manage the entire SDLC from requirements interpretation, design, documentation, coding, review, testing, release, and maintenance for new installations * Design, install and support various installations for clients * Monitor and tune performance * Work on improvements and data analysis needs * Provide database and system administration and data processing expertise to the development team What's in it for you? * Solving complex problems that improve daily the lives of people around the world * Opportunity to work with cutting edge technologies in a high-growth industry * Career growth and development opportunities * Casual work environment with flexible work hours * Excellent benefits including a no-cost medical insurance option for employee and eligible dependents What we are looking for: * Oracle DBA experience including proficiency administering Oracle databases without the use of a GUI * Experience in a database developer role with strong experience writing effective PL/SQL code including bulk processing operations working with large amount of data, developing complex APIs and interfaces * Oracle RAC experience including installation and initial configuration and troubleshooting * Proficient of Bash scripting on Linux * Oracle database upgrades and patching * Knowledge of Database design and performance tuning, relational database concepts including normalization rules, constraint, relations, transactions processing * Oracle RMAN practical experience with manual and shell-driven backups and restores * Data movement with Oracle Data Pump Export, Import, transportable tablespaces and RMAN cloning * Significant database design experience including data modeling and creation of database objects * Hands-on experience with SQL and PL/SQL performance tuning * Experience developing Oracle Application Express (Oracle Apex) reports and applications * Knowledge of hardware design and configuration (i.e. storage, networking, disk arrays etc.) Our top Candidates will have: * Undergraduate degree in computer science or related field * Experience with Postgres, Git, Python * Knowledge of (micro) transactional or tolling systems * Experience with highly-reliable systems * Experience working in production 24x7x365 environments Kapsch TrafficCom is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, creed, color, national origin, ancestry, marital status or sexual orientation, gender identity or expression, disability, nationality or sex. Kapsch TrafficCom is a drug-free workplace. Kapsch is committed to working with and providing reasonable accommodations to individuals with disabilities. If you require need a reasonable accommodation for any part of the application or interview process, please send an email to ktc.us.jobs@kapsch.net to advise of the nature of your request along with your contact information. Candidates Requiring Sponsorship: Kapsch TrafficCom regrets that presently we are unable to consider individuals for this position who will require sponsorship for employment visa status (i.e., TN, H1-B, OPT, etc.). Unsolicited Third-Party Candidates: Please note that Kapsch TrafficCom does not accept unsolicited resumes/candidates from third-party recruiters that are not engaged and under written contract with Kapsch TrafficCom. Any employment agency, individual or entity that submits an unsolicited resume/candidate acknowledges and understands that Kapsch TrafficCom has the right to hire any applicant at its own discretion without any fee owed or due to the submitting third-party employment agency, individual or entity. For more information, please contact ktc.us.jobs@kapsch.net #DICE Kapsch Austin TX

Lead Database Migration Consultant (Oracle To Postgresql) - Remote