SUMMARY:

• Working as a cloud/db architect, have over 17 years of IT experience working in Confidential 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.
• Cloud Architect - AWS/Microsoft Azure
• Architecture and design of cloud, cloud resources, VPC, subnets, and access.
• Data Migration design, solutioning, and implementation from on-premise to cloud (relational and Hadoop)
• Working on EC2 provisioning, S3 bucket management(AWS), ADLS/ADF (Azure) and various Azure and AWS components
• Scripting using AWS CLI, Ansible plays and shell scripting.
• Cloud Architecture for no-sql databases like Couchbase, Cassandra.
• Data Encryption and Masking
• Performance tuning for Cloud RDS databases (oracle,mysql,sql server etc) and NoSQL
• 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 Confidential installations.
• RDBMS and Nosql database modeling.
• Installation of Oracle Confidential and non- Confidential 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.

SKILLS:

RDBMS: AWS RDS Aurora/Postgres/MYSQL, 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 P acks, Oracle G olden Gate, S hareplex, Toad, DBA S tudio, SQL Lab, DB Artisan, SQL Navigator, BMC Patrol, S qlBackTrack

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

OS: SUN S olaris 10/8 2.6/2.5, AIX, R ed Hat 6.5/5.0/4.0/3.0 , l inux 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, B asic, C obol

Software/Other: Hadoop, NoSQL, AWS, MS Azure, RDS, 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, P owerdesigner, P owerbuilder, SQL Studio, Developer 2000, Forms/Reports, ODBC/JDBC, Brio

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Lead DBA/Architect

Responsibilities:

• Golden Gate replication setup, between Oracle Databases.
• Capacity Planning for NoSQL and Oracle DBs, backup, recovery for databases.
• Migrated databases to 12c Confidential and resolved post migration issues, DR Testing
• Reduced application migration downtime by implementing database restore points, GG
• Performance Tuning for Production Databases using v$ views, SQL baselines, tuning
• Standardize overall architecture around RDBMS and NoSQL DBs

Confidential, Austin, TX

Lead DBA/Architect

Responsibilities:

• Cassandra and MongoDB Architecture, Sizing, Performance Tuning and Data Modeling .
• Couchbase/MongoDB Architecture, Administration, Sizing, Upgrades
• Migrating data from various rdbms to Cassandra cluster, including refreshing Cassandra non-prod environments
• Hadoop and Datastax Cassandra Administration, including resizing, backups, monitoring and on-call support
• Automation of cluster setup and deployments using Ansible
• Cloud Architecture and Data Security and Standards related to NoSQL and Hadoop
• Migrate 500+ oracle databases to new data center using Data Guard
• Install, clone, patching and maintain Oracle 12c grid infrastructure and databases
• Automate migration of 11g databases to 12c using DBUA
• AWS Cloud, RDS, Postgres, MySQL, Aurora, Redshift DB management

Confidential, San Bruno, CA

Lead DBA/Architect

Responsibilities:

• Architecture, sizing and implementation for Cassandra Clusters on Cloud and bare-metal including install, configure and upgrade DSE v3/4/5/6 and OpsCenter v 4.x/5.x/6.x.
• Create and Support Hortonworks Hadoop Clusters, including Security(using Apache Ranger, Atlas).
• Analysis, design and implementation of Map Reduce, Spark/Scala, Hive programs for ETL and data ingestion.
• Cassandra & Hadoop Cluster administration.
• Cassandra clusters range from 20 to 128 nodes across multiple Data Centers.
• Fine tuning Cassandra & Hadoop performance related parameters.
• Troubleshoot Cassandra read/write latency issues using nodetool tablestats/tpstats/tablehistograms, thread dumps.
• Configure backup, alerts, repairs and monitoring of Cassandra clusters, in conjunction with Nagios/Command Center.
• Cassandra and Hive Data Modeling, develop best practices.
• 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 Confidential 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 Confidential 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, Confidential AWR, ASH reports.

Confidential, San Francisco, CA

Sr. Oracle DBA

Responsibilities:

• Built 2-node Confidential 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

Sr. Oracle DBA

Responsibilities:

• Setup 3 2-node 10g Confidential 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 Confidential using Sistina GFS on Linux/Oracle 9i and Data Guard with Confidential .
• Implemented a 8 node Confidential 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 Confidential setup and Confidential 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