Job Category: Infrastructure EngineeringJob Description:In this role, you will:DB2LUWSupport logical and physical database creation as well as database object creationPerform Db2LUW version upgrades and patching on the Db engineImplement more advance features such as data encryption for data inflight and at restProvide on-call DBA supportParticipate 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 RubrikReplatform from AIX to Linux for all DB2LUW databases.Azure cloud-Cosmos-MongoDatabase 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.Qualifications:Educational requirements - college degree in Computer Science or Computer Technology preferredRequired skills, knowledge and abilities:DB2LUW EE version 11.x features and functionsTSM backup, restore, archive log operationsDB2 Client installation, configuration and catalogingDB2 Connect supportDB2 EE installation, instance creation, and patching experienceDB2 utilitiesAdditional skills: o HADR configuration - a plusRubrik software experience - a plusExperience replatforming from AIX to LinuxImplementing TLSD on Db2LUW - a plusAlerting and monitoring tool experience - Science Logic, Solar-winds-DPA - a plusAdditional DBMS platform experience in Oracle, Informix, DB2 zOS and IMS- a big plusDB2 zOS experience - a plusInterpersonal skillsVerbal 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 & PostgreSQLProven experience with Cosmos DB/MongoDB scaling across data centers and/or in-depth understanding of HA strategies, including replica sets and shardingAnalyze 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 developersMonitor 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 measuresEnforce best practices for database security, including data masking, encryption, and role-based access controlAutomate 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
