Database Administrator (L2)

Manage Informatica Pipelines in SQL Server and Oracle DB environments, providing expert-level support and ensuring high availability and performance.

Responsibilities:

• Schedule and maintain various scripts for Informatica maintenance like backups, update statistics for the Informatica repository, regular recycles and removal of old logs.
• Informatica Server maintenance including trouble-shooting server issues and performance monitoring & tuning.
• Ensure all production ready scheduled processes are in place after monthly Windows Server updates
• Setup right connections to the right environments.
• Responsible for managing Informatica Services like the Repository Service and Integration Service.
• Responsible for importing all sources and targets.
• Extensively work with Repository Manager, Designer, Workflow Manager and Informatica Monitor.
• Apply Informatica PowerCenter software installation/upgrades and hot-fixes
• Maintain and support the servers the SAS application utilizes, includes driver installation, software patch upgrades, and troubleshooting any issues reported from the user community.
• Keeping the quarterly address updates from USPS up to date on the Dataflux side
• Assisting users of SAS with integration of code between DEV/TST and production
• Assisting users of Dataflux with integration of code with Informatica Mappings
• Migrate code using various methods like folder copy, deployment groups and XML files.
• Deployments to environments like TEST and PROD.
• Support to the ETL team of 10-12 developers
• Support the QA team of 4-6 testers
• Communicate often with DBAs and Network team
• Assist with design of mappings, sessions, mapplets, worklets and workflows.
• Create and conduct formal internal training sessions for ETL developers
• Install and configure client components on users’ desktops
• Help conduct interviews for potentially new IT/ETL staff
• Responsible for creating and maintaining various documents like Mapping/Session naming standards, Work assignments for reference and troubleshooting purposes
• Responsible for ensuring compliance with applicable laws, regulations and company policies across areas of organizational responsibility