Job Title: Sr. Data Engineer (Oracle Database Administrator) Job Duties: Design, implement, administer, and optimize enterprise Oracle database environments supporting mission-critical business applications. Perform Oracle Database Administration, Oracle Exadata Administration, RAC & Cluster Administration, and ASM Administration. Manage OLTP, Data Warehouse, and Very Large Database (VLDB) environments. Design and implement enterprise backup and recovery strategies. Configure and manage RMAN backups recovery catalogs, and recovery procedures. Build, configure, and maintain Physical and Logical Standby databases, perform disaster recovery testing, and monitor Data Guard health, transport lag, and apply lag. Implement and support Oracle GoldenGate Classic and Microservices architecture. Lead Oracle database upgrade initiatives. Conduct performance tuning. Perform Operating System Administration. Implement Oracle security best practices, manage security and compliance, and participate in security and remediation and compliance initiatives. Provide 24x7 on-call support for critical production databases.
Specific skills or other requirements: Experience to include 6 years with: Installing, configuring and the administration of Oracle Databases; performance monitoring and tuning databases using AWR, ADDM, ASH, and SQL; leading data center migration and upgrade projects; Oracle Grid Infrastructure; Automatic Storage Management (ASM); Real Application Clusters (RAC); RMAN; Data Pump; GoldenGate; Oracle Enterprise Manager (OEM); Database recovery across enterprise environments; implementing database security, high-availability and compliance controls, including TDE, Database Vault auditing, audit trails, security patch compliance, SOC/PCI controls, Data Guard disaster recovery testing and RTO/RPO assessments; Data Guard Broker; Infrastructure, Cloud, and Automation across Linux (RHEL/OEL), IBM AIX, Solaris, OCI, and AWS; Oracle Exadata administration across platforms and Exadata Database Service on AWS/OCI; EC2, RDS, S3, CloudWatch, and CloudFormation; Shell Scripting; SQL Developer; Toad; ServiceNow; BMC Remedy; PuTTY; SecureConnect; Agility; and CyberArk. Experience to also include 3 years administering Oracle 19c and 1 year administering Oracle 23ai. Oracle Certified Associate (OCA) in Autonomous Database Cloud, Oracle Cloud Infrastructure Foundations, and/or Oracle Database Administrator required. Hours per week/Pay: 40 hours per week plus provide 24/7 on-call support as needed for critical production databases; Pay $137,363 - $145,000 year Address of worksite: 1615 Locust Street, Des Moines, Iowa 50309 Apply to: Reagen Petterson, MidAmerican Energy Company, 1615 Locust St, PO Box 657, Des Moines, IA 50309 or reagen.petterson@midamerican.com. EOE.
This opening is being posted in connection with a future filing of an application for a permanent alien labor certification. Any person may provide documentary evidence bearing on the application to the U.S. Department of Labor, Employment and Training Administration, Office of Foreign Labor Certification, 200 Constitution Avenue NW, Room N-5311, Washington, DC 20210.
MidAmerican Energy Company is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law. Employees must be able to perform the essential functions of the position, with or without an accommodation. MidAmerican Energy Company, a Midwest utility, provides regulated electric and natural gas service to more than 1.6 million customers in Illinois, Iowa, Nebraska and South Dakota. The company owns and operates a portfolio of power-generating assets, approximately 61% of which is wind generation.