SUMMARY:

• 8 years of working experience in database administration, design, development, performance tuning, and high availability solutions, worked with variety of UNIX and Windows platforms with Oracle (12c/11g/10g/9i/8i). Highly competent in Administration, Monitoring and specialized in Advanced DBA skills such as Performance Tuning, Database Backup and Recovery, Data guard, Data Pump, RAC, Golden gate. My experience has scaled in providing Client support, analysis, testing development, installation, and migration.
• Installed, configured Oracle Enterprise Manager 10g, 11g Grid Control and 12c Cloud control to monitor Oracle databases on multiple platforms.
• Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access, Security and auditing.
• Experience with Exadata database support, patching, tuning and performance.
• Experience with RMAN, Oracle Enterprise Manager (OEM), RAC, OEM Grid control, Data warehousing, Oracle Data Guard.
• Extensive DBA experience in supporting multiple instances of ORACLE database including Development, Reporting, Data Warehousing, User acceptance testing & Production.
• Experience in using data pump import/export utility of ORACLE.
• Experience in deploying, managing and developing MongoDB clusters.
• Experience in database migration by designing and implementing database logical and physical storage structures.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Experience in optimizing database access and allocates/re - allocates database resources for optimum configuration, database performance and cost.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Applying oracle patches (CPU, PSU and ONE-OFF), upgrade and migration of databases using the OPatch utility and fixing bugs.
• Installed and configured oracle Grid control and deployed agent on managed targets.
• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Worked in various environments like Linux, HP-UX, Sun Solaris, and Windows.
• Hands on experience on Oracle GoldenGate Implementation and Maintenance.
• Proficiency with Installation and maintenance of replication tool GoldenGate by creating extract process, extract pump, and replicate. Proficient with installing, configuring, administering, using and benchmarking SQL solutions.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• I used Oracle Middleware Products includes WebLogic Server and experienced in the Oracle PL/SQL programming language.
• Experience with Oracle Streams to replicate or migrate data from one system to another and Oracle EBS administration.
• Solid experience in disaster recovery, 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, cumulative backup and implementing backup and recovery strategies.
• Upgrading and Migrating Databases from lower versions to higher versions.
• And experience with Database Monitoring tools and worked in production environment.
• Experience in analyzing database & rebuilding indexes to improve the oracle database performance along with database tuning.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, UNIX Shell Scripting and Perl scripting.
• Experience with understanding and executing Data Manipulation Language (DML) scripts for Oracle.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Worked with Oracle Ebusiness Suite patching and cloning.
• Expertise in working with the tools like OEM, TOAD, SQL Analyzer and managed system events by using OEM.
• Experience in conversion of Single Node Instance to Multi node RAC with ASM, and adding instance to existing RAC.
• Performance Monitoring and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self-developed scripts, Oracle Enterprise Manager.
• Technical Support for Oracle, including management of databases, concurrent managers, listeners.
• And I had managed skills in all aspects of the physical database including schemas, DDL, users, security in development, UAT and production environments.
• Excellent interpersonal and problem-solving skills together joined with strong customer service attitude.
• Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables.

TECHNICAL SKILLS:

Operating Systems: Oracle Linux, Red Hat Linux, Solaris 8/9/10, HP-UX, AIX 5.2/5.3/6.1/7.1, Windows NT/2000/2003/XP/2008/vista/7

Database s: RDBMS Oracle 8i/9i/10g/11g/12c, SQL SERVER 2005 and 2008, MySQL, MongoDB.

Languages: SQL and PL/SQL programming for oracle, C, C++, UNIX/NT Shell Scripting, PERL Scripting.

Tools: and Utilities: Recovery Manager RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations, GoldenGate, Database Configuration, Database Upgrade, ASM, AWR, Oracle Enterprise Manager(OEM)

Tuning Tools and Monitoring: TKPROF, EXPLAIN PLAN, SQLTXPLAIN, STATSPACK, ADDM, AWR, and ASH, AUTO Trace. Oracle Cloud Control 12c, Grid Control 11g, BMC Patrol, Diagnostic Tool.

Other Tools: OEM, TOAD, SQL Loader, MS Office, MS Project, XML/BI Publisher, Workflow Builder, Data Guard and VM box, Exadata

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. Oracle DBA

Responsibilities:

