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
