Midlevel DB2 Database Administrator

$72,100 - $120,900/Yr

ManTech - Colorado Springs, CO

Full-time - Mid Level

Remote - Colorado Springs, CO

Professional, Scientific, and Technical Services

About the position

Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, you'll help protect our national security while working on innovative projects that offer opportunities for advancement. Currently, ManTech is seeking a motivated, career and customer-oriented Midlevel DB2 Database Administrator to join our team in Colorado Springs, CO or Annapolis Junction, MD. The DB2 administrator will provide technical support day-to-day in a DB2 HADR in both AIX and RHEL environments. Responsibilities include providing technical support across chartered projects, Security Remediation, Disaster Recovery, and Standard O&M support managing and coordinating changes to DB2 (version 11.x) and DB2 FixPaks in AIX and Linux. You will 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. Additionally, you will configure and monitor databases across all application services, maintain systems, user databases, and instances in AIX and Linux environments, and manage database backups and recoveries with IBM TSM. This role requires expertise in scripting SQL, Perl, and Shell, and the ability to review project requests describing database user needs to estimate time and cost required to accomplish projects.

Responsibilities

• Provide technical support day-to-day in a DB2 HADR in both AIX and RHEL environments.
• Provide technical support across chartered projects, Security Remediation, Disaster Recovery, and Standard O&M support managing and coordinating 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.
• Expert in scripting SQL, Perl, and Shell.
• 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. Ability to write clear documentation of operating procedures, and ability to write detailed specifications.
• Must have a 'can-do' attitude, work well in a cross-functional environment, must be able to work well without supervision and lead others. Candidate should be a self-starter, quick learner and great team player.
• Possess the ability to prioritize competing priorities and work in a cross-matrix management organization.
• Required to be on-call and respond in a timely manner.

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. (Education can be substituted for experience).

Benefits

• Health Insurance
• Life Insurance
• Paid Time Off
• Holiday Pay
• Short Term and Long Term Disability
• Retirement and Savings
• Learning and Development opportunities
• Wellness programs
• Other optional benefit elections