Sr. Database Administrator (Contract W2)

Position : Sr. Database Administrator (Contract W2)

Location : Atlanta, GA (onsite)

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.

Job Description :

• 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.

Responsibilities:

• Manage and maintain IBM DB2 databases on the z/OS mainframe platform.
• Create and manage database objects, such as tables, indexes, and table spaces.
• Perform data manipulation operations like loading, unloading, and reorganizing data using DB2 utilities.
• Implement database backup and recovery strategies to ensure data availability and disaster recovery

Performance Monitoring & Optimization:

• Monitor database performance metrics to identify and resolve bottlenecks.
• Perform database tuning to enhance query performance and maintain optimal system functioning.
• Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization.

Collaboration & Consultation:

• Develop and maintain effective communication with application teams regarding infrastructure technology projects and roadmaps.
• Serve as a consultant to application teams and business users on new technologies and system enhancements.
• Collaborate with application developers to design and implement database schema changes.

Software & System Management:

• Oversee external DBA teams and systems programmers during the installation and support of mainframe database software.
• Facilitate service level management, including change management, incident, and problem management.
• Stay current with software upgrades, ensuring timely implementation of new features that enhance Delta applications.
• Work with external vendor teams to ensure smooth conversions during software updates and releases.
• Proactively monitor database platforms for high availability, identifying root causes and correcting issues.

Risk Management & Compliance:

• Keep management informed of risks and develop mitigation strategies to reduce potential risks.
• Participate in audit reviews, including completing quarterly SOX audits and ensuring compliance with regulations.

Disaster Recovery & Business Continuity:

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

Technology Strategy & Lifecycle Management:

• Stay up-to-date on advancements in database technologies and lifecycle management, particularly focusing on deprecated features and mitigation planning

Regards !!

Bobby Sharma

Talent Acquisition Lead

Sapear Inc.

Email :

Cell : +1 Ext : 105

Mobile: +91 -

We are hiring: