• Manage day to day health of DB2 LUW platform with 200 TB of data.
• Work with software vendors and Infrastructure team to continue to improve availability, performance, DR and Data protection.
• Support Operations team for Tier3 support escalations.
• Design, analysis and creation of new databases (analysis about number of database partitions, available memory, database size, database & database manager configuration options).
• Database object creation & alteration (tables, indexes, views, stored procedures, functions etc.).
• Implement Database security model -Database performance tuning and troubleshooting & fixing problems faced by application developer.
• Exploring the use of Multi Dimensional Clustering (MDC) & Materialized Query table to enhance the system performance if required.
• Developing tools using shell/AWK scripts to automate various database administration jobs.
• Performing database security review (for the databases created & maintained by other DBA).
• 6+ years of support experience with DB2 DPF in a large Enterprise Data Warehouse environment (100 + TB) preferably in v9.5 and 9.7 with performance tuning and work load management tool (WLM)experience.
• 2 + yrs of experience in managing DB2 tools like WLM, TSM , HPU and TSA.
• Strong hands-on Unix experience 2+ yrs of experience in managing backup, recovery and DR.
Hiring Manager is available to interview ASAP.
If you are interested with the Opportunity please reach me 425-285-5502
Job details are sourced from the employer's original posting.
Open job postingAbout the company
We provide cost-effective, high quality IT resources to meet talent needs through Staff Augmentation, Global Talent Management, Value Added Services through CLASS (Competency Leveraged Advanced Staffing & Solutions) Permanent Placement Services and Vendor Management Programs. Collabera has been a leader in IT staffing for over 24 years and is one of the largest diversity IT staffing firms in the industry. We are known for our high-touch, customer-centric approach, offering our clients unmatched quality, responsiveness and flexibility. We are appreciated by our clients for our streamlined execution, highly efficient service and exceptional talent management that go above and beyond traditional staffing services. Collabera has been named the Best Staffing Firm to Work For in the large firm category by Staffing Industry Analysts, the global advisor on contingent work, for four consecutive years.