What are the responsibilities and job description for the Database Administrator position at Irvine Ranch Water District?
The District
Irvine Ranch Water District (IRWD) is a progressive, values-driven agency, with an international reputation for its leading-edge financial management practices, water recycling program, water use efficiency practices, water banking, urban runoff treatment, and energy generation and storage. Established in 1961 as a California Water District under the provisions of the California Water Code, IRWD is an independent special district serving central Orange County. IRWD provides high-quality drinking water, reliable sewage collection and treatment, ground-breaking recycled water programs, and environmentally sound urban runoff treatment to its customers. As an independent, not-for-profit public agency, IRWD is governed by a publicly elected five-member Board of Directors. The Board is responsible for the District's policies and decision-making. Day-to-day operations are supervised by the General Manager. Additional information can be found at the District's website: www.IRWD.com.
IRWD Corporate Values
Irvine Ranch Water District believes that its values drive the character, culture, and capacity of our organization. IRWD was built on values, and we weave them into the fabric of everything we do. Values are the ingredients in our recipe for both institutional and individual success. They are a code of conduct to promote positive outcomes for others and ourselves. They are more than words on a wall or a website. We live by them every day. We pledge to keep them relevant in an ever-changing world.
IRWD's employees enjoy working in a safe, supportive, and nurturing environment where they form strong bonds with fellow employees. To ensure effective communication and promote a collaborative team environment, employees report to work each day in the office or in the field, depending on their positions.
The Position
The Oracle Applications Database Administrator (DBA) is responsible for administering the District’s Enterprise applications including Oracle EBS, Oracle CC&B and Maximo, along with associated technologies such as Oracle databases, middleware, and other relevant applications. This involves ensuring that the applications and databases run smoothly, and issues are resolved in a timely manner. This position requires providing on-call support for systems, proficiency in Linux, capacity, and willingness to acquire expertise in new technologies and provide support for them.
For the full job description and responsibilities of the position, please click here.
Applications will be accepted on a continuous basis until a sufficient number of qualified applications have been received. The deadline for the first review of applications is 8:00 AM on Monday, November 25, 2024. Qualified candidates are encouraged to submit applications early. Candidates who submit applications after the first review deadline are not guaranteed to be considered for this recruitment. This recruitment may close at any time without notice after the first review deadline.
The ideal candidate will have the ability to design, maintain, and implement new features as well as troubleshoot any data-related issues, collaborate with developers, system administrators and end-users to maintain databases, thus, making it vital to communicate fluently in database management language(s).
DISTINGUISHING CHARACTERISTICS
This is the entry-level in the professional Database Administrator series. Assignments require knowledge, expertise, experience, and skills in a broad range of professional database administration areas, independence, initiative, and the ability to perform complex and difficult analytical tasks related to a broad range of assignments. The work requires creativity and resourcefulness to accomplish goals and objectives. Incumbents are required to exercise judgment in interpreting established guidelines, policies, procedures, goals, and objectives and in applying concepts, plans, and strategies. Incumbents in these classifications regularly and independently complete assignments in a variety of database administration functions.
Responsible for maintenance and support of Oracle databases and applications.
- Responsible for performance tuning of Application Tiers and Oracle Databases.
Responsible for process and query optimization, troubleshooting of locking issues, monitoring of resource contention, analysis of queries, log files, trace files in Oracle Applications.
- Responsible for quickly identifying and resolving performance issues using the following tools: OEM, explain plan, DBMS Profiler, AWR, ADDM, and TOAD.
Perform database implementation and upgrades in Oracle Applications environments.
- Review and apply critical patches as required.
Perform Real Applications Cluster (RAC) and Active Data Gard installation and maintenance of Oracle Databases.
- Manage and maintain all production and non-production databases, including performing backups, recovery and validation, as well as reporting on database statistics.
Provide support and perform Cloning in RAC and NON-RAC environments.
- Assist application development and/or support with database design considerations.
Assist in the development and maintenance of the disaster recovery / business resumption planning process for all databases.
- Assist in developing database strategies, including standards, design, maintenance, replication, archiving, access and security, to support District needs.
Document and communicate all system changes.
- Enforce defined data security models to help protect the District’s data.
Review and recommend changes to database replication and linking to support District application needs.
- Consult with end users to recommend the most appropriate database solution.
Perform other duties as assigned.
- Comply with District work-related safety practices and attend relevant safety training.
A combination of education and experience equivalent to:
Education:
- A bachelor's degree in Computer Science or related field is required. Work experience may be substituted on a year-for-year basis. For degrees obtained outside of the U.S., an official equivalency evaluation is required.
Experience:
- A minimum of three (3) years of experience in the following disciplines is required: Hands-on experience with Oracle Application databases on Linux/Unix Platform, Patching, cloning, upgrade, backup and recovery for both Oracle applications and databases; Pro-active monitoring and performance tuning, Expert-level Oracle application middle tier configuration, architecture review, patch review and maintenance of Concurrent program setup and maintenance. Expert level in Oracle EBS R12, Oracle Fusion Middleware 11g, RDBMS: Oracle 12c,19c or later
Experience in the following disciplines is highly desirable:
- Oracle SSO using Oracle Identity Cloud Services, Oracle CC&B 2.8x, Oracle RAC and Data Guard.
- Operating Systems: Linux, MS Windows
- Programming Languages: SQL, PL/SQL and Unix Shell Script
- Database management Software or Tools: Oracle OEM, ASM, Data Guard, RMAN, TDE, Toad, SQL Plus.
- Other technologies: Oracle Cloud tenancy, Oracle Cloud VPN, MS Office, Job Scheduler software
- Oracle CC&B (Customer Care & Billing) product; OUAF Framework, Weblogic Server and Performance Management Tools; Oracle CC&B Hands-On Batch Programming; all phases of software development life cycle including functional analysis, development of technical requirements, prototyping, testing and deployment; peer design and code reviews and implementing solutions utilizing ITIL framework and best practices.
License / Certifications:
Depending on assignment, a valid Class ‘C’ California Driver’s License may be required.
Desired Certifications:
Oracle professional Database Administration, OCI or equivalent certification.
The physical and mental demands described below are representative of those that must be met by employees to successfully perform the essential functions of this class. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
Language Ability and Interpersonal Communication
Ability to communicate effectively with all levels of employees and management. Represent the District in a professional manner when dealing with outside suppliers and customers. Ability to explain, demonstrate and clarify to others within well-established policies, procedures and standards, as well as the ability to follow specific instructions and respond to simple and difficult requests from others.
Mathematical Ability
Ability to add, subtract, multiply, divide and calculate percentages, fractions and decimals. Algebra and Statistical Analysis desired.
Technology Ability
Proficient in the use of Microsoft Office Suite (Word, Excel, PowerPoint).Judgment and Situational Reasoning Ability
Ability to use good personal judgment and discretion in performing all job functions. Ability to use analytic and problem- solving skills, effectively evaluate information/data to make decisions. Ability to anticipate obstacles and develop plans to resolve. Ability to evaluate decisions through the eyes of the customer; build strong customer relationships and create processes with a customer viewpoint.
Physical Requirements
Regularly required to sit, bend, stoop and stand. Occasionally required to lift up to 50 lbs.
Environmental Adaptability
Noise level is generally equivalent to a typical office environment. Ability to work in an environment which may expose the employee to hazardous materials and environment. Occasional visits to construction sites where noise level may be higher than typical office environment.
Disaster Service Worker: In accordance with Government Code Section 3100, Irvine Ranch Water District employees, in the event of a disaster, are considered disaster service workers and may be asked to respond accordingly.
IMPORTANT APPLICATION INFORMATION AND INSTRUCTIONS
Applications will be reviewed by the Human Resources Department and the subject matter expert. Those applicants possessing the most pertinent qualifications will be invited to continue in the selection process, which will include:
Spark Hire: a one-way video interview, evaluating the candidates' ability to convey their training and experience.
Oral Interview Examination: will evaluate the candidates' experience, training, education, and abilities in relation to those factors which are essential for successful performance on the job.
Communication regarding your application and/or status will be sent to the email address listed on your application. Please check your email regularly throughout the recruitment process as you will not receive communications by any other method.
Equal Opportunity Employer
Irvine Ranch Water District is an Equal Opportunity Employer and provides reasonable accommodations to qualified individuals with disabilities. If you consider yourself a person with a disability, you may contact the Human Resources Department for a reasonable accommodation.
Salary : $110,791 - $153,408
