Add listing Add

DB2 Database Administrator

Place of work Noida
Contract type Full-time
Start date -
Salary ₹8,11,840.25 - ₹20,59,289.75 a year

Job details

Job description, work day and responsibilities

Location
Noida, Uttar Pradesh
 
Benefits
Pulled from the full job description
Paid time off
Provident Fund
 
Full job description
JOB TITLE: DB2 DBA

LOCATION: Noida

SKILL: DB2 DBA

WORK TIMING: Rotational Shifts

JOB DESCRIPTION

A. Database Object Creation and Maintenance:

1. Create, Alter various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes etc.

2. Knowledge and expertise on DB2 utility execution.

B. Data load and migration:

1. Knowledge and understanding of data migration process from VSAM to DB2.

2. Unload data from DB2 tables using UNLOAD utility.

3. Load data from files to Tables using LOAD utility.

4. Unload data from Image copy using UNLOAD or other utilities.

5. Migrate data from one environment to another.

C. Database backup and Recovery:

1. Setup and maintain Image Copy and other DB2 housekeeping jobs.

2. Able to recover data from Image Copy using RECOVER utility.

D. Database access and security control:

1. Follow the security and audit control procedures to GRANT/REVOLKE permissions on database objects.

2. Understand and provide Group level access on DB2 objects to RACF user groups.

E. Support to Application team:

1. Monitor and troubleshoot batch job failures.

2. Handle and resolve all DB2 package related consistency token issues.

3. Assist application team to resolve performance issues for the SQLs and/or Stored procedures.

F. Performance monitoring and tuning:

1. Monitor current active and historical threads using DB2 monitoring tool.

2. Identify potential bottleneck, lock contention in the active or historical threads and troubleshoot them.

3. Check overall Mainframe CPU utilization using SYSVIEW online panels.

4. SQL tuning by rewriting the SQLs or designing appropriate indexes.

Job Type: Full-time

Pay: ₹811,840.25 - ₹2,05+,28+.75 per year

Benefits:

Paid time off
Provident Fund
Schedule:

Day shift
Monday to Friday
Supplemental Pay:

Yearly bonus
Work Location: In person

Company address

India
Uttar Pradesh
Noida Show on map Get directions
Company Name: BeeSolver Technology Pvt Ltd
You will be redirected to another website to apply.
Apply and send CV
Offer ID: #1178106, Published: 2 hours ago, Company registered: 4 months ago

Other offers

2049login
7500 job offers
Senior Accountant: Accounting and Compliance Expert
2049login · Mumbai, IN
2049login
· Mumbai, IN
Accounting and Financial Compliance Specialist "> The ideal candidate will be responsible for the finalization of accounts, ensuring compliance with tax laws, and managing statutory audits. Key responsibilities includ...
2049login
7500 job offers
ERP executive/ MIS
2049login · Mumbai, IN
2049login
· Mumbai, IN
Job Title: ERP Functional Analyst / ERP Specialist Location: Vile Parle West Employment Type: Rotational Shift Experience Level: [Mid-Level / Senior-Level] Department: IT Software Working hours: + hours/day Working Days:...
2049login
7500 job offers
Senior Accounting Associate – General Ledger
2049login · Mumbai, IN
2049login
· Mumbai, IN
At Jacobs, we're challenging today to reinvent tomorrow by solving the world's most critical problems for thriving cities, resilient environments, mission-critical outcomes, operational advancement, scientific discovery ...
2049login
7500 job offers
Account Assistant
2049login · Mumbai, IN
2049login
· Mumbai, IN
Salary Range : Rs. 12000 - Rs. 25000 , based on skills, experience, and interview performance Educational Requirement : 12th Pass Work Arrangement : Work From Office Gender Preference : Both male and female can apply Ski...
2049login
7500 job offers
SAP Accountant
2049login · Mumbai, IN
2049login
· Mumbai, IN
Job Profile Profile - SAP Accountant Salary - up to 4.8LPA Location- Andheri East JOB Description:- We are looking for a skilled SAP Executive with 2–3 years of hands-on experience, particularly in SAP Financial Accounti...
2049login
7500 job offers
Accountant Internship - 5K pm
2049login · Mumbai, IN
2049login
· Mumbai, IN
Job description Location: Mulund West, Mumbai (In-office) Firm: Virag Mehta & Associates (Chartered Accountants) Type: Internship (Stipend-based) Duration: 3 Years Stipend: • Year 1: ₹5,000/month • Year 2: ₹10,000/mo...
2049login
7500 job offers
Fund Accountant
2049login · Mumbai, IN
2049login
· Mumbai, IN
• Role: Fund Accountant • Experience: 8Y • Positions Available: 4 • Working Days : Sunday to Thursday • Base Location: Mumbai / KSA (Onsite Opportunity) • CTC Range: ₹18 LPA (Based on Experience) • Notice Period: Immedia...
2049login
7500 job offers
Internship - Fund Accounting
2049login
2049login
Location Bengaluru, Karnataka   Full job description Quaestor Advisors, an affiliated entity of Arena Investors, provides return-enhancing portfolio and asset servicing for Arena and a select group of partners. Exciting ...
2049login
7500 job offers
Transport incharge
2049login
2049login
Location Bengaluru, Karnataka   Full job description The Candidate must be able to manage the School transport. Driving Two-wheelers & Four Wheeler is required. Other School related jobs need to be performed. Job Typ...
2049login
7500 job offers
Account Executive
2049login
2049login
Location Bengaluru, Karnataka   Benefits Pulled from the full job description Health insurance   Full job description If you are a current employee who is interested in applying to this position, please navigate to the i...
2049login
7500 job offers
Infrastructure and Platform Architect - L3
2049login
2049login
Location Bengaluru, Karnataka   Full job description Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address client...
2049login
7500 job offers
Solution Architect
2049login
2049login
Location Bengaluru, Karnataka   Full job description Job Summary: We are looking for a skilled Solution Architect with 7 to 12 years of experience to design, develop, and maintain high-quality back-end systems and applic...
2049login
7500 job offers
Career Counselor(Malaylam/Tamil/Kannada/Telugu speaking only)
2049login
2049login
Location Hebbal, Bengaluru, Karnataka   Full job description Eurowings is a dynamic and growing organization dedicated to providing top-quality consulting and recruitment services. We are committed to helping individuals...
2049login
7500 job offers
Game Design Faculty
2049login
2049login
Location Banashankari, Bengaluru, Karnataka   Full job description Graduation in Game Design, Computer Science, or a related field. Game Development Tools (e.g., Unity, Unreal Engine) Scripting Languages (e.g., Python, C...
2049login
7500 job offers
Interior Designer
2049login
2049login
Location Bengaluru, Karnataka   Benefits Pulled from the full job description Cell phone reimbursement Flexible schedule Commuter assistance Paid sick time   Full job description Position Overview The Site Supervisor pla...
Recommend to friend Share on facebook Print Get route to office