SUMMARY OF QUALIFICATIONS:

• Over TWELVE years of experience working as Oracle Database Administration in OLTP, production support DBA and data warehouse systems. Installing, Optimizing and Administering of Oracle Database.
• Involved in Technical project implementations, Requirements Analysis, Workflow Analysis, Business process design and Standard Operating Procedures.
• Experience in gathering user requirements, Planning, Data modeling, Data structure, Tables, Database designs, Normalization, Stored Procedures, Database Instance Creation. Strong Experience in Oracle 11g/10i/9i/8i on different UNIX platforms and Windows.
• Implementation and maintenance of Oracle Real Application Cluster RAC . Experience working with Oracle 10g Automatic Memory Management, Oracle Flashback and FGA.
• Experienced in writing Stored Procedures, Functions, Packages, Handling Exceptions, creating database triggers using SQL and PL/SQL in Oracle 10G Grid control/DB control through Oracle Enterprise Manager.
• Comprehensive experience of using Oracle partitioning options, materialized views and external procedures, in order to gain best performance. Managed and maintained Golden Gate Processes. Provided troubleshooting for abended processes.
• Extensive experience of communication with Oracle Support for various production level issues, Oracle bugs and severity issues. Adept in User Managed and Server Managed online and offline backup and recovery, using RMAN and conventional methods.
• Tuning the Databases for optimization using STATSPACK/AWR reports. Extensively used Oracle Enterprise Manager OEM for maintaining and monitoring databases.
• Hands on experience in transferring Non ASM Oracle systems to ASM and vice versa. Understanding of Data guard and standby database architecture implementation. Expert in designing and implementing backup and recovery strategy to best utilization of resources.
• Adept in SQL Loader, Data Pump Export/Import, conventional Oracle Export/Import utilities in order to load, unload and migrate data. Excellent analytical, problem solving, communication and time management skills.
• An excellent team player that understands the critical nature of DBA activities with 24/7 support. Flexible to adapt for new environment and willing to learn new technology. Worked extensively with Forms 9i/6i/4.5 and Reports 9i/6i/2.5.
• Oracle Certified Database Associate OCA .
• Project Management Professional PMP .
• Microsoft Certified Systems Engineer MCSE .
• Oracle 8i Certified Professional Internet Application Developer OCP .

TECHNICAL SKILLS:

• Databases: Oracle 11g/10g/9i/8i, Dbase, FoxPro, SQL SERVER 2005.
• Operating Systems: Sun Solaris, HP-UNIX, Red Hat Linux and MS-Windows NT/2003/XP.
• DBA Tools: Oracle Enterprise Manager, TOAD, Export Import, Data Pumps, Flash Back, SQL Loader and RMAN.
• CASE Tools: Oracle Designer 10g/9i/6i - Data Modeling, Process Modeling, Entity Relational Diagramming and Erwin
• Front-end ToolsL: Visual Basic, Forms / Reports Interfaces.
• Programming Languages: SQL, PL/SQL, Korn Shell Script, BASH Shell Script.
• Application Servers: Oracle Application Server 9i / 10g.
• Hardware: Diploma in Assembling and Maintenance of PC's, Novell Netware Servers, Windows NT 4.0 / 2000 / 2003 environments.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Installed 9i and 10/11g on many servers. Upgraded 8.1.7 to 9.2.0 on many servers on different platforms. Monitoring and Managing Oracle 11g, 10g, 9i, 8i etc Databases. Provided On-Call DBA support as a member of a dedicated 24/7 oncall DBA team for 2000 production Oracle databases ranging form 8i to 11g.
• Responded promptly to On-Call pagers / email alerts due to issues arouse from a wide range of architectural and functional features. Eg. Replication Golden Gate , Data Guard, RAC, ASM, Streams, Bigfile tablespaces, Materialized view, DBA Job and scheduler job, RMAN etc.
• Worked PDBA Team production on call 24/7 support for department of AT T IT Architecture and Common Services Integration handling more than 2500 MCA Mission Critical Applications production RAC, non RAC databases includes supporting Iphone databases, MCA production and Lab databases
• Taking backups from prod and restoring on labs Install /maintain /monitor RMAN ABS scripts for database and archive log backups, working under flashback technologies.
• Create AOTS change tickets for production maintenance follow-up and manage approvals . Provide appropriate knowledge transfer to teams, if there are any specific or unique situations that require special instructions.
• Ongoing support, which requires shutting/starting databases, setting different parameters, adding space, AWR backups or other ad-hoc requests.
• Designed Backup strategies and wrote scripts to manually implement it. Implemented Backups on Disk, using Veritas Net Backup and BCV. Heavily involved in Capacity planning and Performance tuning. Worked to bring all systems in compliance with Sarbanes-Oxley SOX .
• Migrate/upgrade/installation Oracle 10g to 11g on multiple platforms Rac/Non-Rac - AIX 5, 3, 6.3, Solaris 10, 9, HP-UX 2.3, 3.1, Linux, Performed all analysis, patching, system setup, migration strategies, grid and day-to-day administration, troubleshooting
• Worked in Sun Cluster environment with Oracle RAC. Managed and maintained Golden Gate Processes. Provided troubleshooting for abended processes. Designed Data Warehouse projects including Data Design, Tools selection, Designing Target databases, Defining data sources etc.
• Installed Configured and Administered Informatica 6.2 and successfully created many Transformations. Providing database support to the developers. Helping in writing shell scripts to automate the processes. Working in HP-UX, Sun Solaris and Linux environment. Worked with MY-SQL on HP-UX.
• Validating, implementing, coordinating, tuning changes at DB-Instance and or App-SQL level. Create and maintain DATAGUARD/TRA sites logical or physical per design standards. Re-instantiate standby or manually sync up as needed.
• Monitor golden gate processes extract, pump, replicat and stop/start any ABENDED processes as required. Monitor STREAMS processes capture, propagate, apply and restart any ABORTED processes as needed.
• Working in a 24/7 environment with ON-CALL rotation. Managing Oracle 8i, 9i Databases. Designed Backup strategies and Disaster Recovery plans. Used Cognos extensively including Impromptu and Powerplay. Creating new instances and schemas for various projects.
• Helping in writing shell scripts to automate the processes. Mentored other DBAs and Developers. Working in HP-UX and Sun Solaris environment.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 11g/10g/9i/8i on Solaris and created the test database for the Application. Migration and up gradation of Database 8i to 9i. Maintenance Oracle 8i servers as production and test database. Writing Rman backup Scripts and testing on the database.
• Installed and applied patches for the same from the metalink site. Involved in load testing and capacity planning of Production/Development databases. Configured and implemented RMAN utility 8i/ 9i for backups and recovery. Prepared and implemented the backup and recovery strategies.
• Conducted disaster recovery trails from missing data files, redo logs and entire database using the backups. Automated the database maintenance procedures, Ex. Gather statistics, rebuild indexes. Like Clean up log files, cycle alert log at server startup etc.
• Developed shell scripts, tuning queries, PL/SQL procedures to monitor the databases. Involved in Troubleshooting and Supporting databases, applications and development tools. Created and Maintained Documentation of databases and the related products.

