Sudhir G.
Drop Here

Sudhir G.

MySQL Architect & DBA

$55.56/hr

Hyderabad, India


Sudhir G. has added 1 portfolio piece. Create an account to review it.

Professional Summary:-  8+ years of experience in MySQL DBA, Development ... moreand Database Architecture  Managing Very Large OLTP Databases (>6 TB) and Data Warehousing (>118 TB)  MySQL & Oracle Certifications with 92% of score  Expert-level knowledge in designing, implementing, and managing database systems for heavy-traffic transactions  Expert-level knowledge in MySQL’s logical Architecture, Concurrency control, Transactions(ACID), Multi-version Concurrency Control and MySQL’s Storage Engines  Experience in optimizing a poorly designed and badly indexed schema of high traffic web applications and improved performance up to 600%.  Excellent knowledge and solid experience in PL/SQL code Query Tuning and Optimization, Restructure quires and Query optimizer hints  Excellent knowledge and hands on experience of Optimizing MySQL server settings on General Tuning, Tuning MySQL’s I/O Behavior, Tuning MySQL Concurrency and Workload-Based Tuning.  Expert-level MySQL high availability skills with Master–Slave, Master–Master, Master and Multiple Slaves, Master-Master in Active-Active Mode, Ring, Pyramid replications set up, replication troubleshooting and Replication failover alerts on heavy load application  Expert-level knowledge on MySQL Backups and Recovery, Logical and Raw backups, Increment backups, Parallel backup, Compression backup and point in recovery  Expert-level knowledge on Operating System and Hardware Optimization, Balancing Memory and Disk Resources, RAID Performance Optimization, Choosing Hardware for a Slave.  Excellent Knowledge plug-in APIs for replication, authentication, auditing, authentication and thread pooling.  Excellent Knowledge on DB server Benchmarking, DB server Capacity Planning, Benchmarking strategies, Benchmarking Tactics and Benchmarking tools  Experience on installation different versions of MySQL dedicate servers on Linux, Solaris and Windows NT/2003/2000 and tuned server level configuration parameters based on application behavior.  Experience in Production MySQL Cluster setup with tow node groups, DRBD and windows server failover clustering (WSFC).  Good scripting/programming skills using Perl, Python, Shell and PHP  Experience in Linux & Solaris administration skills  Excellent knowledge in creating new databases and users, Administrating security levels Privileges, setup schedule backups and failover alerts, Import and Export backups, crash recovery, using mysql utilities, data encryption and monitoring scripts.  Excellent Knowledge in Shell and Perl Scripting and configure for Backup failover alert, Replication failover alert, replication lagging alert, daily top 10 slowest query alert , Dead lock alert and other monitoring alerts.  Excellent knowledge and hands on experience in Migrating from other RDBMS (MSSQL, Oracle) to MySQL using Talend , SSIS and MySQL migration ETL tools  Excellent Knowledge in MySQL Capacity Planning, Benchmarking and finding the Bottlenecks.  Experience on Normalization, De-normalization, Database modeling and EER diagrams  Good at relational Databases design using MySQL 5.0, 5.1, 5.5 and Oracle 9i  Excellent knowledge and hands on experience in SQL and PL/SQL coding and optimizing in Mysql 5.0, 5.1, 5.5, Oracle9i and MSSQL servers.  Excellent knowledge and solid experience in SQLYog, Talend, Info Bright (Data warehousing), Mysql Workbench, Jet Profiler, MaatKit, Sysbench, MySQL SLAP, Database Test suite, Mysql Benchmark, Percona XtraBackup, Mydumper, Myloader, Percona Data recovery tool and MySQL query browser.  Experience on recovering lost/corrupted data from InnoDB tables.  Excellent Knowledge and hands on experience in Data Warehousing concepts tools Infobright, TokuDB, Talend and SSIS,SSAS&SSRS  Good at coding, debugging and writing Stored Procedures, Functions, Triggers and Views by maintaining the standards to meet organization requirements and customer expectations.  Knowledge in database architecture concepts as well as vendor-specific implementations  Good at troubleshooting for technical problems and understanding the system.  Analyzed, designed and developed procedures, functions and Triggers  Excellent knowledge and solid experience in MySQL Architecture and Database Design  Excellent Time management skills for handling multiple projects.  Active team player and a self-starter, capable of working independently.  Ability to define short, mid and long-term goals.  Intense desire to create new and innovative solutions  Ability to work independently on large projects.  Excellent communication skills written and verbal.  Excellent organizational and follow-up skills.  Good at mathematics, statistics and reasoning less

