Application Database Administrator

Description CTG is seeking to fill an Application Database Administrator - RDBMS position for our client Location Remote Duration 7 months Duties Code Review Walk-throughs Analyze COBOL and DB2 code changes for efficiency accuracy and cost optimization Provide actionable feedback to development teams prior to production deployment Streamline the SDLC process to enable smoother code releases Development Support Maintain integrity of approximately 10 development and production environments schemas Manage space volume and data consistency issues Populate environments using flash copies and monitor database utilities and objects Resolve issues via ticketing systems and L2 support processes Performance Monitoring Optimization Monitor and tune SQL queries to enhance DB2 performance Analyze CPU utilization and optimize system efficiency Utilize tools like Mainview for proactive DB2 performance management Reduce unnecessary alerts and improve system scalability monitoring Operational Support Documentation Conduct data archiving and quarterly purges Manage defect tracking through formal issue-tracking systems Document new processes tools and procedures in a centralized knowledge repository Skills Mainframe DB2 Database Administration DBA SQL performance tuning and optimization Code review for COBOL DB2 applications Experience with database utilities flash copies and environment management Familiarity with performance monitoring tools e g Mainview Strong operational and documentation skills Experience Proven experience as a Mainframe DB2 DBA supporting large-scale enterprise environments Hands-on experience with multiple development and production schemas Experience providing L2 support and resolving database issues Strong track record in SQL performance tuning and system optimization Education Bachelor s degree in Computer Science Information Technology or a related field or equivalent experience Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required CTG does not accept unsolicited resumes from headhunters recruitment agencies or fee-based recruitment services for this role The expected base salary for this position ranges from 50 00 to 120 00 hour Salary offers are based on a wide range of factors including relevant skills training experience education market factors and where applicable licensure or certifications obtained In addition to salary a competitive benefit package is also offered About Us CTG a Cegeka company is at the forefront of digital transformation providing IT and business solutions that accelerate project momentum and deliver desired value Over nearly 60 years we have earned a reputation as a faster and more reliable results-driven partner Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts CTG leverages the expertise of over 9 000 team members in 19 countries to provide innovative solutions Together we operate across the Americas Europe and India working in close cooperation with over 3 000 clients in many of today s highest-growth industries For more information visit Our culture is a direct result of the people who work at CTG the values we hold and the actions we take In other words our people define our culture It s a living breathing thing that is renewed every day through the ways we engage with each other our clients and our communities Part of our mission is to cultivate a workplace that attracts and develops the best people reflected by our recognition as a Great Place to Work Certified TM company across many of our global operations CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local state and federal laws CTG is an Equal Opportunity Employer CTG will assure equal opportunity and consideration to all applicants and employees in recruitment selection placement training benefits compensation promotion transfer and release of individuals without regard to race creed religion color national origin sex sexual orientation gender identity and gender expression age disability marital or veteran status citizenship status or any other discriminatory factors as required by law CTG is fully committed to promoting employment opportunities for members of protected classes