The Senior Database Administrator will be responsible for the design, implementation and maintenance of complex Oracle based solutions and systems.
Primary Responsibilities for the Role
Administration and management of databases in DEV, QA, pre-prod & production environments.
Provide technical expertise on the installation, setup, configuration of database servers, including infrastructure
Pro-active monitoring of databases both from a performance and capacity management perspective.
Performance tuning and optimization of database schema, indexes, stored procedures etc.
Perform database maintenance activities such as backup / recovery, rebuilding and reorganizing indexes.
Ensure that all database releases are properly assessed and measured from a functionality and performance perspective.
Ensure that all database environments are up to date with the latest service packs, patches & security fixes.
Take ownership and ensure high quality, timely delivery of database related projects on hand.
Collaborate with application developers and operations / support teams in a fast-paced environment.
Minimum Qualification and Experience Requirements
BSc (Computer Science) or similar tertiary qualification
Certification in Oracle (OCP DBA 12c or later)
Knowledge and Skills
Expert knowledge and experience of Oracle database technologies including
Oracle database solution architecture design
Oracle RAC
Oracle Enterprise Manager
Oracle backup and DR solutions (RMAN, DataGuard and Standby databases)
Oracle database security
Performance tuning
Strong knowledge of SQL language and PL / SQL
Strong knowledge of Linux and Unix operating systems and environments
Knowledge of Oracle WebLogic server environments is an advantage
Knowledge of Microsoft Windows server environments is an advantage
Knowledge of Oracle Advanced security
Knowledge and understanding of Oracle APEX, ORDS and Tomcat.
Ability to develop in Java or a similar object-oriented programming language
Good at problem solving and troubleshooting
Offsite and onsite implementations of technical projects
Compilation of technical documentation
Able to learn new programming languages
Relevant Experience
Min 12 years working experience in implementing and maintaining Oracle database solutions
Min 8 years working experience on Linux / UNIX based operating systems
Min 8 years development experience of shell / bash scripts, SQL and PL / SQL.
Min 8 years of experience defining and implementing Oracle database standards and procedures.
Demonstrated ability to design and implement complex IT solutions.
Demonstrated ability to implement, configure and customize Oracle database and Linux platform monitoring solutions (eg.
Oracle Management Cloud, Nagios, etc)
Behavioural Traits
Innovative and Creative
Contributes to team success
Quality orientated
Mentors and coaches
Strong interpersonal skills
Self-motivated
Ability to perform well under pressure
Ability to multi-task
Strong research skills
Strong communication skills
Other
Must be prepared to travel
Must be prepared to do after hours work and 24x7 standby support