SUMMARY

• Around 14 years of experience in the IT Industry as Oracle Database Administrator.
• Currently employed with Confidential as Manager Infra Ops Specialist, which is a leading global IT services and solutions providing company.
• The company's mission is to leverage its technology partnerships on a global scale to deliver cost effective engineering solutions for the emerging network centric world.
• The company provides value - added, software engineering led IT solutions and services in the areas of e-commerce and Internet, enterprise product and management solutions to large and medium scale organizations, across the world.
• Nature of work includes Regular Database Administration Tasks, Performance tuning, Backup/Recovery, schema creation and security management. Have exposure to wide array of technologies and tools used in conjunction with Oracle, in client-server as well as web technologies.

AREAS OF EXPERTISE

• Oracle Database Administration
• Oracle databases administration
• Real application Clusters Installation and Administration
• Database Migration and Ugrade
• Cross Platform Migration
• Performance monitoring and tuning
• Backup plans and implementation
• Capacity Planning
• Oracle Enterprise Manager
• User Management
• Export/Import utility
• Database cloning
• Replication (STREAMS AND GOLDEN GATE).
• Datagaurd

TECHNICAL SKILLS

Operating Systems: AIX, UNIX, Sun Solaris, Red Hat Linux, Windows

Database Tools: Oracle Enterprise Manager, TOAD,OID,RMAN,REMEDY,HP OPENVIEW,ORACLE STREAMS

Other tools: Oracle Golden Gate, MS SQL Server,Shareplex, Autinity

PROFESSIONAL EXPERIENCE

Confidential

Technology: Oracle 11g R2, SQL Server 2000/2005/2008

Responsibilities:

• Database project planning, requirement gathering, scope of work design, hiring DBAs and KT Plan design
• Review project status and project metrics on a daily basis with the client and offshore team
• Cross platform migration of 45TB database from AIX to Linux using RMAN.
• Implementing and troubleshooting DATA GAURD (STANDBY) for high availability and disaster recovery .
• Provide L3 level support to client and team whenever needed
• Manage and resolve queries, escalations, conflicts and issues between onsite and offshore teams to ensure delivery as committed
• Implement and anchor key HR processes for the team - performance management, promotions, normalization of the team ratings and recommendations on rewards
• Managing employee satisfaction, performance management processes, employee development and retention
• Interface with the client organization to provide updates and address queries
• Ensure customer satisfaction through quick and high quality issue resolution
• Ensure regular communication with client on status review, pipeline projects
• Track the project through regular reviews and ensure that status updates are sent out to the customer
• Monitor / prepare monthly management reports to track time and effort for the projects
• Ensure project compliance with respect to audit findings
• Ensure technical / functional involvement with project team on a need basis
• Drive Knowledge Management processes across the team
• Guide the teams to diagnose the issue to understand whether the gap is of a functional nature or whether new development/upgrade is required to meet with the customer’s needs.
• Manage and motivate performance of the team through reviews, coaching and development
• Participate in recruitment initiatives
• Ensure that the training needs of the team are identified and met
• Facilitate knowledge sharing and capture within and across teams
• Documentation, Design and Implementation of High Availability Solution, Security Procedures, OSG and Checklist.

Confidential

Technology: Oracle Database 11g and Oracle Database 12c

Responsibilities:

• Database project planning, requirement gathering, scope of work design, hiring DBAs and KT Plan design
• Review project status and project metrics on a daily basis with the client and offshore team
• Responsible for Planning and Creating new Production/Dev/Test databases.
• Planning of Backups thr’ RMAN and Responsible of Recovery.
• Responsible for Refresh of Dev,UAT and Test databases and schemas using Datapump as per customer requirements.
• Create, allocate and modify database storage structures.
• Create users, roles and assigning privileges on it, granting the roles to the users, and profiles.
• Space management, sizing the database objects, monitoring file systems and tablespace growth.
• Handling user-managed backups and RMAN backups based on business requirements and as customer demand.
• Co-ordination with the Tape Backup team for regular backups of the databases.
• Refreshing the databases/schemas as per requirements.
• Responsible for the Migrations of the Databases, Making action plans for the smooth go of the Migration and supporting the same.
• Worked on 11g R2 RAC with ASM implementation on Linux.
• Successfully Upgraded the Oracle 10g databases to 11g R2.
• Co-ordinating with Application team for the execution of scripts in the releases.
• Responsible for review and execution of scripts provided by the application team for new Objects creation and Object changes in the releases.
• Co-ordinating with storage team and OS teams for space allocations at hardware level.
• Planned and working for Oracle 11g upgrades and Implementation of Oracle datagaurd for 11g.

Confidential

Technology: Oracle 11g R2, SQL Server 2000/2005/2008

Responsibilities:

• Managing backups, recovery, monitoring, and resolving infrastructure and DBMS related problems
• Perform media recovery in the event of system/database failure
• Perform database cloning using RMAN backup
• Prepare Root Cause Analysis (RCA) for Sev1 and Sev2 tickets
• Instituting Permanent Corrective Actions (PCA) for high priority tickets
• Interfaced with the Application support teams for addressing and rectifying critical performance issues
• Provide technical Knowledge transfer to the new team members
• Interacting with customers / client executives regularly and suggest improvement plans for their environment
• Preparing and sharing end to end technical document for customer on their need
• Preparing database analysis reports and providing suggestion to customers to improve their database issue and performance
• Involve Oracle support to resolve major Oracle Bugs / RAC issues
• Handling management level technical escalations & providing solutions

Confidential

Responsibilities:

• Involved in J&J standards meetings for checklists preparation for oracle installations
• STREAMS IMPLEMENTATION
• Golden Gate Implementation
• Project requirement participation
• Participating in Knowledge Transfer activities
• Regular Database Administration
• Providing task to L1 and L2
• OID Management
• Performing Disaster Recovery test
• Backup and Recovery
• Performance Tuning
• Space Management
• DG Management