Tata Consultancy Services
Perform DB2 upgrades, migrate from older version to newer version DB2, reviewing the enhancements and activating the function level, make online and offline system parameter (DSNZPARMs) changes.
•Should have good knowledge on SMP/E RSU maintenance process (Receive/Apply/Accept/Restore), applying maintenance through SMP/E
•Installation and management of DB2 and associated third party products.
•Configure and manage DB2 in a parallel sysplex environment.
•Develop innovation, strategies, processes and best practices in software management.
•Coordinating with application team for design related issues, object changes.
•Experience with DR (Disaster Recovery), adhere to process and security compliance
•Experience in Online utility: Running Reorgs, unload, load and Runstats, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities and troubleshooting restricted object to RW.
•Ensure integrity, availability and performance of DB2 database systems by providing technical support and Maintenance.
•Ability to craft and alter of DB2 object according to custom's requirement (Ex: Database, Table space, Table, Index, etc.)
•Generate reports for performance analysis when required, run explain for the queries identified and review the results, perform SQL tuning if required.
•In-depth knowledge on monitoring the application threads, tuning the SQL queries, making modifications to the query for better performance.
•Installing third party tools in DB2. Applying maintenance and providing support for those tools.
•Troubleshoot and solving production database issue.
•Good hands-on experience with DB2 command interface (familiar with other command), Stop/Start Databases, display command, cancel thread and term utility
•Proficient in Stand-alone utilities: DSNJU003 and DSNJU004, DSNJ003 to change DB2 BSDS, DSNJU004 to print BSDS. Trained with DSN1COPY.
•Ability to provide Grants to users for appropriate groups/authorities, familiar with DB2 privileges.
•Working knowledge of SQL, knows to use query to check catalog table and find necessary details for system usage
•Experience with replication from Mainframe to other RDBMS is a plus.
•Experience on tools like Log analyzer, BMC Apptune, Catalog/Change manager, BMC utiities, CA sysview for DB2, QMF , Omegamon is an advantage.
About the company
Tata Consultancy Services is an Indian multinational information technology services and consulting company headquartered in Mumbai, Maharashtra, India with its largest campus located in Chennai, Tamil Nadu, India. Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000. Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility. An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.
#J-18808-Ljbffr
Tata Consultancy Services is an Indian multinational information technology services and consulting company headquartered in Mumbai, Maharashtra, India with its largest campus located in Chennai, Tamil Nadu, India. Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000. Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility. An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.
#J-18808-Ljbffr