Senior IBM Db2 Database Administrator - HBITS-08-15058

Location: Albany, NY 12240 | Duration: 30 Months | Agency: NYS Dept of Labor | Project: NYSDOL Data Warehouse / UISIM project support

About the role

We are seeking a skilled Data Management Specialist to support the Department of Labor's (DOL) Unemployment Insurance System’s operational functions. This role involves administering DB2 databases on Red Hat Linux. The ideal candidate will possess technical expertise in these areas, problem-solving abilities, and the ability to collaborate effectively with cross-functional teams.

Requirements

• 72 months DB2 Database Administration Expertise: Experience in administering DB2 databases on Linux environments, including installation, configuration, performance tuning, backup/recovery, and security management
• 84 months Red Hat Linux Proficiency: Experience in Red Hat Linux operating systems, including command-line administration, scripting, and system troubleshooting
• 84 months Database Performance Tuning and Optimization Expertise: Analyze and resolve performance bottlenecks in Db2 databases, including query optimization, index management, buffer pool tuning, and workload management
• 84 months High Availability and Disaster Recovery (HADR) for Db2: Experience in setting up, configuring, and managing Db2 HADR solutions to ensure business continuity and data resilience
• 60 months Google Cloud Platform Expertise: Experience with Google Cloud Platform services relevant to database deployments, such as Compute Engine (for bare metal instances), networking (VPCs, firewalls), storage (Persistent Disks), and IAM for access control
• 60 months Scripting and Automation: Experience in scripting languages such as Bash, Python, or Perl for automating routine database administration tasks, deployments, and monitoring
• 60 months Troubleshooting and Problem-Solving: Analytical and problem-solving skills to quickly diagnose and resolve complex issues related to Db2, RHEL, and their interaction within the Google Cloud Platform environment
• 84 months Backup and Recovery Strategies: Experience in designing, implementing, and testing robust backup and recovery strategies for Db2 databases, including full, incremental, and log backups, and performing point-in-time recoveries
• 84 months Monitoring and Alerting: Experience with setting up and utilizing monitoring tools (e.g., Dynatrace, Data Management Console, or Google Cloud Platform's native monitoring tools) to track Db2 and RHEL system health, performance, and to configure proactive alerts
• 84 months Security Best Practices: Experience in implementation of security best practices for both Db2 databases and RHEL systems, including user and group management, access control, encryption, and vulnerability management