Database Administrator (DB2 UDB/LUW)

Responsibilities

• Construct and optimize physical database designs tailored for the DB2 UDB/LUW database environment.
• Support application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.
• Design & development Services:
  • Create and update DDL, views, stored procedures, triggers, and queries.
  • Tune and maintain database performance.
• Data Services:
  • Support data replication, reporting, ad-hoc query support, data correction, and change data capture (CDC).
  • Manage data backups and archives, including disaster recovery planning.
  • Support SSIS (SQL Server Integration Services) and related utilities.
• Performance and Tuning Services:
  • Baseline performance profiles and tune databases.
  • Review and optimize indexes and queries.
• Database and OS Upgrade Services:
  • Plan and execute transitions to different DBMS or operating systems.
  • Resolve upgrade-related issues for applications.
• Security Services:
  • Set up non-standard security roles.
  • Develop and implement HOTS (Homeland Threat Operations Support) turnover plans.
• Database Connectivity Support:
  • Carry out necessary planning and execution of system upgrade initiatives.
  • Contribute to maintaining online availability goals.
• Feasibility Studies and Cost Estimates:
  • Respond to user requests with feasibility studies and cost estimates.
• Query Performance Monitoring and Tuning:
  • Monitor and recommend improvements to query performance.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Minimum 5 years of experience in database design, optimization, and administration.
• Experience with DB2 UDB/LUW database environment.
• Strong knowledge of SQL and database management tools.
• Excellent problem-solving and analytical skills.
• Ability to work independently and manage multiple projects simultaneously.
• Proficiency in database security practices and standards.
• Strong communication and interpersonal skills.