SUMMARY:

• 12+ years experience in Oracle Database Development and Administration. Senior Oracle Developer and Architect involved with data modeling, design, migration and integration across enterprise business applications, Oracle Applications R12 ERP, Salesforce.com CRM, Enterprise Data Warehouse, Informatica, Cloud Computing
• Discoverer and Business Objects. Well versed in all aspects of Analysis, Design, Development, Maintenance and Testing of Oracle Database 11g./10g/9i using PL/SQL, SQL, Java and XML. Oracle certified Developer experienced in collaborating with cross - functional and globally diverse teams using Agile and waterfall SDLC methodology. Excellent communication, interpersonal, leadership and organizing skills. Formerly worked for The Confidential, Confidential, Confidential, Confidential, Confidential, and Confidential .

TECHNICAL SKILLS:

Database: Oracle Database 11g/10g/9i analysis, design, development, maintenance and support. Database Replication, Migration from Legacy systems, Application Performance Tuning. PL/SQL Packages and Triggers, SQL, Erwin, Toad.

Platforms: UNIX (Sun Solaris, HP-UX, AIX), Linux and Windows Enterprise Servers

Ent. Systems: Oracle Applications R12 ERP, Salesforce.Com CRM, Cloud Computing, Enterprise Data-warehouse, Business Objects and Oracle Discoverer.

Integration Informatica: Power Center, Informatica Cloud, Tibco

Programming: Java, ColdFusion, C, C++, C#, Perl and XML

Process: Agile Development, SEI CMM Level 4 and ISO 9001.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Database Architect

Responsibilities:

• Designing the Logical and Physical Data Models for Active’s H&F line of business.
• Architecting the Data Integration using Oracle Golden Gate and Informatica.
• Designed and developed the Automated Data Load Platform for various states across H&F.
• Schema level export/import using Data Pump. Tuning Oracle Data Pump jobs.
• Developed and supported Oracle 10g PL/SQL packages and procedures.
• Database and Application Performance Tuning using AWR, ADDM and ASH reports.
• SQL Performance tuning using Explain Plan and TkProf.
• Designing and developing complex custom reports using Materialized Views.
• Installation, configuration and administration of Oracle 11g and 10g multi node RAC Databases.
• Database support for High availability using RAC and Replication with Oracle Grid and ASM.
• Building and Supporting for Disaster Recovery using Oracle Data Guard.
• Configured GoldenGate MGR, Extract & Replicat processes on highly transactional multi-node RAC environment.
• Supporting Oracle Advance (Multi-master) replication across RAC and traditional databases.
• Cloning the Dev/QA environments using Hot and Cold Backups.
• Database patching (PSU and CPU Patches) and up-grading using manual and automated tools.
• User managed and RMAN based Hot and Cold Full/Incremental Backup and Recovery.
• Production Database Monitoring and Management using OEM, Nagios and Groundwork.
• 24x7 On-Call Production Support for business critical databases.
• Database Auditing, Security and Data Migration from legacy systems.
• Supporting SOX and PCI audit requirements for Production Databases.
• Working with Oracle Tech Support (Metalink / Oracle My Support) for problem resolution.
• Automating Database Alert Management using shell and Perl scripting.
• Proactively identify and troubleshoot production database issues at large.

Confidential

Database Developer

Responsibilities:

• Development, maintenance and support for Confidential ’s Pre-Publication life cycle management systems and master product database applications.
• Developing and maintaining data interfaces with Legacy Enterprise Systems, Oracle Applications R12 ERP, Salesforce.com CRM, and Enterprise Data Warehouse.
• Database Architecture, Design, Modeling and Reverse Engineering using Erwin and Toad.
• Development of PL/SQL based procedures, functions, packages, package bodies and triggers.
• Migrating Data from legacy systems into new Enterprise Applications.
• Interfacing with foreign and legacy systems using TIBCO, Informatica Power Center and Informatica Cloud. Developing Power Center and Cloud based ETL workflows for data migration and interfaces.
• Planning and executing unit, integration, user acceptance, regression and performance testing.
• Working with business users to understand and validate the requirements.
• Participating in application change management, working with the business users to resolve competing priorities; preparing technical design alternatives and estimates in support of approved changes.
• Working with Oracle Support (Metalink) to resolve complex technical issues.
• Working with Database Administrators to resolve database performance and data quality issues.
• Managing and Resolving assigned defects using HP / Mercury Quality Center (MQC).
• Participating in code reviews (DDL/DML), ensuring compliance with development standards and best practices. Reviewing and approving project designs for compliance with overall system architecture.
• Working with DBAs for proactive and reactive database and application Performance Tuning.
• Evaluating new application technologies and products for potential future use; adopting and using new technologies, sharing results and lessons learned with team and other developers.
• Partnering with tech and business leads for successful project management in a Matrix Organization.
• Collaborating with offshore development partner teams in hybrid development models.
• Advising, teaching and mentoring team members on Oracle database development Best Practices.
• Defining and following internal coding standards for development and maintenance.
• Practicing and improving on enterprise quality processes as applicable to Database Development.
• Develop and maintain database centric processes and technical documentation in central repositories.

Confidential

Responsibilities:

• Analyzed Confidential Workplace Resources division’s existing business structure.
• Developed the functional and technical requirements for Sun WR Portal Server Database.
• Designed and developed Confidential WR database.

Confidential

Responsibilities:

• Analyzed USA.NET's E-mail system and designed Java based components to interface with Oracle.

Confidential

Responsibilities:

• Developed system's functional and technical requirement specification.
• Designed and developed telecom mediation based statistical reports using C, Oracle7, PL/SQL, Pro*C.
• Developed Unit Test Plans and System Test Plans and tested C, PL/SQL and Pro*C programs.

Confidential

Responsibilities:

• Analyzed High Level Design of the system and developed LLD for back and front end components.
• Developed C, C++, PL/SQL and Pro*C programs to implement the back end.