PROFESSIONAL SUMMARY:

• 8+ years Professional IT working experience in system Design, Development, Administration and Maintenance of mission critical applications in enterprise and production environment.
• Experience in planning, design, install, configure, perform upgrade and maintain oracle 9i, 10g, 11g (release 1 and 2) and 12c across multiple platforms, like Solaris, RHEL, UNIX, AIX, HP - UX.
• Proficient in Install, upgrade, clone, administrate, patch and troubleshoot oracle databases.
• Thorough knowledge of various Oracle tools like OEM with management pack, RMAN, SQL Loader, TKPROF, Statspack, AWR, ASH, ADDM TOAD, SQL trace to perform day to day job.
• Proficient in installation, configuration, administration, patching and maintenance of ORACLE 10g/11g/11gr2/12c RAC multi-node cluster and add/remove node as per need.
• Extensive experience in configure, implement, maintain and troubleshoot errors of physical and logical standby databases Data Guard .
• Proficient in installing and maintaining Golden Gate for warehouse and high availability.
• Extensive experience in installation and maintenance of OEM 11gr2/12c Database & Grid control for database monitoring, performance and diagnostics.
• Experience in oracle database administration and management on Exadata Platform.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flashback Technology, Log Miner.
• Experienced in Installation, Implementation and configuration of SSO with OID Server.
• Extensive experience with logical and physical data modeling and database design using Oracle Designer, DBArtisan and Erwin.
• Backup and Recovery strategy development (hot / cold) and implementation with through understanding of Database Recovery Scenarios.
• Proficient in UNIX and Linux Shell Scripting, Oracle Net, TCP/IP, Stored Procedures, Functions, Cursors, Triggers and PL/SQL programming.
• Extensive experience in Security management, performance monitoring/tuning/troubleshooting on various levels, storage management, data migration from other databases to Oracle, Oracle/Crystal Reports and Cloning & Replication of Oracle Databases.
• Hands on experience on other various RDBMS databases like MySQL, MSSQL and Sybase, also little exposer to Cassandra NoSQL database.
• Extensive experience on 24X7 Production environments for large databases using database solutions such as OEM, RMAN, Data Guard.

TECHNICAL SKILLS:

Tools: DBCA, TOAD, OEM Grid Control, RMAN, RAC, Erwin, Quest Central, PL-SQL Developer, OWB, DB Tools, Internet directory OID, DBArtisan, OTM, TSM, TDP, GoldenGate.

DBMS: Oracle 10g, 11gR1/2, 12cR1 DBA, Exadata, MSSQL, Sybase, MS Access, MySQL.

Languages/Platforms: Forms/Reports, Designer, Import/Export/DataPump, SQL*Loader, PL/SQL for Oracle, C/C++, JAVA, Perl/Shell programming

Operating Systems: RHEL, UNIX, IBM-AIX, Sun Solaris, HP-Ux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Database Administrator

Environment: Oracle 11gR2, 12c, Sybase, AWS Postgress SQL, Golden Gate, RHEL, Solaris, Data Guard, Autosys, Toad

Responsibilities:

• Modified and troubleshoot Shell scripts, DB Monitoring scripts to accommodate Solaris and Database upgrade changes.
• Providing application deployment and database build support.
• Performed QA for oracle 12c upgrade and patching.
• Used Oracle RAT for 11gR2 to 12c Upgrade performance testing POC.
• Providing assistance in troubleshooting data guard issues
• Performing data refresh through data pump, RMAN & Active database for Development team.
• Worked closely with project managers, programmers and testers to database integrity and security and generated test data and tested new database consistency with existing database to meet the functionalities requirements.
• Providing support to release management for new release updates and issue troubleshooting.
• Providing 24x7 support to incident and change management during on call for Production-PreProd environment support.
• Created Procedures and packages based on requirements, for example compression, ddl-system grants, etc.
• Written scripts for proactive & reactive monitoring and reports for database table space usage/history, oracle alert, re-occurring incident/problem reduction.

Confidential, Roseville, CA

Oracle DBA

Environment: Oracle 8i, 11gR1/2, 12cR1, Grid Infrastructure 11gr2, 12cR1, MSSQL 2k3/8, Golden Gate, RAC, Exadata, Data Guard, RMAN, OMS 12c, Tuxedo, WebSphare, Weblogic, JAVA, OBIEE, Toad, SQL Developer, Erwin, Oracle on RHEL 5/6, HP-UX, AIX, Windows.

Responsibilities:

