DBDatabase Administrator
Job in
City of Albany, Albany, Albany County, New York, 12201, USA
Listing for:
Trigyn Technologies Limited
Full Time
position
Listed on 2026-11-14
Job specializations:
-
IT/Tech
Job Description & How to Apply Below
Location: City of Albany
Trigyn's direct government client has an immediate need for DB2 Database Administrator in Albany, NY.
Description: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.
- Perform administration of Db2 databases hosted on bare-metal Red Hat Enterprise Linux (RHEL) environments.
- Monitor Db2 database performance metrics, including CPU usage, memory usage, disk I/O, and buffer pool hit ratios.
- Deploy, maintain, and monitor Db2 monitoring utilities, including IBM Data Management Console (DMC).
- Develop scripts and tools to automate ongoing monitoring, maintenance, and administrative tasks for Db2.
- Review overnight alerts, monitoring dashboards, and Db2 diagnostic logs daily to identify, troubleshoot, and resolve critical database errors, warnings, and incidents.
- Perform routine database maintenance tasks, including running RUNSTATS, REORGCHK, and REORG.
- Apply database patches and upgrades in accordance with established agency change management procedures.
- Monitor and validate database backup and recovery processes to ensure data integrity.
- Review Db2 security settings and user access privileges, and monitor systems for unauthorized access attempts.
- Document all administrative work performed, including system changes, issues encountered, and resolutions, and update knowledge base articles as needed.
- Respond to service requests and emails related to data management tasks, and prioritize work based on urgency and business impact.
- Participate in daily stand-up meetings to provide progress updates and report roadblocks to State supervisory staff.
Qualifications:
- Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
- Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.
- 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 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 (GCP) Expertise:
Experience with GCP 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 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 GCP environment. - 84 Months of experience Backup and Recovery Strategies:
Experience in designing, implementing, and…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction