DB2 Architect

Job Description

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 lifes uncertainties. Regardless of where you work within the company, youll 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 RDBMSs 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:

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).

Proven experience as a MSSQL/DB2 Developer or in a similar role.

Strong proficiency in SQL and database management systems (e.g., Microsoft SQL Server and DB2).

Knowledge of database design principles, normalization, and indexing.

Experience with ETL processes and tools (e.g., SSIS, ACS, Arcad, DBeaver, and Qlik preferred)

Working Knowledge of data warehousing concepts.

Familiarity of programming languages (e.g., RPG and .Net)

Excellent problem-solving and analytical skills.

Strong communication and collaboration skills.

Attention to detail and a commitment to data accuracy and integrity.

Ability to work independently and as part of a team.

Knowledge, Skills, and Abilities Required:

A sound understanding of software development life cycle and successful management of multiple full lifecycle projects is required, and Agile and CI/CD experience is highly preferred.

Demonstrate broad knowledge of multiple business areas, and industry to identify and communicate how IT solutions can support the achievement of short-and long-term business goals

Negotiation skills, with a driving desire and high propensity to learn quickly and develop oneself

Ability to work with people to proactively identify and evaluate risks associated with business decisions

Ability to communicate clearly, negotiate, listen, mitigate conflict, build alliances, and achieve desired results using strong interpersonal and diplomacy skills

Ability to work independently, with little management direction, and within a team environment

Skilled at asking questions and professionally challenging to uncover important facts and information

Has the courage to make decisions, but also has the wisdom to know when a decision needs to be escalated

Builds consensus among diverse groups of people; highly skilled at facilitating resolution across functions and departments

Has the confidence to engage and work productively with business leaders and product owners

Strong team orientation

Employee Benefits:

We aim to protect our employees' well-being through a broad benefits offering. For example, we protect physical well-being through health, dental, and vision insurance. We protect mental well-being through mental health benefits and an employee assistance program. We protect time away from work with a variety of paid time away benefits (e.g., paid time off, paid parental leave, short-term disability, and a cultural observance day). We protect financial well-being through contributions to healthcare accounts, a pension plan, and a 401(k) plan with Company matching. All employees are encouraged to protect their overall well-being by engaging in ProHealth Rewards, our clients platform to improve wellbeing while earning cash rewards.

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

Diversity and Inclusion:

Our client, is committed to providing an inclusive culture where all employees are able to fully contribute and thrive. Our goal is to grow and develop our people, attract diverse talent and support strong, diverse communities.

We support diversity, equity, and inclusion by working to develop a culture of inclusion and belonging led by leaders who develop potential and embrace unique skills and abilities. Our aim is to create an equitable and accountable environment for all leaders and employees that will drive performance and impact business strategy. In this way, we can increase overall diversity for leadership roles and pipelines of talent by maturing our hiring practices, robust development opportunities and focus on retention of key talent.

Our client is proud to be an equal-opportunity employer committed to being inclusive and attracting, retaining, and growing the talents of a diverse and inclusive workforce.