SUMMARY:

• 8 years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams.
• Installation and administration of Oracle 12c,11g/10g/9i and R12 on OEL, RHEL, Windows, Unix and Sun Solaris.
• Installed SQL server 2012, 2014 and 2016 on windows 2012 server.
• Configured High Availability on SQL 2012, 2014 and set up the listener.
• Setting up the logshipping and mirroring on Production database in SQL 2012, 2014, 2016
• Automatic Failover by using listerner in Availability groups
• Performed Migration and Upgrade of databases to 11g and 10g
• Up gradation of databases applying patches, patch sets and critical patch updates.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC environment
• Configuration of Automatic Storage Management (ASM)
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, data pump export/import.
• Migrating the databases from one platform to another platform.
• Implementation of Flashback Technology
• Extensive experience using SQL* Loader, External Tables for data loading.
• Detecting and diagnosing production system performance problem by analysing TATSPACK reports, Oracle trace and log files, AWR, ADDM, analysing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Working experience in creating materialized views.
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS:

Databases: Oracle 12c,11g, Oracle 10g, Oracle 9i. SQL SERVER 2005, 2008R2, 2012, 2014, 2016

Oracle Products: Oracle10g (Grid Control), OEM (OracO OEM (Oracle Enterprise Manager), RMAN, SQL *Loader, Import and Export, DATA PUMP, ASM

Programming Languages: SQL, PL/SQL, C#, C, C++

Operating systems: OEL, RHEL, Sun Solaris, Windows XP Professional, Windows 2003 Professional

Other Tools: SQL SERVER 2005, 2008,2012 2014, 2016 IBM INFO SPHERE DATAMAKSING OPTIM, TOAD, Erwin, Putty, FOGLIGHT, PERFORMANCE ANALYZER (Quest)

PROFESSIONAL EXPERIENCE:

Confidential, Boston MA

Oracle/SQL DBA

Responsibilities:

• Upgrading the database from 11g to 12c in various environments.
• Configuration the database on Exadata and upgrading the database from 10g to 11g.
• Refreshing the Database from production to Non-Production using Auto Refresh Process.
• Installed and configured ASM, GRID HOME, Oracle Home using OEM
• Configured Standby database for multiple primary database to maintain High Availability.
• Setting up the users in SQL azure Environment for new applications.
• Installed and configured SQL SERVER 2008R2, 2012, 2014, 2016 on windows 2012, 2008 2003.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Adding the Witness server to existing Mirroring.
• Extensively worked on Installation and Maintenance of SQL Server 2014/2016, 2012/2008R2 on Test, Development and Production Environments
• Database Backup and restores, and periodical database refreshes
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues .
• Installed Various Service packs for SQL Server 2008 and 2005.
• Migrated SQL Server 2005/2008/2008 R2 databases to 2012,2014.
• Use log shipping for synchronization of database.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) 12c and 11g. Auto refresh process and RMAN backups in OEM 12c
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import, Auto Refresh.
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM, 12c OEM
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.

Environment: Oracle 12c, 11g,10g, 9i, ExaData, Linux, Oracle Enterprise Manager Grid Control 11g 12c, RDBMS, SQLPLUS, RAC, Oracle forms, and Reports

Confidential, Chicago IL

Oracle DBA

Responsibilities:

• Perform CORE DBA tasks such as Database Administration on Oracle 10g and 11g, 12c environments.
• Upgrade and Migration of Databases from 10g to 11g and 11g to 12C, applying patches whenever required.
• Continuous Performance monitoring and tuning of the databases and application using OEM.
• Daily Health Check Up of the Database using ADDM, AWR.
• RAC Administration involving managing of instances, ASM, cluster resources.
• Work with the production support team and maintain operational consistency and efficiency.
• Configuration of 11g Dataguard for Higher Availability of Tier-I databases along with 11g RAC Scalability.
• Experience using Data pump utility for taking logical backups on database, schemas and tables with partitioning.
• Identify, monitor, recommend, and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity.
• Implement physical database changes, testing, and performance tuning by reviewing database activity, progress, and performance reports.
• Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
• Used Data Pump for schema refresh, database refresh and used RMAN for backing up databases.
• Provided 24x7 on call support.
• Working as Senior Oracle DBA to support mission critical databases. Involved in up gradation/migration of 10g (10.2.0.2, 10.2.0.3, 10.2.0.4 and 10.2.0.5) RAC to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) RAC with ASM, performance tuning, capacity planning and back up recovery.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Having good experience in user management, Table space Management, Session Management, undo Management issues.
• Installed 12c agents on hosts and discovered targets. Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
• Having good exposure in user management, Table space Management, Session Management, undo Management issues.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Generated AWR, ADDM and ASH reports for database issues
• Installed 12c agents on hosts and discovered targets.
• Created new Groups, Templates, and Incident Rule sets in OEM 12C.
• Designed and tested patching through OEM 12C.

