Sr. Database Administrator

Pay range: $59.57 - 69.57 Plus Health, Dental, Vision, Short Term/Long Term Disability, and Group Life pending eligibility Job Summary: We are seeking an experienced Database Analyst or Database Systems Programmer with a minimum of 8 years of experience working with zDb2. The ideal candidate will have strong expertise in mainframe database technologies, including z/Db2, IMS DB/DC, and/or ADABAS. This role involves overseeing database systems, optimizing performance, managing upgrades, and supporting application teams to implement new technologies that align with business goals. Key Responsibilities: · Database Administration & Maintenance: o Manage and maintain IBM DB2 databases on the z/OS mainframe platform. o Create and manage database objects, such as tables, indexes, and table spaces. o Perform data manipulation operations like loading, unloading, and reorganizing data using DB2 utilities. o Implement database backup and recovery strategies to ensure data availability and disaster recovery. · Performance Monitoring & Optimization: o Monitor database performance metrics to identify and resolve bottlenecks. o Perform database tuning to enhance query performance and maintain optimal system functioning. o Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization. · Collaboration & Consultation: o Develop and maintain effective communication with application teams regarding infrastructure technology projects and roadmaps. o Serve as a consultant to application teams and business users on new technologies and system enhancements. o Collaborate with application developers to design and implement database schema changes. · Software & System Management: o Oversee external DBA teams and systems programmers during the installation and support of mainframe database software. o Facilitate service level management, including change management, incident, and problem management. o Stay current with software upgrades, ensuring timely implementation of new features that enhance Delta applications. o Work with external vendor teams to ensure smooth conversions during software updates and releases. o Proactively monitor database platforms for high availability, identifying root causes and correcting issues. · Risk Management & Compliance: o Keep management informed of risks and develop mitigation strategies to reduce potential risks. o Participate in audit reviews, including completing quarterly SOX audits and ensuring compliance with regulations. · Disaster Recovery & Business Continuity: o Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures. · Technology Strategy & Lifecycle Management: o Stay up-to-date on advancements in database technologies and lifecycle management, particularly focusing on deprecated features and mitigation planning. Quals-- Required Skills & Knowledge: · Minimum of 8 years of experience with zDb2, IMS DB/DC, and/or ADABAS. · Proficiency with replication software such as IIDR – IBM Infosphere Data Replication Suite. · Strong understanding of zConnect Enterprise Edition (zCEE) API framework. · Expertise in IBM DB2 database administration on z/OS mainframe platforms. · In-depth knowledge of SQL, DB2 partitioning, indexing, data sharing, and performance tuning techniques. · Experience with mainframe operating system concepts and Job Control Language (JCL). · Familiarity with data security best practices and compliance regulations. · Ability to troubleshoot and resolve complex database-related issues. · Strong experience in managing database backups, recovery procedures, and disaster recovery planning. Preferred Qualifications: · Knowledge of IBM DB2, IMS DB/DC, and ADABAS database products. · Familiarity with service level management, change management, and incident resolution. · Experience working with external vendors and managing software upgrades. Education & Certification Requirements: · Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience). · Relevant certifications in DB2 or related database technologies are a plus. Work Environment: · Full-time, with on-call support and responsibilities for managing database platforms and applications. · Collaboration with various internal and external teams to ensure high performance and availability of database systems. Equal opportunity employer including disability/veterans.

#J-18808-Ljbffr