SUMMARY

• 12+ years of IT experience, out of which 9 years as an Oracle DBA in 24*7 environments on RHE Linux, Sun Solaris, and Windows.
• Installing and configuring Oracle Database on various LINUX and Windows servers.
• Strong Knowledge of 10g advanced features like ASM, AWR, ADDM and FLASHBACK.
• Database performance tuning (Oracle 9i, 10g, 11g), SQL tuning (using v$ tables, STATSPACK, TKPROF, OEM).
• Experience in design, implementation and maintenance of business applications as a Database Administrator of Oracle 11g,10g,9i,8i,8 and SQL 2000/2005.
• Extensive noledge with DB security administration.
• Well experienced with schema changes, database design, database backups, database reorgs, and migrations between instances, database upgrades and database tool upgrades.
• Maintain noledge of Oracle updates, patches, bug fixes or workarounds and relevant oracle releases.
• Creation of Standby Databases (data guard). Installing and Configuring Oracle Active Dataguards.
• Good understanding of 2/3 Node Real Application Cluster (RAC 10g & 11g).
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Trouble shooting and maintenance of RMAN Backups and user managed backups. Setting up RMAN backups for new databases and tuning of RMAN Backups for better performance.
• Worked on SQL performance and tuning for better response time. Used SQL tracing and tkprof for analyzing teh query. Worked on database performance issues. Used statspack and AWR reports for analyzing teh database.
• Installation and configuration of opensource RDBMS (MySQL & Postgres). Good understanding of MySQL Engines: InnoDB and MyISAM. Performance Tuning and monitoring of MySQL databases. Implementing Backup Strategy on MySQL databases.
• Creating security policies, roles, users and granting privileges.
• Very good in BI and Data warehouse - ETL concepts such as data mining, data integration, data cleansing, data transformation and data governance.
• Worked heavily on OLTP and OLAP Environments.
• Closely working with teh developers to create teh schema objects.
• Experience working on Oracle 10g OEM Grid Control and OEM Console for teh TEMPeffective DB administration.
• Good understanding of process, change management policies and coordination with multiple teams in a Global MNC environment.
• Experienced in various phases of Software Development life cycle, including Designing, Development and Testing as a Developer and Software Engineer.
• Providing assistance in logical/physical data modeling using ERWIN. Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Having good noledge of security standards like SOX. Well versed with HIPAA rules.
• Experience in Oracle GlodenGate installation, configuration, troubleshooting GG issues.
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Implementing database security using Auditing.
• Supported Teradata databases and OBIEE.
• TEMPHas very good experience working in Production Support (24*7) in Terabyte environment having tons of databases and providing rotating oncall support (24*7).
• Excellent Technical, Communicative, and Documentation skills.
• Continued learning and adaptability to any kind of Challenging Tasks.

TECHNICAL SKILLS

Operating systems: RHE Linux 5.5, Sun Solaris 10/8, HP-UX 11.0, IBM AIX, Windows NT 4.0/2003.

Databases: Oracle 11g, 10g, 9i, 8i/x, MySQL 5.x/4.x, SQL 2000/05/08, DB2.

Tools: OEM, SQL, PL/SQL, Expdp/Impdp, SQL Loader, Erwin, TOAD, SAP, Glodengate.

Languages: PL/SQL, XML, SQL, T-SQL, Java, VB 5.0, C, C++, CGI/PERL, JavaScript, C#.

DWH: Informatica, Talend 4.2/5.0, Teradata, Exadata, Microstrategy,Tableau, OBIEE.

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Sr Oracle DBA

Responsibilities:

• Evaluate h/w, capacity planning.
• Re-tolled backup and recovery strategy.
• Interpreting AWR, ADDM reports.
• Oracle RAC/ACFS implementation on 11gR2 database with Linux o/s.
• Performance Tuning of RAC databases/instances.
• Creating and maintaining database roles and privileges.
• Supported teh development team and created teh schema objects.
• Done teh query optimization as and when needed.
• Performed partitioning on large tables.
• Worked heavily on OLTP and OLAP Environments.
• Extensively used UNIX Shell (Korn) and PERL scripts for automating various processes.
• Used Flashback utility to restore teh erroneously deleted objects.
• Used Datapump utility instead of Export/Import.
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate.
• Trouble shooting and maintenance of RMAN Backups and user managed backups.
• Setting up RMAN backups for new databases and tuning of RMAN Backups for better performance.
• Used RMAN extensively for DB refresh based on Dev team needs.
• Worked on SQL performance and tuning for better response time. Used SQL tracing and tkprof for analyzing teh query.
• Worked on database performance issues. Used stats pack and AWR reports for analyzing teh database.
• Implemented Database Auditing.
• Extensive use of SQL commands with TOAD environment to create Target tables.
• Worked on SQL performance and tuning for better response time.
• Installing and supporting of open source RDBMS (MySQL).
• Good understanding of MySQL Engines: InnoDB and MyISAM.
• Performance Tuning and monitoring of MySQL databases.
• Implementing Backup Strategy on MySQL databases.
• Datawarehouse and ETL design. Gathering of Business and Reporting Requirements. Designing of teh STAR Schema. Identifying dimensions and fact tables and designing of teh data load process from production databases.
• Developed various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expression Transformations, Filter Transformations and Sequence Generator for loading teh data into target warehouse.
• Usage of Aggregator, SQL Overrides usage in Lookups and Source qualifiers and data flow management into multiple targets using Routers was extensive. Implemented teh SCDs for teh purpose of incremental loading of teh target database. Responsible for Debugging & Performance Tuning of teh mappings and sessions.

