SUMMARY

• Expertise in Oracle 9i/10g/11gR1/11gR2/12c RAC on Linux and Solaris.
• Experience in leading dba team, Agile and Devops implementation, mentoring resources, resource planning, timelines, project meetings, deliverables and senior management status reports to ensure that all teh timelines are met in most efficient way.
• Experience in deployment, management and security of Oracle, MySQL, Memsql and AWS RDS, Redshift, Amazon Aurora database on Amazon AWS cloud.
• Worked on database migration from on premise to AWS cloud, Amazon Aurora to reduce licensing cost and enable horizontal scaling and improve performance.
• Worked on migrating multi - terabyte data warehouse to Amazon Redshift cluster and improved DB performance by 2-3X.
• Migrated MySQL databases from on-premise to aws cloud on EC2 instance, RDS and Amazon Aurora.
• Configured Amazon Aurora cluster as per database load requirement.
• Used Sysbench to test teh performance of Aurora DB Cluster before migrating prod databases.
• Created Read Replicas to offload reporting/read only queries.
• Migrated on premise MySQL and RDS MySQL databases to Amazon Aurora.
• Installation, Configuration and Management of MySQL 5.5,5.6 and 5.7 on Linux.
• 3 Years’ experience on Sybase installation, upgrade, administration, patching, tuning and maintenance.
• Expertise in database and clusterware upgrade/patching for 9i, 10g, 11gR1, 11gR2 and 12c.
• Expertise in data replication using GlodenGate 10.4/11/12 and Sybase Replication Server.
• Expertise in Installation, upgrade, clustering, replication, monitoring, tuning, backup & recovery of Sql Server 2000/2005/2008/2012/2014 using Enterprise manager, Management Studio, Sql Server Agent, Query Analyzer, SQL Profiler, DTA, DBCC, BCP, SSIS, SSRS, DTS, TSQL, DMV & DMF.
• Worked extensively on Multi-terabyte OLTP and Data warehousing environments involving Oracle 8i/9i/10g/11g/12c, 12c In-Memory, RAC, RMAN, Dataguard, Streams, Sql Server, Sybase, DB2, Mysql and Informatica.
• Experience in supporting large client environments (200 + databases & up 50 TB).
• Knowledge of nosql databases Mongodb and Cassandra.
• 3 Years experience in Data warehouse design, development & maintenance using Informatica & Brio
• Worked with Fortune 50 clients Confidential, United Health Group, Agilent Technologies & Confidential .
• Experience as On-Call 24x7 production DBA and application/development DBA
• Installation, configuration, creation, patching, upgrade, migration and tuning of Oracle 8i/9i/10g/11g/11gr2/12c RAC on Solaris, HPUX, Red Hat Linux, SUSE Linux and Windows.
• Expertise in Database Performance tuning using V$/GV$ views, OEM, Grid Control 10g/11g/12c, STATSPACK, AWR, ASH, ADDM.
• Expertise in Sql Tuning using autotrace, explain plan, SQL Trace, SQLT, tkprof, SQL Tuning Advisor etc.
• Expertise in setup, maintenance of Oracle Streams, Standby databases and Data Guard.
• Experience in Sun Solaris, Solaris Zones, Vmware, Oracle VM, Oracle Enterprise Linux, Red Hat, Suse Linux Installation and Administration, using vmstat, cron, sar, top, ps, watch, free, yast, iostat, netstat to monitor teh unix os.
• Managing DBA team, work requests, faults tickets and alerts for enterprise databases, prioritizing and ensuring that they are handled and managed properly by team members.
• Developed Unix Shell & Perl scripts to automate wide range of tasks including administration, backup, and monitor and troubleshoot database issues.
• Experience in creating Procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Logical & Physical Designing of Databases. Data modeling using Erwin, Power Designer, Oracle 10g Designer, and TOAD Data modeler.
• Expertise in FACT Tables, Dimension Tables, Star Schema Modeling, OLTP, OLAP.
• Expertise in SQL Server Clustering, log shipping & mirroring to support high availability.
• Used Sql Server Agent to configure database jobs & alerts to perform routine maintenance tasks.
• Experience in SR, CR process, build planning & deployment, Rational Clearcase, Clearquest & CVS.
• Developed project proposals, statements of work, and project plans.
• Installation, configuration, upgrade and tuning of Sybase 11/12/15.
• Knowledge of Hadoop, Hive, Pig Installation, Configuration and administration using Cloudera distribution.
• Engaged with clients in architecture design, analysis, project management, and solution delivery.
• Ability to work in-groups as well as independently with minimum supervision.
• Initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

• Oracle 8i/9i/10g/11g/11gR2/12c
• Real Application Clusters (RAC)
• Exadata
• Oracle In-Memory Database
• SQL Server Mirroring
• Log Shipping
• Clustering
• Replication
• TSQL
• Sql server Agent
• DTA
• BCP
• Sybase 11/12/15
• Sybase Replication
• RMAN
• Netapp
• Snapmirror
• Snaprestore
• VERITAS NetBackup
• Commvault
• EMC Legato Networker
• Tivoli storage manager
• EMC Timefinder
• EMC Symmetrix
• EMC SnapView
• EMC Clarion
• BCV Backup
• Disaster Recovery Solutions
• Standby Database & Data guard
• Distributed Databases
• ER Modeling
• UML
• Visio
• Database Design using ERWIN 4.2 / 7.1
• Oracle 10g Designer
• Power Designer 11
• Data Modeling
• Data warehousing/Data Marts
• AWS Cloud
• Oracle Cloud
• Hadoop
• Hive
• Cloudera
• GlodenGate
• GlodenGate Director
• Database Tuning
• SQL Tuning
• Unix Shell & PERL Scripting
• SQL & PL/SQL
• Oracle Streams/Change Data Capture
• MongoDB
• Cassandra
• Unix
• Solaris 8/9
• HPUX 11
• IBM AIX
• Red Hat Linux 3.0/ 4.0
• SUSE Linux 8/9/10
• TOAD
• SQL Navigator
• Quest Spotlight
• Foglight
• Quest Big Brother
• DBArtisan & Performance Center
• BMC-Patrol
• BMC Control-M
• Redwood
• Database Control
• Grid Control 11g
• 12c
• Mainframe
• z/os
• IMS
• DB2
• Rational Clear Case
• Visual Source Safe
• ETL
• Informatica 7.1/8.1
• Hyperion BRIO
• Oracle 11i/12
• OAM
• AD Patch
• Opatch
• Confluence
• JIRA
• GIT

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Senior DBA

Responsibilities:

