Job Description
Role Purpose
The purpose of this role is to provide significant technical expertise in architecture planning and design of the concerned tower (platform, database, middleware, backup etc) as well as managing its day-to-day operations
͏
• Generating statistics
• Look for objects that break rules.
• Ensure that all indexes use an index table space
• Ensure that all tables have unique primary keys.
• Look for harmful growth rates
• Examine tuning opportunities.
• Look for I/O Contention
• Review fragmentation by investigating row chaining and other areas of fragmentation
• Database Objects Creation / Review
• Check for unusable indexes
• User / Schema Creation
• User Management
• Roles and Privileges Management
• Look for security policy violations
• Look in Net8 logs for errors and other issues
• Privileges & Access controls on Database
• Verify that the database archiving to tape was successful.
• Verify that the database backup was successful
• Backup execution and monitoring
• Archive all alert logs to history
• Conduct Backup , restoration drills for backup verification
• Database Connectivity issues
• Slow response
• Operations timed out
• Dead locks
• Database Hangs
• Database incident and error resolution
• Archiver Process Stuck
• Database incident and error resolution
• Vendor Management
• System Performance Monitoring
• Maintaining Environment details
• Shell Scripting for DB related work
͏
Experience: 5-8 Years .
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.