Candidates About

 

PROFESSIONAL SUMMARY:

 

¨       Over 7 Years of experience in IT and I have been developing my skills in Oracle 9i, 10g and 11g Database Administration (DBA) .

¨       Experience with Oracle 9i, 10g and 11g on UNIX, Linux, Solaris & Windows operating systems.

¨       Experience with RMAN, Oracle Enterprise Manager (OEM), Oracle Data Guard, Oracle Data pump.

¨       Extensive DBA experience in supporting multiple ORACLE databases including Development, User acceptance testing & Production.

¨       Experience in cloning/replicating production database using RMAN and manually.

¨       Job scheduling through crontab, O/S updates and upgrades, applying patches.

¨       Experience in backup/restore, disaster recovery using RMAN and manually.

¨       Experience in using data pump import/export utility of ORACLE.

¨       Experience in database migration by designing and implementing database logical and physical storage structures.

¨       Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.

¨       Developed database support processes and automated tasks through UNIX Shell Scripting.

¨       Strong analytical and problem solving skills.

¨       Experience in database security strategies by creating database users, user roles, profiles and audits.

¨       Upgrading and Migrating Databases from lower versions to higher versions.

¨       Experienced in Planning, Installation, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Trouble shooting& Tuning.

¨       Experience in analyzing database & rebuilding indexes to improve database performance.

¨       Implemented & monitored daily, weekly and monthly batch jobs in database.

¨       Taking online training for Big data and AWS.

 

 

TECHNICAL SKILLS:

 

Environment	Description
Hardware	Sun- Solaris, IBM-AIX, SUSE LINUX
Operating Systems	MS DOS, Windows- 95/98/2000, Windows-NT 4.0, Unix (Solaris-5.10),Exadata
Database	Oracle 9i, 10g and 11g, SQL Server.
Languages	C,C++,SQL, Unix Shell Programming
DB Tools	Toad, Export, Import, Data pump, RMAN, SQL Loader, AWR, ADDM, STATSTPACK, tkprof, SQL developer,SQL Server Management Studio.

 

 

EDUCATION:

 

ü  Master of Science in Communications.

 

CERTIFICATION:

 

ü  Oracle 10g Certified Professional.

 

PROFESSIONAL EXPERIENCE:

1.       Tata Consultancy Services                                                                           (Oct’2014 – Aug’2017)

Designation: ITA (Oracle DBA)

Client – Hospira

Responsibilities:

Ø  A member of Project team and was responsible for maintaining the health of all the Oracle Databases in the environment.

Ø  Managing the request of the users through Service-now service request queue.

Ø  Monitoring the incident alert about the space or alert log issues through automated email alerts.

Ø  Troubleshooting and root cause analysis P1 issues related to the databases.

Ø  Defining user roles and permission, based on the level of access required.

Ø  Perform disk space management on the Australia servers as weekly maintenance tasks on the Servers.

Ø  Refreshing the schema/test databases with the latest data as per the request from the Application team.

Ø  Monitor the performance and capacity of the administered systems and respond proactively to any potential problems identified.

Ø  Manage & Administration of Australian databases and servers by sending the health check report weekly.

Ø  Work with the Application team for issues corresponding to the application connectivity or enhancements by doing structural or data changes in the database.

Ø  Perform Day to Day Support to User issues (Account related, connectivity, performance etc.).

Ø  Support Australian Client issues, troubleshoot database related issues

Ø  Monitor database performance and Availability.

Ø  Strong day-to-day administration experience within a medium environment.

Ø  Patching, maintenance, Upgrades, and migration of the databases.

Ø  Experience with Microsoft Outlook 2007 / 2010.

Ø   Document processes and procedures, creating SOPs, working on RFC's.

Ø  Golden gate implementation and monitoring.

Ø  Assisting team in helping in their queries and issues.

Ø  Managing weekly report for the database health check and failed login/multiple password resets attempts in the production database.

Ø  Managing RAC databases on Exadata using Goldengate replication.

Environment: Red Hat Linux 5.4/5.5, Sun Solaris 9/10, Oracle 11g/10g/9i/8i, RMAN, Putty, Service-Now Ticketing Tool.

 

 

 

2.       Tata Consultancy Services                                                                           (July’2011 – May’2012)

Designation: ITA (Oracle DBA)

Client – ELI Lilly

Responsibilities:

Ø  Strong 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Ø  Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.

