Dhara Consulting Group - Colorado Springs, CO

posted 4 months ago

Full-time - Mid Level
Remote - Colorado Springs, CO
Professional, Scientific, and Technical Services

About the position

Today, ManTech International Corporation is seeking a motivated, career and customer-oriented Midlevel DB2 Database Administrator to join our team in Colorado Springs, CO or Annapolis Junction, MD. As a DB2 administrator, you will play a crucial role in providing technical support for day-to-day operations in a DB2 High Availability Disaster Recovery (HADR) environment, specifically in AIX and RHEL systems. Your responsibilities will include managing and coordinating changes to DB2 (version 11.x) and DB2 FixPaks, implementing database changes to enhance performance and security, and planning and coordinating security measures to safeguard databases. You will also be tasked with measuring database performance and troubleshooting complex database and HADR issues, configuring and monitoring databases across all application services, and maintaining user databases and instances in both AIX and Linux environments. In this role, you will configure and maintain schemas, table spaces, tables, indexes, buffer pools, and logs, as well as manage database backups and recoveries using IBM TSM. Your expertise in scripting SQL, Perl, and Shell will be essential as you review project requests to estimate time and costs required to accomplish database user needs. The ideal candidate will have at least 3 years of hands-on DB2 administration experience, including upgrades, configuration, tuning, index creation, and performance analysis, along with experience in high availability environments and various business processes and system modeling tools. You will be expected to work well in a cross-functional environment, possess excellent communication skills, and be a self-starter who can prioritize competing priorities effectively. Additionally, you will be required to be on-call and respond in a timely manner to any issues that arise.

Responsibilities

  • Provide technical support day-to-day in a DB2 HADR in both AIX and RHEL environments.
  • Manage and coordinate changes to DB2 (version 11.x) and DB2 FixPaks in AIX and Linux.
  • Implement database changes to improve performance and security.
  • Plan, coordinate, and implement security measures to safeguard databases.
  • Measure database performance and troubleshoot complex database and HADR issues.
  • Configure and monitor databases across all application services.
  • Configure and maintain systems, user databases, and instances in AIX and Linux environment.
  • Configure and maintain schemas, table spaces, tables, indexes, buffer pools, and logs.
  • Configure and manage database backups and recoveries with IBM TSM.
  • Review project requests describing database user needs to estimate time and cost required to accomplish project.

Requirements

  • 3 years hands-on DB2 administration experience inclusive of upgrades, configuration, tuning, index creation and performance analysis.
  • 2 years hands-on experience with DB2 HADR installations.
  • Experienced in configuration, security, failover, and optimization of databases in high availability environment.
  • Experience with various business processes and system modeling tools including Data Flow Diagrams, Process Models, ER Diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process Decomposition and Use Case Scenarios.
  • Experience in planning and implementing fault tolerant and high availability systems.
  • Hands-on experience implementing and configuring packaged real-time monitoring and alerting solutions.
  • Experience with other performance monitors (e.g., Omegamon).
  • Hands-on experience with automation of tools, implementations, scripting and database reporting metrics and reports.
  • Heavy SQL experience writing complicated queries from scratch, tuning code, analyzing impacts.
  • Experience with SAN storage systems.
  • Expertise in backup/recovery/fail-over methods and best practices.
  • Excellent written and verbal communication skills.

Nice-to-haves

  • IBM AIX Administration
  • RHEL Administration
  • IBM Tivoli Monitoring
  • IBM Tivoli Storage Manager
  • ITIL Certification
  • A bachelor's degree or equivalent in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline with 3 or more years related professional experience.

Benefits

  • Disability insurance
  • Health insurance
  • Paid time off
  • Opportunities for advancement
  • Life insurance
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service