SUMMARY:

• Twelve years of experience in handling Oracle Databases on various platforms like UNIX (HP, AIX, and SOLARIS) and Windows.
• Certified in Oracle 9i, 10g and 11g (DBA track).
• Hands on experience with Grid Infrastructure, Oracle Enterprise Manager, Business Intelligence, VMWare, Weblogic Server, Oracle Database Server, Golden Gate.
• Strong UNIX Shell scripting/programming experience. Used shell scripts/programs to cleanup log files, reporting purposes, automating adding parameters to jil entries.
• Implemented Disaster Recovery solutions using data guard in Oracle 11g.
• Strong SQL, ETL, PL/SQL development experience. Written procedures, packages and triggers for database maintenance.
• Strong production Support experience doing hot and cold backups using RMAN as well as manually. I have been a production support DBA for most of the contracts in US. Maintained a replication environment for more than 4 years at different places.

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle 11g, 10g and 9i Database Installation, Configuration, Performance Monitoring, Upgrade, Tuning, Backup and Recovery, Schema Manager, Storage Manager, Net8 Configuration Assistance, Database configuration assistant (DBCA), Oracle Enterprise Manager (OEM), Database modeling and designing through entity relationship diagrams and flowcharts, SQL, PL/SQL, SQL Plus, Real Application Clusters, SQL, Tomcat server, Mongodb, RDS.

Oracle Utilities: SQL Loader, Toad

Mongodb Utilities: Compass, Atlas

O/S: Solaris, HP UX, AIX, Windows 2000 Advanced, Server, Windows 2005

Datawarehouse: Informatica 6.0, Informatica 5.1, Erwin, Business Objects, Ab Initio, OBIEE 11g.

Languages: Java, VB, C, C++, HTML, XML, SQL - PL/SQL, VBScript, JavaScript, CGI

PROFESSIONAL EXPERIENCE:

Confidential, FAIRFAX

Senior Oracle DBA

Responsibilities:-

• Installed and patched 12c pluggable database servers. Cloned pluggable databases across servers for supporting development and testing environment. Troubleshooted issues for team.
• Upgraded 11g databases to Oracle 12c.
• Recommended and Implemented process to convert non-partitioned table to Partitioned table using Partition Exchange method. Tested and implemented solution. Documented table partitioning on Oracle database tables for software implementation.
• Configured Oracle Active Dataguard. Applied PSU to ADG configuration. Documented and tested Active dataguard implementation for replication of database.
• Migrated SQL Server Code to Oracle PL/SQL code.
• Scheduled backup and recovery scenarios.
• Did database migrations using expdp, impdp, transferring database files etc.
• Installed and maintained the Oracle Grid Infrastructure. Startup/Shutdown of Oracle Management Server. Securing Management agents.
• Provided diagnosis for performance issues. Used various diagnostic tools like AUTOTRACE, SQL TRACE, OEM Monitor, SQL Tuning Advisor, AWR, ADDM, Health monitor, Data dictionary views etc.
• Opened service requests with Oracle for database issues.
• Installed and Configured RAC using Cluster Ready Services software. Familiar with RAC background processes like ocssd, crsd and evmd after the install. Configured /etc/hosts file with public, private and virtual IP Addresses for node configuration.
• Managed ASM and non-ASM database instances. Created normal and high redundancy ASM disk groups.
• Installed and Supported Golden gate environment. Setup replication using Golden gate.
• Supported RAC database requests. Assisted in setting up virtual IP addresses for the cluster.
• Created PL/SQL scripts to monitor sqls running on system.
• Worked on veritas cluster database.
• Supported High Availability environment with a RAC configuration.

Confidential, Reston.

Senior Oracle DBA.

Responsibilities:-

