Application Database Admin I

University of Florida•Gainesville, FL

19h•Onsite

About The Position

Database Development, Management and Administration With guidance of senior staff, work to develop and optimize database objects to meet user requirements. Works in conjunction with server admin team members to install, configure, upgrade, and maintain the performance of database servers and their related application servers. Defines users and enables data distribution to the right user, in appropriate format and in a timely manner. Implements, and follows policies, procedures, and standards to ensure the integrity and availability of systems. Assists with designing, implementing, and managing maintenance plans for backups, database updates, etc. per industry best practices. Creates automations for repeating database tasks and monitors scheduled job execution. Troubleshoots any errors that occur and monitors job performance. Integration Development and Support Designs and, with guidance from senior staff, implements required integrations between databases. Monitors integrations to ensure compliance with business processes and updates integrations as necessary when requirements or systems are updated. Reporting and Data Integrity Designs, creates, and manages database reports, visualizations, and dashboards. Responsible for development & documentation of queries & routines to extract management information. Develops, documents & maintains standard system reports to ensure correct data relationships are represented. Assists users with creation of ad-hoc reports. Works with senior staff members to ensure data security, privacy, and integrity. Facilitates real time and/or batch updating of data; testing and correcting data for inconsistencies, redundancies, and other undesirable states; analyzing data anomalies and correcting problems to ensure optimal performance and integrity of systems. Maintenance, Support and Documentation Provides necessary backup on-call and support coverage with little assistance in resolving problems. Troubleshoots applications and maintains systems. Works with system admins and other senior staff members to ensure optimal performance & system integrity. Provides system support documentation for future issue resolution. May consult with software vendors regarding system functionality, enhancement requests, issues and planning for upgrades and future releases. Tracks issues, work performed, and outcomes in ticketing system. Creates and maintains internal documentation on processes, common issues, resolutions, etc. THIS POSITION REQUIRES A CRIMINAL BACKGROUND CHECK (FDLE & FBI) WITH FINGERPRINTING. Class E State of Florida driver license (required) Must maintain active CJIS Security Awareness certification

Requirements

Associate's degree and two years of relevant experience; or a high school diploma or equivalent and four years of relevant experience.
Appropriate college coursework or vocational/technical training may substitute at an equivalent rate for the required experience.
Class E State of Florida driver license (required)
Must maintain active CJIS Security Awareness certification

Nice To Haves

Bachelor’s degree
Experience working with databases, integrations, and enterprise applications.
Knowledge and experience with Relational database design and development (PL/SQL, etc)
Knowledge and experience with Relational and dimensional data modeling
Knowledge and experience with Database management/developer tools, (SSMS, SQL Developer, etc)
Knowledge and experience with Database migration and data integration/ETL tools, such as SQL Server Integration Services (SSIS)
Knowledge and experience with Programming languages such as PHP, Python, Powershell, C#, Javascript, etc.
Knowledge and experience using project/ticket management systems
Knowledge and experience using version control (Git, SVN, etc)
Effective communication skills, both verbal and written
Demonstrated planning and organization skills
Demonstrated interpersonal skills
Demonstrated ability to handle multiple projects or tasks simultaneously.
Ability to work as part of a team.

Responsibilities

Develop and optimize database objects to meet user requirements.
Install, configure, upgrade, and maintain the performance of database servers and their related application servers.
Define users and enable data distribution to the right user, in appropriate format and in a timely manner.
Implement and follow policies, procedures, and standards to ensure the integrity and availability of systems.
Design, implement, and manage maintenance plans for backups, database updates, etc. per industry best practices.
Create automations for repeating database tasks and monitor scheduled job execution.
Troubleshoot errors and monitor job performance.
Design and implement required integrations between databases.
Monitor integrations to ensure compliance with business processes and update integrations as necessary.
Design, create, and manage database reports, visualizations, and dashboards.
Develop and document queries and routines to extract management information.
Develop, document, and maintain standard system reports to ensure correct data relationships are represented.
Assist users with creation of ad-hoc reports.
Ensure data security, privacy, and integrity.
Facilitate real-time and/or batch updating of data.
Test and correct data for inconsistencies, redundancies, and other undesirable states.
Analyze data anomalies and correct problems to ensure optimal performance and integrity of systems.
Provide backup on-call and support coverage with little assistance in resolving problems.
Troubleshoot applications and maintain systems.
Ensure optimal performance and system integrity.
Provide system support documentation for future issue resolution.
Consult with software vendors regarding system functionality, enhancement requests, issues and planning for upgrades and future releases.
Track issues, work performed, and outcomes in ticketing system.
Create and maintain internal documentation on processes, common issues, resolutions, etc.