Applications Developer SeniorLead Sql Server Database Administrator
Applications Developer SeniorLead Sql Server Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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.
APPLICATIONS DEVELOPER SENIOR/LEAD (SQL SERVER DATABASE ADMINISTRATOR)
Division of Technology Services (DTS)
1400 West Washington Street Phoenix Arizona 85007
Salary: $95000.00 Annually
Grade: 27
Closing Date: April 20 2025
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 ; or click on the link here to view Our DES video. Come Join the DES Team!
DES is seeking an experienced and highly motivated individual to join our team as a Applications Developer Senior/Lead (SQL Server Database Administrator). This position is responsible for the overall management and maintenance of information databases used to operate IT applications and systems. The DBA partners with application teams and infrastructure operations to ensure that database performance is not hindered and performance standards adhere to service level agreements set with the enterprise. DBA will manage and maintain SQL Ml/ SQL Server/Postgre SQL databases ensuring their performance availability security and integrity through tasks like monitoring backups performance tuning and troubleshooting.
This position may offer the ability to work remotely within Arizona based upon the departments business needs and continual meeting of expected performance measures.
The State of Arizona strives for a work culture that affords flexibility autonomy and trust. Across our many agencies boards commissions many State employees participate in the States 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.
Essential Duties and Responsibilities include but are not limited to:
Partners with development teams to design data management and governance protocols manages the information lifecycle and design infrastructure and data integration controls. Proactively solves problems. Installs monitors. and directs proactive and reactive measures to ensure the availability integrity confidentiality and reliability of database systems.
Meets performance standards in accordance to service level agreements set by the company. Identifies data sources constructs data decomposition diagrams provides data flow diagrams and documents the process. Implement and review appropriate security guidelines/mechanisms.
Analyzes and reports the performance of database operations against the key database performance metrics. Develops and test database migration procedures and performs database migrations.
Designs configures implements and administers 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. Move rebuild or change database objects as required in production.
Knowledge of:
Conceptual Logical and Physical data models technical architecture system interfaces etc.
Indepth knowledge of SQL with an emphasis on the Azure Platform SQL Ml
PostgreSQL I Vector Databases
High availability and disaster recovery solutions
Azure DevOps Cl/CD
Skills In:
Strong experience using AZURE SQL Ml.
Performance Tuning and Optimization and strong verbal and written communication skills.
Experience with database security best practices and backup/recovery procedures
Migrating onprem databases to the cloud platform
Proficient with relational databases SQL Server)
Ability to:
Document database configurations procedures standards and ensure adherence to database policies and procedures.
Organize plan and coordinate activities that are beneficial for all DES administrations.
Model and design relational databases to include installing and supporting relational database management systems (ROMS).
Find root causes of problems and quickly determines efficient solutions
Perform independent research and utilize that research to the strategic advantage of the DTS.
Assist developers in troubleshooting the cause of SQL and/or application failures while maintaining database availability that will meet required Service Level Agreements.
This ideal candidate for this position will have:
5 or more years of SQL Server with managing cloud based databases.
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: Drivers License Requirements.
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 411969.
Bachelors degree plus 8 or more years of programming and analysts experience (or equivalent experience).
Microsoft Certified in Azure Data Fundamentals and Azure Database Administrator Associate
Successfully pass background and reference checks; employment is contingent upon completion of the abovementioned process and the agencys ability to reasonably accommodate any restrictions.
All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (EVerify).
The Arizona Department of Economic Security offers a comprehensive benefits package to include:
Affordable medical dental life and shortterm disability insurance plans
Participation in the Arizona State Retirement System (ASRS) and longterm disability plans
10 paid holidays per year
Vacation time accrued at 4.00 hours biweekly for the first 3 years
Paid Parental LeaveUp to 12 weeks per year paid leave for newborn or newlyplaced foster/adopted child (pilot program).
Sick time accrued at 3.70 hours biweekly
Deferred compensation plan
Wellness plans
Tuition Reimbursement
Stipend Opportunities
Infant at Work Program
Rideshare and Public Transit Subsidy
Career Advancement & Employee Development Opportunities
Flexible schedules to create a work/life balance
By providing the option of a fulltime or parttime 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 programhere. For a complete list of benefits provided by The State of Arizona please visit our benefits page
State employees are required to participate in the Arizona State Retirement System (ASRS) the State sponsored retirement contribution plan and the LongTerm Disability (LTD) program after a 27week waiting period. The ASRS defined benefit plan provides for lifelong income upon retirement. You will also have the option to participate in a voluntary deferred compensation program to take advantage of taxdeferred 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.
For questions about this career opportunity please contact Jason Hamm ator
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 contactingor Requests should be made as early as possible to allow sufficient time to arrange the accommodation.
Required Experience:
Senior IC
Employment Type
Full-Time
