Job Description & Requirements
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, a high sense of ownership of the problems and requests assigned, a focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with the 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 perform tune all Production/DR, Functional Test and load Test databases, including but not limited to DB2, Oracle, and SQL servers.
- 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/fix-pack patching.
- Responsible for performing and supporting 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 the 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's degree or equivalent with a technical major, such as engineering, data communications or computer science, among others.
- Minimum 3 years of 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 flavors 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.
- Exposure to application development using JMS and RDBMS
- Knowledge in application development using WebSphere and DB2
- Knowledge of 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.
- The ability to work independently on multiple assignments and to work collaboratively within a team is required.
- Perform all duties and responsibilities with minimal supervision.
