Apply on Employer Site

Brown Brothers Harriman · 2 weeks ago

DB2 Database Administrator II

Jersey City, NJ

Full-time

Onsite

Senior Level

$120K/yr - $140K/yr

5+ years exp

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. They are seeking a highly skilled and motivated Senior DB2 Application DBA to implement and support DB2 z/OS application databases, focusing on database design, performance monitoring, security, and backup strategies.

BankingFinancial ServicesSecurity

H1B Sponsor Likely

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

Qualification

DB2 z/OSDatabase AdministrationPerformance MonitoringBackupRecoveryDB2 UtilitiesIBM DB2 ToolsDatabase SecurityDB2 CertificationsIBM Data StudioCOBOLJavaREXXSASCICSUSSWebsphereIBM Q ReplicationFinancial Industry ExperienceProblem SolvingTeam PlayerCommunication SkillsProject Management

Required

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

Preferred

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

Benefits

Discretionary bonuses

Profit-sharing

Long-term savings

Healthcare

Income protection

Professional development opportunities

Time off

Company

Brown Brothers Harriman

Glassdoor3.7

Brown Brothers Harriman is an American partnership bank that offers a range of international investment and banking services.

Founded in 1995

New York, New York, USA

5001-10000 employees

http://www.bbh.com

H1B Sponsorship

Brown Brothers Harriman has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (22)

2024 (16)

2023 (18)

2022 (23)

2021 (15)

2020 (10)