Senior Database Administrator

Posting Date

Application Deadline

Pay Range

Job Type

Department

About the Position

The Senior Database Administrator functions as a technical lead overseeing the architectural design, development, implementation, maintenance support, and management of complex data service systems, including the design and management of data warehouse and databases using database platform tools and systems, such as Microsoft SQL Server, Power BI, and other Microsoft suite of data products and Power Platform capabilities. This position provides technical solutions, expertise, guidance, and direction to database administrators, database developers, data analysts, report writers, and IT executive management on a broad range of complex information technology matters and projects.

About Us

It's time for you to utilize and perfect your talents.

Correctional Health Services is an industry-leading healthcare organization for the incarcerated population, providing medical, dental, mental health, psychiatric care, and substance abuse treatment (i. e. , Medication Assisted Treatment and Opioid Treatment Program). Our department's culture promotes collaboration, continuous training, and flexibility. We challenge our team to spearhead initiatives, break down barriers, and advance their expertise.

Apply now to work with a dynamic group of diverse and talented professionals.

Proud to Offer

• Work with a greater purpose

• Tuition reimbursement

• Exceptional work-life balance with hybrid work schedule options

• Opportunities for growth and development within Maricopa County

• Low-cost, high-value healthcare for you and your qualifying dependents

• Paid vacation, sick time, and parental leave

• Extensive wellness program, including healthcare premium discounts

• Employee discounts for goods and services

• Maricopa County participates in the Arizona State Retirement System. This defined retirement benefit requires a 12. 27% monthly contribution rate and includes a 100% employer match on Day 1

• Learn more at Work With Us | Maricopa County, AZ

We Require

• Four years of experience in an information technology role that involves responsibility, accountability, and hands-on experience with database and data warehousing architecture, design, development, and implementation, and includes reviewing and managing complex information technology projects using Microsoft suite of data products and Power Platform

• Bachelor's degree in Computer Science, Information Technology, or a closely related field

• An equivalent combination of post-secondary education and/or job-related experience may substitute for the required education on a year-for-year basis

We Also Value

• Master's degree in Computer Science, Computer Information Systems, or a related field

• Experience in database, data warehousing, and business intelligence architect roles

• Experience building databases, data warehouses, and business intelligence solutions, including high availability and disaster recovery with the Microsoft technology stack using the best practices with Microsoft suite of data products and Power Platform

• Proven experience with Microsoft SQL Server, T-SQL, Stored Procedures & Triggers, SSIS, SSRS, PowerShell, Power BI, Python, R

• Experience with Team Foundation Server, Git administration/configuration, or build and release management

• Experience working with Microsoft Dynamics, SharePoint, and Power Platform

• Experience working in Agile Methodology

Job Contributions

• Provide technical and analytical guidance; develop and define business and technical requirements and solution designs for specific projects

• Lead technical design and development, with a key role in the technical decision-making process; evaluate and troubleshoot functional design, system architecture, component, and framework programming

• Develop and recommend strategies and specifications for data solutions based on analyzing the business goals, objectives, needs, and existing data systems infrastructure

• Oversee the design, assessment, selection, application, and maintenance of major databases, data warehousing, and business intelligence solutions and metadata structures

• Lead the Data, Data Warehousing, and Business Intelligence teams to maximize existing systems, ensure data integrity/consistency and chain of custody, and develop an analysis for mission-critical reporting

• Formulate data and metadata policies and procedures for functional design and development to build, maintain, and upgrade the data model, ensuring compliance with organization data standards

• Administer technical troubleshooting and integration of new technology or new capabilities into the metadata and data standards and structures and complete assessment of the technical specifications of proposals and alternatives recommended to optimize database performance

• Develop a logical/physical database design by applying data design standards and guidelines

• Develop and facilitate the resolution of data-related project issues

• Create and propose technical design documentation, including database design models, specifications, and diagrams, to provide direction to development teams on the physical implementation of the data model

• Create and maintain documentation related to data configuration, mapping, standards, and processes

• Build processes supporting data transformation, data structures, metadata, dependencies, and model management

• Design, develop, and test data migration solutions as needed

• Assist in the design of databases and data warehouses to ensure interoperability with BI solutions

• Monitor emerging data warehouse technologies and recommend applications appropriate to the organization's environment and its users to ensure the data warehousing solution remains current

• Design and deliver end-user training and training materials; provide technical support as necessary

• Develop and present conceptual and functional innovation prototypes for assessment and evaluation

• Shape the strategy, architecture, methodology, and standards for delivering business intelligence and data visualization solutions.

• Plan, prepare, define, structure, develop, and implement complex database systems

• Manage data integrity, security, availability, and recoverability to ensure optimal performance

• Participate in multiple, technically complex, mission-critical, and/or high-profile data projects .