SUMMARY

• Experienced Database Architect with strong Big Data skills and Cloud Computing implementation experience is looking to contribute his knowledge and expertise to the success of your Big Data strategy

TECHNICAL SKILLS

• Complete Hadoop ecosystem (HDFS, Yarn/Mesos, MR, Hive, Spark, Impala)
• Standalone (Hadoop 2.7, Spark 2.1.0) and commercial (Cloudera, Horton) distributions
• Parallel data stores: Cassandra, Hawq, Netezza, Greenplum
• Streaming: Kafka, Spark Streaming
• Parallel file systems: CEPH, OrangeFS
• Cloud Computing: Amazon EC2, EMR
• Experience implementing IaaS, PaaS, SaaS services
• Amazon EC2, AWS, EMR services
• Provisioning and configuring AWS services and topologies
• Cloud security, access controls and reporting
• Monitoring cloud environments
• Architecting Data Warehouse, DataMart and DataLake environments
• Data Modeling, Logical/Physical Design
• Dataflows, Ingestion, Validation
• Indexing and partitioning design. HA and Replication solutions.
• Writing and optimizing SQL
• Database/SQL Tuning, O/S optimizations
• Structured/unstructured data
• Oracle 10g/11gR2/12c, Exadata, SuperCluster
• SQL Server, PostgreSQL, MySQL
• Production and Development support, writing and optimizing SQL
• Index and partitioning design. HA and Replication solutions: Oracle DG, MS Always ON
• Database Tuning, SQL Tuning, O/S optimizations
• Languages: Python, Scala, Java, PL/SQL, T - SQL, C++, Shell scripting
• Tools: PL/SQL Developer, SQL Developer, Netbeans, Eclipse, Code::Blocks
• Frameworks: Hibernate, Spring, JSP, JDBC, Servlets, JSF2
• Application servers: Tomcat, Glassfish, Weblogic
• Git, Jira
• RHEL, OEL, CentOS, Solaris, AIX, Windows 2008/2012,
• EMC Clariion, VMax, HP EVA, NetApp, Oracle ZFS Storage appliance

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Database Administrator

Responsibilities:

• Architected in-house Big Data platform processing 2TB of daily data ingestion. Performed Cloudera installations and configurations (HDFS, Yarn, Hive, Impala, Spark, Zookeeper), Kerberos integration. Installed and configured Kafka - Cassandra streaming environment. Developed high performance data loading and ETL workflows using Kafka producers/consumers implemented in Scala.
• Created Python based monitoring application for in-house Big Data platform. Worked with Development team on writing SparkSQL code, optimizing Impala queries, and reviewed Scala and Python code. Evaluated scalability of Spark MLib based machine learning algorithms.
• Worked with ETL team on data models implementation, data mapping and analysis, architecting data flows between various file and database based datasources.
• Supported Oracle, Oracle Exadata, Netezza, Greenplum database environments.

Confidential - Bethpage, NY

Database Architect

Responsibilities:

• Responsible for on-going production support of the in-premise database environment and actively participated in migration of the several company's applications and databases to AWS EC2 platform.
• Managed a team of two DBA resources (on-shore/off-shore). Focused on standardizing operations, establishing database support standards, improving database environment. Established database support standards and procedures including database provisioning and de­commission, backup/recovery, data handling, account management, database audit, peer reviews. Set forth team goals, planned team resources for project work, promoted knowledge exchange culture and team work. Ensured licensing compliance.
• Architected and deployed 20 node Hadoop 2.6 cluster, integrated Hadoop with CEPH distributed storage. Installed and configured Apache Spark 1.6. Worked with development on data ingestion pipelines and data processing workflows.
• Guided business on database architecture, database capacity, best practices and features to address high availability, high performance, business continuity and capacity requirements. Performed capacity evaluation of all Exadata systems, validated storage and computing resources with respect to business growth which saved customer $900K by postponing unnecessary upgrades to full rack environment. Supported multiple development and application support teams in the areas of application architecture, product development, application and database performance, ETL processes optimization. Supported multiple mission critical applications and worked closely with development teams on upgrades, improvements and problem resolutions.

Confidential - New York, NY

Sr. Database

Responsibilities:

• Responsible for support of production, development and QA database environments for Ad Sales Administrator Platform, total size of 25TB, 800 concurrent users. Initiated POC migration project from old
• NetApp based database architecture to Oracle half rack SuperCluster solution. Demonstrated high performance and management capabilities of SuperCluster (storage indexes, HCC, cell offloading, smart scan).

Confidential - Norwalk, CT

Sr. Database

Responsibilities:

• Evaluated AWS EC2 cloud services for Database IaaS provisioning. Responsible for cloud servers provisioning, security hardening, database migrations to cloud environment.
• Responsible for continued operation of a dozen clustered and standalone Production, UAT and Development Oracle databases, supporting several customers with high availability requirements, and SQL Server Production databases with very strict SLAs. Participated on 24/7 on call monitoring. Performed 10g/11g Grid Infrastructure installations, RAC and non-RAC database installations, configuration, backup/recovery with RMAN. Configured monitoring and developed custom reports in OEM Grid Control to enable proactive administration and quick response to outages.
• Performed Exadata patching and upgrades of storage servers and compute nodes. Implemented
• Exadata Monitoring via OEM Grid Control. Regularly used Exadata diagnostic tools: Exachk, OSWatcher, imageinfo, cellcli, etc ... Understands how to use Exadata smart scan, flash cache, storage indexes, columnar compression, IORM features.
• Extensive performance analysis and tuning using AWR and other tools to identify problem SQL, recommend indexes/hints/sql profiles/restructuring to improve performance. Set up one way Golden Gate replication between OLTP databases and read-only reporting databases.

Confidential - Stamford, CT

Oracle DBA

Responsibilities:

• Worked on implementing LIMS (Laboratory Information Management System) project. Provided support for complex (more than 120 databases), heterogeneous (HP-UX, Linux, Windows, Oracle 8i,9i, 10g) database environment.
• Logical and physical database modeling using ER Studio tool. Database schema deployments on production, QA and development environments. Communication with development teams, providing guidance for database architecture. Supported OEM Grid Control database monitoring infrastructure including monitoring database targets, reacting on alters and policy violations, creating and monitoring jobs.
• Performing backup and recovery, database refreshes, database validation procedures. Oracle 10g RAC deployments. Scripting using UNIX shell and Perl.

Confidential - Stamford, CT

Oracle DBA

Responsibilities:

• Lead a conversion project from MySQL to Oracle RAC for one of the leading software development companies in gaming industry, with focus on scalability, high availability and disaster recovery requirements.
• Supported development, test, QA and production environments consisting of two Oracle RAC databases, 8 instances, more than 4 TB in size, 15000 online users, and 45GB daily growth rate.
• Evaluated different clustered database technologies for the purpose of migrating to more stable, scalable and highly available RDBMS platform. Prepared project plan, resources estimation, cost analysis, system sizing, capacity planning, design conversion and deployment approach, conduct conversion team meetings. Dramatically reduced implementation cost of the RAC database utilizing Oracle's ASM technology and low-cost Linux servers. Cleaned and normalized schema during database conversion; implemented referential integrity. Utilized partitioning, reverse key indexing and bulk binding significantly increasing database performance.
• Executed performance and fail-over tests validating hardware, database configuration, indexing strategy, scalability and high availability for the RAC database.
• Implemented capacity planning and data retention policies; estimated data growth rate, classified data into different groups, created appropriate partitioned table objects and procedures to retire old data with respect to the policy.
• Conducted several presentations for the development team, introducing advanced Oracle features like autonomous transactions, dynamic SQL, ref cursors, pipelined functions, bulk binding, advanced queuing, streams, TAF.