Databases Administrator

SKILLS SUMMARY

12years of diverse engineering and development experience with concentration in RAC/ASM/Data Guard/ GRID and SQL. I have developed and displayed n-depth knowledge of Oracle 10g/11g R1/R2 RAC implementation and administration on RHEL Linux and UNIX Solaris. I possess a Result Driven, Team Oriented and proactive problem solving personality. Exceptional Soft Skills, Excellent Written and Verbal Communication Talent, Exceptional Multi Tasking Abilities and Reliability.

Networks: Windows NT O/S Windows NT/95/98/2000, MS-DOS, RHEL Linux, UNIX Solaris, Net App SAN,VCS, NetApp Snap Manager for Oracle, DataGuard, Enterprise Storage Networking Languages: SQL, Pl/SQL,HTML, ASP, VB

RDBMS/Storage: Sybase, MySQL, SQL Server,Oracle8i, Oracle9i, 10g,11g R1 and R2 ,Dataguard local standby and DR ,RAC, Data warehouse, Cognos, Datastage, Oracle Portal Infra and Mid-tier, Oracle Weblogic ,PeopleSoft Enterprise Portal, PeopleSoft EPM, PeopleSoft HCM 8.9-9.1, People tools 8.49 8.5, ASM,OCFS2,MS Access, SQL SERVER 2005 , Teradata ,Golden Gate.

GUI Tools: Oracle Reports, OEM, Crystal reports, SQL Navigator, TOAD, SQL, 10g,11g, Grid Control, 12C cloud control,

Project Experience

Confidential

Oracle DBA

• Provided Oracle/PeopleSoft database administration support in OLTP and DSS corporate environment.
• Created and Managed Data warehouse Cognos Databases DSS
• Applied patches and upgraded Release 11gR1 to 11gr2
• Built Development, UAT, QA, Performance and Production environment to support People soft application.
• Built and supported Data Guard standby and remote DR
• Built and supported database environment to support HECH application.
• Maintained the Heart beat tables to check the lag between the sites.
• Worked with application team to help resolving the conflict and trouble shouting the replication issues.
• Experienced in Design, implementation and generation of documentation on Oracle 11g Data Guard on physical standby databases in Maximum performance mode.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Performed Setup Recovery Manager RMAN and Flash Recovery in RAC Environment.
• Built and supported stand alone, RAC 2node cluster RAC 3node Cluster databases
• Clone and restore RAC to None RAC and RAC to RAC databases.
• Refreshed RAC to RAC and none RAC to RAC databases
• Configured and setup the RMAN
• Configured Grid control 10g,11g for monitoring multiple environments
• Implement patches, updates, and fixes as necessary following established Change Management processes
• Work with team members to provide 7x24 production support
• Utilize a working knowledge of Oracle database and consuming third-party applications to troubleshoot technical issues, i.e. error messages, software bugs, availability, etc.
• Worked very closely with developer for performance and tuning for database and application.
• Worked with ADDM, AWR and SQL tuning advisor to tune any long running queries and overall database sessions.
• Performed cold backups and restore
• Participated auditing session to comply with SOX requirements
• Participate effectively in execution of projects to support development, integration, production and infrastructure deliverables.
• Ensure system stability, availability and performance
• Upgraded 11 Rel1 to Rel2 RAC and Standalone Databases
• Implemented local and Remote Data guard.
• Troubleshooting Database environments challenges/exceptions/alerts

Confidential

Oracle DBA

• Responsible for performance and tuning, Performance Monitoring Stats Snapshots.
• Installed and configured 10g Grid Control to maintain and monitor databases
• Configured, implemented 10g RAC with ASM disk on Linux servers.
• Installed Oracle 10G RAC on Linux platform using ASM for a storage manager Provided performance tuning on a 10G RAC database on a Linux platform
• Implementation and support of 10g RAC instances
• Administration of development, test and production databases
• Provide on-call support for critical database issues on a rotational basis
• Perform database upgrades and migrations to updated version
• Experienced in patching, upgrading, and monitoring multiple database environments
• Monitoring Development, Test, Staging and Production Environments
• Responsible for system and capacity planning
• Responsible for software installation and database creation
• IP reconfiguration for entire Data center move in Development, Test, Stage and Production environments.

Confidential

Oracle DBA

• Monitoring multiple production and development databases. Monitor RMAN backups.
• Support of over 150 development, test and production Oracle databases and SQL Server.

• Responsible for performance and tuning, Performance Monitoring Stats Snapshots.

• Working on Database Hardening Edit and Monitor the daily jobs Process data dump requests for clients Process database changes for clients.

• Working with DBA team to re-structure the windows environment to accommodate ESC Database Standards.
• Work closely with software developers to meet user requests and assist with prioritization

• Responsible for capacity planning weekly and performance overview reports for all Production databases.

• Responsible for database documentation.

• Responsibilities included configuration and installation for Test and Production.

• Responsible for patch management and upgrades.

• Responsible for 10G upgrade from 8i and 9i oracle versions.

• Applied all DST patches for Application infra and mid-tier production environments.

• Responsibilities included running the daily batch loads from the ESC Data center, monitoring the automated daily backup routines, writing documentation for new components being added to the system, performance tuning and monitoring of database using Oracle Enterprise Manager, 10g Grid Control and performance evaluation utilities.

Confidential

Oracle DBA

• Database 10g in Oracle Real Application Clusters RAC environment.

• Involved in configuration of 10g RAC on EMC Storage Area Networks SAN Migration from SQLServer to Oracle.

• Working with development team for conversion of objects from SQLServer to Oracle.

• Monitoring the database activities jobs, backups, Logs, table space, user activities. Monitoring the tables on sqlserver for daily data update.

• Updating development database daily with fresh data from production

• Setup backup and recovery procedures.

• Monitored server disk spaces, databases performance, replication, and backups and scheduled tasks. Daily management of Oracle database, support and development of applications using PL/SQL
• Oracle DBA support including backups, recoveries, installations, database performance analyzing existing databases and their interfaces looking for opportunities to improve efficiency.
• Configured and managed users, security and redo logs.

Confidential

Oracle DBA

• Introduction and firm foundation in clustering technologies RAC Designed, implemented, and maintained a new Request tracking system. Installation.

• Solution in the COPE environment. Interfaced with users and technical staff to troubleshoot and implement rules. Provided appropriate reports and views into the data for process.

• Generated information sensitive reports with visual pro as front-end tool with SQL Server. Wrote queries against the database for analysis with the help of shell scripts. Programmed, searched and sorted using UNIX tools.

• Collected data from remote system using FTP. Involved in Oracle Forms conversion. Responsible for the back up of databases on regular basis and performing recovery operations when necessary.