• Installation of Oracle 12c/11g2 Grid Infrastructure/Clusterware for 2 & 3 Node RAC on Red Hat Linux, SCAN configuration.
• Database upgrade from 9i, 10g to 11g and 11gR2, 12c using DBUA and Manual upgrade.
• Participate in meetings with senior management to assist in formation of teh technology roadmap, manage vendor relationships and contracts.
• Tested Aurora Instance Crash, Replica Failure, Disk failure and Disk congestion to create a highly available and fault tolerant Aurora Cluster.
• Used LOAD from S3 and Percona backup tool to migrate on premise MySQL database to Amazon Aurora.
• Performed manual conversion of myisam tables to innodb before starting Aurora migration to reduce migration time and space requirement.
• Used aws cli and shell scripts to manage RDS instances and related aws resources.
• Worked with Developers to external data into Aurora DB using Load Data from S3 feature.
• Worked with Tableau developers to direct teh reporting traffic to Read Replicas to reduce DB load.
• Setup monitoring for Aurora Cluster using Cloudwatch enhanced monitoring and RDS events.
• Setup replication between on-premise MySQL and Aurora database.
• Monitoring Replication lag between primary and read replicas, determining teh root cause and take appropriate action.
• Configured maintenance window and making sure that Security, OS and DB patches are tested and applied on time to reduce security vulnerabilities.
• Implemented best practices for Security and RDS for database deployments.
• Created VPC, DB Security group, IAM Users, Enabled Encryption to harden DB access.
• Upgrading DB engine in dev/test/qa and working with Application team to fully test new DB engine before upgrading production.
• Used reserved DB instances to reduce aws billing.
• Selecting appropriate DB instance type for optimal database performance.
• Use aurora clone and restore snapshots to create production copies to troubleshoot db issues and do performance tests.
• Closely work with Business and Application teams to understand level, value, conformance and expectations and accordingly implement database solutions to achieve best quality of service in terms of performance and availability.
• Manage Database Service Operations in terms of Event Management, Incident Management, Request Fulfillment, Problem Management and Access Management.
• Project Management for critical Database implementations in terms of resource planning, timelines, project meetings, deliverables and senior management status reports to ensure that all timelines are met.
• Tuned Mysql Config parameters like log buffer, Innodb buffer to optimize performance.
• Enabled Mysql Slow query log and used mysqldumpslow to analyze teh log.
• Tuned slow queries by adding missing indexes, selecting dbengine, partitioning tables etc.
• Used Mysql workbench and mysql command line to perform day to day administration tasks.
• Used Explain Plan, Analyze and Optimize to tune Mysql queries.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance.
• Configured MySQL Master-Slave Replication, Identifying and resolving replication issues.
• Managing RAC databases, instances, services, listeners etc using SRVCTL.
• Worked on Oracle and Memsql dev/qa/test database deployment on Amazon AWS Cloud. Knowledge of EC2, VPC, IAM, RDS and Oracle Cloud.
• Maintaining/enhancing physical and logical model of existing and new projects using ERWIN.
• Creating/Maintaining tables, partition, indexes, views, package, procedures, functions, triggers, materialized view etc.
• Used Enterprise Manager & Management Studio to install, upgrade, monitor, tune, backup/recover SQL Server 2008/2012/2014 databases.
• Used Server side Tracing, Sql Server Profiler to identify slow running sqls, blocks and deadlocks.
• Used Sql Server Agent to configure database jobs & alerts to monitor databases and perform routine maintenance tasks.
• Monitoring Sybase to Oracle replication involving Sybase Replication Server, DCO.
• Starting, stopping, tracing Sybase Rep Server, DCO etc during planned maintenance.
• Sybase installation, reorgs, blocking, user management, Space Management, dbcc, tuning and monitoring using DBA Artesian and Sybase Central.
• Performing Sybase backups/restores/refreshes using dump & load and BCP.
• Installation of GlodenGate, configuration of Manager, Extract, Replicat etc on RedHat Linux.
• Monitoring and Troubleshooting Glodengate Environments.
• Installation of GlodenGate Director and Client to manage Source and Targets.
• BCP Planning and Disaster Recovery testing on quarterly basis.
• Configuring SCAN Listeners, listeners.ora, tnsnames.ora, spfile, pfile for RAC environment.
• Installation of 10g/11g/12c/13c Grid Control, Weblogic Server, Management server, Grid Control Agent.
• Configuration, Management and Tuning of Oracle 12c In-Memory database.
• Used Parallel execution to speed queries in Exadata database.
• Tuned many queries in Exadata databases by analyzing exadata/non-exadata wait events.
• Used exadata Hybrid Columnar compression to achieve 5-10x compression and hence reducing storage cost and improve IO performance.
• Used smart flash cache to pin frequently used objects and hence significantly improving db performance.
• SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
• Monitoring and Tuning Exadata using EM12c
• Used Smart Scan, Cell offload, HCC, Flash Cache along with dbms sqltune, AWR, and v$ views to monitor and tune Exadata Database.
• Monitoring Storage Cells using cellcli and dcli commands.
• Generating and reviewing exachk to validate Exadata components.
• Loading bulk data from external sources to Redshift using from Amazon S3 COPY feature.
• Designed Redshift Tables by selecting proper Distribution and Sort Key for optimal performance.
• Monitoring and Tuning long running queries.
• Finding Redshift tables that have missing statistics and running Analyze command on scheduled and on demand basis.
• Running Vacuum command to Reorg & Resort tables.
• Configured and used Redshift utilities and admin views to troubleshoot and optimize database issues/performance.
• Analyzing Compression encoding for columns and selecting teh best Compression to reduce storage space and improve performance.
• Automated ADDM and AWR report generation to analyze last week DB performance.
• Worked with oracle support to fix bugs and applied patchsets and one off patches accordingly.
• Automated Datapump Export/Import using shell scripting for faster monthly refresh of Dev, test, QA and UAT databases.
• Multi terabyte Dev and QA database backup, refresh using Netapp snapshot & snapmirror.
• Used RMAN along with Veritas netbackup for database backups and recovery.
• Worked with SA to create DR databases using Netapp Snapmirror.
• Used TKPROF,10046 session tracing to analyze application performance issue.
• Used logminer to analyze teh transaction and pin point teh time of occurrence.
• Configuration, Monitoring and Maintenance of physical and logical standby databases.
• Creating & Managing tables, indexes, views, synonyms, users, roles, MVs, procedures etc.
• Created Shell scripts, cronjobs for RMAN backup, Archive Sweep, File system monitoring and alert, Tablespace monitoring and alert, Unusable Indexes, Gathering Schema/Database stats, Long running queries notification etc.
• Tuned Sqls using Sql Profiles, Sql Tuning advisor, ADDM Advisor, AWR, ASH Reports, Gather Stats, tkprof, SQLT, explain plan, autotrace, hints, indexes, histogram, Sql rewriting,
• Database monitoring, tuning and maintenance using Grid Control, Toad, DBA Artesian.
• Created shell scripts to automatically grant select privs on new objects to Read Only Roles.

