Msi Database Administrator

-We are always looking for highly motivated, result oriented team players who share our commitment to teamwork, quality, integrity and mutual respect. If these values of ours are aligned with yours, we invite you to explore career opportunities with us to achieve your professional goal in a diverse environment that embraces technological innovation to meaningfully impact the world around us.
- This is a DB2 / Oracle Server DBA role largely responsible for providing operational database services to the organization, to design, install, monitor, maintain, and performance tune Production/DR and non-production database environments while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of all databases and their accompanying software.- This DBA role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production / test / development systems and proactively escalating any issues that cannot be resolved within the established timeframes.**ESSENTIAL DUTIES AND RESPONSIBILITIES**:

- Monitor, maintain and performance tune all Production/DR, Functional Test & Load Test databases including but not limited to DB2, Oracle and SQL server.
- Own, track and resolve database related incidents and requests and resolve incidents within SLAs,
- Review service-related reports (e.g. database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs
- Respond to database related alerts, escalate and work with vendors and other parties to come up with strategic solutions to recurring problems.
- Developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of the databases and their accompanying software.
- Respond to technical emergencies outside of normal working hours as needed.
- Perform additional duties as directed by the supervisor consistent with rank and position.
- Perform Database deployments in production, including firmware/ fixpack patching.
- Responsible to perform and to support functional and actual disaster recovery exercises.
- Troubleshoot reported incidents and perform impact analysis.
- Review and implement Change Requests; provide consultation to requesters
- Track configuration changes and optimize the performance of databases.
- Perform regular database backup; and perform recovery of database objects as required.
- Proactively monitor resource usage (CPU, Memory, filesystem, Storage etc.) and capacity planning for future needs.
- Work with Application team on database related defects; and Enhancement requests raised by stakeholders.
- Develop and modify technical documentation that describes installation and maintenance standards and procedures.

**QUALIFICATIONS**:

- Bachelor degree or equivalent with a technical major, such as engineering, data communications or computer science, among others.
- Minimum 3 years Database Administration experience and SQL programming experience is required.
- Experience with Database Administration for DB2 (version 10 onwards) / Oracle Server (version 11 onwards).
- Knowledge and/or working experience in other flavours of databases (Oracle, MySQL, PostgreSQL, etc.) will be an advantage.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for DB2 / Oracle Server.
- Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience with backups, restores and recovery models.
- Experience in implementing operational automation using scripts / shell scripting.
- Experience in writing and implementing Stored Procedures, PL/SQL and SQL.
- Experience working with Windows, AIX, Linux and Solaris servers.
- Knowledge in common coding languages like Java, XML etc.
- Experience in data warehousing tools like ETL is an added advantage.
- Good understanding of ITIL practice, especially change management and incident management.
- Draft and maintain database Standard Operating Procedure (SOP) documents.
- Strong problem-solving skills.
- Demonstrated capacity for self-directed learning is required.
- Demonstrated ability to work effectively and collegially with colleagues is required.
- Excellent analytical, organizational and communication skills are required.
- Ability to work independently on multiple assignments and to work collaboratively within a team is required.
- Perform all duties and responsibilities with mínimal supervision.