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-Premises 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 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
• 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 and change tracking through agreed business systems
• Working with other DBA and Infrastructure team members, 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 environments, including disk configuration
• Proficiency in SQL Server database design, system analysis & architecture
• In-depth knowledge of Microsoft SQL Server and SSAS/SSIS/SSRS technologies
• Able to create, understand and update PowerShell and Windows Batch scripts
• Competency with SSMS and T-SQL knowledge to create data queries and data extracts
• Knowledge of AWS or other cloud platform – AWS EC2 / S3 Bucket Administration.
• Experience with Microsoft Failover Clustering and SQL Server Always-On High Availability
• Familiar with Ola Hallengren SQL Server Maintenance Solutions
• Database Server Virtual Machine computing in AWS/VMware
  
  

EDUCATION And/or EXPERIENCE

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

CERTIFICATIONS

• MCSA SQL Server
• MCSA Database Administration
  
  

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