Summary:

• 10 plus years of strong Oracle DBA experience, administering production and non production databases. Having in-depth knowledge of oracle architecture and oracle internals.
• Oracle 9i oracle certified professional.
• Oracle 10g RAC Certified Professional.
• Experienced on installation, configuration with Oracle OEM 10g to 12c .
• Configured 10gRAC on HP EXADATA.
• Involved in different scenarios of OLTP as well as DSS Data warehouse databases.
• Configured 11gRAC on ODA Oracle Database Appliance .
• Configured physical and logical standby databases DataGuard .
• Has Strong knowledge in Performance Tuning of databases and fixed many performance related issues.
• Installation, configuration and administrating Oracle GoldenGate replication.
• Administered MySQL databases.
• Involved in setting up Replication between Master and slaves.
• Strong knowledge of RMAN Backups and Recoveries.
• Versatile team player with excellent presentation, communication and inter personal skills.
• Configured OEM Grid.
• Proficient in UNIX shell scripting.
• Experience on GoldenGate environment.
• Good at writing PL/SQL procedures.
• Good at Erwin to design data model.

Professional Experience:

Confidential

Designation: Oracle DBA

Roles and Responsibilities:

• Installation, configuration and administrating Oracle GoldenGate replication.
• Worked as a team member to provide 24x7 on-call production database support.
• Excellent experience in installation and configuration of Oracle 8i, 9i, 10g and 11g in UNIX/LINUX and Windows environment.
• Experience in leading successful enterprise Oracle data warehousing efforts.
• Have great Knowledge of Oracle architecture.
• Extensive experience in developing applications using Struts Framework and different J2EE design patterns.
• Experience designing logical and physical architectures for Oracle data warehousing solutions.
• Experience in Oracle Data Integrator ODI , ORMA and Oracle PL/SQL Package.
• Good experience in SQL, PL/SQL, Shell Scripting, Parallelism, Partitioning, Data modeling, OLAP, Logical and Physical data model using ERWIN, Backup and Recovery procedures.
• Involved in meetings with data modelers, developers, and dba's.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data using external tables and SQL LOADER.
• Knowledge in the ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence .
• Strong knowledge of Data Warehouse and data mining analysis.
• Experience in using RMAN and DataGuard .
• Perform a risk assessment and design SOX infrastructure.
• Worked in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Oracle data warehousing concepts and web design and development.
• Works with Oracle data warehousing including ETL and reporting Business Objects .
• Monitored all the 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
• Involved in different scenarios of OLTP as well as DSS Data warehouse databases.

Environment: Oracle 12c, 11g/10g/9i/, DataGuard with physical and logical standby databases, Oracle Enterprise Manager, SQL, TOAD, AWR, ASH, ADDM, TPROF, Explain plan, STATSPACK, and Oracle GoldenGate replication from oracle to oracle databases.

Confidential

Designation: Oracle DBA

Roles and responsibilities:

• Worked as production database support, monitoring and administering production databases.
• Worked on creating 12c databases.
• Worked on setting Data Warehouse setup using PL/SQL Procedures and triggers.
• Worked on Data Warehouse Reports.
• Worked on writing SQL reports for in house data reports.
• Configured GoldenGate Active-Active replication with CDR Conflict Detection and Resolution .
• Worked on creating data encryption functions to encrypt application users password.
• Worked on creation database reports with encrypted data for some of the columns.
• Worked on writing PL/SQL packages and procedures.
• Monitored all the 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
• Worked on setting AUDIT on databases with respect to FEDRAMP, program.
• Worked on monitoring and configuring DataGuard.
• Worked on refreshing production data to development, QA and staging environments.
• Worked on Performance Tuning to resolve performance issues.
• Worked on 11g Installation and database creation.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Worked on configuring Oracle 11g two node RAC database on ODA Oracle Database Appliance
• Worked on database recovery.
• Monitored all the 11g databases on Linux environments and also monitored their performance by using OEM 11g and 12c versions.
• Worked on database upgrade from 10g to 11g.
• Created materialized views.
• Worked with application team for crating tables and database objects for quarterly production releases.
• Worked on Oracle Exadata.
• Worked on GoldenGate. Monitoring GoldenGate databases.

Environment: Oracle Linux, Sun Solaris, Oracle 10.2.0.3, 11.2.0.3, 12.1.0.2, ODA RAC

Confidential

Designation: Oracle DBA

Roles and responsibilities:

• Working as production database support monitoring production databases.
• Working on deploying tickets on daily basis.
• Involved in database design using Erwin and Relational/OLTP Modeling.
• Worked on refreshing production data to development by making use on rman duplicate command or rman cloning.
• Applied October 2009 CPU patches to databases.
• Provide 24 x 7 supports as an on-call DBA on rotational basis.

Environment: Linux, Sun Solaris, Aix, Oracle 11.1.0.6.0, 10.2.0.3

Confidential

Designation: Oracle DBA

Roles and responsibilities:

