DB2 Database Administrator

A DB2 Database Administrator (DBA) is responsible for managing, maintaining, and optimizing IBM's DB2 databases at SECURA. This role is ideal for individuals with strong technical expertise in database systems, a keen eye for optimization, and a proactive approach to maintaining reliable and secure database environments. As we undergo our modernization journey this role will ensure that our DB2 environment remains performant and be involved in migrating to our newer technology stack.

Responsibilities

• Database Design and Architecture:
• Design and implement DB2 databases to meet business requirements.
• Optimize database schema, indexing, and query performance.
• Database Maintenance:
• Monitor database health, performance, and storage utilization.
• Perform regular backups, recovery, and failover operations.
• Apply patches, upgrades, and fixes to ensure system stability.
• Performance Tuning:
• Identify and resolve performance bottlenecks.
• Implement best practices for database optimization and query tuning.
• Security and Compliance:
• Configure user roles, permissions, and access controls.
• Ensure databases comply with organizational and regulatory security standards.
• Troubleshooting:
• Resolve database-related issues and outages.
• Collaborate with developers, application teams, and infrastructure teams to diagnose problems.
• Documentation and Reporting:
• Maintain detailed documentation of database configurations, processes, and procedures.
• Generate reports for usage, performance, and capacity planning.
  

Skills And Tools

• Technical Skills:
• Proficiency in DB2 on z/OS.
• Knowledge of SQL, stored procedures, Trusted Context, triggers, DB2 PureXML, and other database objects.
• Familiarity with tools like IBM Data Studio and DB2 Query Monitor.
• Performance Monitoring and Tuning:
• Use tools for analyzing and optimizing performance.
• Experience with database compression, partitioning, and clustering.
• Backup and Recovery:
• Expertise in database recovery methods.
• Analytical and Problem-Solving Skills:
• Ability to diagnose and resolve complex database issues effectively.
• Strong task management and communication skills.
  

Qualifications

ESSENTIAL:

• Bachelor’s degree in Computer Science, Information Systems, or related field
• 5 years expertise as a DB2 DBA
  
  

Preferred

• Certification in DB2 Database Administration (ex. IBM Certified Database Administrator) is a plus
• SQL DBA experience
  
  

At SECURA, we are transforming the insurance experience by putting authenticity at the forefront of everything we do. Our mission is clear: we’re making insurance genuine. We recognize that our associates are our greatest assets, and we invest in their well-being and professional growth. We offer opportunities for continuous learning and career advancement, competitive benefits, and a culture that champions work-life balance. Joining SECURA means becoming part of a dynamic team that values each individual’s contribution and fosters a collaborative atmosphere. Here, you’ll not only find a fulfilling career but also a place where you can make a positive impact every day.

SECURA Insurance strives to provide equal opportunity for all employees and is committed to fostering an inclusive work environment. We welcome applicants from all backgrounds and walks of life.