Senior Database Administrator at Hansen Technologies

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

Skills and Experience

• Current experience – should be a minimum of 2 year’s experience as an acting Senior Oracle database administrator
• 5 year’s experience as an Oracle database administrator
• 3 year’s 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

Additional, ideal requirements include:

• 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