We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

MarylanD

SUMMARY:

  • Aspiring a challenging and motivating position as an Oracle DBA where I could utilize my broad and in - depth technical expertise, applications experience and educational background.
  • Engineering graduate with around 11years of experience in Oracle database administration (DBA), RAC, SQL and Linux.
  • Providing 24/7 on-call support
  • Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery and documentation.
  • Result oriented, analytical and self-driven professional seasoned with 8+ years of working in a dual role of design and production support.
  • Installed RHEL, setup configured 10g and 11g R2 Databases.
  • Performed refresh.
  • Applied CPU, PSU Patches.
  • Worked with Oracle on issues.
  • Used various methods of Backup and Recovery including user managed and RMAN
  • Worked on Windows, AIX, Sun Solaris, HPUX, and RHEL with various flavors of Linux.
  • Performed various Instance Tuning activities like tuning SGA, PGA and memory parameters.
  • Generated and analyzed statspack, ASH, AWR, ADDM to address areas of concern.
  • Worked with Development team on gathering requirements and for performance tuning.
  • Developed tip and techniques for capacity planning
  • Poses expertise in Building RAC from scratch include OS deployment.
  • Written Shell Scripts to automate jobs
  • Provide DBA support with proactive monitoring using 10g 11g,12c OEM and cloud Control .
  • Build multiple Oracle Data Guard environment for DR.
  • Worked with Storage team to carve out partitions for ASM.
  • Supported Oracle RAC with Data Guard environment.
  • Familiar with Materialize Views set up and configuration for replication .
  • Used Export/import and Data pump for data movement.
  • Configured and Worked on Flash Recovery Area (FRA)
  • Good understanding of Oracle Wait and Wait Classes.
  • Used SQL Developer, TOAD for ERWIN as tools to manage databases.
  • Good knowledge of explain plan and query tuning.
  • Good knowledge on Management of schemas, objects & Partitioning the tables & indexes .
  • Build and administered Oracle GoldenGate uni-directional replication.
  • Worked on Migration projects
  • Used RMAN’s Duplicate Database feature to clone databases.
  • Identified performance bottlenecks and recommended usage of right indexing mechanism.
  • Worked on consolidating databases project.
  • Very good knowledge on Data Dictionary
  • Poses working knowledge on PL/SQL
  • Proficient in data integration between different sources to the EMC Greenplum.
  • Trouble shooting on greenplum issues. creating schemas and roles
  • Worked in datacenter for replacement of disks.
  • Decommisioning of greenplum database.
  • Recovery of segments.
  • Manage backup and recovery functions for a Greenplum data warehouse environment.
  • Experience on Installing, configuring, monitoring and troubleshooting SQL servers.
  • Implement and maintain database security (create and maintain users and roles, assign privileges).
  • Handling routine DB related requests like backup/restore/refresh, DB changes.
  • Troubleshoot various problems that arise in a day-to-day work and fix the issues.
  • Establish and maintain sound backup and recovery policies and procedures.
  • Responsible for improvement and maintenance of the databases to Upgrade.
  • Responsible for Configuring and managing Databases Log Shipping, Mirroring and Replication.
  • Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.
  • Implementation of database maintenance plans and backup automation.
  • Performing database maintenance activities like rebuilding/reorganizing indexes and update statistics.
  • Implementing High availability of databases using replication, log shipping, database mirroring.
  • Perform failover and failback operations in the cluster environment
  • Knowledge on SQL Server 2012.
  • Provide support 24/7 hours for SQL Server.

TECHNICAL SKILLS:

Operating Systems: RHEL 3, RHEL 4, RHEL 5, RHEL 6, Sun Solaris 5.10, Sun Solaris 5.9, HP-UX 11i v1.5, AIX 4.3, AIX 5.3, Windows 2003, Windows 2008, Windows XP

Databases: Oracle 12c, 11g, 10g, 9i,Greenplum, MS SQL Server 2000, 2005, 2008 & 2012,Postgres

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TK Prof, Statspack, AWR.OS Watcher,SQL tuning advisor.

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 12.6, VNC Viewer, SQL Developer, Putty, SQL*PLUS, FTP, ERWIN 4.14, ERWIN,SSMS

PROFESSIONAL EXPERIENCE:

Confidential, MARYLAND

Sr. Oracle DBA

Responsibilities:

  • Performance tuning(query tuning)
  • Creating container and pluggable databases for development, testing and production
  • Performance tuning using OEM
  • UPGRADES.
  • Troubleshooting and providing possible workarounds for different kind of db problems
  • Migrate DB between software versions, platforms, DB products
  • Install, Configure, Upgrade software: server, tools, applications
  • Configuring & implementing backup strategies and automation of backup
  • Guiding application developers for coding efficient on-line and batch applications
  • Reorganization of critical production databases
  • Coding and tuning efficient back end procedures, triggers, functions and queries handling large volume of data
  • Perform refreshes from Non-RAC database to a RAC environment.
  • Security Administration including the management of profiles, roles, users and their privileges.
  • Configure and manage RMAN backup using GRID.
  • Clone databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
  • Object/Schema level re-org whenever the fragmentation is found.
  • Add/configure the database for database monitoring in Grid
  • Worked on Restore and Recover of databases.
  • Basic Administration of Data guard database.
  • Administrate RAC service with SRVCTL.
  • Instance migration from one server to other server.
  • Implemented Critical Patch Updates which Oracle provides for each server.
  • Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
  • Performed number of Media recoveries, tablespace and datafiles recovery and point in time recoveries.
  • Created monitoring base line templates in Oracle 10g Grid based on different thresholds as per the database requirements
  • Created Backup jobs in OEM Grid for databases.
  • Document the SOP and capture the evidences during Change control in Production databases and Validated Systems

Confidential, WISCONSIN

Sr. Oracle DBA

Responsibilities:

  • Migrate databases across Database servers (Non-RAC to RAC and RAC to RAC)..
  • Performance tuning(query tuning)
  • Create databases for development, testing and production (including RAC databases and NON-RAC databases).
  • Performance tuning using timed statistics, statspack report, waits events and TKPROF
  • Troubleshooting and providing possible workarounds for different kind of db problems
  • Migrate DB between software versions, platforms, DB products
  • Install, Configure, Upgrade software: server, tools, applications
  • Configuring & implementing backup strategies and automation of backup
  • Guiding application developers for coding efficient on-line and batch applications
  • Reorganization of critical production databases
  • Coding and tuning efficient back end procedures, triggers, functions and queries handling large volume of data
  • Perform refreshes from Non-RAC database to a RAC environment.
  • Security Administration including the management of profiles, roles, users and their privileges.
  • Configure and manage RMAN backup using GRID.
  • Clone databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
  • Object/Schema level re-org whenever the fragmentation is found.
  • Add/configure the database for database monitoring in Grid
  • Worked on Restore and Recover of databases.
  • Basic Administration of Data guard database.
  • Administrate RAC service with SRVCTL.
  • Instance migration from one server to other server.
  • Implemented Critical Patch Updates which Oracle provides for each server.
  • Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
  • Performed number of Media recoveries, tablespace and datafiles recovery and point in time recoveries.
  • Created monitoring base line templates in Oracle 10g Grid based on different thresholds as per the database requirements
  • Created Backup jobs in OEM Grid for databases.
  • Document the SOP and capture the evidences during Change control in Production databases and Validated Systems

Confidential, MASSACHUSETTS

Sr. Oracle DBA

