SUMMARY

• An accomplished Database Consultant, having 8 years of experience in the field of Application Design, Development and Administration of Operational and Data Warehousing applications
• Experience in install, patch and upgrade of Oracle Databases of various versions and effectively solve any interim issues by self and working with Oracle support
• Implemented High Availability, Highly scalable solutions like Oracle RAC, Oracle ASM and Oracle DataGuard and worked in engineered system like Exadata
• Providing Replication solutions using Oracle GoldenGate, replicating between Oracle - Oracle
• Performance monitoring, Performance tuning database queries and Managing Databases well for future workloads for Oracle databases
• Handled Database Backup and Recovery solutions using RMAN and performed various restore, recovery activities
• Monitor the database, server using hand written scripts, using Oracle Enterprise Manager 12c (OEM), resolving the alerts and fixing them permanently
• Work experience in both Waterfall and Agile methodologies
• Exposure to cloud solutions and working as Cloud Solutions Architect (AWS) and implementing IaaS solutions. Provisioned DaaS databases using Delphix and been part of DevOps and Agile development methodologies
• Worked in on-call support model and taken care of weekend activities

TECHNICAL SKILLS

Operating Systems: Solaris, AIX, Oracle Linux, RHEL

Cloud: Amazon Web Services (AWS)

RDBMS: Oracle 9i, 10g, 11g, 12c, MySQL

DB Management: Toad, DBArtisan, OEM, MySQL Workbench

Modeling Tools: Enterprise Architect, Erwin Data Modeler, MS Visio

ETL Tool: Informatica PowerCenter

Tools: /Utilities: RMAN, SQL*Loader, Export/Import, DataPump

Tuning Tools: Tkprof, Explain Plan, AWR, ADDM

Replication: Oracle GoldenGate 11g

HA Technology: Oracle RAC 11g, Oracle DataGuard

Programming Languages: C, C++, Java, PL/SQL

Other Tools: Unix shell scripting, JIRA, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Oracle DBA Consultant

Responsibilities:

• Develop, implement and maintain the enterprise database system in a mostly UNIX environment, ensuring stability and meeting ongoing business needs for the client
• Troubleshooting various performance issues from different applications and fix them permanently. It includes SQL tuning and Database/Instance tuning and OS level tuning
• Responsible for the day-to-day management of the IT systems
• Responsible for migrating databases across different hardware and upgrade database to latest versions. Provision new environments in Oracle RAC, ASM and migrated databases using RMAN Active Database Cloning
• Configuring, managing appropriate services using Oracle RAC for Application users, Batch jobs so that effective utilization of system resources can happen
• Configure Oracle Wallet and setup properly in a multi database environment and setup auto-login wallets, configuring master keys, setting up TDE tablespaces
• Implemented Disaster Recovery (DR) solutions using Oracle DataGuard and created physical standby and active standby databases. Taken care of monitoring, maintenance of DataGuard
• Worked on various backup, recovery activities using RMAN and performed complete and point-in-time recovery of database, tablespace, datafile in various scenarios
• Responsible for data protection through backups and consistent availability through solutions such as RAC
• Selecting the appropriate AWS service based on compute, data, security requirements
• Deploying, managing, and operating scalable, highly available, and fault tolerant systems on AWS. Migrating an existing on-premises application to AWS. Implementing and controlling the flow of data to and from AWS

Environment: Oracle 11g, SQL Developer, AWS, Erwin Data Modeler, AWR, ASH, Explain plan

Sr. Database Administrator

Confidential, Raleigh, NC

Responsibilities:

