About the position
Are you looking for the opportunity to utilize your years of Microsoft SQL server database administrator to solve challenging and complex processes and projects? Join our Data developer administration and IT division at the Maricopa County Sheriff's Office. The Database Administrator Senior/Lead architects, develop, implements, maintains, tunes, and monitors all enterprise databases. The role participates in the design and creation of databases at both a data model and architect level, defines standards and design of physical data storage, and maintenance of databases, and performs quality control and auditing of databases to ensure accurate and appropriate use of data. This position plays an integral role in the successful operations of MCSO by supporting data accuracy and availability.
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.
- Is present at work site to perform tasks as scheduled or assigned by the supervisor.
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.
- Training that may be provided on-the-job: FEMA NIMS - IS100 and 700; Safety; Payroll; PREA.
- Prior to hiring, the Sheriff's Office requires that all candidates pass a background review.
Nice-to-haves
- Seven years (7) experience as a Database Administrator with Microsoft SQL Server, T-SQL, Stored Procedures & Triggers, SSIS, SSRS, PowerShell, and Power BI.
Benefits
- Choice of three medical plans - starting as low as $70/month
- Vision insurance
- Dental Insurance
- Pet Insurance
- Life Insurance
- Paid Holidays - 10/year + 1 personal day
- Three weeks of vacation PTO accrual your first year (rollover!)
- Two weeks of Sick time PTO accrual your first year (rollover!)
- Pension: Enrollment in Arizona State Retirement System
- Paid Parental leaves (birth/adoption)
- 10% discount at KinderCare facilities in the Valley and upcoming MCKids Club to serve County employees and their families exclusively
- MCSO Mentoring program to provide personal and professional growth opportunities for all employees.
- Professional Development Assistance
- Tuition reimbursement
- Access to free County gyms
- Employee Discounts
