Contractor, Oracle DBA
New York, NY

Job Description

On our client's team you will collaborate with application owners to develop a seamless process to migrate their schema and data from current Oracle infrastructure to PostgreSQL. You will need to define best practices for migrating and validating data along with schema, functions and PL/SQL procedures. You will also serve as a lead technical resource in the migration and Post migration activities. We expect you to know Oracle database system inside and out and be a little bit obsessive about automation.

We'll trust you to:

* Develop best practices and automated procedures for migrating existing schema including functions, procedures, packages and data.
* Develop end-to-end migration plan from Oracle to PostgreSQL including validation.
* Manage migration projects in collaboration with application owners and DBAs.
* Support existing Oracle infrastructure.
* Mentor application developers on writing efficient queries and designing database schemas.
* Have experience in performance tuning, backup/recovery, and capacity planning.
* Write and maintain scripts to automate complex tasks.

You need to have:

* In-depth knowledge of Oracle version 11/12 including setup, configuration for OLTP, RMAN, Active Data Guard, Streams, GoldenGate, Grid, OLAP, Real application testing, ASM and Query performance tuning.
* Experience with migration of data and schema out of Oracle into PostgreSQL using open/close source tools.
* Knowledge of Oracle internals.

We'd love to see:

* Knowledge of transforming Oracle functions, procedures and packages to PostgreSQL Pl/pgSQL.
* Knowledge of PostgreSQL V10 and V11 including extensions.
* Knowledge of PL/SQL and python programming.

Andiamo is an Equal Opportunity Employer

Andiamo provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Andiamo complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

All qualified candidates are encouraged to apply by submitting their resume as an MS word document including a cover letter with a summary of relevant qualifications, highlighting clearly any special or relevant experience.