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.

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.

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.

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.

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.

o Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.

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 :

Preferred Qualifications :

Education & Certification Requirements :

Work Environment :

Equal opportunity employer including disability / veterans.