PostgreSQL DBA

Compensation

: $94,330.00 - $148,460.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Loading some great jobs for you...





PostgreSQL Database Administrator

My name is Bill Stevens and I have a new six to twelve month plus PostgreSQL DBA opportunity available in Midtown, Manhattan that could be of interest to you, please review my specification below and I am available at any time to speak with you so please feel free to call me.

Please let me know if Midtown, Manhattan could be an option for you.

Due to client confidentiality please call me for the w-2 and corp rates. The rates that are being offered are lucrative and above fair market value. The rates will be for w-2 hourly employees, independent contractors and not third party firms.

The firms Database Engineering team maintains large-scale, high transactional databases with focus on high availability and performance. The firms 25k plus database instances run MySQL, PostgreSQL, Oracle, Db2, and SQL Server. To manage these effectively, they operate a DBaaS (Databases-as-a-Service) platform which empowers developers to manage their own databases.

Responsibilities:

The ideal candidate will collaborate with application owners to develop a seamless process to migrate their schema and data from current Oracle infrastructure to PostgreSQL.

The ideal candidate need to define best practices for migrating and validating data along with schema, functions and PL/SQL procedures.

The ideal candidate also serve as a lead technical resource in the migration and Post migration activities.

The ideal candidate should know Oracle database system inside and out and be a little bit obsessive about automation.

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.

Experience they are seeking:

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.

Position pluses would be the following:

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.

US citizens and those authorized to work in the US are encouraged to apply, sponsorship for this role is not available at this time.

The interview process will include an initial telephone screening.

******This is an onsite position and there is no working remotely.******

Please let me know your interest for this position, availability to interview and start for this position along with a copy of your recent resume or please feel free to call me at any time with any questions.

Regards

Bill Stevens

Director of Technical Recruiting

PRI Technology

Denville, New Jersey 07834

Direct Line: 1- x21

LinkedIn:


Associated topics: data administrator, data analytic, data architect, data engineer, data integrity, data manager, data management, database, database administrator, teradata * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...