What are the responsibilities and job description for the DB2 Database Administrator position at Boscov's?
DB2 Database Administrator
Job Summary : As part of a fast-paced, dynamic Information Technology team, you will support various database while collaborating closely with Network, Server and Application Development teams.
Essential Job Duties and Responsibilities :
Provide DB2 Mainframe z / OS database administration for all environments
Introduction of new functionality of DB2 on z / OS
Application support for changes and problems
Production data updates
Table definitions, design, and modifications
Design / development of Triggers and Stored Procedures
Configure and customize DB2 Tools (Admin Tool, Query Monitor, QMF)
Monitoring of DB2 performance IBM tools and DB2 LUW
DB2 connectivity direct data drivers, remote system connectivity
DB2 Federated Database on AIX
DB2 LUW on AIX
SQL tuning
Business Recovery
Support for SMARTIS
DB2 Bufferpool tuning
Manage zParms
Acceptance environment refresh with Production Data
PCI Interviews
Participate in on-call support rotation
Ensure compliance to all relative security policies and procedures.
Knowledge, Skills, and Abilities :
Advanced proficiency in Structured Query Language (SQL).
In-depth knowledge of database technologies, architecture, and data security.
Knowledge of best practices in database management.
Advanced analytical, leadership, and problem-solving skills.
Exceptional organizational skills and attention to detail.
Excellent interpersonal and communication skills.
2-3 years’ experience with database administration.
Knowledge of DB2 z / OS, DB2 LUW, SQL Server, Oracle, REXX scripting a plus.
Education and Experience :
- Bachelor's degree in management information systems (MIS), computer science, information systems, or information technology or equivalent education
Benefits
At Boscov’s, we value our employees, and that’s why we provide a competitive compensation and benefits package. As a member of our team, you will be eligible to receive :
Competitive starting rate
Weekly Pay
Comprehensive benefits package, including medical / dental / vision
Paid Vacations and Personal days
Liberal Employee Discounts
401k with employee match
Much More!
Work where people love to shop!
Equal Opportunity Employer
