SUMMARY:

• Over 8 Years of experience as Oracle Database Administrator in Finance, Health & Insurance Oracle 12c, 11g RAC/10g RAC/9i/8i databases running on different environments such as Sun Solaris, HP - UX, AIX, Red Hat Linux, and Windows.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, Multi-Node RAC, Goldengate, Apex (module) capacity planning, shell scripting, and documentation.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very large-scale database environment and mission critical OLTP and OLAP systems.
• Experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Hands on Experience in Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle
• Excellent experience in migrating the Databases.
• Have training and practical experience on Mongo DB and AWS.
• Have experience on decommission a database.
• Worked on MMIS (Medical Management and information system)
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
• Hands on Experience in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC.
• Experienced at using Oracle Enterprise Manager/Grid Control (OEM/GRID CONTROL)
• Hands on experience in Java software development with emphasis on database-driven web applications
• Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACES, AWR, ADDM.
• Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
• Hands on experience as DB2 DBA for mainframes and AIX environments. Provided mentoring services in DB2 DBA, Data Modeling and Development.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.
• Experience in Providing Thorough support and problem resolution for customers.
• Experience in training new employees and explain protocols clearly and efficiently.
• Experience in Managing and maintaining the server, computers, Routers and Switches
• Experience in Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring.
• Migrated databases from Windows to Linux, Sun Solaris to AIX
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
• Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs.
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.
• Strong knowledge and experience of managing Oracle8i, 9i, 10g and 11g RAC environments using the OEM Grid Control tools.
• Have extensive experience in performance and tuning of OLTP and Datawarehouse applications.
• Data transferring with Export, Import, Data Pump and SQL Loader utilities.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks and used DBMS STATS to gather the statistics.
• 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 back up, incremental and cumulative backup.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Refresh/Cloning of Database and applications for development and testing purpose. implementing data layer access to Oracle databases for Web Applications
• Installation, Configuration, Performance tuning and administration of Golden Gate for real time data replication
• Have extensive knowledge Oracle Application Server Administration (WebLogic)
• Having good experience on Exadata 2.0, WebLogic 10.3
• Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service-oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Knows Perl scripting
• Worked as a DBA for Web Application Projects
• Participated Upgrade and Post Production Support of Oracle EBS in various applications like Banking, Billing, Payment.
• Knows Web logic environment
• Knowledge on Sybase working on the comprehensive set of database management software technologies that provide the crucial foundation for the Unwired Enterprise and enable you to manage and mobilize information from data centers to the point of action.

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i, SQL Server 2012/2008

Operating Systems: Sun Solaris, Red Hat Linux, AIX, HP-UX, Windows

Languages: SQL, PL/SQL, UNIX Shell Scripting, SQL Server 2005, 2000/7.0/6.5, Greenplum 3.3.4/4.2, PostgreSQL 9.0/9.1, DB2 8x UDB, Access and Sybase, JAVA, MongoDB, AWS

Tools: OEM, SQL Loader, EXP, IMP, EXPDP, IMPDP, TOAD, RMAN

Tuning Utilities: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH

Data Replication: Oracle Golden Gate, Exadata, Exalogic

Other: VERITAS Net Backup, Remedy

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, Dublin, OH

Responsibilities:

• Installation and Configurations of Oracle 12c, 11g, 10g.
• Installed Oracle 12c, 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.
• Upgraded Oracle Database from 9i to 10g, 10g to 11g (APEX module)
• Applied CPU patches
• Developed, tested, debugged and documented Oracle PL/SQL packages and types in accordance with company policies, company standards and industry best practices.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created and maintained PL/SQL scripts and stored procedures.
• Migration of the database from Sun Solaris to IBM AIX, Windows to Linux.
• Expertise in recovering the database. Performed complete and incomplete database recovery.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO)
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Supported customers with online billing and account issues.
• Maintained composure and patience in face of difficult customer situations
• Performed Schema as well as Table Level Replication using Oracle Golden Gate.
• Automated the nightly RMAN backups
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• PL/ SQL Programming.
• Developed PL/ SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Using the 12c Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both Catalog/ No catalog modes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Involved in implementing all components of the application including database tables, middleware designing, server-side Java Programming and client side web programming.
• Used PL/SQL extensively to generate Stored Procedures and Functions to use with JAVA
• Attended training sessions on Mongo db, Oracle 12c.
• Worked on Oracle security suite and identified and removed 16 risks from database.
• Worked on Amazon Web Services (AWS)
• Installed and configured Golden Gate in a prod and non-prod env, configured extract, data pump and replicate.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities)
• RMAN Incremental backups
• Logical and Physical Database Design
• Partitioning of the tables for better performance and manageability
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/ SQL tuning, Oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Provided production support for all DB2 mission critical databases and applications on 24X7 basis
• Performed data modeling and implemented database design to support the project planning process
• Experience in PostgreSQL
• Cloning databases using scripts as well as RMAN.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Created a new debt recovery infrastructure with Oracle Exalogic. Elastic Cloud and Oracle Exadata Database Machine that will help us gain greater business agility, enhance forecasting, reduce the down time of our debt collection process, improve recovery rates and reduce costs
• Strong Knowledge on writing Sql/DBA queries
• Supported Oracle E-Business suite applications
• Participated Upgrade and Post Production Support of Oracle EBS in various applications like Banking, Billing, Payment.
• Performed db. migrations form DB2 to Oracle11g.
• Table partitioning for better performance.
• Oracle Application Server Administration (WebLogic)
• Worked on Exadata environment
• Have good knowledge on Google Mapping ability to tie in graphical reports
• Knows Web logic environment and maintained database for web logic design projects
• Knowledge on Sybase working on the comprehensive set of database management software technologies
• Golden Gate installation and configuration.
• Replication using Golden Gate. (schema level),
• Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Perform on Sybase IQ Database Design

