SUMMARY:

Over 20 years of experience as Oracle DBA on 24*7 systems, Developer, Performance Tuning expert, Database Architect and SME. Expertise in designing Data Marts, Data Warehouses and ETL processes. Expert in Data Migration strategies. Worked in Banking, Airline, Telecom, Manufacturing, Web search, Data Processing, Gas & Power/Trading industries.

TECHNICAL SKILLS:

RDBMS: Oracle 7x - 11g, SQL Server 2005, MySql, Mongo Db, Couch Db, Postgresql.

Features: RAC, ASM, Dataguard, Golden Gate.

Database Tools: OEM, Erwin, TOAD, RMAN, Veritas Netbackup.

Data Analytics: Sql, Pl/Sql, Hive, Pig, Python, R

Data: Mining Machine learning algorithms’ implementation in Python & R

ETL Tools: Informatica, Cognos, Business Objects

ERPs: Oracle Ebusiness Suite

Languages: PL/SQL, Shell scripting, Perl, Java, Hive, Pig, Python, R

CRMs: Affinium, Epiphany, Siebel.

O/s: Sun Solaris, HP UNIX, AIX, True64, Linux, Win2008

Hardware: Sun E10K, SAN (Sun StorEdge 9980), Hp9K.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Managing a large data migration tasks across the enterprise.
• Migrating databases to cloud.
• Managing Exadata databases.
• Performance Tuning the Application & db in RAC/Non-RAC environments.
• Performing reorgs of partitioned & non-partitioned tables across the enterprise.
• Tuning purge operations.
• Capacity Planning and disk space management of dbs.
• Designing the logical and physical architecture of the databases.
• Parallelizing automated jobs.
• Managing Highly Sensitive/Secure OSI PI databases.
• Implementing Oracle advance compression in very large databases.
• Extensive Shell scripting.
• Running data mining algorithms using python on trading data for predictive analysis.

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Designing / scripting a large migration job of 65 TB data production db.
• Designing, testing, customizing two way replication using Golden Gate.
• Performance Tuning the Application and db of a very large database.
• Capacity Planning and disk space management of dbs.
• Sql tuning, implementing sql profiles, sql plan management.
• Implementing Oracle advance compression in very large databases.
• Extensive Shell scripting
• Rman backup/restore, instantiating /syncing data guard instances.

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Converting RPG/C code into pl/sql procedures & packages.
• Designing / scripting a large migration job of 27 TB data production db.
• Performance Tuning the Application and db in RAC environments.
• Performing reorg of partitioned & non-partitioned tables across the enterprise.
• Tuning heavy purge operations, > 2 billion rows.
• Process re-engineering heavy ETL jobs for better performance and throughput.
• Capacity Planning and disk space management of dbs.
• Designing the logical and physical architecture of the databases.
• Massively Parallelize gather stats, index rebuilds, automate awr reports generation.
• Sql tuning, implementing sql profiles, sql plan management.
• Implementing Oracle advance compression in very large databases.
• Extensive Shell scripting

Confidential, Fort Worth, TX

Oracle DBA

Responsibilities:

• Tuning the Application and dbs.
• Cloning the databases and applications.
• Performing db upgrade and applying patches.
• Performing reorg of long data tables in the dbs.
• Capacity Planning and disk space management of dbs.
• Designing the logical and physical architecture of the databases.
• Implementing RMAN backups and performing recoveries.
• PL/SQL programming for comparing schema objects across dbs.
• Shell scripting

Confidential, Irving,TX

Oracle DBA

Responsibilities:

• Tuning the Application and db performance in a scenario ofHeavy hard parsing, Row chaining, Design discrepancies in file layout on disks,
• I/O bottlenecks, Heavy batch updates, anomalies in SGA and RAID configuration.
• Tuning the application and db in high transaction volume (over 5 million transactions/day).
• Identifying hot objects in the db. Designing strategies to segregate I/O on the hot objects.
• Setting Standards in Capacity Planning, Partitioning strategies
• Designing db upgrade and db cleanup strategies
• SQL Server 2005 administration.
• Designing the logical and physical architecture of the databases.
• Implementing RMAN backups and performing recoveries.
• PL/SQL programming and Shell scripting.

Confidential, Plano TX

Database Administrator

Responsibilities:

• Implemented 3 node RAC with dataguard for high availability in Oralce10G.Established Oracle load balancing and TAF (transparent application failover).
• Designing data model for column level / row level security implementation.
• Designing secure truncate table procedure for truncating third party tables.
• Setting Standards in Capacity Planning, Security, Naming Conventions, Partitioning strategies
• Application tuning.
• Tuning procedures/ Process re-engineering
• Troubleshooting.
• Database refreshes/ Loading data through export/import and sql*loader.
• SQL Server database administration.
• Designing the logical and physical architecture of the databases as per OFA standards.
• Implementing RAC, Advanced Replication and Standby databases.
• Implementing RMAN, BMC’s SQL Backtrack backups and performing recoveries.
• Intermedia text. Installation of software, version upgrades, applying patches and re-orgs.
• PL/SQL programming and Shell scripting.
• Oracle Enterprise Manager (OEM) - for monitoring performance and administrative tasks.
• Project book and documentation.

Confidential, Richardson, TX

Oracle Database Administrator

Responsibilities:

• 24*7 production support for very large mission critical databases (up to 8 TB).
• Performance tuning.
• Performing rman backups and recoveries.
• Refreshing reporting, development, QA databases from production
• Trouble shooting.
• Pl/sql programming for data migration
• Shell scripting.

Confidential, Irving, TX

Oracle Database Administrator

Responsibilities:

• Designing the logical and physical database structure.
• Performance tuning.
• Tuning materialized view refreshes(Improving fast refresh times across db links).
• Sql*loader jobs for data loading.
• Pl/sql programming for data migration

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

• 24*7 production support.
• Setting up and configuring Oracle 10g OEM for monitoring and email messaging.
• Installing Intelligent Agents, adding targets for monitoring and managing metrics.
• Rman catalog repository maintenance.
• Database re-orgs.
• Performance tuning/ resolving locking issues in data loads

Confidential, Austin, TX

Oracle Database Administrator

Responsibilities:

• Installing CRS, Oracle 10g, applying patches and setting up RAC on ASM.Setting up 3 node RAC with dataguard for high availability in Oralce10G
• Refreshing 1 TB standby database from production and starting managed recovery.
• Performing backups and recoveries using rman/ conventional hot backups.
• Performing database re-orgs.
• Moving stand-alone applications to RAC environment.

Confidential, Lewisville, TX

Oracle Database Administrator

Responsibilities:

• Designing ETL procedures for the data mart.
• Tuning complex data loading processes.
• Performing rman backups and crash recoveries on a database of size 1 TB.
• Performing re-orgs.
• Trouble shooting database performance issues and tuning and on-call pager rotation.
• Using Materialized Views/Views/Inline Views in data extraction from remote databases.
• Resolving and troubleshooting locking issues in ETL jobs.
• Tuning complex sql queries involving multiple large local and remote tables.
• Shell scripting. Pl/sql programming.

Confidential, Buffalo, NY

Database Administrator

Responsibilities:

• Database upgrades and migrations
• Design strategies for the large dynamic tables.
• Tuning the MTS, SQL*Net.
• On-call pager rotation.
• Attending to day-to-day issues of end users and resolving.
• Performing rman backups and crash recoveries and refreshing development databases.
• Implementing Oracle Real Application Clusters, tuning the application.
• Tuning the application and database for the heavy OLTP transactions (42 million searches/ day).
• Resolving locking issues for hot blocks and distributing the IO evenly.
• Creating and maintaining materialized views. Setting up standby databases.
• Shell scripting. Pl/sql programming.
• Implementing table partitioning (Range and Hash partitions), and schema re-orgs.
• Tuning heavy data loads in the application, loading 500 million records per job.

Confidential, Cleveland, OH

Database Administrator

Responsibilities:

• Designing fact tables and dimension table in star schema of the Data Warehouse
• Indexing strategies.
• Partitioning strategies.
• Heavy SQL*Loader jobs for moving large amounts of data from DB2 to Oracle.
• Regular ETL processing of data from Data Mart into Enterprise Data Warehouse.
• Designing database backup strategies and performing rman backups and recoveries.
• Shell scripting for automating the SQL*Loader jobs for the initial data load.
• PL/SQL programming for using stored procedures in Informatica transformations.
• Resolving the data conversion issues between DB2 to Oracle.
• Installation of software and documentation

Confidential, Dallas, TX

Data Modeler

Responsibilities:

• Designing the logical and physical architecture of the database - Erwin.
• Converting the conceptual model into logical and physical models
• Indexing strategies.
• Used SQL*Loader for heavy data loads.
• PL/SQL programming for transformation and loading of data into Oracle tables.
• Resolving the data conversion issues between SQL Server and Oracle.