SUMMARY

• Oracle 10g and11g DBA Certified Professional OCP .
• More than 10 years of professional experience in Oracle DBA 12C/11g/10g/9i/8i/7x having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation in UNIX, AIX, Sun Solaris, Windows 2000/NT, Exadata Linux high-availability environments.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates CPU's in various environments and experienced full life cycle of Production, Development, UAT and QA databases administration in Oracle.
• Experienced in Installing and configuring ASM and Oracle 11gR2/10g RAC for high availability databases.
• Troubleshoot Database performance issues using Automated Workload Repository AWR , Automatic Database Diagnostics Monitor ADDM , SQL Profiles, SQL TRACE, TKPROF and Explain Plan.
• Expertise in design, development, implementation of Enterprise Data Warehouse, Data Modeling, Data Marts, Data Mining, Operational Data Stores, Metadata Transformation and Client Server applications.
• Extensive knowledge on ORACLE Databases administration 10g, 11g of sizes ranging from 200GB to 5TB.
• Experienced of Oracle Golden Gate GG installation, configuration and troubleshooting Golden Gate Extract and Replicat issues.
• Having good experience in configuring Grid OEM 12C cloud control and Oracle Enterprise Manager OEM for maintaining and monitoring databases.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Designed and Implemented database security using Oracle roles and privileges. And securities for users and applications.
• Experienced in Database design including creation, modification, and deletion of tablespaces, data-files, rollback segments and schema's, creating schemas Tables, Indexes, views, sequences, synonyms, roles, and users .
• Strong team player, team leader, implemented projects independently, commitment towards learning, posses excellent communication, project management, documentation, training, and interpersonal skills in Finance, Transportation, Software, Engineering and Construction Industries in both government and private sectors.

TECHNICAL SKILLS

• RDBMS: Oracle 7.x/8i/9.2.0/10.2.0/11g/12C RAC, Sybase 11.9.2, SQL Loader, MS Access 7.0, , SQL Server 2000, Informix, and DB2.
• Applications: Oracle Siebel 8.0, Apex 4.1, Maximo 6.5.1 and Primavera 6.2
• Business Intelligence Tools: Oracle Reports 6i/9i/10g, Oracle Discoverer 4.1
• Data Warehouse/ETL Tools: Warehouse Builder, Informatica Powercenter 8.1, Microsoft Visio 6.0, SQL Navigator 4.x, EZ-SQL 2.9, Toad 9.1/8.6, PL/SQL Developer 7.1.
• Oracle CASE Tools: Designer 6i/9i.
• Hardware and Servers: Dell Work Stations, IBM PC Compatibles, Pentium PCs, Citrix Server, and Windows Terminal Server, High End Sun Servers.
• Operating System: Windows 2000 Server/Professional/Vista, Sun Solaris 8.0, 5.6, UNIX AIX, SUN, SCO , SUSE Linux 9 10 , MS DOS, Windows 95, 98, Windows NT/XP/Vista.
• User Interfaces: Forms 6i, 5.0, 4.5 Visual Basic 6.0 5.0, ActiveX, COM/DCOM.
• Backup Tools: VERITAS, TSM, Tivoli/Omni.
• Web Servers/ Technologies: Oracle 9i/10g AS, Oracle Report Server, Web Logic 5.10, HTML, DHTML, VB Script, Java Script, JSP, ASP, IIS, FTP, JRUN, Reflection and J2EE.

Languages: SQL, PL/SQL SQL Plus, Java 2.0, C and Pro C.

Scripts: PL/SQL, Perl, UNIX Shell.

Other Tools: PVCS Tracker, PVCS Version Manager.

PROFESSIONAL EXPERIENCE

CONFIDENTAIL

Senior Oracle Database Administration /Siebel Manager/Computer System Manager

CONFIDENTAIL

Oracle Database Administrator/TMAC System Engineer

CONFIDENTAIL operates an extensive transportation system to meet the differing needs of New Jersey'sresidents, ranging from traditional bus and commuter rail to new and expanding light rail services. Njtransit also provide services for people with disabilities and for local community connectors, as well as support for privately operated transit.

CONFIDENTAIL

Responsibilities:

• Installed and configure oracle 10g, 11g databases on Linux, AIX , Solaris,exadata and Windows based servers of Oracle database server and clients.
• Performed up gradation of databases from lower version 10g to higher version 11g .
• Installed and implemented 2, 3 nodes cluster for Test and Production environment.
• Configured ASM disk groups to store Data files, redolog files, and control files.
• ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL
• Used the SRVCTL utility to manage, start and stop Oracle Database and services.
• Created Data guard physical standby database for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment.
• Writing Unix Shell scripting for automating tasks and alert jobs.
• Provide and implemented RMAN backup strategy with retention policy of 35 days to keep the latest 2 days backupsets on disk and move rest of the backupsets to tape.
• Extensive monitoring dev1, feb, host and roc databases and using Data Pump expdp/impdp or BCV or RMAN to clone/refresh Schema, database from Production to Test and Development Environment.
• Experience in Extracting, Transforming and Loading ETL data using SQL Loader Utility
• Troubleshooting Listener and Tnsnames network files.
• Performed recovery from missing or corrupted data files, redo log group, control files and recovery from block corruption dbverify .
• Monitored production database using automatic workload repository AWR and automatic database diagnostic monitor ADDM .
• Analyze and monitor wait events on production databases to implement improvements for buffer busy waits/sequential scattered read contentions.
• Timely monitoring of key tables to collect statistics on row-chaining/migration and implement methods to avoid redundancy thus eliminating performance bottle-necks.
• Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommending solutions for faster execution.
• Experience using modeling tools, logical and physical database design using ERWIN.
• Strong knowledge of PL/SQL code optimization, and assistiance to developers with the writing and tuning of PL/SQL code.
• Reviewing and resizing conspicuously over allocated tablespaces wherever possible thus improving the time-frame for cold backups.
• Improved DW performance by implementing advanced Oracle Data Warehousing features: Materialized Views, Partitioning, External Tables, Dimensions, Parallel Execution, Table and Index Compression, Star Schema, Rely Constraints, and Change Data Capture.
• Monitoring alerts and checking database free space, allocating and maintaining free space for optimal Database performance.

Environment: AIX, Linux, Windows, exadata, Oracle 9i/10g/11g RAC, Oracle Recovery Manager RMAN , Oracle Enterprise Manager OEM , Oracle Dataguard, PL/SQL using PL/SQL Developer 7.1 and TOAD 9.1, Perl, SQL Loader, Warehouse Builder, Oracle Report, XML Publisher Report, Erwin, PVCS.

CONFIDENTAIL

Oracle Database Administrator/Database Developer Architecture

Responsibilities:

• Installing and Managing Oracle 9i, 10g 11g Database on Linux , AIX and Solaris operating system.
• Installed managed 10g R3 OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups Plan growth and changes, capacity planning
• Recover/Cloned the database from ASM to ASM, ASM to File System, and File System to ASM.
• Multiple terabyte warehouse operations and maintenance.
• Monitoring the route generation to get published and unpublished connection reports.
• Oracle database performance tuning using statspack, explain plan, tkprof and OEM.
• Tune the SGA components like buffer cache, shared pool to avoid paging swapping hence reducing I/O bottle-necks in 9i, 10g environment.
• Reviewing and resizing redo logs wherever possible to reduce the redo log space requests and ensuring multiplexing/mirroring of members.
• Tablespace and object reorganization to remove the fragmentation.

Oracle Production DBA functions

• High availability, 24/7, replication, standby, dataguard, clusters, data warehouses, ETL.
• RMAN, Veritas NetBackup, tuning, application support, auditing.

System Design and Development Responsibilities:

• Using Functional Requirement Specification document to get the user requirement
• to analyze, design and develop this project.
• Extract the schedule information from the Train Planning Scheduling System TPSS and fare information from the M R system.
• Created the physical and logical data model using Erwin.
• Generate the routes through dbms scheduler by weak day and weekend partitions and monitoring the cross over train, business rules, departure and arrival timing, running date, peak hour, non-peak hour, published, non published connection, West East Connection and Straight line Connection.
• Developing the retrieval package with the ref cursor to retrieve the routes between departure and arrival station for IVR/Agent/Web application with different time frame.
• Developing and maintaining train, train stop, station and branch special messages, which includes bus indicators and IVR messages.
• Implementing the business logic for shea program on event game day.
• Implementing the entire, none, first, second and third connection suppression logic.
• Using PL/SQL features to write data loading routines for the interim and final tables.
• Use of libraries, triggers, and built-ins, complex program units functions, procedures to implement business logic.
• The C2S and C2P process to copy trillions of data to final SFPUBLIC environment for customer performance.
• Monitoring the Copy to production table's data and routes combination
• Using PVCS Version Manager for version management of the codes.
• Create entity-relationship diagrams and physical data model diagrams using ERWIN for technical documentation.
• Creating the user documents and technical documents to maintain this project.

Environment: AIX, Windows, Oracle 9i/10g/11g, Oracle Recovery Manager, Oracle Enterprise Manager, EXP/IMP, PL/SQL using PL/SQL Developer 7.1 and TOAD 9.1, perl, SQL Loader, Warehouse Builder, Oracle Report, XML Publisher Report, Erwin, PVCS, Oracle ADF.

CONFIDENTAIL

Oracle Database Administrator/Database Developer Architecture

CONFIDENTAIL.

System Design and Development Responsibilities:

Using PVCS Version Manager for version management of the codes.

