SUMMARY:

• Over 28 years of experience, including 23 years as Leading/Senior DBA in production, staging/test and development environments.
• Working as DBA for 23 years in Oracle, 5 years in MySQL, 1 year in each Cassandra, Couchbase, MongoDB, MS SQL Server, PostgreSQL and as Big Data Hadoop Admin/Dev.
• Working experience in companies like: SaaS, E - commerce, Enterprise Solution, Software, Hardware, Telecom & Wireless, Engineering & Construction, Manufacturing, Security.
• Ensure database systems operate efficiently and securely with high volume and very large OLTP and DSS databases.
• Well and in-depth experience in management/administration, maintenance, security, auditing, high availability, diagnostic & tuning, backup & recovery, disaster recovery and support of very large volume and multiple databases in production, development and staging/test environments on 24x7x365 basis.
• In-depth experience in database design, installation, upgrade, patches, migration, cloning, partitioning, data archival, data load, backup & recovery by RMAN/OEM/scripts.
• Broad experience in fail-over/high availability solutions like Oracle Replication like Golden Gate, Advanced/Multi Master, Streams, Data Guard (Physical and Logical), Active Data Guard, Snapshot Standby, RAC (Real Application Cluster), ASM, OEM, ODA, DR Site, MySQL Replication, SQL Server Replication/HA, NoSQL Cassandra/ Couchbase/Mongodb Replication.
• In-depth experience in performance tuning of database: memory, I/O, CPU, contention, locking, waits, SQL, PL/SQL, applications, Oracle Grid Control/OEM, OMS, AWR, ADDM, ASH, SPA, Explain plan, Tkprof, Sqlt, Gather Stats, Histograms, RAT, Scripts, Cron jobs,
• Quest/Dell Foglight, Performance Analysis, SQL Optimizer, Idera, Splunk, ExtraHop, HAProxy, Zabbix, Solar Winds, Nagios Alert, Cacti, proactive database maintenance.
• Database SOX compliant, auditing, OS and Apps baseline, security, profiles, roles, password management, encryption, wallet, etc.
• Strong experience in Oracle databases on Linux, UNIX, Windows and VM environments.
• Experience in administration and support of systems, storage, applications and software development and as Oracle Core/Apps DBA.
• Installation and setting up of Hadoop2 on multiple nodes cluster.
• Installation/setting/administration of NoSQL like Cassandra, Couchbase, Mongodb, Cluster.
• Database Architecture Diagram for Oracle, MySQL, SQL Server, No SQL, etc.
• Database Capacity Matrix for Oracle, MySQL, SQL Server, NoSQL.
• Mentoring and managing/leading highly motivated DBA team members and providing technical leadership with solid hands-on experience.
• OPS on call/Pager duty for Data Center on rotation basis.
• Strong communication and analytical skills with very good experience in problem solving.

TECHNICAL SKILLS:

Oracle (RDBMS): Oracle Enterprise/Standard/Express Edition 12c, Oracle 12c Container/ Pluggable, 11g Rel1/2, 10g Rel1/2, 9i, 8i/8/7/6, Oracle Grid/Database Control, Oracle Enterprise Manager 12c/10g /9i, Oracle Diagnostics/ Tuning/Change Management Packs, AWR, ADDM, ASH, SQLT, SPA, Explain plan, Tkprof, Outlines, Oracle Golden Gate Replication, Multi Master Replication, Oracle Streams, Oracle RAC, Oracle ASM, Oracle Data Guard/Active Data Guard, Broker, RMAN, RAT, SQL, PL/SQL, SQLJ, Forms/Reports/Discoverer/ Portal, Oracle Application Server, Oracle Financials R12/R11, ODI, Designer/Developer

MySQL (RDBMS): MySQL 5.7, MySQL Workbench 6.1, Toad for MySQL

PostgreSQL (RDBMS): PostgreSQL 8.4, PgAdminIII

SQL Server (RDBMS): MS SQL Server 2012/2008/7.0/6.5 Enterprise Edition, SQL Safe, Idera

NoSQL: Cassandra 3.x, CQL, Couchbase 4.x/3.x, N1QL, XDCR, Solr, MongoDB 2.x, Robomongo

