SUMMARY

• A versatile IT professional with 10 years of comprehensive experience as an Oracle Database Administrator and DBA Lead /Manager.
• Having hands on experience in Oracle Database Administration working both on Production and Development environments, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, and documentation in high - availability environments with Oracle 12C/11G/10G/9i/8i, RAC support and Amazon RDS Cloud environment .
• Worked on various environments involving several domains like Banking, Finance, Retail, Energy and Oil for major clients on all OS in mission critical OLTP (up to 30TB) and OLAP (up to 80TB) Environments.
• Excellent experience in Installation, administration and troubleshooting of Oracle 12c/11g/10g/9i and 8i for OLTP (multiple instances)/ OLAP environment on Very Large Databases.
• Managed Database team of 12 DBA’s including their appraisal process and mentored them for delivering successfully to large clients with very good coordination and 100 % success rate.
• Experience on Handling 50 + Production and 100 + Dev Databases.
• Leading Team in the critical situations as SME resolving all critical scenarios faced as part of support.
• Dealt and managed teams both at onsite and offshore in different levels of project.
• Handled planned/ Un-planned complex outages of production servers coordinating with other teams with quick restorations swiftly communicating with involved teams.
• Managed large sized projects as per the client business requirements.
• As a Lead, dealt many complex issues and fix them positively by evaluating the new areas to improve by suggesting the ways to adopt newer technologies whenever required.
• Achieved many client appreciations ranging from various clients VP to client CEO for best work delivered.
• Created many database policies as per the project requirements, proposing newer methodologies by proposing them in the change management meetings for effective delivery.
• Successfully implemented oracle 12C environment and plug-ins for different servers.
• Built and managed many large scale databases and was accountable for successful support of the databases built.
• Completed a highly reputable No-SQL database MONGO DB for DBA’s training from MONGO University.
• Created size based databases on RDS cloud as Small and XL databases, Involved in Installation, maintenance and tuning of RAC Applications.
• Created oracle databases and troubleshoot on AMAZON RDS cloud environment
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM).
• Expertise in Oracle 10g/9iData Guard and standby databases, Snapshot maintenance and creation
• Regular interaction with client and customer managers, development teams and system administrators in coordinating projects successfully.
• Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing databases.
• Experience in designing and configuring high-availability systems using DATAGUARD with physical standby.
• Performed key role in preparing external database Audits and fulfilling the gaps for POSITIVE Audit result in making databases ready, guiding both offshore and onsite teams.
• Guided team in all phases of the application life cycle from proof of concept and initial development through production implementation and operations.
• Excellent in leading, team managing, mentoring, and coaching team members.
• Oracle Problem analysis and resolution and active cloning of databases from one server to another server.
• Expertise at installing Oracle 10g features like ASM and Grid monitoring.
• Built separate servers for third party monitoring tools for Performance Analysis like Quest tools and maintained.
• Database refresh from production to QA, development and testing environments Backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Supported very large Data Warehouse databases, de-normalized schemas, and Performance related issues.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Experience in configuring and Installing/using various Quest Tools- Foglight, Performance Analysis.
• Attended Six Sigma training & worked for Six Sigma Project.

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Manager - Database Administration

Responsibilities:

• Design and Build both Production and development databases as per business requirements.
• Managing Database team of 12 DBA’s including their appraisal process and mentored them for onboarding and off boarding for large clients with very good coordination and 100 % success rate.
• Leading Team in the critical situations as SME resolving all critical scenarios faced as part of support.
• Implemented oracle 12C and troubleshoot the post upgrade issues coordinating with the related teams.
• Best DBA Award from the client working for ZERO DEFECT and 100% SLA’s.
• Active role in performing external database Audits and fulfilling the gaps for POSITIVE Audit in making database ready, guiding both offshore and onsite teams.
• Installed Oracle 10g and 11g RAC software with ASM & OCFS2 File systems.
• Managed large sized projects as per the client business requirements.
• Implemented very strict guidelines from Risk management team for successful audit of the databases making the DBA team on top in obtaining GOOD rating for external database audit.
• Handled planned/ Un-planned complex outages of production servers coordinating with other teams with quick restorations swiftly communicating with involved teams.
• Mentored a direct reporting team and indirect reporters including onsite and offshore locations.
• Test and Implement Applicable new feature during each upgrade.
• Monthly maintenance tasks performed on critical servers and applying required patches and database downtime work.
• Maintain strict documentation for all the work done, coordinate and manage the team to be in compliant with company procedures for anytime Audit review.
• Planned and maintained the database architecture in the current environment and suggested for changes.
• Involved in Installation, implementation and maintenance of relational databases, performance monitoring and tuning, capacity planning, problem analysis and correction,
• Maintain 24*7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times
• Manage High Availability Architecture with clustered environment on both PROD and DEV databases ranging from 1 TB to 80 TB which accounts around 46 databases on whole.
• Maintain daily health checks and send reports to concerned teams.
• Troubleshoot Database Performance issues using OEM, AWR, ASH, TKPROF 10046 traces etc.
• Guided all phases of the application life cycle from proof of concept and initial development through production implementation and operations.
• Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
• Monitor Production Databases using various third party tools like Quest Foglight.
• Database Capacity Management (Working with Storage teams for ASM Disks) using Automated scripts/processes and Reports.
• Database tables Design /Maintenance using ORACLE partition technologies coordinating with application developers.
• Dynamic Change management Environment - Critical production changes are planned and implemented on daily basis with thorough review process in place.
• Manage Database and Archive log backups using RMAN and External third party tools like Netapp backups.
• Closely working and coordinating with Developers and system administrators to regulate the database changes on the site