• Monitored more than 25 production databases.
• Administered databases of gigabytes in development, QA and production environments.
• Involved in refreshing production data to development and QA environment to keep development data in sync with production data by making use of expdb/impdb RMAN transportable tablespace.
• Worked on configuring GoldenGate setup.
• Configured 11g RAC with ASM on 2 nodes on HP EXADATA.
• Involved in applying CPU patches.
• Configured or set notification alert in Grid control to send emails with different metrics.
• Involved in upgrading databases from 9i to 10g.
• Installed oracle software on new servers and created databases on them.
• Configured Streams replication.
• Involved in rebuilding indexes.
• Involved in solving ORA errors like snap shot too old error, unable to extend temporary tablespace etc.
• Restored and recovered database using RMAN.
• Has a ticketing system and will work on tickets assigned to me.
• Edited some of the already available scripts.
• Provide 24 x 7 supports as an on-call DBA on rotational basis.

Environment: Linux, Sun Solaris, Oracle 11.1.0.6.0, 10.2.0.3, 10.1.0.4., HP EXADATA.

Confidential

Designation: Oracle DBA

Roles and responsibilities:

• Administered 30 databases of gigabytes in development, testing and production environments.
• Provide 24 x 7 supports as an on-call DBA on rotational basis.
• Implemented oracle 10g RAC with ocfs2 and oracle 10g RAC on Linux with A.S.M.
• Cloned databases from production environment to other environments.
• Perform regular space management tasks to ensure enough disk space.
• Involved in applying latest CPU patches.
• Involved in administrating MYSQL databases such as creating databases, users, tables, performing backups.
• Involved in migrating some MYSQL tables and oracle tables into oracle database.
• Involved in upgrading databases from earlier version to oracle 9i/10g.
• Monitored and optimized database performance using tools like STATSPACK, SQL tuning advisor, Tkprof, explain plan, auto trace utilities and SQL scripts.
• Set up replication on MYSQL master and slave.
• Involved in administration of MYSQL databases.
• Data warehouse DBA skills related to partitioning and materialized views.
• Involved in designing and implementing backup strategies for production databases.

Confidential

Designation: Oracle DBA

Roles and responsibilities:

• Involved in the installation, configuration and upgrading of the oracle database to 9i 10g.
• Involved in maintenance of separate production/quality/development/test databases and monitoring health check on daily basis
• Developed PL/SQL procedures, triggers, packages and dynamic SQL scripts
• Involved in implementation of backup and recovery policies and procedures.
• Was involved in cloning of production database to the test environment using recovery manager RMAN .
• Involved in creating roles and user administration.
• Monitored and optimized database performance using tools like STATSPACK, Tk-prof, explain plan and SQL scripts.
• Involved in writing Perl scripts.
• Assisted the Sr.DBA in database administration and performance tuning.
• Maintaining the space requirements, tablespace management.
• Created and developed UNIX shell scripts for automating backups and weekly cleansing scripts and scheduled them through cronjob.
• Involved in creating users and granting privileges to them.
• Implemented oracle 9i physical standby DataGuard for the production database running on oracle 9i as a recovery solution.
• Involved in killing the session which were taking much cpu spikes.
• Resolved tickets on priority basis.
• Provided 24x7 on call support on a rotational basis.

Confidential

Designation : Oracle DBA

Roles Responsibilities:

• Offline OS backup of Application/Database
• Online logical backup of Entire Database / User Schema
• Generate weekly reports on data integrity
• To ensure utmost accuracy of financial transactions and completeness of data entry.
• Managing users accounts Creating New Roles / Users / Profiles.
• Granting access on tables/views depending on job they do
• Managing tablespaces Dropping / Creating Tablespaces.
• Modifying Storage Parameters for Tablespaces depending on application requirement
• Managing Rollback segments. Dropping/Creating Rollback segments with appropriate storage parameters to reduce waits.
• Designing Data storage for New Applications database Tuning. Identifying and resolving contention with respect to Disk IO, Redo Logs and Rollback

Designation: Jr. Oracle DBA/Developer

Roles Responsibilities:

• Managing the databases remotely using VPN Client.
• Oracle Installation, Configuration management, Security and Monitoring, Backup and Recovery and Troubleshooting.
• Re-designed for new architecture, developed, customized and implemented the merchant rebate program.
• Allocation of system storage and planning future storage requirements for the database.
• Enrolling users and maintaining system security.
• Developed stored procedures and Database triggers.
• Participated in Tuning SQL queries for better performance, response time using indexes.

Qualifications:

• Bachelor of Engineering from Bangalore University, Bangalore, India.
• A PGDCA certified from Roopa Informatics October 2001- March 2002
• Completed a Course on Oracle from Roopa Informatics on November 2002

Technical Expertise

Databases

Oracle 8i, 9i, 10g, MySQL 5.0, 11.2.0.3, 12c 12.1.0.2

RAC

Oracle 10.2.0.3.0, 11.2.0.3

Operating Systems

UNIX Sun Solaris 5.0, IBM AIX, HP UNIX 10.x/11.0/11.x, Linux , Windows XP/98/NT/2000

Programming Languages

SQL, PL/SQL, UNIX Shell Scripting, Perl Scripting, MS-DOS Batch Scripts, COBOL, C,

Applications/Web Servers

Clarify, Oracle 9i AS R1 V 2.0.2.2.1 , Web Sphere, Oracle 10g AS R2 10.1.2 , Apache Web server 2.0, IIS 5.0, Tomcat 5

Packages Tools

ER/Studio, XML/DB, Erwin, TOAD, DBArtisan, OEM