Senior Database Administrator
Hansen, Johannesburg
With 50 years of experience, Hansen is a leading global provider of customer care, billing software and data management systems across 80 countries with specialisations in the utilities and telecommunications industries. With 1500 people across 31 offices globally, our people bring a deep expertise, that drives innovation and ideas to ensure we deliver exceptional products and services.
The Role
The Senior Oracle Database Administrator is responsible for developing and maintaining the Oracle database infrastructure required to support customer care and billing solutions to a global customer base, and provide Oracle best practice guidance to the DBA team and clients. The ideal candidate is a team player that is driven, willing to take initiative, responsible, and eager to learn.
Key Responsibilities
- Installation, configuration, and upgrading of Oracle server software and related products
- Evaluate Oracle features and Oracle-related products
- Establish and maintain sound backup and recovery policies and procedures
- Implement and maintain database security (create and maintain users and roles, assign privileges)
- Take ownership of the data model
- Setup and maintain documentation and standards
- Review changes to the data model and migration scripts performance optimizations
- Maintain multiple Oracle 19c RAC databases
- Manage Production and Non-production database environments
- Perform database tuning and performance monitoring
- Perform application tuning and performance monitoring
- Perform general technical troubleshooting and give consultation to application and development teams
- Work with development teams in writing complex SQL
- Create and maintain PL/SQL modules
- Size, design, and install Oracle databases including Oracle RAC
- Install Oracle Software modules such as Grid Infrastructure stand-alone and cluster
- Collaborate with the development, professional services, and application support teams
- Provide a strategic database direction for the organization
- Plan growth and changes (capacity planning)
- Interface with Oracle Corporation for technical support
- Patch Management and Version Control
- Provide 24x7 support when required
- Adaptable to change and able to work independently and as part of a team
- Current experience should be a minimum of 2 years experience as an acting Senior Oracle database administrator
- 5 years experience as an Oracle database administrator
- 3 years experience with Oracle 12.2 / 19c
- Oracle OCP Certification
- Experience in database change management, and data management through the various stages of the application life cycle
- Experience with SQL and PL/SQL development
- Experience with Oracle DataPump
- Experience with Oracle Linux or Red Hat Linux, Solaris, and Unix compatible operating systems
- Experience with Windows Server 019
- Excellent understanding of the Oracle database, related utilities, and tools
- Excellent understanding of the underlying operating system
- Excellent knowledge of the physical database design
- Ability to perform both Oracle performance tuning and monitoring and Operating System Monitoring
- Excellent knowledge of ALL possible Oracle backup and recovery scenarios
- Excellent knowledge of Oracle security management
- Excellent knowledge of how Oracle acquires and manages resources
- Excellent knowledge Oracle data integrity
- Excellent knowledge of database performance tuning
- Excellent communication skills with management, onsite teams, development teams, vendors, and systems administrators
- The ability to handle multiple projects and deadlines
- Experience with enterprise applications for example customer care and billing applications
- Experience with Oracle 12.2 / 19c Exposure to Agile and SCRUM methodology
- Grid Infrastructure Certification and/or Dataguard Certification
- Postgres exposure
- Experience with JIRA/SMAXs/ADO Incident / Change management systems
- Development Tools SQL Developer, Enterprise Manager, SQL *Plus, SQL Loader
- Operating Systems - Windows, UNIX(HP/UX, AIX, Solaris, Linux)
- Unix administration (basic knowledge)
- Experience using Microsoft Word, Excel, and PowerPoint
- BCV replication
- Knowledge of system performance tuning
- A stable and rewarding career path working for an established and expanding brand
- Industry competitive salary and benefits package
- Flexible hours and work from home options
- Profit-share scheme bonus
#SA
About Us
Hansen (ASX: HSN) is a global provider of software and services to the energy, water and communications industries. With our award-winning software suite, we help more than 600 customers in over 80 countries to create and deliver new products and services, engage with customers, and control and manage critical revenue management and customer support processes.
We are a culture of persistent problem solvers, together on a journey with our customers striking the right balance between the legacy and future advancements. Striving for infinite progression, rather than the perfect destination, our philosophy is rooted in the belief that incremental innovation and co-development, together with our customers, is the pragmatic path forward rather than over-hyped large-scale disruptions.
