Database Administrator

Adhering to and promoting the Clerk’s Office Mission, Vision and Core Values, The Database Administrator (DBA) is responsible for effective management and optimization of the on-premises Microsoft SQL Server environment. This role ensures the reliability, security, and performance of our databases while supporting application upgrades and enabling data-driven decision making across the organization.

• Install, configure, and maintain SQL Server instances.
• Administer SQL databases, including backups, restores, and disaster recovery planning.
• Administer SQL users, roles, and permissions to enforce security and access controls.
• Create, maintain, and monitor SQL Jobs to automate recurring tasks.
• Manage SQL users, roles, and permissions to enforce security and access controls.
• Review and execute vendor-provided SQL scripts included in software releases.
• Refresh test environments with production data to validate upgrades and support application testing.
• Monitor performance using enterprise-grade diagnostic tools and implement efficiency improvements.
• Document schemas, processes, and replication configurations to ensure consistency and reliability.
• Administer and troubleshoot SQL replication between systems.
• Develop a deep understanding of application data models, relationships, and workflows.
• Identify where data resides across systems and how it flows between applications.
• Query and analyze data to troubleshoot issues and resolve anomalies.
• Collaborate with business units to resolve data issues and ensure integrity.

• Proven experience with Microsoft SQL Server administration, performance tuning, and replication.
• Strong SQL query, stored procedure, and schema design skills.
• Experience with SQL Jobs, SSRS, and SSIS.
• Ability to understand and document application data models.
• Strong troubleshooting and root cause analysis skills.
• Excellent communication and documentation abilities.

• Proven analytical and problem-solving abilities.
• Good written, oral, and interpersonal communication skills.
• Highly self-motivated and directed, with keen attention to detail.
• Team-oriented and skilled in working within a collaborative environment.
  
  Desire to update and enhance technical knowledge and take on advanced responsibilities.

• Ability to effectively prioritize and execute tasks.
• Ability to present ideas in business-friendly and user-friendly language.
• Ability to perform on-call, evening or weekend work.
• Ability to provide support during emergencies and activations.
• Ability to maintain proficiency by updating job knowledge through participating in educational opportunities, reading professional publications and/or participating in professional organizations.
• Ability to collaborate effectively with others.
• Ability to research, diagnose, resolve and document technical problems independently and as a team.
• Ability to communicate technical issues effectively, both in person and in writing.
• Familiarity with data governance and quality assurance practices.
• Background in business intelligence or analytics is a plus.

• College diploma or university degree in Computer Science, Information Systems, or related field; or equivalent work experience.
• Professional certifications in SQL Server or database administration preferred.
• Minimum of 3–5 years of hands-on SQL Server administration experience.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit, use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee occasionally is required to walk, stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 50 lbs. and occasionally lift and/or move up to 100 lbs.

Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.