• Installed and configured Oracle Database Software 11g, 12c on Linux operating system and responsible for administering and monitoring Oracle 12c/11g/10g OLTP Production, Development, and other environment databases.
• Provided 24x7on call production support for ORACLE, MySQL and SQL Server Databases.
• Installation, Configuration and Maintenance of Oracle 11g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on ASM.
• Installed, Configured and managed 11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Successfully maintained multiple databases. Experienced in working with tools like TOAD.
• Installed and configured one to one GoldenGate replication and resolved out of sync issues. Handling GoldenGate replication issues which are responsible for out of sync in Test environment.
• Successfully installed and configured Oracle GoldenGate for Replication in Development and Test environment.
• 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. And expert in Monitor and fine tuning the Exadata Database Machine Hardware.
• Worked on MongoDB database concepts such as locking, transactions, indexes, replication, and schema design.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Created automated file feeds for other interacting systems and developed automated report generation scripts using Perl scripting.
• Experience in reading and writing xml reports with Perl XML modules and Cleansing data generated from weblogs with automated scripts in Perl
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Upgraded Oracle 10g Applications Database to 11g on Linux. Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
• Created OEM jobs for automatic monitoring, differential backup and full back up.
• Upgraded Oracle GI and RDBMS from 10.2.0.3 to 11.2.0.4 on Linux.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database. Performed replication using Oracle Streams and GoldenGate Technology.
• Designed and implemented backup and Disaster recovery strategies with RMAN. Performed logical backup using traditional export/ import and Data Pump.
• Involved in data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams. Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Successfully installed and configured Oracle GoldenGate for Replication in Development, Test and Production environment.
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and used data pump jobs for loading the subscriber and history related data at replicated site.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training.
• Implement Stored Procedures and Triggers based on business plans using PL/SQL.
• Performing conceptual data modeling, data analysis, data profiling, data mapping and implementation for product integration with client's applications.
• Providing database administration support for application development teams for Maintenance, backup and Emergency software releases.

Environment: Oracle 12c, 11g Grid Infrastructure, MongoDB, Perl Scripting, Oracle 11g RAC and Standalone, Exadata, 11g ASM, 11g Grid Control, Oracle 10g, Linux, HP-UNIX Windows, DBCA, OEM Grid Control, HP Data Protector, SOA Suite 11.1.1.3, Oracle Data Guard, TOAD, Solaris 11, GoldenGate, Oracle Database Backup, Data Pump, Tuning, SQL* Loader.

Oracle Database Administrator

Responsibilities:

• Installed and maintained Oracle 11g/10g/9i databases for testing, development and production on Linux, HP-UX and Windows.
• Planned for database performance for maintaining huge data volume 60 TB database.
• Support and maintenance of 200+ oracle databases (10g, 11g) and 200+ instances.
• Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Responsible for Implementation of Oracle 11g Grid Control and configured nodes for proactive monitoring.
• Used Oracle Streams for replications of data between remote databases, monitoring and Troubleshooting of Database Replication issues.
• Knowledge on Exadata, Creating a storage index, tuning the parameters, Involved in migrating Databases to Exadata.
• Performance tuning and testing of NoSQL database environments in order to ensure acceptable database performance in production mode. Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability.
• Writing Perl scripts to provide an interface between the CGI web pages and database for various modules of the release tool.
• Fixed errors and various bugs with necessary alterations to Perl scripts and managed batch in UNIX for data automated import and export of data using Perl Scripts
• Performed performance tuning by using Explain Plan, Statspack, AWR, ADDM and ASH.
• Performed cold backup, hot backup using conventional backups and RMAN, recovered various development and critical Production databases.
• Installed and configured oracle 10g and 11g Management Agent and cloned it to the multiple nodes.
• Maintained data guard to provide high availability by implementing physical stand-by database and snapshot-standby databases.
• Configure ASM and handling issues and suggesting feasible workarounds for ASM Metadata corruption. Implemented and monitored 10g RAC Logical Standby database for reporting.
• Setup and monitored multi node RAC to RAC Data guard with real time apply for DR and offload backups.
• Implemented and administered Oracle Golden Gate for Database Replication between production and reporting node, by using Oracle Streams.
• Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC.
• Participated in implementation of High Availability solution based on the failover process supported by Veritas Cluster Server. Supported database activities using Cluster Manager GUI, administered shutdown/startup process for databases, listeners.
• Moved databases from one clustered server to another for maintenance purposes. Mounted/dismounted file systems.
• Reading Alert Logs and User trace Files for diagnosing the Problem.
• Performing object storage management and capacity planning using precise software and Stats pack.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development. And provided full DBA support for Oracle Applications in Production, Test and Development environments.

Environment: Oracle 11g, 10.2.0.x, 9.2.0.x, GoldenGate, MongoDB, Perl Scripting, Exadata, Data Guard, RAC, Recovery manager (RMAN), Harvest, statspack, AWR, ADDM, OEM 10g, 11g, Solaris, Windows, IBM AIX 6.1,PL/SQL, TOAD, shell scripting.

Sr. Oracle DBA

Responsibilities:

• Worked as production support, maintaining Production and Development Oracle databases.
• Supported databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Installed and configured Oracle 11g databases on HP-Unix and AIX.
• Installed and configured Oracle RDBMS on UNIX and Windows environments. Created primary database storage structures.
• Create and maintain DB templates, RAC environments,
• Involved in database administration including 11g RAC Database cloning, tuning, patching and monitoring concurrent manager processing.
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Migrated standalone databases on AIX/Solaris/Windows and file system to Linux RAC on ASM.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Initiated 10g new feature implementations such as Automatic Storage Management, Flashback features, DBMS Scheduler, ASMM to improve performance and manageability.
• Integrating Oracle Applications 11i with OID/SSO.
• Setting up Physical Standby Database environment using Data guard in Oracle 9i, 10g and 11g.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
• Managed and monitored grants, roles, privileges to users, analyzed tables to generate and gather stats including verifying daily backup logs and alert logs.
• Reorganized databases and Sizing of database objects for effective space management and optimal performance. Oracle Database and Oracle Applications cloning/refresh.
• Create and troubleshoot DB Link’s issues in Oracle for communicating with external databases.
• Done performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Managed undo segments, processes, memory, online redo log files, data files.
• Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Configured and installed one to one replication using GoldenGate between heterogeneous environments.
• Performing all daily maintenance tasks. Interacting with Oracle Customer service as and when required.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

Environment: Oracle 11g,10g,9i, 11g Grid Infrastructure, Oracle 11g RAC, 11g Grid Control, Oracle 10g , HP-UNIX, AIX, Windows, RAC, Data Guard, TOAD, ASM, VERITAS Net Backup, RMAN, Solaris 10, GoldenGate, STATSPACK, SQL* Loader, SQL/PLSQL.

Oracle Database Administrator

Responsibilities:

• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installed and configured oracle10g database and created databases manually.
• RAC installation and configuration for 4 node cluster.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Performed database cloning/export/import to setup identical databases in the production and development environments.
• Installed, Configured and Managed Oracle 10g on HP-UX and IBM-AIX environments for production, test and development.
• Starting and stopping of database/concurrent/application during maintenance, verification of the system after successful application of patches/builds.
• Analysis and application of oracle quarterly patches in dev/ production.
• Experience with Oracle RMAN and Veritas Net Backup
• Performed Logical backups at schema level using Export/Import.
• Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points
• Installation of Oracle 10g/9i software on various platforms like Red Hat Linux Adv.
• Review alert logs and dump files to check for any problems related to the database/users.
• Identifying Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine-tuned for better performance.
• Created users and set permissions, and managing database security using groups and roles.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database. And writing scripts for the system and database for the effective functionality and report generation.
• Supported different databases like Production, Development, Testing, and Training.
• Co-ordination has been extended to Application developers for coding to improve the performance of the database.
• Database refreshes, environment configurations, and troubleshooting.
• Resolving database storage management issues.
• Performing the logical and physical structures for tables, indexes, modeling, normalization and foreign key constraints.
• Provided all kinds of DBA support to development teams as well as production support to various applications.

Environment: Oracle 10g/9i, Solaris, RHEL, Windows, Data guard, RMAN, SQL Navigator, TOAD, OEM Grid Control, RAC, STATSPACK, Oracle 10g streams, oracle partitioning, SQL*LOADER, PL/SQL, Scripting.

Oracle DBA

Responsibilities:

• Installed, Configured and Managed Oracle9i on HP-UX and IBM-AIX environments for production, test and development.
• Upgraded databases from Oracle 8i to 9i. Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Monitoring of hot backups, exports on Linux and Windows.
• Performed Refresh of databases on Linux servers
• Write various SQL and PL/SQL scripts and procedures to support applications.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.
• Performed database cloning to create Test and Development environments from Production.
• Created and maintained materialized views.
• Modified and debugged stored procedures and triggers.
• Interacted with the users and troubleshoot the problems related to the privileges & resources.
• Monitor database activity and file usage, and ensure necessary resources are present, so that databases function properly by removing or deleting old or obsolete files.
• Performing all the Database Administration activities like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Monitoring the test database as well as the production database
• Created and managed tablespaces monitored the data files space, resizing and adding new data file.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimated growth of database size by detail analysis of the company’s future policies.

Environment: Oracle 9i, RHEL, Window 2003, Oracle Enterprise Manager, HP-UX, IBM-AIX, STATSPACK, TOAD, RDBMS, RAC, RMAN, PL/SQL.

Pl/SQL Developer

Responsibilities:

• Installation, Configuration and Administration of SQL Server 2005/2008 on Windows 2003 Servers.
• Expertise in ETL tools and created reports in Oracle Discoverer by importing PL/SQL functions on the Admin Layer to meet the client requirements.
• Design and developing database code using PL/SQL programs, Java Programming
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Ref Cursors, Constraints, Database Links, UTL file and Triggers for Oracle Relational Databases.
• Extensively worked with third party database tools like SQL Developer, Toad and Pl/SQL Developer
• Performed Database backups (operating system, flat file backups & export/import).
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Implemented bulk programming and for all technics to improve the performance of the procedure executions.
• Extensive experience in developing Data Extraction, Data Transformations, Data Loading (ETL) projects.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys and foreign keys.
• Worked on Active/Active and Active/Passive Clustering.
• Worked on series of PL/SQL validations which checks the Employee Type, Payroll Type and Assignment is present for the employee for that Reporting year.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, Records, Types and Dynamic SQL for DML operations for better performance
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: SQL Server 2005/2008, Pl/SQL, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Windows 2003 Server.