Chander Dubedi

Experience

• 

  Planman Technologies India Pvt. Limited

  Dec 2005 - Jun 2009

  Database Administrator

  • Evaluation of faults in existing physical design and documentation of proposals to improve the system.• Owned and developed a detailed database creation process and related documentation to improve the quality of new deployments system.• Development of new PL/SQL procedures for implementing the new requirements of database data entries. • Identification of poor SQL statements to improve performance. • Implemented procedures to manage historic optimizer statistics to help diagnose problems with changing execution plans.• Refined a full production copy test environment refresh procedure for projects, reducing the duration dramatically and improving reliability.• Significant server consolidation activity in co-operation with the Sys Admin team. Using a combination of Stats pack and wait event tracing against overnight batch processes to identify performance problems.• As Junior DBA I was responsible for day-to-day database maintenance including Tuning on 3 running SQL Server2005 databases with 10-15 online database users: 2 productions servers and 1 development server.• As Junior DBA I was responsible for database maintenance of Production Systems for Give India, US and UK. I was responsible for performance tuning, database security, backup & recovery procedures and full database support of production, development and acceptance databases. • Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints.• Worked closely with Give India, US and UK on development of group-wide database security standards. Documentation and hand-over of procedure to Give India, US and UK.• Mapping to load data from an old application to the new application.• Used PL/SQL to create procedures, functions, packages and triggers.• Designed and developed Tables, Indexes and Views in SQLSERVER2008 Database. Show less

• 

  ASKME.com

  Jun 2009 - Sept 2011

  Assistant Manager - Database

  • Design the ETL process to migrate data from old system to new system.• Defined, created, and structured the databases.• User maintenance, database security imposition by creation and granting of roles and privileges.• Setting up of managing staging and production Environments.• Mapping to load data from data management Online to freeads database.• Used PL/SQL to create procedures, functions, packages and triggers to sync data from different source.• Designed and developed Tables, Indexes and Views in SQLSERVER2005 Database.• Auditing the DML statements using service broker• Data cleansing• Creating the Fast Search flat file index to be used in Fast Search - Enterprise Search from Microsoft.• Provided 24x7 supports on production instances to Chennai and Bangalore team.• Generating the print feeds for Chennai (twice a week) and Bangalore.• Porting the old data in to the new database using of BCP.• Interacting with the users and troubleshooting the problems involved with the development of stored procedures.• Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints. Show less

• 

  Fujitsu

  Sept 2011 - Apr 2013

  Sr. IT Consultant - IMS

  • Performing the MSSQLServer failover Cluster and monitoring the failover cluster for any critical events and verifying the windows and MSSQLServer logs.• Performing the database TSQL Procedure Execution with Admin Rights on demands from application team.• Performing Instance De-installation and Deactivation of MSSQLSERVER instances.• Perform Instance Check Recover Ability and health check based on the alerts generated by Systems Center Operations Manager 2007 and centralized database server (INFODB).• Installation of MSSQLServer 2005/2008 instances on windows server 2003/2008 with 2 - node MSSQLServer 2008 cluster.• Instance migration from one version to another version.• Managing the User Privileges Administration.• To review document attached with the ticket for every upgraditions or installation. • Monitoring the Instance Performance Analysis Performance tuning.• Patch Rollout, Service packs and Hot fixes on MSSQLServer.• Monitoring and setup of MSSQLServer daily and weekly Maintenance Plan.• Performed database restore, refresh, and recover activities as needed.• SSIS Configuration changes.• Preparing the RCA for critical incidents and tasks.• Handling critical incidents and tasks. Show less

• 

  Bureau Veritas Group

  Aug 2013 - Sept 2014

  Sr. Database Administrator

  • Working on the POWERSHELL solution to monitor the database alerts.• KT transfer from list of activities for LAZ and NAZ with implementation of sql maintenance plan.• Performance Tuning – Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance for LAZ environment.• Working with L3 transition for EUA zone in transferring the activities to Noida location. This activity is in progress.

• 

  Aristocrat Gaming

  Sept 2014 - Apr 2016

  Sr. Tech Lead – Global IT
• 

  Fidelity International

  Apr 2016 - now

  • Senior Technical Consultant

    Oct 2019 - now

  • Technical Consultant

    Apr 2016 - Oct 2019