This position is to use his/her acquired knowledge of IBM's DB2, systems analysis, systems design, data analysis, database design, and data processing fundamentals/techniques to successfully develop, design, and implement database systems as well as maintaining DB2 Sub-system performance and assisting with Database employee development.
In this role, the selected candidate will be responsible for planning and organizing database, Database creation, manage users, password security, privileges & roles, performance tuning, restoration, user creation, script running, patch installation etc.
Primary responsibilities of this role would include owning, tracking and resolving database-related incidents and service requests, fulfilling Service Level Agreements (SLAs), reviewing service related reports.
In this role, the selected candidate will be managing Single Global instance environments with maintaining high availability; working with a big DBA team with members in different geographical locations.
In this role, you will be responsible for designing and documenting logical and physical Enterprise Application (OLTP) and Data Warehouse (OLAP) databases and creating the related ETL Design Specifications and supporting documentation.
Position requires working with data warehousing team members, Data Architecture and Integrated Operations teams to ensure the Integrated Data Warehouse compliance are adhered to and the performance and optimization issues are addressed.
Good understanding of concurrent manager, how it works, how to correctly stop and start, configuration of specialized managers, differences between types of manager, and how to diagnose issues in the concurrent manager system.