DB2 LUW Database Administrator

company banner
Bank Of America
Database, Application, DBA, DB2, Disaster Recovery, SQL, Performance
Full Time
Work from home not available Travel not required

Job Description

Job Description:

Responsible for database design and analysis, maintenance and database management activities. Involved in the design/redesign of databases to meet specific business needs of user areas and in the testing and correction of databases to ensure system integrity. Ensures quality and efficiencies in the design, implementation, maintenance and administration of database systems. Individual contributor role. Typically requires 5-7 years of applicable experience.

Job Description

Db2 LUW Database Administrator needed to support Market Risk daily operational support for 122 TB data warehouse running on multiple production clustered servers. Market risk provides T-1 market risk measures of Value at Risk and Stress, providing detailed trade risk analytics to Risk Managers.

Job Responsibilities
  • Requirement gathering and performing capacity planning, database physical design, architecture and configuration of large infrastructures, developing complex shell scripts, preparing specifications and defining best practices and standards.
  • Provide database expertise to Application teams; represent DBA team in project planning, sizing, design and defining backup/recovery strategies.
  • Perform, design, build, configuration and administration of DB2 Instances
  • Perform database administration tasks such as patching, upgrading, backup/recovery management and capacity planning
  • Create users and assign permissions based on the level of database access the user would need
  • Implement monitoring procedures to maximize availability and performance of the database/instances
  • Serve as primary DBA for multiple applications
  • Set up high-availability as part of Disaster Recovery Strategy for the databases
  • Perform backups and recovery of SQL databases.
  • Ensure compliance with company standards, policies, and procedures
  • Troubleshoot and perform root cause analysis of problems and recommend solutions to resolve the problems.
  • Promote system reliability and efficiency by implementing standards and best-practices.
  • Perform code migrations and updates through lower level environment ultimately into production.
  • Experience working in a 24x7 environment.


Required Job Skills
  • 5-7 years of supporting DB2 administration experience plus DB2 partitioned databases( DPF) with experience on LUW V11 (LINUX)
  • Experience using Q Replication
  • Hands-on advanced trouble-shooting and performance tuning knowledge/experience;
  • Understand and be able to define different DB2 partitioning strategies;
  • Ability to provide technical documentation, automation scripting, installation, monitoring, and trouble-shooting across a large enterprise environment
  • Ability to work in global environment across time zones
  • Database server and application sizing and capacity planning
  • Database server and application tuning for performance and scalability
  • Performance testing experience
  • In-Depth understanding of High Availability and Disaster Recovery requirements and solutions
  • Advanced troubleshooting techniques in support of On-call duties


Shift:
1st shift (United States of America)

Hours Per Week:
40


Company Information

At Bank of America, we’re creating real, meaningful relationships with individuals, businesses and communities to help them focus on what matters most. Every day, we connect with 57 million customers, using our skills and expertise to help make their lives better. We are committed to attracting and retaining top talent around the world to ensure we continue to deliver together for our customers, clients and communities. Along with taking care of our customers, we want to be a great place for people to work, and we strive to create an environment where all employees have the opportunity to achieve their goals.
Dice Id : 10118499
Position Id : 20003440-1
Originally Posted : 2 months ago

Similar Positions at Bank Of America

Sr. Oracle DBA
  • Richardson, TX
  • 1 week ago
DataStage Developer
  • Plano, TX
  • 1 week ago
DB2 LUW Database Administrator
  • Charlotte, NC
  • 1 week ago