Database Architect - DB2, Linux

HBITS: HBITS-08-15058

Senior, Database Architect

30 month contract

Interview: Virtual Interview

Work model: 50% telecommuting, 50% Office per week in Albany, NY

--- Project Description ---
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.

--- Day-to-Day Tasks ---
1. Perform administration of Db2 databases hosted on bare-metal Red
Hat Enterprise Linux (RHEL) environments.
2. Monitor Db2 database performance metrics, including CPU usage,
memory usage, disk I/O, and buffer pool hit ratios.
3. Deploy, maintain, and monitor Db2 monitoring utilities, including IBM
Data Management Console (DMC).
4. Develop scripts and tools to automate ongoing monitoring,
maintenance, and administrative tasks for Db2.
5. Review overnight alerts, monitoring dashboards, and Db2 diagnostic
logs daily to identify, troubleshoot, and resolve critical database errors,
warnings, and incidents.
6. Perform routine database maintenance tasks, including running
RUNSTATS, REORGCHK, and REORG.
7. Apply database patches and upgrades in accordance with established
agency change management procedures.
8. Monitor and validate database backup and recovery processes to
ensure data integrity.
9. Review Db2 security settings and user access privileges, and monitor
systems for unauthorized access attempts.
10. Document all administrative work performed, including system
changes, issues encountered, and resolutions, and update knowledge
base articles as needed.
11. Respond to service requests and emails related to data management
tasks, and prioritize work based on urgency and business impact.
12. Participate in daily stand-up meetings to provide progress updates
and report roadblocks to State supervisory staff.

--- Required Qualifications ---
84 Months of experience 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 of experience Google Cloud Platform (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.
72 Months of experience DB2 Database Administration Expertise: Experience
in administering DB2 databases on Linux environments, including
installation, configuration, performance tuning, backup/recovery, and
security management
84 Months of experience Red Hat Linux Proficiency: Experience in Red Hat
Linux operating systems, including command-line administration, scripting,
and system troubleshooting.
84 Months of experience 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 of experience 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 of experience 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.
60 months of experience Scripting and Automation: Experience in scripting
languages such as Bash, Python, or Perl for automating routine database
administration tasks, deployments, and monitoring.
60 months of experience 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 of experience 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.

MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.