What are the responsibilities and job description for the Database Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Unicorn Technologies LLC, is seeking the following. Apply via Dice today!
Job Title: Database Architect
Location: Albany, NY
Visa: NO GC
Job Description:
Mandatory Qualification
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.
The position is in support of 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 guide state and collaborate with cross-functional teams in these areas.
Daily tasks include, but are not limited to:
Morning Check-in:
Job Title: Database Architect
Location: Albany, NY
Visa: NO GC
Job Description:
Mandatory Qualification
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.
The position is in support of 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 guide state and collaborate with cross-functional teams in these areas.
Daily tasks include, but are not limited to:
Morning Check-in:
- Review overnight alerts and monitoring dashboards for any critical issues across DB2 systems.
- Check for any new service requests or incidents related to data management.
- Prioritize tasks based on urgency and impact.
- Respond to emails and messages related to data management tasks.
- Participate in daily stand-up meetings (if applicable) to provide updates on progress and any roadblocks.
- Document all work performed, including changes made, issues encountered, and resolutions.
- Update knowledge base articles as needed.
- DB2 Administration (Bare Metal Red Hat Linux):
- Monitor DB2 database performance metrics (CPU usage, memory usage, disk I/O, buffer pool hit ratios).
- Check for any database errors or warnings in the DB2 diagnostic logs.
- Deploy, maintain and monitor DB2 monitoring utilities including IBM DMC
- Develop scripts and tools to automate ongoing monitoring and maintenance for DB2
- Monitor database backup and recovery processes.
- Perform routine database maintenance tasks (e.g., running RUNSTATS, REORGCHK, REORG).
- Apply database patches and upgrades as needed (following change management procedures).
- Review DB2 security settings and user access privileges.
- Monitor for any unauthorized access attempts.