IBM DB2 Admin

MSR Cosmos
CA, United States
$110K a year
Full-time
Quick Apply

Role : Location : Remote

Location : Remote

Full Time

Salary : $110K to $11kK per Year

Direct client : Pragma Edge

USC / GC

As an IBM DB2 Database Administrator, you will be responsible for the management, optimization, and overall administration of IBM DB2 databases.

You will ensure the availability, reliability, and performance of DB2 databases that support business-critical applications.

This position requires expertise in database configuration, tuning, security, backup, recovery, and troubleshooting within both distributed and mainframe environments.

Key Responsibilities :

Database Administration :

  • Install, configure, and maintain IBM DB2 databases on Linux, UNIX, IBM Could platforms.
  • Perform database upgrades and patches to ensure the environment is up to date and secure.
  • Manage database objects (tables, indexes, views, etc.) and ensure proper data integrity and normalization.
  • Handle database partitioning, clustering, and replication tasks.

Performance Tuning & Optimization :

  • Monitor and analyze database performance, identifying bottlenecks and tuning SQL queries for optimal performance.
  • Utilize tools such as IBM Data Studio, or third-party software for performance monitoring.
  • Conduct regular database health checks and make recommendations for improvements.

Backup & Recovery :

  • Design and implement robust backup strategies, including automated backups, point-in-time recovery, and disaster recovery planning.
  • Perform DB2 database restores and recoveries, ensuring minimal downtime.
  • Manage database log files and ensure recovery capabilities.

Data Management & Maintenance :

  • Perform regular maintenance tasks, including reorganization, compression, and data archiving.
  • Manage large volumes of transactional data and optimize database performance for OLTP and OLAP systems.
  • Expertise on of cloud platforms (IBM Cloud, Google cloud) is critical

Troubleshooting & Support :

  • Troubleshoot and resolve database issues, including connectivity, performance, and corruption problems.
  • Provide support to development teams for database design, query optimization, and performance tuning.
  • Support high-availability environments and participate in on-call rotations for after-hours support.

Thanks & Regards,

Naveen Paila

Email : [email protected]

Phone : +1(925)-523-4284

7 days ago
Related jobs
MSR Cosmos
CA, United States

Role: </b></p> <p class="wordsection1" style="text-align:justify"><b>Location: Remote </b></p> <p class="wordsection1" style="text-align:justify"><b>Full Time</b></p> <p class="wordsection1&q...

Promoted
MI Windows and Doors
Simi Valley, California

A Production Assembler in Simi Valley, CA is available at Milgard Windows and Doors.You must be able to perform tasks as assigned in the construction of windows and patio doors in all phases of assembly.In addition to meeting departmental manufacturing goals, safety, accuracy, and efficiency ar...

Promoted
Vaco
Pasadena, California

Vaco Los Angeles is working with a client near Culver City, Ca who is in need of an Accounts Receivable Specialist to join their team.The Accounts Receivable Specialist will focus on reconciling the General Ledger and applying payments accurately while making sure all information has relevant back u...

Promoted
Professional Career Solutions
Lynwood, California

We're looking for candidates with great customer service skills to fill our Remote Customer Service role!.This role is entirely remote and offers full-time/Part time hours with flexibility .We are ready to schedule interviews for this week.We're seeking someone who is great with people, building rel...

Promoted
Vaco
Pasadena, California

We are looking for an experienced Raiser’s Edge Specialist to join a fundraising and development team.The ideal candidate will be responsible for managing and optimizing our Raiser’s Edge database, ensuring data integrity, and providing critical support for fundraising activities.This role is crucia...

Promoted
University of California-Berkeley
Berkeley, California

At the University of California, Berkeley, we are committed to creating a community that fosters equity of experience and opportunity, and ensures that students, faculty, and staff of all backgrounds feel safe, welcome and included.Our culture of openness, freedom and belonging make it a special pla...

Promoted
Vaco
Pasadena, California

Vaco Los Angeles is working with a client in the international trucking and port drayage industry who is looking for a well qualified Sale Support Specialist to help support their sales team.As a Sales Support Specialist you will be in charge of supporting all account managers and handling all custo...

Spindle
Los Angeles, California
Remote

Substitute PRN Remote Sign Language Interpreter Jobs in SC.Substitute Remote Sign Language Interpreter (SLI).Remote (As Needed) Looking for SC qualifications, but also accepting for other states!.Are you a skilled Sign Language Interpreter looking to pick up extra hours? Join our team as a Substitut...

Walmart Inc.
Wasco, California

Want to be your own boss? With the Spark Driver™ app, you can shop and deliver for customers of Walmart and other local businesses.Available in more than 3,650 cities and all 50 states, the Spark Driver platform makes it possible for you to reach thousands of customers!.Enroll using the “Apply Now” ...

Monarch Landscape Companies
Napa, California

Monarch Landscape Companies is a family of successful landscape brands in five states across the central and western United States.We are a values-based learning organization committed to being the best place to work as a landscape professional.Our approach to investing in people is simple.There are...