Requirement: Senior DB2 DBA:(Z/OS)
Job Location: Bangalore
Exp: 3-13years
Job Description:
-Schema Design Review, Physical Tablespace Layout
-DB2 Server Installation, Database Creation, Alteration, and Setup
-DB2 Server Database File Management
-DB2 Server Storage Segment Administration Including Table, Index, LOB, Rollback, and Temporary Segments
-DB2 Server Memory Segment Administration Including Library Cache, Data Dictionary Cache, Buffer Cache, Redo Log Buffer, and Java Pool
-DB2 Server Network Connectivity Management
-Database User Administration Including User Creation, Quota Assignment, Object-level Privilege Administration, Security Management, and Role Creation
-Database Backup and Recovery Implementation and Management Including Instance Failover to Standby Server, Dataset Propagation, Incremental Backups, Full Backups, Point-in-time/Point-of-failure Recovery, Logical Backups, Logical Recovery
-Logical to Physical Data Model Conversion
-Dimensional and Normalized Architecture Review
-Table Partitioning Scheme Generation and Implementation Including Range, Hash, and Composite
-Parallel Query Tuning, Parallel Server Tuning
-Database Block Optimization
-Extent Fragmentation Management and Elimination
-IO Tuning Including Bottleneck and Resource Contention Minimization
-Query Execution Plan Optimization
-Indexing Strategy Review, Design, and Implementation
-Tuning DB2 Server Memory Segment Allocation and Usage Including SGA, PGA, and UGA
-Database Upgrade Implementation, Database Security Auditing
-Database Reorganization Including Tables, Indexes, Clusters, Hash Clusters, & Index Organized Tables
-Standby Server Implementation
-Instance Failover Automation
-Advance Replication Implementation and Management Including Master/Slave and Multi-master Environments
-Instance Load-balancing
-Development of Customized Scripts for Performing Automated Maintenance, System Failover, Database Backup, and Database Recovery
-Exp in AIX is a plus
Eligibility: Any graduate
Company Name: IP Soft India Pvt Ltd
Company Profile: IPsoft is a global, industry-leading managed services company offering a complete solution to enterprise customers for outsourcing global IT operations. We offer a full range of managed services to our clients, from management at the individual component, device and network level to the analysis, design and management of complex business processes.
IPsoft’s unique (and proprietary) automation technology remediates more than half of the detected exceptions in our managed client environments. We manage our customers’ systems through our worldwide Network Operations Centers located in New York City (HQ), London, Amsterdam and Bangalore.
IPsoft has been solidly profitable since its inception as a company in 1998, and has roughly doubled its gross revenues for four straight years; we are on a trajectory to continue this rapid growth pace, meaning that you will have an opportunity to grow with the company.
Contact: Uday.Bhaskar
Send your resume to ubhaskar@ipsoft.com
Website: www.ipsoft.com
