Accord Technologies Inc ยท 5 months ago
Mainframe Database Analyst
Atlanta, GA
Full-time
Onsite
Senior Level, Lead/Staff
9+ years expAccord Technologies Inc is seeking an experienced Mainframe Database Analyst or Database Systems Programmer with expertise in mainframe database technologies including z/DB2, IMS DB/DC, and ADABAS. The role involves overseeing and optimizing database systems, managing software upgrades, supporting application development, and ensuring compliance with business and technical standards.
Information Technology & Services
Responsibilities
Manage IBM DB2 databases on the z/OS mainframe platform
Create and maintain database objects (tables, indexes, tablespaces)
Perform data loading, unloading, and reorganization using DB2 utilities
Develop and implement database backup, recovery, and disaster recovery strategies
Monitor and analyze database performance to identify and resolve bottlenecks
Tune databases and optimize queries for maximum system efficiency
Use tools like RUNSTATS to maintain accurate statistics for query optimization
Work closely with application development teams to support technology projects and system enhancements
Provide expert consultation on database architecture and performance
Collaborate on schema design and implementation
Oversee external DBA and systems programming teams during software installation and support
Manage change, incident, and service level processes
Coordinate with vendors for software upgrades and ensure smooth transitions
Monitor system health to ensure high availability and proactively resolve issues
Communicate potential risks to management and develop mitigation strategies
Support compliance efforts including SOX audit participation and reporting
Ensure adherence to data security and regulatory standards
Lead or participate in disaster recovery planning and testing
Ensure database systems can recover effectively from system failures
Keep up to date with advancements in database and mainframe technologies
Evaluate and plan for deprecated feature retirement and lifecycle upgrades
Qualification
Required
Minimum 9 years of experience with z/DB2, IMS DB/DC, and/or ADABAS
Proficient in IBM Infosphere Data Replication (IIDR) or similar replication tools
Strong knowledge of zConnect Enterprise Edition (zCEE) API framework
Deep expertise in DB2 administration on z/OS
Strong SQL skills; expertise in partitioning, indexing, performance tuning, and data sharing
Experience with mainframe operating systems and Job Control Language (JCL)
Understanding of data security best practices and compliance frameworks
Proven ability to troubleshoot and resolve complex database issues
Experience in backup/recovery procedures and disaster recovery planning
Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience
Preferred
Familiarity with service level, incident, and change management processes
Experience working with external vendors and managing software lifecycle upgrades
Relevant certifications in DB2 or related technologies
Company
Accord Technologies Inc
We are one of the pioneers in Information technology consulting and staffing industry.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase