Database Administrator II

JOB TITLE: Database Administrator II

Location: North Fort Myers, FL

Work Hours: M-F 8:00 - 5:00

Our benefits include:

• Company-wide annual incentive plan
• Medical, vision and dental insurance
• 401(k) plan with a generous 6% company match
• Company funded Pension Plan
• On-site wellness/medical facility
• Company paid Short & Long-Term Disability insurance
• Health Savings Account with an employer contribution
• Flexible Spending Account
• Paid time off and paid holidays
• Wellness program with financial rewards
• Tuition reimbursement
• Group life insurance
• Critical Illness and Accident Insurance

LCEC provides reliable, cost-competitive electricity to more than 260,000 members throughout a five-county service territory located in Southwest Florida. We employ approximately 485 skilled employees and are one of more than 900 electric distribution cooperatives located throughout the United States. LCEC has been recognized locally and statewide as an industry leader and continually receives acknowledgment for the work that our employees do in the community along with other civic, environmental and professional honors.

Position Summary: The Data Base Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the development and organization of the administration, performance, reliability, and ongoing improvement of the company's database and transaction-processing environments. The DBA partners with architecture, application development, and operations teams to implement database technologies and solutions that support current and evolving business needs. The role also provides technical guidance, tools, and support to promote effective use and management of the database environment.
Position Responsibilities

• Tune databases for optimal availability and performance.
• Create and manage database functions to include database startup/shutdown, granting of privileges, applications usage, software development, database refreshes, backup/recovery, and security auditing.
• Provide technical direction to developers for software application design, development, problem analysis, problem determination and problem resolution, for both purchased off-the shelf software and in-house developed software.
• Perform database upgrades and apply patches to resolve issues and maintain support.
• Analyze database products and tools and recommend methods for efficiently deploying those products in a risk-free, secure, production environment.
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
• Troubleshoot service outages as they occur, including after-hours and weekends.
• Configure monitoring utilities to minimize false alarms.
• As new systems are brought in-house, work with the Infrastructure and Information Security Teams to determine whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
• Install and configure new database systems.
• Deploy database change scripts provided by third party vendors.
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
• Document the company’s database environment.
• Database and Python development assignments for data ingestion.
• Good interpersonal, written, and oral communication skills.
• Self-motivated and directed, with keen attention to detail.
• Manage Microsoft 365 Dataverse Fabric/OneLake permission policies and assignment.
• Setup and maintain Microsoft Fabric Gateway and database mirrors.
• Maintain effective working relationships with employees and customers at all levels within LCEC. Ensure smooth operations, productive communications, and effective understanding during all interpersonal contacts. Provide current and accurate information to all requesters, courteously and in a timely manner.
• Support Storm Restoration efforts when needed. Work in emergency storm situations (i.e. hurricanes) and work long hours (>12 hours per day) for many continuous days/weeks as needed.
• Perform other related duties as assigned.

Education

• Bachelor's Degree in Computer Science, Information Systems, Engineering or related discipline; or equivalent experience acceptable. (Required)

Experience

• 4+ years' experience as a production Microsoft SQL Server 2008R2, 2012, 2014, 2016. (Required)
• 4+ years' designing, planning and implementing computer applications based on relational database systems (e.g. Oracle, SQL Server). (Required)
• 2+ years' experience writing database scripts (T-SQL). (Required)

Physical Demands and Working Environment: The physical demands and working environment characteristics described here must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Physical Demands: Standing Occasionally,
  Walking Occasionally,
  Sitting Constantly,
  Lifting Occasionally up to 25 lbs,
  Carrying Rarely,
  Pushing Rarely,
  Pulling Rarely,
  Climbing Rarely,
  Balancing Rarely,
  Stooping Rarely,
  Kneeling Rarely,
  Crouching Rarely,
  Crawling Rarely,
  Reaching Rarely,
  Handling Occasionally,
  Grasping Occasionally,
  Feeling Rarely,
  Talking Constantly,
  Hearing Constantly,
  Repetitive Motions Frequently,
  Eye/Hand/Foot Coordination Frequently.

• Working Environment: Constantly Air-conditioned office environment, Rarely Extreme cold, Rarely Extreme heat, Rarely Humidity, Rarely Wet, Occasionally Noise, Rarely Hazards, Rarely Temperature Change, Rarely Atmospheric Conditions, Rarely Vibration.

STORM DUTY REQUIREMENTS.... Responding to storms may be considered a condition of employment: LCEC provides critical services to our community during an emergency.  Employees may be required to participate in the response/recovery activities related to emergencies/disasters to maintain service to our LCEC members. Employees are required to work in their normal job duties or other assigned activities.  Proper compensation will be made in accordance with the company's guidelines and procedures.

Please note that at the time a candidate is made a job offer, the candidate will be subject to a background check and a drug screening.