PROFESSIONAL SUMMARY:

• Over Eight years of experience as an   Oracle   Database Administrator having hands on experience in database administration, installation, configuration, upgrades, performance tuning, backup and recovery, space management, database security and Migration to SQL Server 2008 Setup, Configuration, Security, replication.
• Significant experience working with teams responsible for   Oracle   Database Administration (DBA) in large enterprise environments and Golden gate.
• Consistently performed core day to day   Oracle   DBA   tasks, troubleshooting, initial load and data migration with Golden gate.
• Significant experience design, implementation, maintenance on   Oracle  12c, 11g RAC under Linux environment. 
• Significant experience leading teams responsible for   Oracle   database production support, applications, data modeling and PL/SQL Developers. 
• Adept in Database Administration activities such as patch installs, cloning, backup and recovery of mission critical databases, performance tuning, script development (UNIX shell scripting).
• Demonstrated strong partnership with other Service Delivery teams in the successful execution of standard processes (incident management, problem management, release management, change management, etc.) 
• Experience includes leading globally distributed teams to manage multiple concurrent product releases, while effectively resolving conflicting priorities. 
• Significant hands - on experience with   oracle   installations and version upgrades,    Experienced in using 11g features Data pump; Flash-Back Recovery, AWR, ASM, ADDM, Grid monitoring, and Recycle Bin. 
• Delivering   Oracle   Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 11gOEM Grid Monitoring. 
• Experience in   Oracle  12c, 10g/11g RAC,   Oracle   ASM,   Oracle   Data Guard, and   Oracle   RMAN. 
• Optimal configuration of SGA and PGA. 
• Expertise in monitoring, performance tuning and troubleshooting. 
• Expertise in Security administration, roles, profiles.
• Experience in PL/SQL, stored procedures, triggers and database/Objects statistics using DBMS UTILITY, DBMS STATS packages and ANALYZE command. 
• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). 
• Checking for Alert log file for errors and monitoring the Hit ratios. 
• Management of schemas, objects, tables & indexes partitioning. 

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Oracle DBA & SQL Server

Responsibilities:

• Performed database and system administration for a corporate network supporting over 250+ employees. Managed servers in an active directory environment, ensuring that each server has 100% uptime. Provide troubleshooting assistance with networks and web services. 
• Installed, configured Oracle 12c, 11g ASM, RAC instances, Data Guard and Stand-alone instance
• Migrating and upgrading the databases to higher versions SQL Server 2008 Setup, Configuration, Security, replication and performance and tuning.
• Enhanced Oracle RMAN scripts for nightly backup.
• Setup the materialize views for replication. 
• Provided assistance to Customers In Solving ORA- errors. 
• Provided assistance to Memory Corruption and Dictionary Corruption Errors. 
• Provided consultative services to implement the Memory configuration for Database Instance and ASM instances.   
• Working on Business continuance and high availability and Data Integration with Golden gate.
• Automated SQL Jobs for nightly backup and reporting 
• Created database procedures, scripted, database alerts and monitored scripts. 
• Managed multiples database environments from Oracle 10g - SQL Server 2008R2 -SQL 2012.
• Installed and configured SQL Server cluster within VMware environment and Oracle Golden Gate.
• Working with PL/SQL Team and Involved in all phases of database development, from assessment to QA/QC and support 
• Installed, configured Oracle12c, ASM, RAC instances, Data Guard and Stand-alone instance. 
• Installed, configured and upgraded Oracle, SQL Server software, etc. and related products 
• Developed documentation and maintaining dba procedures 
• Supported Land Mark users within Oracle Database environment 
• Working with system administrator to monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck.
• Handled database server tuning, capacity planning, physical database design and implementation of database Security 
• Installed and configured ESRI SDE for Petrel, Openwork's and OFM 
• Developed automated process of loading Daily Production Report within OFM 
• Successfully migrated Landmark databases environment to RAC One Cluster 
• Designed, Implemented and document DR Solutions 
• Successfully configured, implemented databases within VMware environment.