Confidential

Oracle Sr. DBA / Data Analyst

Responsibilities:

• Installation, configuration and maintenance of Oracle Database 10g. Systems management and monitoring using Oracle Grid Control. Managing users, policies and implementation of security controls. Gathered user requirements and was involved with planning, data modeling.
• Design logical and physical database for optimization, fulfill backup needs and minimize downtime. Patching and upgrading of Database and applications. Managing concurrent programs and load balancing.
• Cloning the production environment to prepare development and UAT environment for development and implementation purposes. Worked as bridge between development team and business consultant.
• Tracing and analyzing user and applications sessions. Application Tuning to improve performance.

Confidential

Oracle DBA / System Developer

Responsibilities:

• Multiple RAC and standalone Oracle software installation and Database migrations as part of the current system migration process from Oracle 9i to 10g. Played a vital role in multi tera bytes data warehouse project as a Database Administrator DBA .
• Provided the optimum database design and backup and recovery policy that meets the business requirement and standards. Gather business requirement and provide logical and physical database design. Performance testing and tuning of the SQL code. System analysis of projects, design, development, documentation and Implementation.
• Also providing In-house training to the Staff and User with full demonstrations of the software. Training other team members for their skills enhancement as directed by the administration.

Confidential

Oracle DBA / Network administration

Responsibilities:

• Oracle software installation and Database migrations as part of the current system migration process from Oracle 8i to 9i. Played a vital role in multi tera bytes data warehouse project as a Database Administrator DBA .
• Provided the optimum database design and backup and recovery policy that meets the business requirement and standards. Gather business requirement and provide logical and physical database design. Performance testing and tuning of the SQL code.
• Provide the blue print of Oracle Infrastructure for production environment. Systems management and monitoring using Oracle Grid Control.
• Write SQL and PL/SQL scripts in order to implement business logic for various complex daily operations.

Confidential

Leader / Oracle DBA

Responsibilities:

• Supervision projects development in Oracle 8i / Forms6i and MS Visual Basic 6.0. Administration Configuring MS Windows NT 4.0 / 2000 Business Server Network with SQL Server 7.0 and ORACLE 8i Enterprise version.
• Websites Designing and Development. Internet Information Server 4.0 administration and creating company's workgroup Intranet Sites. Backup and Recovery of Oracle Databases. Design of the new database for the application using Erwin.
• Installing the Oracle server, client. Allocating system storage and planning future storage requirements. Creating primary database storage structures Table space with appropriate placement of data files for maximum efficiency and performance.
• Creating primary objects tables, views and indexes as required by the application design. Modifying the Database structure as necessary. Controlling and monitoring user access to the Database.
• Monitoring and optimizing database performance. Planning for backup and recovery of database information.

Confidential

Oracle Software Developer / Analyst

Responsibilities:

• Software development with Oracle / Developer 2000 tolls and handling client's requirements. Maintaining documentations and installations of client's machines with Accounting, Inventory modules. Administrating Oracle database and doing backup procedures for clients in UNIX environment.
• Design of the new database for the application using Erwin. Installing the Oracle server, client. Allocating system storage and planning future storage requirements. Creating primary database storage structures Table space with appropriate placement of data files for maximum efficiency and performance.
• Creating primary objects tables, views and indexes as required by the application design. Modifying the Database structure as necessary. Controlling and monitoring user access to the Database.
• Monitoring and optimizing database performance. Planning for backup and recovery of database information.