Senior Database Administrator/Developer

PEOPLECORP AMERICA; Atlanta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading company in the tech industry is looking for a Sr. Database Engineer/Developer to spearhead the transition of their current IAM system. This role entails redesigning database systems from Microsoft SQL to Oracle, ensuring thorough documentation and a clean implementation in the new environment. Ideal candidates will have extensive experience in SQL and Oracle database administration, with the ability to work independently and tackle complex data management challenges.

Qualifications

• 5+ years in Microsoft SQL Database Administration & Development.
• 7+ years in Oracle Database Administration & Development.
• Experience in ETL processes.

Responsibilities

• Transitioning IAM from Tivoli to Sailpoint using Oracle DB.
• Redesigning SQL database tables and designing new Oracle Database environment.
• Data extraction, transformation, and loading to the new Oracle server.

Skills

Microsoft SQL Database Administration

Microsoft SQL Database Design

Oracle Database Administration

Oracle Database Design

ETL

Strong Programming Skills

PL/SQL

C Based Programming Language

IAM Support

Current and emerging technologies

Job description

Job Description
Our Direct Client is seeking an experienced, full-time, on-site, dedicated Candidate, with skills and expertise as described in below requirement.

Responsibilities:
Sr. Database Engineer/Developer needed to transition current IAM from Tivoli using SQL DB to Sailpoint using Oracle DB.

Redesigning current SQL database tables, designing a new Oracle Database environment, and moving the data from SQL to Oracle. The current Client IAM system contains large amounts student data that is implemented in an MS SQL server. This position will be responsible for designing and creating the new Oracle Database Environment for the new IAM, Sailpoint. This position will be responsible for redesigning those database tables in SQL and then extracting, transforming and loading those feeds to the newly designed Oracle server environment. This will require the chosen candidate to dig through existing (undocumented) tables and existing SQL scripts (also undocumented) and begin to understand the data and build a clean (and documented) implementation over in the new oracle environment.

Skill Required/Desired
Microsoft SQL Database Administration - Required 5 Years
Microsoft SQL Database Design/Mapping/Development - Required 5 Years
Oracle Database Administration - Required 7 Years
Oracle Database Design/Mapping/Development - Required 5 Years
ETL - Required 7 Years
Strong Programming Skills - Required 5 Years
PL/SQL - Required 5 Years
C Based Programming Language experience - Required 5 Years
IAM Support - Highly desired
Current and emerging technologies, technological trends, and industry best practices - Required

800 Corporate Drive, Suite 301-500
Stafford, VA, 22554
Phone - 1 [phone]
Fax - 1 [phone]