Datastage Administrator Resume
4.00/5 (Submit Your Rating)
CAREER OBJECTIVE
To work in an environment that is conducive for effective utilization of my experience in Data warehousing (ETL) and promoting further knowledge acquisition, thereby contributing to the growth of the organisation and myself.
SUMMARY:
- 2.8 years of IT experience, working with the Data Warehousing (ETL ) and Unix administration
- Proficiency in IBM Datastage 7.5/8.1 administration activities, Unix - shell scripting, Tableau Administration 10.5, which arrays from installation on various environments to ensuring proper functioning and availability of the environment 24X7 for the concerned teams.
- Apart from Datastage administration I got a chance to do some unix scripting and also work on Tableau Administration and Tableau Development.
TECHNICAL SKILLS:
Category: IT/Data warehouse(ETL)
Operating system: UNIX,LINUX,WINDOWS XP
Tools: Datastage 8.7/8.1/7.5, CONTROL M, Git Hub(version control), Git Lab, Succeed, Service Now, Tableau 10.5, Tableau Desktop Professional 10.1
Database: Oracle 10g
PROFESSIONAL EXPERIENCE:
Confidential
Datastage Administrator
- Install and deploy Information Server 8.1.
- Install fix packs and patches 8.1.
- Backup and restore of Information Server.
- Configuring the authentication registry (configuring LDAP/OS registry for other components).
- Troubleshooting Datastage users login issues.
- Create Information Server users and groups.
- Configuring Suite Users and Groups.
- Configuring Datastage credentials for Engine users.
- Restart information server.
- Check for running Information Server processes.
- Configure and manage sessions.
- Release Information Server job locks.
- Delete Datastage jobs from XMETA and UV repository.
- Create and modify parallel configuration files.
- Create, Configure and delete Datastage projects.
- Configuring Engine environment variables.
- Manage data sets.
- Configure the Engine to gather and process operational metadata.
- Use the Multiple-Job Compile utility to compile batches of Datastage jobs.
- Configuring the Engine to connect to databases using direct API connections and ODBC drivers.
- Monitor the Datastage job log.
- Use the Datastage and Quality Stage Operations Console.
- Manage workload.
- Archive and package metadata assets using Istool.
- Deploy and manage metadata assets using Information Server Manager.
- Installing grid enablement toolkit.
- Installing loadleveler (Resource Manager).
- Enabling and disabling the compute node using qmod - e and qmod - d commands.
- Preparing script for automating backup (using Istools)
- Making changes in different configuration files .
- Preparing script for clearing &PH& directory and using datastage command line(dsjob,dsadmin)
Tableau Administration
- Add users
- Upgrade server software
- Provide Tableau support to users
- Enforce policies; assist users with workflows
- Create/Modify/Manage server task schedules
- Run cleanup and create backups of the database
- Add/Edit Sites and corresponding administration rights (System vs. Content)
- Implementing user level security to restrict the data by group level and user level.
- Monitor server activity/usage statistics to identify possible performance issues/enhancements
- Work with program manager as necessary regarding issues such as server down-time, versioning
- Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections
- Provide 24X7 operational support for al production related issues, troubleshooting and system maintenance and ensured maximum uptime of servers.