CAREER OBJECTIVE AND GOAL:

To contribute the maximum by learning from professional & personal inputs for organizational growth and value addition. To deal with technical challenges in an organization appreciating and crediting innovative ideas, to strengthen own skills and have the pleasure of solving complicated technology issues in the corporate environment. Can demonstrate the high levels of motivation required to meet the tightest of deadlines. Even under significant pressure, possess a strong ability to perform effectively.

SUMMARY:

• Results - oriented professional with successful track record of 11 years in all aspects of Oracle and Sql Server Database Administration. Areas of specialization include: database administration, database design and planning of backup and recovery strategies, database migration strategies, database upgrade strategies, standby and disaster recovery solutions. Strong knowledge on database performance tuning, logical backups, cold and hot backup and restoration procedures. Currently working with Confidential Technology Solutions as a Database Infra Architect.
• Expertise in installation, configuration, administration of 10g, 11g, 12c, 10g RAC, 11g RAC database in Unix/ Red Hat Enterprise Linux and Windows .
• Extensive experience in Microsoft Sql server database design, development, and administration with MS SQL Server versions 2017/2016/2012/2008 R2/2008/2005.
• Successfully completed multiple big Data Center Migration for different clients.
• Expert knowledge on Database version u pgrade, migration, Patch deployment, rman and Shareplex tool using latest Oracle tools like oracle migration utility, OEM Grid control.
• Extensively worked on physical standby database on different versions 10/11g/12c DATAGUARD with Data Guard Broker configuration.
• Strong hands on experience of Real Application Cluster environment (RAC) on ASM.
• Expertise in using oracle Export/import, Datapump utility to migrate data across schemas
• Strong knowledge of Oracle internals, tools including DBMS jobs, RMAN, SQLPlus, export/import, Toad, Oracle Enterprise Manager (OEM11g/12c)
• Proven experience in implementing, configuring and managing Data Guard with Physical Standby Databases for High availability configuration and Active Data Guard.
• Expertise in applying security patches (CPU and PSU) to the databases.
• Expertise in Oracle database backup & recovery solutions using RMAN.
• Expertise in disaster recovery solution using data guard failover and switchover.
• Expertise in Database sizing, Capacity Planning.
• Cloning the databases using RMAN and EMC Clairton and hot/cold backups for development, uat, reporting environments.
• Expertise of migrating database cross platform and different technologies which includes Oracle to Sql Server and Oracle to Postgress technologies.
• Worked with both onshore and offshore model and coordinated onshore issues with offshore team
• Expertise of administration of replication tool Shareplex
• Proven experience database resizing & de-fragmentation activities
• Strong Query optimization and tuning skills including cross database and cross server queries, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage. Experience in creating database tables, setting up indexes, data constraints and database views and SQL queries.
• Strong Experience of working on Oracle Cloud and Golden gate technologies.
• Strong in Disaster Recovery (DR) planning and testing & Maintenance, RAC familiarity and configuration, Standby database
• Proficient Knowledge of Unix/Linux system administration, Shell Scripting
• Ensure operational efficiency of Database environment meets expected service levels.
• Provide assistance and support to the application development teams on Oracle best practices
• Producing and updating documentation and Standard Operating Procedures (SOPs).
• Excellent written, communication, presentation and interpersonal skills.
• A very good team player with the ability to work independently.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Senior Oracle Database Administrator

Responsibilities:

• Providing technical support to databases which include Oracle 10g,11g and 12c and Sql server Databases
• Involved in Database Installation, Creation
• Database migration from Oracle to Sql Server.
• Day to Day Monitoring and proactive maintenance.
• Implementation of Always on and Log Shipping
• Implementation of Standby database using Data Guard
• Upgrade of database across different versions
• Fixing the daily backup issues in export, RMAN. Sql databases
• Installation, configuration and administration of ORACLE Database Vault
• Data refresh across the Different environments
• Co-ordination with System, Storage team for Disk Increase and Patching activities
• Proactively monitoring the database's health and taking preventive or corrective action as required
• Monitoring and tuning performance
• Provided the On call support for the client
• Interface with Oracle Corporation, Microsoft for technical support
• Worked on active Data Guard with broker configuration
• Handling Day to Day performance Issues
• Database Manager strong analytical, problem solving & organizational abilities

Environment: Oracle 10g/11g/12c, Data Guard, RMAN, Data pump, PL/SQL Developer, Sun Solaris, Red Hat 6, Sql Server 2005/2008/2012/2014/2016/2017.

Confidential, Austin Texas

Senior Oracle Database Administrator

Responsibilities:

• Closely working with Business stakeholders and provide consultative and technical support services for all major database development and system integration tasks including test strategy, version upgrade, migration, space management, implementation of backup and recovery strategy.
• Database administration of Oracle 10g/11g/12c databases in a UNIX, Linux and Windows environment
• Closely working with Application team for production deployments.
• Installation, configuration and administration of ORACLE Database Vault
• Analyze and provide workaround for any oracle BUG or code change in Oracle
• Performance analysis on Oracle databases
• Implemented DATAGUARD (Physical Standby) for high availability/disaster recovery purpose
• Proactively monitoring the database's health and taking preventive or corrective action as required
• Monitoring and tuning performance
• Performed Mass deployment of OEM agents (12c) on different hosts and registered the databases on those hosts to the OEM (12c) for monitoring.
• Performing upgrades of the database and software to new release levels
• Uses change management processes to prevent production disruptions and outages.
• Database cloning from RMAN active database.

Environment: Oracle 10g/11g/12c, Data Guard, RMAN, Data pump, PL/SQL Developer, Sun Solaris, Red Hat 6, OEM.

Confidential, Marlborough MA

Oracle Database Administrator

Responsibilities:

• Providing technical support to 200+ databases which include Oracle 9i,10g,11g databases
• Migration of the Oracle database across various Platforms using Datapump, Transportable table space
• Installation of Oracle database according to business requirements
• Creating the application Users and providing the required Roles, Profiles and Quotes based on the business requirement.
• Proactive monitoring of Tablespace and Disk space
• Monitoring the Standby database for sync with primary database
• Upgrade of Oracle database across different versions
• Fixing the daily backup issues in export, RMAN
• Data refresh across the Different environments using Data Pump
• Performed Schema and database restore based on the Business requirement
• Decommission of the Oracle databases based on the business requirement
• Co-ordination with Unix, Storage team for Disk Increase and Patching activities
• Regular meeting with Customers on Service Improvement and discussion about the Severity incidents on weekly basis.
• Provided the On call support for the client
• Interface with Oracle Corporation for technical support
• Worked on Single Node Cluster ware
• Worked on active Data Guard with broker configuration
• Worked on several Automation theme
• Worked on database upgrade/migration/.
• Handling Day to Day performance Issues
• Technical Lead with strong analytical, problem solving & organizational abilities
• Mentoring Junior DBA's for Oracle latest technologies by providing continuous training.
• 24/7 support for Oracle databases

Environment: Oracle 9i/10gR2/11g, shareplex, Data Guard, RMAN, Data pump, shareplex, foglight, putty, toad, pl/sql developer, Sun Solaris, statspack, Windows 2000/2003.