abhishek_dwivedi_resume
TRANSCRIPT
Resume of Abhishek Dwivedi
Personal Information Name Abhishek Dwivedi
Date of Birth 20,08,1985
Marital Status Single
Education History From To University Degree
05,08,2004 05,08,2008 Kalinga Institute of Industrial Technology Engineering
Employment History From To Company Position
01/10/2015 Till Date Micron Senior DBA (L3)
18/01/2012 30/09/2015 Cognizant Technical Lead (Associate)
25/08/2008 13/01/2012 Infosys Senior Systems Engineer
Technical Skills Operating Systems Windows , Unix
Programming Languages T SQL
Databases & Tools SSMS 2000/2005/2008/2008R2/2012/2014,SSRS,SSIS
Other Utilities HP Quality Center, AHD, ECR, HPSM Tool, Change
Management, Lotus Notes, SM7, MS Office Tools, SCOM,
VERITAS Net Backup, Light Speed ,Commvault , HPSC, Service
Now, WebTop, AES, Tomcat, Visual Studio 2010, MS Visio,
Benchmark Tool, Red gate SQL Compare, SSRS, Active
Directory, IIS, MS Excel , AES, Patrol, Splunk ,Solarwinds
,Matrix ,DPM ,OEM , Putty ,SQL developer ,MTDBM2 ,UltraEdit
Certifications
Resume of Abhishek Dwivedi ● MS 070431 Microsoft SQL Server 2005 – Implementation and Maintenance
● MS 070432 Microsoft SQL Server 2008 – Implementation and Maintenance
● MS 070450 Microsoft SQL Server 2008– PRO
● ITIL Certification
● TOEFL/GRE
Project Profile
Company Name: Micron, Singapore Project Description:
L3 level DBA support for worldwide Micron sites responsible for handling database escalations and leading several project related work Client Description: Micron Technology, Inc. is an American global corporation based in Boise, Idaho which produces many forms of semiconductor devices, including dynamic randomaccess memory, flash memory, and solidstate drives. Roles and Responsibilities: I am working in Micron site based out of Singapore. I am part of the project team and responsible for carrying out several project related work apart from providing L3 level operational support for all Micron databases worldwide
● Handling MSSQL 2012 migration project work for critical and complex systems ● Managing data files and transaction log usage ● Troubleshooting tempdb issues ● Troubleshooting replication issues replication latency, reinitialization, agent stopped, row
not found/duplicate row etc ● Creating and modifying publications/subscriptions ● Resolving blocking issues and working with developers to fine tune the query ● Troubleshooting mirroring issues ● Performing failover checklist and fixing common mirroring differences ● Performing mirroring failover using matrix client/powershell/manual/forced ● Working on replication on mirrored databases ● Working on cluster concepts including quorum , nodes and resources ● Performing cluster failover activity ● Coordinating with windows and storage team for various activities like SAN migration ,
blade enclosure relocation , cluster disk migration etc ● Perform database backup / restore manually and using third party tools like TSM , DPM etc ● Performing immediate recovery in case of disaster ● Working on account management and fixing orphan users \other common access issues ● Managing SQL server agent jobs and regular troubleshooting ● Coordinating with Microsoft incase required for common bugs ● Providing L1 level oracle support ● Managing blockings on oracle databases using OEM , putty and SQL developer
Resume of Abhishek Dwivedi ● Provide 24x7 oncall support for mssql and oracle escalations on timely basis ● Monitoring mailboxes and incidents for worldwide sites and responding within strict SLA
timelines ● Working on user requests and open action items
Project Duration: 01,10,2015 to Till Date
* * * * * Company Name: Cognizant, Singapore Project Description:
Project related work for the client along with regular 24x7 operational support Client Description: UBS is a Swiss global financial services company with its headquarters in Basel and Zürich, Switzerland. The company provides investment banking, asset management, and wealth management services for private, corporate, and institutional clients worldwide, and for retail clients in Switzerland as well Roles and Responsibilities: I am working in the client location based out of Singapore. I am part of the PLC project team and responsible for carrying out several project related work apart from the regular 24x7 operational tasks
● Carrying out build for all new\existing MSSQL servers single handedly. ● Working on all aspects of MSSQL server and related products like Analysis services,
Reporting services etc., whilst adhering to inhouse standards. ● Working on migration and up gradation tasks in the environment ● Configuring DR and resolving issues in high availability methods which includes Clustering,
Mirroring, Replication, Log shipping and Always on. ● Approving\Implementing changes primarily over the weekend ● Monitoring work delivery mechanisms (chat channels, change systems and request
systems) for any incoming work ● Manage native and Quest Litespeed managed database recovery model ● Working on performance issues ● Working on adhoc requests like configure SPN’s , configure monitoring ● Working on Service improvements and alert reduction initiatives ● Conducting knowledge transfer sessions and interviews for the new joiners in team. ● Working on documentation and process related work ● Expected to support Sybase servers too
Project Duration: 20,09,2014 to 30,09,2015
* * * * * Company Name: Cognizant, United Kingdom / India
Resume of Abhishek Dwivedi Project Description:
Transition Lead responsible for successful transition from client to Cognizant shared DB team .
Client Description: Kleinwort Benson is a Private Bank headquartered in London, UK Roles and Responsibilities: I had worked on both offshore\onshore locations (Jersey Islands, UK and India) for few months and have been responsible for the successful transition of the project. I have completed the assignment in due time and was solely responsible for performance and maintenance of database stream. I worked for Pega database \ application support. I worked as a Technical Lead for the banking client leading a team of 15 DBA’s based out in Bangalore, India.
● Performing regular activities using TSQL scripts ● Performing Data fixes on Non Prod/Prod boxes across environments. ● Performance Tuning using Profiler , Traces , DMV’s etc ● Handling User management ● Working on Creation/Decommissioning of databases as per the standard client process. ● Performing regular database refresh activities to keep the environments in sync . ● Expertise in solving database contention problems (dead locks, blocking etc.) ● Working on Capacity Planning ● Maintaining and developing SSRS Reports ● Performing Server Restarts ● Working with third party auditors on severity issues and coordinating across teams . ● Installation of Service Packs/ Hotfixes ● Managing server level and database level permissions ● Configuring alerts using Database Mails ● Set up SQL Server configuration settings for better server management. ● Providing SIP by using DAC as a security measure ● Rebuilding / Monitoring indexes at regular intervals for better performance. ● Suggested Disk Capacity, Processors and Memory based on the Capacity planning. ● Setting up of Alerts using third party tools like Solarwinds ● Creating Database – Application Diagram for the whole environment. ● Supporting critical application like Pega Application ● Managing configuration files of Pega Application ● Daily health check of Pega application through Autonomic Event services Tool ● Work on .jar files during Pega deployment activities with application team ● Installation of Tomcat , Java and basic troubleshooting . ● Mapping of Application – Database for the whole environment using Visio ● Represent Database team in the regular weekly Change meetings and client meeting. ● Creation of timely reports ● Providing SIP for the team on regular basis and creating several documents for the team ● Strong communications skills with the ability to clearly articulate and substantiate
recommendations to the application team ● Consultation/Technology Advise to the team
Project Duration: 20,07,2013 to 20,09,2014
* * * * *
Resume of Abhishek Dwivedi Company Name: Cognizant, India Project Description: Production operations support for APAC, EMEA and America regions for the Banking client . Client Description: Barclays is a British multinational banking and financial services company headquartered in London. It is a universal bank with operations in retail, wholesale and investment banking, as well as wealth management, mortgage lending and credit cards. Roles and Responsibilities: I worked as a Technical Lead for the banking client with a massive environment of more than 15,000 critical production databases ranging from few Megabytes to huge Terabytes in size. The environment was severely critical and the DBA team has worked 24x7 including night shifts and weekend shift for the smooth delivery. We have reduced the count of daily database alerts to almost ½ in a year and I was awarded the “Most Outstanding Performer “of the team. I was also awarded the top most rating in my yearly appraisal.
● Managing SQL Server 2000/2005/2008/2012 ● Exposure in Clustering / Log shipping DR methods ● Various automation/permanent fix done in the project to reduce WEBTOP alerts ● Database Auditing ● Managing Authentication Mode of the servers ● Handling client escalations of the team. ● Proficient in large RDBMS Administration ● Server Installation & Performance Tuning ● Security Management ● Troubleshooting Slow Running Queries ● Implementation of SQL Logins, Roles and Authentication Modes as a part of Security
Policies for various categories of users. ● Resolving TempDB full issues and Log full issues within the strict SLA timelines . ● Strong troubleshooting & problem analysis skills proven under highpressure environments. ● Proficient in migration and up gradation of Databases and applying of patches & hotfix. ● Efficient in standardizing best database practices, processes ● Auditing databases for security. ● ITILV Foundation certified and having experience in handling team day to day activities ● Working through Change Management Process and providing RCA, ● Completely following ITIL processes and SLAs. ● Regular Health checks of all servers and DBs ● Responsible for SQL Server installation/repair of SQL Server ● Setting up of log shipping. ● Experience in MS SQL Server upgrades ● Management of shifts / leaves for the team members ● Providing 24x7 support by working in day and night shifts .
Project Duration: 18.01,2012 to 18,07,2013
Resume of Abhishek Dwivedi
* * * * * Company Name: Infosys, India Project Description: Regular Database maintenance support for the Auditing firm Client Description: PricewaterhouseCoopers (trading as PwC) is a multinational professional services network. It is the world's second largest professional services network, as measured by 2013 revenues, and is one of the Big Four auditors, along with Deloitte, Ernst & Young (EY) and KPMG. Roles and Responsibilities: I worked as a Technology Analyst for the client. I was working very closely with the SAPBasis team and the Windows team was also among the chosen few for the project works planned in the environment.
● Worked on some minor application/windows related issues ● Automating regular heath Check of Databases ● Performing Backup & Restore Operation. ● Disk Space Monitoring , Jobs Monitoring/ Job scheduling, ● Managing security logins ● Troubleshooting failures in Log shipping / Clustering setup ● Disk Space Management ● Monitoring and Troubleshooting SCOM alerts / WebTop Alerts ● Raising tickets /Change requests ● Working on Application related issues/ registry settings ● Troubleshooting database performance issues ● Working on Copy Only Backups ● Clustering /Replication/LogShipping ● Query execution /Optimization ( to some extent ) ● Good backend skills in creating SQL objects like Tables, Stored Procedures, Views,
Indexes, Triggers, Rules, Defaults, user defined data types and functions. ● Working on PreMigration Activity planned from Oracle to Microsoft SQL . ● Managing the VERITAS net backups. ● Configuring Database Mails / Jobs / Maintenance Plans and other Automation Activities ● Managing through Cluster Administrator ● Installation/Uninstallation/Repair of SQL server ● Patching and Updates on the database servers ● Perform SQL Server service pack and Windows Service pack upgrades.
Project Duration: 15,01,2011 to 10,01,2012
* * * * * Company Name: Infosys, India Project Description: 24x7 Database support for several clients. We were working as a shared DBA team
Resume of Abhishek Dwivedi Client Description:
● ABB is a multinational corporation headquartered in Zurich, Switzerland, operating in robotics and mainly in the power and automation technology areas. It ranked 158th in the Forbes Ranking (2013).
● The Australia and New Zealand Banking Group Limited, commonly called ANZ, is the third largest bank by market capitalization in Australia, after the Commonwealth Bank and Westpac Banking Corporation.
● Caesars Entertainment Corporation (formerly Harrah's Entertainment from 1995 to 2010) is an American public gaming corporation that owns and operates over 50 casinos and hotels, and seven golf courses under several brands. The company, based in Paradise, Nevada, is the largest gaming company in the world, with annual revenues of $8.9 billion (2010)
Roles and Responsibilities: I worked as systems engineer for the client. I worked with the profile of a shared DBA handling 3 clients simultaneously. I had worked in shifts and have given oncall support on several weekends with a small team of four.
● InPlace Upgrade of Microsoft SQL server 2005 to Microsoft SQL server 2008 done in dev , test and production clustered environments
● Configured Log Shipping. ● Troubleshooting failures in Log shipping / Clustering setup ● Managing file growth for databases ● Raising tickets /Change requests ● Working on Copy Only Backups ● Working on maintenance and security related issues ● Working on Linked Servers / Registered Servers ● Clustering /Replication/LogShipping ● Acknowledging tickets and solving them within the SLA period ● Providing 24x7 support ● Configuring Database Mails / Jobs / Maintenance Plans and other Automation Activities ● Managing through Cluster Administrator ● Index tuning and updating Statistics ● Managing security on Database level and other account provisioning activities. ● Working on startup parameters , trace files ● Partitioning of Tables ● Solved critical production problems and performed point in time recovery plans. ● Installation of Log Shipping ● Cluster Installation ● Perform SQL Server service pack and Windows Service pack upgrades.
Project Duration: 15,01,2009 to 15,01,2011
* * * * * Company Name: Infosys, India Training Duration: 25,08,2008 to 15,01,2009
Email id: [email protected]
Mobile: +6586511610
