Senior DB2 Database Administrator (z/OS) - Jersey City, NJ
- Moves you to
- United States
- Support
- Visa sponsorship
- Posted
75,532 relocation jobs, straight from company career pages
100% free ยท New jobs every minute
Show job descriptionHide job description
๐ป Specialisation: Mainframe DB2 | DB2 z/OS | IBM DB2 Tools & Architecture
๐ข Work Arrangement: On-site 3โ4 days per week
๐ Benefits: Excellent benefits package + bonus opportunities
๐บ๐ธ Visa Sponsorship: H-1B sponsorship is being considered
Get in touch with me at charneet@omtechllc.comf
Are you an experienced Mainframe DB2 Database Administrator who enjoys solving complex database challenges, optimising performance, and supporting mission-critical enterprise applications?
We're looking for a skilled Senior DB2 Application DBA with strong hands-on experience in DB2 for z/OS, IBM DB2 tools, database architecture, performance tuning, and database administration.
In this role, you'll work closely with application development, systems programming, storage, and security teams to ensure database reliability, performance, availability, and security across a demanding enterprise environment.
๐ Key Responsibilities- Database Administration: Design, implement, configure, and maintain DB2 z/OS application databases and database objects across development, testing, and production environments.
- Database Design: Create and modify database tables, indexes, stored procedures, and other DB2 objects while ensuring data integrity and performance.
- Performance Monitoring & Tuning: Monitor database performance, identify bottlenecks, optimise complex SQL queries, and fine-tune application workloads.
- IBM DB2 Tools & Utilities: Leverage IBM DB2 tools, utilities, and monitoring solutions for day-to-day database administration and production support.
- Backup & Recovery: Develop and execute backup, recovery, and restore strategies to ensure data protection and business continuity.
- Database Maintenance: Perform database reorganisations, RUNSTATS, index maintenance, loads, unloads, and other routine maintenance activities.
- Security & Access Management: Manage database access controls, user privileges, encryption, auditing, and other security measures.
- Troubleshooting & Root Cause Analysis: Investigate database, utility, and performance-related issues using diagnostic tools, logs, and DB2 utilities.
- High Availability & Disaster Recovery: Support and implement solutions that maintain database availability and operational resilience.
- Cross-functional Collaboration: Partner with application developers, DB2 and MVS systems teams, storage, security, and data centre teams.
- 6+ years of hands-on experience as a Mainframe DB2 Database Administrator.
- Strong expertise in DB2 for z/OS, database architecture, and IBM DB2 tools.
- Hands-on experience with DB2 utilities, MVS, and JCL.
- Strong knowledge of database design, DB2 object implementation, and detailed design validation.
- Proven experience in application performance tuning and optimisation of complex SQL statements.
- Practical experience with database backup, recovery, restores, REORG, RUNSTATS, LOAD, and UNLOAD utilities.
- Knowledge of database security best practices, including encryption and auditing.
- Experience supporting high-availability and disaster-recovery solutions.
- Excellent troubleshooting, analytical, and problem-solving skills.
- Strong communication and collaboration skills, with the ability to work in a global, high-demand environment.
- Willingness to provide 24ร7 support when required.
- Bachelor's degree in Computer Science, Information Technology, or a related discipline, or equivalent experience.
- DB2 certifications.
- Hands-on experience with IBM Data Studio.
- Knowledge of IBM Q Replication.
- Exposure to COBOL, REXX, Java, SAS, CICS, USS, or WebSphere.
- Previous experience in the financial services industry.
- Project management experience and the ability to lead, mentor, and support team members.
- Work on enterprise-level Mainframe DB2 environments.
- Take ownership of critical database performance, availability, and reliability.
- Collaborate with experienced cross-functional technical teams.
- Competitive benefits package and bonus opportunities.
- H-1B sponsorship is being considered.
Interested in taking the next step in your DB2 career? Let's connect!
๐ฉ Share your updated resume or reach out directly to learn more.
