SQL Server Lead Database Administrator
| Company | Maricopa County Sheriff’s Office |
|---|---|
| Location | Phoenix, AZ, USA |
| Salary | $91500 – $155000 |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Mid Level, Senior |
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- Four (4) years of experience in database design, development, maintenance, administration, and support in a large-scale enterprise environment
- Must possess a valid Arizona driver’s license or have the ability to obtain by the time of hire
- Prior to hiring, the Sheriff’s Office requires that all candidates pass a background review.
Responsibilities
- Designs logical and physical databases to meet system requirements.
- Establishes and monitors processes that extract data from or load data into databases.
- Provides support, standards, and information relating to database back-ups, archiving, and data recovery.
- Performs database and software life-cycle activities to ensure highest level of system performance and availability and compliance with business requirements.
- Maintains archival copies of database-related files and information.
- Provides documentation and support to users, development and operations staff, and management.
- Writes, tests, and puts into production all tables, constraints, triggers, stored procedures and permissions.
- Works with system programmers to create, enhance, and troubleshoot applications.
- Monitors performance and database usage and adjusts as needed.
- Maintains the integrity, security and availability of the databases.
- Performs the process of database security in compliance with MCSO policy.
- Provides physical model recommendations.
- Provides escalation support for production and nonproduction databases; advises and assists other database administrators.
- Collects and reports data as required for departmental statistics.
- Performs high availability and disaster recovery – installation and configuration at database layer to include 3rd party applications and always on availability groups.
- Assists management in evaluating technology issues, policies and procedures.
Preferred Qualifications
- Seven years (7) experience as a Database Administrator with Microsoft SQL Server, T-SQL, Stored Procedures & Triggers, SSIS, SSRS, PowerShell, and Power BI.