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:
Bachelor’s degree in computer related field plus 2-5 years’ experience developing and administering Microsoft SQL Database Solutions or an equivalent combination of education and work experience required.
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.