SUMMARY:

• 7 years of experience in the field of Database Technology with experience in designing, developing, implementing Oracle, Ms sql server, My sql, Postgres and fileMaker Database technologies.
• Thorough experience in Oracle 10g/11g and 12c implementation & administration including Installations, Upgrades, Migrations, Patch administration, Backup and recovery, Moving data and Performance tuning, and configuring OEM 13c.
• Experience in designing and configuring high - availability systems using physical standby (Active Data Guard, configuring the Observer and Data Guard Broker).
• Excellent Experience in installing and maintaining Oracle Data guard to implement physical Standby Databases for Disaster Recovery using shell scripts and RMAN utility tool. Activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD
• Extensive experience in designing and implementing backup and recovery strategy for large and medium size databases using Recovery Manager (RMAN), traditional Export/ Import, Datapump Export/Import as well as conventional Hot/Cold Backups. Use BMC Control-M utility to automate and schedule some batch jobs.
• Worked extensively on Cloning /Duplicate of databases using RMAN.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.
• Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
• Expert in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
• Installed and configured the Oracle Golden gate software to achieve unidirectional real time data replication and zero Down Time Migration.
• Created the manager, extract, pump, replicat, trail files and Golden gate database user with necessary privileges and tested the system to ensure data was flowing from source to target database.
• Monitor, troubleshoot and tune Oracle Golden Gate Manager, Extracts, Pump and Replicat processes to ensure optimal performance.
• Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports
• Experience with SQL coding including DDL, DML and fine tuning those sqls for better performance.
• Experienced in coding SQL, PL/SQL packages, functions, stored procedures, triggers, and Materialized view for Oracle databases.
• Experience with SQL, PL/SQL, UNIX Scripting.
• Good knowledge of v$ and gv$ performance views and command line skills to identify information about sessions, wait events, system performance.
• Involved in tuning Applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the
• poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Collecting performance statistics using Statspack/AWR and ADDM. Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.
• Experience in using 11g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, FLASHBACK and ADVANCED COMPRESSRION and ENCRYPTION (AES), 11g and 12c Grid Monitoring.
• Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 7.x for Clustered Environments.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Good experience in RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Experienced in Installation of high availability RAC environment (2 and 3 node clusters) and upgraded standalone databases to 11g RAC environment on ASM in Redhat Linux,
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Upgrading and Migration of Oracle database to higher versions and other platforms using manual method and traditional Exp/Imp, datapump and Transportable Tablespace (TTS).
• Hands on experience in Oracle Development.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery, Performance Tuning, Capacity Planning and documentation
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool and large pool.
• Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Managing, tuning, upgrading and patching the Exadata storage servers.
• Create and drop databases on Sql Server using Management Studio.
• Schedule and monitor backups using crontab scheduler and set email alerts to monitor success or failure on postgres, and Mysql and File maker databases.
• Schedule regular jobs using Ms sql agent on Management studio.
• Do database and schema refreshes for various databases in mysql using mysql dump as well as database refreshed from backup for Sql server databases.
• Perform database import and exports.
• Write and schedule scripts on crontab that rebuild indexes and procedures, and also recompile invalid objects automatically in mysql.
• Tune and monitor mysql databases using My Sql Bench
• Build OEM 13c and Installed mysql plugins on OEM13c to monitor Mysql databases from versions 5,7 using Oracle Enterprise Manager 13c.
• Create and drop databases as required in Postgres, Mysql, Sqlserver database Management systems.
• Create scripts to monitor space usage and tune Mysql and Sql Server databases using My Sql Work Bench and Sql server Management studio respectively.
• Migrate databases across servers using Backup and Restore in Sql Server.
• Configured Mysql Percona Server 5.5.55 38 and moved databases from mysql 5.5 community version to Percona.
• Configured Mysql Replication using Master and Slaves for high availability.
• Manage user passwords and profiles of various users, limiting access to sensitive information, by assigning access to specific IP address.
• Excellent analytical, problem solving, communication, documentation and interpersonal skills

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c, Sql server 2008, 2012, Mysql 5.0, 5.0, PostgreSQL 8.4.2, File maker 12, 14, 15

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy, BMC Control M, Sql server Management Studio, My sql Work Bench

Operating Systems: UNIX (Solaris 8/9/10), AIX, HP-UX), LINUX, WINDOWS 2008,

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2

Middleware: BEA Weblogic 10.2.3

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization.

WORK EXPERIENCE:

Confidential, Somerville, MA

Oracle, Sqlserver, Mysql, Postgres and FileMaker database Administrator

• Supporting Oracle 10g, 11g and 12c databases for production, development, test and staging purposes on LINUX, Solaris, and Windows 2012 environments.
• Installed Oracle Enterprise Manager 13C grid control on Virtual Machine
• Build a 2 node RAC Cluster running on 12c Pluggable Container database and moved databases from 11g and 10g up to 12c.
• Monitor and optimize database performance as well as applications using Oracle Enterprise Manager Cloud control along with homespun scripts on crontab.
• Administered Unidirectional Oracle Golden Gate Databases for reporting purposes.
• Monitor and troubleshoot Oracle Golden Gate Manager, Extracts, Pump and Replicat processes to ensure optimal performance.
• Implemented Security in Golden Gate using TDE using AES128 and Advanced Compression using ZLIB algorithm to minimize CPU consumption.
• Used Oracle Goldengate to perform zero downtime Migration across heterogenous platforms from sql server to Oracle.
• Experienced in Oracle Development both Oracle Application development and SDLC
• Allocating system storage and plan future storage requirements, by developing shell scripts that backup and delete archivelogs every 15min.
• Configured 11gR2, RAC, Physical and Logical Standby databases for Test, Development and Production.
• Implemented Oracle Audit Vault and Database Fire Wall (AVDF) to monitor events on databases.
• Involve in 24x7 on-call support for 12 databases of 20 TB 3 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade and Security Patches, maintenance and interim (Opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgrade and Migration of Database from 11.2.0.4 to 12.1 on a RAC cluster and migrated all databases using datapump from old server to new RAC cluster servers applying patches whenever required.
• Efficiently performed installation, setup and creation of two node cluster RAC with Oracle12.2 database using GRID infrastructure with ASM file systems on Linux Redhat 7.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Did performance tuning on Instance as well as database. Tune slow running sql using AWR, ASH as well as Enterprise Manager, Creating Materialized views, adding indexes, dropping unnecessary indexes..
• Loading data from flat files to database using SQL*Loader, External Tables.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Create and drop databases on Sql Server using Management Studio.
• Schedule and monitor backups using crontab scheduler and set email alerts to monitor success or failure.
• Do database and schema refreshes for various databases in mysql using mysql dump as well as database refreshed from backup for Sql server databases.
• Perform database import and exports on mysql databases.
• Write and schedule scripts on crontab that rebuild indexes and procedures, and also recompile invalid objects automatically.
• Tune and monitor mysql databases using My Sql Bench
• Create and drop databases as required.
• Create scripts to monitor space usage and tune Mysql and Sql Server databases using My Sql Work Bench and Sql server Management studio respectively.
• Manage user passwords and profiles of various users, limiting access to sensitive information, by assigning access to specific IP address.
• Excellent analytical, problem solving, communication, documentation

Confidential, Worcester, MA

Oracle Database Administrator

• Supporting Oracle 10g, 11g and 12c databases for production, development, test and staging purposes on LINUX, Solaris, IBM, AIX and Windows 2008 environments.
• Monitoring and optimizing the performance of the database/application using Oracle Enterprise Manager Cloud control along with homespun scripts.
• Configured and administered Unidirectional Oracle Golden Gate Databases and tested the system to ensure data was flowing from source to target databases.
• Monitor and troubleshoot Oracle Golden Gate Manager, Extracts, Pump and Replicat processes to ensure optimal performance.
• Implemented initial Data Load, Batch/Online replication, Security in Golden Gate using TDE using AES128 and Advanced Compression using ZLIB algorithm to minimize CPU consumption.
• Used Oracle Goldengate to perform zero downtime Migration across heterogenous platforms.
• Experienced in Oracle Development both Oracle Application development and SDLC
• Allocating system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, RAC, Physical and Logical Standby databases for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions.
• Implemented Oracle Audit Vault and Database Fire Wall (AVDF) to monitor events on databases.
• Involve in 24x7 on-call support for 12 databases of 20 TB 3 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade and Security Patches, maintenance and interim (Opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab as well as bmc control-m.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2, and from 11.2.0.4 to 12.1 applying patches whenever required.
• Efficiently performed installation, setup and creation of three node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on Linux and Solaris.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints where possible .
• Worked on both VMS and UNIX environments.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge of Conceptual and dimensional data models. Oracle data warehouse with DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for reporting.
• Experience in implementing various aspects of database auditing using Oracle Audit Vault and database firewall.
• Managing, tuning, upgrading and patching the Exadata storage servers
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Environment: Oracle 10g/11g RAC/11g, VMS, Sun Solaris, Windows Server 2008, Red Hat Linux 6.5, TOAD, RMAN, SQL server, OEM.

Confidential, Evansville, IN

Oracle Production Support Database Administrator

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Grid control 12c
• Loading data from flat files to database using SQL*Loader, External Tables.
• Supporting SQL Server databases for production, development, test and staging purposes on Windows 2008 environment.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Implemented oracle 12c active standby database for test database environment.
• Utilized Rman recover table functionality and created proof of concepts for our pre-prod environment.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Documented all Oracle 12c installation/Upgrade work and delivered KT to team.
• Worked with projects/operations/professional services team and co-ordinate multiple tasks with expertise and solid planning.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Monitored/maintained databases, replication process and performance tuning using OEM (Oracle Enterprise Manager).
• Trouble shooting and tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
• Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
• Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also, configured Redaction using OEM's Policy expression builder.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Implementing various aspects of database auditing (Fine grain, value based and standard auditing).
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Optimized performance for the databases by rebuilding indexes on tables.
• Automated processes of moving files, managing alert logs, backups by developing UNIX scripts.
• Used Partitions, create indexes and materialized views to tune various Applications.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Ran Scripts for Health Checks to monitor and tune Exadata Storage Servers.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0. redhat LINUX 6.0