We provide IT Staff Augmentation Services!

Logical Dba Resume

Pittsburgh, PA

SUMMARY:

  • Oracle 12c and AWS Devops Certified Professional with 11+ years of DBA experience for diverse industry sectors - Banking, Airlines, Insurance, Health, Manufacturing, Food industry
  • Proficient in assortment of technologies including Oracle, MySQL and Linux
  • Proficient in Oracle Database Administration activities such as installation pf 10g,11g,12c, Upgrades, Migrations, Patches, Cloning, Backup & Recovery, RMAN, Performance Tuning, RAC, shell scripting, and Flashback technology, Datapump, snapshot
  • Experience in writing liquibase scripts as part of deployment automation.
  • Knowledge on MSSQL, PostgreSQL , NOSQL and trained in Hadoop administration and Mongo database
  • In-depth knowledge of Worked on Amazon IAM, EC2, EBS, S3, Glacier, VPC, Route 53, Config, CloudWatch, Cloud trail
  • Worked on deployment automation for Oracle databases using Bamboo tool via liquibase.
  • Created database and user creation automation scripts for Liquibase job using Git-hub/bamboo
  • Applied PSU July 2017 patches on Oracle 11g databases Applied the Cluster ware (GI), Database (RDBMS) Patches and one-off patches using opatch on Linux, AIX servers.
  • Worked on Oracle enterprise manager (OEM) configuration and maintenance of 12c, 13c cloud control.
  • Created and Managed RACONE Node on ODA databases
  • Building Oracle Stand by databases, both Active Data guard and for disaster recovery along with work experience with Data guard broker
  • Involved in Golden Gate and oracle streams unidirectional set up for Oracle database
  • Experience in MySQL database creation non-GTID and upgrade from 5.5 to 5.6 version
  • Experience in managing wallets as part of Transparent Data encryption(TDE) and managed PII data
  • Created the jobs using SHELL scripting for various database activities
  • Performed Database Administration and debugged for database objects including tables, indexes, views, packages and procedures using PL/SQL

TECHNICAL SKILLS:

IBM: AIX, Windows, RHEL 5/6, HP-UX, Solaris

Database: Oracle 10g/11g,12c, ODA 11g, 12c, MySQL 5.6

