SUMMARY

• Over 4 yrs. hands - on experience in managing Cassandra databases; 4 end-to-end projects, including design, architect, data-modelling, migration, tuning, security, deploy and manage, operational support
• Datastax Cassandra 3.4 - 5.x; 6-180 nodes, 2/3 DC, Vnode, Spark, Solr, AWS, Azure; install, upgrade, tuning, data modelling, support Cassandra databases and queries
• Production and development database support in a Global ecommerce and Cloud environments
• Infrastructure and database design, backup/recovery and performance tuning
• Worked as database engineer, architect, operations DBA at Walmart, Confidential, Ericsson/T-Mobile, MobileIron, Confidential, Confidential, Confidential, Confidential and Oracle
• Extensive hands-on scripting skills, including BASH, and PowerShell

TECHNICAL SKILLS

• Datastax Cassandra 3.x-5.x
• Spark
• Solr
• Apache Cassandra
• Python
• Oracle 9i 10g 11g 12c
• RAC
• Data Guard
• ASM
• AQ
• RMAN
• GlodenGate 10g 11g 12c
• Grid Control
• Veridata
• TDE
• Red Hat Linux
• AIX
• HP-UX
• Ubuntu

PROFESSIONAL EXPERIENCE

Cassandra Engineer/Architect

Confidential, San Francisco, CA

Responsibilities:

• Build Cassandra clusters using Chef for all tiers in AWS environment
• Analyze and tune data model Cassandra tables during DB2 to Cassandra migration process
• Updated and maintained Chef cookbooks for Cassandra
• Worked wif product teams to optimize reads for Cassandra resiliency and latency testing in pre-prod environment.

Confidential, Seattle, WA

Responsibilities:

• Build Cassandra clusters for all tiers, including OS and Network security rules
• Worked wif analysts to model Cassandra tables from business rules and enhance/optimize the existing tables
• Setup 256-bit encryption and TDE for Cassandra environments
• Worked wif QA to optimize Cassandra for Production using custom load testing tools.

Cassandra Engineer/Architect

Confidential, Austin, TX

Responsibilities:

• Add multiple datacenters to the existing production cluster
• Install and upgrade DSE Cassandra from 4.8 to 5.0
• Tune existing data model to optimize partition key
• Tune compaction strategy on existing tables
• Wrote Spark Scala/Python code to analyze data anomalies.
• Migrate Cassandra JVM from CMS to G1GC
• Setup and deployed TDE, and encryption for Cassandra
• Imported data from Oracle to Cassandra using Spark

Confidential, San Diego, CA

Responsibilities:

• Migrate 100+ node prod cluster to a new 100+ node Cassandra domain
• Upgrade DSE 4.7 to 4.8.x

Lead Cassandra Engineer/Architect

MobileIron, Mountain View, CA

Responsibilities:

• Migrate existing Cassandra implementation to Production ready environment
• Data modelling, tuning, migrate existing STCS to Date Tier Compaction Strategy

Confidential - Redmond, WA

Responsibilities:

• Upgraded 12 nodes * 2 DC production clusters from DSE 4.6.3 to 4.7.3
• Expanded 30 node, 2 DC cluster to 180 nodes, 3 DC cluster
• Created script to automate creation of C* nodes in Confidential Azure and Linux environments using Bash and Powershell
• Created script to automate Node Repair in the production environment
• Decommissioned and Added new nodes in pre-prod/prod environments
• Create OpsCenter HA in Active-Passive mode
• Create/maintain users, account management, roles, ACLs, Jump server, endpoints
• Maintain, tune, and support Spark jobs
• Extensively used JSTACK, JSTAT, JPS to analyze/diagnose JVM issues
• Tuned and optimized Cassandra queries, including compaction strategy.
• Upgraded 45 node cluster from 4.7.3 to 4.8
• Created BASH scripts to automate configure and build new Cassandra nodes.
• Ongoing Cassandra support, diagnose and tune issues related to JVM, IO, Consistency, and Mutation issues in production and non-prod environments

Oracle DBA/Architect

Confidential, Bellevue, WA

Responsibilities:

• Setup Oracle GlodenGate 12c for Geo-redundancy and Active/Active bi-directional replication
• Operational support of Production (30TB+) and Development databases
• Oracle GlodenGate upgrade, failover, switchover activity, and setup Veridata
• Support Cassandra clusters in production environment (daily feeds from Oracle databases)
• Setup Physical and Logical standby

Cassandra DBA

Confidential - San Bruno, CA

Responsibilities:

• Setup 54 node, 2 DC Cassandra clusters from ground up (OS, Storage, Kernel, DSE software, configuration)
• Support 6-12 nodes, 2 DC Cassandra production clusters; decommission nodes, add/replace nodes, manage backups, tune Cassandra databases, manage alerts via Opscenter, integration wif Nagios
• Upgrade Cassandra software across all tiers
• Optimized and tuned queries against Cassandra databases
• Migrate Cassandra clusters to VNODE
• Managed Cassandra cluster using Solr
• Automated C* installation process using BASH scripts
• Cassandra development and tuning support across all tiers for multiple applications.
• Install, support and tune Oracle 11g RAC databases

Oracle Database consultant

Confidential - Foster City, CA

Responsibilities:

• Worked on Data Center Migration project involving 25TB legacy database (5 node Oracle RAC)
• Upgraded 10g to 11gR2; Converted 1-node instance to multi-node RAC, ASM migration
• Implemented 2-way and multi-way replication across 3 Oracle datacenters using Oracle Gloden Gate
• Implemented Oracle GlodenGate 11gR2 HA on a 3-node RAC using ACFS and DBFS
• RMAN backup and recovery, cloning

Senior Oracle DBA

Confidential, Seattle, WA

Responsibilities:

• Worked wif the internal development team to provide the necessary SQL, PL/SQL and other database management scripts to enhance, tune, optimize and implement database related development activities.
• Installed and supported 2-node 10gR2 and 11gR2 RAC databases, running on RedHat Linux 5.
• Successfully deployed 3 business critical applications wifin a month involving database installation, tuning, DBA support, interaction wif development, business analysts, consultants, and Oracle support.
• Collaborated wif managed service providers, internal development team, consultants and Oracle Support, to plan, optimize, and design database systems and its supporting applications.
• Wrote several scripts (shell, SQL) associated wif monitoring, database backups, tuning, and cloning.
• Deployed and implemented Oracle Grid Control (10g, 11g, and 12c) to monitor all databases.
• Tuned and improved daily purge process using partitioning and parallel processing by 400%.
• Contributed to Data Center migration project involving database upgrades; 9i to11g, 10g to 11g.
• Improved code deployment techniques by enhancing shell and SQL scripts and processes.
• Coached DBAs to improve efficiency, quality and productivity whilst working on multiple projects.