Senior DBA - Technology Solutions

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues and document changes.
• Assist developers with complex query tuning and schema refinement.
• Provide 24x7 support for critical production systems.
• Perform scheduled maintenance and support release deployment after hours.
• Conduct periodic database restoration and recovery to ensure viability of backup methodology. 
• Make changes for stored procedures and other database objects to the production environment.
• Install and configure new SQL Servers.
• Deploy database change scripts provided by third party vendors.
• When performance issues arise, determine the most effective way to increase performance including server configuration changes.
• Serve as subject matter expert for IT projects, products and services.
• Conduct proactive maintenance of IT infrastructure with minimal supervision including maintaining high level of systems availability, monitoring systems performance and reliability to mitigate outages and system interruptions, managing tools for providing early warning and alerts, and monitoring system capacity utilization and taking proactive steps to avoid over utilization.
• Work with vendors to resolve system outages.
• Work closely with other technology and application personnel to understand and implement application requirements, server/network/storage tuning, and configuration changes.
• Consult in design of new applications and services to ensure they can be support by the infrastructure
• Diagnose and resolve technical issues, conduct root cause analysis, and demonstrate consistent level of accuracy with basic problem resolution.
• Maintain an in-depth knowledge of a specific current technology, both internally and within IT industry, and its applicability to the organization.
• Operate personal computer including word, spreadsheet, database, and other related software to include Visio.
• Respond to and resolve assigned tickets and requests.
• Demonstrate proficiency in the City of Jacksonville Core Competencies.
• Proficient communication and presentation skills. 
• Must be able to clearly document technical information for team review and for management.
• At times when required, must be able to cross-train and perform other server and database functions.
• After hours work as required.
• Performs related work as required.

• Eight years of education and/or experience in information technology which must include at least four years of professional experience with MS SQL Server Administration and proficiency with Windows Server 2008 through 2022 operating systems.
• Must have experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. 
• Must have experience with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Report Services (SSRS) of MS SQL Server Tools. 
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.   
• Requires periodic work during evening/weekend hours to provide support and project implementation

Preferred

• Bachelor's degree from an accredited institution in IT, Computer Science, or related field preferred. 

Other Requirements:  

• Must pass the Criminal Justice Information Services (CJIS) background screening performed by the Jacksonville Sherriff’s Office prior to appointment.

• Within 30 days of appointment date to classification, acquire and maintain the appropriate level of Criminal Justice Information Systems (CJIS) certification which corresponds to the job responsibilities. The level will be determined by current CJIS guidelines and may change periodically. Certification is obtained by successfully completing a web-based training course and test which covers physical security, incident response, the protection of information and other IT specific security threats, vulnerabilities, and risks.

A FULLY COMPLETED ONLINE APPLICATION IS REQUIRED. Apply at www.jacksonville.gov. Work history is required for all employment/volunteer work in which qualifications are being based. When meeting/basing qualifications on education, a copy of your college transcript, with your social blacked out, is required with your application. U.S. transcripts do not need to be official, but must state your name, the school’s name, classes taken, grades received, type of degree, and date degree was conferred. Transcripts outside the U.S. must be converted to U.S. standards.
 
The application system works best with Google Chrome or Edge with Chromium web browsers. Please try to apply using one of these browsers. To ensure you receive email notifications, be sure to make “info@governmentjobs.com” a trusted sender. You may also track the status of your application and see notifications by logging into your account. For further information regarding the application process. please refer to the Frequently Asked Questions on the website.
 
Certain servicemembers and veterans, and the spouses and the family members of such service members and veterans, receive preference and priority, and certain servicemembers may be eligible to receive waivers for postsecondary educational requirements, in employment and are encouraged to apply for positions being filled.
 
If claiming veteran's preference, you must attach a DD-214 (Member Form-4 copy) or military discharge papers, or equivalent certification from the Department of Veterans Affairs listing military status, dates of service and character of discharge. You must also attach the Veterans Preference Certification Form and if applicable, the additional forms as noted here: http://www.coj.net/departments/employee-services/veterans-preference.
 
If a candidate believes he or she was not afforded veteran’s preference, he or she may file a written complaint, within sixty (60) calendar days upon receipt of notification of the hiring decision, requesting an investigation to:

Florida Department of Veterans Affairs
Attention: Veterans’ Preference Coordinator
11351 Ulmerton Road, Suite 311-K  
Largo, FL 33778-1630 
Email: VeteransPreference@fdva.state.fl.us