The Mission of The MEMIC Group is to make workers' comp work better with compassion, trusted partnerships, and relentless commitment to workforce safety. The secret to the success and longevity of great organizations is their shared vision and strong values. At MEMIC our values are to be conscientious, to be an expert, to be a partner, to be curious and to be transparent.
The Database Administrator (DBA) will support the MEMIC SQL Server Database environment with responsibility for creation of databases, performance tuning, cloning, copying, high availability, and data refreshes. The position will also work to support MEMIC development initiatives utilizing production, test and development databases. Work with project teams for database project estimates, design and recommendations
Responsibilities:
- Responsible for SQL Database development and support.
- Create, maintain and update SQL Server Infrastructure and Standards DBA documentation.
- Work with vendors to architect, design and configure large, complex databases with replication and high-availability on the most current MSSQL versions.
- Develop and maintain application, data, and execution architectures.
- Provide input into overall development/implementation plan and documents database builds and changes, perform SQL designs, table designs, and stored procedures work.
- Manage large tables, maintain schemas, and develop queries and utilities to assist users.
- Install upgrades and patches to existing databases.
- Create databases, tuning, cloning, copying, and data refreshes.
- Develop and configure tools to enable automation of database administration tasks.
- Perform system analysis and identify solutions to technical problems.
- Identify bottlenecks and perform database tuning.
- Support the activities required to build and maintain customer relationships.
Requirements:
- Microsoft Certifications a plus.
- Experience in SQL Clustering, SQL Queries, MS Server 2008, 2012, 2016, 2019, Performance Tuning.
- Experience building and implementing databases, debugging, SSIS, SSRS, and DTS as well as migrating DTS packages into SSIS.
- Data Warehouse Design and Administration experience a plus.
- Experience in Database Encryption a plus.
- Must have experience in writing stored procedures and providing high availability service.
- Experience Building/Maintaining Data Warehousing Solutions.
- Excellent backup, monitoring, recovery, planning and troubleshooting skills.
- Experience working outside vendors/3rd parties.
- Knowledge of SAP Business Objects integration, and Microsoft Dynamics CRM a plus.
- Work effectively in a team environment. Excellent communication skills.
Our comprehensive benefits package includes all traditional offerings such as:
- Health Insurance options, Dental Insurance options and Vision Insurance
- Employee Life Insurance/AD&D and Dependent Life Insurance options
- Short-term & Long-term Disability
- Health Savings Account with potential employer match
- Flexible Medical and Dependent Care Account
- Accident Insurance
- Critical Illness Insurance
- Employee Assistance Program
- Legal/Identify Theft Insurance options
- Long Term Care Insurance
- Pet Insurance
- 401 (k) Retirement Plan with match up to 5%, plus profit sharing & discretionary contributions (subject to vesting)
- 5 weeks of Paid Time Off (PTO)
- 10 paid holidays
We also offer other benefits to help foster a healthy, balance lifestyle such as:
- Flextime schedules
- Paid Parental Leave
- Student loan paydown and refinancing assistance
- Educational assistance for job related courses, seminars, certifications or degrees
- One paid day every year to volunteer for your non-profit of choice
- On-site fitness center (Maine) or fitness reimbursement
- Subsidized parking
- Sit-Stand desks & daily stretch breaks
MEMIC is committed to a policy of nondiscrimination and equal opportunity for all employees and qualified applicants without regard to race, color, religious creed, national origin, ancestry, age, disability, genetics, gender identity, veteran's status, sexual orientation, or any other characteristic protected by law. MEMIC is an equal opportunity employer encouraging diversity in the workplace.