Database Administrator II

Salary: $81,046.00 - $113,464.00 Annually Location : New Port Richey, FL Job Type: Full Time Job Number: 12568-1124 Department: Information Technology Division: Information Technology Opening Date: 11/15/2024 Closing Date: 11/28/2024 11:59 PM Eastern Salary Range: $81,046.00 - $113,464.00 Pay Grade: P47 (Exempt position) Salary Disclosure: Pay rates are based on education, skill, experience level and internal equity. General Description JOIN OUR TEAM AS A DATABASE ADMINISTRATOR II This is a technical position responsible for the advanced administration, support and maintenance of the entire SQL Server Enterprise Database Management System Stack and Databases of Medium to High Complexity. Additionally, this position will be required to help the county transition to AI data readiness and other AI initiatives. Essential Job Functions Administer SQL Server Database Services, Integration Services (SSIS), REporting Services (SSRS), Analysis Services (SSAS), Power BI Premium/Pro Service, and Power BI Report Server. Learn and implement AI technologies as the County transitions towards AI-driven projects and initiatives. Install, create, maintain, configure, and ensure the integrity of Microsoft SQL Server instances and databases. Implement critical patching on SQL Server OS and apply SQL Server Service Packs and Cumulative Updates across all environments )Sandbox, Test, QA, Production). Secure SQL Server instances and databases, providing key access control. Execute automated monitoring of the SQL Server environment, managing storage, resource capacity, and performance. Administer SQL Server high availability and disaster recovery solutions, ensuring accuracy and completeness of data backup and recovery. Formulate and monitor related policies, procedures, and standards. Utilize the County's software to support SQL Server backup and recovery processes. Administer, manager, monitor, and support SQL Server Power BI and Reporting Services environments both on-premises and in the cloud. Manage data lake and Power BI security, access to reports, dashboards, and data sources. Work closely with IT teams, including application development, report developers, product manager, business analysts, and SMEs to understand and support SQL Server data warehouse/lake/marts ETL administration in support of Power BI. Administer, automate, and support ETL and SSIS across environments, including Power Automate ETL flows, Power BI Dataflows, Power Query, Power BI Designer, data lineage ETL tools, and related jobs. Assist in Power BI report creation and provide high-level support for report development and troubleshooting, Monitor and manage performance and schedules of data sources, reports, and Semantic Model refreshes. Collaborate with IT and business teams for database migrations, upgrades, deployments, modifications, changes, refreshes, and the automation of database processes. Provide support for query optimization, stored procedures, triggers, indexes, and more to ensure system performance. Performs other related duties as required. Knowledge, Skills and Abilities Knowledge of SQL Server and Windows OS, Including administration, maintenance, and support. Knowledge of SQL Server components, including SQL Reporting Services (SSRS), SQL Integration Services (SSIS), and SQL Analysis Services (SSAS). Knowledge of relational databases, database design, and database management. Knowledge of creating and troubleshooting reports with SQL Reporting Services (SSRS) and developing Business Intelligence dashboards using Power BI. Skilled in TSQL, DAX, C#, and PowerShell. Knowledge of ETL practices and the development of ETL workflows using SQL Integration Services (SSIS) and Visual Studio. Proficient in using SQL Server Management Studio, Visual Studio, VS Code, SQL Report Builder, Power BI Desktop, DAX Studio, Azure Data Studio, and Excel. Ability to adjust to changing priorities and manage multiple projects efficiently. Knowledge of AI tools technologies and principles. Minimum Requirements PHYSICAL SKILLS: Ability to communicate effectively using verbal, written, and visual communication. EDUCATION, TRAINING AND EXPERIENCE: Graduation from an accredited college or university with a Bachelor's Degree in Computer Science, Management Information Systems or related field and six (6) years' experience in development and maintenance of relational database systems; OR graduation from an accredited college or university with an Associate degree in Computer Science, Management Information Systems or related field and eight (8) years' experience in development and maintenance of relational database systems; OR graduation from High School or possession of an acceptable general equivalency diploma and ten (10) years' experience in development and maintenance of database systems and Microsoft Database Administrator Certification. LICENSES, CERTIFICATIONS OR REGISTRATIONS: Must possess a valid Florida driver's license. ADA STATEMENT: A qualified employee or applicant with a disability may be afforded a reasonable accommodation to perform the essential job functions of a position in compliance with the Americans with Disabilities Act. DRUG-FREE WORKPLACE: Pasco County BOCC is a drug-free workplace in accordance with Federal and Florida Law. EMERGENCY RESPONSE/RECOVERY ACTIVITIES: All employees will be required to work before, during, or after an emergency. During an emergency, employees may temporarily be assigned to work and perform duties outside the normal scope of their position, location and work schedule to fit the needs of the County and its citizens. VETERANS' PREFERENCE: Under Section 295.07, F.S., Chapter SSA-7, Pasco County BCC provides to veterans, that preference in appointment will be given to preference-eligible applicants. PASCO COUNTY WAS VOTED ONE OF THE NATION'S TOP WORK PLACES FOR 2021 Benefits include: Florida Retirement System (FRS) retirement plan PTO (Paid Time Off) Paid holidays Group insurance Tuition reimbursement Deferred compensation Medical leave pool Annual medical leave buy-back Mid-management/Professional grade, and management personnel may receive 40 hours of admin leave per calendar year. Effective July 1, 2011, FRS members must contribute 3% of their salary as retirement contributions, on a pre-tax basis (the salary is reduced by the amount of the employee contribution before determining the federal income tax deduction). The employer will automatically deduct the employee contributions. 01 I am aware that the following supplemental questions will determine my eligibility for this position. Acknowledge Decline 02 Are you a current Pasco County BOCC employee? Yes No 03 Which best describes your highest level of COMPLETED education? GED High School Associate degree Bachelor's Degree Master's Degree Doctorate None of the above 04 Which best describes the years of experience you have in development and maintenance of relational database systems? Less than one year of experience One year but less than two Two years but less than three Three years but less than four Four years but less than five Five years but less than six Six years but less than seven Seven years but less than eight Eight years but less than nine Nine years but less than ten Ten or more years of experience 05 Do you possess a Microsoft Database Administrator certificate? No Yes 06 Do you possess a valid Florida driver's license or have the ability to obtain the license within 30 days from date of hire? Yes No 07 Are you a veteran who served as a member of the armed forces of the United States during a period of war, defined in Title 38, U.S.C., and who was separated from such service under honorable conditions, or the surviving spouse of any such veteran?(Supporting documentation needed at time of application or next business day) Yes No 08 I hereby acknowledge that Pasco County BOCC is a drug-free workplace in accordance with Federal and Florida law, and consent to pre-employment drug/alcohol testing, and agree to abide by the program and policy if employed by Pasco County BOCC. Acknowledged Declined 09 Are you legally authorized to work in the United States? Note: If hired, a Form I-9, Employment Eligibility Verification, must be completed at the start of employment. Yes No 10 Have you recently retired from the Florida Retirement System (FRS) Pension Plan or Investment Plan within the last 12 months? Yes No 11 Please specifically explain how your prior work experience and education match the qualifications for this position. (1000 characters or less) 12 How did you hear about this position? Billboard Facebook Friend/Family Referral Indeed Job Fair LinkedIn Magazine publication Pasco County employee Pasco County Traffic Sign Utility bill insert Pasco County website/Governmentjobs.com Other 13 If a Pasco County employee referred you, please provide the name of the employee. Required Question