SUMMARY

• 10+ years of experience in Oracle Database Administration.
• Perform various tasks like Database Design, installation, configuration, upgrades, patches, migration, performance tuning, backup and recovery, production support, cloning, space management, database security in production as well as development databases on variety of platforms for Business solutions.
• Extensive experience in Oracle Database Administration on 24x7 critical production and large databases using Oracle 12c,11gRAC, 10g RAC, and 9i.
• Implementation of high availability solutions with Oracle 10g RAC, 11g RAC, 12c.
• Management of schemas, objects and Partitioning the tables & indexes.
• Experienced in creating USERS, GRANT privileges and ROLES to users.
• Installation, configuration, upgrade and performance tuning of Oracle 12c, 10g, 11g RAC.
• Installed and configured oracle Grid control (12c and 11g).
• Upgrade/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning. Having extensive experience in Oracle Golden Gate 10.x, 11.x installation, Configuration, up gradation and administration.
• Configured parameters for the unidirectional, Bi - directional replication.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc).
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, ASH.
• Excellent Performance management skills on multi- terabyte Database environments.
• Extensive performance tuning experience, specializing in instance tuning, Oracle9i, 10g RAC, 11g RAC, 12c tuning and SQL optimization.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• Excellent experience using Oracle Real Application Testing (RAT).
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, and applied the data model changes in database.
• Installed and configured bi-directional Golden Gate for High data availability and Operational reporting.
• Trouble shooting and performance tuning golden gate replication.
• Experience with designing the existing architecture based upon the business requirement and applying the best Golden Gate Practice.
• Managing the existing Golden Gate replication processes and setting up new Golden Gate replications for ETL process in heterogeneous environments like Oracle, DB2.
• Installation, Configuration and maintenance of Oracle 11gR2/12C on Exadata x2-2, x3-2, x3-8, X4-2.
• Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines.
• Experience in performance tuning, troubleshooting on Exadata machines. Gained Working knowledge of Linux, storage and network administration in relation to Exadata machines.
• Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines. Provided support for OS upgrades on Exadata running on Linux.
• Provided support for altering hardware on Exadata machines.
• Performed migration of databases from single instance database to Exadata machines.
• Knowledge on Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers.
• Configuring IORM/DBRM and Implementing Oracle Exadata best Practices.
• Upgrade the existing Golden Gate version environment to Golden Gate version 11.2.1.0.
• Prepare Golden Gate parameter files for Extraction and Replication.
• Investigate Replication failures using Log Dump utility.
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby databases and also to ensure disaster recovery, high availability and data protection.
• Excellent knowledge in Hot/Cold Backup, Recovery, cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Expert in configuration of 11gRAC, 10gRAC, 9i on Linux, HP-UX and Solaris using ASM and RAW devices and Oracle CRS.
• Worked extensively with configuring database backups in RMAN environments using TSM, Net backup and CommVault backup utilities.

TECHNICAL SKILLS

Databases: Oracle 9i/10gRAC/11gRAC/12C.

Operating Systems: HP-UX 11.x, Sun Solaris 9, 10, AIX 5.2, 5.3, Red Hat Linux RHEL 4.x, 5.x and Windows 2003/2008/2012.

Languages: SQL, PL/SQL, UNIX Shell, Perl, C, C++, XML.

Tools: /Utilities: RMAN, OEM, TOAD, SQL*Loader, SQL Plus, Data pump Export/Import, Query builder, oracle golden gate 10.x, 11.x

DB Management: TOAD, OEM, DBArtisan, OEM Grid Control, SQL Developer.

Database Modeling: ERwin r 7.1/7.2/7.3/8, ER Studio V8.0.1 and Oracle Designer

Tuning Tools: TKPROOF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH.

Hardware/Storage: Exadata x2-2, x3-2, x3-8, X4-2, VERITAS Net Backup, Tivoli Storage Manager (TSM).

PROFESSIONAL EXPERIENCE

Confidential, Dallas,Tx

Senior DBA

Responsibilities:

• Implemented all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of various applications in OLTP, Data Warehousing, and OLAP applications.
• Performed Installation, Configuration, troubleshooting, performance tuning and production support of Oracle 10g, 11g, 12C (Single Instance and RAC) databases on Sun Solaris, Red Hat Linux, and HP-UX environments.
• Created Multiple 12c pluggable databases and performed cloning for non-production databases.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Created database links to access to data between oracle databases and also worked on Heterogenous database links to access data between Microsoft SQL server and Oracle dbs.
• Installed and administered Real Application Cluster (10g, 11g, 12C RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Applied patches (PSU and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Involved in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, and applied the data model changes in database.
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility. Wrote Shell scripts for Alerts for ORA-errors, backup and recovery, Import and export procedures.
• Installed and configured oracle 12c and 11g Grid control.
• As Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience creating data mapping documents, writing functional specifications, queries.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Performed Upgrade/Migration of Databases from Oracle 11g to 12C.
• Currently working on Upgrading oracle 12c to 19c versions with Container and pluggable databases.
• Participated in Hardware upgrades like Firmware upgrades, Linux version upgrades and Storage migrations over on premise and Cloud platforms.
• Excellent experience using Oracle RAT. Used Database Replay to capture production workload on test systems.
• Creating new user accounts, profiles, and roles and assigning them to users.
• Assigning users to groups and granted privileges and permissions to appropriate groups.
• Worked on Performance management of multi- terabyte Database environments.
• Proficient in Oracle Architecture and concepts to support Data Warehouses.
• Worked closely with developers in schema design and SQL tuning, performed database capacity planning, performance tuning at system level, database level, and SQL level.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
• Installed, Configured and Administered Golden gate.
• Configured parameters for the unidirectional, Bi-directional replication.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Worked on Oracle Exadata Backup Configuration utility.
• Disaster recovery of Exadata Data guard Physical Standby.
• Experience with Oracle EXADATA machine deployment & Migrations.
• Good understanding of Oracle Exadata and HCC (high columnar compression ratio).
• Explored optimum utilization of Exadata cell index & HCC (COLUMNAR COMPRESSION).
• One Command configuration on Exadata.
• Configure Maintaining and troubleshooting Exadata Cell disk/Grid Disks.
• Troubleshooting Exadata smart scan/offloading issues.
• Bare metal restore of Exadata DB node and CELL node.
• Monitoring the Infiniband Switches/ports, HCA ports on DB/CELL nodes and IB topology
• Configuration, Administration and tuning of Golden Gate.
• Fixed performance issues in Golden gate by adding more processes and using Range distributions.
• Configured Golden Gate parameters for DDL Replication.
• Performed Uni-directional and Bi-directional replication through Golden Gate for zero downtime Database migrations.
• Investigate Replication failures using Log Dump utility.
• Fixed performance issues in Golden gate by adding more processes and using Range distributions.
• Reporting and resolving all serious Oracle alert log messages.
• Installed and Implemented Backup & Recovery procedures. Implemented Hot and Cold Backups, Exports, Imports, Data Guard, Flashbacks.
• Successfully developed and implemented monitoring scripts, health check scripts, Database backup scripts.
• Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, LOGICAL STANDBY and PHYSICAL STANDBY databases.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.
• Proactively monitored the database systems to ensure secure services with minimum downtime.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.
• Conducted impact analysis on upgrades, security.
• Rollout database builds in various production and non-production environments.
• Designing and managing logs, back-ups and recovery procedures using RMAN.
• Writing PL/SQL triggers, procedures, and functions.
• Creating and Managing Table Spaces, Tables, Views, Indexes, and Partitions.
• Optimized the query result cache for best performance.
• Performed logical and physical database design to support client customers.
• Ability to manage multiple instances in Dev/QA/Stage/Production.
• Prepared database structure and configuration for high-performance/high-availability through analysis and optimization.
• Performed database monitoring utilizing a combination of Oracle Grid Control and UNIX shell scripts.
• Provided 24*7 Production Support.

Environment: HP-UX 11.31, Oracle 12C, 11g, 10g and 11g RAC, Exadata x3-2,3-8,x4-2,4-8, golden gate 11.x, ERWIN r7/r8, RMAN, Data pump, SQL server, OEM, Grid Control, Data Guard, TKPROF, STATSPACK, Diagnostic and Tuning Advisors.

Confidential, Louisville, Kentucky

Sr. Dba

Responsibilities:

• Migrated Large databases over 40+ Terabytes of databases from Aix to Linux environments.
• Refresh non-prod environments and oracle applications on regular basis to support development team.
• Worked on configuring oracle 11g two-node rac database on oda oracle database Appliance.
• Involved in critical migration projects to move databases from 11G to ODA (oracle database Appliances).
• Working with SOX team to maintain database and host Standards.
• Worked with development, storage and network teams in installation and administration of mongodb in the IT Enterprise
• Enable sharding on databases and collection by choosing suitable shard key.
• Involved and responsible for managing more than 80 Nosql clusters, which involved mongodb and Ingres Nosql Dbs.
• Continuously coordinated with Development team for the schema changes & in the Data modelling discussions.
• Installed, configured and maintained Cassandra and mongodb multi-node cluster, OpsCenter.
• Configuring Multiple Heterogeneous ODBC setups and creating listeners to pull data from Multiple database Sources (Netezza, Seibel, Microsoft, Memsql etc.) to oracle databases.
• Setup database servers for new applications and whenever we migrate/upgrade our servers
• Co-ordinating with oracle support for any production issues which affects business.
• Upgraded multiple databases from 10g and 11g and 12c versions with minimal downtime.
• Experienced in Upgradation and Migration of oracle database from windows, Aix to Linux across various platforms.
• Created and setup oracle databases 12c with container and pluggable databases.

Confidential, Dallas, Texas

Responsibilities:

• Installed rac cluster on multiple nodes and managing rac environment efficiently.
• Install and setup MySQL 5.7 servers using AWS RDS.
• Configure and maintain MySQL replication topologies for high-availability and database read scale-out.
• Managed high transactional MySQL databases servicing OLTP and DSS applications.
• Worked on EXADATA hybrid columnar compression for tables and tablespace compressions.
• Install & configure development Postgresql 8.1.1 databases on Fedora Core 7 servers.
• Optimize postgresql.conf for performance improvement.
• Coding of Pl/sql stored procedures,data types, triggers and Constraints.
• Review database schema & structure for design improvements and data normalization.
• Migrated Large databases over 40+ Terabytes of databases from Aix to Linux environments.
• Refresh non-prod environments and oracle applications on regular basis to support development team.
• Worked on configuring oracle 11g two-node rac database on oda oracle database Appliance.
• Involved in critical migration projects to move databases from 11G to ODA (oracle database Appliances).
• Working with SOX team to maintain database and host Standards.
• Worked with development, storage and network teams in installation and administration of mongodb in the IT Enterprise
• Enable sharding on databases and collection by choosing suitable shard key.
• Experience in deploying, managing and developing MongoDB clusters on Linux and Windows environment
• Database management for scheduling, tuning, taking backups using on-premise MMS monitoring and backup solution.
• Point in time Backup and recovery in MongoDB using MMS.Data modeling for data from RDBMS to and MongoDB for optimal reads and writes.
• Used Neo4j for graphical based search. Database management for scheduling, tuning, taking backups using on premise MMS monitoring and backup solution.
• Point in time Backup and recovery in MongoDB using MMS. Data modeling for data from RDBMS to and MongoDB for optimal reads and writes.
• Responsible for managing MongoDB environment with high availability, performance and scalability perspectives.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, Stored outlines, Statistics.
• Worked on different storage engines in Mongo.Managing Mongo databases using MMS monitoring tool.
• AIX JSON and JavaScript for data integration, Shell Scripting
• Worked on balancer issues and chunk migration failures.
• Gained Knowledge on Deploying apps using AWS Cloud Formation.
• Created users in mongo database and assigned specific roles to maintain security of Database.
• Performance tuning and stress-testing of Mongo database using Mongo utilities.
• Troubleshooting of different versions of Mongo database systems and cluster configurations to ensure high-availability in various crash scenarios and restoring roll backs to avoid loss of Data.
• Upgraded Mongo systems from 3.0.5 to 3.2. Also involved with creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Explain plan of mongodb java scripts and suggested tuning of queries when and where it is required.
• Developed JavaScript’s to monitor health of Mongo databases and perform ad-hoc backups using Mongodump/mongoexport and Mongorestore/mongoimport.
• Worked with Gridfs collections to store large size documents and enabled sharding with range based sharding keys.

Confidential, Auburn Hills, MI

Oracle Database Administrator

Responsibilities:

• Performed Installation, Configuration, and Designing, troubleshooting, performance tuning and production support of Oracle 10 g, 11g, and RAC (10g and 11g R2) databases on Sun Solaris, Red Hat Linux, and HP-UX 11.11.1. Installation, Configuration, Designing and Maintaining of ASM on Oracle 10g.
• Installed and administered Real Application Cluster (10g RAC, 11g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Performed replication using Oracle Streams.
• Tuned SQL queries & PL/SQL Applications using AWR, ADDM, STATSPACK and Execution Plans.
• Applied Patches on RAC, Standalone, Standby databases.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Excellent Performance management skills on multi- terabyte Database environments.
• Very good knowledgeable on oracle streams, data guard physical standby databases, working, and managing of partitions and clustering of tables.
• Proficient in Oracle Architecture and concepts to support Data Warehouses.
• Wrote scripts for Backup of databases, export of databases and maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Used Data Pump for export and import.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Installed and configured oracle Grid control. Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• One Command configuration on Exadata. Maintaining Exadata hardware.
• Troubleshooting Infiniband/RDS performance issues.
• Migrating databases to Exadata. Setting and Monitoring Exadata using EM12c.
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
• Database Refreshing / Replication from production to testing using hot backup.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Designed and Implemented replication solution in Oracle Databases using Golden gate 11.1
• Setup Active-Active (bi-directional) replication using Golden gate with conflict resolution.
• Set up monitoring, auto start, and auto restart in bi-directional replication in Golden gate.
• Fixed performance issues in Golden gate by adding more processes and using Range distributions.
• Troubleshooting Golden Gate issues such as process abending, and lag on replication environments.
• Investigate Replication failures using Log Dump utility.
• Fixed performance issues in Golden gate by adding more processes and using Range distributions.
• Involved in Data Warehousing, Data Modeling, Database Design and Creation.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and STATSPACK snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Managed undo segments, processes, memory, online redo log files, data files.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Used Erwin software for data modeling.
• Created logical and physical design, installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN).
• Documented the Standard Processes for peers to follow.

Environment: AIX 5.3, HP-UX 11.31, Sun Solaris 10 and Red Hat Linux, Oracle 11g, 10g RAC, Exadata x3-2,3-8,TOAD, OEM, RMAN, ERWIN r7.1/7.2, Data Pump, oracle golden gate 10.x, 11.x, Diagnostic and Tuning Advisors, SQL*Plus, OEM, TOAD, RMAN, TKPROF, SQL Trace, STATSPACK, AWR, ADDM, Data Guard.

Confidential

Oracle Database Administrator

Responsibilities:

• Generate Explain plan and see flow of execution for sql statement.
• Creating and administrating high availability services in RAC environment.
• Administering RAC using SRVCTL and CRSCTL. Troubleshooting node eviction issues.
• Re-organization of tables to remove fragmentation.
• Performing Switchover/failover activity in physical standby database.
• Monitoring alert log files and diagnosing all the errors occurred in the Database.
• Configuring the listeners using DBCA and manually.
• Create Database links and Materialized views used retrieve data from remote database.
• Refreshing of production data to Dev/Test environments.
• Implemented and maintained physical standby database. Check the sync between primary and standby database.
• Applied Interim patch, CPU patch and PSU patches on production environments.
• Upgraded Database from lower version (10g) to higher version (11g r2).
• Load the data from a text file to oracle table using sql loader utility.
• Created and managed tablespaces, resize and add new data files.
• RMAN Backup validations which was scheduled to crontab.
• Generating AWR Report for database performance Health Check.
• Performed Database Cloning and refresh on to Test environment.
• Monitoring and maintaining Oracle cluster DB’s for their Optimal Performance and ensuing 100% availability of the DB’s.
• Created and managed tablespaces, data files, resizing and adding new data files etc.
• Created new user accounts, profiles, and roles and assigned them to different users.
• Monitoring alert log on time base for critical errors, and space utilization issues.
• Performed Installation, Configuration, troubleshooting, performance tuning and production support of Oracle 10g, 11g (Single Instance and RAC) databases on Sun Solaris, Red Hat Linux.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Installed and administered Real Application Cluster (10g, 11g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and STATSPACK snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.

Environment: Oracle 11g RAC/10g RAC, Sun Solaris, Red Hat Linux, PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, ERWIN, RMAN, ASM.