Notice Period : Immediate to 60 Days

Location : Bengaluru, Mumbai, Pune & Chennai

Experience: 8+ years

Max CTC : 20 LPA

Primary Skills : DB2 UBD/LUW ,

Secondary Skills: My SQL DBA/Oracle DBA

Job Description:

Description:

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.

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

Education and/or Experience:

A Four year degree in computer science or information systems or equivalent experience.

**Minimum of five-six years experience as a DBA in a production and development environment** DB2 LUW is required.

Experience in heterogeneous computing environments required, including platforms that support Windows/DOS and UNIX/LINUX (SUSE preferred). Strong knowledge of Sun Solaris, AIX and Linux environment is a must.

Specific Requirements:

:

Able to identify performance issues and design/implement solutions in an effective manner.
Able to complete assignments that are defined in general terms. Self motivated to direct own work flow in a manner that maximizes results and meets division goals/schedules. Desire to produce high quality, thorough work
Able to prepare and maintain comprehensive and accurate documentation
Able to transfer conceptual knowledge from current skill set in order to quickly develop expertise in new databases, platforms, or networks
Adapt well to changing project and departmental priorities. Able to work scheduled hours and overtime when needed
Strong team orientation, open-minded, able to listen to other's ideas. Good understanding of his/her role, his/her Manager's role, and is able to work well with others
Willingness to develop expertise in other areas. Willingness to actively participate in group cross-training by sharing personal areas of expertise with other engineers

Pluses:

Additional database experience (e.g. Oracle, MS SQL, MySQL, PostgreSQL)

Hiring for Db2 DBA - LUW