Confidential - Torrance, CA

Lead DBA and Database Architect

Responsibilities:

• Lead a team of dba’s directing them to deliver quality results assuring client satisfaction.
• Review, POC and propose new database features that will improve database performance.
• Review and improve operations policies and procedures to reduce operational resources.
• Manage DB resource allocation for teh Software Engineering Teams.
• Develop and maintain standard operational procedures.
• Centralize documentation for operations procedures, processes and run books.
• Collaborate with development managers and product managers to develop and deliver new products.
• Implemented knowledge sharing process to remove single point of contact within a team.
• Managing 3 node Oracle 9i RAC database for CMS-LINK application on HP-UX 11 with Service Guard and Veritas volume Manager.
• Managing 4 node 10g RAC database for TOMS application on HP-UX having Oracle CRS and ASM.
• Perform core database management tasks including software installation, database creation and configuration, database upgrades, patching, backup & recovery, space management, partition maintenance, and object reorganization.
• Adding/deleting nodes from cluster, reviewing CRS, CSS, EVM, OPROCD, alert.log & trace files to troubleshoot RAC issues, resolving node eviction issues.
• Monitoring and Tuning teh RAC Cluster Interconnect CR Block service time, gc wait events & statistics using ADDM, AWR, Statspack, GV$ views, OEM & GRID Control.
• Monitoring RAC specific oracle processes, Library Cache, Dictionary cache, Workload, Contention, GES and GCS.
• Used Quest Big brother, Foglight & Spotlight for 24x7 database & OS monitoring, creating custom alerts.
• Creating table, index, materialized view, outline, partition, Index organized table, procedure & trigger.
• Maintaining Physical & Logical Data models using Oracle 10g Designer.
• Used Commvault & RMAN for Configuring/Managing Media Manager, Backup Policy, Backup Schedule, Enterprise Backup jobs monitoring & reporting.
• Worked with teh EMC team for teh implementation of EMC and BCV Backup.
• Configuration and Management of Streams, Dataguard, Physical & Logical Standby database
• BCP Planning and Disaster Recovery testing on quarterly basis.
• Proactively monitoring teh health of Primary and Standby Database and making sure that teh Standby is in sync with Primary.
• Cloning of development and test databases from production using RMAN.
• Used Enterprise Manager & Management Studio to install, upgrade, cluster, replicate, monitor, backup & recover SQL Server 2000/2005/2008 databases.
• Used Sql Server Profiler to trace sessions, identify slow running sqls, blocks and deadlocks
• Upgrading Sql Server 2000 database for Warranty department to Sql Server 2008 in dev, test and prod.
• Implementing SQL Server 2008 replication, clustering, log shipping & mirroring to support HA.
• Used Sql Server Agent to configure database jobs & alerts to perform routine maintenance tasks.
• Proactive performance monitoring, tuning & capacity planning for future database growth.
• Administer and maintain database security policies and procedures & compliance with SOX.
• Managing snapshots/ Materialized Views for distributed data access using DB Links, Datadirect for Sql Server and Transparent Gateways for DB2.
• Developed Unix shell scripts and SQL scripts to carry out routine checks on databases.
• Used UNIX commands like free, top, sar, vmstat, ps and watch to monitor teh OS performance.
• Tuned Sqls using tkprof, explain plan, autotrace, hints, indexes, histogram, outline, Sql rewriting.