Overview

Professional Summary:-  8+ years of experience in MySQL DBA, Development and Database Architecture  Managing Very Large OLTP Databases (>6 TB) and Data Warehousing (>118 TB)  MySQL & Oracle Certifications with 92% of score  Expert-level knowledge in designing, implementing, and managing database systems for heavy-traffic transactions  Expert-level knowledge in MySQL’s logical Architecture, Concurrency control, Transactions(ACID), Multi-version Concurrency Control and MySQL’s Storage Engines  Experience in optimizing a poorly designed and badly indexed schema of high traffic web applications and improved performance up to 600%.  Excellent knowledge and solid experience in PL/SQL code Query Tuning and Optimization, Restructure quires and Query optimizer hints  Excellent ... moreknowledge and hands on experience of Optimizing MySQL server settings on General Tuning, Tuning MySQL’s I/O Behavior, Tuning MySQL Concurrency and Workload-Based Tuning.  Expert-level MySQL high availability skills with Master–Slave, Master–Master, Master and Multiple Slaves, Master-Master in Active-Active Mode, Ring, Pyramid replications set up, replication troubleshooting and Replication failover alerts on heavy load application  Expert-level knowledge on MySQL Backups and Recovery, Logical and Raw backups, Increment backups, Parallel backup, Compression backup and point in recovery  Expert-level knowledge on Operating System and Hardware Optimization, Balancing Memory and Disk Resources, RAID Performance Optimization, Choosing Hardware for a Slave.  Excellent Knowledge plug-in APIs for replication, authentication, auditing, authentication and thread pooling.  Excellent Knowledge on DB server Benchmarking, DB server Capacity Planning, Benchmarking strategies, Benchmarking Tactics and Benchmarking tools  Experience on installation different versions of MySQL dedicate servers on Linux, Solaris and Windows NT/2003/2000 and tuned server level configuration parameters based on application behavior.  Experience in Production MySQL Cluster setup with tow node groups, DRBD and windows server failover clustering (WSFC).  Good scripting/programming skills using Perl, Python, Shell and PHP  Experience in Linux & Solaris administration skills  Excellent knowledge in creating new databases and users, Administrating security levels Privileges, setup schedule backups and failover alerts, Import and Export backups, crash recovery, using mysql utilities, data encryption and monitoring scripts.  Excellent Knowledge in Shell and Perl Scripting and configure for Backup failover alert, Replication failover alert, replication lagging alert, daily top 10 slowest query alert , Dead lock alert and other monitoring alerts.  Excellent knowledge and hands on experience in Migrating from other RDBMS (MSSQL, Oracle) to MySQL using Talend , SSIS and MySQL migration ETL tools  Excellent Knowledge in MySQL Capacity Planning, Benchmarking and finding the Bottlenecks.  Experience on Normalization, De-normalization, Database modeling and EER diagrams  Good at relational Databases design using MySQL 5.0, 5.1, 5.5 and Oracle 9i  Excellent knowledge and hands on experience in SQL and PL/SQL coding and optimizing in Mysql 5.0, 5.1, 5.5, Oracle9i and MSSQL servers.  Excellent knowledge and solid experience in SQLYog, Talend, Info Bright (Data warehousing), Mysql Workbench, Jet Profiler, MaatKit, Sysbench, MySQL SLAP, Database Test suite, Mysql Benchmark, Percona XtraBackup, Mydumper, Myloader, Percona Data recovery tool and MySQL query browser.  Experience on recovering lost/corrupted data from InnoDB tables.  Excellent Knowledge and hands on experience in Data Warehousing concepts tools Infobright, TokuDB, Talend and SSIS,SSAS&SSRS  Good at coding, debugging and writing Stored Procedures, Functions, Triggers and Views by maintaining the standards to meet organization requirements and customer expectations.  Knowledge in database architecture concepts as well as vendor-specific implementations  Good at troubleshooting for technical problems and understanding the system.  Analyzed, designed and developed procedures, functions and Triggers  Excellent knowledge and solid experience in MySQL Architecture and Database Design  Excellent Time management skills for handling multiple projects.  Active team player and a self-starter, capable of working independently.  Ability to define short, mid and long-term goals.  Intense desire to create new and innovative solutions  Ability to work independently on large projects.  Excellent communication skills written and verbal.  Excellent organizational and follow-up skills.  Good at mathematics, statistics and reasoning less