Responsibilities:

  • Migrate databases across Database servers (Non-RAC to RAC and RAC to RAC)..
  • Performance tuning(query tuning)
  • Create databases for development, testing and production (including RAC databases and NON-RAC databases).
  • Perform refreshes from Non-RAC database to a RAC environment.
  • Security Administration including the management of profiles, roles, users and their privileges.
  • Configure and manage RMAN backup using GRID.
  • Clone databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
  • Object/Schema level re-org whenever the fragmentation is found.
  • Add/configure the database for database monitoring in Grid
  • Worked on Restore and Recover of databases.
  • Basic Administration of Data guard database.
  • Administrate RAC service with SRVCTL.
  • Instance migration from one server to other server.
  • Implemented Critical Patch Updates which Oracle provides for each server.
  • Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
  • Performed number of Media recoveries, tablespace and datafiles recovery and point in time recoveries.
  • Created monitoring base line templates in Oracle 10g Grid based on different thresholds as per the database requirements
  • Created Backup jobs in OEM Grid for databases.
  • Document the SOP and capture the evidences during Change control in Production databases and Validated Systems

Confidential, NEW JERSEY

Sr. Oracle DBA\Sql DBA\Greenplum DBA

Responsibilities:

  • Architected and implemented development environment in support of 4 engineers.
  • Activities from database creation to retirement.
  • Experience in Performance Tuning by using tools/utilities by SQL tuning advisor,Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.
  • Creating and managing different kinds of tablespaces, monitoring and fixing tablespace space issues on regular basis.
  • Routine Database Administration tasks such as Space Management, User Creation and Maintenance, Upgrades and Patches.
  • Performed regular Releases on weekly basis (Application upgrades).
  • Creating and managing database objects, users, roles, privileges, profiles.
  • Scheduling different kind of jobs, monitoring and fixing of broken jobs on regular basis.
  • Performing database refresh using RMAN, Export/Import, and Data pump utilities.
  • Migrating large databases to Linux servers with minimal downtime.
  • Upgrading from Oracle 9i/10g to Oracle 11g.
  • Experience on Installing, configuring, monitoring and troubleshooting SQL servers.
  • Implement and maintain database security (create and maintain users and roles, assign privileges).
  • Handling routine DB related requests like backup/restore/refresh, DB changes.
  • Troubleshoot various problems that arise in a day-to-day work and fix the issues.
  • Establish and maintain sound backup and recovery policies and procedures.
  • Responsible for improvement and maintenance of the databases to Upgrade.
  • Responsible for Configuring and managing Databases Log Shipping, Mirroring and Replication.
  • Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.
  • Implementation of database maintenance plans and backup automation.
  • Performing database maintenance activities like rebuilding/reorganizing indexes and update statistics.
  • Implementing High availability of databases using replication, log shipping, database mirroring.
  • Perform failover and failback operations in the cluster environment.
  • Knowledge on SQL Server 2012.
  • Provide support 24/7 hours for SQL Server.
  • Responsible for gathering the business requirements for the Initial POCs to load the enterprise data warehouse data to Greenplum databases.
  • Contributed in creation of the BRD/functional and technical design document after having multiple sessions with business users team.
  • Responsible for architecting/designing the ETL framework for the Proof of concepts from different GDW/SAP BW data sources to Greenplum database/sandbox.
  • Involved in creating the greenplum schema creations.
  • Involved in the creation of Greenplum functions and views for the customer useActively involved with Greenplum DBAs for loading of GP data along with query performances and standard metric processes.
  • Environment: Informatica Power Center 9.0.1, EMC Greenplum
  • Proficient in data integration between different sources to the EMC Greenplum.
  • Trouble shooting on greenplum issues. creating schemas and roles
  • Worked in datacenter for replacement of disks.
  • Decommisioning of greenplum database.
  • Recovery of segments.
  • Manage backup and recovery functions for a Greenplum data warehouse environment.
  • Having coordination with AWS team.
  • Worked on Data warehousing tools such as IBM InfoSphere DataStage 8.5
  • Oracle9i/10g and IBM InfoSphere DataStage V9.1 and V8.7 using Oracle 10g.

Confidential, NEW JERSEY

Sr. Oracle DBA

