We provide IT Staff Augmentation Services!

Sr. Database Advisor Resume

SUMMARY

  • Hands on experience on various platforms like OEL4/5/6, RHEL Linux 4/5/6/7, AIX, Solaris, Ubuntu and Windows environments.
  • Experience on different variants of Oracle databases such as 9i, 10g, 11g, and 12c.
  • Excellent experience in trouble shooting and fixing performance issues at session and system level using various reports like Explain plan, TKPROF, AWR and ADDM reports.
  • Excellent experience in improving database performance by SQL tunings, SQL profiles and Baselines.
  • Experienced in configuring and Installation of multiple node 11g and 12c Real Application Clusters (RAC).
  • Migrated NON - ASM databases to ASM using RMAN
  • Expertise in installation, configuration, and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager Cloud Control (OEM 12c and 13c), Toad, Oracle SQL Developer.
  • Experience in implementing cross platform Migration such as IBM AIX, Solaris and Windows to Linux.
  • Good experience on Upgrades and Patches in various stand alone and RAC environments.
  • Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using Recovery Manager (RMAN).
  • Configured 11gRAC on ODA Oracle Database Appliance
  • Excellent experience in installing and supporting oracle 12C multitenant databases and converted several regular 12c databases to Multitenant.
  • Good working knowledge in implementing EXADATA features like HCC, Flash cache and SMART SCAN features.
  • Provided and implemented performance tuning recommendations of all components in the Exadata machines.
  • Performed Oracle upgrades with custom build Ansible playbooks and conf deployments by using Ansible in multi-site cluster environment.
  • Performed the automation using CHEF configuration management and managing the Infrastructure environment with Puppet.
  • Defined the automation strategy of Database releases and maintenances on Oracle/Cassandra/Sybase which reduced the overall release time and man power.
  • Supported in analysis and designing of Oracle Exadata Server for infrastructure and related projects, Integration of Exadata monitoring into our existing IT monitoring framework.
  • Implemented Standby Databases with the help of Data Guard for High Availability, Data Protection, and Disaster Recovery for enterprise data.
  • Experience on Fast Start Failover (FSFO) implementation of Data Guard as per the end user requirement.
  • Configured Data Guard for more then 50+ databases with Data Guard Broker and FSFO
  • Pioneer in Installation, Patching, Cloning and Upgrade of Oracle Databases.
  • Experience in replication of schemas using Golden Gate schema replication which includes online change synchronization and DDL synchronization.
  • Golden Gate 11g and 12c installations and maintenance of unidirectional replication.
  • Experience in using PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.
  • Good experience with Oracle enterprise manager (OEM), and utilities like AWR, ADDM, Flashback Technology, SQL tuning advisor.
  • Expertise in configuration and maintenance of table partitions in oracle 11g and 12c.
  • Performance Tuning experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE.
  • Experience in proprietary change management processes to prevent Production Disruptions and Outages.
  • Cloning and Refreshing databases from Production to Test and Development and from Development to Production.
  • Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Good communication and coordination with different departments for efficient problem escalation and deciding on optimal solution.
  • Experience on performance optimization in private cloud models (IaaS/PaaS) with enterprise standards, workflows and industry best practices using VMware products.
  • Rendered performance tuning to VMware servers, Virtual sessions and management of server resources between virtual machines.
  • Strong MySQL skills with significant general system administration skills on UNIX/IBM AIX, Linux and Windows environment, Knowledge in general System Administration tasks.
  • 24*7 production database support to developers & end-users.

TECHNICAL SKILLS

Operating Systems: RedHat Enterprise Linux, Sun Solaris, IBM AIX, Microsoft Windows Server, Oracle Enterprise Linux.

RDBMS: Oracle 12c, 11g, 10g, 9i and 8i, MySQL 5.1, 5.6, 5.7

Database Management tools: Oracle Enterprise Manager Cloud Control (OEM), Oracle Enterprise Manager Grid Control (OEM), TOAD, TIVOLI and ERWIN.

Tools: and Utilities: RMAN, SQL Navigator, SQL*Loader, SQL Developer, ASMCMD, DataGuard Manager Utility(DGMGRL), Server Control Utility (SRVCTL), Traditional Data pump, EXPDP/IMPDP DataPump, Data Guard, VERITAS Net Backup, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Splunk, Putty, Oracle Data Integrator(ODI), and Oracle SQL Developer, Ansible and puppet.

Languages: SQL, PL/SQL, Perl, Bash, Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Advisor

Responsibilities:

  • Involved in 24x7 on-call support for enterprise production databases .
  • Installation and Configuration of 4 node RAC using oracle clusterware and ASM storage, Configured A CFS file system and administer ed ASM Instances and Disk Groups in RAC .
  • Resolved several RAC related outages caused due to node evictions and resolved many performance issues in Oracle 12c RAC databases.
  • Provided support and recommendations for components in Exadata X6 machines and Implement performance tuning for all components in the Exadata machines.
  • Actively participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Monitored IT framework on machines integrated with Exadata.
  • Experience in cloning of databases using RMAN.
  • Migrated over 200+ databases across data centers using various methodologies like DATAPUMP, Log shipping and RMAN XTTS.
  • Configured RMAN backups (Full, incremental and cumulative) and performed recovery, incomplete recovery and disaster recovery.
  • Oracle Instances deployments by using Ansible in multi-tenant installations
  • Install and Configured Disk and file system management using LVM Partitions and ASM Diskgroups.
  • Worked on configuring Oracle 11g two node RAC database on ODA Oracle Database Appliance.
  • Install, configure and upgrade databases to Oracle 12c, consolidate multiple databases into multi-tenant database containers, evaluate and implement latest database technology and new Oracle12c features.
  • Installed Oracle 12c (cloud) and migrated all the databases from Oracle 11g to Oracle 12c.
  • Performed RAC all node patching and Rolling patching.
  • Implemented Backup, Recovery procedures and Hot, Cold and Logical backup plans.
  • Installed and upgraded Golden Gate to version 12c.
  • Successfully implemented Unidirectional Golden Gate replication for Oracle 12c databases on 2 node RAC Clusters.
  • Identified and fixed Golden Gate Replication issues using GGSEVT and log dump utilities.
  • Performed database migrations from AIX Solaris to Linux using Oracle Golden gate and data guard
  • Installation and configuration of Golden gate for replication and resolved issues to sync Databases.
  • Implemented Golden Gate replication during database migration from AIX to Linux server.
  • Installed, configured and supported Golden gate (11g) replication solutions to facilitate data flow between environments.
  • Developed custom utilities to automate manually intensive tasks including mass schema changes, recovering Golden Gate corruptions.
  • Implemented, configured and maintained data guard for oracle 11g (primary and standby databases) to ensure disaster recovery, high availability and data protection
  • Extensively worked in various areas of data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
  • Installed OEM 13C and configured agents on all our monitored database servers.
  • Configured and setup of monitoring alerts and BI publisher reports in OEM 12c and 13C.
  • Implemented the resizing of online redo logs in production and standby databases
  • Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
  • Expertise in the creation of databases, tablespaces, tables, indexes and other database objects.
  • Installed and configured relevant network components to ensure database access as well as database consistency and integrity.
  • Experience in troubleshooting and resolving various Oracle connectivity problems.
  • Extensively used DATAPUMP and Export / Import utilities for logical backups.
  • Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
  • Performed various performance goal oriented database tuning using Explain plan , AWR , ADDM and various Oracle Advisors to tune the database.
  • Tuned various slow running queries to improve performance and decrease data fragmentation.
  • Performed instance tuning, memory tuning query tuning and complete database tuning.
  • Created and implemented various table partitions for large tables.
  • Applied quarterly PSU patches to different versions of databases.
  • Upgraded Oracle 10g database to 11g and 11g to 12c, Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set.

Environment: Oracle 12.2.0.1, 11.2.0.4, Oracle Exadata, IBM AIX 6.3,7.1, Red Hat Linux 6.0, PL/SQL, SQL*PLUS, ORACLE ENTERPRISE MANAGER 12c/13c Cloud Control, Oracle 11g Grid Control, Oracle RAC, Data Guard, Toad 12/12.5, Server control utility(SRVCTL), ASM Command line (ASMCMD), DataGuard Manager Utility(DGMGRL), MySQL 5.5, 5.6.

Confidential

Sr. Oracle Database Admin

Responsibilities:

  • Installed, maintained new Oracle 9i and 8i instances. Upgraded several Oracle 10g instances from Oracle 9i , Connectivity with different client programs using ODBC .
  • Maintained backups for recovery using RMAN in tapes and disks.
  • Planning and implementing Backup strategy for the databases using RMAN , Scripting backups, once in two weeks on the application database.
  • Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
  • Migration from SQL Backtrack to RMAN as backup utility.
  • Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities.
  • Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.
  • Modified and maintained database structures and views for the core system.
  • Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures.
  • Setting up client/server Architecture and distributed processing.
  • Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.
  • Implemented automated backup strategy using the UNIX shell script and CRON Utility.
  • Wrote Shell scripts to automate DBA tasks such as monitoring tablespaces , health on daily basis.
  • Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i .
  • Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
  • Creating users and database links, snapshots on production and development servers.
  • Designed database tables as per technical specifications.
  • Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.

Environment: Oracle 11.2.0.1/11.2.0.3 , Red Hat Linux 4/5, PL/SQL, SQL*PLUS, SQL* loader, Data Guard, Server control utility (SRVCTL), DataGuard Manager Utility (DGMGRL), Toad, AWR, ADDM, Recovery Manager (RMAN).

Confidential

Sr. Oracle Database Engineer

Responsibilities:

  • Worked as Support Database Administrator Responsibilities include Creation & Maintenance of Table Spaces, Data Files.
  • Upgraded database from Oracle 9.2.0.8 to 10.2.0.1 using database upgrade utility (DBUA).
  • Loading data from flat files into database tables using SQL* loader.
  • Creating and maintaining triggers, packages, functions and procedures.
  • Created users and established the application security by creating roles.
  • Used Indexes and Hints to enhance the performance with the help of Explain plan.
  • Importing/Exporting data from/to different databases using utilities like SQL*Loader.
  • Used TOAD for faster application design and developments.
  • Implemented Hot, Cold and Logical backup plans using RMAN and Data pump tool.
  • Creating tables, indexes, views and synonyms depending upon the need.
  • Involved in Designing backup and recovery strategy for OLTP systems.
  • Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
  • Modified spfile parameters like DB block size, block buffers, shared pool.
  • Used NETMGR and NETCA for the creation of Listeners.
  • Involved in Query tuning of SQL Queries.

Environment: Oracle 9.2.0.8, 10.2.0.1, 10.2.0.5, Red Hat Linux 5/5.5, PL/SQL, SQL*PLUS, SQL* loader, ORACLE ENTERPRISE MANAGER 10g Grid Control, Data Guard, Toad, AWR, ADDM, Recovery Manager (RMAN).

Hire Now