This position may close at any time based on needs of the Court.
Applicants are encouraged to apply promptly.
 

Los Angeles Superior Court (LASC) is seeking dynamic, well-qualified, and highly-motivated individuals to fill the position of Application Database Administrator (Applications Development Analyst V) within its Court Technology Services department based in Los Angeles, California.

Application Database Administrator is the expert level in the classification series. Act as subject matter expert in database administration; incumbents demonstrate strong organizational skills, ability to thrive in an environment where success depends on a high degree of cross-functional collaboration; possess deep understanding of SQL Server architecture and services; extensive experience in SQL Server platform, data warehouses, PowerShell, Cloud, and replication technologies. For a detailed job description, please click here. Please note the requirements in the job description may vary from the requirements in this bulletin. Applicants must meet the requirements stated in this bulletin.


MINIMUM REQUIREMENTS:
To qualify, you must meet one of the following options at time of filing:

OPTION I: One year of experience at the level of Applications Development Analyst IV working for the Los Angeles Superior Court.

OPTION II: Graduation from an accredited four-year college or university* with a major in computer science, information systems, information technology, or a closely related field -AND- six years of progressively responsible experience in performing business process analyses and translating functional and business requirements into design, development, installation, and maintenance of computer applications in conformance with business and technical requirements.


Note: Credit for experience is given based on a 40-hour workweek. Part-time experience is credited on a part-time ratio, i.e., working 20 hours per week for two months equals one month of experience. No additional credit is given for overtime.

 

DESIRABLE QUALIFICATIONS:
The ideal candidate will possess the following desirable qualifications:

• Hands on experience in installing, monitoring, performance tuning, providing operational services, backup and recovery for SQL Server databases (including Reporting Services, Integration Services, Analytical Services) using the current state of the art technologies such as SQL Server 2012 or higher
• Experience in high availability technologies (Always On, log shipping etc.), failover clustering, SQL replication, SQL Mirroring and SQL Server Tools
• Hands on experience of cloud environment, preferably Azure
• Troubleshoot and fix production issues
• Writes stored procedures, triggers, batch jobs, and scripts used in database management systems
• Ability to analyze query plans, consolidate and tune databases for optimal efficiency and monitoring SQL Server
• Manage data warehouse tools, database upgrade and migration, utilities, and backup and recovery. Refine the logical design so that it can be translated into a specific data model
• Good understanding of design and implementation of database security, including encryption, creating users, roles, assigning database privileges
• Possess and apply knowledge of operating systems, network, storage technologies, PowerShell, and virtualized environment to database administration
• Knowledge and experience with Idera and other monitoring tools
• Apply knowledge of new and emerging data management technologies to assist with existing database designs, data architectures, technologies, and platforms

LICENSES; CERTIFICATES; SPECIAL REQUIREMENTS:

PART II: An online examination, weighted 100%, assessing two professional/technical knowledge areas. No person may complete this assessment more than once every 12 months.

• MS SQL SERVER 2012 ADMINISTRATION - covers architecture, backup and restore, command line tools and utilities, database management, graphical tools and utilities, high availability, security, and troubleshooting.

• DATA WAREHOUSING CONCEPTS - covers big data and data warehouse appliance, business considerations, data transformation, data warehousing and data marts, design, dimensional data model, on line analytical processing (OLAP), querying and reporting/data extraction.

APPLICATION and FILING INFORMATION:
Applications may only be filed online. To learn how to apply online, please access the Online Employment Application Guide. Los Angeles Superior Court reserves the right to verify all submitted documentation prior to appointment. The Court will only consider completed applications submitted, along with the required documents, and will reject incomplete applications. A resume will not substitute for a fully completed employment application. To facilitate the full and proper consideration of your work experience, clearly specify what professional experience meets the required job qualifications. When listing your work experience, please specify the beginning and end dates for each job you held and describe your experience for each position.

Please provide a current and accurate e-mail address for the Court to communicate with you about this job opportunity. Human Resources staff will notify all applicants of their application status via e-mail. We recommend that you add info@governmentjobs.com to your e-mail address book to avoid the notification being filtered as spam mail.

Los Angeles Superior Court is an equal opportunity employer. Applicants with disabilities who require reasonable accommodations to participate in the recruitment process can contact the email address provided below. For additional employment information, please click here (Download PDF reader).

Questions regarding this posting may be e-mailed to mpenate@lacourt.org.



WHAT TO EXPECT NEXT:

We will notify you of the outcome after each step of the recruitment process has been completed. Applicants who successfully pass each (and all) examination part(s) will be placed on an eligible list which will remain valid for up to one year. Other vacancies may be filled using this list.