Sr. Database Administrator

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 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 :

"All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. NLB is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation, contact HR department by sending an e-mail to notifications@nlbservices.com."