IBM DB2 UDB Database Administrator
Right To Hire
Roseland New Jersey
Scope of Work
Design, create, and maintain DB2 database schema
Maintain (Create, Alter, Drop, Reorg, Backup, Load, Build and Migrate) Objects (Databases, Tablespaces, Tables, Views and Indexes) on all Sub Systems (Dev, QA)
Ensured business continuity by performing data maintenance, backup planning and recovery of table spaces and indexes, data reorganization and updating DB statistics.
Load and refresh Non-Production databases with production database for application testing
Batch Performance issue debugging and resolution for resource unavailability, database deadlock, LPAR level and other environment issues
Extensively worked with DB2 Explain, Copy, Quiesce, recovery, Runstats, Bind check, REORG and other ONLINE and Offline utilities.
Create and maintain plans and packages. Grant and Revoke Authority to users.
Use triggers to populate an archive table on deletion of the original table row.
Assist developers in database and application tuning for optimal performance, Audited application SQL code with DB2 Explain prior to production implementation.
Used DB2 Admin utilities as well as other IBM DB2 utilities to load, make image copies and other related DBA tasks.
Be able to troubleshoot locks in environment and remove the connection holding the lock.
Development DBA/Modeler/ETL Specialist with additional skills in federation, MQTs, Linux, Autosys, Cyberfusion, Dev Ops
DB2 UDB 10.5, Strong analytical & mathematical skills, written & spoken communication skills; stored procedure development in UDB; LINUX/UNIX Korn Shell scripting, Autosys job management.
Nice to have
Prior use/knowledge of CyberFusion, Bitbucket, Autosys R11, Jenkins DevOps Pipeline
Please submit your resume for consideration. Once submitted, feel **** for additional information.
Approx. Duration: TBD
About Hired By Matrix
**MEMBERS ONLY**SIGN UP NOW***. founded in 1986, is a certified Woman-Owned Business Enterprise (WBE) dedicated to providing the highest quality of job opportunities to our candidates and staffing services to our clients. We are a full service staffing firm with experience recruiting and delivering for IT, Accounting & Finance, Administrative & Clerical, Clinical & Scientific, and Marketing disciplines. Our long history in the staffing industry and dedication to excellence are the key differentiators that have fueled our success for over 30 years.
Hired by Matrix offers our contract professionals competitive salaries, benefits after 60 days and a 401k option after one year.
Equal Opportunity Employer
*CEO Sharon Olzerowicz serves on the WBENC Board and is a long-standing member of the Forum Governing Group.
We work hard to match our candidates with the right career opportunities. Let us find you a #MatrixMatch
so you can reach your career goals!
Connect with us on LinkedIn and see how we can impact your career!
Hired by Matrix Career Center: ****