Manager / Data Architect Resume Carlsbad, CA - Hire IT People

SUMMARY

Hands on technical architect with 14 years of experience in building data platforms.
Architecting data platform supporting more than 25 million daily active users and more than 60 million monthly active users.
Building Big Data warehouse systems supporting PB scale data processing billions for records a day
Strong experience working with Relational and No - Sql databases
Strong experience building data pipelines / ETL
Strong experience working with distributed systems and big data.
Strong experience in developing and supporting SaaS enterprise level applications.
Possess excellent analytical, problem solving and communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server, Redshift, Hive and Couchbase.

Big Data: Hadoop, HIVE, Pig, Presto, Sqoop, Oozie and Map Reduce

Cloud: Amazon AWS, S3, ec2, Redshift and Qubole.

Programming: SQL, C++ and Python

PROFESSIONAL EXPERIENCE

Manager / Data Architect

Confidential, Carlsbad, CA

Responsibilities:

Designed and implemented scalable big data collection system to ingest the data from different data sources. Any application can use this system with simple message registration and start sending the data. Right now it collects about 12 million data points per minute at the peak and more than 4 billion messages/records per day. We process about 1 TB of data per day using this system
Built end to end scalable data pipelines / ETL to ingest data from different sources and process and transfer the data to various destinations.
Designed and implemented big data warehouse with nearly 1 PB of data using HDFS and Hive
Extended our in-house Hadoop cluster with AWS EMR / Qubole using S3 and ec2. Extended our DW to RedShift Cluster in AWS.
Designed and implemented backend systems for custom Ad exchange platform that servers more than 2 billion impressions per day.
Designed and re-architected the scalable data platform based on distributed shared nothing architecture. This system currently runs on 4 nodes supporting 25 million daily active users and supports more than 100k transactions per second with 99.99% up time. It can be scalable up to 256 nodes.
Designed and implemented the infrastructure for real-time analytics.
Build a great data infrastructure team. Recruited highly talented team members and motivated them to be productive.
Successfully transitioned our team to build the platform using no-sql / big data technologies in addition to traditional relational databases.

Sr Database Administrator

Confidential, San Diego, CA

Responsibilities:

Designed and developed complex multi-tenant database applications for SaaS ERP platform.
Designed and developed Data Warehouse for SaaS CRM, CMS, ERP applications using SSIS and SQL Server.
Designed and developed various KPIs and Custom report generation using dynamic queries.
Database administration and maintenance including production deployment and production support.
Replication setup and maintenance, reporting services development.
Work with UI developers for TSQL code review and help them with db and SQL problems.

Database Administrator

Confidential . Irvine, CA

Responsibilities

Implementing database backup and recovery procedures.
Evaluating and monitoring databases to resolve performance issues and fine tuning queries and stored procedures.
Creating and managing DTS packages, Triggers and Stored procedures.
Implementing and administering database replication between SQL Server databases.
Providing consultation on SQL Server to our development team.