SUMMARY:

• 15 + years of experience in System Analysis, Design and Development.
• Extensive hands on experience with Oracle Databases (8.x to 11gR2).
• Extensive working experience with Oracle RDBMS as a DBA and Developer.
• Extensive experience in writing Packages, Stored Procedures, Functions & Database Triggers.
• Expertise in SQL, PL/SQL, Oracle Loader and Sql*Loader for database programming.
• Worked on Data Warehouse applications, and data modeling with Oracle.
• Proficient in writing UNIX shell Scripting and Batch Processing.
• Extensive experience in Analysis and Design maintaining the required coding standards.
• Has very strong background in working large projects with many developers and a disciplined software development life cycle (SDLC) process.
• Equally proficient in C and Pro*c.
• Well versed in using SCCS and VSS version control tools.
• Full Life Cycle Development experience (Requirements gathering, Analysis, Design, Development, Documentation and Testing).
• Expertise in development and implementation of Client / Server Applications.
• Worked with TCP/IP, SNMP and SMTP protocols.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte NC

Sr. Oracle DBA

Responsibilities:

• Build Exadata appliance RAC system on ASM
• Experienced in Oracle database table/column encryption and OEM implementations
• RMAN backup and recovery
• Experienced in database tools and performance methodologies
• Active - Active Data guard Disaster recovery with Broker in multi-node RAC systems
• Proactively manage database space utilization, database performance issues, daily monitoring databases and reduce errors to zero and patch management
• Migrate to production as needed coordinating with developers

Environment: Oracle 11gR2, Data Guard, RMAN, Cloud Control, Exadata, PL/SQL, SQL, UNIX, Python, Linux, Shell Scripting

Private Pilot

• Working on my Private Pilot License.

Sr. Engineer/Oracle DBA

• Defined and maintained architecture standards
• Evaluate Enforced Geo-redundant disaster recovery with datagaurd
• Configured Active-Active bi-directional replications with Goldengate, Shareplex and streams
• Evaluated and implemented Oracle features and Oracle products ASAP
• Established RMAN backup and recovery policies
• Performed database tuning and performance monitoring
• Designed and implemented RAC Databases
• Migrated 10gR2 file system Database into 11gR2 ASM Database servers with control files only.
• Whole Database from old hardware into new hardware migration with Goldengate
• Monitored databases with tools like Grid control & created own shell script tools
• Interfaced with Confidential for technical support.

Environment: Oracle 10gR2 and 11gR2, Data Guard, RMAN, Grid Control, GoldenGate, Streams, L/SQL, SQL, UNIX, Linux, Shell Scripting

Senior Software Engineer (Oracle Engineering DBA)

Responsibilities:

• Responsibilities included: researching, analyzing and providing solutions for database issues.
• Undertaking installations, upgrades, migrations and patch management.
• Oracle Database performance tuning, troubleshooting and PL/SQL optimizations.
• Setting-up Oracle environments (Database, Application Server and Development).
• Develop and implement Database Triggers, Stored Procedures, AQs, and Packages.
• Perform Database disaster recovery and Backup with RMAN.
• Considering both 'back end' organization of data and 'front end' accessibility for end-users.
• Designing of database sizing tools to meet system storage requirements.
• Help ensure that customer service level agreements (SLAs) are met at all times.
• Communicate regularly with development and support teams regarding database status and changes.
• Mentoring junior and mid-range software engineers for quality products.
• Ensure test and staging databases properly match production.

Environment: Oracle 9i and 10gR2, Data Guard, RMAN, PL/SQL, SQL, UNIX, Linux, Shell Scripting

Software Developer Consultant/Oracle DBA

Responsibilities:

• Responsible for the design and development of application for integrated marketing setups.
• Designed database Specifications per business requirements.
• Developed Database scripts to implement designs.
• Developed Insurance rate refresh, Insurance Code Request, Insurance Code Extract, Insurance Response Load and Insurance Response applications in UNIX environment using C and Pro*C.
• Developed Insurance Marketing applications using Pro*c, PL/SQL in UNIX and Oracle Environment.
• Wrote stored procedures, triggers, database scripts.
• Developed data transaction applications between Legacy and Oracle systems.
• Developed UNIX Shell Scripts (K Shell) to automate the whole process.

Environment: Oracle 9i, PL/SQL, SQL, SQL/Oracle Loader, UNIX, Linux, Shell Scripting

Application Developer Consultant

