Talk to sales Try for Free
Neha Gupta

Neha Gupta

Associate Consultant

Followers of Neha Gupta357 followers
location of Neha GuptaPune, Maharashtra, India

Connect with Neha Gupta to Send Message

Connect

Connect with Neha Gupta to Send Message

Connect

  • Timeline

  • Skills

    Database administration
    Sql dba
    Sql
    Microsoft sql server
    Oracle database
    Cluster
    Sql server integration services
    Sql server reporting services

  • About me

    Experience with SQL Administration, Monitoring, Database Backup and Recovery.Has Knowledge of SQL Server Log Shipping, Replication, Mirroring and Cluster. * Installation of SQL Server2005/2008 R2/2012/2014,Service Packs. * Troubleshooting SQL Server Production issues * Moving objects from QA/Development to Production databases * Identifying and resolving Blocking and Dead-lock issues. * Identifying the bottlenecks in the system through perfmon counters and resolving them * Implementations of SQL logins, roles and authentication mode as part of security Policies for various categories of users. * Job Automation. Configuring Database Mail, configuring Operators and Alerts. * Backup and Restores. * Emergency Disaster Recovery experience * Replication, Log Shipping, Mirroring, Clustering and High Availability options. * System and User database corruptions. * Performance tuning of queries * Capacity Planning and monitoring database growth * Maintenance plan implementation. * ITIL certified

  • Education

    • Viva college

      2006 - 2008
      HSC

    • Savitribai Phule Pune University

      2008 - 2012
      Bachelor of Engineering (BE)

  • Experience

    • Capgemini

      Dec 2013 - Dec 2017
      Associate Consultant

      Project Description: Visteon Corporation (American global automotive electronics supplier)Role: SQL DBAResponsibilities: • Daily monitoring and generating Reports• Create and maintain users and roles, assign privileges.• Implement new maintenance plan and index optimization strategies as per best practices • Scheduling The Job On SQL Server ,troubleshooting Job failure• Managing Transaction log and Data file size growth and shirking of databases.• Handling incidents on CA Service Desk.• Troubleshooting Log shipping and Replication issue.• Installation and configuration of Microsoft SQL Server• Installation and configuring SQL Cluster.• Upgrading sql server from lower version to higher version.• Applying latest service pack on SQL Server• Providing database support during business / non-business hours (on call support) • Providing inputs from database view on application enhancement • Preparing Transition related documents (technical as well as non technical) during Transition of project to New vendor • Troubleshooting in database during performance issues • Preparing Monthly incidents / change reports, RCA of production outages, any ad-hoc report required by customer / management • Working on request of New Server build, Instance decommission from Application team • Attending Team and other Management related meetings.Software / Languages: MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014Ticketing Tool:CA Service Desk Show less

    • Allscripts India

      May 2018 - May 2022
      Senior Database Analyst

    • Altera Digital Health

      May 2022 - now
      Sr Database support Analyst

  • Licenses & Certifications

    • ITIL Foundation

      Sept 2016