Environment: Oracle12c, Oracle 11g RAC, Oracle 10g RAC, Mongo dB, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Golden Gate Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD, SQL Developer, SQL Loader, ERWIN, Data Pump.

Sr. Oracle DBA

Confidential, Minneapolis, MN

Responsibilities:

• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Implemented Data Guard for Disaster recovery
• Setup and configure Standby database for high availability by using Data Guard.
• Migrated & upgraded databases from Oracle 10g to Oracle 11g
• Experience in SQL performance tuning using Cost-Based Optimization (CBO)
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Installed and implemented Golden gate to replicate data between databases.
• Replication using Oracle Streams.
• Documented instructions for migrating & upgrading databases.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Wrote various shell scripts to automate tasks.
• Knows MS SQL Server Enterprise Manager applications
• Creating PL/ SQL procedures for Extraction, Transformation and Loading of data
• Worked on PostgreSQL
• Created schema (tables, Indexes, views, sequences, synonyms, packages)
• Setup database auditing, granted privileges to users through system/object roles.
• Implement and maintain database security
• Assist management with scheduling, service protocol improvements, and quality assurance.
• Configured monitor tools to identify golden gate latency..
• Created db link for inserting large tables directly without taking export.
• Online index rebuilds
• Created PL/ SQL Procedures, Functions, Triggers.
• Taking Hot and cold backups.
• Modified Data Using Perl Scripting
• Worked on Mongodb for Java related applications.
• Weblogic 10.3 administration
• Creating and managing partitioned tables and indexes.
• Monitor and tune database performance using STATSPACK, AWR, ADDM
• Increased performance of sql queries by creating materialized views and by enabling query re-write.
• Perform decommission of a database operation implementing data layer access to Oracle databases for Web Applications

Environment: Oracle 11g RAC, Oracle 10g RAC, Mongo dB HP-UX, Golden Gate RedHat Linux, Sun Solaris, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD, SQL Developer, SQL Loader, ERWIN, Data Pump

Oracle DBA

Confidential, CA

Responsibilities:

• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Performed backup and recovery activities.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO)
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Daily database administration tasks including backup and recovery using RMAN, Import/Export.
• Managed and maintained the server, computers, Routers and Switches
• Troubleshoot various network issues affect solutions and collaborate with staff and outside vendors to resolve complex problems.
• Analyzed software hardware and network systems for various transmission systems.
• Designed the database schema and created any necessary database objects.
• Applied patches, upgraded databases
• Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL Trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Assist application developers to meet their day to day requirements related to performance.

Environment: Oracle 12c,11g, 10g, Linux, Solaris 5.10, Windows, Golden Gate, Shell scripting, RMAN, Data guard, SQL Loader, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, RAC, ASM.

Oracle DBA

Confidential

Responsibilities:

• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
• Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Load data into Oracle using SQL Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Creating users and roles for database and give the privileges.
• Performance monitoring and tuning using Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)
• Automated the Replication process using Materialized Views for reporting databases.
• Using the ADDM to analyze performance problem and with help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: locking, corruption, disk spaces and Performance issues.
• Cloning of production database to the test environment using Recovery Manager (RMAN)
• Created Standby databases for Disaster Recovery, using Data Guard.
• Load data using SQL Loader
• Backup and Recovery
• Created database objects like tables, views, indexes, partitions.
• Develop, document and enforce database standards and procedures.
• Setting Oracle Streams for replication between two databases.

Environment: Oracle 10g RAC, Oracle 9i, Sun Solaris, RedHat Linux, IBM AIX, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD, SQL Developer, SQL Loader, Data Pump

Oracle Developer/DBA

Confidential

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development databases from offshore.
• Installing, upgrade and configuring the Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Managing user accounts, Granting required privileges and profiles to users.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Monitoring the Database storage and Day to Day activities.
• Configured scripts to monitor activity with database.
• Cloned Environments to create Patch Test, Development and QA Environments.
• Partitioned large tables to increase the performance.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes and monitoring their growth rate.
• Data masking in dev, test and stage while refreshing from production DB.

Environment: Oracle 10g/9i, Sun Solaris, HP-UX, Windows, RMAN, Data guard, SQL/PL-SQL, HTML, STATSPACK, Shell Scripting, exp/imp, Data Pump