Maricopa County

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Database Architect

at Maricopa County

Pay: $45.80 to $73.85/hour
$45.8 - $73.85
Posted: 4/12/2019
Job Status: Full Time
Job Reference #: 2416225
Keywords: architecture

Job Description

Overall Job Objective

Position Overview

Be Part of Technology Innovation! Join Our Dynamic, Can-Do Spirit Team!
 
The Office of Enterprise Technology (OET) provides technology leadership for Maricopa County through innovation, exceptional customer service, process efficiency and digital transformation. 
 
The Database Architect oversees 100+ SQL Servers that encompass a combination of 1000+ databases on-premise and cloud-hosted environments.  This position will govern SQL Server infrastructure requirements, database designs, monitoring and analysis of software and hardware.  The Database Architect will administer database encryption with regular "safeguard processes" that satisfy HIPPA, Personal Identifiers (PID) and Payment Card Industry Data Security Standards (PCI DSS). This position empowers innovative ideas that have strategic impacts to Maricopa County.  The applicant must demonstrate substantial tuning (SQL queries and services) and database optimization skills.  Candidate will identify and address systemic errors impacting County data resources.

Position Qualifications

Minimum Education and/or Experience:

  • Bachelor's degree in computer science, information technology, or a related field.
  • Seven (7) years' hands-on experience in SQL Database/Servers development and administration.
  • An equivalent combination of post-secondary education and/or job-related experience may substitute for the minimum qualifications on a year for year basis.
Preferred Education and/or Experience:
  • Minimum fifteen (15) years of hands on SQL Database development and administration
  • Master's degree in Business Administration, Computer Information Systems, Management Information Systems, Public Administration or a related field.
  • Seven (7) years in a Technical Architect role.
  • Proficiency in all Microsoft products, including Visual Studio, TFS, SQL Server Query Optimization, SSRS, SSMS, SSIS, Office, Outlook and Project.
  • Managing enterprise scale SQL environments (on-premise and cloud-hosted).
  • Continuous Integration and Delivery (CI/CD) using Visual Studio Team Services (VSTS)
Preferred Training, Certifications and/or Other Special Requirements:
  • Project Management Professional (PMP) certification
  • Information Technology Infrastructure Library (ITIL) Foundation v3 Certification
  • Health Insurance Portability and Accountability Act (HIPAA) Certification
  • Terminal Operator Certificate (TOC) Certified
  • MCSA: SQL server certification
Working Conditions:
Work is performed in an office and data center environment.  May be subject to repetitive motion such as typing and data entry.  Frequent computer use involving the need to see details at close range.  Must be able to work after hours, weekends and holidays, as well as be on-call 24 hours a day, seven (7) days a week.  Must have the ability to travel to other County facilities.

Essential Job Tasks

  • Plans, coordinates and communicates effectively and professionally by verbal and written messages to variety of recipients.
  • Creates and maintains technical architecture documentation (topology diagrams, Standard Operating Procedures (SOPs), knowledge base articles, etc.) that accurately characterizes business requests. 
  • Prepares overall server health dashboards (operational readiness, security, technology, business continuity) that provides actionable information to technical staff and management.
  • Forecasts capacity growth demands in near-term, short-term (1 to 2 years) and long-term (2 to 5 years) horizons. 
  • Maintains security best practices with frequent internal audits.
  • Mentors team members in the use of Microsoft and third-party monitoring/troubleshooting tools.
  • Champions high availability & peak performance through database tuning and optimization.
  • Develops and maintains comprehensive operational and strategic plans for County database requirements, capabilities, budget, training and forecasting.
  • Facilitates data set transfers of 100+ gigabytes between Cloud and On-premise.
  • Participates in 24/7 on-call production support rotation.
  • Implements third party database administration and monitoring tools.
  • Handle high volume, scalable, data-intensive SQL Servers.

Selection Procedure

The hiring authority will select the successful candidate based on departmental needs.
 
All offers of employment made to new hires and rehires at Maricopa County are contingent upon successful completion of a post-offer, pre-employment thorough background investigation.  A background investigation is conducted on a current employee who changes to a Safety Sensitive Position or one having the potential for serious adverse impact on the integrity or efficiency of the County.  These requirements do not pertain to employees of elected officials who undergo background investigation processes administered through their respective offices.

Typically successful candidates are hired at a salary rate, up to midpoint of the range, based on applicable experience, internal equity and budgetary allowances.
 

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!