Database Administrator

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.

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:

Experience:

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.

• 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

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.