SUMMARY

• Over ten years as DBA/Architect in Fortune 50 companies like Walmart eCommerce, Wells Fargo Bank, GAP. Designing 24/7 highly available solutions to meet SLA’s using cutting edge technologies ranging from Infrastructure, BigData, NoSql, RDBMS databases, Storage and backups layers.
• Strong lead DBA abilities working with E - commerce, Data Warehousing projects on a VLDB environment. Performed performance tuning on databases ranging from simple to complex environments, Backup and Recovery of databases, Database Clustering, implementing high availability solutions using Data Guard, Standby, Gloden Gate.
• Oracle DBA with ver 12c/11g/10g/9i/8i with OLTP and Data Warehousing experience.
• Installed, Configured and Administered Hortonworks HDP 2.x/ HDFS clusters.
• Implemented Hadoop Eco-system dat includes Pig, Hive,Hbase,Sqoop, Map reduce, Yarn, Zookeeper, Oozie, Flume.
• Installed and Configured Hadoop monitoring tools like Ganglia, Ambari, Cloudera Manager.
• Cassandra database administration.
• Supported more TEMPthan 400 databases overall on various UNIX platforms - Solaris, HP, AIX/Linux/NT.
• Implemented more TEMPthan 100 RAC installations.
• RDBMS and Nosql database modeling.
• Installation of Oracle RAC and non-RAC software on production and non-production systems in Oracle versions 10g/11g/12c.
• Created and administered databases in ASM and on Filesystems.
• Database cloning using RMAN, converting non-ASM to ASM for storage.
• Setup Replication using Data Guard/Standby, Gloden Gate/Shareplex.
• Setup both logical and physical standby databases, use sql apply.
• Extensive use of RMAN duplicate from active database, and other duplicate options.
• Participated in database upgrade projects - Oracle Upgrades from Oracle 10g to 11g/12c, 8i/9i to 10g. Also critical patches and other patch application.
• Provide Failover and Switchover for the replicating databases.
• Setup Enterprise Manager Grid Control and manage complete database, and other application servers using it.
• Data Warehouse creation, ETL using oracle tools and Business Objects.
• Performed Database Partitioning, and configured materialized views, and extensive use of SQL*loader and export and import datapump utilities.
• Expertise in Performance tuning using scripts(based on v$views), EM Grid Control and 3rd party tools.
• Job Scheduling using scheduler, cronjobs, autosys
• Troubleshooting application level issues using tkprof/explain plan, appropriate index creation, bitmap indexes, and at OS level using SAR, VMSTAT, IOSTAT, TOP etc
• Database Sizing, Capacity Planning and building Very Large and High Performance Databases.
• Mentoring DBAs and documentation of database standards and policies.

TECHNICAL SKILLS

RDBMS: ORACLE 12c/11g/10G/9.2/8, MYSQL4/5, Sybase 11.5, MS SQL Server 2014/2012/2005

DBA Tools: Oracle 12c/11g Grid, OEM, Oracle Packs, Oracle Gloden Gate, Shareplex, Toad, DBA Studio, SQL Lab, DB Artisan, SQL Navigator, BMC Patrol, SqlBackTrack

Hardware: M9K, DL580, SUN E4500, E6500, E10K, HP 9000, IBM RS 6000, IBM Blade Servers, Compaq Server

OS: SUN Solaris 10/8 2.6/2.5, AIX, Red Hat 6.5/5.0/4.0/3.0, linux x86, HP-UX 11.0, HP-Linux, SCO- Unix, Windows NT/2003, Novell

Languages: PL/SQL, TSQL, Unix Shell Scripting, PERL, C, C++, PRO*C, Basic, Cobol

Software/Other: AWS, MS Azure, RDS, Aurora, Hadoop, NoSQL, Couchbase, Apache/Datastax Cassandra, MongoDB, Hive, Spark, Pig, HBase, Erwin, SAP Business Objects Data Services, BI 4.x, SAP ECC 6 Basis, Quest me/Watch, Oracle 10/9iAS, HP-PPM, Apache Server, Veritas Netbackup, Autosys, Powerdesigner, Powerbuilder, SQL Studio, Developer 2000, Forms/Reports, ODBC/JDBC, Brio

PROFESSIONAL EXPERIENCE

Confidential, Burlington, MA

Lead DBA/Architect

Responsibilities:

• Architecture, sizing and implementation for Cassandra Clusters on Cloud (AWS/Openstack) including install, configure and upgrade DSE v3/4/5 (Cassandra v 1/2.x) and OpsCenter v 4.x/5.x.
• Create and Support Hortonworks Hadoop Clusters.
• Resize Cassandra & Hadoop Clusters.
• Typical Clusters range up to 64 nodes across multiple Data Centers.
• Fine tuning Cassandra & Hadoop related parameters.
• Troubleshoot Cassandra read/write latency issues using nodetool cfstats/tpstats/cfhistogram column-families.
• Configure backup, alerts, repairs and monitoring of Cassandra clusters, in conjunction with Nagios/Command Center.
• Create Keyspaces, Column families, working with application teams.
• Design and Implement access controls/security on DSE Cassandra clusters.
• Design, implementation and maintenance of multiple Hadoop/ Big Data, Infrastructure and clusters.
• Implemented Hadoop Eco-system dat includes Pig, Hive,Hbase,Sqoop, Map reduce, Yarn, Zookeeper, Oozie, Flume.
• Installed and Configured Hadoop monitoring tools like Ganglia, Nagios, Ambari, Cloudera Manager.
• Play key DBE role on architecture of new services for walmart ecommerce databases.
• More TEMPthan 30 Oracle 11g/12c RAC Cluster/database installs, delivering go-live production and beyond support
• Design high availability and replication solutions using Gloden Gate, including data center switchovers, gloden gate upgrades to ver 11.2 and 12c.
• Critical Site-facing production database support for walmart.com, inventory, asda.com (UK Groceries), samsclub.com databases
• Setup Active Data Guard databases, DB switchovers, using both manual and DG Broker.
• Administer Oracle Exadata X6-2 for Samsclub databases.
• Install and configure 12c OEM, agents using agentdeploy, monitor DBs, schedule jobs, integrate GG plug-in, and define thresholds.
• Oracle 12c GI and database upgrades including Gloden Gate
• Performance Tuning for Production Databases using v$ views, SPM/SQL baselines, tuning, Cloud Control/OEM.

Confidential, Albany, NY

Lead Oracle DBA

Responsibilities:

• Build more TEMPthan 20 11gR2 RAC clusters with ASM. The environment was AIX 5.3 and Linux.
• Setup Dataguard in Oracle 10g and 11g using rman and active standby 11g feature.
• Configure RMAN backups and restore other environments from production (DB Cloning). Also, configure OEM grid for monitoring and other dba tasks.
• Work with developers on database issues - connectivity, performance and monitoring. Also halp them in debugging app/db issues.
• Applying db changes, schema refreshes using datapump, and used sqlldr.
• Upgrade Oracle 9i to 11g and 10g to 11g. Apply CPU and other patches.
• Database size ranging upto 50 TB size.
• Extensively involved in Data Encryption using ASO/TDE.
• Worked on datawarehouse access strategies of large objects.
• Setup DBVault (database vault) by creating realms, command rules, policies and roles.
• Resolve Performance Issues in OLTP as well datawarehouse environments using ADDM, RAC AWR, ASH reports.

Confidential, San Francisco, CA

Sr. Oracle DBA

Responsibilities:

• Built 2-node RAC cluster on 11g
• Database Migration from 10.2.0.4 to 11.2.0.2.
• Database Cloning and replication setup using rman “active database” 11g option
• Maintaining and Tuning both OLTP and Data Warehouse databases - loading data to data warehouse, performance tuning for instance, SQL’s, star schema.
• Used Partition Exchange Loading, monitor parallel execution performance, materialized views, and compression on partitions to reduce storage needs.
• Configure and administration of Business Objects Data Services
• Ensured Databases are in compliance with HIPAA and SOX standards
• Change Deployment using HP-PPM tool

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

• Setup 3 2-node 10g RAC cluster databases, using ASM, OCFS2 on Linux-HP servers.
• Create 15 Oracle 9i and 10g databases, support prod (and non-prod) upgrade from 9i to 10g
• Setup data guard databases and perform failovers. In addition, setup Quest Shareplex replication for critical databases.
• OEM setup and configuration.
• Database tracing, database monitoring, OEM Setup, and RMAN backup configuration for oracle databases.
• Setting up DBVault (database vault), ASO and Encryption for Oracle
• Resolve Performance Issues in OLTP as well as data warehouse environments.
• Applying CPU patches, documentation - DBA cookbook, mentoring Junior DBAs.

Confidential, San Francisco, CA

Lead DBA

Responsibilities:

• Setup RAC using Sistina GFS on Linux/Oracle 9i and Data Guard with RAC. Implemented a 8 node RAC system, 4 databases, with Data Guard databases on 6 nodes. Use 10G Grid for monitoring the databases.
• Implemented Data Guard Databases - one set lag behind by 6 hours (for recovering from accidental drop of data/objects), one set with zero data divergence.
• Supporting production databases and as well as leading a team of 3 DBAs and 2 db developers.
• Schema management and comparison, performance tuning, backup and recovery.
• Setup high availability solutions like shareplex replication and standby databases.
• Installation of Oracle 8i, 9i on Sun and IBM-AIX servers and database creation.
• Trained in RAC setup and RAC tuning
• Implement backups using netbackup, sqlbacktrack and IBM’s TSM and custom-made perl hot backup scripts(including RMAN). Implemented backup for databases over 100GB using SAN solutions.
• Implement db monitoring(availability, tablespace monitoring, locking conflicts etc), using BMC Patrol, me/Watch and perl/shell scripts.
• Troubleshoot application to database performance issues using scripts based on system tables, tools like Precise/Insight and Precise/Indepth, Quest Foglight and Spotlight.
• Database design and programming, extensive use of oracle utilities like export/import, SQL*loader using direct/parallel mode.
• Created Datawarehouse database and partitioned Objects implemented parallel DML