Sudhir G.
Drop Here

Sudhir G.

$55.56 /hr

MySQL Architect & DBA

Hyderabad, India

Overview

Professional Summary:-  8+ years of experience in MySQL DBA, Development and Database Architecture  Managing Very Large OLTP Databases (>6 TB) and Data Warehousing (>118 TB)  MySQL & Oracle Certifications with 92% of score  Expert-level knowledge in designing, implementing, and managing database systems for heavy-traffic transactions  Expert-level knowledge in MySQL’s logical Architecture, Concurrency control, Transactions(ACID), Multi-version Concurrency Control and MySQL’s Storage Engines  Experience in optimizing a poorly designed and badly indexed schema of high traffic web applications and improved performance up ... moreto 600%.  Excellent knowledge and solid experience in PL/SQL code Query Tuning and Optimization, Restructure quires and Query optimizer hints  Excellent knowledge and hands on experience of Optimizing MySQL server settings on General Tuning, Tuning MySQL’s I/O Behavior, Tuning MySQL Concurrency and Workload-Based Tuning.  Expert-level MySQL high availability skills with Master–Slave, Master–Master, Master and Multiple Slaves, Master-Master in Active-Active Mode, Ring, Pyramid replications set up, replication troubleshooting and Replication failover alerts on heavy load application  Expert-level knowledge on MySQL Backups and Recovery, Logical and Raw backups, Increment backups, Parallel backup, Compression backup and point in recovery  Expert-level knowledge on Operating System and Hardware Optimization, Balancing Memory and Disk Resources, RAID Performance Optimization, Choosing Hardware for a Slave.  Excellent Knowledge plug-in APIs for replication, authentication, auditing, authentication and thread pooling.  Excellent Knowledge on DB server Benchmarking, DB server Capacity Planning, Benchmarking strategies, Benchmarking Tactics and Benchmarking tools  Experience on installation different versions of MySQL dedicate servers on Linux, Solaris and Windows NT/2003/2000 and tuned server level configuration parameters based on application behavior.  Experience in Production MySQL Cluster setup with tow node groups, DRBD and windows server failover clustering (WSFC).  Good scripting/programming skills using Perl, Python, Shell and PHP  Experience in Linux & Solaris administration skills  Excellent knowledge in creating new databases and users, Administrating security levels Privileges, setup schedule backups and failover alerts, Import and Export backups, crash recovery, using mysql utilities, data encryption and monitoring scripts.  Excellent Knowledge in Shell and Perl Scripting and configure for Backup failover alert, Replication failover alert, replication lagging alert, daily top 10 slowest query alert , Dead lock alert and other monitoring alerts.  Excellent knowledge and hands on experience in Migrating from other RDBMS (MSSQL, Oracle) to MySQL using Talend , SSIS and MySQL migration ETL tools  Excellent Knowledge in MySQL Capacity Planning, Benchmarking and finding the Bottlenecks.  Experience on Normalization, De-normalization, Database modeling and EER diagrams  Good at relational Databases design using MySQL 5.0, 5.1, 5.5 and Oracle 9i  Excellent knowledge and hands on experience in SQL and PL/SQL coding and optimizing in Mysql 5.0, 5.1, 5.5, Oracle9i and MSSQL servers.  Excellent knowledge and solid experience in SQLYog, Talend, Info Bright (Data warehousing), Mysql Workbench, Jet Profiler, MaatKit, Sysbench, MySQL SLAP, Database Test suite, Mysql Benchmark, Percona XtraBackup, Mydumper, Myloader, Percona Data recovery tool and MySQL query browser.  Experience on recovering lost/corrupted data from InnoDB tables.  Excellent Knowledge and hands on experience in Data Warehousing concepts tools Infobright, TokuDB, Talend and SSIS,SSAS&SSRS  Good at coding, debugging and writing Stored Procedures, Functions, Triggers and Views by maintaining the standards to meet organization requirements and customer expectations.  Knowledge in database architecture concepts as well as vendor-specific implementations  Good at troubleshooting for technical problems and understanding the system.  Analyzed, designed and developed procedures, functions and Triggers  Excellent knowledge and solid experience in MySQL Architecture and Database Design  Excellent Time management skills for handling multiple projects.  Active team player and a self-starter, capable of working independently.  Ability to define short, mid and long-term goals.  Intense desire to create new and innovative solutions  Ability to work independently on large projects.  Excellent communication skills written and verbal.  Excellent organizational and follow-up skills.  Good at mathematics, statistics and reasoning less

Sudhir G. has added 1 portfolio piece. Create an account to review it.

Work History and Feedback

  • MySQL Expert with experience optimizing Wordpress/Woocommerce site

    Aug 2015
    1.80
    I was on a deadline, communication was not good, sometimes mid conversation would disappear and not answer till next day. Started job then had other commitments so told me cant do till 2 days after. by the next time i talked to him it was to late. I tried to salvage anything i could by seeing if he had expertise on another platform but again he disappeared mid conversation. Waste of money

    2 hours

    $15.00 / hr
    $30.00 earned

  • MongoDB DBA Database Administrator

    Nov 2014 - Dec 2014
    5.00
    Nice work, thank you!

    3 hours


  • MySQL Performance Optimisation

    Jul 2014 - Aug 2014
    4.40
    Sudhir was not able to sort out the specific MySQL and database design issues we had. However he was open about this. Communication was good and he was easily contactable. Very honest! He volunteered a full refund when the project could not be completed. So giving him a try did not cost us financially. We will be discussing future database work with him.

    7 hours

    $19.99 / hr
    $1.04 earned

  • MySQL MyISAM DB Optimization

    May 2013
    4.55

    4 hours

    $33.33 / hr
    $127.76 earned

  • MySQL Expert

    Mar 2013 - May 2013
    5.00
    It was a pleasure working with Sudhir and his expertise in MySQL helped us drive our project to completion.

    5 hours


  • MySql Database Architect

    Dec 2012 - Jan 2013
    5.00
    Thank You

    74 hours

    $12.78 / hr
    $947.89 earned

  • mysql-proxy on Ubuntu 12.04

    Nov 2012
    5.00
    I know Sudheer is a great MySQL DBA, unfortunatelly such time he didn't get my task in time. Even the best can be in late :-) Will work with you again with great pleasure.
    $16.67 earned
    Fixed Price

  • Simply MySql query

    Oct 2012 - Nov 2012
    No feedback given

    2 hours

    $10.00 / hr
    $100.00 earned

  • Mysql Expert

    Oct 2012
    5.00
    Very knowledgeable about mysql and server tuning.
    $5.00 earned
    Fixed Price

Sudhir G. has more jobs to show. Create an account to review them.

Tests

NameScore (out of 5)Time to Complete
MySQL 5.0 Test3.75Top 20%39 mins
MySQL Test4.15Top 20%46 mins
SQL Test3.00Top 20%40 mins
or
Invite to Job
What's the difference?

100% Job Success
Top Rated
Work History
1,538 hours worked
28 jobs
Availability
Available
More than 30 hrs/week
Profile Link
Search for others