US CITIZENS ONLY. Immediate opening.
SnapIT Solutions has a full-time opening for an experienced Senior DB2 Database Administrator at FRB Kansas City. We are looking for an organized, detail-oriented person with proven skills to work collaboratively with our federal government customer. This is a 80-20% (remote-onsite) hybrid working position for KC, Omaha, Denver, Oklahoma City OR 100% remote.
Key Activities
- This position will support the Payment Automation Manager (PAM) team.
- Performs application and system operational and on-call duties. Implements solutions to Critical and High Incidents to solve problems and eliminate future recurrence. Tunes databases, software, and operating system environments.
- Collaborates with architects and product teams to ensure that the designed solution responds to non-functional requirements such as availability, performance, security, and maintainability.
- Performs Database Management System design using data modeling tools. Creates database objects such as tables, views, stored procedures, triggers, sequences, constraints, and rules.
- Troubleshoots problems and provides resolution, including SQL tuning, solving performance and/or connectivity issues, fixing corrupt indexes, restoring corrupt databases from backup, and assisting developers with repairing corrupted data.
- Identifies tasks and estimates as appropriate for business line support.
- Creates documentation for standards, design, support, implementation, and troubleshooting of databases and database management systems.
Required Technical Skills
- Database Administrator experience with DB2 on Linux (RHEL).
- People skills: Work with application development team to design and create database objects.
- Performance tuning skills: monitoring and optimizing database performance.
- Experience coding and explaining complex SQLs.
- Backup and Recovery: Implementing and testing backup and recovery procedures.
- Good problem solving, analytical and critical thinking skills.
- In depth knowledge and understanding of tools (DB2PD, DB2TOP, etc.).
- Programming experience with Unix/Linux Shell script.
Preferred Technical Skills
- Database Administrator experience with Db2 on z/OS and PostgreSQL.
- Maintain Erwin data model.
- Ability to learn new technologies.
Location
- HYBRID - Kansas City, Omaha, Denver, Oklahoma City OR
- 100% Remote if living in other areas
Screening
- US Citizenship is required.
- Treasury level screening is required.. The areas screened may include education/employment verification, criminal history, credit history, and reference checks.
Job Type: Full-time
Pay: $110,000.00 - $140,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Experience level:
Schedule:
Application Question(s):
- Are you a citizen of US?
- Do you have previous working experience in federal government agency?
Work Location: In person