Database Administrator/Database Developer

Under the general direction of the Information Technology Manager I, the incumbent acts as a lead Database administrator and Database developer with expertise in software application development in Java J2EE. The incumbent performs as a database administrator responsible for the design, implementation, and performance tuning of Oracle databases. The incumbent is responsible for assessing customer technical solutions to ensure they adhere to the technical infrastructure and are in alignment with the Legislative Data Center's (LDC) Enterprise Architecture to address the support, reliability, and performance aspects of Oracle database infrastructure systems. The incumbent is responsible for the analysis, design, coding, testing, documentation, and implementation of highly complex in-house developed applications for the California State Legislature within the Architected Services Division. The incumbent performs moderate to high-level data processing problem analysis, database design, and consulting for all environments to the legislature, and OLC customers. The incumbent provides advanced knowledge in systems analysis and Software Development Lifecycle (SDLC) processes. The incumbent works independently or as a team member and/or leads a team of information technology specialists on complex projects of variable risk over computer systems that are highly visible and mission-critical to meeting the business requirements of the California State Legislature and legislative support organizations. The incumbent may carry a mobile device during core business hours and off-shift hours; evenings, weekends, and State Holidays for the ability to respond to calls after hours.

You will find additional information about the job in the Duty Statement .

Minimum Requirements You will find the Minimum Requirements in the Class Specification.

• INFORMATION TECHNOLOGY SPECIALIST II

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details Job Code #:
JC-449005

Position #(s):
430-154-1414-XXX

Working Title:
Database Administrator/Database Developer

Classification:
INFORMATION TECHNOLOGY SPECIALIST II $8,622.00 - $11,558.00 L

# of Positions:
2

Work Location:
Sacramento County

Telework:
Hybrid

Job Type:
Permanent, Full Time

Work Shift:
8:00 am - 5:00 pm

Work Week:
Monday - Friday

Department Information
The Office of Legislative Counsel (OLC) is a small civil service department whose mission is to provide responsive nonpartisan and confidential legal services and information technology support services to the California State Legislature and in support of the legislative process. This position is located in the heart of downtown Sacramento. The State of California provides excellent health benefits and retirement options, sick leave and vacation accrual, and paid state holidays. OLC employees are excluded from collective bargaining and, therefore, receive enhanced benefits and do not contribute fair share.

Special Requirements

Do not include any confidential information on any documents you submit for a job vacancy, such as your STD. 678, resume, or school transcripts. Confidential information that should be excluded or removed from these documents includes, but is not limited to, your social security number, birthdate, student identification number, driver license number (unless required), examination results, LEAP status, marital status, and age. (Note confidential information on the first page of the application submitted online through your CalCareers account will be redacted automatically upon submission.)

Employment Application (STD. 678):

Applications must be complete and include dates and hours worked; contact names and phone numbers of supervisors; and a description of the duties performed for each position held; reference to a resume (i.e., "See Resume") in place of a description of the duties performed will not be accepted.

School Transcripts:

When using education to qualify, unofficial transcripts must be submitted. Applicants with foreign transcripts must provide a transcript evaluation that indicates the number of units to which the foreign course work is equivalent. If selected for appointment, official transcripts will be required.

Application Instructions
Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.
Final Filing Date: Until Filled
Who May Apply
Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply.

Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).

How To Apply
Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

Office of Legislative Counsel
Attn: Coral Arana
925 L Street, Suite 1105

Sacramento , CA 95814

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

Office of Legislative Counsel
Coral Arana
925 L Street, Suite 1105

Sacramento , CA 95814

08:00 AM - 05:00 PM

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

• Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is required and must be included.
• School Transcripts

Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.

Desirable Qualifications In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

• 5+ years of experience performing advanced database administration and support with Oracle, SQL, and PL/SQL.
• 5+ years of experience in Oracle RAC, Oracle OEM, Oracle Golden Gate/Data Guard.
• Experience developing or supporting Java J2EE based web applications, Interface technologies utilizing the Oracle database.
• Experience with performing systems analysis, and performance tuning (Oracle Database 19c, WebLogic, Oracle Application Server, PL/SQL code tuning, etc.).
• Experience with backing up/cloning Oracle databases using RMAN.
• Experience in the use of technologies, such as XML Publisher, Oracle Application Framework, BI reporting, Oracle Listener, XDB, XQuery, and TOAD/SQL Developer tools.
• Experience in writing complex SQL and PL/SQL functions, procedures, views, triggers, and advance queues to solve business problems.
• Knowledge of shell scripting and web application administration.
• Ability to troubleshoot complex information technology systems.
• A strong history of successful customer service and support, with a passion to meet the dynamic needs of external and internal customers.
• Excellent verbal and written communication skills, including ability to produce IT documentation.
• Passion for technology and a desire to expand upon existing technical skills.

Benefits
All OLC employees are excluded from collective bargaining, and therefore, receive enhanced benefits, such as CoBen benefit allowance, employer paid life insurance, additional vacation/annual leave, and are not subject to State Disability Insurance payroll withholding. Additional information can be found on CalHR's website under California State Civil Service Employee Benefits Summary .

Contact Information
The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.
Human Resources Contact:
Coral Arana
(916) 341-8330
coral.arana@legislativecounsel.ca.gov
Hiring Unit Contact:
Minh Vo-Bucaneg
(916) 341-8862
minh.vo@lc.ca.gov

Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.
EEO Contact:
EEO/Human Resources
(916) 341-8330
OLC.HumanResources@legislativecounsel.ca.gov
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Your Expertise

• Experience with Oracle Database, SQL, PL/SQL, J2EE, HTML, and XML.
• Knowledge of system specifications, design, documentation, and implementation methodologies and techniques.
• Knowledge of database design, implementation, and maintenance.
• Experience with database performance tuning and optimization.
• Experience in leading technical oversight of architecture, hardware and software used to enhance existing in-house applications, and develop new systems.
• Strong analytical and problem-solving skills.
• Strong organizational skills and attention to details.
• Commitment to high quality of solutions and services provided to clients.

Your Responsibilities

• Provide day to day administration support and maintenance of Oracle databases.
• Plan and perform Oracle database tuning, upgrades, and migrations.
• Provide support to customers by fielding requests for enhancements, generating ad hoc reports, resolving production database problems, providing consultation and technical troubleshooting expertise.
• Lead in development and maintaining complex database scripts and packages in support of J2EE applications.
• Lead moderate to highly complex database infrastructure, critical database IT projects, and software implementations, using project management tools, and techniques.
• Lead in the data analysis and resolution of database performance issues for highly complex applications.
• Cross collaborate with organizational teams to share knowledge, suggest improvements, and debug existing legislative applications.
• Mentor and perform as a database consultant to staff, providing procedural guidance, and provide cross-training on the development, implementation, support, and maintenance of the database and related mission-critical legislative applications.
• Accurately interpret and apply program specifications, develop, and test core modules, and deliver applications that meet customer expectations.
• Ensure data integrity and quality throughout the development process.
• Troubleshoot and resolve software/hardware problems using technical knowledge and skills.
• Provide direct support to customers whose applications fall under the area of responsibility, such as fielding requests for enhancements and generating ad-hoc reports.
• Manage and maintain a schedule of work to ensure project schedules and deliverables are completed within agreed-upon timeframes; report progress on projects and work activities in meetings and provide regular status reports .
• Professional and personable demeanor, with good verbal and written communication skills to communicate professionally and effectively.
• Develop and maintain professional internal and external relationships that adhere to the organization's core values, including working relationships with project team members and LDC management.
• Work with existing organizational teams to share knowledge, suggest improvements, and to resolve technology issues.

Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.