Database Administrator II

LCEC•North Fort Myers, FL

1d•Onsite

About The Position

The Database Administrator II provides technical support for the database environment and oversees the development and organization of database administration, performance, reliability, and ongoing improvement of the company's database and transaction-processing environments. The role partners with architecture, application development, and operations teams to implement database technologies and solutions that support current and evolving business needs, and provides technical guidance, tools, and support for effective database use and management. The position is based in North Fort Myers, Florida, with regular work hours Monday through Friday, 8:00 a.m. to 5:00 p.m. Troubleshooting service outages may require after-hours and weekend work. Storm restoration support is also required when needed and can involve long hours exceeding 12 hours per day for many continuous days or weeks.

Requirements

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline, or equivalent experience.
At least 4 years of experience with production Microsoft SQL Server 2008 R2, 2012, 2014, or 2016.
At least 4 years of experience designing, planning, and implementing computer applications based on relational database systems such as Oracle or SQL Server.
At least 2 years of experience writing database scripts using T-SQL.
Good interpersonal, written, and oral communication skills.
Self-motivated and self-directed, with keen attention to detail.
Ability to work in emergency storm situations and, as needed, work more than 12 hours per day for many continuous days or weeks.
Ability to meet the stated physical demands and working-environment characteristics, with reasonable accommodations where applicable.

Responsibilities

Tune databases for optimal availability and performance.
Create and manage database functions, including startup and shutdown, privilege management, application usage, software development, database refreshes, backup and recovery, and security auditing.
Provide technical direction to developers on application design and development, problem analysis, determination, and resolution for purchased and internally developed software.
Perform database upgrades and apply patches to resolve issues and maintain support.
Analyze database products and tools and recommend ways to deploy them efficiently in a secure production environment.
Ensure database servers are backed up to meet business Recovery Point Objectives (RPOs), and test backups to verify Recovery Time Objectives (RTOs) can be met.
Troubleshoot service outages, including after-hours and weekend outages.
Configure monitoring utilities to minimize false alarms.
Work with Infrastructure and Information Security teams to select technologies such as clustering, log shipping, mirroring, or Windows Azure for new systems.
Install and configure new database systems.
Deploy database change scripts provided by third-party vendors.
Investigate performance issues and determine whether hardware purchases, server configuration changes, or index/query changes are appropriate.
Document the company's database environment.
Complete database and Python development assignments for data ingestion.
Manage Microsoft 365 Dataverse Fabric/OneLake permission policies and assignments.
Set up and maintain Microsoft Fabric Gateway and database mirrors.
Maintain effective working relationships with employees and customers at all levels, support smooth operations and productive communications, and provide accurate information courteously and promptly.
Support storm restoration efforts when needed, including emergency storm work and extended hours.
Perform other related duties as assigned.