DB2 Database Administrator II | Hoboken, NJ, USA

Job description
DB2 Database Administrator II

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 Application DBA to implement and support DB2 z/OS application databases in our organization. The ideal candidate will have a deep understanding of DB2 for z/OS, database architecture, DB2 utilities and IBM DB2 Tools. They will handle tasks related to application database design and review, creation and modification of DB2 z/OS database objects, performance monitoring and tuning, security, backup and recovery, and overall database administration. We require strong problem-solving abilities and a proven track record of optimizing database performance, ensuring high availability, and implementing robust security measures.

Responsibilities

Database Installation and Configuration: DB2 Application DBAs are responsible for working with applications, systems programmers, storage and security teams to design, implement and maintain database objects in DB2 z/OS to support application development, testing and production efforts.

Database Design and Modeling: DB2 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, Stored Procedures and other objects, and ensure data integrity and performance.

Performance Monitoring and Tuning: DB2 DBAs monitor database performance on an ongoing basis. They analyze performance metrics, identify bottlenecks, and work with application development teams to identify and tune the database system and application logic to optimize efficiency. This may involve re-writing and/or optimizing SQL statements, adjusting buffer pool settings, or implementing database partitioning.

Security and Access Control: DB2 DBAs ensure the security of the database system by implementing access controls and user privileges. They work with the application development and security teams to manage DB2 security for databases and database objects via user roles and permissions. They also deploy data masking, encryption and/or authentication mechanisms to protect sensitive data.

Backup, Recovery and Restores: DB2 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. They also perform test system database restores using test and production backups.

Database Maintenance and Upgrades: DB2 DBAs perform routine maintenance tasks, such as database reorganization, statistics collection, and index maintenance. They also support systems programmers in planning and implementing database upgrades and patches, ensuring minimal downtime and compatibility with existing applications.

IBM Utilities IBM DB2 Tools: DB2 DBAs are proficient in using DB2 utilities, IBM DB2 Tools and DB2 monitoring tools to provide day to day application development, testing and production support to meet the needs of the business, ensure DB2 databases are operating efficiently, and to identify and fine tune poor performing SQL statements and processes.

Troubleshooting, Performance Monitoring and Problem Resolution: DB2 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.

Education and Qualifications

• 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.
• Knowledge and hands on experience with DB2 utilities, IBM DB2 Tools, MVS, JCL.
• 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, DB2 systems, 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.
• DB2 certifications are a plus.
• Knowledge and hands on experience with IBM Data Studio is a plus.
• - Knowledge and experience with COBOL, REXX, Java, SAS, CICS, USS, Websphere are a plus.
• - Knowledge and hands on experience with IBM Q Replication is a plus.
• - Financial Industry experience is also a plus.
Salary Range

$120K to $140K

BBH's compensation program includes base salary, discretionary bonuses, and profit-sharing. The anticipated base salary range(s) shown above are only for the indicated location(s) and may differ in other locations due to cost of living and labor considerations. Base salaries may vary based on factors such as skill, experience and qualification for the role. 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.

We value diverse experiences. We value diverse experiences and transferrable skillsets. If your career hasn't followed a traditional path, includes alternative experiences, or doesn't meet every qualification or skill listed in the job description, please do go ahead and apply.

About BBH:

Brown Brothers Harriman (BBH) is a premier global financial services firm, known for premium service, specialist expertise, technology solutions and partnership approach to client management. Across Investor Services and Capital Partners, we work with an enviable roster of sophisticated clients who make BBH their first call when they are tackling their hardest challenges. Delivering for our clients and each other energizes us.

We believe that how we do our work is just as important as what we do. We are relentless problem solvers who know our best ideas come from collective debate and development-so we are never possessive about our ideas. Every day we come together as a diverse community of smart and caring people to deliver exceptional service and expert advice-creating success that lasts. No matter where you sit in the organization, everyone is empowered to contribute their ideas. BBHers can pick up the phone and call any colleague, and they are happy to help. Expanding your impact beyond your daily role is part of how we operate as trusted partners to one another.

We believe stability is a competitive advantage, but being stable means having the knowledge, skill, and discipline to evolve, often-pushing the boundaries of innovation. As a private partnership, every investment we make is in the relationships, technologies, products and development we believe are in the long-term interests of our clients and our people. Our long-tenured leaders are experts in their areas and are actively involved in the day-to day business, taking the time to provide guidance and mentoring to build the next generation of BBHers. Because we know, our success begins with yours.

Go to BBH.com to learn more about our rewards and benefits, philanthropy, approach to sustainability or how we support you to thrive personally, physically and financially.
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, age, genetic information, creed, marital status, sexual orientation, gender identity, disability status, protected veteran status, or any other protected status under federal, state or local law. Read more