DB2 Professional
2 weeks ago
Job Description - DB2 DBA with exp range 6-10 Years detail JD below: - Daily management, maintenance, monitoring, tuning and support for DB2 v9.0 and V9.5 databases in UNIX environment (RHEL 5.0 to RHEL 7.2) and windows platforms. - Perform database software installations including database creation, configuration and applying fix packs and migration of databases as per the Patch Applicability Matrix. - Performing weekly offline backups and daily online backups to Disks/TSM and tapes using scripts and manual methods. - 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. - Implementing purging policies over the database servers as per the customer data retention periods. - Installation and configuration of HADR/HACMP on standalone, DB2 pureScale and DPF DB2 servers and performing failover on yearly basis. - Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks - Daily and weekly database Maintenance and data movement activities such as backup, reorgchk, reorg, run stats, export, import, load and all related activities for OLAP database. - Provide on-call support in adherence to specific business and customer Service Level Agreements. - Managed database instances for Consolidated Online trading system in DB2 UDB in version 9.7/10.1/v10.5/11.1 on AIX 6.1 and Linux (RHEL 7) servers. - Managed large, mission-critical databases. Interpreted business requirements and recommended solutions. - Installation and configuration of DB2 Database servers for standalone and DPF environments in Linux and 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 - Managing DB2 Security by implementing patch management, password management, license management and GSD across all servers. - Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems. - Responsible for searching various DB2 Fix Packs for v9.7 and v10.5/11.1 and providing assessment about these Fix Packs to the upper management. Accordingly applying various Fix Packs to v9.7 and v10.5/11.1 database servers. - Performing weekly offline and daily online backups and restore functions using Symantec Net Backup. Redirect restored test databases with production databases. Moved databases from one server to another or from existing file systems to new file systems.. - Daily activities include removing deadlocks, transaction log resolution, bottle necks, dropping & re creating staging tables, optimizing complex queries using explain/db2exfmt. - Deployed various scripts on production servers- Backup/Runstats/Log collection/Archive - logs/Locking/WLM/Health Check/Audit logHigh water mark/Diagnostic log/Transaction log/Migration from 9.7 to 10.5.x/11.x. through script.
-
DB2 DBA Professional
2 days ago
Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full timeAt least 12 years Plus experience as DBA.Able to interpret customer needs and translate into understandable written requirementsAble to assemble, analyze and evaluate data to make appropriate and well-reasoned recommendations and decisions to support the business and project teamsAble to engage with application development and support teams.Able to mentor...
-
DB2+NETEZZA
2 weeks ago
Hyderabad, India People Prime Worldwide Full timeAbout LTIMindtreeLTIMindtree is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and accelerate innovation through digital technologies. Powered by more than 84,000 entrepreneurial professionals across more than 30 countries, LTIMindtree caters to over 700 clients. We are a Larsen & Toubro...
-
DB2+NETEZZA
2 weeks ago
Hyderabad, India People Prime Worldwide Full timeAbout LTIMindtree LTIMindtree is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and accelerate innovation through digital technologies. Powered by more than 84,000 entrepreneurial professionals across more than 30 countries, LTIMindtree caters to over 700 clients. We are a Larsen & Toubro...
-
DB2+NETEZZA
2 weeks ago
Hyderabad, India People Prime Worldwide Full timeAbout LTIMindtree LTIMindtree is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and accelerate innovation through digital technologies. Powered by more than 84,000 entrepreneurial professionals across more than 30 countries, LTIMindtree caters to over 700 clients. We are a Larsen & Toubro...
-
DB2 Specialist
4 days ago
Hyderabad, Telangana, India SandVcapitals Private Limited Full time#Connections #Experience #Hiring #DB2SpecialistIDAASystemsProgrammerHi Connections,We are hiring Required Technical and Professional Experience7+ Yrs Experience in IBM Db2 Analytics Accelerator (IDAA) to manage, optimize, and maintain the system.Strong expertise in DB2 database administration and IDAA installation & optimization.Experience with query...
-
DB2 Patch Management
2 weeks ago
Bengaluru, Hyderabad, Pune, India People Prime Worldwide Full time ₹ 8,00,000 - ₹ 16,00,000 per yearRole: DB2 Patch ManagementExperience Required: 58 YearsLocation: PAN IndiaMode: 247 SupportNotice Period Preference : Immediate 30 DaysRole Overview :The DB2 Patch Management professional will be responsible for end-to-end patching of IBM DB2 databases, including fix pack installations, security updates, and HADR checks. The role involves planning, testing,...
-
Mainframe DB2 System Programmer
3 weeks ago
Hyderabad, India 5100 Kyndryl Solutions Private Limited Full timeWho We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The Role As a...
-
Mainframe IMS DB2 System programmer
4 days ago
Hyderabad, Telangana, India SandVcapitals Private Limited Full time#Connections #Hiring #Experience #MainframeIMSDB2SystemProgrammerHi Connections,We are hiring....Required Skills and Experience10+ years of professional experience in IMS and DB2 database administration.BMC COPE and IBM tools for IMS and DB2.Hands-on experience with IMS/DB2 performance monitoring and automation.Establishing policies and procedures pertaining...
-
Mainframe DB2 DBA
3 weeks ago
Hyderabad, India 5100 Kyndryl Solutions Private Limited Full timeWho We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The Role...
-
Mainframe DB2 System Programmer
2 weeks ago
Hyderabad, Telangana, India Kyndryl Full time ₹ 12,00,000 - ₹ 36,00,000 per yearWho We AreAt Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.The RoleAs a...
