Job Description
We are looking for an IBM certified Database Administrator with 5-+ years of experience supporting DB2 Databases on Unix and Windows operating systems.
The candidate must demonstrate solid experience with Incident management, change management, Problem management and solid administration skills to ensure smooth and efficient operation of the supported environment.
The candidate should be able to provide SME level of support to 1st level Administrators within the team.
The job includes working with the various technology teams, developers, vendors, and management of new landscape setup.
The Engineer will be responsible for the administration, installation, configuration, and support of DB2 databases on standalone and clustered environment for multiple clients.
"
Skills"\u2026 Good experience on High availability (HA) and disaster recovery (DR) experience with DB2 HADR with TSA (Tivoli system automation)
\u2026 Good experience in Replication Queue\/SQL
\u2026 Experience in implementing backup and recovery strategies, replication, and database performance tuning on LINUX\/UNIX platform
\u2026 Database migration experience (On premises & Cloud) including various upgrades.
\u2026 Experience in automating database maintenance and database monitoring including operational 24x7 support in troubleshooting.
\u2026 Experience in staging the new DB2 servers builds
\u2026 Knowledge of refresh activities at table level and other DB refreshes in prod\/non-prod environments.
\u2026 Experience in performing database loads and unloads, tablespace containers and resize on tablespaces
\u2026 Good experience in Database restores including Redirected restores and backup concepts
\u2026 Good understanding in performance monitoring techniques and conduct performance checks to ensure the databases, and their associated applications, are continuing to support the existing Service Levels
\u2026 Hands on experience in Table range partition, Multi dimension clustering, Materialized query tables
\u2026 Data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions.
\u2026 SQL Tuning using db2advisor and db2explain tools.
\u2026 Troubleshooting database issues using db2diag, db2pd, db2dart, db2support , db2top.
\u2026 Database performance tuning by configuring database and instance Parameters.
\u2026 Should have good knowledge on Latest DB2 features.
\u2026 Administration of database objects such as indexes, tables, views, constraints, stored procedures
\u2026 Capacity Management and storage management
\u2026 Design, test, and optimize\/tune RDBMS components
\u2026 Excellent understanding of ITIL process (Incident, Change and Problem management processes)
\u2026 Should be flexible to work in 24X7 shift operations
\u2026 Capable of handling escalation independently
\u2026 IBM certified administrator
\u2026 Industry certification in at least one of the cloud technologies
\u2026 Demonstrates strong communication skills (written and oral)
\u2026 Proven ability to work in cross-cultural environments
\u2026 Ability to interact with customers regarding business and technical information and issues
\u2026 Demonstrates strong team building skills - ability to work as a team
\u2026 Identify Root Cause and be able to apply preventive actions for environment specific Problems"
Responsibilities"\u2026 Meets degree\/educational requirements or has equivalent work experience
\u2026 5 to + years' experience in relevant Database administration
\u2026 Able to deal with complex issues involving customers and vendors
\u2026 Strong skills in the administration of DB2 Databases.
\u2026 Well experienced in common Unix and Windows Platforms
\u2026 Perform Installation, upgradation, migration of DB2 Database software's.
\u2026 Support standard software maintenance and application deployments to prod and non-prod environments by following project management office guidelines
\u2026 Demonstrate ability to automate and maintain automation for core job functions
\u2026 Advanced skills in platform administration tasks including installation, patching, clustering, log-shipping, and tuning
\u2026 Ability to work well within a team environment and participate in team projects
\u2026 Perform related duties as required and provide off-hours support for Database related issues
\u2026 Identify Root Cause and be able to apply preventive actions for environment specific problems
\u2026 Available for off-hour deployments and provide 24x7 on-call production support for mission and business critical applications
💡 Quick Summary
Seeking a career-building opportunity? The DB2 Database Administrator position is now open for candidates interested in the Database Administrator sector. This role in India offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
