SUMMARY:

• A Senior/Lead Oracle DBA with 10+ years of Oracle Database Administrator experience providing 24/7 support for development and production Oracle 12c/11g/10g/9i databases on various platforms including Red Hat Linux, Sun Solaris, HP UX and IBM AIX. Currently employed by Target as a Lead DBA/Database Engineer supporting multi - terabyte databases. My primary focus is Oracle with additional responsibility for SQL Server and PostgreSQL
• Experience in Installation of Oracle 11g Real Application Clusters (RAC) databases on Linux and Sun Solaris operating system
• Experience in migrating Standalone Database to High Availability RAC environment with ASM
• Configured Data guard environments for disaster recovery and high availability, experience setting up physical & logical standby, active DataGuard
• Experienced and proficient in producing complex migration strategies and supporting artifacts including requirements discovery and analysis.
• Extensive experience in planning and execution of Database Backup and Recovery using RMAN
• Expertise in SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities)
• Performance tuning of the database - SQL Statement Tuning. Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, ZFS, NFS Storage.
• Extensive experience with database audit vault, Transparent Data Encryption
• More than 3+ years of working experience on Agile/Scrum Team.
• Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills and excellent interpersonal and communication skills, self-starter and a quick learner.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g, UNIX, SQL, PL/SQL, bash scripting, Data warehouse, ETL, EXADATA, PostgreSQL, and MongoDB

Operating Systems: Windows, Linux, Sun Solaris, HP UX, and IBM AIX

Development: SQL, PL/SQL, UNIX Shell Scripting, Oracle Designer, Hadoop, Ansible, NoSQL

Tools: OEM (Oracle Enterprise Manager), SQL*PLUS, PL/SQL, SQL*Loader, Agile, ZFS, Export/Import, RMAN, 11G,12c OEM, Microsoft SQL Server 2008,2012, MySQL, VLDB, VM Ware

PROFESSIONAL EXPERIENCE:

Confidential

Lead DBA/Database Engineer

Responsibilities:

• As a part of scrum team worked on analyzing the communications, and programing requirements of clients; planning, developing and designing business programs with agile methodology.
• Support and manage multi-terabyte databases in Oracle and SQL Server database environments.
• Performance monitoring, SQL optimization and tuning using OEM grid, SQL Tuning
• Lead DBA responsible for all the databases in the Merchandising Portfolio
• Mentor team of engineers, and documents procedures for different DBA tasks, including connection to pluggable database, Transparent Database Encryption (Oracle TDE), password security standard
• Optimizing and tuning PostgreSQL databases, and configure the daily AUTOVACUUM and ANALYZE in cron
• Migrated Oracle database to PostgreSQL using Ora2PG tool.
• Quarterly verify user’s privileges on all the SQL Server, Oracle and PostgreSQL databases.
• Migrated Real Application Cluster (RAC) from 11g to 12c environment
• Written Chef cookbooks to automate database build and patches
• Primarily used Ruby to write GIT applications and Chef Recipes, Integrated GIT into Jenkins to automate the code check-out process.
• Decommissioned Datadog agent on multiple servers using Ansible and replace the Datadog with Sensu
• Lead the database migration from standard RAC platform to EXADATA machine.
• Database refresh using RMAN duplicate and schema refresh using data dump from production to lower environment databases.
• Implement Oracle Transparent Data Encryption on column and tablespace levels.
• Worked closely with the system administrators to tune the operating systems, configure the disk storage layouts, forecast disk space utilization, configure the backup and recovery system, and troubleshoot database system issues.

Confidential, Minneapolis

Oracle DBA

Responsibilities:

• Support and manage multi-terabyte databases in Oracle and SQL server database environments.
• Upgraded Oracle Golden Gate streams version 11.1 to 11.2 using ACFS on all Oracle RAC clusters in staging and production.
• Worked with Storage team on modernizing Sun legacy platforms, with upgrades to ZFS file systems, Solaris 10.
• Create PL/SQL Stored Procedures, Functions, Triggers and Packages to develop interfaces.
• Create and execute SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD
• Work in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Supported over 40 Oracle11g R1 (11.1.0.7) production, development, test & certification databases in Real Application Cluster environments on Dell hardware running Red Hat 5.x
• Upgraded several Oracle RAC systems (2 to 4 nodes) from 11.1.0.7 to 11.2.0.4.2 in staging and production environments.
• Troubleshooting experience with NAS and NFS Storage platform.
• Create/build/modify Ansible playbooks including automation scripts with Python and Bash.
• Production experience in large environments using configuration management tools Ansible and Chef
• Migrated databases to Oracle Exadata Database Machine for different clients.
• Deploying OEM 12c agents on many servers and configuring the agents on OMS.
• Worked with DW team for loading data to warehouse databases using different tools.

