In this role, you will:
DB2LUW
Support logical and physical database creation as well as database object creation
Perform Db2LUW version upgrades and patching on the Db engine
Implement more advance features such as data encryption for data inflight and at rest
Provide on-call DBA support
Participate in the strategic projects such as o Implementation of high availability features such as HADR as Chubb becomes a highly available environment including granular DR practices.
Conversion of existing backup processes away from TSM to Rubrik
Replatform from AIX to Linux for all DB2LUW databases.
Azure cloud-Cosmos-Mongo
Database Design & Implementation – Design and implement database solutions using Azure Cosmos DB and MongoDB best practices. Create data models, schemas, and database management processes tailored to application needs.
Performance Optimization - Monitor and tune the performance of databases, including queries and indexing strategies. Implement best practices for data partitioning, sharding, and replication to ensure high availability and scalability.
Security & Compliance - Implement security measures to protect sensitive data in compliance with relevant regulations. Monitor access control and audit logs to ensure data security practices are followed.
Backup & Recovery – Establish and manage backup and recovery processes for database environments to ensure data integrity and availability.
Data Migration & Integration - Plan and execute data migration strategies from on-premises databases or other cloud systems to Azure Cosmos DB and MongoDB. Integrate databases with existing applications and services, ensuring seamless data flow.
Scripting - Proficiency in scripting languages such as Terraform, Python, Bash, JavaScript (Node.js), Ansible, Puppet, or similar for managing MongoDB deployments for automation tasks.
Educational requirements – college degree in Computer Science or Computer Technology preferred
Required skills, knowledge and abilities:
DB2LUW EE version 11.x features and functions
TSM backup, restore, archive log operations
DB2 Client installation, configuration and cataloging
DB2 Connect support
DB2 EE installation, instance creation, and patching experience
DB2 utilities
Additional skills: o HADR configuration – a plus
Rubrik software experience – a plus
Experience replatforming from AIX to Linux
Implementing TLSD on Db2LUW – a plus
Alerting and monitoring tool experience – Science Logic, Solar-winds-DPA – a plus
Additional DBMS platform experience in Oracle, Informix, DB2 zOS and IMS– a big plus
DB2 zOS experience – a plus
Interpersonal skills
Verbal and written communication skills are key, Various levels of business and technical contact. Candidate must be able to communicate effectively to all levels. Crisp, concise delivery of technical information a must - will be part of the interview process.
Team player – Chubb DBA works as individual DBMS teams and as part of the larger north America team. We will also be called upon to provide DB2LUW SME recommendations and assistance for other Chubb global regions as we evolve into a more global/follow-the-sun organization.
DB2LUW and Azure-Cosmos-MongoDB & Scripting (Ansible, MongoDB Shell, Python, PowerShell, Terraform)
Secondary skills: Oracle, SQL-Server & PostgreSQL
Proven experience with Cosmos DB/MongoDB scaling across data centers and/or in-depth understanding of HA strategies, including replica sets and sharding
Analyze SQL query plans, suggest and implement solutions to support developers in development and production environments. Performance troubleshooting - performance tuning and optimization, identifying and resolving performance bottlenecks, Analyze SQL query plans, suggest and implement solutions to support developers
Monitor and troubleshoot database issues, including performance bottlenecks, query optimization, and replication problems.
Optimize database performance, including query tuning, indexing, and partitioning strategies.
Ensure high availability through replication, failover, and other redundancy measures
Enforce best practices for database security, including data masking, encryption, and role-based access control
Automate routine database administration tasks using PowerShell, Azure CLI, and ARM templates.
Document database configurations, processes, and best practices, contributing to the creation and maintenance of internal knowledge resources
Similar Jobs
What We Do
Chubb is the world’s largest publicly traded property and casualty insurance company. With operations in 54 countries and territories, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients. As an underwriting company, we assess, assume and manage risk with insight and discipline. We service and pay our claims fairly and promptly. The company is also defined by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength and local operations globally. Parent company Chubb Limited is listed on the New York Stock Exchange (NYSE: CB) and is a component of the S&P 500 index. Chubb maintains executive offices in Zurich, New York, London, Paris and other locations, and employs 31,000 people worldwide. Additional information can be found at: chubb.com.
