Responsibilities:

The Oracle Performance DBA is responsible for providing technical expertise in the analysis, design, implementation, and maintenance of an existing high-volume, data intensive system.  Position requires critical thinking and problem-solving abilities to address complex issues involving performance analysis, data migration, information life cycle management, multi tenancy for applications designed for very large databases. 

Candidate must be able to support large enterprise initiatives and help resolve architectural issues in the environment and database infrastructure, as well as develop and maintain an in-depth understanding of the database architecture and the application functionality.

Additional responsibilities may include database design and implementation for multiple products; analyzing performance issues and providing recommendation; proactively diagnosing and resolving problems affecting database; configure and support Golden Gate replications, participates in special projects and performs additional duties as required.

The candidate will work with a cross-section of organizations, including other DBAs, systems engineers, developers and the management team. 

 REQUIRED QUALIFICATIONS:

Strong knowledge of Oracle RDBMS internals including Performance of database and SQL tuning Experience with data migration including Golden Gate replication, Datapump and Cloning of pluggable databases Superior troubleshooting skills, battle-tested in high-volume production environments with experience in OEM, AWR, ASH, SQL Plan Baselines, execution plan and wait event analysis. Administration of VLDB databases covering multi-tenancy, RAC, Data Guard, Partitioning, Compression, Security, Resource Manager, RMAN and other administrative tasks Proficient with automation of maintenance and monitoring tasks and alerting methods Schema design and access control for multi-tenancy and Autonomous databases.

 

The following technical skills are plus:

Hands on SQL and PL/SQL development experience Oracle Certified Professional (OCP) Hands on experience with VPD, Data Vault, TDE, Audit Vault  Operations support as well as Cloud operation experience

Additional experience with Oracle’s Exadata engineered systems is preferred

Personal Competencies:

Excellent verbal and written communication skills Excellent customer focus and issue handling skills Strong analytical reasoning and problem solving skills Strong focus on diagnosing and resolving complex technical problems Strong  teamwork skills and ability to work as member of a global team Results oriented

Detailed Description and Job Requirements

Work with a world-class team to provide enterprise-wide, Oracle Database Administration and Performance support for Energy and Water SaaS application across development and production environments. 

Own database architecture and design for Oracle Utilities Framework products and help resolve complex technical issues.

Establish standard operating procedures for DevOps team, prepare best practices for administration and monitoring of system and arrive at root cause analysis and preventive actions for encountered issues.

Research, evaluate, design, test, recommend, and plan implementation of new or improved RDBMS, ETL and database tools.

Job duties are varied and complex utilizing independent judgment. It requires 10 years of experience supporting relational databases as an Oracle DBA with emphasis on Performance and Data migration rather than Operational support. Exposure and practice at using the RDBMS to optimize performance of large production databases for enterprise use is required. Experience with an organization having a key 24 X 7 reliance on its database is desirable. Requires a bachelor’s degree in computer science or equivalent field.

Career Level - IC4