Database Administrator
Location: Atlanta, GASalary Range: Competitive and commensurate with experienceIntroduction We are seeking an experienced professional with a passion for database management and optimization. This role involves overseeing database systems, optimizing performance, managing upgrades, and supporting application teams to implement new technologies that align with business goals.Required Skills & Qualifications (Must-have qualifications that candidates must meet to be considered)
- Applicants must be able to work directly for Artech on W2
- Minimum of 8 years of experience with zDb2, IMS DBDC, 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 zOS 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 Skills & Qualifications (Nice-to-have skills but are not required)
- Knowledge of IBM DB2, IMS DBDC, and ADABAS database products
- Familiarity with service level management, change management, and incident resolution
- Experience working with external vendors and managing software upgrades
Day-to-Day Responsibilities (Key tasks and expectations for the role)
- Manage and maintain IBM DB2 databases on the zOS 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
- Monitor database performance metrics to identify and resolve bottlenecks
- Perform database tuning to enhance query performance and maintain optimal system functioning
- 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
- 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
Company Benefits & Culture
- Inclusive and diverse work environment
- Opportunities for professional growth and development
- Supportive team culture with a focus on collaboration
For immediate consideration please click APPLY to begin the screening process with Alex.
Artech Information Systems