Franklin Street is currently seeking a Database Administrator for the Corporate Services team. Successful candidates will be those possessing a background in the performance, integrity, and security of information systems’ databases.
Essential Functions
• Designs and documents database architecture.
• Assesses malfunctions of hardware and/or 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, and/or conveying information.
• Prepares and distributes reports, including but not limited to weekly and monthly status reports to the CIO.
• Attends seminars, conferences, in-service training and staff meetings as required
• Other related duties, as assigned
Knowledge, Skills and Abilities
• 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.
Education and Technical Requirements• 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.
• 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, logical/physical standby, ETL, replication).
• Experience with Microsoft FLOW, PowerApps, API Explorer and Power Automate a plus.
For more information: https://franklinst.com/careers/current_opportunities
