Senior DB2 z/OS, Systems Database Administrator

Brown Brothers Harriman & Co•Jersey City, NJ

4d•$130,000 - $190,000

About The Position

At BBH, Partnership is more than a form of ownership—it’s our approach to business and relationships. We know that supporting your professional and personal goals is the best way to help our clients and advance our business. We take that responsibility seriously. With a 200-year legacy and a shared passion for what’s next, this is the right place to build a fulfilling career. We are seeking a highly skilled and motivated Senior DB2 System DBA to manage and maintain the DB2 for z/OS database systems in our organization. The ideal candidate will have a deep understanding of DB2 for z/OS, DB2 utilities and IBM DB2 Tools. They will handle tasks related to database design, installation, configuration, performance tuning, security, backup and recovery, and overall system administration. We require strong problem-solving abilities and a proven track record of optimizing database performance, ensuring high availability, and implementing robust security measures.

Requirements

Bachelor's degree in computer science, information technology, or a related field (or equivalent experience).
5-10 years of hands-on experience in DB2 z/OS database administration.
Hands on experience with SMPE, MVS, JCL.
Knowledge and hands on experience working with IBM utilities and IBM DB2 Tools.
Detailed design validation, implementation of DB2 objects, performance monitoring, and tuning (proficiency and hands on experience tuning applications and tuning complex SQLs).
Strong technical aptitude with the ability to solve problems, perform database backup, recovery, reorg, runstats, unloads, and loads while conforming to and/or improving company standards.
Strong expertise in implementing and managing high availability and disaster recovery solutions.
Knowledge of database security best practices, including encryption and auditing.
Team player working closely with DBA’s and other groups: development teams, MVS systems, storage, security, and the data center.
Willing and able to provide 24 x 7 support as needed.
Excellent verbal and written communication skills.
Project management skills and the ability to lead and mentor a team.

Nice To Haves

DB2 certifications are a plus.
Knowledge and hands on experience with DB2 Connect is a plus.
Knowledge and hands on experience with IBM Q Replication is a plus.
Experience with DB2 LUW, Linux, and Shell Scripting are a plus.
Knowledge and experience with COBOL, REXX, SAS, CICS, Java, Websphere are a plus.
Financial Industry experience is also a plus.

Responsibilities

Database Installation and Configuration: DB2 System DBAs are responsible for installing and configuring the DB2 database software on mainframe, servers and workstations. This includes setting up database instances, defining storage structures, and configuring memory and other system parameters.
Database Design and Modeling: DB2 System DBAs work closely with application developers and system analysts to design and implement database structures that meet the organization's requirements. They design database tables, indexes, and other objects, and ensure data integrity and performance.
Performance Monitoring and Tuning: DB2 System DBAs monitor database performance on an ongoing basis. They analyze performance metrics, identify bottlenecks, and tune the database system to optimize its efficiency. This may involve optimizing SQL queries, adjusting buffer pool settings, or implementing database partitioning.
Security and Access Control: DB2 System DBAs ensure the security of the database system by implementing access controls and user privileges. They create and manage database user accounts, roles, and permissions. They also enforce data encryption and authentication mechanisms to protect sensitive data.
Backup and Recovery: DB2 System DBAs develop and implement backup and recovery strategies to safeguard data and ensure business continuity. They schedule regular backups, perform database recoveries in case of failures, and test recovery procedures to validate their effectiveness.
Database Maintenance and Upgrades: DB2 System DBAs perform routine maintenance tasks, such as database reorganization, statistics collection, and index maintenance. They also plan and execute database upgrades and patches, ensuring minimal downtime and compatibility with existing applications.
IBM Utilities, IBM DB2 Tools, SMPE: DB2 System DBAs install, upgrade and maintain/apply patches to DB2 z/OS.
Troubleshooting and Problem Resolution: DB2 System DBAs investigate and resolve database, utilities, and tools related issues, such as performance problems, data corruption, or system failures. They utilize diagnostic tools, logs, and database utilities to identify the root causes and implement appropriate solutions.

Benefits

BBH’s compensation program includes base salary, discretionary bonuses, and profit-sharing.
BBH's total rewards package recognizes your contributions with more than just a paycheck—providing you with benefits that enhance your experience at BBH from long-term savings, healthcare, and income protection to professional development opportunities and time off, our programs support your overall well-being.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume