We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume Profile

GA

SUMMARY

  • Having more than 10 yrs of experience in Information technology with a strong success record in Database Administration, System Analysis Design,SDLC and Software Development.
  • Strong knowledge and experience with Oracle 11g/10g/9i/8i/8.x/7.x RDBMS onUNIX/Linux/ Windows environment.
  • Migrating and Upgrading the Databases between different environments and versions.
  • Procedures using RMAN, VERITAS Net Backup.
  • Excellent knowldege using Oracle Forms Developer 6/6i and Reports 6/6i.
  • Ability to grasp and adapt new technologies and systems quickly. A commited team player.
  • Knowledge and proven domain expertise in Energy Utility areas, Transportation and Policing.
  • Certified Oracle 9i DBA, Certified Oracle Forms Developer Release 6/6i.
  • Worked on more than 5 TB of Data.
  • Installation, upgradation and maintenances of Oracle RDBMS on UNIX/Linux and Windows platforms.
  • Backupof database Logical and Physical hot and Cold Procedures and also using RMAN.
  • Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation
  • Extensively worked on Oracle Utilities Data Guard, Data Pump, Flashback, SQL LOADER and RMAN.
  • Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
  • Experience in using GoldenGate to support data replication in the Oracle database environment.
  • Recovery of database in case of database crash, disk /media failure etc.
  • Database desing and Implementation.
  • Implement and maintain database security create and maintain users and roles, assign privileges .
  • Strong Exposure on High Availability Concepts RAC, Standby , Database Cloning, and Oracle Streams.
  • Strong knowledge and experience of managing Oracle 9i, 10g and 11gR1, 11gR2 RAC environments using the OEM GridControl tools.
  • Perform database tuining, application tuning and performance monitoring using STATSPACK, EXPLAIN PLAN ,TKPROF,AWR,ASH,ADDM report.
  • Create and maintain documentation and standards.
  • Capacity planning, capacity monitoring and management.
  • Work as a part of team and provide 24x7 support when required.
  • Load and extract formated data in and out of database ETL .
  • Perform general technical troubleshooting and give consultation to development teams.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROFand ADDM reports.
  • Experience in Oracle Enterprise Manager OEM Grid Control, TOAD, RMAN.
  • User requirement study
  • Creating libraries for standard reusable procedures functions.
  • Prototype devlepment based on the design specification.
  • Designing various data entry forms.
  • Design various custom reports and essential lexical reports.
  • Installation and setting up the software for run time environment.
  • Training the end users.
  • Sytsem support modifications according to the user request.
  • Writing data conversion procedures.
  • Integrated testing of application.
  • Installation and configuration of RAC10g 11g on RHEL/SLES.
  • Shell scripts bash,bourne,csh,ksh,sh
  • Professional Certification / Special Training and Education:
  • Oracle Certified Professional OCP 9i Database Administrator.

TECHNICAL SKILLS:

  • RDBMS : Oracle DB 10g / 9i / 8i / 8.0 / 7.x, SQL Server 2000 / 7, MS Access
  • Middleware : Oracle 9iAS, Oracle Weblogic Server 10.3.3
  • Operating System Sys Admn : Sun Solaris 10 / 9 / 8 Red Hat Linux 7.1 / 9.0, Novell Netware 4.x, Windows 2000
  • Programming : PL/SQL, Shell Scripts ksh,csh , perl scripting.
  • Tools : TOAD, OEM 10g, Oracle Developer Suite, Nimsoft, Unicenter.
  • Hardware : Sun Fire, Sun Enterprise, Compaq, DELL Enterprise servers,
  • IBM minis
  • CASE Tool : Designer 2000 R 6i Knowledge of Process Modeler,
  • ER Diagrammer,Database Transformer, Application
  • transformer, Design Editor and Design Capture , power designer 15.1

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

  • Responsibilities include supporting Verizon Wireless systems in a very large complex Solaris, AIX and Linux environment.
  • POC for highly mission critical system and leading team of 5 DBAs.
  • Providing 24/7 database administration support for 4-node Oracle 11g RAC databases in production and 2-node RAC in pre-prod, development, test, training and integration environment.
  • Planned and rolled out Phase-I SOX database security compliance across the enterprise production systems.
  • Supported Oracle quarterly rolling PSUs for RAC databases and OS patches.
  • Leading IBM IIDR/CDC heterogeneous data replication - implementation, upgrades, support from/to DB2/Mainframe and Oracle.
  • Built 3 node Oracle 11g RAC GI/ASM/DB on RHEL and configured application schemas, tablespaces and scripts for export and RMAN backup.
  • Participated in Oracle SuperCluster/Exadata architecture, database consolidation, capacity planning, LDOMs and Zones for non-prod and prod systems.
  • Configured unidirectional Oracle Golden Gate and supported Shareplex 3-way replication between Oracle databases in 3 data centers.
  • Installed and configured 2-node Oracle 12c RAC.
  • Coordinate, plan and implement monthly Enterprise Releases.
  • Attend code reviews for Enterprise releases and weekly VCOPs changes.
  • Presented IBM IIDR/CDC data replication and OEM 12c Change Management to EOS DBA group.
  • Performance tuning explain plans, SQL tuning, SQL profiles, top activity, top SQLs, AWR global/diff, top events.
  • Installed and configured Active Data Guard.
  • Supported PCI Layer 3 migration including firewall rules testing.
  • Implemented SharePoint ticketing system for DBA tasks and problem/incident management.
  • Providing on-call support for Verizon EOS Oracle systems.
  • Implementing CA's dSeries job automation for non-prod and prod Application related jobs.
  • Configured RMAN Init level 0/1 backup policies and VTL/TSM backups.
  • Supported ICONIC load testing and monitored database performance.
  • Received Certificate of Appreciation for Outstanding Personal and Team Commitment from Verizon management.

Environment: Oracle Database 10g, 11g R1, 11g R2, Sun solaris 5.9 , Redhat linux AS 6.2, TOAD ver. 11.5. OEM 10g Grid, OEM 12C, dbArtisan,

Confidential

SrOracle DBA

Responsibilities:

  • Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
  • 24 X 7 Production Oracle database support, administration and on call rotation.
  • Installation and configuration of oracle 10g and 11gR2RACdatabases.
  • Upgrading databases from 10g to 11.2.0.3.
  • Implemented Golden Gate replication solution.
  • Configured initial and incremental load using golden gate.
  • Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate with zero downtime.
  • Installed and configured Golden Gate director server/client for monitoring golden gate processes.
  • Upgraded OWB repository from 10g to 11.2.0.3.
  • Maintained and upgraded databases and software.
  • Worked on rolling patch apply throughout the environment with no downtime.
  • Monitored system resources and takes action to keep the system at optimal performance using Grid Control.
  • Planned and implemented a backup and recovery strategy using RMAN and Data Guard.
  • Worked on database refresh using hot backup and rman backups.
  • Worked on SQL explain plans and query performance, session tracing.
  • Application Tuning: Identifying the sql's causing I/O bottlenecks, sql's of high cost and giving recommendations to the development teams accordingly.
  • Configured Oracle grid control to manage the entire database in single centralized location.
  • Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
  • Creating table spaces, tables, and users for custom applications.
  • Automation of Startup Shutdown on all Production and Development Database.
  • Implemented oracle high availability solution using Oracle Physical Logical Standby.
  • Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance.
  • Worked on schemas creation and maintaining large partitioning tables.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Monitoring space requirement for production databases.

Environment: Oracle 10g/Oracle 11g/RAC, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard

Confidential

Oracle DBA

Responsibilities

  • Provided support for all the databases as an operational database administrator
  • Configuration and Creation of Databases
  • Develop and deploy logical and physical test and production database solutions for Oracle 9i, 10g database and SQL Server 2005 Databases.
  • Worked on recovering data files, control files, block corruption.
  • Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
  • Involved in the maintenance of the database at Segment level, also user management activities depending on the data access requested by a specific user.
  • Upgrade/Migrated the production and development databases from 9i to 10g,
  • Installed Oracle 10.2.0.5 on Linux, AIX, Windows 2003 Server, HP-UX and Solaris.
  • Going through the day-to-day user requests and troubleshooting the database related problems.
  • Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs issues resolutions and personal research.
  • Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import move procedures.
  • Installed and configured the Oracle Cluster ware cluster file system for RAC.
  • Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
  • Rebuilding of Indexes for better performance, maintenance of Oracle Database.
  • Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions.
  • Taking periodic Backup of the Database and the software using RMAN.
  • Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
  • Scheduling jobs using Oracle Job Scheduler.
  • Scripts for Cold Backups, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
  • Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
  • Installation and configuration of Oracle Client software and Tools.
  • Monitoring and Optimizing database performance.
  • Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
  • SQL scripts to monitor Tablespaces and extent growth.
  • System monitoring and maintenance to ensure the high availability.
  • Generating administrating Reports of Database on free space statistics, cache statistics and database.
  • Creating, altering and dropping data files, tablespaces, and schema objects in the database.
  • Rebuilding of Indexes for better performance, maintenance of Oracle Database.
  • OS level activities like space monitoring of Mount point.
  • Storage Management, Managing Space, Tablespaces, Segments and Extents.
  • Taking Hot and Cold Backups, Exports etc.
  • Creating the database tables, setting privileges, indexes, user logins, passwords security .
  • Responsible for monitoring daily and weekly backups, alert logs space.
  • Resolving network related issues.
  • Responsible for schema comparison using TOAD.
  • Automated the process of analyzing tables every night.
  • Installation and configuration of Oracle Client software and Tools.
  • Worked with application developers in resolving application issues.
  • Responsible for optimizing the queries and application tuning.
  • Installed and Implemented Backup Recovery procedures.
  • Proactive database monitoring using automated scripts based on v views.
  • Developer Environments setup using database cloning.

Environment:Oracle Server 8i,Oracle Server 9i, Oracle 10g, SQL, PL/SQL, SQL Server 2000 2005 ,Linux ,Shell scripting.

Confidential

Oracle DBA

Responsibilities:

  • 24 7 Production Database Administration Support
  • Installation and configuration of Oracle Server software 9i and 10g
  • Created Oracle 9i and 10g databases, allocated system storage and planned future storage requirements for the database.
  • Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.
  • Written PL/SQL Stored Procedures, Functions, Packages and Triggers
  • Automated hourly, daily, weekly system health reporting using crontab, PL/SQL and shell scripts.
  • Developed UNIX shell scripts with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Created database links for accessing data from remote databases.
  • Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.
  • Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
  • Implemented Recovery Manager RMAN . Created recovery catalog, performed complete and incomplete recovery using RMAN.
  • Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
  • Implemented and maintained Database security.
  • Created / Altered / Dropped Users as and when required and administer their respective quotas.
  • Implemented cloning using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
  • Implemented shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
  • Created Database Links and Snapshots Materialized views .
  • Performed Hot Backups and maintained database availability to support non-stop Business operations.
  • Configuring network components like TNSNAMES, SQLNET etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.
  • Performance tuning using AWR, TKPROF, EXPLAIN PLAN STATSPACK, AWR, ADDM
  • As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Environment: 10g RAC/Oracle 9i/Oracle 8i, Data Guard, HP-UX, Red hat Linux, RMAN, ASM, SQL Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential

Oracle DBA/Developer

  • Involved in the process of tuning and refining queries of various applications.
  • Prepare the documents of the process and knowledge transferring about the project tothe new team members.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Wrote scripts for Startup, Shutdown and automation of backups.
  • Monitoring and Management of table space growth, extent growth.
  • Storage and space management including table spaces and data files.
  • Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
  • Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup recovery, space management in database, user and roles administration, schema management.
  • Involved in 24x7 Oracle Production Database Administration.
  • Monitored Production Databases, Performed performance tuning, added data files, resized segments, and tablespaces.
  • Installed and configured Oracle 10g.
  • Migrated Oracle 9i database to Oracle 10g.
  • Monitoring Database for fragmentation and correcting them.
  • Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan
  • Planning and implementation of Backup and recovery procedures and Maintenance of Database.
  • Performed Backup/Recovery using RMAN.
  • Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
  • Interfacing with Oracle Corporation for technical support.

Environment:: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting

Hire Now