• Resolved performance issues caused due to high IO. Worked on level 1 Oracle Service Request to find root cause analysis of outages and get a diagnosis for performance problem. Problem was resolved by creating and caching indexes and adding memory and also changing the way the statistics were collected.
• Worked to support multiple databases for Business Process Management (BPM) application team to monitor and diagnose solutions for long running queries. Used OEM12c monitoring, AWR and ADDM reports to diagnose cause of time consuming queries. Wrote SQL queries to monitor the database to report queries running more than 15 seconds. Supported highly sensitive environment. Tuned queries taking 17 minutes to 1 minute. Troubleshooted environment with very high number of active sessions and large number of long running queries.
• Created tables, views, stored procedures, sql scripts. Maintained users, roles and privileges for database objects.
• Identified missing normal and function based indexes by analyzing top resource consuming queries. Created those indexes to get the queries to run faster. Increased memory and cached tables in memory.
• Performed multiple data migrations/refreshes using expdp and impdp. Created parameter files for migrations. Checked space in schema tablespace and temporary tablespace before migrations and resized datafiles as needed. Remapped users as needed.
• Worked with Autosys job Scheduler to create and migrate jobs from release 4.5 to Release 11.6. Scheduled oracle backup and monitoring jobs using autosys.
• Wrote shell scripts/programs using AWK, Sed, Grep and other utilities to filter out box and command jobs and create jil files for migration. Put logic in scripts to list jobs for deletion based on their existence in other environments.

Confidential

Senior Oracle DBA.

Responsibilities:

• Installed Oracle Enterprise Manager server 11g along with Oracle Weblogic Application Server.
• Installed and Cloned Oracle 10g and 11g Grid Agents on Sun Solaris platforms.
• Installed and Upgraded Oracle Business Intelligence Server and Performed upgrades.
• Hands on experience with 11g new features like Real Application Testing (RAT), SQL Performance Analyzer, setting AWR baselines, SQL Profiling using SQL Repair Advisor, using Automatic Diagnostic Repository, using support workbench, Oracle Secure Files etc.
• Performed database upgrades to 11.2.0.3 from 11.2.0.2.
• Created and upgraded Oracle Databases using DBCA (Database configuration Assistance) in UNIX environment.
• Applied scheduled CPU patches every quarter on production, QA and development.
• Schedule and Monitor RMAN incremental/daily and full/weekly hot backups for the databases through grid and manually. Maintained and monitored the jobs on a daily bases.
• Responsible for supporting Oracle 10g databases for multiple applications. This involved maintaining various schemas/users along with their roles, profiles, privileges and objects. Made sure users are given access through synonyms.
• Perform recoveries for databases if needed. Performed a point in time recovery.
• Migrated data using expdp and impdp across databases using the TRANSPORATABLE TABLESPACE parameter. Documented procedures for the same.
• Configured memory for automatic tuning by setting the MEMORY TARGET parameter. Suggested DB architecture and created the databases in accordance to the requirements.
• Supporting an Oracle Internet Directory environment.
• Used data stage to migrate data from sql server to oracle database. Migrated from object oriented environment to relational environment.
• Created and maintained database objects like Tables, Indexes and Partitions. Used AUTOTRACE to look at query statistics. Also used SQL TRACE to see runtime execution plans.

Confidential, ARLINGTON

Senior Oracle DBA

Responsibilities:

• Installed Oracle 10g and 11g Grid Agents on Sun Solaris platforms.
• Installed Oracle database 10g and 11g Servers on Sun Solaris platforms.
• Maintaining the Oracle Grid Infrastructure. Startup/Shutdown of Oracle Management Server. Securing Management agents.
• Created and upgraded Oracle Databases using DBCA (Database configuration Assistance) in UNIX environment.
• Used Erwin to create and model data for an in house project.
• Applied scheduled CPU patches every quarter on production, QA and development.
• Schedule and Monitor RMAN incremental/daily and full/weekly hot backups for the databases through grid and manually. Maintained and monitored the jobs on a daily bases.
• Performed Oracle Grid and Oracle Agent Installations.
• Responsible for supporting Oracle 10g databases for multiple applications. This involved maintaining various schemas/users along with their roles, profiles, privileges and objects. Made sure users are given access through synonyms.
• Perform recoveries for databases if needed. Performed a point in time recovery.
• Migrated data using expdp and impdp across databases using the TRANSPORATABLE TABLESPACE parameter. Documented procedures for the same.
• Scheduled jobs in UNIX via crontab.
• Customized Oracle Startup and Shutdown shell scripts to start and shut the database, listeners and agents in a consolidated manner. Deployed them on 30 database servers.
• Wrote shell scripts to mail any log files that are more that 100mb in Oracle Home.
• Supported developers for troubleshooting various needs.
• Configured memory for automatic tuning by setting the SGA TARGET parameter. Suggested DB architecture and created the databases in accordance to the requirements.
• Supporting an Oracle Internet Directory environment.
• Used data stage to migrate data from sql server to oracle database. Migrated from object oriented environment to relational environment.
• Installed, maintained and supported APEX database.
• Wrote scripts to identify segments that are being used in queries but are not giving good performance. Example Full table scans should be avoided on large tables. Indexes and hints can help improve performance.
• Trouble shouted performance using grid AWR reports.
• Customized the dbstart and dbshut shell scripts to start the listener and agents along with the database.
• Wrote shell script to perform RMAN reporting on the database backups and perform cleanups.
• Configured ETL in datastage as part of requirements.
• Cloned Management agents using command line for Oracle Grid Architecture.
• Configured RAC databases. Converted Non RAC databases to RAC databases.
• Implemented scripts to partition tables and indexes.

