Datastage Administrator Resume Samples

Description :

1. Established for Master Data Hub MDH project to combine customer data integration, enterprise application integration, data warehousing, master data management, and business intelligence capabilities and validated different applications of IS 8. x suite.
2. Upgraded and configured all the tools from IIS Information Server 8.1 base version to Fix Pack 1->Fix Pack 1a->Fix Pack 2 and then to 8.1 on different tiers.
3. Installed, Configured, and Administered DB2 9.5 Metadata Repository Database and WebSphere Application Server Configured external validation to validate end-user data before updating or adding transactions.
4. Customized code tables & error messages. Managed extensions within the framework to extend data elements or extend the behavior of existing transactions.
5. Performed tracing and monitored logs files via The Transaction Audit Information log (TAIL).
6. Configured InfoSphere MDM Server Messaging Adapter using WebSphere as the application server and WebSphere MQ as the JMS provider.
7. Configured .odbc.ini, dsenv, up config, DSParams, uvodbc, and config files at both engine and project levels.

Experience

0-2 Years

Level

Entry Level

Education

BCS

Description :

1. Worked as Administrator for DataStage and Resolved user's day-to-day Application, Server, and Component related issues.
2. Maintained engine, and resource nodes including files system and user management.
3. Configured parallel engine, database connectivity in the parallel environment, and access to ODBC sources.
4. Performed administration tasks like creation/deletion/migration of new projects, roles, users, privileges, role setup, connectivity, security, the configuration of projects, creating or updating users and groups, mapping credentials, configuring DSN and TNS entries, parallel, compiler, reporting, operator and user-defined environment variables in Prod, Stage, Test and Dev environments.
5. Applied fix packs, patches, and service packs as required to keep the DataStage environment up-to-date.
6. Used ISTOOL to migrate job objects between different environments in IS Manager.
7. Implemented procedures for maintenance, monitoring, backup, and recovery operations for the HA-enabled Information server 8.5.

Experience

7-10 Years

Level

Consultant

Education

BCS

Description :

1. Installed, configured, upgraded, patched, and maintained MS SQL, Oracle, PostgreSQL, NoSQL (Mongo DB & Apache Cassandra), MY SQL, and DB2 databases.
2. Involved in Data Modelling, Database Design, tuning, troubleshooting, and performance monitoring of Database servers.
3. Implemented, configured, and managed to cluster (RAC), mirroring, replication, Log Shipping, Data Guard, ASM, Golden Gate, Grid Infrastructure, Master & Slave replication, and Always on Failover.
4. Handled issues SSAS, SSRS, SSIS in Business Intelligence, SQL*Loader, TOAD, SQL *Plus, SQL Developer, and ETL tools (Informatica, OBI, Tableau & Cognos).
5. Wrote, tuned, and troubleshoot Power Shell, T-SQL, and PL/SQL scripts.
6. Applied experience in IIS, Dot.Net, Azure(Cloud), and Oracle e-business suite.
7. Setup and supported deployment of IBM Datastage V8.1/V8.5 on IBM-AIX environment. Experienced migrating between 8.1 and 8.5.

Experience

5-7 Years

Level

Executive

Education

BCS

Description :

1. Performed administrative activities such as Project/User creation, Roles Management, Import and Export projects, database configuration setup, and dataset management.
2. Worked with other Database and Unix administrators to resolve any open issues.
3. Administrated and maintained a DataStage shared environment.
4. Monitored the InfoSphere suite (Data Stage/Quality Stage) servers and Killed/assisted release job locks, shared memory locks, and hung processes.
5. Created and maintained database standards and policies and Supported database design, creation, and testing activities.
6. Managed the database availability and performance, including incident and problem management.
7. Defined and implemented event triggers that will alert potential database performance or integrity issues.

Experience

2-5 Years

Level

Executive

Education

BCS

Description :

1. Provided technical expertise, direction, and development support for the ETL development team as well as support to the developers.
2. Provided technical subject matter expertise wherever required and Ensured proper communication and quick resolution as a crisis manager. 
3. Planned and scheduled Changes, Coordinating with different stakeholders. Performed RCA for Major Incidents related to the tower Follow quality/security process defined for the engagement. 
4. Performed Trend analysis, identify the top few incidents, and work with respective teams/individuals to minimize the incidents, Hardware troubleshooting & Vendor coordination Prepare Weekly and monthly status reports. 
5. Participated in business meetings with various stakeholders on a need basis and Took corrective actions based on customer satisfaction surveys. 
6. Worked on service improvement programs and  Effort estimation/reviews on a need basis for new projects and Training of new team members. 
7. Worked on Knowledge acquisition and updates to related documents.