Reponsibilities:

  • Apply CPU, DST, RDBMS patches as per the requirement.
  • Migrate databases across Database servers (Non-RAC to RAC and RAC to RAC).
  • Create databases for development, testing and production (including RAC databases and NON-RAC databases).
  • Perform refreshes from Non-RAC database to a RAC environment.
  • Security Administration including the management of profiles, roles, users and their privileges.
  • Configure and manage RMAN backup using GRID.
  • Clone databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
  • Object/Schema level re-org whenever the fragmentation is found.
  • Add/configure the database for database monitoring in Grid
  • Worked on Restore and Recover of databases.
  • Basic Administration of Data guard database.
  • Administrate RAC service with SRVCTL.
  • Instance migration from one server to other server.
  • Implemented Critical Patch Updates which Oracle provides for each server.
  • Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
  • Performed number of Media recoveries, tablespace and datafiles recovery and point in time recoveries.
  • Created monitoring base line templates in Oracle 10g Grid based on different thresholds as per the database requirements
  • Created Backup jobs in OEM Grid for databases.
  • Document the SOP and capture the evidences during Change control in Production databases and Validated Systems

Environment: ORACLE 10g/11g, LINUX, SUN SOLARIS 9, IBM AIX, TOAD

Confidential, Milwaukee, WI

Sr. Oracle DBA

Responsibilities:

  • Member of DBA team supporting database infrastructure containing 500+ databases by regular administrative.
  • Architected and implemented development environment in support of 20 engineers at infancy to 500+ at peak.
  • Activities from database creation to retirement.
  • Experience in Performance Tuning by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.
  • Creating and managing different kinds of tablespaces, monitoring and fixing tablespace space issues on regular basis.
  • Routine Database Administration tasks such as Space Management, User Creation and Maintenance, Upgrades and Patches.
  • Performed regular Releases on weekly basis (Application upgrades).
  • Creating and managing database objects, users, roles, privileges, profiles.
  • Scheduling different kind of jobs, monitoring and fixing of broken jobs on regular basis.
  • Performing database refresh using RMAN, Export/Import, and Data pump utilities.
  • Migrating large databases to Linux servers with minimal downtime.
  • Upgrading from Oracle 9i/10g to Oracle 11g.
  • Replication and Extracting data and applying on production using GoldenGate
  • Creating logical and physical database design as per application requirement with E/R models and normalization using CA Erwin Data Modeler.
  • Authoring change management scripts to production databases.
  • Implementing partitions to the tables, also implemented daily/weekly/monthly purge process for dropping/adding partitions.
  • Performance tuning of Oracle Database Objects by fixing row chaining and row migration
  • Capacity planning for the current and future storage requirements based on database volumetrics.
  • Developing queries for complex business requirements using SQL.
  • Configuring databases and listeners through Oracle Enterprise Manager (OEM).

Environment: Oracle11g/10g/9i,Grid Control 10g/11g/12c,RedHat Linux, Solaris, DataGuard, RAC, ASM, CRS, TKPROF

Confidential

