
DB2 Professional
5 days ago
Job Details:
Skill: DB2/FLM
Location: - PAN INDIA
Notice Period: Immediate Joiners
Employee type: C2H
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 pureScale Skills ..
Backup, restore, and roll forward operations
A) Instance monitoring
B) Database alert management
C) Database storage management
D) Access management
E) Remote installation and configuration of the Db2 pureScale Feature
F) Creation and deletion of computing resources
G) Addition and removal of hosts from the cluster manager and shared file system
H) Host system maintenance
I) Topology changes (add or drop members)
J) Topology changes (add or drop CFs)
K) Backup, restore, and rollforward operations within Db2 pureScale Feature.
-
Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full time ₹ 9,00,000 - ₹ 12,00,000 per yearMainframe Development and Support.5 years of Mainframe in Development and enhancement .Worked on production support.Experienced in Mainframe development, Requirement Analysis, Test Strategy & Planning, Data Validation and Defect TrackingHands on on DB2 queries and understanding on the optimization ground.Knowledge on programing languages and mainframe...
-
Hyderabad, Telangana, India HSBC Full timeJob DescriptionJob descriptionSome careers shine brighter than others.If you're looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you furtherHSBC is one...
-
SAP BASIS Professional
2 days ago
Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full time US$ 90,000 - US$ 1,20,000 per yearMore than 12 years of experience in SAP Basis administration with hands on experience and handling large and complex engagements which includes all the flavors of SAP components including both ABAP and Java stacks.Experience in Solution Manger activities. Experience in Windows, AIX, Linux Operating systems Experience in Oracle, SQL, Sybase and DB2...
-
SAP BO Professional
7 days ago
Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full time ₹ 8,00,000 - ₹ 12,00,000 per yearSkill: SAP BOExp: 4 YearsLocation: Pan IndiaBasis SAP Administration, Maintaining BO architecture documentation, administration, upgrade and patching support.Performance Issue Analysis, working experience installing and configuring client connectivity to different databases like SAP HANA, IBM DB2, Oracle, SQL ServerUnderstanding SAP Business Objects (Web...
-
Oracle Web Logic Professional
7 days ago
Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full time ₹ 9,00,000 - ₹ 12,00,000 per yearBachelor's degree in Computer Science, Information Technology, or related field.Proven experience with Oracle WebLogic and AWS cloud services.Strong knowledge of database management systems including Oracle Database, Oracle MySQL Enterprise, Microsoft SQL Server, and IBM DB2.Familiarity with .NET interoperability and middleware integration.Experience with...
-
SAP BASIS Upgrade Professional
7 days ago
Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full time ₹ 10,00,000 - ₹ 12,00,000 per yearMinimum relevant BASIS experience of 5-6 years of Support and Implementation Projects.Should have good knowledge of SAP systems like ECC EHP4 and above, PO, BW, SRM and CRM.Should have SAP system monitoring and troubleshooting skillsWorked on both ABAP and JAVA stacksPerform Daily, Weekly and Monthly BASIS tasksAnalyzing issues of BASIS issues in ABAP and...
-
Mainframe DB2 DBA System Engineer
1 week ago
Hyderabad, Telangana, India Kyndryl Full time ₹ 15,00,000 - ₹ 20,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 RoleAre you...
-
Mainframe IMS System Programmer
2 weeks ago
Hyderabad, Telangana, India Kyndryl Full time ₹ 20,00,000 - ₹ 25,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...
-
Mainframe Developer
4 weeks ago
Hyderabad, Telangana, India Zensar Technologies Full timePosition : Mainframe DeveloperExperience : 4-8 YearsJob Summary :We are seeking an experienced Mainframe Developer with 4-8 years of development experience and a strong background in mainframe technologies. The ideal candidate will be a proficient developer with expertise in Cobol, JCL, DB2, and VSAM. This role is critical for the design, build, and delivery...
-
Infrastructure Engineering Senior Analyst
3 weeks ago
Hyderabad, Telangana, India Manipal Cigna Insurance Group Full timeJob Description- Looking for a resource with Data Archival Solution.- Need to collaborate with our internal customers to deliver an enterprise-level database archival solution.- The candidate will architect, deploy, maintain, and monitor the data archival process.- The candidate is responsible for setting standards, guidelines and best practices for Data...