This is responsible database administration and systems analysis work.
Nature Of Work
An employee in this class is responsible for performing a variety of technical computer programming 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 data processing systems, programs and 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.
Examples of Duties
Develops and/or modifies database systems from program specifications; develops and/or modifies production runs according to instructions; prepares program specifications and production run specifications from functional specifications 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.
Develops and/or modifies reports created against Enterprise and departmental databases. 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.
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 equipment and software and makes recommendations; evaluates, acquires, and coordinates computer hardware 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.
Knowledge, Skills & Abilities
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 2016 or higher, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Management Studio, Microsoft Office, Azure DevOps, and ESRI ArcGIS 10.8 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.
Licenses or Certifications
Valid driver's license preferred
Evaluation of education and experience. Drug testing is included in all pre-employment processing.
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.
HELPFUL HINTS FOR COMPLETING YOUR APPLICATION: Please register before you begin the application process. This will enable you to view and re-use information from previously submitted applications to complete and submit any future applications. Please make certain your application is complete and the information you provide clearly demonstrates that you possess the minimum job qualifications as stated in the job announcement. Resumes can be submitted in support of an application, but not in lieu of an application. Resumes and copies of certifications or other required documents may be attached to your online application.