Sr. ORACLE DBA

  • Handling & Administrating Oracle Production, Development and Staging Databases ranging from 50 Gigs to 8 TB in size for various OS Platforms including Linux, Solaris and AIX for standalone and clustered databases.
  • Ensuring continuous 24x7 Availability, Reliability and Optimal Performance of Production Databases using DataGuard, RAC, RMAN etc.
  • Developing Backup Strategy Includes Documentations of Backup and Recovery Processes, Ensuring Successful Periodical Database Backups, Restoration and Testing Backups
  • Proactively identify, diagnose and resolve database issues in Production, Development environments related to SQL, server, performance, locking, bugs, storage, networking, backups and communicate with other teams, clients or agencies in the resolution of these issues.
  • Expertise on OEM10g, OEM11g, OEM12c installation, configuration and monitoring.
  • Experience in Installation and Involved in Implementing RAC Database with 2 and 4 nodes.
  • Write documentation for the DBA group detailing procedures, architecture diagrams and solutions to problems.
  • Applying Oracle Patches Updates (CPU, PSU) and one-off patches on PROD, QA and DEV Databases,Upgradation and Migration of Database from 9i to 10g, 10g to 11g and applying patches when required.
  • Experiences in Wait Interface, Materialized Views, ASM, ADDM and SQL Tuning
  • ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL
  • Partitioned large tables to increase the performance
  • Implementing Range, List Partitions, Hash Sub Partitions
  • Creating and refreshing materialized views
  • Performed SQL tuning and assisted developers with coding PL/SQL
  • Performance tuning of Oracle Database Objects by fixing row chaining
  • Implement change and test plans prior to commencing changes, installs or upgrades and verify in a test environment prior to implementing in production.
  • Implemented Backup & Recovery procedures using RMAN, Hot/Cold Backups
  • Continuous monitoring of the Database through Grid Control and troubleshooting the issues, if any
  • Responsible for setting and managing user accounts, Granting required privileges to users
  • Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE and OEM.
  • Performing the daily Maintenance tasks and interacting with Oracle Customer service when required

Environment: Oracle11g/10g/9i, RedHat Linux, OLTP/DW, RMAN, SQL Tuning, Oracle and OS Patching

Confidential

Sr. Oracle DBA

  • Experience with configuration, installation, and administration of Oracle 10g, RAC, Enterprise Manager, Diagnostic Pack and Tuning pack.
  • Plan, Implemented and documented the RMAN backup strategy for new and Existing RAC and Non RAC databases by configuring channels, allocating space for Backupsets, Implementing retention policy for backupsets, clean the archive log after backup and write the shell script to automate the backup process by scheduling in crontab.
  • Experience in Set up Test environments using snapshots standbys
  • Experienced in Read only Tables, Invisible Indexes, Online Indexes Rebuilds and Rea­­--l Time SQL Monitoring
  • Configured ASM disk groups to store Datafiles, redolog files, and control files.
  • Worked on SQL Performance Analyzer, SQL Plan management and SQL Access Advisor
  • Working experience with Oracle Advanced Security (ASO/TDE) Option and database encryption.
  • Experience installing Oracle database components and tools.
  • Experience with RMAN backup and recovery setup, tuning, and execution.
  • Experience in Enterprise Manager 10g, Virtual Private Database, Transportable tablespaces and scheduler.
  • Database streams and data guard (physical and logical)
  • Database Creation, DB Refresh, create control file, etc
  • Fully utilizes CASE tools to develop, or modify, physical database designs from logical designs, using the logical design, discussion with the Data Analyst, application development reviews.
  • Managed Database security and Auditing.
  • Performed the Oracle DDL, DML operation.
  • Implemented Real Application Clusters (RAC) setup, configuration and cluster interconnection of 5 instances with server side load balancing using Automatic Storage Management (ASM) .

Environment: Oracle10g/9i, Red Hat Linux 4.x, IBM AIX, RAC, DATGUARD

Confidential

Jr. Oracle DBA

  • Oracle 10g Installation on UNIX OS and Windows.
  • Oracle 10g database cloning, patching.
  • Database creation as per project requirements
  • Space management database using OEM.
  • User Management & Security Management
  • Taking Physical and logical backups of the databases.
  • Maintaining Prod, Test.
  • Transferring data using Export-import, Datapump.
  • Daily Logical Backup and restore for UAT database.
  • Used Tools - Oracle Enterprise Manager (OEM), Toad.
  • Monitoring the system resources using vmstat, iostat, top etc.
  • Renamed the Database.
  • Creation of database objects & of table, indexes
  • Changed init.ora parameter.
  • Gathering statistics using Statspack.
  • Check alert log & backup log file for possible oracle errors
  • Managing stand by database, MIS database & Test database.
  • Co-ordination with users & responsible for quick solutions to their problems.

Hire Now