Confidential, Bloomington

Data Center Migration DBA

Responsibilities:

• Lead the technical aspects of the migrations program
• Responsible for technical deliverables for data quality and completeness of requirements generated from migrations database
• Use RMAN duplicate and DataGuard for database Migration
• Migrated RAC databases (6 Terabytes and more) to the new Data Center and Implemented the changes of host IP, VIP, SCAN addresses.
• Ensured Migrations best practice and technical guidelines, artifacts prescribed are adhered to in a timely manner; application flows, technical architecture, test plans and any other success driven artifact is completed.
• Built and enhanced the scripts for migrations, refreshes and RMAN backups
• Worked closely with project managers to ensure delivery of the project.
• Make sure the completeness of the Migrations Technical Planning and Execution.

Environment: IBM AIX Power 7, WebLogic, TOMCAT, ERP application, 11c, 12c, CommVault

Confidential, Minnetonka, MN

Sr. Oracle DBA

Responsibilities:

• Monitor the refreshes on DEV, Integration, SYSTEM Test databases, fix the issue and implement a permanent solution.
• Created database objects like tables, views, Stored procedures, Packages using Oracle Utilities like PL/SQL, SQL* Plus, Toad.
• Involved in database development by creating PL/SQL Query, Oracle PL/SQL Functions, Procedures, Triggers, Packages, Performance Tuning, Records and Collections.
• Built and implemented bash/shell scripts for our refresh databases, as well as enhancing the existing scripts.
• Implement and enforce database security based upon best practice, SOX regulations, and company policies
• Monitor and tune databases to meet the performance and availability requirements of on-line systems and multiple applications on a 3-node cluster database
• Use Shareplex for replicating data into several other databases in all the environments.
• Oracle DataGuard Physical Standby configuration, build and support including DataGuard Broker
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Provide support on all the stages of database implementation and/or database related deployments

Environment: Oracle 10g,11g SQL Developer, Toad, Windows XP, RHEL 6.x and Solaris 6.x, Shell Scripts, Shareplex, PL/SQL, OEM, RMAN, ETL, Data Warehouse,11G,12c OEM, Microsoft SQL Server 2008,2012, MySQL

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Oracle Installations (Application Server, Client, Database Server) & Patching
• Extensively worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and Data Warehouse Environment
• Creation of database indexes on certain tables to improve query performance after thoroughly testing the same in the development environment
• OS Monitoring of CPU Utilization and its performance with tools like (TOP, GLANCE, VMSTAT, IOSTAT, SAR, PRSTAT, etc.)
• Security Maintenance, applying oracle security patches as & when needed
• Writing shell scripts to automate daily backup, automate schema refresh across servers
• Troubleshooting database problems faced by the application developers

Confidential, Schaumburg, IL

ORACLE DBA

Responsibilities:

• Planned and performed RMAN backups and recovery procedures
• Setup configuration and management of standby databases using DataGuard and performed Failover tests for High availability
• Write / modified UNIX scripts to automate backups and database monitoring
• Wrote Shell Script to create DB objects for Products and testing scripts
• Planned and implemented hot, cold and export backups. Reviewing backup logs for irregular occurrences
• Ensured data availability as per the service level agreement

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Configured ASM for shared storage, installed ASM libraries
• Migrated single instance databases to RAC database using RMAN
• Developed SQL and shell scripts for database monitoring
• Schema management, space management as per the requirements of team
• Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Cloning production databases for development, test environment with RMAN duplicate feature

Confidential, GA

Jr. Oracle DBA

Responsibilities:

• Recommended changes to increase efficiency minimize operating expense or improve accuracy and timeliness of application systems
• Capacity planning, capacity monitoring and management
• Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace and TKPROF

Environment: Oracle 10g, 9i, Toad, RMAN, Remedy, WinScp, SQL*Loader, Windows 2003, RHEL 4.x