Database Administrator

About Client:

Our client is prominent Indian multinational corporation specializing in information technology (IT), consulting, and business process services and its headquartered in Bengaluru with revenues of gross revenue of ₹222.1 billion with global work force of 234,054 and listed in NASDAQ and it operates in over 60 countries and serves clients across various industries, including financial services, healthcare, manufacturing, retail, and telecommunications. The company consolidated its cloud, data, analytics, AI, and related businesses under the tech services business line. Major delivery centers in India, including cities like Chennai, Pune, Hyderabad, and Bengaluru, kochi, kolkata, Noida.

Job Title: Database Administrator

Location:

· Experience: 6+

· Job Type :

· Notice Period:

· Project Tenure:

Job Description:

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.