Environment: Oracle 12C/11g/10g/9i/8i, RHEL, Solaris, AIX and Windows 2003 server, OEM 12C, NetApp, TOAD, REMEDY, Fog Light, FTP professional, EMC Wizard, putty.

Confidential, Houston, TX

Senior Oracle DBA / Lead DBA

Responsibilities:

• Managed 4 onsite reportees and 6 offshore reportees as part of DBA support team.
• Created, maintained and administered databases on AMAZON RDS cloud.
• Created many database policies as per the project requirements, proposing newer methodologies by proposing them in the change management meetings for effective delivery.
• Analyzing and solving the performance problems arising out of critical applications on the invoicing days.
• As a Lead, dealt many complex issues and fix them positively by evaluating the new areas to improve by suggesting the ways to adopt newer technologies whenever required.
• As DBA Lead, Regularly been part of change management meetings for any changes to the databases and proposals.
• Built and managed many large scale databases and was accountable for successful support of the databases built.
• Providing production and development database support and maintaining them stable 24/7 support.
• Database copy downs whenever required for development teams.
• Application upgrades on the databases for various clients of fuel quest supporting off hours in making the application versions up to date coordinating with team and various other involved teams.
• Created size based databases on RDS cloud as Small and XL databases
• Cloning the databases when required for development and testing activities using EMC Wizard.
• Maintained 3 RAC databases and involved in migrating to cloud based databases from RAC cluster to NetApp VM ware.
• Imported and exported files, databases, schemas and tables using utilities when required.
• Implemented database security by database Auditing.
• Guided DBA team in setting up new servers from scratch to creating databases and using them dedicatedly for using Quest fog light and performance analysis of databases exclusively
• Performance tuning via AWR and Improved Performance of the database by troubleshooting whenever payroll run happens on the database for high performance output.
• Implemented Oracle Database 10g 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.
• Co-ordinate with system administrators for space managements on various servers.
• Resolved table space issues, disk space issues and problems like listener down, tnsnames errors etc. from the end user interaction.
• Responsible to ensure that the environments are stable and at acceptable performance.
• Developed Cron jobs to automate the backups, monitoring Alerts.
• Allocating system storage and planning future storage requirements for the new environment to be set up.
• Extended Work on planned weekend outages for critical projects and bug fixes based on the criticality.

Environment: Oracle 10g, and 11g, SQL, AMAZON RDS Cloud, RHEL, RAC, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, JIRA Tool, FTP professional, WINSCP, TOAD, Solaris and Linux, EMC wizard, Foglight.

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• Providing production and development database support and maintaining them stable.
• Installation of ORACLE 9i and 10g Database on different Environments
• Installation of OEM Grid Control and OEM Agents to Manage up to 100 Databases.
• Performing capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects
• Design ORACLE ASM Disk and Disk group layout in collaboration with system administrators and system architects
• Support of daily operations including job monitoring and troubleshooting of the 24x7 production
• Design, develop, and maintain back-up strategy using Centralized RMAN Shell Script and expdp/impdp
• Keeping the database up to date on patches and Supporting the roll-out of new versions
• Involved in Oracle database designing using ERWIN tool for development projects coordinating with development teams.
• Logging support cases as necessary and effectively working with Oracle to resolve issues
• Involve in all phases of software development lifecycle, including data analysis, business analysis, testing and documentation development
• Worked on the Service Now to handle user tickets, Incidents and Service requests.
• Presented and explain technical information of diverse type of audiences such as management, users, vendors and technical staff in a way that establishes rapport, persuades other and gains understanding.
• Adherence to policies, procedures and controls especially in regard to outage and change management, licensing, and information protection.
• Enable and Configure Database Auditing for Class 1 Production databases
• Managing offshore team and setting up 24X7 monitoring.

