Job Description

As a key aide to both the IT Infrastructure and Development teams: Support the product roadmap for software maintenance and enhancement such that the quality of software deliverables maintains excellent customer relationships and increases the customer base Lead the team to design, implement, and maintain systems critical to our business functions Coordinate team efforts to plan and manage capacity of database management systems, create standards and procedures, and ensure technical documentation is maintained Participate in the on-call support rotation of DB2 environments on Unix systems troubleshoot database problems and implement corrective measures as required and again, ensure this technical documentation is also maintained. Ensure the team performs review and technical walk-throughs of complex changes Provide guidance to the team members to help build their confidence and skills Represent the team in regional (APAC) system planning meetings with business leads, helping to gain and maintain confidence in our team and teams we collaborate with Last, but not least, help to plan, and oversee migration of on-prem databases to the cloud. Major Job Functions: Responsibilities: Collaborate and communicate with all levels of technical management Translate business requirements and logical designs into working physical database designs working with Global Development teams. Participate in database design discussions with both software developers and DBAs Support environments utilizing DB2LUW (V11.5) both on-prem and in the cloud Install database software and patches, perform upgrades, manage utilities, monitor database performance and recommend enhancements perform trouble shooting, perform tablespace management, and handle user requests Create high availability environments using HADR, Q-Replication, Attunity, Purescale, or other software. Participate in Disaster Recovery exercises and update related documentation Support database systems 24x7x365 on a rotation basis with other team members Assist in the review and audit of database security policies and work closely with the security and auditing teams (internal and external as required). Ensure alignment of procedures, design, and implementations with current IT standards and controls Open and coordinate service requests with IBM Support Collaborate with the team to automate routine tasks Perform change control requests (code deployments) when approved Additional responsibilities may include support of MongoDB, Attunity and other software and other work as assigned. Teamwork Work as part of a team to achieve the departmental standards. Work with other departments and divisions within the organization to identify any process improvements and improve standards, efficiency and profitability. Participate in DBA Team meetings for knowledge sharing and team collaboration of activities and projects Qualifications Typically requires a bachelor\'s degree (in Computer Science or related field) or equivalent, and 10-15 years of related experience. Strong knowledge supporting High availability architecture with relevant experience V11.1 and V11.5 Strong communication skills and the ability to work effectively in a team environment are required Experience of managing multiple RDBMS on large systems Experience on large DB2LUW partitioned (DPF) and HADR database implementations Purescale is a plus Experience in review of Access Plans to explain and make recommendations Experience in monitoring and tuning database environmentsDB2 databases (V11.1, V11.5), MongoDB (a plus), Attunity (a plus), pureScale (a plus) Experience in data movement and utilities: exports, imports, loads, reorgs, runstats, and other OpsApplication dba activities Strong skills in system activities such as applying fixpacks and managing DB2 upgrade activities Strong skills in backup and recovery procedures. Knowledge of federated databases Adaptability: Ability to adapt to multi-lingual and multicultural environment, additional language skills are a bonus. Ability to learn. Ability to handle conflicting priorities Receptive to change. Ability to communicate with business users at all levels Analytical skills Self-motivated and pro-active Experience of working in high pressure results oriented organization Additional Information Identifying who has access to the database Helping build the structure and design of the database Implementing security measures for the data Restoring lost data Building test versions and testing for bugs Merging databases when necessary Updating systems when necessary and creating data backups Continually monitoring database systems \' DB, DR, CRP Experian Careers - Creating a better tomorrow together

Monster