drjobs Database Administrator (L2)

Database Administrator (L2)

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Bengaluru - India

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

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 

Qualifications :

  • Bachelors Degree in IT or related field required. 
  • Five plus years related experience. 
  • Familiarity with data warehousing concepts and integration patterns. 
  • Strong troubleshooting and communication skills. 


Remote Work :

No


Employment Type :

Full-time

Employment Type

Full-time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.