SUMMARY:

• Over 18 years of IT experience includes Datawarehouse,Database Design, Data Model, Development, Deployment, Database Administration, Testing, Enhancement, Maintenance, Migration and implementation of large and complex Oracle character & GUI based Client/Server applications and Web - based applications.
• Strong experience in Oracle 7.x/8.x/8i/9i/10G/11G, C/C++, SQL, PL/SQL, SQL*Forms 4.5/6.0/6i/10G, SQL*Reports 2.5/3.0/6i/10G, Developer 2000, RMAN.
• Strong experience in Datawarehousing using Informatica 7.0/6.5 ETL, Power center, Siebel Analytics, SQL*Loader.
• Good experience with Data modeling, Schema Modeling, Multi-dimensional modeling using ERWIN.
• Experienced in working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Develop and document conceptual and logical data models using standard modeling techniques (entity-relationship diagrams) and software.
• Proven experience in project and team leading with zero defect delivery.
• Strong skills in Oracle are SQL*PLUS, PL/SQL especially, back end programming like Packages, Functions, Procedures and Database Triggers as well as writing ksh/bash/csh Shell and PERL scripts. Wrote PERL Scripts for automation of file transfers.
• Experience working with Java/JSP/EJB/Servlets/HTML/DHTML/JavaScript/VBScript/WebLogic/Websphere Server.
• Strong in Data Model & Database/Application Design, performance tuning and Database Administration.
• Experienced with data administration, data management, data integration, data standardization, metadata management and repository implementation techniques.
• Interaction with other technical groups including Oracle DBAs, Unix Administrators, business analysts and product analysts.
• Accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of business applications, data warehouses and data marts.
• Experience providing 24x7 on-call production applications support.
• Other skills include Team Management, Quality Assurance, Software Testing, Business Process Re-engineering, Information Systems Planning Study, and Reverse Engineering etc.

TECHNICAL SKILLS:

Databases: Oracle 7.1.6/8.x/9.x/10G/11G, MySQL, Teradata, MS-SQL Server 6.5/7.X/2000/2008, DB2, MS Access 97/2000

ERP Oracle Applications: 11i/ 11.5.8/11.5.6/10.7.

Languages: PL/SQL, Hive, Java, XML, XSL, C/C++, Pro* COBOL, FORTRAN, Basic, Perl 5.x, UNIX.Java Script, VB Script

Data warehouse: Informatica 7.0/6.5 ETL, Data Stage, Power center, and Siebel Analytics

Data Modeling: Designer 2000, Erwin 3.x, Visio,DB Artisan.

Application Server: ATG DYNAMO, Web Logic 8.1/7.0, Web Sphere 4.5/5.1, Apache, Tomcat

Tools: Informatica ETL 6.2/8.x, Developer 2000, Forms 4.5/6.0/6i, Reports 2.5/3.0/6iCrystal reports, Visual Basic 6.0, SQL*Plus, SQL*Loader, Erwin, DB Artisan, ER Studio, PL/SQL Developer, SQL Navigator, Toad, Benthic, MS Project, MS-Office 97/2000, RMAN, Composite SW.

Source Control: Visual Source Safe 6.x, PVCS 6.x, CVS and SVN.

O/SHP: UX 10.20/11.0/11.11 , Solaris 2.x, Sun 4.1.x, DG-UX 4.2, AIX 3.x/4.x, LinuxUnixWare/SCO 7.x, Windows 3.1/95/98/2000/ NT

Testing Tools: Win runner, Test Director, Load Runner

OLAP/OLTP: Business Objects, Analysis Services and Informatica/Data Stage.

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Sr. Application Support DBA/Developer

Responsibilities:

