← Back to jobs

Urgent Need || Database Administrator || Remote || USC or GC Only || 6 - 12 Months C2H ||

DMS Visions

Remote, OR, USA

Posted On: 30+ days ago

Experience: Not specified years

Availability: Remote

Openings: 1

Category: Database Administrator

Tenure: Contract - Corp-to-Corp

Related Jobs

No related jobs found

Description

Hi,

Hope you are doing well !!

I have an urgent position. Kindly go through the Job description and let me know if this would be of interest to you.

Job Title: Database Administrator

Location: Remote

Duration : 6 -12 months C2H

Visa : USC or GC Only

Job Description: We are looking for an experienced Migration DBA/DB Engineer to migrate of our legacy, large database from DB2 platform to PostgreSQL platform. The candidate would be responsible for assessing the current DB2 environment, designing and implementing the migrating strategy and ensure a smooth transition tpo PostgreSQL environment with minimal downtime.

Responsibilities

Very strong hands-on experience with heterogeneous database migration from DB2 to PostgreSQL
Database Design and determine a best approach for Database migration, including data conversion, schema changes and any application modifications with stored procedures, functions etc.
Analyze current query patterns and create an efficient indexing strategy for performance optimization on PostgreSQL.
Develop and execute Migration plan
Migrate Database, schemas, data and permissions.
Test and validate the migrated database for data consistency, data integrity, schema consistency and application functionality.
Troubleshoot, resolve, and document migration issues
Collaboration with Application teams.

Requirements:

10+ years of Strong experience with DB2 and PostgreSQL
5+ years of Database Migration experience, both homogenous and heterogenous.
Experience w/ Data Migration tools like pg_dump or pg_restore or pg_admin
10+ years of DBA experience on Linux based platforms.
Expert skills on DB backup/restore, database monitoring, security, access for both DB2 and PostgreSQL.
Excellent problem-solving and troubleshooting skills.

Qualifications