Oracle Applications Release Support Engineer / Database Administrator

"Develop, analyze and maintain tools that support and automate processes for hardware or software product release.As a member of the software engineering division, you will analyze and integrate external customer specifications. Specify, design and implement modest changes to existing software architecture. Build new products and development tools. Build and execute unit tests and unit test plans. Review integration and regression test plans created by QA. Communicate with QA and porting engineering to discuss major changes to functionality.Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. Leading contributor individually and as a team member, providing direction and mentoring to others. BS or MS degree or equivalent experience relevant to functional area. Typically seven years of software engineering or related experience needed.*This is a remote/office based position which may be performed anywhere in the United States except for within the state of Colorado.**Oracle is an Affirmative Action-Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veterans status, age, or any other characteristic protected by law.**ORACLE CORPORATION - **Oracle Utilities Global Business Unit (UGBU)**Oracle Applications Release Support Engineer / Database Administrator**Remote Opportunity**_Responsibilities:_*The Oracle 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 backup /recovery, information life cycle management, disaster recovery, 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; supporting multiple lab environments; installing, maintaining, and refreshing Oracle database for development and test environments; performing database patching, upgrade and migration as necessary; analyzing performance issues and providing recommendation based on testing results; proactively diagnosing and resolving problems affecting database; maintaining database configurations in compliance with release management and change management; 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:** Applications Release Engineer* Python / BASH / Perl Scripting* Jenkins - Automation* Agile Methodology - Scrum Meetings* CI/CD Pipeline* Strong knowledge of Oracle /11g/12c/19c internals, from performance troubleshooting from SQL to ASM.* Strong Database Administration and SQL skills* Operating system knowledge (Unix, Linux and/or Windows)* Daily administration activities such as Datapump Export/Import, Database migration/cloning, RMAN, Data Guard replication, backup/restore, patching, maintenance, upgrades, storage layout and access control should be second nature* Hands on experience with OEM 13c, AWR, ASH, SQL Tuning Advisor, SQL Plan Baselines.* Extensive knowledge of high availability database concepts.* Proficient with automation of maintenance tasks using PL/SQL and scripting tools such as shell script, Perl or Python* Superior troubleshooting skills, battle-tested in high-volume production* Hands on experience on RAC, Data Guard and multitenant database* Maintenance and support for VLDB databases* Schema design and access control for multi-tenancy databases.*The following technical skills are plus:** Hands on Experience with Golden Gate* Oracle Certified Professional (OCP)* Hands on experience with VPD, Data Vault, TDE, Audit Vault is a plus* Operations support as well as Cloud operation experience*Additional experience with Oracles 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 support for all products using Oracle Utilities Application Framework and provide DBA services to SaaS development and production environments.Provide product development support. This includes creating primary database storage structures, designing and creating primary objects, modifying database structure as necessary for enhancements or performance, creating/maintaining documentation and standards, establishing application development best practices, monitor and optimize performance of the database, plan for backup and recovery of the database, and allocate system storage and plan future storage needs.Design /develop / maintain database upgrade procedures/tools. This comprises creating/maintaining database-related scripts and programs to upgrade database portion of the Oracle Utility products and the scripts for database support of the development environments.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. Exposure and practice at using the DBMS to optimize performance of large production databases for enterprise use is preferred. Experience with an organization with a key 24 X 7 reliance on its database is desirable. Requires a bachelors degree in computer science or equivalent field.**Job:** **Product Development***Organization:** **Oracle***Title:** *Oracle Applications Release Support Engineer / Database Administrator***Location:** *United States***Requisition ID:** *21000AT1*"