We provide IT Staff Augmentation Services!

Oracle Dba Resume

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.

Hire Now