Environments: Sun Solaris 9.0, Linux 5.0, Windows 2003, Dataguard, ASM, Oracle 10g, 11g, 12c, SQL*Plus, PL/SQL, Grid Control, TOAD, SQL server 2000, 2005, 2008, 2012

Confidential, San Ramon, CA

Oracle DBA

Responsibilities:

• Installed, configured Oracle 12c, 11g, ASM, RAC instances, Data Guard and Stand-alone instance.
• Experience Migrating and upgrading the databases to higher versions.
• Enhanced Oracle RMAN scripts for nightly backup.
• Setup the materialize views for replication. 
• Provided assistance to Customers In Solving ORA- errors 
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size. 
• Installed Oracle Client s/w on Client machines.
• Installing and configuring several Oracle 10g, 11g databases on Linux and Unix platforms.
• Experience in providing technical expertise to design efficient and cost effective solutions for Oracle database systems.
• Experience in SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database performance on daily basis.
• Experienced in Data blocks, Tablespace, segments, partitioning of data and extent.
• Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters
• Expertise in Capacity planning, sizing and designing of databases for both ASM and Non ASM file systems.
• Setup backup and recovery procedures using RMAN. 
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical). 
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc. 
• Providing production support 24/7 for Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Experience in PL/SQL, stored procedures triggers and Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size. 

Environments:   Oracle Solaris 11,10, Oracle Linux, Windows 2003, SOA,SQL, PL/SQL, Oracle 10g and 11g, TOAD 9.5, Oracle Enterprise Manager 11G.

Confidential, Pittsburg, PA

Oracle Database Administrator

Industry/Domain: Banking/ Financial

Responsibilities:

• Part of the migrating team responsible for up gradation from Oracle 9i to Oracle 10g. 
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Installed, configured Oracle ASM, RAC instances, Data Guard and Stand-alone instance
• Migrating and upgrading the databases to higher versions.
• Worked on Opatch and Oracle upgrades.
• Responsible for installing, upgrading and configuring the Oracle server. 
• Worked in release management involving database components.
• Oracle security and familiar with database vault. 
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size. 
• Automation of job scheduling by crontab. 
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage. 
• Setup backup and recovery procedures using RMAN. 
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical). 
• Created and managed database objects such as tables, indexes, partition tables and views. 
• Expert in PL/SQL and upgrade & configuration of MS SQL Server and databases in clustered and non-clustered environments. 
• Installed Service Packs in SQL in standalone and clustered environment. 
• Established and maintained disaster recovery, backups, restore, attach, and detach migrations across SQL servers.

Environments: Sun Solaris 9.0, Linux 5.0, Windows 2003, Dataguard, ASM, Oracle SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008

Confidential, New York, NY

Oracle & SQL Server DBA

Responsibilities: 

• Installed Oracle 11gR2 RAC with 2 Nodes on (RHEL- 5.0,64-bit Processor) with New SAN Storage 
• Performed Migration of the databases from file system to Automatic Storage Management (ASM) for managing huge data in SAN. 
• Experience ensuring the high availability, Performance and integrity of databases. 
• Configured physical Standby databases with Dataguard and managed Dataguard using data guard broker (DGMGRL). 
• Installed Oracle 10G and 11G, Grid control Agents on Linux, Sun Solaris and Windows servers. 
• Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like TOAD, Erwin, Visio and KeepTool. 
• Responsible for Data Modeling and converting Domain model to Data model- logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams, failover and Disaster Recovery. 
• Setup backup and recovery procedures using RMAN. 
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical). 
• Created and managed database objects such as tables, indexes, partition tables and views. 
• Created and managed users, roles, privileges, profiles, schemas using OEM. 
• Manage data architects, data administrators and client enhancement requests. 
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running. 
• Creating and rebuilding indexes and optimizing the code to improve the performance. 
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters. 
• Strong ability with UNIX shell scripting to automate tasks and also in Crontab and dbms scheduler for scheduling jobs. 
• Extensively worked on Database administration activities like Installation, Configuration, Backup & Recovery and Database Security. 
• Expert in upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments. 
• Installed Service Packs in SQL in standalone and clustered environment. 
• Experience working with Windows 2003 Server - Administration and Installation. 
• Monitoring alerts through SCOM and MOM. 
• Good in Implementing SQL Server change control process. 
• Established and maintained disaster recovery, backups, restore, attach, and detach migrations across SQL servers.
• Database and log backups & restoration, backup strategies, scheduling backups. 
• Created Database Security by giving proper permissions to users and Admins. 

