Summary

• Result oriented, analytical and self-driven IT professional seasoned with 16 years proven working experience in various roles as Lead Database Architect, Solution Architect, Lead Engineer and Database Operations Manager with exceptional Technical skills.
• Extensive work experience in handling mission critical Production 24x7 and Non-Prod/SDLC databases - Oracle RAC, Non-RAC of versions 12C, 11gR2, 11gR1,10gR2, 10gR1 and 9i running on Exadata platform, Linux, AIX operating systems.
• In depth knowledge and experience in Database Architecting, Solution design, Engineering, Planning and advised on database strategies.
• Working knowledge of MySQL, MS SQL Database Administration. Now working with new techs such as Big Data, NoSQL, Engineered Systems and Cloud.
• Consistently recognized for outstanding contributions to the bottom line and solid reputation for resolving complex issues. Commended for organization, perseverance, efficiency, and priority management skills.
• Highly committed, Result oriented, Competitive technical SME cum DBA Manager with Innovative and strong interpersonal skills. Looking forward to grow with a challenging opportunity.
• Capable to manage/maintain Very large and mission critical Production Databases 24x7 and Development Application Support in Complex Environments.
• Expert in handling ORALCE RAC and NON - RAC 12C, 11gR2, 11gR1, 10gR2, 10gR1 and 9i databases on Unix environment Solaris, HP-Unix and Linux .
• Very good in Database Architecting, Solution Designing, Capacity Planning, Database Design, Database Cross Platform migrations, Database Storage Migration and implementation solutions for new business and applications requirements.
• Expert in Designing and implementing High availability Solutions RAC, Dataguard, Replication for Applications in Development and Production environments.
• Have exceptional technical skills in Oracle RAC and NON-RAC 11gR2, 11gR1, 10gR2, 10gR1 implementation, configuration, Upgrades/Migration, Patching, ASM, Replication-Streams, Goldengate, RAC Database Troubleshooting, OEM Grid Management, Active Data Guard Physical Standby , General Database administration, RMAN, Backup Recovery, Performance Tuning and Unix Shell Scripting.
• Have exceptional skills in implementing Best Practices and future proof solutions as per need of applications running on various databases.
• Proven ability to manage and maintain very large databases and ensure near to 100 availability in mission critical production 24x7 environments.
• Have very strong troubleshooting skills, can provide quick resolutions to meet SLAs, identifying Root Cause and provide future proof solutions, automating database monitoring and proactive monitoring of databases in production environment.
• Technical Skills
• Operating Systems - SUNW, Ultra-Enterprise Sparc Solaris 9, Solaris 10, SUNW, Ultra4 Sparc Solaris 8, SUNW, Ultra-Enterprise Sparc Solaris 8, SUNW, Sun-Fire-480R Sparc Solaris 9, Red Hat Linux 2.1AS x86 , Linux 3.1 Advance Server, Linux Advance Server 4, HP-Unix, Windows 2000, Windows NT 4.0, Win 98, Win 95, MS DOS
• Database Versions - Oracle 12C, 11gR2, 11gR1, 10gR2, 10gR1 and Oracle 9i
• Tools/Utilities OEM12C Grid, ASMCA, DBUA, AWR, ADDM, DBASSIST, DBCA, NETCA, EXPDB, IMPDP, SQLT, STATSPACK, TKPROOF, UTLBSTAT, UTLESTAT, EXPLAIN PLAN, DBMS STAT and other DBMS packages useful for DB administration/manitenance, RMAN, RDA, TOAD, SQL Developer, SQL Plus, SQL Net, Net8, SQL Loader, Import/Export, DATAPUMP, PLSQL, Stored Procedures, Triggers, etc.
• Other tools for remote administration Xming, Exceed, VNC, RDC, X-Manager, Telnet, Putty, WebEx, GotoMeeting, Net meeting, Pcanywhere, Windows Live Meeting.

Professional Experience

Confidential

Lead Engineer /Database Manager

Responsibilities:

