Oracle/SQL Server Database Administrator

Los Angeles 22 months ago Remote Full-time External
813.2k - 1m
ANNUAL SALARY $113,609.60- $141,065.60 BENEFIT HIGHLIGHTS Choice of five medical plans Defined Benefit Retirement Plan (2.50% at 67 formula) Health Reimbursement Arrangement (HRA) Vacation and sick leave packages 14 paid holidays per year Defined benefit retirement-plan Tuition reimbursement Optional deferred compensation program (457 plan) This recruitment will remain open until the needs of the Court have been met and may close at any time. However, the deadline for first round consideration is Friday, January 26, 2024, at 11:59 PM PST. This recruitment is open to external candidates, internal OCSC employees, internal OCSC promotions, and internal OCSC lateral transfers. The eligible list established from this recruitment will be used to fill current and future positions. TELEWORK/ON-SITE OPPORTUNITY This position is eligible for a combination of telework and on-site work assignments. Telework must be completed from a pre-designated home-based location within the State of California and employees may be required to report on-site to address business needs. Telework is at the sole discretion of the Court and may be rescinded with 48 hours' notice, based on needs of the Orange County Superior Court. ABOUT THE DEPARTMENT / POSITION The Court Technology Services (CTS) department provides the court with proactive leadership in implementing and maintaining the court’s network infrastructure, core business and departmental applications, as well as ensuring the security of the court’s data and processes. CTS works with court leaders, judicial committees, the State Judicial Council staff, justice agencies, court departments, vendors, and others to ensure the Court is fully supported by the appropriate levels of technology services. The Servers, Storage & Database unit provides core Infrastructure services to support Court technology operations. The unit is seeking qualified candidates with a deep understanding of Linux, WebLogic, Tomcat, Azure, Virtualization, Storage, Security, and Networking stack. The incumbent is required to exercise excellent judgment and perform their duties with the highest degree of integrity to uphold the public’s trust and confidence in the administration of justice. The incumbent is expected to use sound judgement when making decisions, be self-driven, stay on top of technology trends, and research and propose solutions. The individual selected for this position will perform an advanced level of Oracle, SQL Server, Azure SQL database administration. Minimum Qualifications REQUIRED EDUCATION: High school diploma or GED equivalent REQUIRED EXPERIENCE: Seven (7) years of full-time (or equivalent) progressively responsible experience in the design, development and administration of complex relational databases and the management of relational database management systems. EXPERIENCE SUBSTITUTION: Bachelor's degree in computer science, information technology or a closely related field may substitute for two (2) years of required experience. Note: To receive substitution credit, a copy of your college official transcripts must be included with your application. DESIRABLE QUALIFICATIONS: • 7+ years of Oracle database administration experience (12c or higher) in a UNIX/Linux environment, preferably Red Hat Enterprise Linux (RHEL) or Oracle Linux. • Experience with the following Oracle technologies: Oracle Grid Infrastructure, Oracle GoldenGate, Oracle RMAN, Oracle OEM, Oracle DataGuard, Oracle Multitenant. • 3+ years of experience as a Microsoft SQL Server DBA. Azure SQL and/or Azure SQL Managed Instance experience is a plus. • Experience with the following Microsoft technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), Always-On. • Experience managing Oracle and/or SQL Server databases in cloud environments. • Experience writing complex SQL, PL/SQL, and T-SQL, including distributed transactions. • Experience with UNIX/Linux shell scripting and/or PowerShell • Experience designing optimal high availability (HA), database backup and disaster recovery strategies. • Extensive hands-on experience working with development and infrastructure teams in regard to schema design, database performance tuning and SQL optimization, database security measures, change control and troubleshooting. • Experience working with a Snowflake database is a plus. • Good writing skills to provide documentation for DBA and other teams