Job Title: Sr. Database Administrator
Location: Atlanta, GA 30354 (Hybrid)
Duration: 12+ Months
Qualifications:
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.
Responsibilities:
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.
1. Bachelor's degree or above in Russian language major, with a passing score of TEM-8/T C 1 (fluency in spoken language is preferred);2. Proficient in using Office and able to write emails in Russian;3. Strong ability to withstand pressure, willing to accept long...
...education. Decisions will be determined on a case-by-case basis. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. Marsh & McLennan Agency offers competitive salaries and comprehensive...
...About the Role: We are seeking an experienced Construction Manager to support Electric Maintenance & Construction (M&C) operations for a major utility provider in San Luis Obispo, CA . This role provides end-to-end construction management across multiple electric...
- Delivery Driver - Class A JobSafely and efficiently deliver the companys products (cases and kegs) to retail accounts from a commercial... ...).a. Navigate the city by reading addresses or utilizing a map.4. Present a professional attitude and appearance.5. Execute...
We are seeking a discreet and highly organized Personal Assistant to support day-to-day personal and household operations. This role is best suited for someone who thrives in dynamic environments, is solutions-oriented, and can work both independently and collaboratively...