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)
