SENIOR DATABASE ADMINISTRATOR

DEPARTMENT OF ECONOMIC SECURITY

Your Partner For A Stronger Arizona.

DES works with families, community organizations, advocates and state and federal partners to realize our collective vision: A thriving Arizona.

DES serves more than 3 million Arizonans. Our Mission is to strengthen individuals, families, and communities for a better quality of life.

SENIOR DATABASE ADMINISTRATOR

Job Location:

Division of Technology Services (DTS) 1400 West Washington Street, Phoenix, Arizona 85007 www.azdes.gov

Posting Details:

Salary: $71,676.59 - $90,000 

Grade: 27

Closing Date: September 5, 20206

Job Summary:

Would you like to be part of an amazing team that helps Arizonans thrive? At the Department of Economic Security (DES) we strengthen individuals, families, and communities for a better quality of life. DES is looking for individuals who are committed to service, community, and teamwork. To learn more about DES please visit des.az.gov; or click on the link here to view ‘Our DES’ video. Come Join the DES Team!

The Department of Economic Security, Division of Technology Services (DTS), is seeking an experienced and highly motivated individual to join our team as a Database Administrator Senior (Senior Database Administrator). The Senior Database Administrator is responsible for the overall management and maintenance of information databases used to operate IT applications and systems, including SQL Server, Azure Databases, Azure Managed Instances and Azure pipelines, including various physical data models, technical architecture, and system interfaces. This position partners and collaborates with other application teams and infrastructure operations to ensure that database performance standards adhere to service level agreements set by the agency.

This position may offer the ability to work remotely within Arizona based upon the department's needs and continual meetings of expected performance measures.

The state of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, commissions, many State employees participate in the State's Remote Work Program and are able to work remotely in their homes, in offices, and in hoteling spaces. All work, including remote work, should be performed within Arizona unless an exception is properly authorized in advance.

Job Duties:

Essential Responsibilities include but are not limited to:

• Partners and collaborates with development teams to design, configures, implement, and administer all data management and governance protocols. Develops and manages the information life-cycle, designs infrastructure and data integration controls. Installs, monitors, proactively solves problems and directs proactive and reactive measures to ensure the availability, integrity, confidentiality and the reliability of database systems.
• Meets performance standards in accordance to service level agreements. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Implements and reviews appropriate security guidelines/mechanisms. Utilizes business strategy and cascades business intelligence needs to the database level.
• Analyzes and reports performance of database operations against the key database performance metrics. Develops and tests database migration procedures and performs database migrations. Designs, configures, implements, and administer all databases for the respective parties involved. Develops database administration tools/utilities/operation procedures.
• Builds and manages the database disaster recovery and backup plan. Performs database maintenance functions. Moves, rebuilds or changes database objects as required in production. Identifies opportunities for use of solutions to improve efficiently and reduce waste.
• Mentors and coaches to others performing similar like job responsibilities while maintaining and enforcing departmental data standards.

Knowledge, Skills & Abilities (KSAs):

Knowledge of:

• Physical data models, technical architecture, system interfaces, database querying and management tools.
• Backup and recovery best practices.
• Query tuning and troubleshooting.
• SQL based query languages, applicable IT systems and applications.
• Policies and procedures for ensuring the security and integrity of databases.
• Proficient with Relational Databases Management System (RDBMS) (e.g. MySQL, SQL Server, etc.).
• Proficient in Google Suite products, MS Office and similar like program (e.g. Linux, Windows, etc.).
• Proficient in installing and supporting Very Large Database (VLDB) systems.

Skill in:

• Leadership, critical thinking, customer centric approach.
• Collaborating with all levels of management and stakeholders.
• Strong customer service skills.
• Negotiate resolution of work issues.
• Maintaining integrity, security, and availability of databases.
• Developing new systems and tools.
• Documenting and maintaining data system procedures.
• Database design, both physical and logical.
• Excellent interpersonal, written and oral communication skills
• Handling high-stress situations and exhibits poise and focus.
• Troubleshooting complex and distributed systems.

Ability to:

• Balance, prioritize, and organize multiple tasks.
• Work collaboratively or in teams and across organization.
• Correlate IT industry standard best practices to regularly executed solutions.
• Develop and write technical documentation.
• Apply creative solutions to business problems to ensure business needs are most effectively.
• Install, model, design and support relational databases.
• Evaluate and test emerging technologies.
• Assist developers in troubleshooting application failures.
• Maintain database availability that will meet required Service Level Agreements.
• Design and implement a high-availability strategy.
• Perform disaster recovery.
• Perform analysis and tuning, index maintenance and monitoring of data organize.
• Mentor, coach and lead others.
• Build strong relationships inside and outside the organizations.

Selective Preference(s):

The ideal candidate for this position will have:

• N/A

Pre-Employment Requirements:

• This position may require driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply: Driver’s License Requirements. Any employee operating a motor vehicle on State business must possess and retain a current, valid class-appropriate driver’s license, complete all required training, and successfully pass all necessary driver’s license record checks. The license must be current, unexpired, and neither revoked nor suspended. Employees who drive on state business are subject to driver’s license record checks, must maintain acceptable driving records, and must complete all required driver training. An employee who operates a personally owned vehicle on state business shall maintain the statutorily required liability insurance (see Arizona Administrative Code (A.A.C.) R2-10-207.11).
• Successfully pass background and reference checks; employment is contingent upon completion of the above-mentioned process and the agency’s ability to reasonably accommodate any restrictions
• All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify)
• Employee shall obtain and maintain a valid Level One fingerprint clearance card that meets DES requirements for a Level One card pursuant to Arizona Revised Statute 41-1969.
• Bachelor’s degree plus 5 or more years of experience in database administration (or equivalent experience).

Benefits:

The Arizona Department of Economic Security offers a comprehensive benefits package to include:

• Affordable medical, dental, life, and short-term disability insurance plans
• Participation in the Arizona State Retirement System (ASRS) and long-term disability plans
• 10 paid holidays per year
• Paid vacation and sick time
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child.
• Deferred compensation plan
• Wellness plans
• Tuition Reimbursement
• Stipend Opportunities
• Infant at Work Program
• Rideshare and Public Transit Subsidy
• Career Advancement & Employee Development Opportunities

By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.

Learn more about the Paid Parental Leave pilot program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page.

Retirement:

State employees are required to participate in the Arizona State Retirement System (ASRS), the State sponsored retirement contribution plan and the Long-Term Disability (LTD) program after a 27-week waiting period. The ASRS defined benefit plan provides for life-long income upon retirement. You will also have the option to participate in a voluntary deferred compensation program to take advantage of tax-deferred retirement investments.

On, or shortly after, your first day of work you will be provided with additional information about the available insurance plans, enrollment instructions, submission deadlines and effective dates.

Contact Us:

For questions about this career opportunity, please contact Benson Walker at (480) 318-4150 or email Bensonwalker@azdes.gov.

The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by calling (480) 318-4150. Requests should be made as early as possible to allow sufficient time to arrange the accommodation.