Senior SQL / DB2 Developer

The work we do has an impact on millions of lives, and you can be a part of it.

We help protect our customers against life’s uncertainties. Regardless of where you work within the company, you’ll be helping provide protection and peace of mind when our customers need it most.

The Sr / DB2 Sql Developer will work as part of the APD IT team under the direction of the Sr Director App Dev to ensure APD applications are performing optimally.  The role spans MSSQL and DB2 RDBMS’s and requires familiarity with both platforms.

Key Responsibilities :

• Database Design and Development :
• Design and create SQL databases based on business requirements.
• Develop and optimize SQL queries for data retrieval, manipulation, and reporting.
• Create and maintain database schemas, tables, views, and stored procedures.
• Data Integration :
• Develop data integration processes to import and export data from various sources and formats.
• Collaborate with ETL (Extract, Transform, Load) developers to ensure smooth data flow.
• Performance Tuning :
• Monitor and optimize database performance by identifying and resolving bottlenecks.
• Implement indexing and caching strategies to improve query speed.
• Data Security :
• Implement and maintain database security measures to protect sensitive data.
• Documentation :
• Create and maintain documentation related to database design, schemas, and processes.
• Keep documentation up-to-date to facilitate knowledge sharing.
• Collaboration :
• Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and support application development.
• Work with DBAs (Database Administrators) to ensure database health and stability.
• Troubleshooting and Support :
• Investigate and resolve database-related issues and errors.
• Provide technical support to end-users and troubleshoot data-related problems.

Work Experience, Education, Certification / Training Required :

Knowledge, Skills and Abilities Required :

$82,500 - $126,500 a year

Protective’s targeted salary range for this position is $82,500 to $126,500. Actual salaries may vary depending on factors, including but not limited to, job location, skills, and experience. The range listed is just one component of Protective’s total compensation package for employees.

This position also offers additional incentive opportunities through an annual incentive based on individual and Company performance.

Employee Benefits :

We aim to protect the wellbeing of our employees and their families with a broad benefits offering. In addition to offering comprehensive health, dental and vision insurance, we support emotional wellbeing through mental health benefits and an employee assistance program. Work / life balance is important and Protective offers a variety of paid time away benefits ( e.g. , paid time off, paid parental leave, short-term disability, and a cultural observance day). The financial health of our employees is just as important as physical and emotional health.  Some of the financial wellbeing benefits include contributions to healthcare accounts, a pension plan, and a 401(k) plan with Company matching. All employees are encouraged to protect their overall wellbeing by engaging in ProHealth Rewards, Protective’s platform to improve wellbeing while earning cash rewards.

Eligibility for certain benefits may vary by position in accordance with the terms of the Company’s benefit plans.

Accommodations for Applicants with a Disability

If you require an accommodation to complete the application and recruitment process due to a disability, please email  martina.winston@protective.com . This information will be held in confidence and used only to determine an appropriate accommodation for the application and recruitment process.

Please note that the above email is solely for individuals with disabilities requesting an accommodation.  General employment questions should not be sent through this process.

We are proud to be an equal opportunity employer committed to being inclusive and attracting, retaining, and growing an inclusive workforce.