Senior database administrator Job at State of Arizona, Phoenix, AZ

aHhsb21nMlNkbTh4VGNMaEtzbml0MHBv
  • State of Arizona
  • Phoenix, AZ

Job Description

Department of Education

The Arizona Department of Education is a service organization committed to raising academic outcomes and empowering parents.

Senior Database Administrator

Job Location:

Address: Information Technology Division
Phoenix, AZ 85007

Posting Details:

Salary: $80,000 - $85,000

Grade: 27

Closing Date: 10/15/24

Job Summary:

Responsible for assisting with the management of all aspects of the Arizona Department of Education's data including but not limited to:



  • Database backup and recovery
  • Logical and physical database design
  • Designing and writing stored procedures
  • Database maintenance
  • Disaster recovery
  • Database connectivity
  • Database replication
  • Database performance and tuning
  • Database naming conventions and standards
  • Installation and configuration of database software (SQL Server)
  • Database upgrades
  • Diagnosing and correcting database operational problems
Rare in-state travel is required for this position


The Arizona Department of Education currently utilizes a hybrid work environment, with up to two days of remote work (contingent upon business needs). Candidates should apply with an ability and willingness to work in-office up to five days per week as business needs necessitate.

Job Duties:

  • Assist and cross-train in the work of other database administrators
  • Review and recommend improvements to existing architecture
  • Tune performance, review and recommend improvements to existing code
  • Meet with other IT staff to determine scope of system requirements related to data storage, retrieval and performance
  • Design and code stored procedures and scripts to facilitate database administration (Powershell experience desired)
  • Develop database administration tools/utilities/operation procedures
  • Assist in developing purge/archive criteria and procedures for historical application data
  • Proactively solve complex problems
  • Review, evaluate, design, implement and maintain company database[s]
  • Implement and review appropriate security guidelines/mechanisms
  • Implement database migrations and changes
  • Management of Azure database virtual machines
  • Troubleshoot application key selection, creation of appropriate indexes, and query needs
  • Ensure that databases are operational and functioning properly
  • Perform database maintenance functions
  • Move, rebuild, or change database objects as required in production
  • Develop and test database migration procedures
  • Assist in interviewing and training new hires and provide guidance to Junior Developers when required
  • Manage SQL Server Always On configurations
  • Provide on-call support to correct database issues or assist with other processes that require off-hours support
  • Educate users and maintains database documentation
  • Establish database procedures and standards; assists in database design
  • Other duties as assigned as related to the position

Knowledge, Skills & Abilities (KSAs):

Knowledge in:

  • General working knowledge of physical data models, technical architecture, system interfaces, etc.
  • Database Software: SQL Server 2000 - SQL Server 2022
  • Hardware installation and configuration (Azure)
  • SQL Server Clustering
  • Transact-SQL and stored procedure design
  • Database performance tuning replication
  • Disaster recovery planning
  • Backup/recovery planning
  • SQL Server Always On groups
  • A Bachelor’s degree plus five or more years of experience in database administration, or equivalent experience to substitute for the degree, is required (Skills can be acquired by trouble shooting software and hardware issues in a generic computer environment. Logical prowess can be cultivated in basic mathematics training, puzzle solving, formal logic training.)
Skills in:

  • Analysis and problem solving for complex information and data collection systems
  • Strong customer service skills
  • Excellent interpersonal, written and oral communication skills
  • Intermediate to advanced skill in using Microsoft Outlook, Word, and Excel
Ability to:

  • Develop and write technical documentation
  • Model and design relational databases
  • Install and support relational database management systems (RDMS)
  • Evaluate and test emerging technologies
  • Apply creative solutions to business problems to ensure business needs are most effectively
  • Balance, prioritize and organize multiple tasks
  • Work collaboratively in teams and across organizations
  • Synthesize feedback and adjust plans accordingly
  • Build strong relationships inside and outside the organization

Selective Preference(s):

Pre-Employment Requirements:

Offers are contingent upon successful completion of all background and reference checks, required documents and, if applicable, a post-offer medical/physical evaluation.

If this position requires 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.


All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Benefits:

The State of Arizona provides an excellent comprehensive benefits package including:



  • Affordable medical, dental, life, and short-term disability insurance plans
  • Top-ranked retirement and long-term disability plans
  • Ten paid holidays per year
  • Vacation time accrued at 4.00 hours bi-weekly for the first 3 years
  • Sick time accrued at 3.70 hours bi-weekly
  • Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
  • Deferred compensation plan
  • Wellness plans

Retirement:

You will be required to participate in the Arizona State Retirement System (ASRS) upon your 27th week of employment, subject to waiting period. On or shortly after, your first day of employment you will be provided with enrollment instructions and effective date.

Contact Us:

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 (602) 542-3186 or emailing Human.Resources@azed.gov. Requests should be made as early as possible to allow sufficient time to arrange the accommodation.

Job Tags

Remote job, Holiday work, Full time, Temporary work,

Similar Jobs

Tallahassee Community College

Program Specialist II (Grant Specialist) Job at Tallahassee Community College

Program Specialist II (Grant Specialist) Location Tallahassee, FL : TITLE: Program Specialist II - Charter Grant Program POSITION NO.:...  ...APPLICANTS WILL DEMONSTRATE THE FOLLOWING: Skill in operating personal computer software: Word, Excel, Access, PowerPoint and Outlook.... 

Career Renew

DevOps Engineer - Blockchain Job at Career Renew

 ...Career Renew is recruiting for one of its clients a DevOps Engineer - Blockchain - this is a hybrid role in Ashburn, VA. We operate with a lean, highly motivated team who revel in the responsibility that comes with autonomy. We have a flat organizational structure,... 

Luxus

Architectural Designer Job at Luxus

 ...Architectural Designer Location: Maitland, Florida Company: Luxus Build Salary Range: $80,000 $110,000 About Us: A leader in innovative and client-focused architectural design. Based in Maitland, Florida, we specialize in delivering exceptional design... 

Bashas'

Starbucks Barista Job at Bashas'

 ...Position Purpose: Our Baristas will be responsible for executing the Starbucks Experience for Bashas' customers by providing customers with prompt service, quality beverages and products, and maintaining a clean and comfortable store environment. Responsibilities... 

Broad River Rehabilitation

Speech Language Pathologist / Speech Therapist / SLP Job at Broad River Rehabilitation

Speech Language Pathologist/ SLP-CCC - Part time Skilled nursing facility in Lima, Ohio Part Time position (2-5 days/week) flexible scheduling!! **Offering $2,500 Sign on Bonus**Benefits for part time would include: Accrued PTO 401k Company Paid...