PROFESSIONAL SUMMARY:

• Over 10.5 Years of IT Eperience with 10 years as Oracle DBA, providing 24/7 support for both development and production databases on Various Platforms like Red Hat Linux, IBM - AIX, Sun Solaris and Windows.
• Proficiency includes Production DBA, Tuning, Clustering, Backup and Recovery, Optimal Flexible Architecture in standalone and clustered environment.
• Experience in installation, configuration of Oracle 12c/11g/10g.
• Experience implementing and using SHAREPLEX with advanced queuing.
• Experience in implementing real application cluster Oracle 12c/11g/10g RAC.
• Experience in Disaster recovery support using Data Guard.
• Proficient in Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF, STATSPACK, SQL TRACE, custom scripts and wait interface.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Experienced in Troubleshooting and resolving critical production issues in complex application environment: SQL*net connectivity issues, locking, OS/network issues.
• Creating Oracle complex stored procedures and views for ETL process, creating SQL*Loader scripts and Oracle external tables.
• Excellent knowledge on Oracle 11g/10g features like AWR, ASM, 10g Grid monitoring.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Experience in backup and cloning using RMAN procedures.
• Experience in Data Migrations using oracle export/import, Data Pump, SQL*Loader.
• Proficient in using OEM 11g/12c and Oracle Grid Control.
• Experience in Proactive monitoring, identifying areas that need to be improved in the application and database.
• Expertise includes management of schemas, objects & partitioning the tables & indexes.
• Providing Solutions to the Problem Faced by end Users or Programmers.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.
• Experiance in various Oracle Financial applications like PeopleSoft, Oracle EBS etc.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger, Oracle Payables, Oracle Receivables and Oracle Cash Management.

TECHNICAL SKILLS:

Operating System: Red Hat Linux, Solaris, HP-UX, AIX, Windows

Databases: Oracle 8i/9i/10g/11g/12c, RAC 10g/11g MS-Access, SQL Server

Languages: SQL, PLSQL, Java, C, C++, XML, HTML, ASP.NET, C#, UNIX shell scripting.

Web Servers: Apache, Web logic

Tools: and Utilities(ORACLE): Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF, Golden Gate, Streams

Other Tools: ERWIN, DB Visualizer, Microsoft Visio, Use cases, SQL Developer, OEM, VM ware, Filezilla, putty, TOAD, Query Builder, VNC, WINSCP, APEX.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Senior Oracle DBA

Responsibilities:

• Database design, master data management, maintenance and editing within a variety of systems.
• Provided 24x7 on call production support to troubleshoot complex and sometimes cross-platform issues.
• Extensively used datapump which is a feature of Oracle 11gR1 throughout the project.
• Capture technical requirements, coordinate with other system managers/administrators, and develop solutions for data exchanges to include web services.
• Implementing backup and recovery procedures including logical backup (RMAN), physical backup (online/offline) and integrating the backup procedures.
• Assist with developing methods and solutions to increase data quality.
• Assist team members with internal requests for data, mapping, and analysis.
• Assist in the evolution of a maturing data model, including geospatial elements.
• Support field data collection activities from the office to maximize work efforts.
• Experience working with Oracle versions 10g and 11g in a UNIX environment a must.
• Strong programming experience in PL/SQL and UNIX shell scripting.
• Scalability/HA solutions included Oracle RAC, implemented and supported Shareplex for Data replication, supported Oracle Golden Gate Replication and Active Standby(11gR2).
• Maintained users, roles and privileges in Oracle database for the development team.
• Extensively used Performance and Tuning tools like AWR, ADDM through out the project both in command prompt and 12c OEM interface.
• Applied Smart Scan,Flash Cache,Hybrid Columnar Compression IORM in exadata.
• Expertise in Oracle 11g, Oracle Exadata, RAC, Data Guard, ASM, RMAN, PL/SQL, OEM, Oracle Enterprise Linux, HP-UX
• Performed Installation, configuration, troubleshooting Oracle RAC Database in 11gR2.
• Assisted in disaster recovery procedures and recovery using Data Guard in both 11gR2 and 10g.
• Responsible for Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Carried out disk space maintenance on various UNIX servers. Provided suitable mount points for each database and additional disk space for testing purposes.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger.
• Experience in working with datawarehouse products.
• Provided Oracle installation support, database maintenance, version control for source code and backup using RMAN with new features of 11gR2.
• Set up Apex enviromment and SSL configuration.

Confidential, Dallas, TX

Senior Oracle DBA

Responsibilities:

