What are the responsibilities and job description for the DB2 DBA position at SmartIMS Inc.?
Job Description
Job Responsibilities:
- Troubleshoot, analyze for root causes for problems, ensure database availability, security and stability, performance tuning and optimization.
- Provides expertise to Application programmer staff technical questions related to Db2.
- Manages and maintains data in all Production and Test Db2 (Mainframe z/OS)
- Handles data refreshes from Production to Test environments based on user requirements.
- Performs maintenance of the Db2 environments including image copies, performance monitoring, capacity management, and object upgrades.
- Provides 24x7 on call support and works as needed after normal working hours to implement changes.
Required Qualifications:
- Bachelor’s degree in computer science or qualifying work experience.
- Experience with z/OS Db2 V10 or higher
- Experience with Db2 LUW and Linux
- 2 years z/OS Db2 DBA including running utilities, performance monitoring, writing, and debugging complex DDL and SQL, managing Db2 Packages and security.
- Strong z/OS Db2 object management experience including but not limited to, Referential Integrity, Triggers, Aliases, Stored Procedures, and Universal PBG and PBR
- Experience with all Db2 utilities including Image Copy, Reorg, Recovery, Run stats, Unload/Load, etc.
- Can perform recovery to Image Copy or RBA
- Able to provide performance tuning by analyzing Database and O/S performance using Explain, articulate the benefits, and implement the solution.
DB2 DBA
Pyramid Consulting, Inc -
Fernandina Beach, FL
DB2 DBA
Turing IT Labs -
Waukegan, IL
DB2 DBA
eTeam -
Gladstone, NJ