What are the responsibilities and job description for the DB2 Database Administrator position at Boscov's Department Store, LLC?
DB2 Database Administrator
Job Summary: As part of a fast-paced, dynamic Information Technology team, you will support various databases 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