Confidential, Torrance, CA

Database Architect /DBA

Responsibilities

• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation
• Participate in teh development of project plans and contribute effectively to planning & control.
• Capacity planning including allocating system storage, plan future storage requirements.
• Map new business requirements to enhancements existing database models and applications.
• Using ERWIN for Creating and managing teh logical and physical Data Models.
• Validate Logical Data Model (LDM) against teh Functional Specifications.
• Work with BA’s, Architect, and Senior Developer to track down, research, and define all unknown data elements from teh Functional Specifications and finalize their sources.
• Help teh Architect, Senior Developer, Testers to create Data Mappings for Application Design.
• Installations of Oracle Clusterware, ASM, 10g RAC, DB creation, TAF, RMAN on SUSE Linux 10.
• Installation of GlodenGate Server, Director, Veridata and Veridata agents on on Suse Linux.
• Configuration of Manager process, Extract & Replicat, Filter, Map, Initial Load, DDL syncronization.
• Monitoring/Validating replication using command line, GlodenGate Director and Veridata.
• Performance and load testing, used AWR, ADDM, Sql tuning advisor to tune sqls and database.
• Used Veritas Netbackup & RMAN to implement Incremental & Incrementally Updated Backup.
• Documenting teh disaster recovery policies, simulating teh various recovery scenarios using RMAN
• Creation of Logical Standby database, monitoring teh health of standby database.
• Created DDL & DML scripts to deploy PRS database in Dev, Test, QA and PROD environment.
• Writing teh SQLLOADER scripts to load teh external files into teh Oracle Database.
• Created complex PL/SQL Procedures & functions for matching Claims with teh Part Requests.
• Created tables, indexes, triggers, views, dblinks, materialized views, partitions.
• Regular communication to management regarding project's status, potential risks, concerns & needs.
• Coordinate with technical project managers, PL/SQL developers, and DBA Team to ensure database performance and reliability.

Confidential - Salt Lake City, UT

Responsibilities:

• Perform database installations, upgrades, patching and migrations for 9i and 10g databases.
• Monitoring enterprise database performance & availability using Quest Spotlight, Foglight, STATSPACK, AWR and ADDM.
• Oracle 10g Installation, database creation, migrating oracle 9i to oracle 10g.
• Develop, test & document database backup & recovery procedures using RMAN & Netbackup.
• Used AD utilities for installing, upgrading, maintaining, and patching teh Oracle 11i systems.
• Used Oradebug, oswatcher, racdiag, gv$ views, RDA and AWR to monitor performance and configuration of RAC cluster.
• Working with Oracle support to resolve ORA-600 errors, reviewing teh OS message file, CRS Log and Oprocd log to resolve RAC node eviction issues.
• Application tuning by identifying TOP SQL and fixing them using indexes, Histograms, SQL Hints.
• Using TOAD to manage tables, indexes, Mviews, Partitions, procedures, functions & triggers.
• Enabled Flashback Database to wind teh entire database backward in time, reversing teh effects of unwanted database changes within a given time window.
• Installation, upgrade, clustering, mirroring, replication & tuning of SQL Server 2000/2005 Databases.
• Used SQL Profiler and Database Engine Tuning Advisor for troubleshooting, monitoring and optimization of SQL Server and SQL code
• Used SQL Server Agent to Create alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
• Used BCP & SSIS to export and import data.
• Using DBCC checkdb, checkalloc, checkcatalog to maintain database consistency and integrity.
• Performing disaster recovery testing in test environment.
• Create & Manage users, tables, indexes, views, partitions, procedures, functions, cursor & triggers.
• Used dbcc traceon, set showplan, query analyzer, Index tuning wizard to analyze slow running sqls and take corrective action.