Experience

7-10 Years

Level

Consultant

Education

BCS

Description :

1. Experienced with scripting languages (Python, PowerShell.) and Experienced building automation jobs for monitoring, alerting, and deployment processes.
2. Experienced leading incident resolution and problem management. Experienced in application testing, release management, and support activities.
3. Familiared with IBM IIS tool (version 11.7) DataStage, FastTrack, IGC, and IA o Excellent problem-solving and troubleshooting expertise.
4. Worked with Linux/scripting o IBM IIS installation/migration experience.
5. Developed DataStage installation and support guides that are consistent with IT security policy.
6. Provided third-level support regarding DataStage product-related issues.
7. Developed new tools and processes to ensure the effective use of DataStage products.

Experience

7-10 Years

Level

Consultant

Education

BCS

Description :

1. Experienced in concepts of DWH. Experienced with cloud next step is moving to the cloud. Worked in international cooperation with many stakeholders.
2. Designed and sized the environment. Installed patches when required.
3. Monitored and analyzed the audit usage data to ensure the optimal usage and efficient performance of the infrastructure.
4. Worked with the application administrators and development teams to ensure the shared environmental resources are optimally utilized.
5. Provided infrastructure operations support and administration of the 11.5 and 11.7 DataStage environments. Set up and tested new installations of DataStage, QualityStage, and Information analyzer.
6. Monitored the InfoSphere suite (Data Stage/Quality Stage) servers and Assisted release job locks, shared memory locks, and hung processes.
7. Applied fixes, patches, and service packs as required and Ensured infrastructure and application stability through preventative maintenance, monitoring, troubleshooting, and implementing long-term solutions.

Experience

10+ Years

Level

Senior

Education

BCS

Description :

1. Supported and troubleshoot production incidents/problems, optimizing performance.
2. Provided technical expertise and development support for the ETL development team.
3. Maintained the Info Sphere environment primarily for the Data Stage (ETL) technology stack, including; product upgrades & maintenance, data cycles, change control, code & configuration promotion, performance management, administrative support, system access control support, build & release support, and supporting audit practices.
4. Worked with offshore Support when problems involve Data Stage Application and Unix Server issues.
5. Published Datastage development standards and best practices and Assists with L2 and L3 production issues and works directly with vendors on patching and problem records.
6. Maintained regular environment monitoring processes and procedures and was Experienced in integration with SAP connectors.
7. Improved business performance. Assessed market potential and key trends.

Experience

2-5 Years

Level

Executive

Education

BCS

Description :

1. Engaged in the performance and optimization of DataStage applications at a job level and Worked with other team members to work with and understand issues and troubleshoot.
2. Drove toward the achievement of results in a manner that focuses on service, and value provided to clients.
3. Demonstrated a deep understanding of DataStage technologies and trends that could impact the field and the business.
4. Understood technical concepts required for specialized fields and encourages and supports others to perform their jobs more effectively (e.g., provides advice, tools, and/or resources).
5. Built database systems of high availability and quality depending on each end users specialized role.
6. Designed and implemented databases in accordance to end users' information needs and views.
7. Defined users and enabled data distribution to the right user, in the appropriate format, and in a timely manner.

Experience

7-10 Years

Level

Consultant

Education

BCS

Description :

1. Planned and oversaw the technical transitions between the development, testing, and production phases. 
2. Facilitated change control, problem management, and communication among data architects, programmers, system analysts, and functional users.
3. Monitored the platform and respond immediately to component failures and ensure 24/7 system availability.
4. Worked with Vendor to coordinate patch installations, upgrades, and IIS support packages.
5. Coordinated backup and restore activities for the platform and Contributed to IIS DataStage standards, policies, and procedures.
6. Performed database housekeeping, such as tuning, indexing, and Administering database objects to achieve optimum utilization.
7. Monitored usage, transaction volumes, response times, and concurrency levels.

Experience

7-10 Years

Level

Consultant

Education

BCS