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.
No out-of-class experience will be accepted.
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:
A valid California Class C driver's license or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions.
*OPTION II EDUCATION VERIFICATION:A legible copy of your college diploma -OR - transcript(s) (unofficial are acceptable) with the degree posted from the college or university must be submitted within 10 business days from application submission.
Documentation may be submitted as follows:
As an attachment to your on-line application. Attachment(s) must be in Microsoft Word or PDF format and should not exceed 10 MB; or
As an email attachment to Max Penate at firstname.lastname@example.org. Please indicate in the subject line "Application Database Administrator - Bachelor's Degree Verification." Please include your first and last name and the examination title on the documentation.
Foreign studies must be evaluated by an academic credential evaluation agency and deemed to be equivalent to degrees from the United States. For a list of acceptable evaluation agencies, please visit www.naces.org or http://aice-eval.org/. Foreign studies submitted without acceptable evaluation will be rejected.
EXAMINATION INFORMATION: PART I: Qualifying evaluation of education, training and experience based upon submitted application materials and supplemental questionnaire.
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 email@example.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).
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.