IT Database Senior Analyst
City of Chandler Chandler, AZ 85225 Posted 4 days The City of Chandler Police Department is currently seeking qualified individuals interested in joining our team as the IT Database Senior Analyst. This position plans, creates, installs, supports, and maintains complex departmental databases; and, facilitates department access and use while maintaining security protocols provides backup support for enterprise databases. This is a regular full-time, exempt position with benefits. The anticipated work schedule for this position is a Monday-Friday, on-site; on-call and weekends as needed. Why work for Chandler? Diverse and inclusive environment
Up to 8 hours paid time off annually to volunteer in the community
Dress code is business casual
3 medical plans to choose from along with dental and vision coverage
Accrue 122 hours paid vacation in your first year, eligible for use immediately following accrual
Accrue 96 hours paid sick leave in your first year, eligible for use immediately following accrual
12 paid holidays per year, plus Winter Break at the end of the year
Become part of the Arizona State Retirement System with a 100% city contribution match
City contributions of 1% gross wages per pay period to deferred compensation upon employee contribution
Robust Employee Wellness program with $350 incentive
Professional development opportunities
Tuition reimbursement up to $5,250 annually
Free Tumbleweed Recreation Center membership Who we are The City of Chandler Police Department, consisting of 348 sworn officers and 192 civilians, serves a growing population of approximately 290,000 residents. The organization is divided into three main divisions, one bureau, and many sections/units. The Patrol Operations Division three precincts, 1) Main Station
- Downtown & North Chandler, 2) Desert Breeze
- West Chandler, and 3) Chandler Heights
- South Chandler, work in concert with the Criminal Investigations Bureau, Operational Support Bureau, and Professional Services Division to meet the needs of the community.
The members of the Chandler Police Department are dedicated to the advancement of community policing and the development of a partnership with our citizens. Our mission is, "To maintain a safe, vibrant community through meaningful engagement and continuous organizational improvement." We are committed to being a world-class leader in law enforcement. We will pursue and engage the best trained, equipped, and committed professionals who demonstrate the highest standards of performance and best policing practices in partnership with the community. Who we are looking for Our ideal candidate will have a passion for customer service, teamwork, and collaboration. We are looking for an individual who enjoys working in a fast-paced environment; and, when assigned to the Police Department IT Section, the successful candidate must be able to do the following: Must be able to analyze, plan, design, and implement high reliability availability and scalability solutions for enterprise SQL database environments assist with capacity planning.
Performs database recovery backups clones refreshes exports imports storage maintenance and security maintenance task for multiple databases.
Drafts documentation including standard operating procedures.
Develops modifies and optimizes SQL scripts and determines modifications to tune database performance provides solutions and recommendations for improvements.
Serves as database technical expert to the department.
Coordinates database related projects including assignment schedules and plans.
Plans and conducts maintenance functions migration and upgrades coordinates with users and vendors ensures compliance with vendor license agreement. To view the complete job description, please click here. Minimum qualifications Must possess a Bachelor's Degree in Computer Science, Information Technology or in a related field of study; and
Must have at least 4-years of experience in database management, administration and support in a SQL environment that includes clustering; and
Must possess a valid driver's license with acceptable driving record.
Any equivalent combination of experience and training which provides the knowledge and abilities necessary to perform the work. Desired qualifications Strong experience with Microsoft SQL Server (2019 or newer) and Azure SQL Database / Managed Instance.
Experience with high availability and disaster recovery solutions such as Always On, clustering, replication, and log shipping.
Experience with database backup, restore, and data protection tools.
Understanding of cloud and hybrid database environments.
Experience with Azure data or BI services such as MSBI or Fabric.
Scripting or automation experience using PowerShell, Python, or Bash.
Experience supporting cloud migrations or database modernization projects.
Microsoft or Azure database certification is a plus. Supervision Work is performed under the supervision of a division supervisor or manager. This position does not supervise others. Application Process NeoGov Application
Preliminary Background Questionnaire Submittal & Review
Oral Board Interview
Background Interview
Interview with Chief of Police
This is a full-time, exempt position with benefits, with a Monday-Friday, on-site; on-call and weekends as needed. This opportunity is only open to current City of Chandler employees only. A register of qualified candidates will be active for 6 months should another position become available. The City of Chandler will conduct a pre-employment background check as a condition of employment. An offer of employment is contingent upon acceptable results. All applicants hired will be required to be fingerprinted with successful results as a condition of continued employment. Applicants for employment and volunteer opportunities should be aware of the City of Chandler's policies concerning the use of drugs and alcohol. These policies have not been altered by the passage of Proposition 207. The use of recreational marijuana is a violation of the city's Drug Free Workplace Policy. Certain positions within the city are required to submit to a pre-employment drug test. A positive result for drugs tested under the policy, including recreational marijuana, may be grounds for withdrawal of an offer of employment or volunteer opportunity. The examination process may vary if determined necessary. The City of Chandler is committed to Equal Opportunity and Reasonable Accommodation. Job Details Seniority Level Some work experience (up to 5 years, non-manager) Area of Interest Government & Public Administration Employment Type Full Time Number of openings N/A
