IT Database Senior Analyst

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 ., Work is performed under the supervision of a division supervisor or manager. This position does not supervise others.

• 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.

Tuition reimbursement, Health insurance, Paid time off, Vision insurance, Dental insurance, Paid sick time, Paid holidays, Wellness program, * Job Announcement 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, This is a full-time, exempt position with benefits, with a Monday-Friday, on-site; on-call and weekends as needed. 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. The City of Chandler offers a comprehensive benefits package for full-time and some part-time positions. For more detailed information on the benefits offered, please Click Here .

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, + City of Chandler Arizona About Team Chandler When you join Team Chandler you join a team of more than 1,800 employees who make a difference, serving and responding to local community needs, as well as supporting each other. We have a customer service philosophy to connect our customers (internal and external) to the information, services and people who can best meet their needs. We are proud of our seamless service commitment and the high customer service ratings we receive. Our Mission: We are committed to serve Chandler's citizens through teamwork, understanding and dedication in a professional and responsive manner. About the City of Chandler: Since being founded by Dr. A.J. Chandler in 1912, Chandler has been a forward-thinking, world-class community built on entrepreneurial spirit, innovation and hometown traditions. A longheld commitment to thoughtful, constructive and consistent planning has transformed Chandler into the Innovation and Technology Hub of the Southwest. Chandler is known for its safe and inviting neighborhoods, superior schools, abundant recreation and one-of-a-kind entertainment, dining and shopping experiences as well as a vibrant Downtown. We are proud to offer many exceptional employee benefits, including a generous compensation package with comprehensive benefits, medical and dental insurance, paid time off and substantial automatic retirement contributions. Additionally, we invest in employee success by providing many resources designed to support your personal and professional growth, including: Comprehensive Health Plans and Other Core Insurance State Retirement Programs and Pension Options Retiree Insurance for Lifetime Medical Benefits Continuing Education & Lifelong Learning Programs Tuition scholarships for employees and their dependents Leadership and Professional Development Programs Mental and Physical Wellness Programs Employee Recognition Programs and Longevity Pay