SUMMARY:

• 3+ yrs. Hands - on experience in managing Cassandra databases
• Datastax Cassandra 3.4 - 5.0; 6-180 nodes, 2/3 Confidential, 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 Confidential Walmart, Confidential, Confidential, Confidential, Confidential and Oracle
• Extensive hands-on scripting skills, including BASH, and PowerShell

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

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 size
• Tune compaction strategy on existing tables
• Wrote Spark Scala/Python code to analyze data anomalies.
• Migrate JVM from CMS to G1GC

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

Confidential, Mountain View, CA

Lead Cassandra Engineer/Architect

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 Confidential production clusters from DSE 4.6.3 to 4.7.3
• Expanded 30 node, 2 Confidential cluster to 180 node, 3 Confidential 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

Confidential, Bellevue, WA

Oracle DBA/Architect

Responsibilities:

• Operational support of Production (30TB+) and Development databases
• Oracle GoldenGate upgrade, failover, switchover activity, and setup Veridata
• Support Cassandra clusters in production environment (daily feeds from Oracle databases)
• Setup Physical and Logical standby

Confidential, San Bruno, CA

Cassandra DBA

Responsibilities:

• Setup 54 node, 2 Confidential Cassandra clusters from ground up (OS, Storage, Kernel, DSE software, configuration)
• Support 6-12 nodes, 2 Confidential Cassandra production clusters; decommission nodes, add/replace nodes, manage backups, tune Cassandra databases, manage alerts via Opscenter, integration with 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

Confidential, Foster City, CA

Oracle Database consultant

Responsibilities:

• Worked on Data Center Migration project involving Confidential 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 Golden Gate
• Implemented Oracle GoldenGate 11gR2 HA on a 3-node RAC using ACFS and DBFS
• RMAN backup and recovery, cloning

Confidential, Seattle, WA

Senior Oracle DBA

Responsibilities:

• Worked with 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 within a month involving database installation, tuning, DBA support, interaction with development, business analysts, consultants, and Oracle support.
• Collaborated with 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 with 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.

Confidential, Bothell, WA

Oracle DBA 4

Responsibilities:

• Supported Confidential ’s multi-terabyte Billing system based on Oracle 9i/10g on HP-UX.

Sr DATABASE CONSULTANT

Confidential

Responsibilities:

• Provided DBA support from development to production, associated with installation, upgrade, deployment, and performance tuning.
• Supported and managed ERP databases across all tiers, including routine maintenance, SQL tuning, Query optimization, database cloning using Kintana, patching, code-migration and database backup.

Confidential, Bellevue, WA

Senior Principal Consultant

Responsibilities:

• Installed, upgraded and supported Oracle databases and EBS applications for various clients UNIX platform.
• Tuned SQL queries and EBS modules (Financials, Manufacturing) while on a project Confidential Boeing.
• Participated on several SQL query optimization projects with the internal development groups Confidential Oracle to resolve and enhance web application while on a project Confidential Fujitsu Consulting.