• Monitor Databases, Servers and troubleshooting alerts, fix them permanently. Migrated 800+ Database targets from in-house monitoring tool/scripts to OEM 12c which includes agent installation, configuring agents and targets, monitoring template, group, rule set
• Designed, Created, Managed Oracle 12c Container and Non-Container databases and migrated 11g databases to 12c container and non-cdb databases. Managed multiple pdbs on top of cdbs
• Implemented bi-directional GoldenGate replication and effectively taken care of the conflicts and resolution
• Worked on various Datacenter Migration activities with proper planning, communication and implementation with backout strategy. Provisioned new environments in Oracle RAC, ASM and migrated databases using RMAN Active Database Cloning, Datapump methods
• Worked on various DataGuard databases for Disaster Recovery (DR) tests in weekend and effectively carried out the activity without any impact to the application, customers with proper planning, communication and execution
• Good experience in performance tuning of long running queries, SQLs from application and batch by making use of AWR, AWR Grid, ASH, AWR SQL, AWR Diff reports, ADDM, Explain plan, SQL Trace, Tkprof, SQL Tuning advisor, SQL access advisor
• Configuring, managing appropriate services using Oracle RAC for Application users, Batch jobs so that effective utilization of system resources can happen
• Performed implementation of Transparent Data Encryption (TDE) for the Oracle Exadata Databases to enforce security in storage level by setting up Wallet, Master Encryption Key
• Automation and enhancements of various activities like daily validation of database & server, reports to management, monitoring long running processes, new user creation (not by DBA), tablespace & schema growth, cleaning old log files, monitoring table count, public grants using Shell scripts, PL/SQL
• Good exposure of Oracle Apex installation, configuration, maintenance and documentation
• Good exposure to Agile methodologies and been part of Scrum and Kanban meetings. Designed Kanban Boards using JIRA tool for the team and track, monitor work using the Kanban board
• Good exposure to Cloud technologies (AWS) and internal cloud (Click2Compute) and act as Cloud Solutions Architect. Advise development teams on architecting and designing web applications over cloud
• Worked in replicating data from Oracle to Greenplum for massive parallel processing of the Data warehouse data and bring it back to Oracle from Greenplum
• Worked in various tools like Splunk for Dashboard and monitoring, uDeploy (CICD). Support JVM deployments for Apache Tomcat and troubleshooting middleware issues
• Supported Databases of various environments like OLTP, Operational Data Source (ODS), Data Mart and Data Warehouse (OLAP)

Environment: Oracle 11g/12c, RAC, DataGuard, GoldenGate, Greenplum, Toad, AWS, Erwin Data Modeler, AWR, ASH, Explain plan, RMAN, OEM, Jira, Scripting

Database Administrator

Confidential, Raleigh, NC

Responsibilities:

• Responsible for various database, server monitoring including tablespace, archivelog, database status, server utilization, replication, alert log error, file system usage and many
• Install, clone, patch and upgrade Databases from 10g to 11g, 11g to 12c. Effectively solve any interim issues by self and working with vendor support. Also making sure database, server are in compliance with Enterprise and vendor standards
• Experience in install, configure, monitor, troubleshoot and maintenance of Oracle RAC 11g, 12c. Upgraded Oracle GI, ASM from 4 c with proper planning and backout strategy
• Install, configure, monitor, maintenance and troubleshooting of Oracle GoldenGate replication between Oracle-Oracle, Oracle-ApacheMQ, Oracle-Big Data. Making sure no replication break during DDL operation in databases and during outage of database, server
• Implemented Disaster Recovery (DR) solutions using Oracle DataGuard and created physical standby and active standby databases. Taken care of monitoring, maintenance of DataGuard
• Worked on various backup, recovery activities using RMAN and performed complete and point-in-time recovery of database, tablespace, datafile in various scenarios. Created databases using manual RMAN backup, recovery and also using active database cloning
• Experience in various Flashback technologies and performed activities like restore of accidentally dropped tables by partner teams, point-in-time restore of required tables
• Involved and performed various database migration and refresh activities from Solaris to Linux and Linux to Linux across different Data Centers using RMAN or DataPump
• Worked in both SQL, database/instance tuning and resolved issues related to poor I/O, memory parameter misconfiguration, change in execution plan, tuning physical/logical reads, insufficient statistics. Handled performance issues that occurs post upgrade, post migration activity
• Supported Databases of various environments like OLTP, Operational Data Source (ODS), Data Mart and Data Warehouse (OLAP)
• Creating users with appropriate privileges, assigning required roles, managing privileges and roles, configuring profiles and assigning them to the correct user groups (application schemas, generic users, corp-id users) to maintain the control over system resources and access mechanisms
• Creating and maintaining partitions for the Data warehouse environment databases as part of Year End activities and do capacity planning for both file system and Oracle ASM storage
• Effective coordination and communication with Application, OS, Storage, Middle-ware teams and Business users for any planned activities like patching, upgrade, migration and unplanned outage caused by a change ticket on Data Center associated components

Environment: Oracle 10g/11g, RAC, DataGuard, GoldenGate, Toad, Erwin Data Modeler, AWR, ASH, Explain plan, MySQL Workbench, Informatica, RMAN, OEM, Scripting

Confidential

Infrastructure Specialist

Responsibilities:

• Install, configure and manage Oracle and MySQL databases
• Assisted users on creating various database objects like tables, views, indexes, constraints, synonyms and procedures
• Taken care of database usage by checking tablespace usage and adding more space when needed
• Taken care of data copy from one database to another using exp, imp tools
• Performed archivelog removal periodically to make sure database does not get hung
• Monitor the Database statistics using Database Control and take necessary actions
• Assisted users to create index on certain columns to speed up query execution

Environment: Windows XP, Oracle 9i, Database Control, SQL* Plus, MySQL, C, C++, Java, Eclipse, SQL Developer