• Developed, reviewed and enforced database standards.
• Backed up and Recovered of large databases RMAN as well as Netbackup.
• Involved in Oracle database performance tuning and troubleshooting.
• Troubleshooted database performance issues and also help team mates understand the resolution process.
• Ran various AWR, ASH reports and 10046, 10053 trace files to identify potential performance problems.
• Applied SQL statement tuning skills.
• Worked independently as well as excellant interpersonal communication skills.
• Checked disk groups space and limitation in a RAC environment.
• Checked Volumes Informations in each RAC instances.
• Expert in Production Oracle 10g/11g environments including RAC, PL/SQL, OEM,RMAN,Data Guard and shell scripting.
• Responsible for DBA functions and ETL development in Data ware housing.
• The ability to spot potential problems from AWR reports and the knowledge to propose appropriate solutions.
• Mentor database team and developers on new database technology, provide database design and architecture oversight.
• Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Worked in Linux, Solaris, and AIX operating systems.
• Participated in various data replication like Active Data Guard, Streams and/or Goldengate.
• Involved in installation, administration and troubleshooting Oracle Golden Gate.
• Able to prioritize and execute tasks in a 24 x 7 production environment.
• Worked with development teams on all aspects of database design including tables, views, stored procedures, packages and manage role based grants.
• Involved in Goldengate installation and troubleshooting.
• Actively participated in RAC installation, administration and troubleshooting.
• Administered patching in a 3 node RAC environment.
• Conducted integrated capture and logical change record in Oracle Golden Gate.
• Applied various process in Oracle Golden gate.
• Involved in installation, administration and patching of 12c OEM Oracle database environment.
• Deployed and supported Exadata.
• Checked parallelisim instance parameter in Exadata.
• Participated in Exadata database migration.
• Participated in MySql server administration.
• Worked in ASM storage devices mainly mirroring and striping.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger, Oracle Payables, Oracle Receivables and Oracle Cash Management.
• Applied various PL/SQL scripts in Oracle database projects.
• Supported Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems, for applications with data warehouse and OLTP components.
• Effectively participated in EMS with servers, databases and schemas, view, edit, search, group,sort and filter any data stored in a database.
• Set up USER access and Security Modal definition using APEX.

Confidential, Richmond, VA

Senior DBA

Responsibilities:

• Worked in the group as a technical team lead providing support to development teams to create database objects, schemas, tables, indexes etc.
• Provided support to development teams to create database objects, schemas, tables, indexes etc.
• Administered Oracle Real Application (RAC) system and standalone database environment.
• Involved in checking CRS status in an oracle RAC environment in 11g and 10g environment.
• Check OCR and VD backup locations in an Oracle RAC environment regularly.
• Performed recovery from instance and media failures.
• Worked with ETL - Informatica teams and developers to co-ordinate data loads, EIP releases & iterations from data warehouse database to OLTP databases.
• Performed capacity planning and space management.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Developing and reviewing PL/SQL stored procedures.
• Created physical and standby databases in a Data Guard environment to use as reporting and an alternate failover database.
• Responsible for add and remove ASM disk group.
• Monitoring the instances in a 3 node RAC cluster.
• Excellant knowledge about Advanced Encryption Standard in Oracle Golden Gate.
• Monitored checkpoints and various Golden gate errors.
• Worked with various files in Oracle Golden gate like GLOBALS, ggserr.log, dirprm.
• Experience in installation, and maintenance of Oracle Exadata machines.
• Knowlege about various events in Exadata.
• Applied various shell scripts in oracle database projects.
• Experience in Mysql server database troubleshooting.
• Have assisted several project managers in reporting and activity management on a daily basis.
• Used Oracle Exadata for DBA activities and advanced queuing while replication.
• Performed cronjobs mostly backup jobs using crontab utility in Linux Operating System.
• Experience in using TOAD for SQL Development and DBA tasks.
• Experiance in working VMWare Server which is virtualization of server with RDB.
• Experiance in using OEM and command line for Performance and Tuning tasks
• Work closely more deep into 11g architecture viz. PGA, SGA and oracle logical structure as well as physical structure.
• Participated in Oracle EBS for higher level business application.
• Monitored Oracle Goldengate replication and used logdump utility to read tracefiles.
• Effectively participated in EMS for creation and execution of SQL queries with powerful SQL editor, handle multiple selected objects Confidential a time.
• Ad hoc issues and resolution was taken care of using APEX.

Environment: Oracle 11gR2/10g, Red Hat Linux, Golden Gate,SQL Loader, Toad,ETL, OEM, Shell Scripting.

Confidential, Milwaukee, WI

Senior Oracle DBA

Responsibilities:

• Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.
• Configured RAC Physical standby database for RAC primary using ASM filesystem in 11gR2.
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall in standalone as well as clustered environment.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Monitoring and maintenance of multiple databases for production, development, testing.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• 24 X 7 on call support of all production environments in group supported by our team.
• Utilized Various Raid levels such as mirroring and stripping with parity.
• Data migration between environments using Export/Import, expdp/impdp, Transportable Tablespace and Oracle Streams.
• Support Oracle databases forhigh transaction OLTP and Large Data Warehouse databases.
• Implemented Golden Gate Technology on Oracle 11g/10g.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Administered Oracle Real Application cluster (RAC) system both 11gR2/10g.
• Written Shell scripting which monitors the server’s performance and logs output on periodic basis to database using Perl Scripting.
• Experience in using flashback feature of oracle throughout the project.
• Oracle Exadata Management was efficiently used in the project.
• Oracle Apex was used moniter patching and performance.

