USA_Database Administrator jobs in United States
cer-icon
Apply on Employer Site
company-logo

VARITE INC ยท 1 month ago

USA_Database Administrator

VARITE INC is seeking an experienced Database Analyst or Database Systems Programmer with expertise in zDb2. The role involves overseeing database systems, optimizing performance, managing upgrades, and supporting application teams to implement new technologies that align with business goals.

Information Technology & Services
check
Growth Opportunities

Responsibilities

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
Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization
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 Delta 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

Qualification

ZDb2IBM DB2Database AdministrationSQLDisaster RecoveryPerformance TuningADABASIMS DBDCJob Control LanguageData SecurityCommunication Skills

Required

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

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

Company

VARITE INC

company-logo
VARITE has a definite spirit.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Adarsh Katyal
President & CEO
linkedin
leader-logo
Sue Patel Arora
Vice President Of Strategic Partnerships
linkedin
Company data provided by crunchbase