Database Administrator - Oracle

Position Summary

In this role you will get the opportunity to work with Clinisys which is a global leader in healthcare information technology. As a part of the Solution Adoption team, you will act as a liaison between the business and its customers and will be responsible to deliver impeccable service by providing high quality software solutions. As an Oracle DBA you will perform essential database functions from development through production including but not limited to database installations, upgrades, troubleshooting, and conversions for both client based and cloud hosted products. Additionally, in this role you will be accountable for documentation for all database functions.

Skillset Requirements

Essential Functions:

• Install Oracle database patches and troubleshoot various issues related to database patching.
• Perform production database health check.
• Detect potential issues that may impact production database operation and resolve the issues.
• Performs database support for both production and development environments, including the installation of databases, back-ups, replication, restores, patches, and upgrades.
• Works closely with product development teams to create and manage product databases, solve problems, and optimize performance.
• Provide product database support for client installations and knowledge of applying security patches on Oracle Databases.
• Ability to configure replication as a part of disaster recovery process.
• Identify and resolve database issues that impact application performance.
• Follows appropriate sign-off and escalation procedures for database changes and version upgrades.
• Document database installations, replications, upgrades, and conversions.
• Stay ahead of the latest database versions and features.
• Qualify latest database versions for application use and recommend and implement emerging database technologies.
• Craft and deliver training materials as assigned.
• Prepare reports or correspondence concerning project specifications, activities, or status.
• All other duties and responsibilities as assigned.
• Strong command of Oracle, Oracle server tools and Oracle Data Guard.
• Advanced knowledge of database security, backup and recovery, performance monitoring and tuning standards.
• Understanding of relational and dimensional data modelling.
• Strong mathematical and statistical knowledge.
• Impeccable attention to detail.
• Develop processes for optimizing database security.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Be available for on-call support as needed.

Knowledge, Skills, and Abilities

• Deep knowledge of Oracle servers/databases and Oracle database development and Oracle Data Guard.
• Deep knowledge in both OLTP and OLAP database designs and administration.
• Proven System Administration skills.
• Innovative thinker with a commitment to improve processes and methodologies
• Strong written and verbal communications skills.
• Excellent client management & client service skills
• Create/Maintain Oracle Database Projects for development.

Job Requirements

• Bachelor's degree in business or computer science, or equivalent education and work experience combined.
• Minimum 3 to 5 years of Oracle database administration and Oracle Data Guard experience.
• Prior exposure to software development processes and/or methodologies.
• Familiarity with on premise and cloud-based implementations.

Preferred or Desired Skills

• Database certification(s) preferred.
• Prior experience with server class hardware, operating systems, and virtualization.