SUMMARY

• Managed RAC databases.
• Build ASM Diskgroups and migrated non-ASM databases to ASM.
• Creating of both RAC and none RAC databases
• Build Data Guard
• Configure uni-directional GoldenGate Replication.
• Performs user managements that include the followings: - expire and unexpire of password after first login, lock and unlock users accounts etc.
• Performs day-to-day maintenance of databases and monitors database statistics;
• Performing task such as creation and dropping of tables, inserting of rows and ensuring that blocks, extent or segment are counted for.
• Ensures that sufficient backups are taken by operations to recover from any situation.
• Part of team responsible for proof of concept for creating new database, performing upgrades, patches for standalone and RAC databases before GO LIVE on production support.
• Performing task such as decommissioning of standalone and RAC databases.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Applied CPU and PSU patches on 10g and 11g.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Responsibilities:

• Managed RAC databases.
• Build ASM Diskgroups and migrated non-ASM databases to ASM.
• Creating of both RAC and none RAC databases
• Build Data Guard
• Configure uni-directional GoldenGate Replication.
• Performs user managements that include the followings: - expire and unexpire of password after first login, lock and unlock users accounts etc.
• Performs day-to-day maintenance of databases and monitors database statistics;
• Performing task such as creation and dropping of tables, inserting of rows and ensuring that blocks, extent or segment are counted for.
• Ensures that sufficient backups are taken by operations to recover from any situation.
• Part of team responsible for proof of concept for creating new database, performing upgrades, patches for standalone and RAC databases before GO LIVE on production support.
• Performing task such as decommissioning of standalone and RAC databases.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Applied CPU and PSU patches on 10g and 11g.
• Consistently conducting capacity planning and monitoring for the databases to ensure that disk space is adequate for new database creation and upgrades.
• Design and construct physical standby for Disaster recovery site.
• Defining the standards, to maintain the health of the server. RAC to RAC physical standby configuration of data guard for Disaster recovery requirement.
• Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
• Supporting the databases and ensuring their performance, availability and security.
• Involve in managing very large database with 20TB in size on a 6 node RAC cluster ensuring the fail over, load balancing and scalability
• Represent my team for compliance meetings, by coming up with test cases that ensures we are meeting with company’s compliance policy, resolved compliance failures based on the company policy.
• Generate AWR reports for performance analysis and tuning opportunities.
• Develop appropriate polices and plans relating to database backup, recovery, and disaster
• Recovery using RMAN. Improve the database performance by Using the Hints, Indexes, Explain Plan and TKPROF for effective retrieval and processing of queries.
• Resolving underlying GO LIVE performance issues.
• Provided on-call support.
• Coordinated tasks with offshore DBAs

Oracle DBA

Role & Responsibilities:

• 24x7x365 administrative support staff.
• Build multiple 11g R2 node RAC clusters.
• Configured Data Guard to provide high availability by implementing Physical stand by database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Designed DR using Data Guard.
• Add new nodes to RAC 11g Cluster to distribute the load. .
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Worked with Golden Gate installed two node, configured and administered GG environment
• Troubleshoot Golden Gate with unidirectional setup.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Familiar with ETL.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Worked on basic Linux OS system administration.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources on a daily basis,
• Able to work effectively with multiple teams at once.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Setup and documented Oracle GoldenGate replication on 11g for support team.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, 11g R2, 12c, 9iAS; Sun Solaris Unix, RHEL Oracle Developer, 11g R2, 12c Cloud control, GoldenGate

Sr. Oracle DBA

Roles & Responsibilities:

• Supported more than 30 databases including development/production sizes up to 5 TB for 24/7.
• Designed, Installed and configured the Oracle server software and related products. Upgraded 30+ databases from 9.2.0.6 to 10.2.0.1 to 10.2.0.3 to 11gR1/R2 on RHEL and AIX.
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump. Used AWR reports to monitor the database performance.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Upgrade Data warehouse Database from 8K block size to 32K block size to optimize performance.
• Worked on OLTP and Data warehouse farms.
• Refreshed multiple databases for Development and Testing upon short request.
• Served as part of a 7 member DBA team which was involved in the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.