Senior Database Administrator

Company: Maricopa County
Location: Phoenix
Posted on: January 26, 2025

Job Description:

Posting Date01/24/25Application Deadline01/27/25Pay Range$91,500 - $155,000 annually

Salary offers are based on the candidate's equivalent experience and internal equity with other employees within the same job classification. The position is not eligible for overtime compensation.Job TypeUnclassifiedDepartmentCorrectional HealthAbout the PositionThe 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 UsIt'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 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 MethodologyJob 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 or initiatives
      • Partner with internal customers to conceptualize new projects; recommend technical resources and strategies, and design project requirements
      • Conduct detailed reviews of all major development projects undertaken by information technology functions within CHS, within the area of expertise, or as requested by management
      • Identify opportunities to re-engineer business practices to enhance CHS's information technology strategies and plans
      • Maintain state-of-the-art knowledge in emerging technologies, methodologies, and best practices to enhance the enterprise's image as a first-class organization
      • Provide expertise regarding the integration of applications across the business
      • Determine specifications; plan, design, and develop complex and business-critical data solutions individually or in partnership with the project team
      • Act as an evangelist for BI benefits across the organization; promote BI usage to relevant departments
      • Provides expert-level support for the most difficult support problems; resolves unique or non-routine data and BI problems
      • Analyze short and long-term strategic data or BI/reporting problems and develop solutions
      • Ensure CHS adherence to all County data compliance regulations
      • Perform other duties as assignedWorking Conditions
        • Must be able to work inside a jail and pass a fingerprint background check
        • Able to sit and perform duties on a computer for long periods of timeSelection Procedure
          • Only the most qualified candidates will be considered
          • Consideration will only be given to candidates who submit online applications
          • Candidates will be contacted primarily through email and their Workday online application profile
          • Must pass a pre-employment background and/or fingerprint investigation as required by statute or policy, including drug and alcohol testing requirements for positions designated as safety-sensitiveMaricopa County is an equal opportunity employer.Apply Now!

Keywords: Maricopa County, Prescott , Senior Database Administrator, IT / Software / Systems , Phoenix, Arizona