Manager / Senior Manager (Database)

The Senior Manager/Manager (Database) is a key member of the Group IT Infrastructure Team. He/she will be responsible in the area of DB design, sizing, tuning, support and maintenance. He/she must have an in-depth understanding of the technology, trend and technical components of databases (IBM DB2 and MySQL) and had been working extensively with the application development team.

Senior Manager/Manager (Database) must collaborate closely with a large contingent of others throughout the PSA Group IT and external vendors. The collaboration is both prior to any deployment software & applications and in post-deployment, development of improvements plan or procedures. This demand very high levels of skill in communication and diplomacy, a passion for problem resolution, solution derivation, project management, attention to detail, and a round the clock service orientation.

Responsibilities

1. Design, document, create, and modify server configurations that are highly available and scalable for Databases.
2. Administer, modify & tune existing database configuration to allow it to adapt to the application, to improve its performance and efficiency.
3. Provide advice to the application teams based on in-depth understanding of the technology, trend and technical components of databases (IBM DB2 & mySQL).
4. Design and develop a DB Monitoring solution for the entire Global Terminal Operating System suite of applications.
5. Responsible for Capacity management which includes Capacity analysis, review and planning.
6. Ensure performance, security, and availability of databases.
7. Design, implement, execute and validate backup and DR plans for application infrastructure.
8. Implement patches, updates, and fixes for databases as necessary following established Change Management processes.
9. Provide Level-3 on-call support for database issues.
10. Act as technical liaison for the application deployment teams on projects and support.
11. Planning, implementation and management of the various software environments required for product application development and test as well as customer deployment and support.
12. Work with development vendors and internal staff to achieve objectives.
13. Project management for projects relating to databases.

Education: Bachelor’s degree in IT, Computer Sciences or other relevant fields.

Languages: Strong command in both written and spoken English.

Experience:

• 8-10 years of proven hands-on experience in administering, design, deployment and support of IBM DB2 will be mandatory.
• Experience in IBM DB2 PureScale will be an added advantage.
• 5-6 years of proven hands-on experience in administering, design, deployment and support of MySQL.
• Working experience with virtual teams and offshore development.

Technical Competencies:

• Strong proficiency in IBM DB2.
• Familiarity with IBM DB2 PureScale implementation.
• Familiarity with other databases such as MySQL will be an added advantage.
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM.
• Experience in setting up Master-Slave replication, Multi-Master replication, backup, point in time recovery, high available configurations and disaster recovery in a complex and dynamic production environment.
• Knowledge of de-facto standards and best practices in IBM DB2 and MySQL.
• Strong communication skills and ability to add recommendations on architecture/design decisions that will ensure optimal application performance with IBM DB2 and MySQL.
• Knowledge of limitations in IBM DB2 and MySQL and their workarounds.
• Basic knowledge of Linux operating system (RedHat) and basic commands.

Business Skills:

• Fluent in English.
• Strong analytical and decision-making skills.
• Ability to take pressure and work under tight schedule.
• Organized, analytical and displays a keen understanding of the business priorities and objectives.
• Team motivator, self-starter, logical and deadline oriented.