Database Migration Analyst

---

Job description

PSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experienced recruiters who know the IT industry inside and out, and we work with you every step of the way to ensure a smooth and successful transition. PSR Connecting Talent, Crafting Success.

Database Migration Analyst

The selected candidate will work a hybrid schedule consisting of onsite work in Atlanta, Georgia as directed.

Job Description:

We are seeking a qualified candidate for the role of Database Migration Analyst. The Data Migration Analyst will perform the analysis to migrate DB2-LUW data to a PostgreSQL environment. The candidate will play a crucial role in planning, executing, and validating data migration, ensuring data integrity is accurate. The candidate will develop and execute data migration strategies, including data cleansing and validation processes to ensure data quality; the candidate will create complex SQL scripts and stored procedures for ETL process. The candidate will work with Application Development SME s to ensure data is mapped properly and ensure the ETL process is optimized. The candidate will maintain documentation and status on a SharePoint site.

Qualifications:

Bachelor's degree in a related field from an accredited college or university AND Four years of related experience OR MASTERS degree

OR Two years of experience at the lower-level Database Migration Analyst position equivalent.

Required Skills:

Five years experience with data migration processes.

Five years experience with SQL and creating Stored Procedures

Three years experience with a relational database, such as DB2, SQL Server.

One years experience with PostgreSQL

One years experience with DBeaver Tool or IBM Data Studio

One year s experience with Erwin Data Modeling Tool

One years experience with Microsoft Windows Server.

Desired Skills:

Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities.

Strong knowledge of Unemployment Insurance (UI) Benefits and Tax.

Strong knowledge of data mapping process and best practices

Personal Qualities:

Be innovative, energetic, energizing, flexible and eager to learn. Excellent work ethic, attention to detail, ability to work in a highly collaborative, collegial, multidisciplinary fast paced team environment. Excellent analytical skills with the ability to manage multiple priorities and requests. Excellent communication and interpersonal skills. Ability to work independently and meet requested deadlines promptly.

<!– job description page –>