Ø  Supporting over 200+ critical production databases along with 90+ QA/DEV databases of sizes from 80 GB to 9TB.

Ø  Upgraded databases from 10g to 11g.

Ø  Handling issues related to Database Upgrade/Migrate and Patching.

Ø  Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.

Ø  Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN NetBackup.

Ø  Skilled in developing RMAN scripts for database back up including hot and cold backup options

Ø  Diagnosing and performing root cause analysis on ORACLE INTERNAL errors like ORA-600, ORA-7445 and ORA-3113 issues.

Ø  Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Ø  Writing UNIX shell scripts for backup and recovery, Import and export procedures.

Ø  Maintaining the availability of the databases by checking the daily alert log reports.

Ø  Troubleshooting the backup related issues.

Environment: Red Hat Linux 5.4/5.5, Sun Solaris 9/10, HP-UX, Oracle 11g/10g/9i, RMAN, Putty, X-Ming, AR Ticketing Tool.

 

 

3.       Fiserv India Pvt. Ltd.                                                                                       (Sep’2008 – Mar’2011)

Designation: Software Engineer (Oracle DBA)

Ø  Supported Oracle version-Oracle 9i, 10g on windows server 2003.

Ø  Installed, configured, maintained Oracle Database Software 10g on Windows machines.

Ø  Managing the Oracle 10g database of 40GB, was involved in the maintenance of the   development/Test environments.

Ø  Implementation and configuration of OEM, Oracle Management Server for maintenance and monitoring.

Ø  Performing Hot / Cold backups of the database through RMAN or User Managed method.

Ø  Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.

Ø  Review alert logs and dump files to check for any problems related to the database.

Ø  Perform database cloning/exp/imp to setup identical databases in the development/Test environments.

Ø  Create and maintain users, roles and privileges.

Ø  Upgrade/Migrated the production and development databases from 10.2.0.1 to 10.2.0.3.

Ø  Good working knowledge of RMAN Backup, Restore and Recovery.

Ø  Excellent knowledge of Import and Export.

Ø  Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.

Ø  Created lots of  SQL’s for task automation like generating reports(e.g. Timesheets, task based efforts etc.) for monthly project analysis and which helped in the smooth working of the projects.

Ø  Created PL/SQL procedures for the generating the Monthly collective data for the Management for data analysis.

Ø  Identify top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.

Ø  Applying patches and updates.

Ø  Created batch jobs for the automating the RMAN backups and removing the old trace files for the regular maintenance and Space management.

Ø  Tuned SQL queries using TKPROF and EXPLAIN Plan.

Environment: Oracle 10g, SQL Developer, RMAN,Windows 2003 Server, Tortoise SVN.

 

4.       Cognizant (T-Systems India Pvt. Ltd.)                                                     (Aug’2006 – Aug’2008)

Client : T-Systems, Germany

Designation: Associate Consultant (Oracle DBA)

Ø  Supported Oracle version-Oracle 9i, 10g all releases on all platforms e.g. Solaris, HP-UX, IBM AIX, and Linux.

Ø  Installed, configured, maintained Oracle Database Software 9i/10g on Solaris, Solaris x86, Linux x86, Windows machines.

Ø  Performing Hot / Cold backups of the database through RMAN or User Managed method.

Ø  Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.

Ø  Review alert logs and dump files to check for any problems related to the database.

Ø  Perform database cloning/exp/imp to setup identical databases in the production and development environments.

Ø  Create and maintain users, roles and privileges.

Ø  Upgrade/Migrated the production and development databases from 9i to 10g.

Ø   Good working knowledge of RMAN Backup, Restore and Recovery.

Ø  Excellent knowledge of Import and Export and datapump.

Ø  Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.

Ø  Creating shell scripts, SQL scripts for task automation.

Ø  Good knowledge with writing PL/SQL stored procedures, functions, packages and triggers.

Ø  Identify top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.

Ø  Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.

Ø  Applying patches and updates.

Ø  Create small shell scripts and cron jobs for the regular maintenance and automating small backups.

Ø  Tuned SQL queries using TKPROF and EXPLAIN Plan.

Environment: IBM AIX 5.3, Solaris 5.9,5.10,RHEL 4,5, Oracle 9i/10g/11g,SQL Developer, TOAD,RMAN,  Windows XP, Putty, FileZila, X-Ming, X-Manager, WinScp, Tortoise SVN, AR Ticketing Tool.