PROFESSIONAL SUMMARY:

• Poses over 9 years of experience in managing Oracle and SQL Server databases
• Managed 9i, 10g, 11g, 12c databases on standalone, RAC and on cloud.
• Strong administrative skills on RHEL, Solaris, Windows and AIX.
• Strong skills in managing High Availability and critical databases.
• Configured, installed and administered 2 - node and 4-node clusters.
• Configured, installed and administered standby databases using Oracle Data Guard.
• Managed and resolved gaps in Data Guard.
• Worked with Storage and configures ASM disks.
• Strong experience in managing RAC databases on ASM
• Build and managed Active Data Guard.
• Managed Oracle database on AWS.
• Strong experience in troubleshooting and performing root cause analysis.
• Installed and managed Oracle Goldengate uni-directional and bi-directional replication.
• Good experience in troubleshooting RAC, Data Guard, GoldenGate, ASM, performance related issues and other areas of Databases administration.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Strong experience in applying database and CRS bundle patches.
• Strong experience in RMAN and cloning databases.
• Strong experience in refreshing databases, schemas and tables using data pump.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Extensive knowledge in Database Cloning using RMAN, Veritas and Commvault.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Written shell scripts to automated database tasks.
• Setup and managed database jobs via crontab and dbms jobs.
• Managed databases using OEM 13c cloud control
• Administrative experience in setting up 12c and 13c cloud control.
• Managed SQL Server databases.
• Setup log shipping between primary and standby SQL Server site.
• Backup, restore, recovery of SQL Server databases.
• Performance tuning of the database using different methods like SQL Tuning, ASH, AWR, ADDM and Tuning of SGA, Distribution of disk me/O, Sizing of tables and indexes etc.
• Expertise in using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in writing PL/SQL Stored Procedures, Functions, Packages and Triggers, various UNIX Shell Scripting.
• Managed in managing Oracle on-premises cloud.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
• Provided 24*7 on-call production database support and maintenance including remote database support. Worked on Automatic Storage Management with SAN storage for managing data in EMC symmetric.
• Knowledge of Data Normalization and its normal forms.
• Performed various database Upgrades from 10g to 11g to 12c.

TECHNICAL SKILLS:

Operating Systems: RHEL, AIX, Windows, Sun Solaris

RDBMS: Oracle 9i, 10g, 11g and 12c

High Availability: RAC, Data Guard, Golden Gate, ASM

Languages: SQL, Java, C, PERL, UNIX Shell, T-SQL

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, DBMS, Stats

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Lombard, IL

Responsibilities:

• Perform DBA task such as Database Administration on Oracle 9i,10g, 11g, 11gR2 and 12c environments, upgrading databases from 11g, 11gr2 to 12.1.0.1, Performance tuning, Schema creation, maintenance, and trouble shooting.
• Migrated Oracle Database from On-premise environment to Oracle Cloud Control.
• Resolves database performance issues, database capacity issues, backup, replication, and other distributed data issues.
• Migrated Oracle Database environment from On-Premise to Amazon AWS Cloud.
• Setup and manage RAC environments for our customers, Monitor, recommend and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity.
• Implement physical database changes, and performance reports.
• Maintain Oracle SQL and PL/SQL scripts, UNIX shell scripts, debugging and tuning.
• Ability to pro-actively understand and manage end user/customer expectations.
• Provide best practice on new technology and implementations.
• Provides expertise and makes recommendations for physical database design, testing, performance tuning, and implementation of DB.
• Performance issues (track and trend overall database performance and database area, index, and drive performance).
• Great experience applying patches and performing DB Migrations.
• Plan and Design Backup/Recovery solution using Shell scripting and RMAN.
• Installation, Administration and Maintenance of SQL Server Instances.(Installing SQL Server).
• Setup Test, Dev, Staging and Production Environments.(Installing SQL Server)
• Create Users and assign permissions based on the level of database access the user would need.(Security)
• Design database Backup and Restoration Strategy.(Database Backups and SQL Server Agent)
• Once created the database Backups, monitor those backups are being performed regularly.(SQL Server Agent)
• From time to time recover the databases to a specific point of time, as per the requests.(Database Backups and Recovery)
• Troubleshoot various problems that arise in a day-to-day work and fix the issues.(Monitoring SQL Server Error Logs and checking you're email alert (if there is one configured)

Oracle DBA/MS SQL Server

Confidential, CHICAGO, IL

Responsibilities:

• Build 2 node RAC cluster
• Setup Maximum Availability Physical Standby Data Guard
• Refreshed databases using RMAN duplicate database.
• Refreshed schemas using data pump.
• Worked with storage admins for disk space for ASM
• Migrated databases from UNIX file system to ASM.
• Applied CPU / PSU / one-off patches.
• Used 12c cloud control to monitor databases.
• Setup jobs/alerts using OEM.
• Utilized a combination of Bash and Korn shell scripting to integrate two sets of scripts
• Created and modified shell scripts
• Worked with shadow copy software to back up large databases and quantities of data
• Migrated data from one server to another
• Worked with CLI and GUI
• Worked with vi Text editor
• Modified existing RMAN scripts.
• Generated Oracle Audit Remediation reports

Oracle DBA

Confidential, N ew York, NY

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Proactive database monitoring using 11g grid monitoring tool.
• Installation, Configuration and Maintenance of RAC, Stand by database. Installed and Configured Oracle 11g RAC, CRS using ASM.
• Implemented the Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintain primary and standby databases.
• Database migrations from HP-UX11 to AIX 6.1 platforms.
• SQL tuning using statspack and explain plan, tkprof.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Responsible for upgrade & migrating databases from 10g to 11g &11g to 12c.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g, 12c & OEM
• Install, configured and maintained Oracle 10g on Linux Red Hat 5
• Clone database from Production to Development, QA testing environments
• Create materialized view (snapshot)
• Installed, patched, and configured Oracle 10g and monitoring Oracle database.
• Upgrade OPatch
• Rolling install oracle patch in Oracle RAC 11g
• Upgrade database from 10g to 11g
• Managed table space
• Monitoring database in GRID CONTROL, OEM and OS level
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Sun Solaris 5.10, Aix 6.1, HP-UX 11.31 Oracle 9i, 10G, 11G, & 12C, OEM, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Oracle Replication, Hot Standby, Data Guard.

Oracle DBA

Confidential

Responsibilities:

• Installed, configured and managed Oracle 10g RAC
• Configured Oracle networking for RAC
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of STANDBY database using DATAGUARD.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Experience in troubleshooting the ORACLE streams.
• Configured RMAN backup for 10g RAC database
• Monitoring 10g RAC performance
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Raised SR and TAR with Oracle Support.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN. Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Provided System support for both development and 24*7 production environments.
• 24x7 Production Database Administration support

Environment: Oracle 10g RAC/9i, SQL, RHEL 4, AIX 5.2, Shell scripting, SQL Server 2000/2005