SUMMARY

• Oracle Certified Database Administrator with around 8 years of experience in installing, configuring, administering and managing oracle databases & implementing solutions like high availability(HA), disaster & recovery
• Hands on experience on 11G Performance Tuning Pack including SPA, SQL Access and Tuning Advisors, SPM, SQL Plan, Real TimeSQL Monitoring etc.,
• Hands on experience on 11G Diagnostic Pack including AWR, ASH, ADDM, Trace, tkprof etc.,
• Very good experience as Oracle DBA in production, development and test environments
• Experience in Migration Projects. Hands on experience in - migrating from Oracle 9i to 10g/ 11g.
• Successfully implemented Physical Standby Database using Oracle DATAGUARD feature for High availability and DR configuration.
• Administration and support of Oracle databases together on separate servers using Grid Control. Installed and configured agents on all remote databases.
• Experience in designing and implementing backup and recovery strategy for disaster management using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
• Experience in ASM, and performance tuning in SQL tuning, AWR and flashback
• Having experience with Oracle 11g new features like AMM, database replay.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
• Expert in Administering 7X24 OLTP, Data Warehouse, OLAP, and Hot Standby (Data Guard) databases. Ability to analyze, plan and execute to perfection.
• Have knowledge on UNIX administration on OS installations, Installing 3rd party software.

TECHNICAL SKILLS

RDBMS: Oracle 9 to 11G

Database Technologies: ASMM, AMM, Data Guard, RAC, ASM, SCAN, Flashback Database, RMAN

DB Admin Tools: Exp/Imp, Expdp/Impdp, DBCA, DBCU, OEM Grid Control, ToadSQL Loader, LOG Minor etc.DB Tuning Tools SPA, SQL Access and Tuning Advisors, SPM, SQL Plan, Real TimeSQL Monitoring etc.DB Diagnostic Tools AWR, ASH, ADDM, Trace, tkprof etc.Operating System Linux, Solaris, Windows

Source Control: VSS and Clear Case

Schedulers: Crontab, Control M and Autosys

Ticketing Tools: Remedy, Clear Quest, HP Open view and Jill

PROFESSIONAL EXPERIENCE

Confidential, FL

Senior database Support Specialist

Responsibilities:

• Working on 24x7 database production operations which includes oracle High-Available technologies like RAC, Data guard, Flashback database etc.,
• The environment demands various techniques for data transfer methods like expdp/impdp, RMAN restores, Cloning etc.,.
• Troubleshooting RAC, Active Data guard, Flashback DB like Node eviction, lag on archive log apply and flash recovery full etc.,
• Support RMAN backups, troubleshooting and improve strategies.
• Support downstream data availability, reporting systems and ETL job support.
• Configured lower (non production) environment databases to support UAT operations.
• Performing routine database health checks of space utilization, instance availability, alert logs, memory utilization and ASM management etc.,
• Creating service accounts, roles, synonyms & and Materialized views to build database environments for project demands.
• Distributed data support using various database techniques like dB link, materialized views and streams etc.,
• Performance Review using AWR, ASH and SQL Monitoring etc.,

Confidential, VA

Sr. database administrator

Responsibilities:

• Collaborative efforts with Architects and modelers to provide optimized database solutions
• Data storage and partitioning strategies for OLTP and Warehouse systems
• OLTP system data replication and purges and archive methods using oracle streams
• Schema objects physical layouts and storage options
• Database and SQL Optimization support throughout the database Lifecycle
• Monitor Production databases for resource intensive database tasks
• Partner with Operational DBA group for troubleshooting performance issues and High Availability methodologies
• Benchmark the usage of database features and tools
• Knowledge sharing on database optimization methodologies and techniques

Confidential, NC

Sr. DBA

Responsibilities:

• Senior Engineer for performance related issues during the phase of 11g upgrade and support operations.
• Detailed DB change reviews with designers and developers for quarterly application releases.
• Explored and used the new Oracle Database 11gfeatures, SQL Plan Management, Adaptive Cursor Sharing, SQL Profile, Invisible Index, Extended Statistics etc., to successfully optimize the SQL queries.
• Resolving OLTP and DW Performance issues proactively and reactive basis when needed.
• Leading tasks and Providing Senior Level Support for Oracle databases for all the environments under the standards of enterprise controls.
• OLTP and DW Database Capacity Planning, Logical object management and Schema support.
• Shell scripting and automate tasks where ever possible.
• Tightly integrated Production system has upgraded to 11G which included standby, BCV and media servers.

Confidential, FL

Oracle Database support engineer

Responsibilities:

• Implemented and handling more than 10 cluster setups.
• Installed and configured 2 node Oracle Real Application Clusters (RAC) on IBM AIX
• Migrated 10g non-cluster databases into 11g cluster databases and configured streams at table level and schema level.
• Supported more than 90 production/dev/test servers of 10g & 11g managing databases.
• Configured RMAN backups for production servers.
• Supported ONCALL on rotation basis and managed the issues within the SLA for the production calls.
• Applied PSU patches on 10/11g Grid and RDMS homes.
• Adding and deleting nodes in existing RAC Environment.
• Data Guard/standby database configuration and maintenance for production databases.
• Refreshing Test/Dev databases with production backups.
• Daily database health checkups and preparing daily DB health reports.
• Creating service requests with oracle support for bugs and errors.
• Generating AWR reports and analysing the load profile & wait events of the database.
• Establish and maintain data replication as required for each application.
• Creating service accounts, roles, synonyms & and Materialized views in production & test databases.
• Worked with System Administrators, storage and application teams while server maintenance activities.
• Establish, maintain, and monitor database security, roles, user-role assignments, and individual logins per company security policies and procedures.
• Monitor database performance and space utilization - investigate and resolve reported issues.