Environment: Oracle 9i, 10g, and 11g, SQL, NETApp, RAC, Linux, AIX, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, Service Now Tool, ERWIN, TOAD, Solaris and Linux, Exp 9i, 10g, Imp 9i, 10g and Tortoise SVN Tool.

Confidential, Atlanta, GA

Oracle DBA Team Lead

Responsibilities:

• Defect less monitoring of all the Production, development and Test databases.
• Responsible for around 60 Oracle databases on 11 servers.
• Maintained instances of around 750GB to 30 TB.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control.
• Actively involved in the team to migrate RAC databases to EXADATA systems to startup with quarter RACK.
• Major Aviation databases have been migrated to quarter RACK of EXADATA which was supported and maintained by the team worked.
• Troubleshooting on the databases on user issues on performance related issues.
• Involved in development and implementation of Data ware house and Data mart Design.
• Worked on performance issues related to RAC Cluster Interconnect performance.
• Administration of Oracle networking and Listener setup for oracle databases.
• Data Refresh from Production to Test and Development environments using clone refreshes and using Exp/Imp utilities..
• Daily Health Checkup of the databases.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus and TOAD.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Restored and Recovered database at the times of occurrence of critical failures using RMAN.
• Extensive used Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing
• Since most of the data pertains to the personal information of the customer, security is of the utmost importance, so naturally I was involved in designating the roles and privileges to the application developers.
• Taking Periodic Backup of the databases and the software using RMAN.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Extending support for Daily Data Loads so that the loads get completed within agreed SLA time.

Environment: Sun Solaris 9.0/10.0, Linux, AIX, Oracle 8i/9i/10g, RAC, Toad, SQL*Loader, HPSD, PL/SQL, OEM Grid, RMAN, Erwin 4.1.2,EXP/IMP tool.

Confidential, Stamford, CT

Oracle Database Administrator

Responsibilities:

• Prepared a reference document called Issue - Approach for all the issues faced during the tenure.
• Worked with Development team for performance issues.
• Developed Cron jobs to automate the backups, monitoring Alerts.
• Performance Tuning for hung sessions and long running quires in the database based on user requests.
• Extended Work on planned weekend outages for critical projects and bug fixes.
• Worked on the HPSD to handle tickets and Work Order requests.
• Volumetric estimations for creation of new table space for data marts.
• Planned and executed RMAN and cold backup strategies and recovered database.
• Handled planned/ Un-planned outages of production servers.
• Refreshing of production data to Dev/QA environments.
• Performing re-sizing of data files, managed table spaces and data files
• Created partitions & indexes for better performance.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN.
• Customization and development of Korn shell scripts.
• Troubleshoot application - related issues and supporting offshore team.
• Documenting all the issues and resolutions in a Fail N Fix document for the future reference of the same issue.
• Space Management/Monitoring - Temp TBSP, RBS, Data Space, Swap, archive file system. Data Loading using SQL Loader
• Logging tickets with GIS (Global Information Systems) in case of server/ hardware issues, restoration.

Environment: Oracle 8i, 9i, 10g, SQL, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, Cadre Tool, TOAD, Solaris, AIX, and Linux, Exp 9i, 10g, Imp 9i, 10g, Data pump 10g.

Confidential

Oracle Database Administrator

Responsibilities:

• Monitoring the Database and its Alert Log.
• Proactively Monitored the OS for Space Utilization and any performance issues.
• Assisted in software installation and development environment creation by creating databases and modifying scripts that access them.
• Prepared documentation on software and application installations for training purposes.
• Synonyms created and grants to specific users for accessing from other schemas.
• Indexes were implemented wherever they were needed to boost the performance of the quires and to reduce the Locking of the objects.
• The quires executed from the front end were regularly monitored to detect any illegal data manipulation and to detect queries that were blocking the system resources.
• Took the Hot Backup of Database.
• Backed the dump files & DB Backup Created Snapshots for Replication and automatically updating the jobs.
• Experienced with RMAN backups and Oracle exp/imp utilities and Hot/Cold backups
• Provided On-Call rotation support and 24x7 support for very large and critical databases based on the criticality and priority of the issue.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Updating the issues and dealt using tickets and took periodic backups as per user requirements and requests.

Environment: Oracle 8i, 9i, SQL, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, TOAD, Solaris, Linux and Windows.