Confidential, DC

Program Analyst / Oracle DBA

Responsibilities:

• Responsible for supporting Oracle databases for SAS Application team and Team Approach (Application) team. This involved supporting a replication environment (materialized views) and a normal database environment.
• Troubleshooted rollback segment issues for the team. They were getting a lot of 'ora-1555 snapshot too old' errors. Created new rollback segments with bigger size to dedicate to very large transactions. Added more files to the undo tablespaces in some cases.
• Optimized the databases in regards to materialized views by changing the size of the redo logs. Replication that was taking a whole day to finish now finishes in an hour.
• Maintained a replicated database environment. We were maintaining a copy of the production database by copying the database files and recreating the control files and finally renaming the database.
• Created shell scripts for various purposes like doing FTP, backup, cleaning up, reporting etc.
• Wrote multiple stored procedures in Oracle to do various clean up activities like finding duplicated records and merging them into one. Edited existing procedures to sync databases in accordance to requirements.
• Wrote Oracle procedure to find out candidate indexes that need to be rebuilt.
• Conducted performance tuning using various tools like TKPROF, EXPLAIN PLAN, STATSPACK, data dictionary and dynamic performance views. Created scripts and scheduled them as jobs to keep the statistics updated.
• Created scripts to identify the progress of queries. Able to see exactly how many records have been entered during a transaction.
• Helped developers to troubleshoot slow performance. Reasons could be insufficient sort space or insufficient memory or tablespace.
• Monitored processes for developers to identify the bottleneck in the system.
• Used Job scheduler and resource manager to schedule jobs and setting priorities to jobs.
• Created documentation on the Disaster Recovery and Database upgrades implemented by me.
• Supported SAS team for any issues with the SAS application. Contacted SAS support for troubleshooting.
• Supported the Tomcat web server for any issues.
• Configured and converted single instance databases to RAC.

Confidential, Chantilly, VA

Oracle DBA

Responsibilities:

• Responsible for upgrading Oracle 8i and 9i databases belonging to different versions to Oracle 10gR2. Conducted upgrades manually and through DBUA.
• Implemented dataguard on Oracle 9i and 10g to implement a disaster recovery plan.
• Conducted replication of tables from databases outside the network using materialized views/snapshots. Created scripts to create the snapshot logs for the databases outside the network.
• Configured Oracle 10g to gather statistics automatically by setting the STATISTICS LEVEL parameter to typical.
• Supported Production databases and took care of any memory issues. Configured memory for automatic tuning by setting the SGA TARGET parameter.
• Suggested DB architecture and created the databases in accordance to the requirements.
• Suggested backup and recovery plan. Cold backups were scheduled for every week.
• Created shell scripts for various purposes.
• Created packages for various database requirements.
• Conducted performance tuning using various tools like TKPROF, EXPLAIN PLAN, STATSPACK, data dictionary and dynamic performance views. Created scripts and scheduled them as jobs to keep the statistics updated.
• Wrote scripts to identify segments that are being used in queries but are not giving good performance. Example Full table scans should be avoided on large tables. Indexes and hints can help improve performance.
• Created scripts to identify the progress of queries. Able to see exactly how many records have been entered during a transaction.
• Used new EXPDP and IMPDP utilities to conduct export and import. This is a lot faster than the conventional export and imports.
• Helped developers to troubleshoot slow performance. Reasons could be insufficient sort space or insufficient memory or tablespace.
• Monitored processes for developers to identify the bottleneck in the system.
• Used the 10g new features like segment advisor, SQL access advisor, SQL tuning advisor, Automatic database diagnostic manager and undo segment advisor.
• Used Job scheduler and resource manager to schedule jobs and setting priorities to jobs.
• Created full fledged documentation on the Disaster Recovery and Database upgrades implemented by me.
• Created shell scripts for daily maintenance activities.
• Configured RAC databases. Converted Non RAC databases to RAC databases.

