Advantest
Oracle and Microsoft Database Administrator
Advantest, Chandler, Arizona, United States, 85249
Job Description
-The Corporate IT team is looking for an Oracle EBS DBA, who can also support MS SQL Databases, and has experience with Oracle Cloud Infrastructure (OCI).
To manage and maintain our Oracle DB, Application and Microsoft SQL environments across on-premises and cloud platforms. The role involves end-to-end management of Oracle E-Business Suite, Oracle Databases, Microsoft SQL Server, Service-Oriented Architecture (SOA) components, and cloud infrastructure. The ideal candidate will have strong technical expertise in Oracle technologies and cloud administration, with a proven track record of ensuring system reliability, security, and performance.
Requirements:
· Development support and maintenance of Oracle ERP and MS SQL databases.
· Knowledge of the ORACLE Cloud Infrastructure (OCI) and Microsoft SQL, with certification being a plus.
· Knowledge of the ORACLE SOA, ETL, MS SQL, SSIS and Integrations would be a plus.
Qualifications:
· Experience of 5+ years as an Oracle and/or Microsoft APPS/DB Administrator
· Experience in using and supporting OCI, Oracle Cloud Infrastructure, IaaS.
Key Responsibilities:
1.
Oracle E-Business Suite (EBS) Administration:
o Install, configure, patch, and upgrade Oracle E-Business Suite (R12).
o Manage and monitor EBS modules, concurrent managers, workflows, and custom applications.
o Handle cloning, backup, and recovery operations for EBS environments.
o Manage user access, roles, and responsibilities, ensuring compliance with security standards.
o Troubleshoot and resolve application issues in collaboration with functional and development teams.
2.
Oracle Database Administration:
o Administer Oracle Databases (12c, 19c, or later) including installation, configuration, patching, and upgrades.
o Perform database tuning, optimization, and query performance improvements.
o Implement and manage high availability (HA) and disaster recovery (DR) solutions, including Data Guard, RMAN, and GoldenGate.
o Monitor database health, security, and performance using tools like Oracle Enterprise Manager (OEM).
o Conduct regular backups, restores, and data migrations as needed.
3.
Oracle SOA Administration:
o Install, configure, and manage Oracle SOA Suite, including BPEL, OSB, and other middleware components.
o Deploy, monitor, and troubleshoot SOA composites, web services, and integrations.
o Optimize SOA performance and ensure the reliability and scalability of the integration environment.
o Collaborate with development teams to support SOA-based integrations and resolve middleware issues.
4.
Cloud Administration:
o Design, deploy, and manage Oracle Cloud Infrastructure (OCI) and other cloud platforms (e.g., AWS, Azure) hosting Oracle workloads.
o Automate cloud resource provisioning and management using tools like Terraform, Ansible, or OCI Resource Manager.
o Optimize cloud resources for performance and cost-efficiency, ensuring alignment with business needs.
o Manage cloud networking, storage, and security configurations, including identity management and access controls.
5.
Security and Compliance:
o Implement security best practices for EBS, database, SOA, and cloud environments.
o Ensure systems comply with regulatory standards such as GDPR, PCI-DSS, and SOX.
o Regularly apply security patches and manage vulnerability assessments and remediation.
6.
Monitoring, Performance Tuning, and Troubleshooting:
o Monitor system performance and availability, proactively identifying and resolving issues.
o Conduct root cause analysis for incidents and apply corrective measures.
o Fine-tune performance across the EBS, database, SOA, and cloud environments.
7.
Backup, Recovery, and Disaster Recovery (DR):
o Develop and maintain comprehensive backup, recovery, and disaster recovery strategies.
o Perform regular DR drills to ensure readiness and minimize downtime.
8.
Support and Collaboration:
o Provide L2/L3 support for EBS, database, SOA, and cloud issues, coordinating with Oracle Support when necessary.
o Collaborate with cross-functional teams on system integrations, upgrades, and migrations.
Document procedures, configurations, and troubleshooting guides for the IT team.
Office Location: at any Advantest office in the US
Requirements
Minimum Qualifications:
1.
Education:
o Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).
2.
Experience:
o 5+ years of experience administering Oracle E-Business Suite (R12).
o 5+ years of experience as an Oracle Database Administrator.
o 3+ years of experience managing Oracle SOA Suite.
o 3+ years of experience with Oracle Cloud Infrastructure (OCI) or other cloud platforms (AWS, Azure).
3.
Technical Skills:
o In-depth knowledge of Oracle EBS R12 architecture, modules, and workflows.
o Expertise in Oracle Database management, including performance tuning, backup/recovery, and Data Guard.
o Proficiency with Oracle SOA Suite components like BPEL, OSB, and adapters.
o Experience with cloud administration, particularly in Oracle Cloud Infrastructure (OCI), including automation with Terraform or Ansible.
o Strong skills in Linux/Unix environments, shell scripting, and automation tools.
4.
Certifications (Preferred):
o Oracle Certified Professional (OCP) - Database Administrator.
o Oracle Cloud Infrastructure (OCI) Certified Architect Associate or Professional.
o Oracle SOA Suite Certified Implementation Specialist.
5.
Soft Skills:
o Excellent analytical and problem-solving abilities.
o Strong communication and teamwork skills.
o Ability to manage multiple priorities and work independently.
o Detail-oriented with a commitment to continuous improvement.
6.
Work Environment:
o Willingness to provide on-call support and address critical issues during off-hours.
Flexibility to work on weekends or holidays for major updates or incidents.
State of California Development (EDD):
- https://www.ecfr.gov/current/title-41/subtitle-B/chapter-60/part-60-300#p-60-300.5(a)
- § 60-300.5(a)(2)(3)(4) Equal opportunity clause. Details the job posting requirements.
- § 60-300.5(a)(6) Equal opportunity clause. All employment openings includes all positions except executive and senior management, those positions that will be filled from within the contractor's organization, and positions lasting three days or less. This term includes full-time employment, temporary employment of more than three days' duration, and part-time employment.
CCPA Notice for California Residents:
Notice for California Residents: We collect personal information (PI) from you in connection with your application for employment with Advantest America, Inc., including some or all of the following categories of PI: identifiers and personal records (e.g., name, phone number, email address, employment history); commercial information (e.g., if we reimburse you for travel or other expenses during the application process); sensory information (e.g., recorded virtual interviews); professional or employment information (e.g., information provided in your resume and application, such as employment history); non-public education records (e.g., educational institution transcripts and records); and inferences drawn from the above categories of PI. We collect your PI for our purposes, including performing operations related to your potential employment. To view the Advantest Privacy Policy, visit https://www.advantest.com/privacy-policy.html. For additional details or if you have questions, contact us at AAI_privacy.officer@advantest.com.
In providing a safe and healthy workplace for all of our employees, Advantest America, Inc., and its subsidiaries, ("Advantest"), new employment job offers are contingent upon the applicant's provision of a copy of their COVID-19 vaccination document to Advantest America Inc. Human Resources prior to their scheduled start date, subject to any written request for medical or religious accommodations.
Advantest is an Equal Opportunity Employer and embraces diversity in our employee population. It is the policy of Advantest to provide equal opportunity to all qualified applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or special disabled veteran, marital status, pregnancy, genetic information, or any other legally protected status.
The Advantest Way - Diversity, Equity, Inclusion and BelongingAt Advantest, diversity, equity and inclusion are at the core of who we are. We are continuing to build a culture where everyone feels a sense of belonging through our DE I programs initiatives. We strive to have a diverse, equitable and inclusive workplace to enable us to attract and retain candidates that feel a sense of purpose and empowerment. Our commitment to DE I is unwavering and we are steadfast in our mission to continuously foster an environment of respect, trust and transparency. We value diversity and inclusion and believe employees of all backgrounds contribute to our ongoing success. At Advantest, we celebrate and support the needs of our employees regardless of race, color, ethnicity, national origin, religion, age, disability, gender (including gender expression and gender identity), sex and sexual orientation. DE I at Advantest is more than words to us, they are the Advantest Way.
-The Corporate IT team is looking for an Oracle EBS DBA, who can also support MS SQL Databases, and has experience with Oracle Cloud Infrastructure (OCI).
To manage and maintain our Oracle DB, Application and Microsoft SQL environments across on-premises and cloud platforms. The role involves end-to-end management of Oracle E-Business Suite, Oracle Databases, Microsoft SQL Server, Service-Oriented Architecture (SOA) components, and cloud infrastructure. The ideal candidate will have strong technical expertise in Oracle technologies and cloud administration, with a proven track record of ensuring system reliability, security, and performance.
Requirements:
· Development support and maintenance of Oracle ERP and MS SQL databases.
· Knowledge of the ORACLE Cloud Infrastructure (OCI) and Microsoft SQL, with certification being a plus.
· Knowledge of the ORACLE SOA, ETL, MS SQL, SSIS and Integrations would be a plus.
Qualifications:
· Experience of 5+ years as an Oracle and/or Microsoft APPS/DB Administrator
· Experience in using and supporting OCI, Oracle Cloud Infrastructure, IaaS.
Key Responsibilities:
1.
Oracle E-Business Suite (EBS) Administration:
o Install, configure, patch, and upgrade Oracle E-Business Suite (R12).
o Manage and monitor EBS modules, concurrent managers, workflows, and custom applications.
o Handle cloning, backup, and recovery operations for EBS environments.
o Manage user access, roles, and responsibilities, ensuring compliance with security standards.
o Troubleshoot and resolve application issues in collaboration with functional and development teams.
2.
Oracle Database Administration:
o Administer Oracle Databases (12c, 19c, or later) including installation, configuration, patching, and upgrades.
o Perform database tuning, optimization, and query performance improvements.
o Implement and manage high availability (HA) and disaster recovery (DR) solutions, including Data Guard, RMAN, and GoldenGate.
o Monitor database health, security, and performance using tools like Oracle Enterprise Manager (OEM).
o Conduct regular backups, restores, and data migrations as needed.
3.
Oracle SOA Administration:
o Install, configure, and manage Oracle SOA Suite, including BPEL, OSB, and other middleware components.
o Deploy, monitor, and troubleshoot SOA composites, web services, and integrations.
o Optimize SOA performance and ensure the reliability and scalability of the integration environment.
o Collaborate with development teams to support SOA-based integrations and resolve middleware issues.
4.
Cloud Administration:
o Design, deploy, and manage Oracle Cloud Infrastructure (OCI) and other cloud platforms (e.g., AWS, Azure) hosting Oracle workloads.
o Automate cloud resource provisioning and management using tools like Terraform, Ansible, or OCI Resource Manager.
o Optimize cloud resources for performance and cost-efficiency, ensuring alignment with business needs.
o Manage cloud networking, storage, and security configurations, including identity management and access controls.
5.
Security and Compliance:
o Implement security best practices for EBS, database, SOA, and cloud environments.
o Ensure systems comply with regulatory standards such as GDPR, PCI-DSS, and SOX.
o Regularly apply security patches and manage vulnerability assessments and remediation.
6.
Monitoring, Performance Tuning, and Troubleshooting:
o Monitor system performance and availability, proactively identifying and resolving issues.
o Conduct root cause analysis for incidents and apply corrective measures.
o Fine-tune performance across the EBS, database, SOA, and cloud environments.
7.
Backup, Recovery, and Disaster Recovery (DR):
o Develop and maintain comprehensive backup, recovery, and disaster recovery strategies.
o Perform regular DR drills to ensure readiness and minimize downtime.
8.
Support and Collaboration:
o Provide L2/L3 support for EBS, database, SOA, and cloud issues, coordinating with Oracle Support when necessary.
o Collaborate with cross-functional teams on system integrations, upgrades, and migrations.
Document procedures, configurations, and troubleshooting guides for the IT team.
Office Location: at any Advantest office in the US
Requirements
Minimum Qualifications:
1.
Education:
o Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).
2.
Experience:
o 5+ years of experience administering Oracle E-Business Suite (R12).
o 5+ years of experience as an Oracle Database Administrator.
o 3+ years of experience managing Oracle SOA Suite.
o 3+ years of experience with Oracle Cloud Infrastructure (OCI) or other cloud platforms (AWS, Azure).
3.
Technical Skills:
o In-depth knowledge of Oracle EBS R12 architecture, modules, and workflows.
o Expertise in Oracle Database management, including performance tuning, backup/recovery, and Data Guard.
o Proficiency with Oracle SOA Suite components like BPEL, OSB, and adapters.
o Experience with cloud administration, particularly in Oracle Cloud Infrastructure (OCI), including automation with Terraform or Ansible.
o Strong skills in Linux/Unix environments, shell scripting, and automation tools.
4.
Certifications (Preferred):
o Oracle Certified Professional (OCP) - Database Administrator.
o Oracle Cloud Infrastructure (OCI) Certified Architect Associate or Professional.
o Oracle SOA Suite Certified Implementation Specialist.
5.
Soft Skills:
o Excellent analytical and problem-solving abilities.
o Strong communication and teamwork skills.
o Ability to manage multiple priorities and work independently.
o Detail-oriented with a commitment to continuous improvement.
6.
Work Environment:
o Willingness to provide on-call support and address critical issues during off-hours.
Flexibility to work on weekends or holidays for major updates or incidents.
State of California Development (EDD):
- https://www.ecfr.gov/current/title-41/subtitle-B/chapter-60/part-60-300#p-60-300.5(a)
- § 60-300.5(a)(2)(3)(4) Equal opportunity clause. Details the job posting requirements.
- § 60-300.5(a)(6) Equal opportunity clause. All employment openings includes all positions except executive and senior management, those positions that will be filled from within the contractor's organization, and positions lasting three days or less. This term includes full-time employment, temporary employment of more than three days' duration, and part-time employment.
CCPA Notice for California Residents:
Notice for California Residents: We collect personal information (PI) from you in connection with your application for employment with Advantest America, Inc., including some or all of the following categories of PI: identifiers and personal records (e.g., name, phone number, email address, employment history); commercial information (e.g., if we reimburse you for travel or other expenses during the application process); sensory information (e.g., recorded virtual interviews); professional or employment information (e.g., information provided in your resume and application, such as employment history); non-public education records (e.g., educational institution transcripts and records); and inferences drawn from the above categories of PI. We collect your PI for our purposes, including performing operations related to your potential employment. To view the Advantest Privacy Policy, visit https://www.advantest.com/privacy-policy.html. For additional details or if you have questions, contact us at AAI_privacy.officer@advantest.com.
In providing a safe and healthy workplace for all of our employees, Advantest America, Inc., and its subsidiaries, ("Advantest"), new employment job offers are contingent upon the applicant's provision of a copy of their COVID-19 vaccination document to Advantest America Inc. Human Resources prior to their scheduled start date, subject to any written request for medical or religious accommodations.
Advantest is an Equal Opportunity Employer and embraces diversity in our employee population. It is the policy of Advantest to provide equal opportunity to all qualified applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or special disabled veteran, marital status, pregnancy, genetic information, or any other legally protected status.
The Advantest Way - Diversity, Equity, Inclusion and BelongingAt Advantest, diversity, equity and inclusion are at the core of who we are. We are continuing to build a culture where everyone feels a sense of belonging through our DE I programs initiatives. We strive to have a diverse, equitable and inclusive workplace to enable us to attract and retain candidates that feel a sense of purpose and empowerment. Our commitment to DE I is unwavering and we are steadfast in our mission to continuously foster an environment of respect, trust and transparency. We value diversity and inclusion and believe employees of all backgrounds contribute to our ongoing success. At Advantest, we celebrate and support the needs of our employees regardless of race, color, ethnicity, national origin, religion, age, disability, gender (including gender expression and gender identity), sex and sexual orientation. DE I at Advantest is more than words to us, they are the Advantest Way.