210794 / DB2 Database Administrator
At a glance
Mid-level Data Architecture & Governance role at Procom Services. Durham · no salary stated · we estimate $97,988–$155,000 across the United States.
Procom Services has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build, upgrade and improve DB2 databases across AIX and z/OS environments
- Keep DB2 databases running well, then help application teams tune performance and vendor builds
- Turn logical designs into physical data models with business analysts and application developers
- Plan backup and recovery, set data integrity controls, and document database practices
- Track database capacity and forecast future needs
What you bring
- A bachelor’s degree or equivalent demonstrated capability
- Hands-on administration and tuning of DB2 on both z/OS and AIX
- Two to three years of DB2 DBA work across z/OS and AIX, within five to seven years in IT
- Application development experience totaling two years
Who this fits
This suits a mid-level DBA who can work across DB2 on AIX and z/OS and collaborate with application teams. The role is onsite in Durham. Candidates on H1B visas and third-party represented candidates are not eligible.
From the employer
Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.
With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.
Procom’s areas of staffing expertise include:
• Application Development
• Project Management
• Quality Assurance
• Business/Systems Analysis
• Datawarehouse & Business Intelligence
• Infrastructure & Network Services
• Risk Management & Compliance
• Business Continuity & Disaster Recovery
• Security & Privacy
Specialties• Contract Staffing (Staff Augmentation)
• Permanent Placement (Staff Augmentation)
• ICAP (Contractor Payroll)
• Flextrack (Vendor Management System)
DB2 Database Administrator to implement and administer databases within a multi-tiered environment. The DBA will play a critical role in design, build, implementation, upgrade and optimization of DB2 databases in an AIX and z/OS environment. The Database Administrator will support DB2. Monitor/maintain/upgrade the DB2 database and assist the application team with performance tuning initiatives , and builds from the application vendor. Interface with business analysts and application developers to create and maintain physical data models based on the logical design. Monitor and tune databases to ensure peak performance. Design/implement backup and recovery solutions. Provide assistance to associates to resolve technical issues, document and implement best practices for the database environments. Establish standards, controls and procedures to ensure data integrity and security. Perform capacity planning and projection for future growth
- Bachelor’s degree or demonstrated equivalent competency
- Proficient in administering and tuning DB2 databases in a z/OS environment
- Proficient in administering and tuning DB2 on AIX environment, experience with administering/tuning multi-partition databases preferred
- Experience with OEM and other database tools (Toad, Foglight) preferred
- Significant experience with database backup/recovery strategies
- Technical expertise on current AIX and z/OS operating systems preferred
- Experience with DBA productivity tools preferred
- Effective verbal and written communication skills
- 5-7 years of Information Technology experience consisting of 2 years of application development experience
- 2-3 years DBA experience in DB2 on z/OS and AIX platforms
- Hands on experience with database performance tools (Toad, BMC etc.,)
- IBM DB2 Certification preferred or willing to obtain
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.