Oracle Rocklin , CA 95765
Posted 2 months ago
Solve complex problems related to infrastructure cloud services and build automation to prevent problem recurrence. Design, write, and deploy software to improve the availability, scalability, and efficiency of Oracle products and services. Design and develop designs, architectures, standards, and methods for large-scale distributed systems. Facilitate service capacity planning and demand forecasting, software performance analysis, and system tuning.
We are looking for dynamic, energetic and forward-looking engineers to join our database cloud engineering team. Candidate must have Oracle Database Administration experience as a Site Reliability Engineer or DBA on large production environments. Understand the end-to-end configuration, technical dependencies, and overall behavioral characteristics of large-scale implementation of Oracle database. Responsibilities includes development and implementation of critical test cases, certification of the mission critical technology stacks for cloud integration with focus on security, resiliency, scale, and performance. Partner with development teams and work towards addressing and fixing production issues on cloud, defining and implementing product enhancements. Collaborate with various cloud operations teams to understand the production issues and work towards to create a reproducible test cases in the lab environment to present to the development teams.
Job description
We are looking for dynamic, energetic and forward-looking engineers to join our database cloud engineering team. Candidate must have Oracle Database Administration experience as a Site Reliability Engineer or DBA on large production environments. Understand the end-to-end configuration, technical dependencies, and overall behavioral characteristics of large-scale implementation of Oracle database.
Responsibilities includes development and implementation of critical test cases, certification of the mission critical technology stacks for cloud integration with focus on security, resiliency, scale, and performance. Partner with development teams and work towards addressing and fixing production issues on cloud, defining and implementing product enhancements. Collaborate with various cloud operations teams to understand the production issues and work towards to create a reproducible test cases in the lab environment to present to the development teams.
Detailed Responsibilities
o Design & Develop Highly Automated Multi-Tier/Multi-Stack Stress Test Suites/Workloads for Testing and Certifications
Develop and implement various database life-cycle management flows.
Conduct extensive testing of Oracle database HA, data protection and disaster recovery.
Implement and validate all Maximum Availability Architecture best practices and asses how these helps to prevent, detect, tolerate and repair from various outages.
Work on large engineered cloud environments on OCI and EXaCS
Independently setup and configure large database environments with RAC, data-guard, and Oracle Goldengate.
Independently install, configure, patch and upgrade large database clusters on Linux
o Develop test cases and configurations to simulate application/business critical workloads and usage scenarios.
o Develop and Maintain Test Specs/Plans/Methodologies and then Design, and Implement End-to-End Test Suites/Frameworks simulating Real-world production systems.
Extensive upgrade and Patching testing while simulating production like load scenarios.
Research and Development
o Reviewing production issues and identifying gaps in the test suite and implementing these as test cases. This may include DB Schema Design/Normalization, Data generation, Load generation and Application/Business Logic programming in Oracle SQL, PL-SQL, Perl/Shell/Python and JDBC/JMS or Python.
o Carry-out independent research and review new functionality/features in nextgen Oracle Database releases and other products.
o Performance Tuning and pro-active measurements of future planning.
o Backup & Recovery Strategy.
Log and track product defects (bugs), Collaborating closely with Development teams to resolve problems encountered in these Multi-tier test simulations.
Develop Automation tools, Simulation Apps and Re-usable Framework for efficient System/Stress Testing.
Participate in Product Feature Review, Certification experiments and User Document reviews.
Research and acquire skills on new technologies as needed from time to time
Technical qualifications
Minimum Requirements for this job role
10+ years of Oracle database administration experience on large production environments
Database hands on skills especially around database and system troubleshooting and administration
GoldenGate setup, administration and tuning
RAC setup and administration
Strong Linux/UNIX OS understanding including OS Architecture & Internals (Networking, File Systems, Process/Memory Monitoring/Tuning/Linux Virtualization etc).
Programming/Scripting skills in one or more of below languages is required.
o Scripting
o Programming
Preferred Requirements for this job role
Architect and administrating large mission critical Oracle database systems
Data Guard administration and tuning
Experience on any ERP applications like Oracle E-biz suite, Oracle Fusion Apps or Netsuite
Good written communication skills to create best practice and solutions
Experience in developing test-cases, automation and orchestration
Oracle