SR IT PROFESSIONAL - APPLICATONS (DATABASE PROFESSIONAL) Print (https://www.governmentjobs.com/careers/houston/jobs/newprint/4773701) Apply  SR IT PROFESSIONAL - APPLICATONS (DATABASE PROFESSIONAL) Salary $84,838.00 - $106,499.90 Annually Location 8000 N. Stadium Job Type Full Time Job Number 35757 Department Houston Health Department Division HHD - Information Technology Opening Date 01/07/2025 + Description + Benefits + Questions POSITION OVERVIEW Applications Accepted From: ALL PERSONS Posting Number: 35757 Division: Houston Information Technology Services Reporting Location: 8000 N Stadium Dr, Houston, TX 77030 Workdays & Hours: Saturday – Friday; 40 hours*** ***Subject to Change DESCRIPTION OF DUTIES / ESSENTIAL FUNCTIONS + Database Installation and Configuration: Setting up and configuring SQL Server instances, ensuring optimal performance and security settings. + Performance Monitoring: Continuously monitoring database performance, analyzing query execution plans, and identifying bottlenecks to optimize performance. + Backup and Recovery: Implementing and managing backup and recovery strategies to ensure data integrity and availability in case of failures. + Security Management: Managing user access and permissions, ensuring that data is secure and compliant with regulations. + Troubleshooting and Support: Diagnosing and resolving database issues, providing support to application teams and end-users. + Database Maintenance: Performing routine maintenance tasks such as indexing, updating statistics, and ensuring data consistency. + Capacity Planning: Monitoring database growth and planning for future capacity needs to accommodate increasing data loads. + Replication and High Availability: Implementing and managing database replication and high-availability solutions to ensure uptime. + Data Migration: Assisting with the migration of databases to new environments or versions, ensuring minimal downtime. + Documentation: Maintaining detailed documentation of database configurations, processes, and procedures for reference and compliance. + Upgrades and Patching: Applying patches and upgrades to the SQL Server environment to maintain security and performance. + Collaboration: Working closely with developers, network engineers, and other IT staff to design and implement database solutions that meet business needs WORKING CONDITIONS This position is physically comfortable; the individual has discretion about walking, standing, etc. There are no major sources of discomfort in a normal office environment. MINIMUM REQUIREMENTS EDUCATION REQUIREMENTS Requires a Bachelor’s degree in Computer Science, Management and Information Systems (MIS) or a closely related field. Usually has advanced technical certifications that demonstrate mastery of a specialized applications. EXPERIENCE REQUIREMENTS At least six (6) years of technology experience supporting applications. Advanced certifications and/or greater than six (6) years applicable experience may be substituted for up to two (2) years of the education requirement. LICENSE REQUIREMENTS None PREFERENCES **Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for, such persons are among the most qualified candidates for the position, and all other factors in accordance with Executive Order 1-6. ** Preferences will be given to those with the following skill sets: + SQL Server Proficiency: 6 Years of strong knowledge of MS SQL Server, including its architecture, features, and tools. + T-SQL Programming: Proficient in Transact-SQL (T-SQL) for writing queries, stored procedures, and functions. + Database Design: Understanding of data modeling and database design principles, including normalization and indexing strategies. + Performance Tuning: Skills in optimizing query performance and database operations, using tools like SQL Server Profiler and Execution Plans. + Backup and Recovery: Knowledge of backup strategies and disaster recovery planning, including implementing point-in-time recovery. + Security Management: Familiarity with SQL Server security features, including roles, permissions, and auditing. + High Availability and Disaster Recovery (HADR): Experience with solutions such as Always On Availability Groups, replication, and clustering. + Monitoring and Troubleshooting: Ability to monitor database health and performance, and troubleshoot issues effectively. + Scripting and Automation: Proficiency in PowerShell or other scripting languages for automating tasks and managing databases. + Data Migration: Skills in migrating data between environments and different versions of SQL Server. + ETL Processes: Familiarity with SQL Server Integration Services (SSIS) for data extraction, transformation, and loading. + Reporting and Analysis: Experience with SQL Server Reporting Services (SSRS) or other reporting tools. + Documentation: Strong documentation skills for maintaining records of configurations, processes, and procedures. + Collaboration and Communication: Ability to work effectively with cross-functional teams, including developers, network engineers, and management. + Continuous Learning: A willingness to stay updated with the latest SQL Server features and industry trends. + DevOps: Experience working on DevOps. + Data Visualization: Working experience creating dashboards using data visualization tools. GENERAL INFORMATION SELECTION / SKILLS TESTS REQUIRED None; however, Department may administer skills assessment test. SAFETY IMPACT POSITION NO If yes, this position is subject to random drug testing and if a promotional position, candidate must pass an assignment drug test. SALARY INFORMATION Grant Funded Grant positions are dependent upon continued available funds. If funding is no longer available, employee may be laid off or transferred. Factors used in determining the salary offered include the candidate’s qualifications as well as the pay rates of other employees in this classification. PAY GRADE: 29 APPLICATION PROCEDURES Only online applications will be accepted for this City of Houston job and must be received by the Human Resources Department during active posting period. Applications must be submitted online at: www.houstontx.gov. To view your detailed application status, please log-in to your online profile by visiting: http://agency.governmentjobs.com/houston/default.cfm or call (832/393-4882). If you need special services or accommodations, call (832/393-4882). (TTY 7-1-1) If you need login assistance or technical support call 855-524-5627. Due to the high volume of applications received, the Hiring Department will contact you directly, should you be selected to advance in our recruitment process. All new and rehires must pass a pre-employment drug test and are subject to a physical examination and verification of information provided. EOE - Equal Opportunity Employer The City of Houston is committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, genetic information, veteran status, gender identity, or pregnancy. The city offers a competitive benefits program, including competitively priced health coverage and a defined contribution pension plan. Benefits include: + Medical + Dental + Vision + Wellness + Supplemental Insurance + Life insurance + Long-term disability + Retirement pension + 457 deferred compensation plan + Employee Assistance Program + 10 days of vacation each year + 11 city holidays, plus one floating holiday + Compensable Sick Leave + Personal Leave + Flexible schedules + Hybrid-Telework for eligible positions + Professional development opportunities + Transportation/parking plan + Section 125 pretax deductions + Dependent Care Reimbursement Plan + Paid Prenatal, Parental and Infant Wellness Leaves + Healthcare Flexible Spending Account For plan details, visit http://www.houstontx.gov/hr/benefits.html 01 Are you a veteran who served on active duty in the Armed Forces (United States Army, Navy, Air Force, Marine Corps, or Coast Guard) for more than 90 consecutive days and received either an honorable discharge or a general discharge under honorable conditions? + Yes + No 02 Which best describe your completed education? + High School Diploma + Associate Degree + Bachelor's Degree + Master's Degree or Beyond + None of the Above 03 Which area of concentration did you obtain your degree? + Computer Science + Information Technology + Management and Information Systems (MIS) + Business Administration + Engineering + My degree is not listed + I have no degree 04 Which best describes your experience supporting applications in a Healthcare Setting? + Less than 3 years of verifiable experience + 3 years of verifiable experience + 4 years of verifiable experience + 5 years of verifiable experience + 6 years of verifiable experience + 7 years of verifiable experience + 8 years of verifiable experience + 9 years of verifiable experience + 10 or more years of verifiable experience + I have no verifiable experience 05 How many years of working experience using MS SQL Server? + Less than 3 years of experience + 3 years of experience + 4 years of experience + 5 years of experience + 6 years of experience + 7 years of experience + 8 years of experience + 9 or more years of experience + I have no related experience 06 How many years of working experience using Azure or Snowflake? + Less than 3 years of experience + 4 years of experience + 5 years of experience + 6 years of experience + 7 years of experience + 8 years of experience + 9 ormore years of experience + I have no experience 07 . Which of the following do you have experience with? (Need All) + MS SQL + ETL Processes + Building Clusters + Data visualization + SSRS + SSIS + None of the Above 08 How many years of working experience using Data tools? + Less than 6 years of experience + 6 years of experience + 7 years of experience + 8 years of experience + 9 years of experience + 10 years of experience + 11 or more years of experience + I have no experience working with Rhapsody 09 Describe your experience and provide the number of years working on a clustered environment. Required Question