• Performed the RMAN complete recovery, tablespace recovery, datafile recovery, controlfile recovery, online redo log file recovery.
• Creation and maintenance of test schema.
• Advanced performance tuning techniques using Oracle wait interface.
• Oracle replication advanced replication, materialized views etc .
• Configured and maintenance Oracle Data guard for production database and standby database support.
• Devising various solution methodology, process definitions, job management, execution plans etc.
• DBA script development and maintenance.
• Database connectivity tnsnames, listener, database links, synonym etc. .
• Database user and role administration.
• Oracle database performance tuning using statspack, explain plan, tkprof and OEM.
• Design and implement DB security, user management
• Created the physical and logical data model using Erwin.
• SQL and PL/SQL: scripts, triggers, procedures, packages, and automation projects
• High availability, 24/7, Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
• Created multiple customized PL/SQL Packages for various businesses needs and modified existing packages to improve performance.
• Created and manipulated Nested and Index-By tables i.e. PL/SQL Tables .
• Manipulated PL/SQL tables and VARRAYs with BULK BINDS and BULK COLLECTS.
• Monitoring alerts and Checking database free space, allocating and maintaining free space for optimal Database performance.
• Experience in Siebel Administration Management System Application and Production Support including deployment and migration activities from Development through Testing in Production environment.
• Environment: Oracle 9i and 10g, Oracle Siebel CRM 8.0, SQL, PL/SQL, SQL Loader, perl, Oracle Enterprise Manager, Oracle Recover Manager, Report 10g, Warehouse Builder, XML Publisher, Windows NT, Sun Solaris, Oracle 10g AS, Erwin, PVCS Version Manager, CVS Version Manager.

CONFIDENTAIL

Role: Database Developer/DBA

Perfect Technology Solutions is a full-service specialty-staffing firm providing flexible and permanent staffing solutions for hiring organizations and career management in the specialty skill areas of Information Technology, Finance and Accounting and Pharmaceutical.

CONFIDENTAIL

System Design and Development Responsibilities:

• Oracle DBA support including installations, configurations, backup/restore recoveries, database performance tuning, tuning applications, database monitoring operating system configurations, assisting in the logical and physical database and providing general support to developers.
• Daily house keeping activities like checking database growth and taking appropriate actions for capacity management
• Ensuring availability of all tablespaces and data files
• Making changes to the parameter file as requested by the customer and ensuring a clean database startup for the changes to take effect
• Oracle User management tasks including creation of User Accounts, assigning privileges, Password change and dropping user as per client request.
• Built version control environment for vendor binaries and script storage.
• Safe Guarding Customer Data by ensuring that tables with sensitive and critical data can be accessed by only selected group of users as per client requirement
• Monitoring alerts and Checking database free space, allocating and maintaining free space for optimal Database performance.
• Using EXPLAIN plan utility to analyze the cost involved in query processing and tune it for faster retrieval.
• Data extraction, loading and manipulating using SQL Loader, Export/Import utilities using direct and conventional paths.
• Monitoring Alert log and background trace files for warning, alerts and error messages.
• Writing back end objects like stored procedures, functions, anonymous blocks, triggers, views using PL/SQL.
• Using parameterized / non-parameterized explicit and implicit cursors, UTL file functionality on PL/SQL blocks.
• Writing exception handling routines to trap error codes / messages on PL/SQL blocks. Writing scheduled scripts/batch procedures for database backups.
• Using PVCS Version Manager for version management of the codes.
• Designed the security maintenance module around the system based on the user responsibility.

Environment: Oracle 8i, OEM, RMAN, Oracle Designer 2000, SQL, PL/SQL, SQL Loader, Developer 2000, Discoverer 4.1, Windows NT, Sun Solaris, IIS, J2EE JAVA, JSP, JDBC, HTML, DHTML.

CONFIDENTAIL

This system was developed for Saravana Finance Limited. It deals with various deposit modules, loan modules and hire purchase.

System Design and Development Responsibilities:

• Managing various kinds of backup and Recovery Issues, online backup and offline backup
• Maintain data security by creating views, DB owners/users and granting/revoking permissions and roles.
• Monitoring the Database for growth and add space to the table spaces.
• Cloning of the production database to the test and development for testing and development purpose.
• Monitor, tune, size, backup, recover, analyze, defrag, migrate
• Created and utilized SQL Loader script to load data into database
• Use of libraries, triggers, and built-ins, complex program units functions, procedures to implement business logic.
• Involving in the testing.
• Participating in the development of several standards for data conversion Uploading data process as per client requirements.
• Providing the User training on the system and problem solving and Development and maintenance the project documents and User guides.
• Data Analysis and Designing.
• Using PL/SQL features to write data loading routines for the interim and final tables Modified existing Oracle Back-end to implement the new business logic.
• Using Oracle Warehouse builder to mapping the Source to Target and improve the performance.
• Environment: The project was developed using Oracle 7.3,8i, sqlplus, Forms 4.5, Reports 2.5 PL/SQL on Pentium PC