Sql Server Support
Resume:
CURRICULAM VITAE
BHUSHAN DHOMANE
Mobile: +60-133******
Skype: *******.*******@****.*** Email: *******.*******@*****.***
*******.*******@**********.***
Objective
To associate with an organization which progresses dynamically and gives me a chance to hone my skills so that I could utilize it for profitable corporate growth and personal development and to be a part of an intellectual team that works towards the growth of the organization.
Technical Knowledge
MS SQL DBA
Overall 6.3+ Years of experience in Software Industry as a DBA.
6.3+ Years of experience in MS SQL Server DBA, 3 years in Oracle and 1 Years in Sybase DBA and MySQL DBA.
Experience on MS SQL server version 2000, 2005, 2008, 2012, 2014 and 2016.
Experience on SQL server installation, upgrade, configuration, patching and hot fixes.
Experience on SQL server Standalone, Clustering, Mirroring, Log Shipping, Replication and Always on HA\DR technologies.
Experience on configuration of SQL server clustering Active/Passive and Active/Active mode.
Experience on configuration of SQL server always on, Mirroring, Log Sipping and Replication for Production, Test and developments environments.
Administering SQL Server High Availability and Disaster Recovery strategies.
Experience in SQL Server Backup, Restore, recovery and migration of databases.
Extensively worked on logical design of DB, estimating table and DB sizing, creating database, creating schemas, database export/import, Partitioning and analyzing tables and indexes and setting up databases parameters
Experience in creation and configuration of SQL Server Jobs, Maintenance Plan.
Extensively worked on SQL Mails, Alerts, Operators, Facets and Audits.
Experience in troubleshooting and resolving database integrity issues, performance issues.
Experience in SQL server DB locking, blocking, deadlocks and DB hanging issue.
Ability to detect and troubleshoot on performance, security, memory, CPU memory, I/O, disk space and Indexing related issue.
Experience in Tuning Adviser, profiler, DMVs, Performance Counters and Resource Governor.
Monitoring and analyzing the SQL error logs and windows logs and take appropriate action
Support and Monitoring of different jobs scheduled in SSMS and Ctrl M.
Basic experience on SSRS, SSIS and SSAS.
Handled 10 TBs of database with environment size of more than 60 TBs.
Provided 24x7 supports and involved in on-call rotation.
Worked in L0, L1 and L2 level database support teams.
ORACLE DBA
Worked intensively on Oracle databases 8i\9i\10g and 11g
Installation of Grid, ASM and Oracle 11G software.
Installation of Oracle firewall and configuration.
Worked on cold\hot backup, RMAN, RAC, ASM and oracle streams.
Checking space related issue and solving it.
Security configuration and users and object managements.
Familiar with Oracle DBA L1 Support tasks.
SYBASE DBA
Knowledge and worked on ASE 12\15, Backup Server and Replication Servers.
Familiar with DB Backup, Restore, User Managements and DB security.
Familiar with SYBASE DBA L1 Support tasks.
Blocking, long running query, DB related issue solving.
User and access Management.
Proactive monitoring of alert log file.
SERVERS
Worked on Windows Server 2003\08\12 and 2016.
Worked on Linux, HP-UX, AIX and Solaris.
TOOLS
IBM Tivoli, Service Now, HPSC, BMC Remedy, ITSM
JIRA, TONE, Control M
Academic Qualifications
Passed B.E. Electronics from P.E.S. College Of Engg, Aurangabad (MH) (2010) [Scored 66%]
Passed 10+2 from Amravati University, Amravati, Maharashtra (2006) [Scored 77 %]
Passed 10th Amravati University, Amravati, Maharashtra (2004) [Scored 77%]
Professional Courses/Training
ITIL V3 Foundation Certified [Registration No :5058326.20278476]
MCSA: SQL Server 2012 [MS Certification ID : 11148297]
AWARD & ACHIVIEMENT
Won Tech Mahindra Bravo award for handling the Database operations, part of Project Celcom IMS during project transition Kuala Lumpur, Malaysia.
Won Best Performer Award for handling, solving incident and maintain lowest SLA in Infra supports operation at Cognizant for Credit Suisse Project.
WORK EXPERIENCE
3. TECH MAHINDRA LIMITED
KUALA LUMPUR [MALAYSIA] From 16th Feb 2015 – Present
Senior Database Administrator (MS SQL and ORACLE DBA)
PROJECT I: CELCOM AXITA BERHAD, MALAYSIA [TELCO]
ROLE: Sr. MS SQL and ORACLE DBA From September 2015 – Present
PROJECT DESCRIPTION:
Celcom Axiata Berhad, DBA Celcom, is the oldest mobile telecommunications provider in Malaysia. Celcom is a member of the Axiata group of companies.
As MS SQL server DBA I am working for Celcom Database support operations, which includes support of SQL server varies from 2005 to 2016. Currently we have Clustering, mirroring, log shipping and replication technologies implemented in infra with more than 100+ database Instances with TB sizes.
As an Oracle DBA, working for oracle database support and administration database version varies from 8i to 12C. Currently we have standalone and RAC, golden gate, data guard implemented in infra with more than 500+ database Instances with TB sizes.
ROLES AND RESPONSIBILITY:
Supports and maintenance of application, development and production database Team.
Create and maintains database environment to support business applications for programming and testing.
Installation of SQL server in standalone and clustering mode.
Upgrade SQL server from 2005 to 2008, 2012 and 2016 version using backup and restore and attached and detached method.
Monitor database upgrades, analyse database upgrade tool logs and supply
Maintains backups, checks its integrity, design database creation scripts, evaluates and set databases parameters etc.
Gives assistance and support to database related issues like performance tuning, locking or database hanging etc.
Patching Entire Celcom DB infra
Working on SQL server Profiler and Tuning adviser.
Extended DBA support on Mobile to ensure zero downtime
PROJECT II: TATA COMMUNICATION LIMITED (TCL), INDIA [TELCO]
ROLE: MS SQL DBA From August 2015 – October 2015
PROJECT DESCRIPTION:
Tata Communications Limited is a global Telecom Indian business conglomerate Tata Group, having much application software use to serve their clients across the globe 24x7.
As SQL DBA I am working on TATA health Care project which is three SQL servers 2012 Cluster and 6 standalone Instance Installation in Data Centre. We have configured SQL server 2014 Always on for production environment. Secondary task was scheduling maintenance and backups Jobs and security configuring. Infra having SQL server 2012\14 on windows server 2012 installed on virtual machines.
ROLES AND RESPONSIBILITY:
Senior Database administrator and responsible for installation and supporting of databases
Installation and configuration of SQL server database in clustering mode.
Configuration of Always on for SQL server 2014
Alerts and operators configuration
Create and schedule maintenance and Backup Jobs
Monitor server health check
SQL Mail configuration
Creation of linked servers for oracle and MS SQL DBs.
PROJECT III: VODAFONE INDIA LIMITED (VIL), INDIA [TELCO]
ROLE: MS SQL DBA AND ORACLE DBA From Feb 2015 – July 2015
PROJECT DESCRIPTION:
Vodafone India Limited is one of the world’s biggest telecom providers in telecom sector, having much application software use to serve their clients across the globe 24x7.
As a DBA I am working on CRM transformation Project which is the building and migration of Vodafone data Centre. It includes Installation of SQL server database in cluster and mirroring and installation of ORACLE Grid Infrastructure, ASM and 11g database on Linux platform and application running on Seibel and MySQL DB.
ROLES AND RESPONSIBILITY:
Installation and configuration of SQL server database in clustering mode.
Create and schedule Jobs
Monitor server health check
Create report and send it to customer
Installation of Grid, ASM and Oracle 11G software
Installation of Oracle firewall and configuration.
Configuration of security and backups.
2. TIETO SOFTWARE TECHNOLOGY LIMITED
PUNE [INDIA] From 13th Jan 2014 – 9th Feb 2015
Database Administrator (MS SQL and ORACLE DBA)
PROJECT I: TELENOR SHARED SERVICES, NORWAY [TELCO]
ROLE: MS SQL and ORACLE DBA From Jan 2014 – Feb 2015
PROJECT DESCRIPTION:
Telenor is one of the biggest telecom providers in Norway, having much application software use to serve their clients across the globe 24x7.
As MS SQL server DBA I am working for Telenor Database support operations, which includes support of SQL server varies from 2005 to 2012. We had clustering and log shipping technologies implemented in infra with more than 50+ database instances.
As ORACLE DBA I am working for Telenor Database support operations, which includes support of Oracle 10 g and 11g databases running on standalone and RAC and golden gate technologies.
ROLES AND RESPONSIBILITY:
Supports and maintenance of application, development and production database Team.
Create and maintains database environment to support business applications for programming and testing.
Installation of SQL server in standalone and clustering mode.
Upgrade SQL server from 2005 to 2008, 2012 version using backup and restore and attached and detached method.
Monitor database upgrades, analyze database upgrade tool logs and supply
Maintains backups, checks its integrity, design database creation scripts, evaluates and set databases parameters etc.
Gives assistance and support to Programmers and QAs in database related issues like performance tuning, locking or database hanging etc.
Review, test and maintain update scripts and upgrade tools and deliver the same
Databases with standard database and supply correction scripts if required
Gives assistance and support to colleagues in Europe and deliver
Implements and maintain CMM-I Quality Management processes for DBMS Activities
Working on SQL server Profiler and Tuning adviser.
Extended DBA support on Mobile to ensure zero downtime
Provide consulting and support to customers with database maintenance Contract
1. COGNIZANT TECHNOLOGY SOLUTION
PUNE [INDIA] From 28th July 2011 – 3rd Jan 2014
Database Administrator (MS SQL and SYBASE DBA)
PROJECT I: BARCLAYS CAPITAL, SINGAPORE [BFS]
ROLE: MS SQL and SYBASE DBA From Aug 2011 – May 2012
PROJECT DESCRIPTION:
Barclays Capital is one of the world’s biggest organizations in capital/financial services, having much application software use to serve their clients across the globe 24x7.
As MS SQL server DBA I worked in production DB operation L1 support team for Barclay’s capital. Which includes support of SQL server varies from 2000 to 2008. We had clustering, log shipping, mirroring and replication technologies implemented in infra with more than 20000+ database instances globally.
As SYBASE DBA I worked in production DB operation L1 support team. Which includes support of SQL server varies from ASE12 to ASE 15.5.
ROLES AND RESPONSIBILITY:
Monitoring of different jobs scheduled in SSMS.
Pro-active Monitoring and Support for both the Primary and Secondary Servers.
Daily Backup and restoring database.
Wholly clustering, Mirroring, Log shipping and Replication environment.
Daily Database Health Check.
Blocking and Deadlocks issue solving.
Identify the root causes of the issues faced and take necessary actions.
Proactive monitoring of alert log file.
Creating user and granting necessary privileges.
Handle IM Call for ongoing mission critical issue.
PROJECT II: CREDIT SUISSE, SINGAPORE [BFS]
ROLE: MS SQL and SYBASE DBA From June 2012 – Jan 2014
PROJECT DESCRIPTION:
Credit Suisse Group is a Swiss multinational financial services holding company, headquartered in Zurich, which operates the Credit Suisse Bank and other financial services investments.
As MS SQL server DBA I worked in production DB operation L1 support team for Credit Suisse. Which includes support of SQL server varies from 2000 to 2012. We had clustering, log shipping, mirroring, replication and Always on technologies implemented in infra with more than 15000+ database instances globally and As SYBASE DBA I worked in production DB operation L1 support team. Which includes support of SQL server varies from ASE12 to ASE 15.7.
ROLES AND RESPONSIBILITY:
SQL Server:
Support and Monitoring of different jobs scheduled in SSMS and Ctrl M.
Daily Backup and restoring database.
Resolving issue on clustering, Mirroring, Log shipping and Replication environment and take appropriate action to minimize loss and less downtime.
Daily Database Health Check.
Checking Blocking, long running Trans Issue and follow with application team.
Attend IM call for ongoing server issue and solving on High Priority.
Identify the root causes of the issues faced and take necessary actions.
Proactive monitoring of alert log files and checks all SQL Server issue.
24 X 7 on call support to different Application Team.
Sybase:
Knowledge of ASE Server, Replication, Backup Server.
Blocking, long running Trans and issue solving and follow-up with application Team.
Attend IM call for ongoing server issue.
Identify the root causes of the issues faced and take necessary actions.
Proactive monitoring of alert log file.
Daily Server Heath Checkup.
Personal Details
Full Name : Bhushan Sudhakarrao Dhomane
Date of Birth : 7th July, 1988
Passport : J1667156 (Valid till July 2020)
Languages known : English, Hindi, Marathi
Present Address : 24-11A, Viva Residency, Jalan Ipoh, Kula Lumpur, Malaysia
Permanent Address : Amravati (MH), India 444901
Declaration
I hereby declare that all the information given above is true and correct as the best of my knowledge.
Date:
Place: (Bhushan Dhomane)
Contact this candidate