Join our team! King County’s Business Resource Center (BRC) is seeking a senior level Oracle Database Administrator (DBA) to join the BRC Shared Services Team to perform database administration duties for the county’s Oracle E-Business Suite (EBS) financial system. As a senior level DBA, the successful candidate will monitor and manage the Oracle EBS database and middleware operations to maximize system availability, improve performance and manage back-up and recovery operations. As a member of the DBA team, they will also act as backup DBA to support the PeopleSoft HR/Payroll and Hyperion Budget systems implemented county wide in January 2012. Each of the BRC’s DBAs administer, patch and support Oracle middleware, integration and reporting tools that include technologies like Web logic, BPEL, PeopleSoft Integration Broker and Oracle’s BI Publisher and Discoverer. The county anticipates ongoing evolution of the three ERP systems supported by the Business Resource Center including major system upgrades. Future BRC projects may also include development of data marts/warehouses and implementing advanced reporting capabilities across Oracle EBS, PeopleSoft, and Hyperion. The DBA team will provide support to these initiatives. Our ideal candidate is a good communicator and an intellectually agile problem-solver able to deal with complex concepts comfortably. He or she will be able to retain composure and work well in a team of DBAs. As a member of that team this DBA will work to seek standard practices, participate in cross training and share solutions to facilitate consistent support of the three ERP systems. Why Work for King County? King County offers an outstanding benefits package including employer paid medical and dental benefits, 12 paid holidays, vacation with pay, life insurance, transit passes, and much more. Please visit our website to learn about King County’s commitment to employee’s health and well-being: http://www.kingcounty.gov/employees/ . For questions about this recruitment contact: Margie Viall, at 206-263-1060 or firstname.lastname@example.org
WHO MAY APPLY: This recruitment is open to all qualified applicants. Please also refer to Job Announcement # 2013MV03121 - Oracle Database Administrator Master. Qualified candidates are encouraged to apply for both positions.
The first review of applications for interviews will be on Wednesday, June 12th at 4:30 pm.
WORK SCHEDULE: This position is not overtime-eligible . This position is paid on a bi-weekly schedule, every other Thursday, comprising a 40-hour workweek; normally 8:00 a.m. – 5:00 p.m., Monday through Friday . This position may be required to work extended and/or flex scheduled work hours to respond to service needs.
REQUIRED MATERIALS: King County Application, Resume and Supplemental Questions
Experience, Qualifications, Knowledge, Skills:
- Proactive support of Oracle databases : Serve as primary Database Administrator for the Oracle E-Business Suite Finance system and backup for BRC DBAs who support the PeopleSoft and Hyperion Budget systems. Support includes but is not limited to: · Monitoring and managing database operations · Performance tuning of database and SQL to improve application performance · Troubleshoot and resolve of database and system issues · Creating new database instances and cloning or refreshing of existing data instances · Application and patch installs · Backup and recovery of Oracle and SQL Server databases · Monitor and maintain database security and access · As an Oracle Financial Application DBA , monitor and tune Oracle Applications and perform a variety of system administration tasks that may include: · Design all new or changes to existing security responsibilities · Administer Concurrent Manager – request sets and job scheduling · Creating new EBS menus and form personalizations · Enabling, disabling and changing profile options · Support application middleware technologies and integration: Monitoring, tuning, troubleshooting, configuration, patching of middleware and web servers including WebLogic, Oracle Internet Application Server (IAS) and Oracle’s Business Process Execution Language integration services. Support Oracle reporting tools such as Discoverer and BI Publisher. · Develop and maintain Linux shell and batch scripts to automate the creation of new instances, create alerts to proactively recognize issues and send notifications, and to automate system administration tasks. · Coordinate with King County’s IT Systems Engineering and Networks teams, System Owners and BRC teams as needed for ongoing management of service requests and correction of system issues. · Participate in technology projects and system upgrades. Provide database and system administrative services for technology initiatives. · Planning and Design work including database design and architecture, forecasting space growth, sizing and hardware planning, security design, and to plan for upgrades and future system requirements. · Work with other BRC DBAs to seek standard practices, participate in cross training, share solutions to facilitate ease of acting as database administrator for any of the three ERP systems. Develop operations and procedures documentation for use by DBA and BRC teams.
REQUIRED QUALIFICATIONS: · Four or more years of professional experience as an Oracle Database Administrator supporting enterprise business systems. · One year professional experience as DBA for Oracle E-Business Suite financial system. · Experience and understanding of Oracle EBS system administration tasks including one or more of the following: o Maintenance of Oracle concurrent manager, request sets and job scheduling; o Design and maintenance of security responsibilities, profile options, menus and form personalizations. · Experience, skills and knowledge on Oracle Database technologies · Professional experience installing and patching Oracle databases and Oracle EBS systems. · Professional experience developing Linux/Unix shell scripts used to proactively manage system availability and performance or to automate system administration tasks. · Expert level of SQL*Plus skills. o Experienced and skill using Oracle Enterprise Manager and performing DBA tasks using command line functions. · Professional experience with performance tuning. · Experience and skills troubleshooting and resolving complex technical issues. · Skill and experience with database design and architecture, security design, forecasting space growth and participating in hardware sizing and planning. · Strong verbal and written communication skills DESIRED QUALIFICATIONS: · Experience performing DBA duties during a major Oracle EBS upgrade project. · Professional experience as DBA for PeopleSoft system. · Professional experience as DBA for Hyperion budget systems and/or Essbase OLAP databases. · Knowledge of Windows, Windows scripting, and DBA experience supporting Microsoft SQL Server. · Professional experience monitoring, tuning, troubleshooting, configuration, patching of one or more of the following middleware technologies: o Oracle’s Weblogic o Oracle’s Business Process Execution Language integration services (BPEL 11g 9or 10g), o Oracle’s Data Integrator (ODI) o Oracle SOA Suite o PeopleSoft’s Integration Broker and web servers · Professional experience implementing data warehousing solutions to support Business Intelligence reporting. · Oracle Certified Professional (OCP) certification.
RECRUITMENT PROCESS: Interviews will be conducted for top candidates. There may be test conducted as part of the selection process. A final offer of employment and hire will be contingent upon successfully completing a criminal background check and references.
UNION MEMBERSHIP : International Federation of Professional and Technical Employees Local 17, Information Technology