Confidential, Reston, VA

Oracle DBA

Responsibilities:

• Involved in supporting an environment having more than 60 database instances of around 60-70G each, involving the Data warehouse and the OLTP databases.
• Installed, Created and Maintained Oracle 8i, 9i and 10g instances and Databases in Solaris Environment.
• Extensive Performance Tuning at all levels (Database, Segment, Extents and Block level). Installed and used Stats pack reports.
• Created users and performed replication as and when desired.
• Created sequences, synonyms, database links based on developer requests.
• Maintained Database security according to requirements. (Granted roles and privileges.)
• Deployed and configured environment for Dataguard.
• Instantiated standby database in dataguard environment. Tested various scenarios like Failover, Switchover, and Activation etc.
• Enhanced performance of database objects by removing performance bottlenecks like removing chained rows in the table, and configuring various storage parameters like PCTFREE, PCTUSED,INITIAL EXTENTS, MAX EXTENTS etc
• Scheduled jobs to run in Oracle Enterprise manager and Cron utility and also DBMS JOB package.
• Scheduled statistics for updating using various Analyze commands.
• Query optimization (Use of EXPLAIN PLAN and TKPROF).
• Monitored and tuned the performance and space requirements of Oracle databases on live and development servers.
• RMAN and User managed Backup and recovery.
• Involved in Change Control using Mearant Version Manager.
• Refreshed database from the Production to create a fresh copy of production database on daily basis for testing.
• Thorough with Real Application Clusters Architecture and Environment.
• Performed migration from oracle 9i to 10g.
• Performed database migration between servers.
• Configured Application and Web Servers for redirecting data to the databases.

Confidential, Herndon, VA

Oracle DBA

Responsibilities:

• Involved in supporting an environment having more than 60 database instances of around 60-70G each, involving the Data warehouse and the OLTP databases.
• Installed, Created and Maintained Oracle 8i, 9i and 10g instances and Databases in Solaris Environments.
• Extensive Performance Tuning at all levels (Database, Segment, Extents and Block level). Installed and used Stats pack reports.
• Created users and performed replication as and when desired.
• Created sequences, synonyms, database links based on developer requests.
• Maintained Database security according to requirements. (Granted roles and privileges.)
• Deployed and configured environment for Dataguard.
• Instantiated standby database in dataguard environment. Tested various scenarios like Failover, Switchover, and Activation etc.
• Enhanced performance of database objects by removing performance bottlenecks like removing chained rows in the table, and configuring various storage parameters like PCTFREE, PCTUSED,INITIAL EXTENTS, MAX EXTENTS etc
• Scheduled jobs to run in Oracle Enterprise manager and Cron utility and also DBMS JOB package.
• Scheduled statistics for updating using various Analyze commands.
• Query optimization (Use of EXPLAIN PLAN and TKPROF).
• Monitored and tuned the performance and space requirements of Oracle databases on live and development servers.
• RMAN and User managed Backup and recovery.
• Involved in Change Control using Mearant Version Manager.
• Refreshed database from the Production to create a fresh copy of production database on daily basis for testing.
• Thorough with Real Application Clusters Architecture and Environment.
• Performed migration from oracle 9i to 10g.
• Performed database migration between servers.
• Configured Application and Web Servers for redirecting data to the databases.
• Created partitioning table scripts.

Environment: Oracle 9.2.0, Oracle 10.1g, HP-UNIX, Oracle Enterprise Manager (OEM), Database Configuration Assistant (DBCA), Oracle Management Server, Net Configuration Assistant, Oracle Net Manager, Database Migration Assistant, SQL * Loader, Toad, Visual Source Safe, Telnet, FTP

Confidential, VA

Oracle DBA

Responsibilities:

• Involved in supporting an environment having more than 60 database instances of around 60-70G each, involving the Data warehouse and the OLTP databases.
• Installed, Created and Maintained Oracle 8i, 9i and 10g instances and Databases in Solaris Enviroment.
• Extensive Performance Tuning at all levels (Database, Segment, Extents and Block level). Installed and used Statspack reports.
• Created users and performed replication as and when desired.
• Created sequences, synonyms, database links based on developer requests.
• Maintained Database security according to requirements. (Granted roles and privileges.)
• Deployed and configured environment for Dataguard.
• Instantiated standby database in dataguard environment. Tested various scenarios like Failover, Switchover, Activation etc.
• Enhanced performance of database objects by removing performance bottlenecks like removing chained rows in the table, and configuring various storage parameters like PCTFREE, PCTUSED,INITIAL EXTENTS, MAX EXTENTS etc
• Scheduled jobs to run in Oracle Enterprise manager and Cron utility and also DBMS JOB package.
• Scheduled statistics for updation using various Analyze commands.
• Query optimization (Use of EXPLAIN PLAN and TKPROF).
• Monitored and tuned the performance and space requirements of Oracle databases on live and development servers.
• RMAN and User managed Backup and recovery.
• Involved in Change Control using Mearant Version Manager.
• Refreshed database from the Production to create a fresh copy of production database on daily basis for testing.
• Thorough with Real Application Clusters Architecture and Environment.
• Performed migration from oracle 9i to 10g.
• Performed database migration between servers.
• Configured Application and Web Servers for redirecting data to the databases.

Confidential, MD

Oracle DBA

Responsibilities:

• Thorough with Oracle server architecture and design. (SGA+PGA+BGProcesses+Database).
• Created scripts to replicate the schemas from one server to another. (Export and Import utilities were used).
• Created scripts to rebuild all indexes in the database/schema.
• Developed PL/SQL packages involving creating cursors, procedures and functions.
• Requirement Study, Analysis and Design.
• Creation and maintenance of tablespaces (LOCALLY and DICTIONARY managed).
• Creation and maintenance of tables, indexes, users and other schema objects.
• Partitioning tables for enhancing performance.
• Application tuning by optimizing SQL statements.
• Query optimization (using various hints and optimizer modes).
• Transport of various database objects like schemas, tablespaces and tables from one database to another.
• Wrote PL/SQLTriggers for validation of data.
• Communicated with the end users to get their feedback about the completed application.
• Installation and configuration of Oracle 9i Database Server and the oracle 9i developer suite.
• Tuned complex queries for performance using Explain Plan, SQL TRACE, and TIMED STATISTICS, HINTS like FTS, NO INDEX.
• Applied DCR’S and SCR’S on the developers’ request.
• Maintained source code changes through Visual Source Safe.

Environment: Oracle 9.2.0, Oracle 10.1g, HP-UNIX, Oracle Enterprise Manager (OEM), Database Configuration Assistant (DBCA), Oracle Management Server, Net Configuration Assistant, Oracle Net Manager, Database Migration Assistant, SQL * Loader, Toad, Visual Source Safe, Telnet, FTP

Confidential, MD

Oracle DBA

Responsibilities:

• Thorough with Oracle server architecture and design. (SGA+PGA+BGProcesses+Database).
• Created scripts to replicate the schemas from one server to another. (Export and Import utilities were used).
• Created scripts to rebuild all indexes in the database/schema.
• Developed PL/SQL packages involving creating cursors, procedures and functions.
• Creation and maintenance of tablespaces (LOCALLY and DICTIONARY managed).
• Creation and maintenance of tables, indexes, users and other schema objects.
• Partitioning tables for enhancing performance.
• Application tuning by optimizing SQL statements.
• Query optimization (using various hints and optimizer modes).
• Transport of various database objects like schemas, tablespaces and tables from one database to another.
• Wrote PL/SQL Triggers for validation of data.
• Communicated with the end users to get their feedback about the completed application.
• Installation and configuration of Oracle 9i Database Server and the oracle 9i developer suite.
• Tuned complex queries for performance using Explain Plan, SQL TRACE, and TIMED STATISTICS, HINTS like FTS, NO INDEX.
• Applied DCR’S and SCR’S on the developer’s request.
• Maintained source code changes through Visual Source Safe.
• Created ETL transformation routines in Informatica.