Environment: Oracle 12c, 11g,10g, 9i, ExaData, Linux, Oracle Enterprise Manager Grid Control 11g 12c, RDBMS, SQLPLUS, RAC

Confidential, Minneapolis MN

ORACLE/SQL DBA

Responsibilities:

• Configuration the database on Exadata and upgrading the database from 10g to 11g.
• Configuration of Oracle restart for all databases.
• Converting Standby database to two node RAC
• Converting physical standby database to Snapshot standby database. After the DR activity again reverting physical standby database.
• Configuration of Database with FAST START FAIL OVER for maximum availability.
• Manually configuration of ASM through commands.
• Refreshing the Database from production to Non-Production using Auto Refresh Process.
• Configuration of Physical Standby database for maximum performance mode, Maximum Availability - Oracle Data Guard by using OEM 12c.
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Oracle Agent installation OEM 12c, ORACLE HOME, GRID HOME, SAPORACLEHOME.
• Configuration of Active and passive clusters for Oracle Databases at Plant Locations.
• Installed and configured SQL SERVER 2008R2, 2012, 2014, 2016 on windows 2012,2008, 2003.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Adding the Witness server to existing Mirroring.
• Extensively worked on Installation and Maintenance of SQL Server 2016,2014,2012/2008R2 on Test, Development and Production Environments
• Database Backup and restores, and periodical database refreshes
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues .
• Installed Various Service packs for SQL Server 2014,2012,2008 and 2005.
• Migrated SQL Server 2005/2008/2008 R2 databases to 2012.
• Use log shipping for synchronization of database.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) 12c and 11g. Auto refresh process and RMAN backups in OEM 12c
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import, Auto Refresh.
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM, 12c OEM
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily healthcheck up of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions

Environment: Oracle 12c, 11g,10g, 9i, ExaData, Linux, Windows 2003, SQL Server 2008, 2012, 2014 Oracle Enterprise Manager Grid Control 11g 12c, RDBMS, SQLPLUS, RAC

Confidential, California

ORACLE/SQL DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Installed IBMINFO Sphere 9.3 DATAMASKING
• Migration of SQL Server databases from 2005 to 2008R2.
• Installed and configured SQL SERVER 2008R2 on windows 2008, 2003.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Extensively worked on Installation and Maintenance of SQL Server 2012/2008R2 on Test, Development and Production Environments
• Database Backup and restores, and periodical database refreshes
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues .
• Installed Various Service packs for SQL Server 2008 and 2005.
• Migrated SQL Server 2005/2008/2008 R2 databases to 2012.
• Use log shipping for synchronization of database.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Scrubbing the data for Both ORACLE and SQL Server databases using IBM INFO SPHERE OPTIM.
• Applying scrubbing algorithms for SSN, Account Number, Credit/Debit Card, Work Phone, Address, Zip Code, City, Email Address by using IBM INFO SPHERE OPTIM DATA MASKING.
• Upgrading the Optim 7.3 to 9.3 by applying fix pack 3.
• Installed and configured Foglight in order to Monitor both SQL Server and Oracle Databases.
• Installed and Configured Performance Analyzer in both Oracle and SQL servers.
• Performing Database refresh in both ORACLE and SQL server by using IBM INFO SPHERE DATAMASKING OPTIM.
• Running the extract convert and load process through the power shell using commands.
• Co-Ordination with web developers and Developers team while upgrading Oracle 11g.
• Installed and configured Fog Light and SQL advisor from Quest in Windows.
• Implemented Data Guard on Oracle 10g and 11gwith high availability and performance configurations and participated in Data Guard Fail over tests.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Developed generic package for partition maintenance job for multiple environments.
• Worked on Automatic Storage Management (ASM)with SAN Storage for managing data
• Configured RMAN and performed daily backups.
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, tablespace, Control files, log files and user profiles.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs in the database.
• Analyze the schema and tables.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Extensively used SQL Loader to load data from flat files to the Oracle Database.
• Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTENER, Net Configuration Assistant and other configuration files.
• Created and configured database manually using Oracle Database Configuration Assistant.
• Monitored and tuned long running jobs by working closely with the application development team and analysing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).
• On call 24X7 Production Support.

Environment: Oracle 11g, 10g/9i, Linux, Windows 2003, SQL Server 2008, Data Masking Optim IBM InfoSphere, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, Foglight, Performance Analyzer, RAC.

Confidential, California

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Database Refresh from one version to another version.
• Cloning the oracle home
• Decommissioning the databases
• Scheduling the backups for the database using 12c.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Daily Health Check Up of the Database using AWR, ADDM.
• Perform Daily Monitoring of Oracle Instances, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Performed day to day administrative tasks by analysing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Replication of tables to cross platform and Creating Materialized Views.
• Configured and Implemented Cold/Hot Backups.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Also configured database cloning using RMAN.
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various nature.
• Managing databases on multiple servers.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Confidential, Omaha, Nebraska

Oracle DBA

Responsibilities:

• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment
• Oracle Grid Control11g Installation and Configuration.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily healthcheck up of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML