OCJ - SQL Database Administrator (DBA), Information Services Department
About The Position
The following are duties and responsibilities of the SQL Database Administrator (DBA). Configure and maintain database servers and processes Manage SQL Server databases through multiple product lifecycle environments Configure and maintain database server interfaces/integrations with partner agencies. Monitor system's health and performance Monitor and update anti-virus and anti-malware protection software to combat potential security breaches Ensure high levels of performance, availability, sustainability and security Serve as the subject matter expert in database performance and information security. Serve as the Court's liaison to the County's Information Security Work Group. Ensure data integrity Creation long term technical direction for server, storage, and operations as it relates to locally hosted databases Refine and automate regular processes, track issues, and document changes Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end Assist developers with query tuning and schema refinement Work collaboratively with a team of in-house application developers as well as 3rd party vendors and partner agencies to meet the meet the business objectives of the court Provide 24x7 support for critical production systems Perform scheduled maintenance and support release deployment activities after hours The duties listed above are not set forth for the purpose of limiting the assignment of work. They are not to be construed as a complete list of the duties to be performed under the job title or those to be performed temporarily outside an employee's normal line of work.
Requirements
- Bachelor's Degree - Computer Science (or equivalent field)
- 4 years of experience as a SQL Server DBA or similar role
- 4 years of experience with MY SQL Server Administration experience required
- 4 years of experience in configuring and maintaining the performance of large/critical SQL Server database applications
- 4 years of experience with Performance Tuning and Optimization (PTO)
- 4 years of experience with backups, restores and recovery models
- 4 years of experience of High Availability (HA), SQL Clustering and Disaster Recovery (DR) SQL Server
- 4 years of experience with SQL Server AlwaysOn Availability Groups
- 4 years of experience with SQL Server Reporting Services (SRSS).
- 4 years of experience with Windows server, including Active Directory
Nice To Haves
- Microsoft Certified Technology Specialists (MCTS) certification a plus
- Microsoft Certified IT Professional (MCITP} certification a plus
- Microsoft Most Valuable Professional (MVP) certification a plus
- Sense of ownership and pride in performance and its impact on court operations
- Critical thinker and problem-solving skills
- Ability to explain complex ideas in simple terms
- Team player
- Good time-management skills
- Good multitasking abilities
- Excellent written and oral communication skills;
- Excellent interpersonal skills;
- Ability to work cooperatively and integrate with legal and non-legal personnel
Responsibilities
- Configure and maintain database servers and processes
- Manage SQL Server databases through multiple product lifecycle environments
- Configure and maintain database server interfaces/integrations with partner agencies.
- Monitor system's health and performance
- Monitor and update anti-virus and anti-malware protection software to combat potential security breaches
- Ensure high levels of performance, availability, sustainability and security
- Serve as the subject matter expert in database performance and information security.
- Serve as the Court's liaison to the County's Information Security Work Group.
- Ensure data integrity
- Creation long term technical direction for server, storage, and operations as it relates to locally hosted databases
- Refine and automate regular processes, track issues, and document changes
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
- Assist developers with query tuning and schema refinement
- Work collaboratively with a team of in-house application developers as well as 3rd party vendors and partner agencies to meet the meet the business objectives of the court
- Provide 24x7 support for critical production systems
- Perform scheduled maintenance and support release deployment activities after hours
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