Environments: Sun Solaris 9.0, Linux 5.0, Windows 2003, Dataguard, ASM, Oracle SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008

Confidential, Chicago, IL

Oracle and SQL DBA

Responsibilities: 

• Supporting Oracle Customers running various versions of Oracle database (9i, 10g)
• Worked on various performances related issues. 
• Worked with Storage team for ASM and other file system needs. 
• Set up unidirectional Golden Gate for replication. 
• Setup the materialize views for replication. 
• Provided assistance to Customers In Solving ORA- errors 
• Provided assistance to Memory Corruption and Dictionary Corruption Errors 
• Provided consultative services to implement the Memory configuration for Database Instance.
• Provided assistance to Implement Huge pages /Large Pages in Unix platforms 
• Assistance to High memory utilization issues in Unix and Windows Platforms 
• Worked on many data refreshing tickets using Data Pump and RMAN Duplicated database. 
• Worked with Oracle Development and Oracle Bug Diagnostics Escalation Team for solving the bugs hit by the customer 
• Provided assistance to numerous customers in production Database Hung and non-responsive issues 
• Has good understanding of analyzing the hang analyze and system state dumps 
• Supported application and professional services to manage their data ranging from GB to TB in oracle database, solving of space problem, data loading problem. 
• Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across the Globe. 
• Involved in resolving issues after Installations, Upgrades, Cloning, patching (both DB and Applications), CPU patches, and one off patches. 
• Setup the RMAN Backups for all the Production databases satisfying RTO and RPO. Leading in performing periodic DR Drill and testing RMAN backups with various scenarios.. 
• Evaluated Oracle Database Monitoring and PL/SQL tools. 
• Helped on Demand engineers in the dry run for disaster recovery test for On Demand Customer instances. 
• Investigate, diagnose, and quickly resolve issues in production and testing environments. Work closely with the customers to quickly resolve production problems. 
• Monitored data files, logical data storage and data growth activities 
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc. 
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN. 
• Perform capacity planning required to create and maintain database environments. 

Environments: Linux 5.0, Windows 2005, Oracle 9i, 10g, SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008, TOAD 9.5, Oracle Enterprise Manager, SQL server 2000, 2005, 2008

Confidential, Bedford, MA

Oracle DBA

Responsibilities: 

• Installed and configured oracle 9i / 10g databases.
• Created database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.
• Designed and implemented backup and recovery strategies.
• Tuned application SQL using STATSPACK, SQL Trace and TKPROF.
• Optimized and fine-tuned the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
• Created users and assigned roles and profiles to users.
• Maintained data integrity, profiles, resources and password security.
• Used direct path loading vi SQL Loader/ SQL INSERT statement, CREATE TABLE AS SELECT statements, specifying NOLOGGING on staging table, table spaces, parallelized SQL statement execution where appropriate tables.
• Developed PL\SQL code such as procedure, function, package or triggers as well as working with pre-defined oracle package to administrate database.
• Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines.
• Designing and creating schema objects like Database tables, Indexes, Views, Synonyms and all schema objects in Oracle.
• Implemented the specific functionality by developing complex PL/SQL code like functions, procedures and packages.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Creation of users and Granting them privileges and roles.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory and operating system.
• Writing Shell scripts to automate the data loading processes using Cron jobs and PL/SQL procedures are scheduled using oracle job scheduler.

Environments: Oracle 9i,10g SQL Server 7.0, PL/SQL, SQL Loader, RMAN, Oracle Parallel Server, Import, Export, Oracle Enterprise Manager (OEM), TOAD, Oracle warehouse Builder, SQL Navigator, HTML, JDBC, RedHat Linux