SUMMARY:

10+ years of extensive experience in Database Management, Architecture, Design, Availability Management, Administration, Development, Maintenance, Installation, Configuration, Upgrading, Monitoring, Security, Data Mining, Data Science, Machine Learning, Designing, Modeling, Scripting, Testing and Supporting database solu­tions across both Oracle MySQL/PL/SQL and Microsoft SQL platforms working remotely and on site. Proficient in technologies, including MySQL, Percona XtraDB Cluster, Maria DB, MS SQL Server, T - SQL, Oracle Database 11g/12c, Mongo DB, Hadoop, NoSQL, Linux, Puppet, Chef, Galera, Access, JDBC, Visio, Perl, Java, C# and XML. Experienced in the E-Commerce, Healthcare, Automobile, Fitness, Real-Estate, Financial and Telecom Domain.

SKILL:

Database Management, Architecture, Design, Administraton, Availability Management,Development, Data­base Backup/Recovery, Table Parttoning, Restoring, Database Upgrades, Data Warehousing, Database Moni­toring, Performance Optmizaton, Data Replication, Database Clustering, Database Sharding/Parttoning, Con­figurator Load Balancing, Business Intelligence, Data Warehousing, Query Plan Analysis.

TECHNICAL SKILLS:

Database Expertise in : MySQL 5.1/5.6/5.7, Percona XtraDB 5.5/5.6/5.7, Percona Server, AWS RDS Aurora, MariaDB Galera Cluster 10, Oracle Database 11g/12c, Oracle GoldenGate 12c, Microsoft SQL Server 2008 R2/2012/2014, SSIS, SSRS, SSAS, MongoDB, Big Data, ETL, BI, Hadoop, NoSQL, Cassandra.

Tools Utilized : Percona Toolkit, Percona XtraBackup, New Relic, Nagios, Splunk, Percona Monitoring, AppDynamics, check mk, Oracle Enterprise Manager, PRTG, Jira, Slack, Stash, Hudson, Grafana, Rattic, Atlassian apps, Toad, DB Visualizer, SQL Profiler, Query Plan Analyzer, SQL Query Stress, ReSharper, Telerik Apps, OLTP, Docker, Kendo UI and SQL Visual Studio Tools.

Release Manaaement/DevOos: Jenkins, Puppet, SAP ERP, BI suite, SVN, GitHub, Team Foundaton Server.

Operating Systems: Linux, Mac OS, Dos/Microsoft Office/Win 95/2000/XP/2003/Win 7/8/10.

Programming Languages: C#, ASP.NET, Java, Perl, MVC, CSLA, JavaScript/VBscript, XML/XSL/CSS, HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Senior Database Architect / DBA

Responsibilities:

• Lead the DBA team and responsible for over 200 Production/Non-Production MySQL/MS databases with 100 TB data.
• Directed/Applied tasks at SFIA Level 6 on Database Design, Availability Management, Level 5 Database Administration.
• Set strategies for effective use of database technology taking account of interrelation between hardware/software.
• Applied up to date, specialized knowledge on database concepts, object and data modeling techniques/principles.
• Analyzed data requirements, established, modified, maintained a data model taking account of geocoding.
• Managed all phases of database architecture, administration and development including mapping, designing, capacity planning, configuring, implementing, testing, and post-launch support for company's customer data and fitness data.
• Provided expert knowledge in the selection, provision and use of database architectures, software and facilities.
• Successfully lead several data extraction, warehousing and analytics initiatives that reduced operating costs and cre­ated customized programming options.
• Maintained company database, including BI, Data Warehousing solutions, creating and modifying tables, monitoring traffic, importing and synchronizing data while working remotely and on-site.
• Carried out Data de-fragmentation, reorganization, Data Security, Data Warehousing using dB management systems.
• Contributed to maintaining database availability at 99.9999999 % across all MySQL backed applications.
• Created and managed projects including transition from single Percona Server to Percona XtraDB Cluster database environment, zero downtime upgrade from MySQL 5.1 to 5.6 and MySQL 5.6 to 5.7 leveraging load balancer.
• As a billion company, I optimized database performance for Beachbody most popular in-home fitness and weight loss products, including P90X®, Insanity®, FOCUS T25®, and Shakeology® by 32%, met Confidential SLAs expectations.
• MySQL/MS SQL SME while Supported/built database environments for eCommerce: beachbody.com, shakeology.com, teambeachbody.com, My Challenge Tracker App, Beachbody OnDemand, P90X, Insanity, Body Beast, 21 Day Fix.
• Analyzed multiple existing platform and application needs and designed a scalable architecture to meet those needs.
• Built database solutions based on business process to facilitate Multi-level Marketing: coach network, coach online office, CRM: Lead Wheel qualifications, Lead management, conversion, Genealogy and Commission system.
• Worked with developers specializing in iOS, Android, Java, Spring, and worked with tools such as Splunk, Percona Monitoring, check mk, Oracle Enterprise Manager, AppDynamics, New Relic, PHP, WordPress, AWS (Aurora, RDS), Oracle (Endeca, WCS, ESB, ATG, OAG, OIM), MarketLive, Liferay, (API Management), MongoDB, Ruby on Rails, Docker.

Confidential, Rochester Hills, MI

Sr. DBA / Database Developer

Responsibilities:

• Managed all phases of database administration and development for company's large 10 TB+ vehicle diagnostic data.
• Led and carried out database projects including transition from single MySQL DB to Clustered Maria DB / Galera.
• Led and developed database consolidation initiative to implement efficient data distribution and analysis.
• Built proactive monitoring measures and collected diagnosis data to ensure SLA's are met.
• Identified, developed, optimized MySQL/MS SQL statements in stored procedures/reports which were pain points. There was a 35% improvement in the critical path stored procedures and 53% improvements in the reports.
• Rebuilt highly fragmented indexes on the development databases and convinced Manager that application needs a periodic index rebuild and coordinated production implementation with the DBA team. Recovered 35 GB of free space from index rebuilt and thus weekly database maintenance improved by 2 hours. (Worked remotely 70% of the time)
• Attained 30% growth in revenue/customers by analyzing business needs and designed a new data warehouse.
• Solved and Fixed over 2000 Production Database Related Tickets each within a 12-hour time span.
• Developed over 1500 custom financial/auditing Database Report for Business Analysis and Data Mining purposes.
• Worked closely with front end, product and back-end developers to ensure data platforms meet their needs.
• Developed Complex Import Procedures for Specific data using Cursors, Cascade Delete/Insert Procedures.
• Developed and tested storage strategies and disaster-recovery plan for large company's operational database, deliver­ing solution that guaranteed recovery performance and high availability.
• Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual sessions and creating user-friendly materials.
• Created multiple programs to ensure correct data transfer and communications between Oracle database and SQL Server ERP system while working independently in remote environments.
• Optimized price testing, data upload, mapping modules for product controllers with a 82% improvement in run time.
• Provided support services for Data Warehousing, SharePoint and Business Intelligence solutions.
• Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
• Carried out Complex data patches to fix data Discrepancies and developed automated checks for future issues.
• Carried out Benchmark and regression tests to check for Performance Metrics to optimize database performance.
• Carried out Scrum Master Duties for daily meetings and Jira Administration applying Agile Methodology.
• Carried out database/code deployments for latest Builds/Trunks working closely with Network and Linux teams
• Modified and Build Java files using IntelliJ to modify nHibernate database s, queries and JSON files.
• Carried out Data Cleanup for Duplicate Data, Data Validation, Sanitized Data and Obfuscated data.
• Developed data validation jobs to check for specific conditions/criteria associated with the application.
• Implemented automation in data archive/transformation based on workflow logic using Perl, Shell and MySQL Scrips.
• Assisted in the development and launch of secure, recoverable and fault-tolerant systems for data access and identity management for state and federal government agencies including data masking, encryption of sensitive information.

Confidential, Troy, MI

Sr. DBA / Database Developer / Application Developer

Responsibilities:

• Created, Set up and Maintained Disaster Recovery of MySQL and MS SQL databases with High Availability Cluster.
• Developed time-saving, robust customer/employee data-intake system that automate database update functions, enabling new process-exception information to be automatically populated using complex stored procedures.
• Influenced, lead and developed big data architecture platform (Relational/NoSQL/Graph) upon which company grew.
• Developed Complex Scripts and applied MySQL/MS SQL jobs for Reports Alerts and Ticket Escalation Email Alerts.
• Developed CDR and Payment system which retrieves, delivers and provides secure communication between vendors using triggers and sophisticated stored procedures under MySQL/Maria DB/MS SQL while working remotely.
• Extensive experience with various backup/recovery methods mysqldump, enterprise backup, Percona XtraBackup .
• Provided support services for Data Warehousing and Business Intelligence solutions using Galera, MySQL and MS SQL.
• Designed and created Data Warehouses for company reporting purposes including reports like AR Aging, Invoices, Revenues, Orders, tickets, etc. using Pivot Tables, SSIS Packages.
• Maintained Company's 18+ Internal and Customer Production Databases in a 24 x 7 environment working remotely.
• Developed complex maintenance plans and performance monitoring solutions that increased performance by 10X and reduced downtime by over 35%.
• Created reports using SQL to monitor customer sales and identified new revenue streams for company brands.
• Managed and Automated Billing cycle processes and related databases with annual turnover of $20+ Million.
• Streamlined processes and procedures to increase database/system development efficiencies.
• Contributed to company's 15% revenue growth in 2013 by standardizing content from disparate databases, remap­ping billing/payment database, enabling sales and support staff to quickly respond to customer requests.
• Carried out order management processes by integratng with 17 other database systems.
• Developed data architecture design to enable analysts to perform targeted customer analysis.
• Optimized query and table design with knowledge of database performance and capacity.
• Provided Level 3 remote support of database residing on the system.
• Managed Business Processes, Work flow System, Customer Relatonships, Usage Data and carried Quality Analysis.
• Identfied future Software Enhancements for Customers based on Sales and Business Diagnostc data.
• Advised customers and stakeholders on database and software opportunites that align with business strategy.
• Interviewed prospect IT developers for Company Recruitng.
• Carried out System Administrator tasks, IT Support and Troubleshootng and trained new Employees and Interns.

Confidential, Birmingham, MI

Remote Lead Database Administrator / Principal Database Engineer

Responsibilities:

• Served as Lead DBA, Principal Engineer, Project Lead in the completon of 50+ medium to large scale implementa- Bons of MySQL/MS SQL dBs, managing projects from business requirements analysis to solutons delivery/support.
• Installed and upgraded the database servers and applicaton tools. (Worked remotely 100% of the time).
• Developed and Debugged Complex Queries and Scripts and Carried out over 5000 Production Database Tickets.
• Planned, Built and executed multiple detailed database projects/tasks simultaneously.
• Allocated system storage and planning future storage requirement for the database system.
• Modified the database structure, as necessary, from informaton given by applicaton developer verbally.
• Provided level 3 support remotely for database residing on the system.
• Monitored and optimized the performance of the database.
• Controlled user access, Disaster Recovery, Backup and Restore initatves.
• Maintained archived data and generated Reports using BI apps.