Responsibilities:

• Responsible for development of data warehouse standard reporting for Sales and performance system.
• Developed applications written in PL/SQL procedures as per business requirements
• Developed UNIX Shell Scripts to automate the whole process.
• Enhanced applications for efficiency written in Pro*c and PL/SQL.
• Managed internal coding, testing and maintenance of the oracle database using SQL*Plus, PL/SQL and Pro*C.
• Developed SQR modules for the end-users to generate sales Reports.
• Created PL/SQL Functions and Stored Procedures to meet the requirement of the Project.
• Created UNIX shell script to automate the whole process of loading multiple data files, use the same control file and load the data into temporary table; and using the PL/SQL Procedure load the entire data into Data Model Tables and rebuild the corresponding table indexes.
• Wrote Shell scripts to move the bad files to bad files directory, Original data files to archive directory and will create a log file for the whole process.
• Wrote Shell scripts to take care of errors and abandon the process.
• Developed test scripts and system procedure manuals for the applications.
• Migrated into production using software configuration management system procedures.
• Developed process and technical specifications for applications.

Information Management Consultant

Responsibilities:

• Responsible for monitoring production and reporting on a system's data warehouse operations. Responsible for keeping the systems in optimal condition.
• Enhanced application modules written in Pro*c to reduce application transaction times.
• Designed and developed new application modules in Pro*c and PL/SQL,
• Created in-house Data Warehousing ETL process using Pro*c, C UNIX scripts to handle 40G data files for daily process.
• Created Unix Shell Scripts to automate the loading process.
• Designed and developed modules using Pro*C, PL/SQL to extract data for Targeting Professional Indexing transaction.
• Developed PL/SQL code to write Packages, Stored Procedures and Functions.
• Loaded upstream flat file data into Oracle database using Sql*Loader.
• Created UNIX shell script to automate the whole process of loading multiple data files.
• Created Pro*c and PL/SQL models to handle database transactions on the entire application and rebuilt the corresponding table indexes.
• Created Pro*c, and PL/SQL modules to generate data files for downstream applications.
• Created UNIX shell script to automate ftp data files from source to the destinations.
• Wrote Shell scripts to move the bad files to bad files directory, Original data files to archive directory and will create a log file for the whole process.
• Wrote Shell scripts to take care of errors and abandon the process.
• Prepared a document to explain the whole operations involved in preparing the data and how to use the shell script to load the data.
• Developed test scripts and system procedure manuals for the applications.
• Performed unit, integration and full volume system testing of new modules.
• Migrated into production using software configuration management system procedures.
• Achieved application data transaction times reduced by considerably.
• Developed process and technical specifications for applications.

IT Senior Consultant

Responsibilities:

• Maintained and supported a web-based form generation application.
• Provided maintenance and support for a web-based application.
• Modified Perl/CGI and PL/SQL codes on demand basis per business requirements.
• Performed unit and integration testing of the modified modules.
• Migrated into production as per Cisco business practice.
• Attended weekly conferences with managers worldwide.

IT Analyst/Developer

Responsibilities:

• Successfully completed a merger application and managed batch processes for various applications. Responsible for maintaining and optimizing a number of databases and for scripting batch jobs.
• Created and handled batch processes for in-house applications.
• Created PL/SQL Functions, Triggers and Stored Procedures to meet the requirement of the Project.
• Created UNIX shell script to automate the whole process of loading multiple data files, use the multiple control files and load the data into database table.
• Using the Pro*c and PL/SQL Procedure, loaded the entire data into Tables and rebuilt the corresponding table indexes.
• Developed new modules, enhanced and modified Java based applications on Netdynamics.
• Performed Unit testing, Integration and full volume system testing of the applications.
• Created test scripts and system procedure manuals for the applications.
• Migrated into production using software configuration management procedures.
• Upgraded Oracle 7.i to 8.i versions.
• Completed migration projects for AT&T and Lucent.
• Maintained and optimized databases as application DBA.
• Created the backend Oracle database; created tables, table spaces, data files, grant, rollback segments and schema objects.
• Developed applications and modules in Pro*c, PL/SQL as business requirements.
• Developed process and technical specifications for applications.
• Developed report generators using GUI Centura.
• Performed configuration management administrator (CMA) responsibilities for many applications.

Environment: Oracle 7i and 8i, PL/SQL, SQL, C, Pro*C, Java, UNIX, (K Shell) Shell Scripting