PROFESSIONAL SUMMARY:

• Over 15 years of IT experience in Database Administration, Designing, Developing, and implementing applications using various relational database management systems (RDBMS) and operating systems.
• Hands on administration/performance/implementation experience on oracle appliances like Exadata and ODA’s.
• Migrated databases from solaris/Aix to oracle appliances Exadata/ODA’s by using GG replication.
• Migrated database from 10G/11G to 12C.
• Expertise in GG configuration and uni/bi directional replication.
• Experience with Oracle 12c container/pluggable databases.
• Hands on experience in Oracle DBA activities including database design, development, performance tuning and disaster recovery management, systems administration in LINUX environment and software development activities.
• Creating physical and logical Database Design, Data Analysis and Data Modeling.
• Installation, configuration and maintenance of Oracle 12C/11g ASM & RAC databases.
• Hands on experience in Installation, configuration and maintenance of OEM - 12C Grid.
• Oracle 12C/11g Dataguard configuration and maintenance.
• Database upgradation from Oracle10g to Oracle 11g in RAC and Non-RAC databases.
• Coordinate and work with System DBAs, SAs, and Storage Teams in their tasks to keep the databases up and running and plan for projects which involves hardware or system level changes.
• Hot and cold Backup and recovery of oracle 11g database using tools like RMAN
• Scripting and scheduling of oracle database backup using RMAN.
• Experienced in using 10g features like Data pump, Flash-Back Recovery and ASM.
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g.
• Experience in SQL server database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
• Strong in using tools such as SQL*Plus, SQL Developer, TOAD, PL-SQL, OEM and SQL*Loader.
• Highly skilled in Performance Tuning & Optimization of SQL statements and Stored Procedures.
• Database performance tuning by using AWR,ADDM,ASH reports and TKPROF, SQL Trace, Explain Plan.
• Experience in Physical database design and creation. Device strategy for Backups, Recovery and fine-tuning.
• Cloning of database and database refreshment for development teams, import and export of data.
• Expertise in maintaining Database Security using auditing.
• Expertise in Shell Scripting for Database Extraction and filtering, automating routine tasks and Oracle DBMS JOBS.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Excellent analytical and problem-solving skills.
• Ability to work independently and with work teams having varying backgrounds on complex issues and have strong verbal and written communication skills along with strong analytical and decision-making skills.

TECHNICAL SKILLS:

OS: Windows, Unix, Linux, Solaris,HP-UX,AIX

DBMS/RDBMS: Oracle 12C/11g/10g/9i, MS Access, MS SQL Server 2003,2005,2008

DBA Tools: ZFS,ZDLRA,Export/Import(Datapump),SQL*Loader,RMAN,Erwin,TOAD,OEM,Shareplex,Autosys,Gridcontrol,Datamirror,DMExpress,Quest Spotlight

ETL Tools: Informatics Power Center 7.1, Oracle Warehouse Builder, BO, Crystal Reports, SQL-Loader

Languages/Scripting: Java, Unix Shell Programming,SQL, PL/SQL

Unix Administration: Linux, Solaris

Tuning Tools: Explain Plan, Stats pack, AWR,ADDM

Query Tools: TOAD, PL/SQL Developer, SQL Navigator, SQL*PLUS, SQL Developer, AP,AI

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee

DBA Specialist (Architect)

Responsibilities:

• Worked on 9i, 10g,11g and 12c RAC and Non-RAC databases on Exadata,ODA’s,VCS cluster and RAC clusters on OLTP and DW environments.
• Involved Exadata configuration and implementation.
• Migrated databases from one cluster to another cluster.
• Migrated databases from solaris/Aix to Exadata/ODA’s by using GG replication to 12C containers.
• Configure and maintain the DR/Standby databases in different locations.
• Clusterware upgrade from 10g to 11g, 11g to 12c.
• Applied patches on Oracle 12c/11g/10g Clusterware and RAC databases.
• In depth Oracle Database Administration experience in DataGuard, ASM,GoldenGate.
• Extensive experience in Database Backups RMAN (Full/Incremental backups) by using oracle backup solutions like ZDLRA & ZFS and in traditional hot/cold backups.
• Performing database upgrades as part of new releases
• Automated the configuration management for several servers using Chef and Puppet.
• Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables and changing performance related parameters in the database.
• Worked actively on features such as AWR, ADDM, and ASH, performance statistics collection, and fine tuning database wait events.
• Created a number of database instances for development, testing and production.
• Configure and Register Oracle Database in OID
• Worked on Transparent Data Encryption (TDE),Secure Key Management,Strong Protection of Database Backups,Oracle Data Vault, Oracle Data Masking Pack.
• Worked on DR exercise and replication on databases using goldengate and shareplux.
• Applied database patches using Opatch utility.
• Coordinated and interfaced with Oracle support for upgrades, certification issues and tars
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.

Confidential, Milwaukee

Lead DBA

Responsibilities:

• Managing, troubleshoot and resolving oracle database and applications issues.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Handled multi TB size Production databases with Oracle 10g & 11g RAC and Standalone environments.
• Installation, configuration & monitoring of OEM-12C grid.
• Administrating and maintaining the ASM including configure/discover/partition the new LUN at OS which are carving from SAN storage and adding disks into disk groups.
• Proactive monitoring of the system, responding to the p1,p2,p3 tickets.
• Resolving the production and development issues in timely manner.
• Identifying for performance issues, root cause analysis and troubleshooting.
• Upgrading the database as and when required, cloning the systems, refreshing the test/development databases.
• Capacity planning and benchmarking statspack, development and operational support.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption) by using RMAN.
• Implemented Dataguard & Active Dataguard for high availability/ disaster recovery purpose and monitor the DR by using Dataguard broker and OEM.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Installed SQL Server 2008 R2 and SQL Server 2005 windows servers, applied service packs and security fix for all servers.
• Implemented Database Mirroring on SQL Server 2008 environments.
• Used ERWIN to carry out Logical and Physical data modeling
• Implemented transactional replication for data refresh.
• Created backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.

Environment: Oracle 9i/10g/11g, Real Applications Cluster (RAC), Data guard, ASM, Solaris 10, Oracle Linux, PL-SQL, Java, Autoprocess, Autoissue, Grid control (OEM) and SQL Server 2005/2008.

Confidential, NJ

Sr. Oracle DBA

Responsibilities:

• Reviewing all the requirements from the requirement documents and Reviewed Test Cases based on the requirements.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Installation, configuration and maintenance of Oracle 11g RAC and Non-RAC databases.
• Involved in Upgrade/Migration of the oracle databases from Oracle 10 g to Oracle 11g and 11g to 11g R2.
• Involved database migration by using oracle Golden Gate (Installation, Configuration & Maintenance).
• Hot and cold Backup and recovery of oracle 11g database using tools like RMAN
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Implemented Dataguard for high availability/ disaster recovery purpose.
• Installation and maintenance of Oracle11g ASM.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed PL/SQL objects like Packages, stored procedures and functions for accessing, inserting, modifying and deleting data in the database.
• Designed and Implemented table partitions on large tables to improve performance using Partition Pruning.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Performing monitoring and performance tuning
• Monitoring the various database activities by developing shell scripts and using various tools
• Participated in Unit testing, Integration testing, User Acceptance testing.
• Administrated Upgraded and Managed SQL Server 2008R 2/2008/2005/2000 databases in Production, QA and development environments and mentored other technical staff.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans which covers Database Integrity Checks.

Environment: Oracle 9i/10g/11g, Real Applications Cluster (RAC), Data guard, ASM, Solaris 10, Red Hat Linux, HP-UX, AIX, TOAD, Java, Grid control (OEM) and SQL Server 2005/2008.