Scroll To View More
Suresh Kumar, T-SQL Developer in Gurugram, Haryana, India
Suresh Kumar

T-SQL Developer in Gurugram, Haryana, India

Member since August 18, 2017
Suresh Kumar has more than 16 years of experience in a variety of development roles. He’s been mainly working as a SQL Server database administrator and developer and data warehouse engineer. He's an expert in database design, composing complex queries and procedures, performance tuning, replication, mirroring, log shipping, backup/restoration, job monitoring, data migration, and more. Suresh is also comfortable with SSIS, SSRS, and SSAS.
Suresh is now available for hire

Portfolio

Experience

  • T-SQL, 16 years
  • SQL Developer, 16 years
  • SQL Server DBA, 12 years
  • Performance Optimization, 12 years
  • Database Replication, 10 years
  • SQL Server Integration Services (SSIS), 8 years
  • SQL Server 2012, 6 years
Gurugram, Haryana, India

Availability

Part-time

Preferred Environment

Windows/SQL Server, TFS, Subversion, Redgate

The most amazing...

...thing I’ve created was a rate matrix history for a logistics client; it was left half done by 2 previous vendors because of its complexity, but I finished it.

Employment

  • Senior Database Administrator

    2012 - 2017
    Fareportal
    • Worked as production database administrator (DBA) to provide support to live servers.
    • Designed and developed database solutions for new applications.
    • Worked with large tables with table sizes in the range of 2.5 to 3 terabytes; also partitioned the large tables.
    • Upgraded the production SQL Server from 2008R2 to 2012 and then from 2012 to 2016.
    • Worked on all aspects of a DBA profile including backup/restoration using Redgate tools, job monitoring, replication, AlwaysOn, and performance tuning.
    • Developed reports for the senior management and business analysts.
    • Managed the development servers, staging servers, and the report server.
    • Implemented the best practices for database security.
    Technologies: SQL Server, Microsoft Business Intelligence (MSBI)
  • Senior Database Administrator

    2010 - 2011
    TSYS International
    • Tuned the performance of business-critical procedures.
    • Designed and developed new database objects like tables, procedures, and functions.
    • Implemented database security best practices.
    • Trained other teams to manage the SQL Server.
    • Mirrored the SQL Server databases.
    Technologies: SQL Server, Start Team, HEAT, .NET
  • Information Technology Analyst

    2001 - 2010
    Tata Consultancy Services
    • Developed different database objects like tables, procs, functions, and triggers for a government project; worked as a SQL Server developer.
    • Constructed, as a VB6 developer, the roadmap and world back modules for a government project.
    • Led the testing for AC Nielsen in Chicago.
    • Developed more than 80 SSIS packages for Long and Foster (a conglomerate in the US).
    • Led the SQL Server development for Long and Foster (a conglomerate in the US).
    • Worked as a database developer for Hartford Insurance, CT.
    Technologies: SQL Server 2005, VB6, Subversion

Experience

  • CheapOAir, OneTravel, FareBuzz, and TripMama (Development)
    http://www.CheapOAir.com

    I managed all the database operations for the leading fare portals like CheapOAir.com, OneTravel.Com, FareBuzz.com, and TripMama.com

    It was my responsibility that the production server was kept up and running. I also optimized the performance and supervised all the database deployments for all the live servers.

  • Performance Tuning of a Substantiation Procedure at TSYS (Other amazing things)

    This was a business critical complex procedure. It had around 2,500 lines of code. Many attempts had already been made to improve its performance so I delicately worked on this proc for a few weeks and brought down the proc performance from 15 seconds to less than 1 second.

    The management there awarded me a certificate of appreciation specifically mentioning that procedure.

  • MyCare Card (Development)
    https://www.mycarecard.com

    The MyCare Card platform provided the benefits of security, ease, and convenience of accessing the end user funds and monitoring their activity from multiple accounts, including:
    - Flexible Spending Accounts, FSA: including limited purpose, health, transit and parking, and dependent care.
    - Health Savings Accounts, HSA: health reimbursement arrangements (HRA), lines of credit (LOC), and prepaid cash accounts.

    It also provided the benefits of integrated statements and healthcare statements were sent via email or via paper reports for claims.

    I worked extensively on tuning the performance of various areas of concern. I created and implemented database design solutions in collaboration with the programming team. I also handled the resolution of tickets raised in Clear Quest.

  • Long & Foster, USA (Development)
    http://www.LongandFoster.Com

    Long & Foster is the United States' largest privately owned real estate company.

    Our team was entrusted to develop and maintain their websites LongandFoster.Com, LuxuryHomes.com, LeadPear.com, and its agent portal.

    I developed SSIS packages and implemented a data integration for the 30 listed companies which supplies data to Long & Foster. I also developed SSAS cubes for web stats analysis. In addition, I wrote complex procs, functions, and views for Long & Foster.

  • Computerization of UP Public Works Department at TCS (Development)
    http://www.uppwd.gov.in

    The Public Works Department also called Uttar Pradesh (UP-PWD) is an organization that's entrusted with the primary responsibility of constructing and maintaining roads, bridges, and assigned buildings throughout the state.

    UP-PWD is divided into zones, circles, and divisions for the work execution, monitoring and control, and planning. The existing system had manually collected, stored, and retrieved this information. The project that I worked intended to computerize all the functional aspects of the organization.

Skills

  • Languages

    T-SQL, SQL, Visual Basic 6 (VB6)
  • Storage

    SQL Server 2012, SQL Server DBA, Database Replication, SQL Server 2016, SQL Developer, SQL Server 2008 R2, SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Redgate SQL Toolbelt, SQL Server Analysis Services (SSAS)
  • Other

    Performance Optimization, Mirroring, Log Shipping, HEAT, High Availability
  • Tools

    Subversion (SVN), Microsoft Access, TFS
  • Platforms

    Windows Server 2008, Windows, Windows Server 2012
  • Paradigms

    Agile Software Development

Education

  • Postgraduate diploma in Information Technology
    2009 - 2011
    Symbiosis International University - Pune, India
  • Bachelor of Engineering degree in Elecetronics and Communication
    1997 - 2001
    Deenbandhu Chhotu Ram University of Science and Technology - Murthal, Haryana, India
Certifications
  • MCITP
    AUGUST 2008 - AUGUST 2011
    Microsoft
I really like this profile
Share it with others