Hadoop (Big Data): ClouderaCDH4, VM4.401-vmware, Hortonworks, Hadoop 1/2, HDFS, Hive, HBase, MapReduce, Sqoop, Flume, Apache Oozie, ZooKeeper, YARN

Scripts: SQL Script, PL/SQL, Unix/Linux Shell script, Perl script, MS NT DOS

S/W and Tools: SQL Developer 4.x, Quest Foglight 5.6.x, Performance Analysis 7, SQL Optimizer 8.x, Toad 12/11, Pentaho BI/ETL, Brio 6.x, ‘R’, BSCS 9X, C++ 5.0, Unix C++ 4.2, MS VBasic 5.0, E/R Win, MS JDeveloper 3.0, Perl, Java JDK, JPA, Hibernate, Eclipse, Informatica, Mastersaf, Clear Case, Subversion, Remedy, Jira, Zen/Service Desk, Confluence, Reflection for Unix, Exceed on Demand, PuTTY, VNC, SecureCRT, KeePass, VPN, VIP Access

Server: AWS/IBM/Oracle Cloud based Servers, Sun T5-4, SunNetra-T12, Sun-T5240/Fire-T200/V2900/490/V445/V440, Sun Virtual server, Sun Ultra Enterprise-6000, Sun Sparc 20, ODA (Oracle Database Appliance) X3-2

Workstation: Sun Ultra Enterprise 10/5/2/1, Dell Workstation 170L/400/Optiplex, Digital Prioris HX 590DR/XL Server 5133, Compaq Deskpro XL 5133

Client: PC Lenovo, Apple Macbook, Dell Dimension, Vostro, Latitude, Digital Venturis, Compaq Deskpro, Datamini, Toshiba CDT, HP Pavilion

Operating System: Linux CentOS 7.x/6.x, Red Hat Enterprise Linux 7/6, Oracle Linux server 7.4, Ubuntu 10.04, Sun Solaris 2.11/2.10/2. x, HP-UX 11.0 /10.20, IBM AIX 4.x, MS Windows Server 2000/2012, Windows 10/8/7/XP/Others

Storage System: Network Optimized SSD, EBS, S3Storage, Sun StorageTek, NetApp Disk

Virtualization: VMware vSphere5

AWS: Amazon Cloud based - High Performance Computing Servers for Oracle, Couchbase, Cassandra, MySQL, AWS Management Console

IBM SoftLayer: IBM Cloud based High Performance Computing server for Oracle

Oracle Cloud: Oracle Cloud based High Performance Computing server for Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Brisbane, CA

Sr. DBA

Responsibilities:

• Oracle Golden Gate Replication: Setup, maintenance and monitoring of Oracle Golden Gate Replication in heterogeneous database environments with active-passive, active-active mode.Oracle Standby/Active Data Guard, Snapshot Standby: Setup, maintenance and monitoring of
• Standby /Active Data Guard, Snapshot Standby. Use data for BI/DWH reporting purpose.
• OEM 12c: Setup, maintenance and monitoring of OEM and Agents.
• Database and query tuning, Diagnostic/Tuning pack, AWR, ADDM, ASH, Sqlt, Explain plan,etc.
• Database Backup and Recovery, Disaster Recovery Strategies and Procedures:
• Database daily backup, weekly full backup at Primary/Standby, daily incremental backup.
• Database refresh, restore/recovery, schema refresh. Disaster recovery plan and its testing.
• Database Support for Software release:
• Database design, development, changes, deployment and support for Software/Apps releases.
• Database Security and Access:
• Database access rights, security, profiles, roles, password management, auditing, baselines.
• Database Installation and Patches:
• Installation and patches of Oracle database software 12c/11g/10g, database patches, security patches, OEM patches, etc.
• Database Upgrade and Migration: Database Upgrade and Migration from Oracle 11g to 12c.
• Pre-upgrade plan, post upgrade plan, gather stats, SQL execution plan, forcing plan, etc.
• Database Space Utilization: Management and tracking of space utilization of databases.
• Database Performance Tracking: Reviewing and tracking of database performance issues.
• MySQL:
• MySQL installation, setup, database creation, objects creation, backup/restore, security, active/passive replication, DR, monitoring, maintenance, support, etc without AWS & with AWS.
• NoSQL/Couchbase/Cassandra:
• Installation, setting up and administration of NoSQL: Couchbase, Cassandra and its Cluster, replication, XDCR, rebalancing, indexing, buckets, views, sharding, key spaces, compaction, nodetool, N1QL, CQL, Solr, etc.