Oracle Tools: Expdp/impdp Veritas NetBackup on Linux, DB verify, Oracle (OEM,DBCA, Oracle streams, Explain Plan, ADDM,AWR,SQLTRACE,,DBMS SCHEDULER,TOAD,sql developer

Tools: Vantive, BMC Remedy 7.1, Maestro, Tivoli(TSM), Service Center, SM9 Ticketing tool, Data Protector, Putty, WinSCP, ftp, sftp, BMC, NetBackup, MEM,liquibase-bamboo, Github

Languages: SQL, PL/SQL, Unix scripting

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Logical DBA

Responsibilities:

  • Supported Oracle/Mysql databases both on-premises and AWS .
  • Deployed code to various environments using bit bucket/bamboo
  • Written automation script for schemas export of 3 different databases using dbms utlility.
  • Responsible for db/user automation script using Githib/liquibase-Bamboo.
  • To perform day-to-day activities wrote sql queries/procedures and for reporting purpose
  • Installed MEM 8.0 to monitor Mysql databases.
  • Responsible to create RMAN catalog and setup backups using catalog for oracle databases.
  • Involved in Mysql replication by building slave database for Mysql 5.6 version.
  • New database creation in 18c(12.2.0.2) both standalone/RAC and cdb-pdb based.
  • Schema refresh for 12c database using datapump

Environment: Oracle 11g,12c,sql developer, OEM, Shell Scripting, Jira, Linux, LiquibaseMEM,Bamboo

Confidential, OHIO

Oracle DBA

Responsibilities:

  • Responsible for Oracle Database Administration to provide application operation support services.
  • Applied PSU Patches on 11g Oracle databases
  • Reorganization of tables, indexes for defragmentation of tablespaces export import methods
  • Performed RMAN cloning from Prod to non-prod databases
  • Experience with upgrade and migration from oracle 11g to 12c
  • Worked with IAM service creating new IAM users & groups in AWS environment
  • Involved in trouble shooting of databases as part of performance tuning
  • Resolved application connectivity issues along with long running jobs consuming high CPU which resulted in bad performance
  • Diagnose and troubleshoot Database problems and failures.
  • Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training

Environment: Oracle 11g,12c RMAN, OEM, Shell Scripting, Remedy, Linux, 11g Grid

Confidential

Sr. Oracle/MySQL DBA

Responsibilities:

  • Served as DBA in managing about 80+ medium- to large-scale Oracle databases
  • Rebuilding MySQL slave server with non-GTID
  • Migrated MySQL database to AWS using MySQL dump
  • Backed up and Recovered of the Oracle Database and Archive logs using RMAN
  • Applied PSU patches for 11g,12c oracle databases
  • Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability
  • Refreshed Couchbase database on windows using GUI
  • Converted physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database
  • Created standby database on a Exadata server
  • Skilled in performing Logical backup using Traditional export/import and Datapump export/import along with managing wallets as part of Transparent Data encryption(TDE).
  • Worked with application team in solving various performance tuning issues
  • Migration of oracle databases on different platforms using RMAN and Data Pump

Environment: Oracle 11g RMAN, Linux, Remedy, Vantive, Sun Solaris, Couch base

Confidential

Sr. Oracle/MySQL DBA

Responsibilities:

  • Applied PSU patches for Oracle databases for OLTP environments
  • Involved in migration of oracle/Mysql databases to AWS (Amazon web service)
  • Upgraded Oracle database to 12c from 11g
  • Migration of Mysql 5.6 databases using Mysql dump to AWS environment
  • Rebuilding Mysql slave server for 5.6 version with non-GTID
  • Using the flashback feature to roll back the database at particular time as per requirement
  • Database Troubleshooting for oracle errors with oracle support using RDA
  • Migrated the new databases using the RMAN active duplication, recovered and restored data files and archive logs for Dataguard troubleshooting sync issues.
  • Identifying waits and bottlenecks at the database and OS level.
  • Worked on Index Rebuild, DDL update, Created Triggers, Created Tables, Indexes, DB links, sequences etc.
  • Worked on Switchover from primary to standby with/without DG broker during maintenance.
  • Extensively used Oracle features Oracle Data Pump, big file tablespaces, new OEM Grid Control, Database Control, AWR, ADDM, Flashback Database
  • Customization and development of K- shell (Korn Shell) scripts scheduled through Crontab for reporting and monitoring the database activities

Environment: Oracle 11g RMAN, OEM, Linux, Remedy, Vantive, MySQL

Confidential

Sr. Oracle/PostgreSQL DBA

Responsibilites

  • Provided 24x7 Oracle Production Database Administration as part of on-call DBA.
  • Supported 100+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
  • Creation of databases on ODA servers and applied patches on ODA servers.
  • Involved in RAC ONE NODE Database creation
  • Ensured Data Security by oracle Transparent Data Encryption ( TDE ) by managing wallets
  • Monitored the database using OEM 12C by creating threshold points and alerts to different teams to take care of alerts
  • Worked on flash back technology as part of the snapshot standby creation and during deployment scenarios
  • Created the jobs using SHELL scripting for database migration, refresh and reporting, then scheduled them as job streams through cron jobs and Maestro jobs
  • Migrated the databases from stand alone to 2 nodes RAC on ASM file system
  • Refreshed PostgreSQL database using pg dump utility
  • Cloned/Refreshed Database to create patch, test, development and QA environments.
  • Maintained Oracle 11g Data Guard/standby databases for fail-over purposes
  • Managed GUI based Postgresql databases on Vmware
  • Database migration from 10g to 11g on different platforms on 12c ODA servers
  • Involved in Golden Gate unidirectional set up for Oracle database
  • Cloned/Refreshed Database environments using RMAN and data pump
  • Database tuning at the instance level using AWR reports and OEM.

Environment: Oracle 10g,11g RMAN, OEM, ODA, RMAN, Linux, Remedy, Service center(DWNG), Sun Solaris, Golden gate, PostgreSQL

MAZDA, Pune, INDIA

Oracle DBA

Responsibilites

  • Database creation & planning. Managing the physical design of the database.
  • Installing Oracle 11g, grid agent on various platforms.
  • Upgrading the databases, catalog from 10g to 11g
  • Applied the Cluster ware (GI), Database (RDBMS) Patches and one-off patches (for Bug resolution) using opatch on Solaris, RHEL and AIX servers.
  • Provided support in managing Oracle streams databases
  • Database refresh using RMAN, duplicate, Datapump..
  • Using the flashback feature to roll back the database at particular time as per requirement
  • Setup and configured Oracle 11g Physical Standby database (Data Guard) to ensure high availability
  • Resolved standby database gap issues from RMAN.
  • Monitored the database performance using OEM 12C by creating threshold points and alerts to different teams to take care of alerts
  • Worked on block corruption and fixed the corrupted blocks.

Environment: Oracle 10g,11g, OEM, ODA, RMAN, Linux, Remedy, Service center, SM9HP backup tool, Sun Solaris

Confidential

Oracle DBA

Responsibilites

  • Maintaining more than 300 Prod/QA/Dev/LAB databases in 24X7 Environment.
  • Database and server monitoring using OEM 11g and BMC Patrol(Remedy)
  • Installing Oracle 10g, grid agent on various platforms along with database creation & planning.
  • Allocating system storage and planning future storage requirements for the database system.
  • Reorganization of tables, indexes for defragmentation of tablespaces
  • Upgrading the databases from 10g to 11g in standalone environment.
  • Applying Oracle Patches using OPATCH. i.e. Bug Fixes, CPU and PSU Patches.
  • Creation of Physical standby databases and configuring Data guard for high availability
  • Backup and Recovery of the databases using RMAN and TSM backups
  • Cloned/Refreshed Database environments to create patch, test, development and QA environment: s using RMAN and data pump
  • Installation of OEM agent (11g) and OEM grid (Oracle Enterprise Manager), Monitoring tool for oracle databases.
  • Created the jobs through cron jobs and Maestro jobs
  • DR Exercise Perform planned switchover and failover to physical standby database with and without Data Guard Broker

Environment: Oracle 10g,11g, OEM, RMAN, Linux, Remedy, Service centerAIX, Maestro backup tool, Citrix, WinSCP, Tivoli backup

Confidential

Oracle DBA Trainee

Responsibilities

  • Monitoring database and system health and performance.
  • Monitoring alert log and trace files.
  • Managing controls files and redo log multiplexing.
  • Responsible for Oracle Database Administration to provide application operation support services.
  • Provided support to client by traveling to client sites, and rectifying the problems raised for current and prospective customers.
  • Creation of user, roles and assigning privileges
  • Prepared daily, weekly and monthly reports for clients

Environment: Oracle 10g, RMAN, OEM, RMAN, Linux, Remedy, TOAD, Windows

Hire Now