Environment: Oracle 10.2.0.5/11.2.0.2 , MySQL 5.5.11, RHE Linux, Windows 2008, Talend 4.2/5.0, Javascript, Java.

Confidential, Alpharetta, GA

Oracle Database Administrator

Responsibilities:

• Best practices and documentation to maintain standards across environment.
• Participated in Oracle RAC/ACFS implementation on 11g database with Linux o/s.
• Performance Tuning of RAC databases/instances.
• Re-tolled backup and recovery strategy.
• Worked heavily on OLTP and OLAP Environments.
• Worked on Oracle 11g OEM Grid Control and OEM Console for teh TEMPeffective DB administration.
• System monitoring and maintenance to ensure teh high availability.
• Setting up Data guard and provide all DBA support from Dev to PROD.
• Applying Database Patches and rolling upgrades on OS Windows, Linux and Solaris.
• Data refreshes through Oracle utilities such as EXP/IMP/SQLLDR.
• Helping Dev team to move database objects from Dev environment to PROD.
• Creating and maintaining database roles and privileges.
• Performed partitioning on oracle large tables.
• Has worked on 40+ TB Databases.
• Has teh working noledge of VERITAS.
• Worked on teh failover of Databases on VCS.
• Extensively used UNIX Shell (Korn) and PERL scripts for automating various processes.
• Used Flashback utility to restore teh erroneously deleted objects.
• Used Datapump utility instead of Export/Import.
• Database Migration across various OS and in between different databases.
• Performed Rolling upgrades and applying patches.
• Supported Exadata databases.
• Supported databases heavily on Solaris in a SAN Environment.
• Used RMAN extensively for DB refresh based on Dev team needs.
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Trouble shooting and maintenance of RMAN Backups and user managed backups. Setting up RMAN backups for new databases and tuning of RMAN Backups for better performance.
• Implemented database Audting for database security.
• Closely working with teh developers to create teh schema objects.
• Worked on SQL performance and tuning for better response time. Used SQL tracing and tkprof for analyzing teh query. Worked on database performance issues. Used stats pack and AWR reports for analyzing teh database.
• Installing and supporting of opensource RDBMS (MySQL & Postgres). Good understanding of MySQL Engines: InnoDB and MyISAM. Performance Tuning and monitoring of MySQL databases. Implementing Backup Strategy on MySQL databases.
• SQL Server Installation, backup and restore.

Environment: Oracle 10.2.0.5/11.2.0.2 , Solaris 10, Oracle EBS 11i, RHE Linux, Windows 2008, MySQL 5.0, Postgres 8, SQL Server 2008, Weblogic 10.3, Exadata, J2EE/Java.

Confidential, Edison, NJ

Oracle Database Administrator

Responsibilities:

• Participated in Oracle RAC 2 node implementation on 10g database with Linux o/s.
• Best practices and documentation to maintain standards across environment.
• Evaluate h/w, capacity planning.
• Re-tolled backup and recovery strategy.
• Interpreting AWR, ADDM reports.
• Worked heavily on OLTP and OLAP Environments.
• Worked on Oracle 10g OEM for teh TEMPeffective DB administration.
• System monitoring and maintenance to ensure teh high availability.
• Setting up Data guard and provide all DBA support from Dev to PROD.
• Applying Database Patches and rolling upgrades.
• Installed Oracle DBs on Vmware ESXi 4.0.
• Migrated Oracle Databases from 8i/9i to 10g.
• Data refreshes through Oracle utilities such as EXP/IMP/SQLLDR.
• Creating and maintaining database roles and privileges.
• Closely working with teh developers to create teh schema objects.
• Done teh query optimization as and when needed.
• Worked with XML Objects.
• Performed partitioning on oracle large tables.
• Extensively used UNIX Shell (Korn) and PERL scripts for automating various processes.
• Used Flashback utility to restore teh erroneously deleted objects.
• Used Datapump utility instead of Export/Import.
• Implemented database Audting for database security.
• Used backup, recovery and DB refresh based on Dev team needs.
• SQL Server Installation, backups and restore.
• Has teh working noledge of VERITAS.
• Experience in Oracle GlodenGate 10.4 installation, configuration, troubleshooting GG issues.
• GlodenGate replication implementation on Oracle 10g and 11g with Linux, HP-UX and Windows platforms.
• Supported Teradata databases and BI publisher.
• Supported databases heavily on Solaris in a SAN Environment.
• Involved in Data Extraction from Oracle, Flat files using Informatica.
• Prepared ETL flow of data from Staging to Data Mart.