Confidential, Mountain View, CA

Sr. DBA

Responsibilities:

• Setup, maintenance, monitoring of RAC on ODA with two nodes, standby/active data guard with nodes, standby DG at DR site with nodes, ASM, Snapshot Standby, DG Broker, OEM 12c.Database Diagnostics and Tuning:
• Database and query tuning by OEM 12c, Diagnostic/Tuning pack, AWR, ADDM, ASH, Sqlt, etc.
• Database Backup and Recovery Strategies and Procedures:
• Database weekly full backup, daily incremental backup, restore/recovery/refresh.
• Database Support for Software release:
• Database design, development, deployment and support for software/apps release.
• Database Security and Access:
• Database access rights, security, profiles, roles, password management, encryption, wallet, SOX, auditing and baselines.
• Database Installation and Patches:
• ODA/Database patches, OEM patches, etc.
• Database Space Utilization: Management and tracking of space utilization of databases.
• MySQL:
• MySQL installation, setup, database creation, objects creation, backup/restore, security, active/passive replication, DR, monitoring, maintenance, support, etc without AWS & with AWS.
• MS SQL Server:
• MS SQL server installation, cluster, high availability setup, database creation, objects creation, backup/restore, security, replication, DR, monitoring, maintenance, etc.
• Hadoop, NoSQL:
• Installation and setting up of Hadoop2 on multiple nodes cluster and also NoSQL like MongoDB, Couchbase, etc.

Confidential, Mountain View, CA

Sr. DBA

Responsibilities:

• Responsible for the following management/administration, availability, scalability, reliability, security, maintenance, support and business requirements activities for production, staging/test and development databases on 24x7x365 basis for Business Software Systems, Operations, Engineering, Customer Support and MIS/Data Warehouse departments of SaaS company.
• Reporting to CIO and mentoring and managing/leading highly motivated DBA team members and providing technical leadership with solid hands-on experience.
• Customer Care Support and Escalation: OPS on Call (on rotation basis) for any issue in Data Center, review and escalate the issue to the respective person and follow up, if it is database issue then assign to available/on call DBA including me and get problem resolution.
• Database Fail-over/High Availability Solutions:
• Oracle Data Guard/Active Data Guard: Installation and setting up of databases in Data Guard environment with different modes by physical/logical/ snapshot standby option, switchover, failover, convert physical database to snapshot standby & vice-versa.
• Oracle Golden Gate Replication: Installation and setting up of databases in heterogeneous data environments by GoldenGate replication option in Test environment.
• Database Migration/move: From Sun StorageTek Disk to NetApp Disk by using Data Guard method, making tertiary DB server and switchover to it as Primary and rebuild standby DB.
• Database Server Migration: From Sun E2900 server to Sun T5-4 server for Data Guard Standby DB by presenting disk/LUN in NetApp storage and switchover and make it Primary DB.
• Database Diagnostics and Tuning:
• Monitoring of database status and performance by Scripts, Cron jobs & Database/Grid Control/ OEM, Foglight/Performance Analysis Tool.
• Automatic generation of DB AWR reports (by cron job) which writes to centralized location.
• Centralized server for all cron jobs of all DB servers with failover/backup option.
• Tuning of database Performance like database Memory, I/O, CPU, Contention, Locking, Waits, SQL Tuning, PL/SQL application tuning, etc by using Scripts, Cron jobs and Tools: Database Grid Control, AWR reports, dbms stats, gather stats, analyze, statspack, packages/tools, SQL Performance Analyzer (SPA), ADDM, SQLT, Tkprof, outlines, Foglight, Performance Analysis, SQL Optimizer, Pro-active DB maintenance. Too deep/wide, high water mark index rebuild, gather stats, analyze, degree of parallelism. Analyze SQL execution plan for top query and forcing good plan by Sqlt option.
• Database Table and Index Partitioning and maintenance to enhance database performance.
• Partition split, exchange, drop, rebuild unusable partition index automated job. As pro-active maintenance rebuild global index of partition table with gather stats monthly or based on need.
• Database Backup and Recovery Strategies and Procedures:
• Centralized two locations for backup on NFS mounted disk which is accessible from all DB servers.
• Hot/Online backup by RMAN, catlogdb, Cold/Offline backup and Export/Export Data Pump backup by Scripts. Monitoring of database backup and maintaining the status of database backup logs. In Data Guard environment online backup by RMAN and catlogdb for Physical standby database.FRA (flashback recovery area) point-in-time database recovery by flashback.
• Database Recovery strategies and procedures. Recovery of database in case of database crash, CPU/memory crash, disk/media failure, block corruption, database server failure, disasters, etc.
• Database Cloning: Database refresh/cloning by RMAN backup, cold/hot backup, archived redo logs and from primary to physical/logical/snapshot standby database by RMAN, Scripts.
• Database Support for Software release:
• Database design, development and deployment. Planning for logical database and physical layout. Creation and maintenance of databases, tablespaces/datafiles, users, roles, schemas, tables, indexes, views, materialized views, synonyms, sequences, procedures, packages, functions, db links and other database objects.
• Database Security and Access: Establishing and maintaining database access rights, security, profiles, roles and assign privileges to roles/users. Resource allocation, user validation, password management, etc. through profiles. Database auditing and baselines.
• Data Archival/Purge: Data archival/purge procedures based on the requirements by triggers, scripts, cron jobs, ETL process, etc.
• Database Space Utilization: Management and tracking of space utilization of databases, tablespaces, tables, indexes and disk spaces by scripts, cron jobs, Grid/DB control, Foglight.
• Database Upgrade and Migration: Database Upgrade and Migration from Oracle 10g to 11g.
• Pre-upgrade plan, post upgrade plan, gather stats, SQL execution plan, forcing plan, etc.
• Database Installation and Patches: Installation and patches of Oracle database software 12c, 11g, 10g Rel 2.
• Materialized views for MIS/Datawarehouse - Business Intelligent Tools: Pentaho, Data Source, Microstrategy:
• Creation of views in primary database, creation of materialized views and refresh data daily in MIS/Datawarehouse as target database by scripts, cron jobs, ETL and reports.
• MySQL: Installation and setting up of MySQL binary software, creation of DB, tables, other objects, configuration file, backup & recovery by sqldump, replication with Active/Passive nodes, MySQL Workbench client setup to monitor/manage MySQL.
• MongoDB: Installation and setting up of MongoDB, mongos (Process), config-server (mongo instances), mongo-database (mongod instances) with 3 nodes - 1 primary and 2 replica and tomcat Apps. Robomongo client setup to monitor/manage mongodb.
• Foglight/Performance Analysis: Installation and setting up of Foglight Process, DB, Middleware and Repository servers, Performance Analysis client.
• Co-ordination with software developers, testers, production/ops, customer care and other team/personnel for different database issues and business requirements.

Confidential, Milpitas, CA

Sr. DBA

Responsibilities:

• Oracle Data Guard/Active Data Guard: Installation and setting up of databases in Data Guard environment by physical/logical/ snapshot standby option, switchover, failover.Oracle database RAC (Real Application Cluster) and Oracle ASM: Installation and setting up of databases in RAC environment on multiple nodes and administration.
• Oracle Database Advanced Symmetric Multi Master Replication/Streams: Installation and setting up of databases in a replicated environment by advanced symmetric multi master replication. Replicating data and file system from primary site to alternate site, switch over.
• Oracle Database Hot Standby Replication: Installation and setting up of databases in a Replicated environment by Hot standby option, activate hot standby database and open it.
• Oracle Golden Gate Replication: Installation and setting up of databases in heterogeneous data environments by GoldenGate replication option.
• Database Diagnostics and Tuning:
• Tuning of database Performance like database Memory, I/O, CPU - tuning, Contention tuning, Locking, SQL Tuning, PL/SQL application tuning, etc by using Scripts and Tools: Database Grid Control, AWR reports, dbms stats, statspack and other packages/tools, SQL Performance Analyzer (SPA), ADDM, ASH, Explain plan, Tkprof.
• Database Table and Index Partitioning and maintenance to enhance database performance.
• Monitoring of database status and performance by scripts and Database Control/Grid control.
• Database Backup and Recovery Strategies and Procedures:
• Hot/Online backup, Cold/Offline backup and Export/Export Data Pump backup from the Scripts and RMAN utility. Monitoring of database backup and maintaining status of backup logs. Database Recovery strategies and procedures. Recovery of database incase of database crash, block corruption, database server failure, disasters, etc.
• Database Cloning: Database refresh/cloning by RMAN backup, cold/hot backup, archived redo logs and from primary to physical/logical/snapshot standby database by RMAN, Scripts.
• Database Security and Access: Establishing and maintaining database access rights, security, profiles, roles and assign privileges to roles/users. Resource allocation, user validation, password management, etc. through profiles. Database auditing for SOX Compliant.
• Data Load and Conversion: Creating/populating data, Data load/ conversion from flat-file etc. to Oracle database by the tools: Stored procedure,Sql*loader, Perl.
• Data archival/deletion: Data archival procedures based on the requirements by triggers, ETL.
• Database Space Utilization: Management and tracking of space utilization of databases, tablespaces, tables, indexes and disk spaces. Oracle Advanced Compression.
• Database Upgrade and Migration: Database Upgrade and Migration from Oracle 9i/10g to 11g, from 8i/9i to 10g, from 7.3.4/8.0.5/8 i to 9i and from 7.3.4 to 8.0.5/8i/9i.
• Database Installation and Patches: Installation and patches of Oracle database software 11g, 10g Rel 2,1/9i/8i /8.0.x/7.3.x and also for PostgreSQL 8.4and MySQL 5.1 databases.
• Application Server and Business Intelligent Tools Installation and patches: Installation and patches of Oracle 11g/10g/9i Application Server,Web logic server,Forms 11g/10g/9.x, Reports 11g/10g/9.x, Discoverer 11g/10g/9.x, Portal 11g/10g/9.x, Oracle Financials R12.
• Mastersaf, ODI & Oracle Financials R12: Installation and setting up of Mastersaf application, ODI (Oracle Data Integrator), Oracle Financials R12 and interface for Taxation purpose.
• Planning and evaluating Oracle, PostgreSQL, MySQL database server hardware, database software, licenses. Database design, development, creation and maintenance.
• Support in S/w Development and maintenance in Forms/Reports 11g/10g/9.x, SQL, PL/SQL.
• Co-ordination with SOX Compliant Team to make the database SOX Compliant with different procedures, Database, UNIX, Applications baselines.
• Support and co-ordination with developers, QA, end-users, production team & other personnel.
• Mentoring DBAs: Managing and co-ordination with other DBAs.

Confidential, Santa Clara, CA

DBA Consultant

Responsibilities:

• Planning and evaluating Oracle database server hardware, Oracle database software.
• Database design and development. Planning for logical database and physical layout.
• Installation, upgrade and patches of Oracle database software.
• Creation and maintenance of databases, tablespaces/datafiles, users, schemas, DB objects.
• Database access rights, security, roles and assign privileges.
• Creating/populating data based on the requirement. Data conversion from flat-file to Oracle DB. Database Cloning: move/create database from existing database to new database.
• Database Migration from Oracle 7.3.4 to 8.0.5, from 8.0.4 to 8.0.5.
• Database Backup procedures: Hot/Online backup, Cold/Offline backup and Export backup. Monitoring of database backup. System backup.
• Database Recovery strategies and procedures. Recovery of database incase of DB crash, etc.
• Database Basic Replication: Installation and setting up of basic replication, master to snapshot
• Management of space utilization of databases, tablespaces, tables, indexes and disk spaces.
• Monitoring of database status and performance.
• Tuning of database Performance memory, I/O, Contention, Locking, SQL and PL/SQLTuning.
• Support and co-ordination with software developers, testers, end-users and other personnel.