Senior Oracle Database Administrator

ABOUT THE ROLE:

• The Senior Oracle Database Administrator role designs and develops robust and reliable database management systems that are secure reliable meet the organizations needs. They will develop technical platforms using modern tooling build systems and processes for operations and maintenance that facilitate production needs and speed application development. By doing so they bring significant value to the organization by ensuring that business operations run smoothly and efficiently and change can be efficiently performed and managed. The incumbent works collaboratively with crossfunctional teams that include developers data analysts data scientists business analysts and other relevant stakeholders within the organization.

WHAT THE ROLE WILL DO:

• Design and develop database management systems standards guidelines and quality assurance for database deliverables.
• Patch and maintain database systems for optimal security and supportability
• Document and communicate database designs to relevant stakeholders and analyze the impact of the data architecture
• Code complex programs and develop logical processes on technical platforms.
• Participate in quality assurance by developing and testing database code in client server environments.
• Adapt business requirements and develop data database specifications and table and element attributes for applications.
• Develop an understanding of the organizations data and storage mechanisms and assist with capacity planning.
• Determine appropriateness of data for storage and optimum storage organization.
• Determine how tables relate to each other and how fields interact within the tables for a relational model.
• Work with stakeholder to define the database Disaster Recovery plan database backup recovery and archiving strategy

Education

• Required
  • Bachelors degree in Computer Science Statistics or Information Systems or in lieu of a degree at least 7 years of experience in the field of database engineering and administration

Skills and Experience

• 46 years of experience in database engineering and administration
• Knowledge and experience with database design implementation documentation and management
• Indepth understanding of database management systems and data structures
• Experience translating business data needs into technical language
• Ability to deal with large pool of data often unstructured coming from disparate sources
• Experience with Oracle relational databases
• Experience with query and coding languages such as SQL PL/SQL Python
• Knowledge and experience in database performance tuning backup and recovery strategies and data security practices

Preferred

• Experience with Oracle 19C and autonomous databases including singleinstances RAC and DataGuard.
• Experience with Oracle 19C and autonomous databases on Oracle Cloud (OCI).
• Experience in supporting some of the following technologies: Oracle SSO OIM OBIEE Data Guard Oracle RAC ASM and Sun Cluster on Linux and Solaris systems.
• Working knowledge of the entire Oracle database and Oracle Applications environment and architecture.
• Expertise withperformance tuning and troubleshooting database slowness with a holistic approach.
• Experience with DevOps tools like Jenkins & Ansible. Additional knowledge on Github and version control would be beneficial.
• Preferable candidate must have senior level Oracle DBA experience

Technical Skills

• Programming Languages
• Database Management Systems
• Software Development Lifecyle (SDLC) Methodology
• Project Management Methodology
• Cloud Technologies & Platforms
• Continuous Integration and Continuous Deployment (CI/CD)
• Data Analysis
• Data Security
• Database Performance Tuning Backup & Recovery Strategies
• Monitoring and Logging
• DevOps Methodology
• Emerging Technologies and Automation Tools