CAREER OBJECTIVES:

I am looking for a challenging position as Database Administrator that will allow me to utilize my experience and knowledge and be an essential part of a team. I bring forth new and innovative ideas for growth and management within the organization.

PROFESSIONAL SUMMARY:

• Around 8+ years of experience as Oracle 10g/11g/12c and MSSQL 2005/08/12 DBA providing support to Production, Test and Development environment.
• Have Strong interpersonal skills with the ability to interact with end - users, managers, technical personnel, etc.
• Excellent work ethics and team oriented with strong analytical and leadership qualities.
• Possess good communication and inter-personal skills, able to adapt quickly to new technologies and environments.
• Proficient at working as a team player with an aim of contributing towards the team's success.
• Involved in unit testing, systems integration testing and documented the same.
• User management, tablespace management, Schema design.
• Involved in golden gate implementation project.
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Design, Creating and Maintaining the Database.
• Experience in analysis, design, development, implementation and testing of applications in data warehousing and
• Client/server environment.
• Experience with Oracle SQL and PL/SQL programming and using Database tools like TOAD, SQL*plus and Oracle SQL Developer.
• Familiar with SQL*Loader to load data from external source like flat files into database tables.
• Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, Views.
• Experience in Performance Tuning of SQL statements and Database using tools/ reports like Explain plan, ASH/AWR/ADDM.
• Have Strong interpersonal skills with the ability to interact with end-users, managers, technical personnel, etc. Excellent work ethics and team oriented with strong analytical and leadership qualities.
• Administered databases on AIX/Linux and Windows platform.
• Experience in Installation, Configuration and Re-Configuration of Oracle Database on AIX, Red hat Linux 4/5/6 and Windows servers.
• Experience in planning and scheduling RMAN, Original Export/Import, Data Pump backups
• Involved in recovery of datafiles, redologfiles and control files.
• Experience in Oracle 12c Grid control and grid upgrade.
• Experience in backup/restoration using native/TSM/Light speed.
• Experience in deploying, executing package using SSIS and BIDS.

TECHNICAL SKILLS:

Database: Oracle Database Server (9i, 10g,11g,12c) administration, MS SQL Server 2005/08/2012 , BIIDS, OEM - Oracle Enterprise Manager Cloud control 12cR5

Operating System: Windows XP / / 7 / 8, Red Hat Enterprise Linux, IBM AIX

Oracle Utilities / Reports: SQL* Loader, Exp/Imp, Data Pump Exp/Imp, External Tables, ADDM, ASH,AWR, STA,TSQL

Tools: Putty, Cygwin, SQL*Plus, Toad 9/10, Oracle SQL Developer, SSMS 2005/08/12, Basic SSIS, Light speed, BIDS, VNC, MobaXterm, NetSupport Manager,ISQL

Software Applications: MS Office Suite, Adobe Suite, FileZilla, BMC Blade Logic

Scripting Language: Shell script, Batch

Database Language: SQL, PL/SQL, T- SQL

Programming Language: C, C ++ (Basic)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Environment: Windows 2008 Enterprise Edition R2, RHEL 6

Responsibilities:

• 24x7 L2 level database and operational application support for centralized and standalone systems for 60 properties.
• Configure database with application, interfaces and 3rd party service application servers.
• Work with Oracle support tickets to resolve application and database issues.
• Test/Apply latest Host fixes and patches on application.
• Upgrade OEM from 12.1.0.2 to 12.1.0.5, Upgrade OEM agent from 12.1.0.2 to 12.1.0.5.
• OEM repository database upgrade from 11.2.0.3 to 12.1.0.2.
• Upgrade OEM from 12.1.0.5 to 13.1.0.0, Upgrade OEM agent from 12.1.0.5 to 13.1.0.0.
• Upgrade GI from 11. .1.0.2.
• Apply Opatch on GI and RAC database system.
• Capacity planning for OEM, QA and Dev environment.
• Restore backup using RMAN catalog to build test and dev environment.
• Apply Opatch on repository database, MOS and agent.
• Create, set up rules on OEM for all database alerts.
• Decide threshold value for all alerts.
• Add and delete agent from OEM grid control.
• Monitor and troubleshoot data guard for 4 node RAC for missing or corrupted logs.
• Performance tuning for BI Projects on request.
• Performance tuning using AWR.
• Hospitality application-Opera upgrade.
• Day to day database health check, table space management and operation troubleshooting.
• Implement shell-script for EBS automation utility.
• Rewrite PL/SQL, SQL code for new requirement and performance tuning.
• Maintain documentation for server inventory, upgrade and troubleshooting.

Confidential

Oracle/MSSQL Developer/DBA

Environment: Linux/Unix, WINDOWS 2005/08/12

Responsibilities:

• Worked on CASD Ticket system for day to day trouble shooting.
• 24x7 on call DBA support for DEV/TEST/PROD environment.
• Participate in day to day deployment for release.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures.
• Database admin copy using data-pump.
• Backup / Restoration MSSQL database using SSMS/Light speed.
• Take Native, Light speed and LSTSM backups.
• Schedule backup and maintenance jobs.
• Remove tables, Procedure from replication.
• Deploy/Execute packages using SSIS/BIDS.
• Export/import tables in different environment.
• User, schema and space Management.

Confidential

Oracle DBA

Environment: Linux/Unix

Responsibilities:

• Worked HP ticket system for day to day trouble shooting.
• Performing daily and weekly health checkup of Production, QA and Development database to ensure 0% downtime.
• Involved in Database Upgrade activity.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality. Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Involved in troubleshooting activities like working on ORA- alerts which are generated from OEM/alert logs & if required working with ORACLE SUPPORT to resolve the issue.
• Involved in DBA activities like Index rebuilding, analyzing objects, table rebuilding, tablespace monitoring, cloning.
• Interacting with client to help them to resolve their database related issues.
• Used Data pump for exporting and importing tables, schemas and table spaces.
• Performs ongoing tuning of the database using tools/ reports like Explain plan, ASH/AWR/ADDM reports.
• The DBA will carry out the daily, weekly and monthly tasks as specified
• Verify that all the databases/services are up and running.
• Verify success of database daily backups (export/hot/archive log).
• Verify database resources like…
• Tablespace Management.
• Rollback or Undo Segment Management.
• Temp Tablespace Management.
• Archive Log/Redo log Management and
• Disk Space Management to ensure sufficient disk space.
• Look for any Security Policy Violations.
• Archive all alert logs to history.
• Trace files management.
• Weekly backups(COLD/Tape backups)
• Weekly on call support.
• Monitoring/supporting weekend maintenance window.

Confidential

Oracle Developer/DBA

Backup Environment: TSM

Environment: IBM AIX-6

Responsibilities:

• Supporting 24/7 Production databases along with Logical - MIS and physical - DR standby database (Data Guard).
• Installation, configuration of oracle database server on windows platforms in test environment.
• Developed user defined functions based on requirements. Developed interfaces using PL/SQL Stored Packages, Procedures, Functions, and Triggers. Created PL/SQL procedures and packages.
• Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations.
• Loaded the data into the tables using TOAD and SQL*plus.
• Good knowledge on joins, which are inner join, Left outer join.
• Basic database environment troubleshooting.
• Scheduling and managing batch job.
• Patching databases on various platforms.
• Upgrade and migration of database.
• Managing users and security by creating roles and profiles.
• Ensured database security using appropriate roles and privileges.
• Creation and Maintenance of schema objects such as tables, indexes, and views.
• Performing backups using RMAN and Import / Export Utilities based on defined policies.
• Periodically checking physical backups by restoring on Test database.
• Interaction with Oracle Support Services to resolve mission critical issues.
• Implement and maintain the methodology and procedure standards for the effectiveness in the access, backups and recoveries.
• Creation of various database objects as per requirement.
• Interacting with Clients / Application Developers to fulfill their database requirements.
• Monitoring database objects and auditing as per defined policies.

Confidential

Oracle Developer/DBA

Environment: Windows bit

Responsibilities:

• Capacity Planning and Space Management.
• Supported Production and Physical Standby-DR databases to make them available 24x7.
• Daily and weekly backup using original export/Import and RMAN as per defined policies.

Confidential

Oracle Developer/DBA

Environment: RHEL

Responsibilities:

• Installed 10.2.0.4 database on TEST Environments.
• Regular Monitoring of Alert Log Files on Day-to-Day Basis.
• Creating database users, granting roles and privileges to users.
• Analyzed the business requirements for the enhancements needed in the contract Administration application and related policy modules.
• Documented the detailed requirements and prepared DLD for the new enhancements.
• Performed several DDL, DML and TCL operations.
• Added database triggers to some history tables of the database.
• Used file handling in Oracle to read and write into files associated with the modules.
• Refresh the development and test databases using export/import utilities.
• Provided 24*7 on call support to production environment.
• Communicating with management, development teams, vendors, systems administrators and other related service providers.
• Database backup & Recovery for no archive and archive database using RMAN.
• Used Data pump for exporting and importing tables, schemas and table spaces.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Taken database, schema and database level backup using Data pump utility.

Confidential

Oracle Developer/DBA

Environment: Windows

Responsibilities:

• Installed 10.2.0.2 database on TEST Environments.
• Providing process driven support to end users and application developers. This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
• Regular Monitoring of Alert Log Files on Day-to-Day Basis.
• Creating database users, roles and responsibilities.
• Involved in recovery of datafiles, redologfiles and control files on the test environments.
• Logical backup using export/import and Data pump.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Implemented stored procedures, procedure, function, triggers as per requirements.
• Data loading using External tables.
• PL/SQL and SQL tuning.
• Uploading flat file data using Oracle utilities.