PROFILE:

Over ten years as DBA/Architect in Fortune 50 companies. 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, Golden Gate.

EXPERIENCE SUMMARY:

• 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 that 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 than 400 databases overall on various UNIX platforms - Solaris, HP, AIX/Linux/NT.
• Implemented more than 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, Golden 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.

SKILL:

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 Golden 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 I/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 that 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 than 30 Oracle 11g/12c RAC Cluster/database installs, delivering go-live production and beyond support
• Design high availability and replication solutions using Golden Gate, including data center switchovers, golden 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 Golden 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 than 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 help 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.

Confidential, San Francisco, CA

Production DBA

Responsibilities:

• 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, I/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