Lead Administrator L1

5 - 8 years

7 - 11 Lacs

Posted:2 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description


Job Description
CBR - 150K, Location - Pune/Chennai/Hyderabad - DB

Position Overview:**

We are seeking an experienced **DB2 LUW (Linux, UNIX ) Database Administrator (DBA)** to join our team. The ideal candidate will have strong experience in managing and supporting DB2 databases across Linux, UNIX, and Windows environments. As a DB2 DBA, you will be responsible for the administration, performance tuning, backup, recovery, and security of DB2 databases, ensuring optimal performance, availability, and reliability. You will collaborate with development teams, system administrators, and other IT stakeholders to support critical business applications and ensure smooth database operations.
- **DB2 LUW Database Administration:**
- Install, configure, and maintain **DB2 LUW** (Linux, UNIX ) databases, ensuring high availability and performance.
- Create and manage database instances, tablespaces, and other database objects.
- Perform routine database maintenance tasks such as reorgs, runstats, and database health checks.
- Monitor database performance and tune DB2 for optimal efficiency.
- Analyze and optimize **SQL queries** for performance improvement, leveraging DB2 performance tools like **db2pd**, **db2exfmt**, and **db2top**.
- Perform index optimization, query plan analysis, and fine-tuning of DB2 configuration parameters.
- Develop and implement robust backup strategies, ensuring regular and consistent backups of DB2 databases.
- Test and document backup and restore procedures to ensure quick recovery in case of system failure or data corruption.
- Ensure database consistency, integrity, and availability during recovery operations.


- **Database Security and Compliance:**

- Enforce security policies for DB2 databases, including user access control, authentication, and encryption.
- Configure and manage user roles, privileges, and permissions to ensure database security and compliance with company and industry standards.
- Implement database auditing for security and regulatory compliance.

- **Database Migration and Upgrades:**

- Plan, execute, and test database upgrades, patching, and migrations with minimal disruption to business operations.
- Ensure that DB2 LUW instances are upgraded to the latest versions and maintained with security patches.

- **Capacity Planning and Resource Management:**

- Monitor and forecast database growth, advising on hardware and storage requirements.
- Ensure optimal resource allocation for CPU, memory, and disk usage to support business-critical applications.
- Recommend and implement solutions to scale DB2 environments based on performance needs.

- **Automation and Scripting:**

- Develop and maintain automation scripts (e.g., shell scripts, SQL scripts) for routine administrative tasks such as backups, health checks, and database maintenance.
- Use DB2 automation tools (e.g., **db2look**, **db2move**) to simplify common database administration tasks.

- **Database Troubleshooting and Incident Resolution:**

- Troubleshoot database-related issues, including performance degradation, connectivity problems, and errors related to DB2 services or queries.
- Respond to database incidents or outages, identify the root cause, and work to restore service quickly.



Team Management
  • Resourcing
    • Forecast talent requirements as per the current and future business needs
    • Hire adequate and right resources for the team
    • Train direct reportees to make right recruitment and selection decisions
  • Talent Management
    • Ensure 100% compliance to Wipros standards of adequate onboarding and training for team members to enhance capability & effectiveness
    • Build an internal talent pool of HiPos and ensure their career progression within the organization
    • Promote diversity in leadership positions
  • Performance Management
    • Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports.
    • Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below
  • Employee Satisfaction and Engagement
    • Lead and drive engagement initiatives for the team
    • Track team satisfaction scores and identify initiatives to build engagement within the team
    • Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team
    • Exercise employee recognition and appreciation




Mandatory Skills: Oracle Database Admin .
Experience: 5-8 Years .

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Wipro logo
Wipro

Information Technology & Services

Bengaluru

RecommendedJobs for You