Environment: Oracle 11gR2/10g, RAC, RMAN, PL/SQL, Stored procedures, SQL*Loader, Toad for Oracle, GoldenGate, OEM, SQL Loader, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential, Hightstown,NJ

Senior Oracle DBA

Responsibilities:

• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace, TOAD.
• Assisted in configuring disaster recovery procedures using Standby Data Guard setup.
• Refresh/Cloning of Database and applications for development,testing.
• Involved in taking periodic Backup of the Database and the software using RMAN.
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Performed Performance tuning for optimized results using tools like Explain Plan, TKPROF and STATSPACK.
• Performed ASM Configuration, maintenance and monitoring in standalone and clustered environment.
• Resolving any databases issue like database down, file system space issue, Agent issue etc.
• Worked in the matters of performance issues, major reorganizations and auditing the required down times.
• Migrated flat files from different sources into Oracle Database using SQL*Loader.
• Performed Cross Platform transformation of the databases.
• Worked with Real Application Cluster (RAC) database in test environment.
• Performed Golden Gate setup,extract,pumping and replication processes
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Managing archived redo files, DB-links, Partitions and monitoring Alert Logs.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity
• Wrote database PL/SQL stored procedures, triggers and procedures to provide backend security and data consistency.
• Worked with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure .
• Involved in analyzing and determining information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
• Extensively used Oracle Exadata throughout the project.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining.
• Installed, Configured, Upgraded & Applied patches for Prod & Dev Servers.
• Creating table spaces, tables, and users for custom applications. Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required Capacity Planning & Benchmarking using analysis from STATSPACK reports.
• Participated in customising various modules of Oracle Financials.

Environment: Oracle 10g, RAC, RMAN, GoldenGate, TOAD, Sun Solaris, UNIX Scripting, LINUX, AIX,PL/SQL.

Confidential, NY

Oracle DBA cum Developer

Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, maintenance and tuning of Oracle 10g RAC/11g RAC database for high availability.
• Performed upgrades from Oracle 9i to 10g, 10g to 11g
• Involved in Design and Implementation of physical/logical standby databases for disaster and reporting
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Closely monitoring and administering log transport services and log apply services in physical/logical databases.
• Used shell scripting for RMAN backups and hot backup and recovery.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Implemented Backup using RMAN (Recovery Manager) as a media management layer.
• Have worked on building complex logical data models, reverse engineering and forward engineering using sophisticated modeling techniques and tools like Erwin and Visio.
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views.
• Performance tuning i.e. tuning RAC, applications, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/ Logical I/O and Memory usage.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Consulting and advising with developers on the design of applications having complex database considerations, design custom database objects as required and recommended data access solutions that best fit the needs of the application.
• Used export/import for schema, table and database refresh.
• Supported bi-directional replication using oracle streams and designed the conflict resolution.
• Installation and administration of GoldenGate.
• Implemented Range, List Partitions, Hash Partitions,
• Creating and refreshing materialized views.
• SQL, PL/SQL programming. Written functions, procedures, packages and triggers.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects and also did the patch management for oracle upgrade.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and tuning.
• Have done database backup and recovery using(cold backup/Hot backup/ logical)
• Worked in various financial modules like Oracle Assets, Oracle General Ledger, Oracle Payables, Oracle Receivables and Oracle Cash Management.

Environment: Oracle 10g RAC/11g RAC/9i, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, RAC, RMAN,TKPROF,SQL-Trace.

Confidential, COLLIERVILLE, TN

Database Administrator

Responsibilities:

• Manage data architects, data administrators and client enhancement requests.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams & failover.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Created tablespaces, tables, users for custom applications.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Handling large database environments (Data warehouse) using ETL tool Informatica and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.
• Setup backup and recovery procedures using RMAN.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF
• Wrote PL/SQL procedure, functions, packages for various requirements in the database.

Environment: HP -UX 11.23, Linux 4.0, Windows 2003, Streams, ASM, Informatica, Business Objects Oracle 10g/9i, SQL*Plus, OEM, TOAD.

Confidential, San Ramon, CA

Oracle Developer

Responsibilities:

• Develop and maintain software; implement highly scalable components and reliable web applications in a high traffic transactional data and data warehouse environment using the latest technologies following software engineering best practices. Work with relational databases, SQL, and Oracle Webcenter.
• Develop data persistence based on commercial and open source relational databases.
• Provide thorough and automated unit test harnesses for developed solutions.
• Provide software development estimates outlining business and technical risks.
• Develop and deploy systems in an iterative, incremental process that fully incorporates testing.
• Contribute to enterprise software development initiatives.
• Participate in formal requirement, design, and code reviews.
• Regularly update technical and business teams as to plans, progress, and issues.
• Produce excellent, thorough, and concise development documentation.
• Analyze, modify and unit test software in support of customer issues.

Environment: Oracle 10g 11g/9i, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x.