• Provide support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN trace analysis, service creation, and cluster and system management.
• Planned and implemented high availability solutions using Oracle 11g RAC, Standby Database using Oracle Data Guard.
• Configuration, upgrade and performance tuning of Oracle RAC, Experience in using OEM, TOAD, and Data Migrations using export/import.
• Troubleshoot production issues and restore service by resolving customer-facing incidents for .Net business applications.
• Provide support for Oracle Enterprise Manager Grid Control and Agents, Experience with writing advanced Korn/bash/C shell scripts.
• Provide technical leadership in the diagnosis of issues as they arise in support of the Copient offer Drive collaboration sessions among IT and business groups to facilitate optimal support and operation of the Copient Central System and ecommerce Applications.
• Contribute to the implementation and enhancement of Windows application and database systems used by the Loyalty and ecommerce departments.
• Contribute to the design and implementation of performance improvements to Linux/Windows application and database systems in support of the Loyalty and ecommerce departments.
• Perform proactive analysis and troubleshooting to predict and prevent production incidents.
• Define and contribute to monitoring capabilities for production Unix/Windows application and Oracle/Teradata/SQL Server systems in support of the Loyalty and ecommerce departments.
• Collaborate with key vendors on functional, performance and capacity improvements.
• Design and build tools to automate support and monitoring functions.
• Provide 3rd level support for a customer-facing suite of Loyalty and ecommerce solutions that require 24x7 availability, including after-hours and on-call activities.

Environment: Oracle 11G, Teradata, MYSQL, SQL Server 2008, Cassandra, Hive, PL/SQL, Automation (job scheduling), ESP, Data Stage, SQL Developer, Toad, Sun OS, UNIX, Perl, Windows XP, MS SharePoint, Remedy, LiveMeeting, Communicator.

Confidential, Foster City, CA

Sr. Database Administrator

Responsibilities:

• Work closely with quality engineering and operations to test and deploy product enhancements andissue resolutions.
• Worked on applying Oracle Patches on production, QA and Development databases usingopatchutility.
• Created newdatabasesandusers: set upbackups,export, and other monitoring scripts.
• Promote the developed/tested code to subsequent stage/production environments.
• Monitored memory, CPU utilization, disk utilization (I/O usage), and locks/deadlocks.
• Workindependently, while interacting with product and engineering teams.
• Performed GRID and database upgrades from Oracle 11.2.0.3 to 11.2.0.4
• Worked on Oracle Enterprise Monitor (OEM).
• Worked onASM, adding disks to Disk Groups and FRA Groups.
• Troubleshoot issues with application, technologies and infrastructure.
• Extensively worked on monitoring Real Application Clusters (RAC) databases for highavailability.
• Write scripts to monitor and automate processes.
• Define and document current and future configuration processes and policies.
• Worked on Automation of jobs USING UNIX Shell scripting & Perl.
• Worked on creating and scheduling Oracle based applications using Shell and Perl scripts.
• Workedoncomplex SQL queries &PL/SQLProcedures&Packages.

Environment: Oracle 11G/10G, RAC, SQL Server 2008, MY SQL, DB2, PL/SQL, SQL Developer, Toad, LINUX, Perl, Windows XP, SVN, Composite SW, Communicator.

Confidential, San Leandro, CA

Sr. Oracle DBA

Responsibilities:

• Worked extensively on OEM 12c Cloud control for monitoring and administration.
• Worked on Creating, Scheduling & refreshing of Materialized Views/ Snapshots.
• Understanding of Wholesale Technology Services processes, methodologies and tools to include Pac2000.
• Promote the developed/tested code to subsequent stage/production environments.
• Understand detailed Wachovia integration business process and analyze data for Oracle Back End Database.
• Used Various Optimizer hints, BIT MAP, ORDERED to tune Complex SQL queries.
• Document the findings from the analysis and understanding of business process into technical design document.
• Monitoring ASM instances across enterprise wide databases.
• Working on creating reports using SQL*Plus spooling.
• Worked extensively on RAC and Database upgrades from 11.2.0.3 to 11.2.0.4.
• Created & Scheduled SQL*Loader control files for incoming data transmission.
• Worked on Automation of jobs USING UNIX Shell scripting & Perl.
• Extensively worked on Trouble tickets work (Remedy/Pac2000).
• Worked on creating and scheduling Oracle based applications using Shell and Perl scripts.
• Worked on applying latest PSU patches on RAC databases.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Worked on debugging and testing of the application in UNIX and Perl.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Performance Tuning of complex SQL queries & PL/SQL Procedures Packages
• Worked on Data propagation from source systems to Destinations.