• Performed fresh Installation, Configure, Administrate and Maintained Oracle 11gr2/12cR1 databases.
• Participated in oracle 12c upgrade, administration and golden gate from oracle.
• Performed Oracle Grid Infrastructure, database upgrade from 11gr2 to 12cR1 by command line and Golden Gate.
• Created step by step instruction checklists/documents for database design, installation, patching, upgrade and administration for Dev/SysTest/UAT/TRN/PROD Environments.
• Worked closely with project managers, middleware team, testers and developers to provide best application performance.
• Performed database and SQL tuning to lessen performance impact after oracle 12c upgrade.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Performed installation and maintenance of ORACLE 10g/11gr2/12c on multi-node RAC.
• Configured and maintained Production database replication to client site using Golden Gate from Production databases to various DBMS like Oracle on Exadata, MSSQL and MySQL.
• Provided assistance to client in database installation, administration and maintenance for target site for Golden Gate.
• Performed installation and management of weblogic, Database, OBIEE and set up CDC for client to provide real time data for reporting project.
• Worked with developer team to fix application issue and deployed java backend codes.
• Performed adding/removing a node on test server cluster for production POC and added node on Production Environment for high availability.
• Used data-guard to minimize downtime in Production server upgrade project.
• Used active database, ASM Copy, RMAN and Data Pump to copy/create database for development/testing team.
• Involved in designing, assembly and tuning of database for development teams.
• Performed installation, upgrade, patching and configuration of OEM Cloud Control and Agents for database, RAC monitoring and data masking.
• Scheduled auto maintenance and corrective actions jobs in OEM to reduce maintenance efforts.
• Supported Dev-UAT-PRD Environments with regards oracle installation, configuration, patching, database backups and assistance to developer with oracle and OWB issues, also add, remove, configure, support OWB workspace and troubleshoot OWB services when necessary.
• Written K/Bash shell scripts for auto monitoring, backup validations and other corrective action tasks for production and client environments.

Confidential, Cupertino, CA

Oracle DBA

Environment: Oracle 11g (11.2), Oracle Application Release 11i, MySQL, Oracle Data Modeler, SQL Developer, Erwin, FileMaker Pro, WebLogic, Oracle on Linux, MySQL on OS X.

Responsibilities:

• Performed fresh Installation, Configure and Administrate Oracle 11gR2 and MySQL 5.6.
• Supported the application and GUI team to design and develop data models for the current and future CRM applications.
• Develop documentation related to design, build, deploy and maintenance best practice for Dev - Prod - CRM databases.
• Design / Develop / Deploy logical and physical model into various environments to support application Dev-Prod-CRM launch related activities
• Performed Change Control Process for Oracle & MySQL Databases.
• Prepared documentation, following process and procedures.
• Created and modified triggers, cursors, functions and procedures.
• Experienced with logical and physical data modeling and database design using Oracle Data Modeler.
• Performed migration between MySQL-Oracle and loaded the data.
• Performance Tuning at DB level, OS level and Object level.

Confidential, Buffalo, NY

Oracle DBA

Environment: Oracle 11g (11.2), MSSQL, Red Hat Linux, IBM-AIX, Win 2000 Advanced Server, Oracle Designer, PL/SQL, OEM, RMAN, RAC, Golden Gate, Erwin, OLTP, ADDM, AWR.

Responsibilities:

• Checked configuration and performance of existing including data file allocation, index, fill factor, fragmentation and impact on system performance.
• Analyzed and tuned the DB to identify potential database issues such as response delay, locking contention, even server down time by using tools like Statspack, explain PLAN and TKPROF.
• Monitored and tuned database to optimize the performance and satisfy the availability requirements of multiple applications using (STS) SQL Tuning Set and (STA) SQL Tuning Advisor. Analyzes the data by (ADDM) Automatic Database Diagnostic Monitor in the (AWR) Automatic Workload Repository.
• Created the new database objects compiling with (OFA) Optimal Flexible Architecture.
• Modified existing database structures layout such as disk configuration and storage allocation to enhance application performance.
• Provided suggestions to server administration team regarding disk configuration, RAID according to database sizing and capacity planning. Fully utilize Metalink to maximize Oracle support.
• During On-Call rotation maintained day-to-day production support for all DBMS like Oracle, MSSQL and MySQL thereafter, check alerts, activity logs, error logs, Tune Long running SQLs also capture any possible errors to ensure the databases health.
• Migrated databases of windows server to UNIX servers for new application integration.
• Devised, developed and implemented sophisticating backup recovery strategy using RMAN with VERITAS and designed/implemented disaster recovery test.
• Performed implementation, performance tuning and troubleshooting of GoldenGate for Data Warehouse and High Availability of Production databases.
• Developed and implemented database maintenance procedures.
• Capacity Planning for both OLTP and Data mart - Allocating system storage and planning future storage requirements for the existing and new databases.

