SUMMARY:

• Over 7 Years of experience as Oracle Database Administrator. Oracle Exadata, Oracle 12c, 11g RAC/10g RAC/9i/8i databases running on different environments such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup Recovery, Performance Tuning, capacity planning, shell scripting, and documentation.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g and 12c with experience within very large scale database environment and mission critical OLTP and OLAP systems.
• Experience in upgrading databases from 9i to 10g, 10g to 11g, 11g to 12c.
• Proficiency in Dataguard administration such as Failover, switchover, Rebuild.
• Good experience Conceptual, Logical and Physical database design.
• Experience in OLTP/DSS database systems, implementing and managing Very Large Databases VLDB .
• Hands On Experience in installing, configuring and managing Oracle 11g RAC, Oracle 10g RAC
• Performance monitoring and tuning using EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, , AWR, ADDM.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery, Performance Monitoring and Tuning, Capacity Planning and documentation.
• Migrated databases from Windows to Linux, Sun Solaris to AIX.
• Good experience on Oracle Support processes.
• Data transfer with Export, Import, Data Pump and SQL Loader utilities.
• Database backup concepts and options such as user-managed backup, RMAN incremental backups.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Good experience with GoldenGate setup replication.
• On call 24x7 Production Support Worked beyond regular hours.
• Dealing with database security and auditing.
• Excellent communication, interpersonal and strong analytical skills, Documentation Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr.Oracle DBA

Responsibilities:

• 24x7 production database and applications support.
• Installed and Configured Oracle 12c RAC for high availability.
• Database upgrade from 11gR2 to 12c.
• Migrated databases from Windows to Linux.
• Taking Oracle HOT, COLD backups, RMAN incremental backups.
• Clone database from production to development and testing.
• Support and advise the development teams on database related issues.
• Installed and Configured GoldenGate.
• Trouble shooting and performance tuning golden gate replication.
• Assisted developers in creating Stored Procedures, Triggers, Functions, Packages.
• Responsible for memory and Application tuning of the databases using Oracle utilities like OEM, SQL Trace, TK Prof, Explain Plan, AWR, ADDM.
• Partitioning of large tables for better performance and management.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Involved in root cause analysis, problem solving, issue tracking and support in production.
• Written scripts for custom monitoring.

Environment: Oracle 12c, 11g RAC, 10g, SQL Server, Red Hat Linux , IBM AIX, Data Guard, ASM, PL/SQL, RMAN, GoldenGate.

CONFIDENTIAL

Role: Sr. Oracle DBA

Responsibilities:

• 24x7 on-call production database support.
• Installation and Configurations of Oracle 12c, 11g
• Configured Oracle 11g RAC and Standby Databases for high availability and disaster recovery/reporting purpose.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.
• Upgraded Oracle Database from 9i to 10g, 10g to 11g, 11g to 12c
• Migrated databases from Sun Solaris to IBM AIX, Windows to Linux.
• Consolidated databases to Exadata.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Upgraded production databases from 10g to 11g without downtime using Golden Gate.
• Expertise in recovering the database. Performed complete and incomplete database recovery.
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments
• SQL tuning and Database performance tuning using SQL Trace, TKPROF, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities .
• RMAN Incremental backups
• Logical and Physical Database Design
• Capacity Planning and bench marking
• Partitioning of the tables for better performance and manageability
• Creating Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and automatic session history.
• Cloning databases from production to development and testing.
• Database Security User Management, Privileges, Roles, Auditing.
• Provided documentation for database design, analysis, modifications, creating schemas etc.
• Golden Gate installation and configuration.
• Replication using Golden Gate.

Environment: Oracle Exadata, Oracle 12c, Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, ERWIN, Data pump, GoldenGate

CONFIDENTIAL Role: Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Implemented Data Guard for Disaster recovery.
• Worked on Data Modeling, Dimensional Data Modeling.
• Setup and configure Standby database for high availability by using Data Guard.
• Upgraded databases from Oracle 10g to oracle 11g
• Replication using Oracle Streams.
• Documented instructions for migrating upgrading databases.
• Refreshed schemas from Production environment to Dev/Test environment using expdp/impdp utilities.
• Wrote various shell scripts to automate tasks.
• Creating PL/SQL procedures for Extraction, Transformation and Loading of data
• Created schema tables, Indexes, views, sequences, synonyms, packages .
• Setup database auditing, granted privileges to users through system/object roles.
• Implement and maintain database security.
• Created PL/SQL Procedures, Functions, Triggers.
• Taking Hot and cold backups.
• Modified Data Using Perl Scripting
• Creating and managing partitioned tables and indexes.
• Monitor and tune database performance using Explain Plan, SQL Trace, TKPROF, AWR, ADDM
• Increased performance of sql queries by creating materialized views and by enabling query re-write.
• Environment: Oracle 11g RAC, Oracle 10g RAC, HP-UX, RedHat Linux, Sun Solaris, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, ERWIN, Data Pump

CONFIDENTIAL, Role: Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Load data into Oracle using SQL Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Creating users and roles for database and give the privileges.
• Performance monitoring and tuning using Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM .
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Automated the Replication process using Materialized Views for reporting databases.
• Using the ADDM to analyze performance problem and with help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: locking, corruption, disk spaces and Performance issues.
• Cloning of production database to the test environment using Recovery Manager RMAN .
• Created Standby databases for Disaster Recovery, using Data Guard.
• Load data using SQL Loader
• Backup and Recovery
• Created database objects like tables, views, indexes, partitions.
• Develop, document and enforce database standards and procedures.
• Setting Oracle Streams for replication between two databases.

Environment: Oracle 10g RAC, Oracle 9i, Sun Solaris, RedHat Linux, IBM AIX, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, Data Pump

CONFIDENTIAL, Role: Oracle DBA

Responsibilities:

• 24x7 on-call production database support.
• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Performed backup and recovery activities.
• Daily database administration tasks including backup and recovery using RMAN, Import/Export.
• Designed the database schema and created any necessary database objects.
• Applied patches, upgraded databases
• Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL Trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Assist application developers to meet their day to day requirements related to performance.

Environment: Oracle 10g RAC, Oracle 9i, IBM AIX, Windows, RedHat Linux, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL Loader, Data Pump

CONFIDENTIAL

Role: Oracle DBA

Responsibilities:

• Responsible for maintenance of production.
• Created tables, views, materialized views
• Database administration tasks included performing regular Hot Cold Backups, Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments
• Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Maintenance modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL Loader.
• Develop, document and enforce database standards and procedures.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL Loader, Data Pump