IT Database Senior Analyst

<a data-fr-linked="true" href="https://www.governmentjobs.com/careers/chandleraz/classspecs/1525934" data-pasted="true" data-uw-rm-brl="PR" data-uw-original-href="https://www.governmentjobs.com/careers/chandleraz/classspecs/1525934" aria-label="governmentjobs.com" data-uw-rm-empty-ctrl=""></a><p data-pasted="true">The City of Chandler Police Department is currently seeking qualified individuals interested in joining our team as the <strong>IT Database Senior Analyst</strong>.  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.</p><p><strong><u>Why work for Chandler?</u></strong></p><ul style="margin-bottom: 3pt;"><li>Diverse and inclusive environment</li><li>Up to 8 hours paid time off annually to volunteer in the community</li><li>Dress code is business casual</li><li>3 medical plans to choose from along with dental and vision coverage</li><li>Accrue 122 hours paid vacation in your first year, eligible for use immediately following accrual</li><li>Accrue 96 hours paid sick leave in your first year, eligible for use immediately following accrual</li><li>12 paid holidays per year, plus Winter Break at the end of the year</li><li>Become part of the Arizona State Retirement System with a 100% city contribution match</li><li>City contributions of 1% gross wages per pay period to deferred compensation upon employee contribution</li><li>Robust Employee Wellness program with $350 incentive</li><li>Professional development opportunities</li><li>Tuition reimbursement up to $5,250 annually</li><li>Free Tumbleweed Recreation Center membership</li></ul><p><br></p><p><strong><u>Who we are</u></strong></p><p>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, “<strong><em>To maintain a safe, vibrant community through meaningful engagement and continuous organizational improvement</em></strong>.”  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.</p><p><strong><u>Who we are looking for</u></strong></p><p>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 <strong>Police Department IT Section,</strong> the successful candidate must be able to do the following:</p><ul style="margin-bottom: 3pt;"><li>Must be able to analyze, plan, design, and implement high reliability availability and scalability solutions for enterprise SQL database environments assist with capacity planning.</li><li>Performs database recovery backups clones refreshes exports imports storage maintenance and security maintenance task for multiple databases.</li><li>Drafts documentation including standard operating procedures.</li><li>Develops modifies and optimizes SQL scripts and determines modifications to tune database performance provides solutions and recommendations for improvements.</li><li>Serves as database technical expert to the department.</li><li>Coordinates database related projects including assignment schedules and plans.</li><li>Plans and conducts maintenance functions migration and upgrades coordinates with users and vendors ensures compliance with vendor license agreement.</li></ul><p><br></p><p>To view the complete job description, please <a href="https://www.governmentjobs.com/careers/chandleraz/classspecs/1525934" data-uw-rm-vglnk="" data-uw-rm-brl="PR" data-uw-original-href="https://www.governmentjobs.com/careers/chandleraz/classspecs/1525934">click here</a>.</p><p><br></p><p><strong><u>Minimum qualifications</u></strong></p><ul style="margin-bottom: 3pt;"><li>Must possess a Bachelor’s Degree in Computer Science, Information Technology or in a related field of study; and</li><li>Must have at least 4-years of experience in database management, administration and support in a SQL environment that includes clustering; and</li><li>Must possess a valid driver’s license with acceptable driving record. </li><li>Any equivalent combination of experience and training which provides the knowledge and abilities necessary to perform the work.</li></ul><p><br></p><p><strong>Desired qualifications</strong></p><ul style="margin-bottom: 3pt;"><li>Strong experience with Microsoft SQL Server (2019 or newer) and Azure SQL Database / Managed Instance.</li><li>Experience with high availability and disaster recovery solutions such as Always On, clustering, replication, and log shipping.</li><li>Experience with database backup, restore, and data protection tools.</li><li>Understanding of cloud and hybrid database environments.</li><li>Experience with Azure data or BI services such as MSBI or Fabric.</li><li>Scripting or automation experience using PowerShell, Python, or Bash.</li><li>Experience supporting cloud migrations or database modernization projects.</li><li>Microsoft or Azure database certification is a plus.</li></ul><p><br></p><p><strong>Supervision</strong></p><p>Work is performed under the supervision of a division supervisor or manager. This position does not supervise others.</p><p><strong>Application Process</strong></p><ul style="margin-bottom: 3pt;"><li>NeoGov Application</li><li>Preliminary Background Questionnaire Submittal & Review</li><li>Oral Board Interview</li><li>Background Interview</li><li>Interview with Chief of Police</li></ul><p>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.  </p><p><br></p><p>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.</p><p>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.</p><p><br></p><p><strong>The City of Chandler is committed to Equal Opportunity and Reasonable Accommodation.</strong></p><br>