Confidential, Louisville, KY

Oracle DBA

Environment: Oracle 11g/10g/9i, Oracle 11i, IBM AIX, WebLogic, PL/SQL, Data Guard, Import Export, TOAD, LDAP, RMAN, JIRA, Erwin, Shell Script, DBArtisan.

Responsibilities:

• Performed fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Project and Version management using PVCS Version Manager and Checking DDL, DML’s and Stored procedures in PVCS.
• Database Builds Handling and migrations from CUT (DEV)-ETE (QA)-DR (deployment readiness) and Production. Propagates synchronized database builds to different channels in pre-production environments.
• Created master build script for data migration for DR and Production and providing scripts to infrastructure DBA’s.
• Archiving large tables and provides access to business and also increase the performance on archiving tables.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Performance testing (Stress testing) of third vendor applications for DB parameter settings, capacity planning (Memory, Space, CPU) and SQL tuning.
• Table Reorganization and recalculating/sizing the storage parameters for database objects to reduce fragmentation.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5 production databases and few development databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
• Good knowledge in Oracle utilities including export/import, SQL*PLUS. Data loading using SQL Loader.
• Performed export and import of database objects in order to copy them from one database to another & for backup the tables.
• Setup SOX auditing on financial tables using Oracle FGA (Fine grain Auditing).
• Installed, Implemented and configured Single Sign on (SSO) with OID Server.
• Involved in integration of Oracle Application Server 10g components like single sign-on/Portal/Discoverer/Oracle Internet Directory (OID) with oracle applications 11i.
• Implemented AQ (Queues Tables & Procedures) for job scheduling orchestrator (In-house app).
• Monthly Maintenance Week for reorganizing database and Clearing/Purging Old files/Data.
• Done storage management of Tablespaces, Rollback/Undo segments & Data segments by writing scripts on different data dictionary tables. Managed Space, Monitoring Free Space, and Chained Rows etc.
• Daily monitoring of ALERT log & Trace files of the database.
• Separating of tables and indexes on different locations, reducing disk I/O contention etc. applications tuning of database using Explain Plan, TKPROF, SQL Trace, Analyze, Hints.

Confidential, Hoffman Estates, IL

Database Administrator

Environment: Oracle 11g/10g, ASM 10g, CRS, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, WebLogic, Java, Data Pump, DBArtisan, Toad, VERITAS Net Backup, OTM.

Responsibilities:

• Installed, configured and maintained Oracle 11g R2 on Linux also upgraded from Oracle 10g to 11g.
• Involved in Building efficient database system using Oracle, WebLogic and Java. Performed Installation, Configuration and issue troubleshooting of WebLogic.
• Worked with Developer team to trouble shoot application issue and java programs.
• Configured, maintained and troubleshoot issues of Oracle Data guard.
• Production support in planning, reporting and performance for OTM.
• Administer and monitor all databases with help of DBArtisan
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Oracle streams AQ (Advance Queuing) in integrated application environments.
• Configured and implemented Oracle Streams (AQ) for high availability.
• Configured and back up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Experienced in dealing with Query execution plan, SQL trace, TKPROF.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Performed gathering requirements from end users.

Confidential

Database Administrator Intern

Environment: Windows 2003 server, oracle 10g, 11g, ASP 3.0, PHP2, XML, MS SQL Server 2000 (Enterprise Manager, Query Analyzer), TSQL, Erwin 4.0.

Responsibilities:

• Installed, configured and maintained Oracle 10g on Linux also upgraded from Oracle 10g to 11g.
• Implemented Oracle Database 10g two node Real Application Cluster (RAC) using Oracle Cluster-ware and was responsible for high availability and load balancing.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Created and modified procedures, triggers and functions.
• Created all administration tasks of SQL Server and designed database.
• Used system stored procedures and DBCC commands.
• Planned Replication set up for banking software between SQL Server 2000 and local access database.
• Created DTS package to export and import data from SQL Server to Access, text files and Excel files.
• Set up backup using Veritas, checking event viewer on Windows Server 2000/03 and developed recovery procedures.
• Proficient in Windows Server 2003, Windows XP, Linux, OS2 operating systems
• Knowledgeable in Microsoft Exchange, MS SQL, MySQL, IIS, VPN, RAS, FTP Servers
• Active Directory administration, user logon scripts
• Security administration over web servers, mail servers using SSL sockets, firewall
• Created DTS packages for migration of data from SQL Server to MS Access or Oracle databases.
• Created automatically running stored procedures for day-end operation using SQL Server agent.
• Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
• Created and supported complex database schemas
• Designed data models
• Implemented Microsoft SQL 2005 Server in a test environment.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.