• Managed 100 enterprise-level Oracle 12c, 11g, 10g database systems, achieving the goal of 99.99 availability at acceptable level of performance.
• Lead and run multiple Oracle Database Engineering Projects efficiently and drive them to achieve best results along with expected benefits. Capture metrics that can be used to measure the outcome of each project, create and publish dashboard for Senior management reviews.
• Migrated nearly 100 Databases 10gR2, 11gR2 from AIX to Linux -Exadata Platform that includes PROD and NON-PROD databases being used for critical online banking application using best possible migration methods and ensured defect less migration results. Also, migrated nearly 200 Databases from Hitachi to EMC SAN Storage using Open Replicator and ASM rebalance methods.
• Innovatively, developed a tool using OEM12c metric data / AWR warehouse, which can be used to quickly generate - Database health check reports, Capacity treand analysis, resource utilization reports, proactively predict database performance issues, identify top worst performing databases, various executive reports and much more.
• Architect and designed solution for a Active-Active banking application that requires High Availability , Load Balance and Fault Tolerance.
• Converted 200 databases from NON-ASM to ASM 12C GI standalone, 2-node RAC, 3-node RAC with less downtime using online hot migration methods.
• Engineering, Planning , Estimating- Infrastructure Cost, Effort, Labor Cost and work with various Groups for budget allocation and run the projects by taking end to end responsibility.
• Implemented Automation of several manual database operations and monitoring work and released DBA effort.
• Redefined and enabled the processes - Backacup management, Incident management , RCA, RCCA and DB Governance process for more accurate information and effective use of various teams.
• Standardization, Best practices, Architect Design cost effective solutions, Create Plan and procedures, Documentation, Metrics and Dashboards, RCA RCCA, Incident Problem management, Risk Management, enforce team to use standard documents/procedures, Manage Database projects.
• Manage team of DBA's on-site and off-site spread across the globe. Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.
• Developed and maintained solid professional relationships with Application teams and other Infrastructure teams with my strong interpersonal skills.

Confidential

Database Senior Architect/Sr. Database Manager

Responsibilities:

• Responsible for Operations 24 7 production supporting databases around 150 ORACLE 11gR2, 11gR1 and 10g and 80 MS-SQL 2008, 2005 running on Solaris, Linux and Windows operating system being used for critical commercial applications.
• Providing hands-on L3-L4 level DBA support for all database environments and also providing weekend and on-call support for business critical production issues.
• Played Database Architect role and Planned, Designed and successfully implemented 3 node multiple Oracle RAC 11g2R2 setups for PRODUTION, STAGING, QA, INT, DEV and TRAINING environments for a new commercial application.
• Successfully migrated Oracle 10.2.0.5 standalone database from Solaris operating system to Oracle 11gR2 3-Node RAC database on Linux Operating system.
• Implemented 11gR2 Active Dataguard 2-Node RAC for the type of ACTIVE PASSIVE application support, High Availability, Disaster Recovery, and Reporting purpose.
• Implemented Golden Gate Replication for ACTIVE-PASSIVE and ACTIVE-ACTIVE.
• Implemented oracle 11g OEM grid for databases monitoring.
• Designed and implemented DR systems, Enabled and implemented the process for BCP Business continuity Plan test every quarter.
• Solution designed and implemented Oracle Bi-Directional streams as to replicate data from Core Databases to its multiple Edge nodes.
• Stabilized Database environment issues by enabling standard database procedures practices, automating database monitoring and proactive monitoring. With this changes I was able to control the database downtime and achieved 100 availability.
• Designed and implemented backup strategy used RMAN backups/recoveries, datapump expdp/impdp according to business requirement.
• Implemented Best Practices in all possible areas of RAC / Non-RAC Databases to improve performance and achieve targets.
• Helped Developers in designing and developing code with Oracle Scripts, and provided DBA support in implementing and deploying Applications for their releases.
• Establish and maintain strong, effective working relationships with Application Team, Designing Team, Clients and Coworkers.
• Providing weekend and on-call support for Production Oracle database environments. Work and troubleshoot issues, problem identification, RCA RCCA, reporting, tracking, analysis, and resolution and documenting the solution.
• Research and analyze all assigned anomalies to determine root cause produce, review, track and log all findings and recommendations.
• Monitor database performance and space utilization investigate and resolve reported issues as well as recommend upgrades / updates.
• Research, analyze, and recommend patches, tools, and/or database upgrades to resolve issues and add features/functionality.

