Sr.DB2 DBA

Job description

Sr.DB2 DBA

Publish Date: Feb 2, 2021

Location: 

Pune, Maharashtra, GB
#job-location.job-location-inline { display: inline; }

Company: Atos

·  "Install, configure, upgrade, and maintain all client databases which include performance monitoring, troubleshooting and client support.
·  Perform changes within Company regulations and security standards.
·  Assist with testing, implementation, and installation of new/improved systems, as well as product upgrades.
·  Attend meetings and interact regularly with management, team, and clients to continuously improve services.
·  Participate in On-Call rotation schedule.

Specific Duties:

·  Responsible for ensuring all database system operational processes are managed according to established service level agreements.

Specifically;

·  DB2 UDB V 9.1 ,9.5 , 9.7 , 10.1 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.1 and DB2V10.5 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.