EVEviden
DATABASE ADMINISTRATOR
Bangalore ₹50K-7 LPA Posted 19 May 2025
FULL TIME
Sql Tuning
Db2 Udb
Itil
Database Administration
Job Description
- Responsible for ensuring all database system operational processes are managed according to established service level agreements. Specifically; DB2 UDB V 9 , 10, 11 Installations, Configurations and Administration.
- Should have strong experience on High availability (HA) and disaster recovery (DR) experience with DB2 HADR with TSA (Tivoli System Automation).
- Should have strong experience in Database restores including Redirected restores and backup concepts.
- 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.
- Hands-on experience in Table range partition, Multi dimension clustering, Materialized query tables data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions.
- SQL Tuning using db2advisor and db2explain tools.
- Troubleshooting database issues using db2diag, db2pd, db2dart, db2support, db2top.
- Database performance tuning by configuring database and instance Parameters.
- Should have good knowledge on DB2 V10 and DB2 V11 new features.
- Administration of database objects such as indexes, tables, views, constraints, stored procedures.
- Administration of database users.
- Capacity Management and storage management.
- Design, test, and optimize/tune RDBMS components.
- Contribute to design, maintenance, and documentation of integrated database security and components in relation to SOX and SAS70 compliance.
- Review and assess new features or upgrades to existing RDBMS components as well as application database changes.
- For databases that may be supported in the future, reviews product literature to assess RDBMS differences and unique features. When possible, test new technologies and report results.
- Good knowledge of ITIL processes with special attention to - incident, change, problem management, Database growth & capacity management for shared environment.
- Troubleshooting hardware using tools like NetBackup, Avamar, Arago, Ansible.