Confidential

Database Production Support

Responsibilities:

• Managed multiple large scale ORACLE / MS SQL / MYSQL DBA projects and successfully deliver on high profile/priority projects
• Coordinate and drive cross functional project teams, schedule, install, test and deliver contracted products within scheduled timeline and with a high degree of quality and customer satisfaction
• Establish and maintain strong, effective working relationships with clients and coworkers
• Lead/participate in meetings with customers and internal project resources
• Provide continuous feedback on project status and offer constructive options to ensure project continues to meet original expectations
• Provide work coordination and management for teams of DBAs, including project lead, project management, task assignment and coordination, and status reporting
• Provide support for all ORACLE database environments to include problem identification, reporting, tracking, analysis, and resolution.
• Research and analyze all assigned anomalies to determine root cause produce, review, track and log all findings and recommendations.
• Participate in production on-call rotation one week at a time of 7x24 on-call support for production environments .
• Monitor database performance and space utilization investigate and resolve reported issues as well as recommend upgrades / updates.
• Architect and oversee database backups and DRP sites.
• Architect/Plan for database migrations/upgrades/new db setups for new business etc
• Architect and oversee data replication as required for each application.
• Assist project teams in setting up and testing development, test, and production environments.
• Research, analyze, and recommend ORACLE Patches, tools, and/or database upgrades to resolve issues and add features/functionality.
• Provide technical leadership to the DBA team by assisting junior team members and sharing knowledge and research of tools/techniques, and Oracle features.
• Serve as team liaison to project managers for database administration and SAs

Confidential

Database Architect- ITIS

Responsibilities:

• Currently providing offshore support to client's mission critical 24x7 production cluster and non cluster databases 200 databases
• Responsible for mission critical production databases Oracles 10g, 9i, and 8i running on different OS Solaris, HP-Unix, Linux, NT to ensure high availability.
• Handling and Managing Multiple DBA projects for various accounts.
• Installed/Configured 2-Node/3-Node RAC on Linux/Solaris
• Converted Non-RAC database to RAC on HP-Unix/Linux
• Converted RAC database to Standalone database on Solaris
• Upgraded RAC database from version 10.2.0.1 to 10.2.0.4
• Migrated RAC database from ASM to Non-ASM using rconfig/DBCA
• Configured High availability/Load Balancing features TAF/FAN in RAC database.
• Upgraded nearly 150 production databases from 9i to 10gR1 and10gR2.
• Have good experience in handling Cluster RAC and non-Cluster databases running on Unix Environment.
• Installed and Configured Oracle 10gR2 databases for new applications.,
• Installed and configured OWB, Workflow Manager, HTTP Server, Grid Management Agent etc.
• Good in setting up oracle advanced features like 10G Streams, ASM for RAC, Database Upgrades, and Applying CPU Jan2008 for production databases.
• Migrated Non ASM database RAC/Non RAC to ASM using RMAN
• Converted 2 Node RAC database into Single Node non Cluster Database.
• Configured Bi-directional Oracle Streams between databases in order to replicate data.
• RMAN Scripting, Backup Configuration and Scheduling backups using Crontab. Reviewed and corrected the existing RMAN scripts in order to ensure reliable backup.
• Converted few production Databases character set to UTF8 to support multi lingual applications without any data loss and data truncations'
• Troubleshooting issues, Providing quick resolutions and proactive measures to ensure zero business loss during production hours.
• Streamlined the existing monitoring methods.
• Manually process of Monitoring databases has been automated by writing shell scripts to avoid mistakes and speed up the monitoring process.
• Good in Handling Large databases 1 TB to 2 TB Oracle databases On Unix Environment.
• Responsible for Change Management, Incident Management, Problem Management, Security Management, Backup Management etc.
• Responsible for RCA, RCCA, Dash Board preparations and Publishing the reports.
• Working with Oracle Support in case of any emergency help required to fix the issue by raising Service Requests SRs
• Documenting the issues/resolutions/process details and maintaining the documents up to date.
• Providing high level Technical Support and on call support to the Team.
• Providing High Level Technical support by closely work with team members in order to give quick resolutions on production issues and in time deliverables.
• Handling Large databases 1 TB to 2 TB Oracle databases
• Providing activity plans to the Team / Preparing and publishing technical docs for future reference.
• Responsible for Team Management, Resource Handling, Resource Management, Raising Invoice /Billing etc.
• Confidential
• Production Support Sr. DBA Consultant / Team Lead- Projects
• Responsibilities:
• Providing Oracle DBA 24X7 support for multiple large critical cluster and non-cluster production databases in production environment, also supporting development and test databases of different versions on different platforms.
• Installed oracle 10gR1, 10gR2, Multiple oracle homes and configured databases on Solaris/Linux.
• Non-ASM 10g R1 Production database Migrated to ASM Automatic Storage Management
• Upgraded databases from 10gR1 to 10gR2. Also upgraded databases from oracle 9i to 10g.
• Configured Physical Standby databases for RAC production database.
• Migrated databases running on 10R1 from Solaris 8 to Solaris 10.
• Database refresh for development / test using production database, Standby database.
• Configured BI-DIRECTIONAL STREAMS between two production databases in order to exchange live data between schemas and tables.
• Identified Block corruptions, and repaired block corruptions using DBVERIFY, DBREPAIR, and RMAN on Standby database, Development database.
• Database Refresh including READ ONLY TABLESPCE for development/test database using standby database, production database.
• Data Transport schema level, tablespace level etc using EXPDP, IMPDP.
• Online Tablespace space migration to reclamation space using dbms redefinition.
• Installed and Configured AWR Automatic Workload Repository on 2 node RAC instances.
• Given quick resolution for production database issues like ORA-600, ORA-7445, hard disk failures etc without effecting business loss.
• Identified and provided recommendations on the different performance problems ranging from Database performance problems to I/O hardware performance problems.
• Developed Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking database status, listener is running, database locks, alert log error messages, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.
• RMAN backups and recoveries using RMAN backup. RMAN Scripting.
• Excluding Read-Only tablesapces from the RMAN backup to reduce the backup size/ time.
• Database Cloning
• Setting up a Standby database using RMAN backup.
• Configured Production database and Standby database for Switch Over, Switch Back and Failover.
• Worked on several database recovery scenarios and recovered data without data loss and without any business loss with simplified recovery methods.
• Configured 10g OEM for Grid Management, Atomized jobs and scripts for maintaining/monitoring production RAC instances.
• Responsible for Incident Management, Problem Management, Change Management, Backup Management, Team Management, Resource Management to ensure quality and timely deliverables.

