TECHNICAL SKILLS

Databases: Oracle 12C/11G/10G/9i

Projects: Data guard, RAC, Golden gate, Capacity Planning

Operating Systems: HP - UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/ 2000/2008/2014/2016

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer, Sql Server Management Studio 2008/2014, Foglight Dell, MobaXterm, Putty.

PROFESSIONAL EXPERIENCE

Senior Oracle/SQL Database Administrator

Confidential - Austin, TX

Environment: Oracle 12C, 11.2.0.3, SQL server, Teradata, Dataguard, RAC, SQL, T-SQL, PL/SQL, SQL* LOADER, TOAD, OEM 12C, RAC, MS SQL server, Linux Enterprise Server 9, 10, Teradata, Golden Gate, SSMS, Foglight

Responsibilities:

• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Upgrades and Patches-Installation of oracle 10g, 11g and 12c databases in production, development and test environments depending on project requirements.
• Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Creating SSRS reports and subscription. Deploying Report on multiple Report Servers.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database.
• RMAN CLONING-Refreshing development/test database from production using Export/Import & RMAN backups.
• Performance-Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Data Migration/REPLICATION-Extensively used ORACLE GOLDEN GATE and ORACLE DATAGUARD for data replication and protection.
• Also used Data pump, conventional export/import utilities for loading data to & from other databases.
• Security-Managing database security.
• Security-Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Performance Tuning-Defragmentation of tables and indexes for improved performance and effective space management.
• Performed inSQL Server Reporting Services (SSRS) and Integration Services (SSIS) to manage data warehouse environment
• Performance Tuning-Managed Database Maintenance Activities to achieve optimum database uptime.
• Network-Configured Listener and Tnsnames.
• Performance Tuning-Performing regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Database Links-Created database links between two databases to access data from one local database to remote database using distributed database feature.
• Created Complex Stored Procedures and automated them usingSQL Server Agent.
• Experience in implementingSQL Server Security and object permission like maintaining creation of users, configuring permissions database authentication modes and assigning roles of users.
• Backup & Recovery-Planned database backups (operating system, full/incremental database backups, Data pump, or export/import)
• SDLC-Provide 24/7 support to during production support for the deployed project till it is stabilized.
• Scripting-Wrote SQL scripts to create database objects like tables, views and sequences.
• Proficient in SQLServer Replication, Always on, Backup/Recovery, Disaster recovery and Capacity planning.
• Expert in tuning database by choosing indexes and using tools Database engine tuning advisor, SQL Profiler.
• Worked on Clustering and server consolidation, troubleshooting production issues and raising high availability.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g 12C

Oracle/SQL Database Administrator

Confidential - Grand Rapids, MI

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, PL/SQL, TOAD 11.0 . Linux Enterprise Server 9, 10, MS SQL server

Responsibilities:

• Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
• Upgrade/Migration of Databases from Oracle 11.2.0.2 to 11.2.0.3.
• Implemented 12c Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing materialized views, created partition tables and maintaining index's
• Enabled Flashback for database to create restore points and supporting DDL changes
• Used Oracle database vault and proactively protecting application data, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted table spaces and backup wallet and master keys to tapes
• Installed, configured Oracle database Vault and database Fire wall server and Implemented Advanced security 12c Oracle Advanced Security using TDE (Transparent Data Encryption) and Enabling Auto Login for the Keystore for cdb$root and Pluggable databases
• Applied PSU quarterly on 11g/12c GRID & RDBMS homes using opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN
• Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in handling large databases upto 4TB in size and largest table of size 60GB with 145 million records.
• Installation, Configuration of ASM, RAC databases, Adding Services and maintaining GRID control.
• Migrated databases from 9i and 10g to 11g R2 using utilities like export/import, datapump and transportable tablespace.
• Performed replication between databases using Materialized Views and DB links from a remote database.
• Successfully performed installation, setup and creation of Primary & Standby database using dataguard to deliver no data loss with maximum availability mode.
• Worked closely with application teams for rolling application.
• Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
• Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.
• Applied PSU Patches as a part of maintenance activity.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
• Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Provide production, dev and test, support for the deployed project till it is stabilized.
• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Database Administrator

Confidential - Waukon, IA

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Provided 24X7 support for all the production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.