City of Tampa

This is responsible database administration and systems analysis work.

An employee in this class is responsible for performing a variety of technical database and systems analysis tasks of more than average difficulty. Employees coordinate and monitor the work of technical project team members in the completion of specified assignments. Tasks include the design, development or modification, testing, and implementation of database systems, and related procedures. Tasks require that the employees consult with user personnel, functional data processing personnel, and other project team members to resolve technical questions. Although under general supervision, employees are expected to exercise considerable initiative and independent judgment in selecting work methods and performing assigned tasks. An employee in this class may be subject to on-call status on a rotating basis to provide 24-hour/7 day service. Work is reviewed while in progress and upon completion through discussions and reports submitted.

Develops and/or modifies database systems from specifications; develops and/or modifies production runs accordingly; prepares database specifications and production run specifications from functional and technical system design; assists in technical systems design from functional specifications; develops documentation or modifies existing documentation for programs and production runs according to standards.

Designs and develops data conversion processes using industry standard methodologies to extract, transform, and  load data from source to target databases for use in reporting or conversions; prepares test data and verifies system results; analyzes and resolves system problems; consults with users, project team members (both technical and functional) on questions or problems.

Participates in training programs to develop new skills and maintain existing competencies; conducts training sessions; assists in the preparation and delivery of user training programs.

Analyzes problems and implements solutions; consults with functional team members, users, and technical project team members on technical questions; coordinates, schedules, assigns, and monitors the work of technical project team members.

Conducts cost/benefit analyses; conducts technical research and prepares and presents reports on findings; coordinates system conversion efforts; analyzes network infrastructure and software and makes recommendations; evaluates, acquires, and coordinates upgrades/installations.

Coordinates system conversion efforts and performs necessary tasks; prepares test data and verifies system test results; analyzes and resolves system problems; consults with users and technical and functional project team members on questions or problems.

Coordinates system/disaster recovery efforts and performs necessary tasks related to recovery requirements, documentation, testing, and resolves restoration problems.

Performs related work as required.

Considerable knowledge of: Microsoft SQL Server 2016 or higher; data analysis techniques, database clustering, database systems within virtual environments; understanding of relational database design; understanding of data warehousing concepts.

Working knowledge of: Desired experience in Windows Operating Systems 2019 or higher, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Management Studio, Microsoft Office, Azure DevOps, and ESRI ArcGIS 10.9 or higher.

Ability to: Implement/maintain/support databases; analysis/needs assessments for database related requests; performing ETL functions; perform production change control; troubleshoot database/ server/storage issues.

Graduation from an accredited college or university with a bachelor’s degree in computer science or a related field and three (3) years of progressively responsible experience in computer programming, systems analysis and/or database administration; or Graduation from an accredited college or university with an associate's degree in computer science or a related field and five (5) years of progressively responsible experience in computer programming, systems analysis and/or database administration.

Employees may be required to work rotating shifts, including nights, weekends, holidays and overtime as needed. During periods when the Mayor issues an emergency declaration for the City of Tampa, all employees may be required to work in preparation, response or recovery activities related to the stated emergency.