6 - 11 years
12 - 22 Lacs
Posted:3 months ago|
Platform:
Work from Office
Full Time
Daily management, maintenance, monitoring, tuning and support for DB2 v11.0 and V11.5 databases in UNIX environment (RHEL 5.0 to RHEL 7.2) Perform database software installations including database creation, configuration and applying fix packs and migration of databases as per the Patch Applicability Matrix Responsible for application SQL Query tuning, database parameter tuning, operating system tuning, memory tuning Database Backup/Recovery on databases and file system backups. Redirect Restore to move application from Development, QA and Production. Installation and configuration of HADR/HACMP on standalone, DB2 pureScale and DPF DB2 servers and performing failover on yearly basis Provide on-call support in adherence to specific business and customer Service Level Agreements Installation and configuration of DB2 Database servers for standalone in AIX operating systems Performing table space re-balancing for ensuring the equal data distribution across all the data mounts and applying compress methods on tables for storage savings. Designing appropriate Database configuration parameters and tuning buffer pools for better optimised database performance Separating the file systems enforced the UDB database standard practice and it also simplified table space and file system maintenance Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems Daily activities include removing deadlocks, transaction log resolution, bottle necks, dropping & recreating staging tables, optimizing complex queries using explain/db2exfmt logs/Locking/WLM/Health Check/Audit log /High water mark/Diagnostic log/Transaction log/Migration from 9.7 to 10.5.x/11.x. through script
Tata Consultancy Services
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
My Connections Tata Consultancy Services
Information Technology and Consulting
500,000+ Employees
2710 Jobs
Key People
Pune, Bengaluru, Hyderabad
12.0 - 22.0 Lacs P.A.
Chennai, Tamil Nadu, India
3.0 - 8.0 Lacs P.A.
Mumbai, Maharashtra, India
2.0 - 4.0 Lacs P.A.
Bengaluru / Bangalore, Karnataka, India
Experience: Not specified
0.5 - 4.0 Lacs P.A.
Bengaluru / Bangalore, Karnataka, India
Experience: Not specified
0.5 - 4.0 Lacs P.A.
Bengaluru / Bangalore, Karnataka, India
5.0 - 9.0 Lacs P.A.
Bengaluru / Bangalore, Karnataka, India
7.0 - 10.0 Lacs P.A.
Bengaluru / Bangalore, Karnataka, India
5.0 - 7.0 Lacs P.A.
Hyderabad / Secunderabad, Telangana, Telangana, India
5.0 - 7.0 Lacs P.A.
Delhi, Delhi, India
5.0 - 7.0 Lacs P.A.