Job Description :
Client: State of North Carolina
Job Title: DB2 Database Administrator
Duration: 6 Months
Start Date: 11/05/2018
Location: 501 N Wilmington Street, Raleigh, NC 27604
Position Type: Contract
Interview Type: Either Webcam Interview or In Person
Requirement ID: SNC_DB2416_BR


State of North Carolina - Department of Revenue (NCDOR)

The position will support legacy mainframe databases and new database installations. The position will work with a team of DBAs that will provide support to tax system databases that contain both federal and state tax information. The selected candidate will serve as primary database support for DB2 on Z Series Mainframe in a production environment. This includes Table Reorgs, Indexing, Table Partitioning, Performance Tuning, Automation and Scheduling of tasks in Zeke with extensive use of JCL, Easytrieve and REXX.

Description (including, but not limited to):
Data analysis and database management
Maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning
(Logical) Administration of application objects within database; maintenance of business requirements for database, database schema, data maps, ERDs, application objects (i.e., tables, indexes, views, etc; performance of database application tuning; provision of business and data requirements and data for capacity planning
(Physical) Environment-level administration; installation/patch/upgrade of database software; management of HA, database-level security; maintenance of database configuration files and data files; completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery; performance of capacity planning driven by technology and resource usage trends

Required/ Desired Skills:
Mastery of DR best practices and ABARS as well as other complex administration task of high transaction volume tax application
Ability to perform Regular Storage Management and Administration of large databases on MainFrame DASD
Assist programmers in diagnosing/ troubleshooting code and queries
Provide Performance Tuning on the DB2 Z databases
Provide Database Administration on DB2 os390 v11
Strong demonstrated administration skills of IBM DB2 on ZOS
Experience with CA Database tool
Demonstrated ability to work with DB2 on the Mainframe
Administration of CICS
File manipulation: FTP, ConnectDirect, File-AID/RDX, VSAM, RACF, IMS
Programming languages; REXX, Easytrieve, Cobol, JCL; ISPF (CLIST, PROCS, Skeletons, Panels, Messages, Tables) and Logon Procs


V Group Inc. is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR, CA, DE, FL, GA, IL, KY, MD, ME, MI, NC, NJ, NY, OH, OR, PA, SC, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.