4 DAYS AGO
Full Time
Summary The Database Administrator (DBA) and Systems Integrations Specialist is responsible for developing and maintaining system integrations and components, including but not limited to application to application integrations, services, internal and external API, file transfer, and EDI and SQL queries. This position provides technical expertise in the design, implementation, and maintenance of database management systems that support institutional business applications. Additional responsibilities include reporting, data input and output, technology management, backups, end-user training and support. Responsibilities Designs and documents database architecture. Assesses malfunctions of hardware andor software applications for the purpose of determining appropriate actions to maintain computer, network, and database operations. Builds database scheme, tables, procedures and permissions. Creates, tests, and executes data management languages. Develops database utilities and automated reporting. Analyzes and sustains capacity and performance requirements. Monitors systems and platforms for availability. Oversees backup, clustering, mirroring, replication and failover. Performs maintenance operations daily, weekly and monthly on Azure and SQL servers and databases, and information systems for the purpose of ensuring efficient program operations. Performs database backups and restorations, and recovers corrupted databases. Evaluates and recommends new database technologies. Implements and maintains database security and encryption. Develops, manages and tests database and information system backup and recovery plans. Develops standards and policies for data entry, and ensures compliance. Prepares written materials for the purpose of documenting activities, providing written reference, andor conveying information. Prepares and distributes reports, including but not limited to weekly and monthly status reports to the CIO. Design integration solutions and document the design in accordance with best practices. Work with development teams to architect, design, build, and implement application integrations. Develop and maintain data integration components such as SQL queries, stored procedures, data extraction and cleansing, and integration with system front end components. Build reports andor data extracts to support business analysis. Support development on resolving system defects, acting as liaison, and developing solutions. Coordinate directly with business users and business analyst to best understand and analyze business specifications. Provide technical assistance to troubleshoot and resolve integration errors. Skills Individual must possess the knowledge and the following skills and abilities or be able to perform the essential functions of the job, with or without reasonable accommodation, using some other combination of skills and abilities. Experience in Microsoft SQL Server 2008+.. Experience in Microsoft Azure and Office365. Proficiency in Microsoft Windows and Microsoft Office applications with an emphasis on database and spreadsheet applications. Experience in Microsoft PowerBI. Intermediate knowledge in hardware and networking. Experience managing databases. Proficiency in database administration, management, data imports and exports, and developing reports. Ability to provide excellent customer service and public relations outreach. Proven ability to effectively manage multiple priorities and meet deadlines. Ability to adapt to varied roles and job responsibilities and problem-solving skills. Demonstrated ability using a life cycle management process for implementation of changes in technology. Ability to performs a variety of professional tasks including, but not limited to, technology services representative on various committees or task forces Demonstrated ability to excel both independently and as a team member in a lively, collaborative environment. Excellent written and verbal communications skills with a demonstrated ability to make difficult concepts easy to understand EducationTraining High School Diploma or equivalent is required. College degree with emphasis in information systems is preferred. Certifications such as MCSE DBA, or equivalent experience are preferred. Experience Minimum of three years conducting general SQL database administration tasks such as database implementations, backups, and account maintenance Minimum of two years administering database platform specific advanced features (e.g. clustering, encryption, logicalphysical standby, ETL, replication) Experience in data analytic tools such as Microsoft PowerBI required. Experience with Microsoft FLOW, PowerApps, API Explorer and Power Automate a plus
Location/Region: Tampa, FL