Senior Datastage Administrator Resume

SUMMARY

I have 5+years of experience in IBM InfoSphere Datastage Administration, and Confidential DS admin domain with special focus on ETL tool like Datastage 9.1, 11.5 and 11.7 Versions worked as Datastage Administrator and support.
5 + years of professional experience as IBM Datastage administrator and support 9.1v and 11.5v and also worked with Confidential Client.
Extensive experience in ETL Analysis, Design, Implementation, Maintaining Standards and Performance Tuning.
Strong Knowledge on Datastage Administrational activities like project creation, user creations, permissions, assigning roles, Datastage health check activities.
Maintenance of all the Datastage environments. (Development to Production Servers).
Stop and start Datastage servers.
Monitor Datastage jobs in all environments, looking into job issue and fixing the job.
Creating and deleting project and taking backup of corrupted project.
Involved in Performance tuning of Datastage Server.
Tuning UV Configuration file, which improves Datastage Performance.
Part of Performance & Capacity team which looks after CPU Utilization and workload of Datastage Server.
Patch installation on server.
Hands on experience in UNIX as a platform with Datastage.

TECHNICAL SKILLS

Operating System: Windows, UNIX

Tools: Datastage9.1 &11.5

Other Tools: Jira and service now

System Design & Development: ETL and database performance tuning, Environment set - up, Maintenance and Enhancement, Performance tuning, Datastage administration and Production support.

PROFESSIONAL EXPERIENCE

Confidential

Senior Datastage Administrator

Responsibilities:

Over 5.5 years of experience in Information Technology.
Extensive Experience in Datastage Administration.
Experience in System Analysis, Design, Development and Implementation of Relational Database and Data Warehousing systems using IBM InfoSphere Datastage 8.7, 9.1 versions.
User/Group creation, Session Management, Log Management in Information Server console.
Installed few patches, bug fixes.
Involved in version upgrade.
Involved and performed code migration from one environment to another environment.
Approving change controls & implementing changes to different production environments.
Creating new Datastage projects & setting up their environment.
Clearing hung processes in grid.
Testing the SFTP connections from source to various destination hosts.
Dumping datasets using Orchadmin utility.
Restart of Datastage Engine during various outages.
Creating/updating entries in odbc.ini & tns.ora files.
Releasing FIFO & session locks for Datastage jobs.
Worked on Datastage corrupted jobs to re import new design.
Adding users to various projects with respective their roles
Good experience in application support and maintenance activities for DWH Projects.
Experience in troubleshooting of jobs and addressing production issues like ENV issues, performance tuning and enhancements.
Project Creation in all environments from Development to Production.
Users Creation and assigning required roles in all environments.
Configuration of different Database connections like SQL, DB2, Kerberos.
Datastage Server Stopping & Starting, as well WAS Services.
Debugging and resolving all Datastage related issues like login, permission & Project Corruption etc.
Health Check activities on different environments.
Monitor all jobs which are running production.
Looked after 15 Datastage Servers.
Migration of projects from older version to new version.
Deployment of jobs from Development to production environment.
We will get on demand request from client need to solve within given period of time.
Maintaining daily monitoring jobs records, with their start time and end time.
Hands on experience in control-M tool.
Having experience in Incident Management, Problem Management & Change Management.
Leading team of seven with 24/7 support to Wal-Mart.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship