SUMMARY:

• Principal DB Architect / EDW Architect / Azure Cloud Architect / Enterprise Architect
• Seasoned IT Infrastructure & Database technologies professional with 19 years diversified and progressive experience.
• Good Windows Server skills, Skilled in Microsoft Azure, Proactive Monitoring skills with WMI & Powershell scripting, AWS, VMWare, Production DBA, Performance Tuning, Automation & Troubleshooting skills, Oracle admin, AWS Cloud, SubVersion admin, F5 BigIP LTM admin, MySQL InnoDB Cluster, MySQL Router.
• Experienced in supporting very large OLTP Transactional and Enterprise Data Warehouse EDW databases.
• Possess excellent hands - on experience in "Infrastructure, Engineering, Production & Development" administrator and architect roles. Possess excellent knowledge in EMC SAN & fibre network technologies, Good knowledge in VMWare.
• Expert knowledge in the design and architecture of multi-dimensional snowflake schema based EDW that reflects the transactional data into EDW on almost 'Nearline' timeframe. (within 1 to 5 minutes)
• Advanced level performance troubleshooting, tuning, Database migrations; Tasks automation & Integration, solid hands-on with DR planning and real-time tests, and working with Enterprise environments involving 500 Physical Servers and 3000 Databases, VLDB Support, and with high end IT infrastructure.
• Extensively worked and supported NxGen Siebel CRM / PeopleSoft / EMC Documentum/ OBIEE / Sharepoint / EMC SourceOne / Informatica / EMC Captiva / Oracle DAC / SCOM 2007 / Drupal Portal Systems / EMC Avamar / Apache Solr / EMC xPression / MS EPM systems and possess good knowledge in SSIS, SSRS etc.
• Good knowledge in AD, Networking, IIS Web Server, worked with F5 BigIP 3600 LTM machines from initiation, configuration and administration.
• Excellent business communication skills and project management skills. Led dba teams and worked in Technical Lead role and is a trained professional in Consulting, Business Administration, Cloud Solutions & Project Management functions.
• Holds active Federal Public Trust clearance since 2010 which is valid until 2021.

SPECIALTIES:

• Sr SQL DBA
• MySQL DBA - Windows / Linux (HA Cluster, Group Replication, MySQL Router etc.)
• Azure SQL DBA
• Cassandra DBA
• Redshift DBA
• Experienced in RDBMS SQL and Columnar NOSQL database world.
• EDW Architecture, Enterprise DW- Dimensional & Snowflake Modeling
• Cloud Solutions with Azure and AWS (Private cloud & Gov Cloud)
• Expert knowledge in design & implementation of SQL Server and MySQL HA cluster, DR solutions
• T-SQL Scripting, PowerShell/ VBScript / WMI Scripting
• Excellent knowledge in Windows Server, VMWare and good Linux knowledge

PROFESSIONAL EXPERIENCE:

Confidential

Database Specialist

Responsibilities:

• Assisted the Programming & Playback division in troubleshooting one of their critical application that serves the music and weather details to Toyota thru the Toyota ENTUNE application. (heavy transactional database 6K batches or more per second)
• Review MySQL performance and assist in identifying the database wait stats and potential problems with the war-room kind of troubleshooting
• Short term troubleshooting assignment for this particular TT Entune seeding app (s can be provided)
• Attend and contribute in the cross-functional team meetings. Issue was identified and resolved on the 3rd day.

Confidential

Principal Architect & DB Administrator

Responsibilities:

• Worked on DB, EDW, Cloud architecture project planning, application development & deployment support.
• Planned, Designed & Implemented and Maintained of High-Available Database Farm
• MS Failover SQL Server Cluster -&- MySQL Cluster, Group Replication, MySQL Router
• Key member in 'ALMOST ONLINE' Enterprise DW project. (EDW Architecture planning, Developed POC (proof of concept) with SQL programming, development and successful implementation with EDW cluster and "NEAR-LINE DW Data" from OLTP systems.) - "Near-Line" Data = OLTP apps data in DW "within a minute".
• Production support of multi TB (8+ TB) sized transactional 24X7 COTS & DW Enterprise-wide systems
• Contributing participant - CAB related processes with IT infrastructure & Business Services group.
• Performed advanced level Performance Troubleshooting & Tuning
• True CROSS-FUNCTIONAL consulting role (Infrastructure - Network - Virtualization - Storage - Development - Enterprise D/W & Obiee Reporting - Client Tech Mgmt. - AWS - Project Management etc)
• Administration of MySQL Portal Databases for Drupal Systems.
• Implemented MySQL HA cluster for the agency’s main Drupal based website database.
• Database Administration of NOSQL Systems projects, Worked on Cassandra NOSQL initiatives.
• Proficient in Cassandra Data Architecture, Admin tasks such as Cluster Installation in Linux env, Configuration, Node Scaling, Monitoring nodes, Log Reviews, Nodetool, CQL Shell, Index Creation, Snapshot, Compaction etc
• Redshift admin - Cluster Config, User Security, Backup, Data Loads, Table Design, Tuning, SQL Workbench etc
• AWS administration - Phase 1 systems (AWS initialization tasks thru maintenance of AD, RDS, RedShift, IAM, VPC, AMIs, Drupal, Apache Solr & DB systems)
• Worked with Microsoft Azure Solutions such as Azure planning, Azure DR options, VM migration tasks
• SubVersion Repository Administration and Support. Migrated SVN repos between environments.
• Managed data "from 70 GIGS to 8+ TERA bytes" and assisted in 15 Legacy application migrations to ERP, DB consolidation tasks & support migrations of various systems
• Assist data marts development & SSIS deployments, maintenance support Clustered version of SCCM deployment, MS patching support, EMC Captiva O&M Support
• Proposed the design, implementation and maintenance of Finance Dept's IBC confidential data archival efforts that "saved around 600K from 3rd party maintenance" charges

Senior DBA Consultant

Confidential

Responsibilities:

• Provided leadership in DB design, development and deployment of in-house dev applications
• Worked on architecture planning, development, database deployment, Developed DR plans & real-time drills.
• Wrote and implemented many script-based monitoring and maintenance admin tasks.
• Assigned Primary DBA for multiple Critical Applications, Advanced Performance Tuning and Troubleshooting.
• Primary DBA for the World 1st largest EPM and Portfolio Farm.
• Representative in Confidential 's RED team (CROSS - FUNCTIONAL) troubleshooting from DB Engg group.
• Assisting offshore operations vendor's team on visible, critical & level 4+ escalated DB issues.
• HA solutions like Clustering, Mirroring, Replication & Log shipping between multiple data centers.
• SharePoint DB Admin ( Confidential considered as World 2nd largest SharePoint Farm).
• Server & Database Risk assessment & Remediation Tasks. (Microsoft Engagements RAP Confidential ’s POC)
• New Products / Versions / SQL 2008 Qualifications Works
• Internal Consultant for Web Projects - Security Standards & Vulnerability Test Drills etc
• SCOM and Amazon AWS Cloud Computing works.

Senior Database Administrator

Confidential

Responsibilities:

• Client Engagement Duties included; Consultant Database Architect
• Database Administration & Development (included SharePoint Support) Web Server Load Balancer Administration (Design to Implementation)
• Consulting on HA Clusters (Design, HW vendor interactions, SAN Storage Setup, setting A-A-P clusters)
• Server Load Balancing -F5 Big IP 3600 series (setting the various profiles, VLANS, pool setups etc)
• Websites Vulnerability Remediations (IIS & DB Servers)

Senior Associate - IT Infrastructure Services

Confidential

Responsibilities:

• Senior Member of IT Infrastructure Services Practice Database Administration & Programming
• Level 4 and 5 DB Support Consultant.
• Onsite Coordinator and Database Lead for Engagements.

Senior Systems Engineer

Confidential

Responsibilities:

• Database Administration, Programming
• Project Management & Coordination
• Programming
• Database Administration
• Project Management Functions