Db2 Database Administrator (Thiruvananthapuram)

2 - 3 Years - 1 Opening - Trivandrum Role description: Key Responsibilities: - Database Management & Maintenance: - Install, configure, and upgrade DB2 database software on platforms such as z/OS and LUW. - Manage database instances, schemas, and database objects (tables, indexes, stored procedures). - Perform database backup, recovery, and disaster recovery using DB2 tools. - Performance Optimization & Monitoring: - Monitor database performance and optimize queries, indexes, and configurations. - Diagnose and resolve performance bottlenecks and connectivity issues. - Implement and manage database security, including user access control and auditing. - Collaboration & Support: - Support database-related issues during development, testing, and production phases. - Review SQL code to ensure performance optimization and adherence to standards. - Capacity Planning & Reporting: - Monitor database growth and plan for capacity requirements to align with business needs. - Analyze system usage and recommend scaling or upgrades. - Generate regular reports on database health, performance, and usage metrics. - Compliance & Documentation: - Maintain detailed documentation of database configurations, processes, and procedures. Qualifications and Skills: Required Skills: - Expertise in IBM DB2 database administration on z/OS or LUW platforms. - Proficiency in SQL, performance tuning, and database optimization techniques. - Experience with DB2 utilities (e.g., RUNSTATS, REORG, LOAD, UNLOAD). - Solid knowledge of backup, recovery, and disaster recovery strategies. - Understanding of database security and compliance best practices. Preferred Skills: - Experience with database replication and high-availability solutions (e.g., HADR). - Knowledge of automation tools and scripting languages (e.g., Shell, Python). - Familiarity with monitoring tools (e.g., IBM Data Studio, third-party solutions). - Exposure to DevOps practices and database integration within CI/CD pipelines. Educati .