Confidential, Springs

Lead DBA

Responsibilities:

• Administration and Tuning of GDW data warehouse Oracle 9i database of 5 Terabyte Size.
• Install, patch & clone teh Oracle Applications database and file system for Everest & PI.
• Validate and compile APPS schemas, recreate grants and synonyms for APPS schemas.
• Maintain, convert to Multiple Reporting Currencies, Relink Applications programs, generate Forms, Report & message Files.
• Manage Admin server, Forms server, Web server and Concurrent Manager server
• Used AD Controller utility to check status of AutoUpgrade, AutoPatch & AD Administration workers.
• Monitoring of Alerts and remediation of incidents, Closure of tickets in a timely manner
• Utilizing tools (STATSPACK, HP OVPM) to identify teh database and operating system bottleneck.
• Installation of Oracle 10g on test & prod environment, implementing new features, upgrading teh current Oracle 9i database to Oracle 10g.
• Creating table, indexes, materialized views, partitions, Index organized tables, procedures & triggers.
• Database tuning by adjusting teh SGA/PGA, add/modify indexes, Histograms, analyze tables and indexes
• Identifying Informatica sessions that are slow and tuning them by adding sql hints and Outlines.
• ETL Load Process monitoring using Informatica workflow monitor.
• Extensively involved in performance tuning of BRIO reports and Data Models.
• Partitioning very big tables using Range Partition on Month to improve performance.
• Created Shell Scripts to check instance & listener availability, check alert.log for errors, analyze database, tables & Indexes, check tablespace usage and alert teh DBA.
• Worked on teh Extracts optimization so that teh extracts from teh Oracle APPS and SAP runs fast.
• Implemented Incremental Backup strategy using RMAN.
• Performed incomplete recovery using RMAN with in SLA when an importat tables was truncated through Informatica session.
• Successfully performed cloning of development and testing databases from production using RMAN.
• Used VERITAS Netbackup for Configuring/Managing Media Manager, NetBackup Policy & Schedule.
• Worked with teh EMC team for teh implementation of EMC and BCV Backup.
• Configuration and Management of Oracle DATAGUARD, proactively monitoring teh health of Primary and StandBy Database and making sure that teh Standby is in sync with Primary Database.
• Administered database security, created users, granted/revoked roles, privileges, managed data files, rollback segments, extents, segments, re-indexing
• Implementation of a change management process & SOX for database modifications.
• Managing teh logical, conceptual and physical models, designing teh Star Schema Fact & Dimensions tables using Sybase Powerdesigner 11.

Confidential - Dayton, OH

DBA

Responsibilities:

• Support 24x7 databases ensuring their availability, performance, security, and operational efficiency.
• Perform core database management tasks including software installation, database creation and configuration, database upgrades, patching, backup and recovery, space management, partition maintenance, object reorganization, Sql and database tuning.
• Installations, performance monitoring, tuning, backups, recoveries, and sql tuning of SQL Server 2000 databases using Enterprise manager, Query Analyzer, Sql Profiler, DBCC, System Monitor, BCP, DTS & Backup & Recovery wizard and TSQL.
• Analyzing teh Top SQLs, Top Wait events, Latches, Locks and Top datafiles.
• Used BMC patrol for 24X7 monitoring of Confidential enterprise databases.
• Used commands like free, top, sar, vmstat, ps and watch to monitor teh OS performance.
• Designed backup and recovery plan, implemented with RMAN and Veritas Netbackup as centralized backup solution, performed disaster recovery test for production database.
• Managing Physical & logical Standby database, monitoring teh health of standby database.
• Created, scheduled db maintenance tasks, such as tables/indexes stats, index rebuild, materialized views refresh, db exports and other day-to-day tasks.
• Created table, index, materialized view, outline, partition, Index organized table, procedure & trigger.
• Migrating Sql server 2000 databases to Oracle 9i using OMWB.
• Identified teh key area where performance is a problem using OEM packs and tuned them.
• Performing SQL statement tuning (TKPROF, Explain Plan & AUTOTRACE)
• Configuring Physical Standby database using Dataguard, setting teh protection mode, Simulation of Failover and Switchover for Disaster recovery testing.