Environment: Oracle 10.2.0.4/11.1.0.7 , Oracle EBS 11i, Solaris 10, HP-UX 11.0, Windows 2003, RMAN, OBIEE, Java, Weblogic 9.2, Microstrategy, SQL Server 2000/2005, MySQL 5.0, DB2, GlodenGate 10.4, Informatica 8.6, Teradata.

Confidential, Pasadena, CA

Oracle Database Administrator

Responsibilities:

• Evaluate h/w, capacity planning.
• Re-tolled backup and recovery strategy.
• Oracle Standby/Failover Administration.
• Done database cloning to setup Test & Development Databases.
• Used Flashback utility to restore teh erroneously deleted objects.
• Used Datapump utility instead of Export/Import.
• Performance Tuning of teh databases.
• Performed partitioning on oracle large tables.
• Design of Data Models using Erwin. Worked on designing of Dimensional Data Models.
• Helping Dev team to move database objects from Dev environment to PROD.
• Creating and maintaining database roles and privileges.
• Database Migration across various OS and in between different databases.
• Used Security features such as FGAC, Roles and privileges.
• Performing Various Backup (HOT&COLD) and Recoveries using RMAN.
• Hands on experience with ETL tool informatica.
• Good understanding of Data warehouse tasks such as data mining, data integration, data cleansing, data transformation and data governance.
• Having good noledge with creation of Metadata.
• Using teh Java Objects in teh Oracle Databases.

Environment: Oracle 9i/10g, Solaris 8.0, HP-UX, RHE Linux 5.3, J2EE, Weblogic, SQL/PL-SQL,OWB/ODI Informatica Power Center 5.0, Java.

Confidential, Dallas, TX

PL/SQL Developer

Responsibilities:

• Extraction of data from different flat files into Oracle Database using SQL*Loader.
• Gather Business rules from teh end users that are to be incorporated into teh system.
• Wrote PL/SQL Procedures, Functions and Triggers for insert, update, and delete transactions.
• Changed existing logic within teh packages for optimum Performance.
• Tested teh original and optimized codes thoroughly for failures before exporting to other environments.
• Used Korn Shell scripts Regular backup, instance start and shutdown and for automation.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.
• Tuned SQL by using Explain Plan, Indexing, partition pruning and Hints.
• Created number of database Triggers according to business rules using PL/SQL.
• Involved in code reviews of other team members.

Environment: Oracle 8i, PL/SQL, TOAD, SQL*Loader, PERL, HTML, XML, Crystal Reports,Javascript, Java.

Confidential

Oracle DBA/ Developer

Responsibilities:

• Done database cloning to setup Test & Development Databases.
• System monitoring and maintenance to ensure teh high availability.
• Worked on Backup & Recovery.
• Done SQL tuning at teh database level. Performed partitioning on oracle large tables.
• Design of Relational Data Models using Erwin.
• Helping Dev team to move database objects from DEV environment to PROD.
• Creating and maintaining database roles and privileges.
• Database Migration across various OS and in between different databases.
• Interacted with teh business users and collected teh requirements.
• Evaluated teh feasibility of teh requirements by analyzing teh source systems.
• Prepared BRS (Business Requirement Specifications) document that gives teh detailed information about teh requirements. Worked on physical Data Modelling.
• Involved in database development by creating PL/SQL Functions, Procedures, Triggers, Packages and Materialised views.
• Involved in Unit testing and integrated system testing.
• Created UNIX Shell scripts for automating teh execution process.
• Performed teh data migration using SQL* loader.

Environment: Oracle 8i, PL/SQL, Developer 2000, TOAD, SQL*Plus, Windows 2000 Professional, Perl/CGI, Javascript, J2EE, JAVA and UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in back end development and maintaining of oracle database.
• Developed and implemented Stored Procedures, Packages, Functions, and Database Triggers.
• Created Tables, Indexes, Constraints and improved database performance.
• Involved in tuning and applying teh SQL statements and PL/SQL processes.
• Enhanced teh existing UNIX scripts to achieve better performance and throughput.
• Involved in teh Daily maintenance of teh database that involved monitoring teh daily run of teh scripts as well as troubleshooting in teh event of any errors in teh entire process.

Environment: Oracle 8i, SQL, PL/SQL, HTML, JavaScript, Pro*C, Developer 2000, SQL Server, UNIX.