Database Administrator II

Join our dynamic team of innovators, creators, and problem solvers At Frontline Insurance, we're on a mission to Make Things Better We believe in fostering a collaborative, inclusive, and growth-oriented work environment where every team member can thrive and make a meaningful impact.

At Frontline Insurance we're more than just a workplace – we're a community of talented individuals dedicated to Integrity, Patriotism, Family and Creativity. Join us in shaping the future of Insurance and let's achieve remarkable things together. Your next career adventure starts here

SUMMARY

Database Administrator II is a function at Frontline Insurance that together with the Database Manager will manage all aspects of database operations. As a Database Administrator II, you will manage all range of RDBMS in highly available environment both on Prem and in AWS.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Include the following. Other duties may be assigned.

• Provide overall database administration & system tasks, support & maintenance
• Undertake monitoring/ tuning / optimizing, installation, updates, upgrade, and backups/restore/recovery processes, etc.
• Carry out periodic database maintenance & systems support
• SQL Server and PostgreSQL database design, system analysis & architecture design
• Action incident and problem management activities, escalating issues to external technical support parties when required.
• Supply database statistics & related data on a timely basis
• From time to time, support team members with data analytical and other application support activities
• Manage operational tasks such as providing technical support for ETL processes, SQL Agent Jobs, and support Application release
• Problem-solve issues (connections errors, databases & their operating systems) as and when they arise
• Produce & maintain technical & user documentation
• Issue tracking and change through agreed business systems
• Working with other DBA and Infrastructure team, design and facilitate database backup and recovery as well as document and test all backup and disaster recovery procedures
• Provide development and production support to troubleshoot day-to-day database or related application issues
• Maintain and administer database security access
• Manage DBA related projects within the organization
• Provide input into Frontlines IT Risk Management function, working closely with DBA Manager/Risk Analyst
• Participate in Frontline’s Data Governance strategic development.
• On-call requirements to ensure 24 x 7 support of database operations

SUPERVISORY RESPONSIBILITIES

This job has no supervisory responsibilities.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Strong organizational and documentation skills. The requirements listed below are representative of the knowledge, skill, and/or ability required. IT also must have:

• 5+ years’ experience as a database administrator in SQL Server and other RDBMS environments performing the Essential Duties required for this position

• Experience with Monitoring & Diagnostic tools
• Experience working with Windows server and Linux environment, including disk configuration
• Proficiency in SQL Server and PostgreSQL database design, system analysis & architecture
• In-depth knowledge of Microsoft SQL Server and SSAS/SSIS/SSRS technologies
• Able to create and update PowerShell and Linux scripts
• Competency with SSMS and T-SQL knowledge to create data queries and data extracts
• Knowledge of AWS or other cloud platform
• Experience with Microsoft Clustering and SQL Server Always On High Availability

EDUCATION and/or EXPERIENCE

• Bachelor’s degree in information technology, computer science or equivalent combination of education

CERTIFICATIONS

• MCSA SQL Server
• MCSA Database Administration

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Strong organizational and documentation skills. The requirements listed below are representative of the knowledge, skill, and/or ability required. IT also must have:

• 5+ years’ experience as a database administrator in SQL Server and other RDBMS environments performing the Essential Duties required for this position
• Experience with Monitoring & Diagnostic tools
• Experience working with Windows server and Linux environment, including disk configuration

SUPERVISORY RESPONSIBILITIES

This job has no supervisory responsibilities.

COMPETENCIES

Problem Solving

• Quickly analyses work problems and implements solutions
• Uses his or her technical knowledge to solve business problems
• Has a good knowledge of the practical issues within his or her team
• Supports the technical crises or problems that occur in his or her team

Consulting

• Listens to staff input when making decisions
• Draws on the advice of others when making decisions

Supporting

• Spends time with team members talking through issues or concerns
• Helps others in a patient and supportive manner

Planning

• Plans work activities and initiatives well in advance
• Has plans in place to deal with future contingencies
• Considers the long-term impact of his or her actions

Monitoring

• Closely monitors his or her own performance relating to specified goals
• Complies with required procedures and work processes
• Provides progress reports to team leaders and management as needed

Performance Attributes

• Excellent written and oral communication and interpersonal skills
• Results orientated
• Ability to work comfortably with competing demands & finite resources

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; and talk or hear.  The employee frequently is required to reach with hands and arms.  The employee is occasionally required to stand and walk.  Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.

NOTE:  This is not necessarily an exhaustive list of responsibilities, skills, duties, requirements, efforts or working conditions associated with the job.  While this list is intended to be an accurate reflection of the current job, Frontline Homeowners Insurance reserves the right to revise the functions and duties of the job or to require that additional or different tasks be performed when circumstances change.

I have carefully read and understand the contents of this job description.  I understand the responsibilities and duties expected of me.  I also understand that this job description does not constitute a contract of employment nor alter my status as an at will employee.  I have the right to terminate my employment at any time and for any reason and Frontline Insurance has a similar right.

 #LI-HYBRID