Sr. Database Administrator

Immediate need for a talented Sr. Database Administrator. This is a 12+ Months Contract opportunity with long-term potential and is located in Atlanta, GA. Please review the job description below and contact me ASAP if you are interested.

Job ID: 25-83631

Pay Range: $58-$68/hour.  Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
 
Key Responsibilities:

• Manage and maintain Client 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.
• 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 Client 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.
• 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.
• Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.
•  Stay up-to-date on advancements in database technologies and lifecycle management, particularly focusing on deprecated features and mitigation planning.

Key Requirements and Technology Experience:

• Minimum of 8 years of experience with zDb2, IMS DB/DC, and/or ADABAS.
• Proficiency with replication software such as IIDR – Client Infosphere Data Replication Suite.
• Strong understanding of zConnect Enterprise Edition (zCEE) API framework.
• Expertise in Client 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.
• Knowledge of Client 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.
• 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.
• 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.

Our client is a leading Airlines organization and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
 
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

"If you are a person with disability needing assistance with the application or at any point in the hiring process, please contact us at

" #DOL J2W:CB3