Confidential

Production Support Sr.DBA DB IT Ops

Responsibilities:

• Worked as an Assistant Manager for Team Management/ Provide 24x7 On-call DBA Technical Support to ensure High Availability of the Systems.
• Installation and Configuration of Oracle 9i,8i server and creation of databases for GE Business Applications and for their customers like Nissan Europe, Nissan Hungary, GSK etc.
• Database Upgrades and Migration.
• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution.
• SQL statement Tuning using SQL TRACE / TKPROF, explain Plan and Auto Trace.
• Fixing performance problems gaining good percentage increase in application performance using StatsPack, Utlbstat, Utlestat, TOAD, SQL-PLAN, DB tools etc.
• Database server tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
• Performance tuning of database overall Performance gain which includes optimization of UNIX Kernel, Oracle INIT.ORA, Oracle SGA, I/O balancing and memory.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Maintained good Backup and Recovery strategy and implementation. And Scripting of Hot and Cold backup
• Developed and modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented ARCHIVELOG process and procedures for automatic copying files to development server as they generated.
• Implementing and Maintaining Standby Database with oracle 9i.
• Tools used include Import/Export, SQL DBA, Monitor SQL Loader, SQL Plus, SQL Net and Unix operating system procedures.
• Implemented nightly cron jobs to print DBA reports using SQL and PL SQL scripts and UNIX shell scripting.
• Ensure databases adhere to corporate standards and policies including database auditing.
• Provided 24x7 on call production support.

Owned different process like Incident Management, Problem Management, Change Management.

Responsible for providing/publishing Weekend Activity Plan , Action Plan on Several Database Issues.

Prepared and published many SOPs/Documents on various activities like oracle installation on solaris/linux, Stand by db setup, etc. for their reference