Executive Summary

Oracle certified IT professional with 17 year's industry experience in a variety of roles ranging from business analyst, solution architect, and technical consultant to Oracle Applications, Database and Fusion middleware administrator. Provided production project support to implement, administrator maintain Oracle Applications and integration with 3rd party ERP boundary application and in-house developed legacy solutions. Maintained current knowledge of Oracle tools and technologies by attending the Oracle university classes and training courses

Technical Profile

Oracle Enterprise Apps: E-Business Suite EBS , Enterprise Performance Management EPM ,Governance

Risk compliance GRC , Configuration Controls Governor CCG , OBIEE

Boundary Apps: Ecosys EPC, Virtual Trader, More4Apps, EIS, Vertex, Automic UC4, Talemetry

Databases: Oracle RDBMS, Microsoft SQL Server, DB2, Foxpro, MS Access

Languages: PL/SQL, Java, COBOL, Shell scripting, MS Visual Basic, Delphi, Pascal, WLST

Technologies: Oracle Fusion Middleware,Tomcat, Apache, Oracle Application server, RAC, OID

Oracle Tools: Discover, Warehouse Builder, JDeveloper, SQL developer, BI Publisher, Golden Gate, Business Process Management BPM , OEM, RMAN, UPK, OSB, ASM, AIA

Other Tools HP-PPM Kintana , HP Application Lifecycle Management, Informatics, Clear Case, Toad, CVS, MS Visual Studio, Share point

OS Red Hat Linux, Oracle Linux, Sun Solaris, Oracle Solaris, Windows

Professional Experience

Roles Responsibilities:

• Worked with OMCS and Internal infrastructure teams to configure Disaster Recovery solution
• Coordinated among functional and technical teams to test Oracle hosted Disaster recover solution
• Hand-on experience on Weblogic server architecture, admin, configuration and troubleshooting issues
• Troubleshoot performance issues using ADDM, AWR SQL tuning access advisor, memory advisor
• Managed table spaces, schemas, users, roles, grants, profiles, windows, window groups, Job classes
• Installed and configured oracle Databases using grid Infrastructure, ASM, RMAN, RAC and Data Guard.
• Provided infrastructure, architecture and database support to development, technical functional teams
• Oracle DBA backup recovery, Performance Tuning, Capacity Planning, Data Guard
• Supervised team of off-shore DBA and developers and provided 24 7 project implementation support
• Supported and Oracle Applications on RAC in a large scale Linux environment
• Coordination with Oracle Managed Cloud Services OMCS for production support and maintenance

Roles Responsibilities:

• OracleDB admin, BI publisher, SOA, Weblogic Database Administration support
• OLTP Design conceptual/logical/physical , development, implementation, and maintenance phases
• Developed PL/SQL procedures and host scripts to archive purge custom database tables and xml files
• Coordinated with Oracle Consulting services OCS and Oracle Managed Cloud services OMCS to troubleshoot functional and technical issues and coordinate to implement resolution
• Identified the top resource consuming SQL, tuned them using SQL access advisor and tuning advisor, creating indexes, materialized view, partitioning and gathering statistics on regular basis
• Identified cause of the exponential growth of workflow tables, purged obsolete data and stopped growth
• Strong skills in T-SQL programmable object development, table design, index design, Various technologies within SQL Server: Data Mirroring/Replication, SSIS. Configuration of SSRS and SSAS

• Managed data migration projects from legacy systems toERP systems, gathered client's business requirement, performed gap analysis, develop data mapping procedures and tuned conversion procedures
• Implemented virtual private database, transparent data encrypting TDE and PL/SQL procedures using obfuscation toolkit to encrypt sensitive data to meet Payment Card Industry PCI requirements
• Configured flashback data archive a low-cost, high-performance, secure, and seamless history data management system that replaced complex application logic, database triggers and redo log mining
• Provided root cause analysis of database performance issues related to programming objects, query syntax, schema design, indexing, DB and server configurations using ADDM, AWR and ASH reports and advisors
• Day-to-day DBA activities of administrating, monitoring, tuning, maintenance, backup, recovery , resource and patch management, and capacity planning of 40 in-house test and development oracle databases

• Implemented consolidated customer service, circulation, distribution and billing system for 10 Tribune newspapers, migrated legacy data, designed data warehouse for reporting and business intelligence
• Developed PL/SQL procedures to create subset of production database for training and development environment based on variety of parameter while maintaining data integrity and masking sensitive data

• Executed database software installation, database creations/configurations, data loading, performance monitoring, tuning, security capacity planning and backup and recovery.

• Developed and designed communication layer between COBOL Application and Oracle Database
• Created Unix Shell scripts for new batch process, replaced mainframe JCL with UNIX shell scripts
• Application Programming using Micro Focus COBOL, creating PL/SQL procedures, packages, triggers