SUMMARY

• 12+ years of IT experience, out of which 8+ 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 knowledge 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 knowledge of Oracle updates, patches, bug fixes or workarounds and relevant oracle releases.
• Creation of Standby Databases (data guard).
• Good knowledge working with Oracle Streams.
• 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 the query. Worked on database performance issues. Used statspack and AWR reports for analyzing the 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.
• Associated with different projects and has a good understanding of the programming techniques using Quality-Driven Methodologies.
• Experience working on Oracle 10g OEM Grid Control and OEM Console for the effective 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 knowledge of security standards like SOX. Well versed with HIPAA rules.
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Has 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, APEX 4.0, Goldengate.

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

DWH: Informatica, Talend 4.2/5.0.

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Sr DBA & ETL Developer

Responsibilities:

• Datawarehouse and ETL design.
• Gathering of Business and Reporting Requirements.
• Designing of the STAR Schema.
• Identifying dimensions and fact tables and designing of the data load process from production databases.
• Creating and maintaining database roles and privileges.
• Performed partitioning on large tables.
• Designed and Implemented the ETL Process using Informatica power center & Talend Open Studio.
• Involved in Data Extraction from Oracle & Flat files using Informatica & XML files using Talend by using Java as Backend Language.
• Prepared ETL flow of data from Staging to Data Mart.
• Developed various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expression Transformations, Filter Transformations and Sequence Generator for loading the 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 the Slowly Changing Dimensions for the purpose of incremental loading of the target database.
• Responsible for Debugging & Performance Tuning of the mappings and sessions.
• Extensive use of SQL commands with TOAD environment to create Target tables
• Implemented Talend to Extract data from .csv files & to load into MySQL database & Generated Reports via Microstrategy.
• Worked Extensively on scheduling the Talend Jobs using crontab.
• Implemented SCD type 2 via Talend (Using Joiners Itself).
• Extensively used UNIX Shell (Korn) scripts for automating various processes.
• Used Datapump utility instead of Export/Import.
• Database Migration across various OS and in between different databases.
• 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.
• 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.

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

Confidential, Alpharetta, GA

Oracle Database Administrator

Responsibilities:

• Best practices and documentation to maintain standards across environment.
• Participated in Oracle RAC/OCFS2 implementation on 11g database with Linux o/s.
• Performance Tuning of RAC databases/instances.
• Re-tolled backup and recovery strategy.
• Worked on Oracle 11g OEM Grid Control and OEM Console for the effective DB administration.
• System monitoring and maintenance to ensure the 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.
• Have worked on 40+ TB Databases.
• Extensively used UNIX Shell (Korn) scripts for automating various processes.
• Used Flashback utility to restore the 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.
• 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.
• Worked on SQL performance and tuning for better response time. Used SQL tracing and tkprof for analyzing the query. Worked on database performance issues. Used stats pack and AWR reports for analyzing the 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, RHE Linux, Windows 2008, MySQL 5.0, Postgres 8, SQL Server 2008, Weblogic 10.3.

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 on Oracle 10g OEM for the effective DB administration.
• System monitoring and maintenance to ensure the 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.
• Worked with Streams to replicate the data.
• Performed partitioning on oracle large tables.
• Extensively used UNIX Shell (Korn) scripts for automating various processes.
• Used Flashback utility to restore the erroneously deleted objects.
• Used Datapump utility instead of Export/Import.
• Used backup, recovery and DB refresh based on Dev team needs.
• SQL Server Installation, backups and restore.
• Supported DB2 Databases.

Environment: Oracle 10.2.0.4/11.1.0.7 , Oracle EBS 11i, Solaris 10, HP-UX 11.0, Windows 2003, RMAN, J2EE, Weblogic 9.2, Javascript, APEX, SQL Server 2000/2005, MySQL 5.0, DB2.

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 the erroneously deleted objects.
• Used Datapump utility instead of Export/Import.
• Performance Tuning of the 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 knowledge with creation of Metadata.

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.

Confidential, Dallas, TX

PL/SQL Developer

Responsibilities:

• Extraction of data from different flat files into Oracle Database using SQL*Loader.
• Gather Business rules from the end users that are to be incorporated into the system.
• Wrote PL/SQL Procedures, Functions and Triggers for insert, update, and delete transactions.
• Changed existing logic within the packages for optimum Performance.
• Tested the 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.

Confidential

Oracle DBA/ Developer

Responsibilities:

• Done database cloning to setup Test & Development Databases.
• System monitoring and maintenance to ensure the high availability.
• Worked on Backup & Recovery.
• Done SQL tuning at the 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 the business users and collected the requirements.
• Evaluated the feasibility of the requirements by analyzing the source systems.
• Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the 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 the execution process.
• Performed the data migration using SQL* loader.

Environment: Oracle 8i, PL/SQL, Developer 2000, TOAD, SQL*Plus, Windows 2000 Professional, Perl/CGI, Javascript 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 the SQL statements and PL/SQL processes.
• Enhanced the existing UNIX scripts to achieve better performance and throughput.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

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