Environment: Oracle 11G/10G/9i/8i, SQL Server, PL/SQL, Informatica 8.5, NDM, AutoSys Workload Automation (job scheduling), Toad, Sun OS, UNIX, Perl, Windows XP, MS SharePoint, Remedy, LiveMeeting, Communicator.

Confidential, Oakland, CA

Sr. Oracle DBA

Responsibilities:

• Worked extensively with Oracle Technical support on various Tars.
• Created new databases and users: set up backups, export, and other monitoring scripts.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance.
• Identify, recommend, and implement all new database technologies and Oracle license management.
• Installed and configured Oracle Enterprise manager on Linux platform.
• Used various Optimizer Hints to speed up the SQL queries.
• Designed ETL programs to extract data and created the reports.
• Monitored memory, CPU utilization, disk utilization (I/O usage), and locks/deadlocks.
• Worked on creating and scheduling Shell and Perl scripts.
• One of the main responsibilities was database Performance tuning using TKPROF, Explain/Plan, utility and also performed Application tuning i.e., SQL, PL/SQL, Maintaining the security of the databases and error correction.
• Extensively worked on SVN version control tool and with Release management team.
• Worked on applying Oracle patches on Production & Adhoc databases using Opatch utility.
• Worked with the team on Oracle database upgrade to 11G.
• Worked on packaging rpms in Linux and used SVN source control.
• Performance Tuning of complex SQL queries
• Worked extensively on PL/SQL Procedures and Packages
• Worked on Data propagation from source systems to Destinations.
• Extensively worked on performance tuning of PL/SQL.
• Worked on call round the clock 24/7 Support model.
• Worked on 3PAR storage, Creating CPGS, Volumes, and LUNS/VLUNS.
• Performed data backup using logical exports/imports.

Environment: Oracle 11G/10G/9i/8i, OEM, PL/SQL, Linux, Perl, Data Guard, 3Par Storage, Apache, Tomcat, SVN.

Confidential, San Jose

Oracle Developer

Responsibilities:

• Loaded Data from huge Oracle Database tables to Excel spreadsheet Sheets.
• Development of PL/SQL packages and SQL scripts.
• Worked on various TCA tables like HZ PARTIES and HZ CUST ACCOUNTS.
• Created certain Materialized views to get best-optimized results based on TCA tables, which are used in search engine.
• Performance Tuning of SQL queries
• Provided Production Support and handled production-related issues.
• Involved in taking logical backups like Exports and Imports.
• Used various Optimizer Hints to speed up the SQL queries.
• Extracted data from Oracle Applications 11i databases.
• Database Tuning: Instance tuning, Application Tuning, Used parallel query parameters.
• Worked on Oracle Objects, Object Oriented Programming.

Environment: Oracle 8i/9i, SQL Loader, SQL Server, Dollar Universe, PL/SQL, Shell Scripting, HP UNIX, Java, Windows 2000, Benthic, Toad and SQL Navigator, HTML, Java Script.

Confidential, Newark, CA

Oracle Developer

Responsibilities:

• One of the main responsibilities was database Performance tuning using TKPROF, Explain/Plan, utility and also performed Application tuning i.e., SQL, PL/SQL, Maintaining the security of the databases and error correction.
• Used various Optimizer Hints to speed up the SQL queries.
• Used SQL Loader to import data from large flat files and Excel sheets to Oracle tables.
• Loaded Data from huge Oracle Database tables to Excel spreadsheet Sheets.
• Understanding Business Requirements and Impact Analysis. Defined the Data requirements.
• Developed Oracle reports using Oracle report builder for real-time applications.
• Created Data base schemas, Data Model, Data Flow, and Database Objects.
• Design and developed data layer.
• Designed Multi-Dimensional abstract Data Model using ERWIN.
• Extracted data from other databases (Oracle).
• Development of PL/SQL packages and SQL scripts.
• Worked extensively on database exports/imports and troubleshooting.
• Facilitate what-if analysis, ad-hoc reporting, portfolio reruns and forecasting.
• Support XML-based valuation transactions.

Environment: Oracle 9i, PL/SQL, Erwin, SQL Loader, Shell Scripting, UNIX, Java, XML, Windows 2000, Toad, SQL Navigator, HTML, and Java Script.

Confidential, San Jose, CA

Oracle DBA/Developer

Responsibilities:

• Involved in Re-Engineering of existing applications and preparation of Functional/Technical Design document.
• Worked extensively on Data mapping using Data Junction’s content extractor.
• Developed reports using VB .NET
• Created and modified UI Screens using java Script, VB script & HTML.
• Converted Crystal reports from version 7 to 8 to web enable them.
• Involved in Re-Engineering of existing applications and preparation of Functional/Technical Design document.
• Frequent interactions with user teams for analysis of problems in the existing system.
• Involved in creation of databases, moved databases by recreating control files, export/import, and complete backups. Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Handled database server tuning, application tuning, maintaining documentation, and capacity planning and database security.
• Worked on admin console of web sphere and web logic and involved in debugging of the web app written in Java J2EE Platform with Oracle 8i/9i.
• Used SQL Loader to import data from large flat files and Excel sheets to Oracle tables.
• Loaded Data from huge Oracle Database tables to Excel spreadsheet Sheets.
• Installed and configured IBM Web sphere 5.1 and BEA Web logic 8.1 software according to customer needs.
• Involved in creation and maintenance of Oracle Users, Roles and Profiles.
• Developed PERL scripts to interact with Oracle extract data and display these data onto the Internet.
• Developed UNIX shell (ksh) scripts and Perl scripts to automate most of the engineering and testing tasks.
• Performance/query optimization (using TKPROF, Explain Plan, Hints, etc.)
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Analyzed database for referential integrity violations and write PL/SQL stored procedures to correct “live” data.
• Interaction with other technical groups including Oracle DBAs, Unix Administrators, business analysts and product analysts.

Environment: Oracle 7.x/8.x/8i/9i, Data Junction, C++, Java, SQL*Loader, SQL*Plus, Erwin, Toad, Benthic, PL/SQL, SQL, SQL*Trace, ksh, PERL 5.x, JavaScript, HTML, Shell Scripts, Windows NT/9x/2000, Sun Solaris.

Confidential

Oracle DBA/Developer

Responsibilities:

• Design & Development of user interface using Developer/2000 and Designer/2000.
• Design & Development of reports using Reports 3.0.
• Production Support - Retrieving and loading data from banks.
• Created Standby databases (now called as Data Guard) for high data availability.
• Prepared Roles for System User to give security to the system.
• Involved in SQL & PL/SQL programming for stored procedures.
• Wrote PL/SQL procedures, packages, triggers and Oracle Forms (Developer 2000/6i) as required.
• Developed applications using .NET to include ASP.NET, C# or VB.NET.
• Worked extensively on RMAN backup of multiple databases.
• Administered databases and handled large volume of data.
• Developed the whole of Power Monitoring System Online, Batch Programs, and Reports & Graphs using PL/SQL.
• Integration of Custom Applications and database objects as well as Customization and
• Testing and Debugging Oracle Applications and Batch jobs.

Environment: Oracle 7.x/8.0, RMAN, Standby Database, Designer 2000, Developer 2000 (Forms 4.5, Reports 2.5), Visual Basic.