Senior SQL DBA
Forrest T. Jones & Company, Inc., and its affiliates (“FTJ”), provide insurance and insurance related services to clients, corporations, employers and individuals. These services include providing benefits through innovative life and health insurance plans, financial services, and customized insurance products for niche markets.
Position Summary
The SQL Server Database Administrator is responsible for the architecture, planning, implementation, performance, maintenance, security, and support of the SQL Server environments, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
The DBA must work with application development and infrastructure to help achieve a state-of-the-art environment that meets current and future business objectives, while at the same time ensuring that the company’s production databases offer the highest reliability and performance possible.
Expectations
- Installs, administers, and maintains SQL Server environments.
- Monitors performance, tunes and optimized current SQL Server environments to ensure the availability, integrity, security, and reliability of the data
- Reviews and recommends improvements to existing data server architecture.
- Monitors and manages users and applications data access across multiple environments.
- Develops, maintains and tests SQL Server backups and disaster recovery procedures.
- Implements and maintains capacity planning procedures for SQL Server environments.
- Able to deploy packages and troubleshoot issues with SSIS packages
- Able to deploy RDLs and troubleshoot issues with SSRS
- Maintain SQL Database compliance with versioning and security patches
- Robust knowledge of SQL Server backups, recovery, and user security
- Knowledge of TDE Encryption implementation and maintenance
- Researches and evaluates hardware and/or software.
- Optimizes current SQL processes.
- Provides day-to-day support for SQL Server environments.
- Provides Change Management support, including reviewing/approving and implementing changes that affect databases.
- Maintains database instances across multiple operating environments. Move, rebuild, or change database objects as required in production.
- General working knowledge of physical data models, technical architecture, and system interfaces.
- Develops and tests database migration procedures.
- Establishes database procedures and standards; assists in database and data related process design.
- Documents data related processes and data server’s technical configurations.
- Performs other related duties as assigned and required.
Competencies
- Excellent understanding of Microsoft SQL Server and SSMS
- Proficient with SSIS and SSRS.
- Experienced with large data warehousing, data mining and data conversion projects.
Requisites
- Bachelor’s Degree
- 5 or more years of experience in database administration (or equivalent experience).
Work Physical Requirements FLSA Status: Exempt
Work is generally performed in an office environment. Incumbent must have the ability to stand and sit frequently throughout an eight-hour period, reach vertically for overhead use as well as horizontally. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Core Values
- We demonstrate INTEGRITY in all we do.
- We enthusiastically display our ENTREPRENEURIAL spirit with every opportunity and challenge.
- We are RESULTS-DRIVEN in our performance.
- We are COMMITTED to our promises and people.
- We are STEWARDS of the people and resources entrusted to us.
Mission
Specialty insurance solutions with personalized expertise and responsiveness.
We offer comprehensive benefits to full time employees including company paid medical, STD, LTD and life insurance; plus voluntary dental, vision, Life/AD&D insurance, 401(k) with company-matching, generous paid time off and much more.
We encourage applicants of all ages and experience, as we do not discriminate on the basis of an applicant’s age.
ALL OFFERS OF EMPLOYMENT ARE CONTINGENT UPON PASSAGE OF A DRUG SCREEN AND BACKGROUND CHECK.