Manager Sql
Resume:
CURRICULUM VITAE
ASHISH SHARMA
Email: - ******.***@**********.*** or **********@*****.*** Mobile: - 809-***-**** (Bangalore) OBJECTIVE AND PROFESSIONAL EXPERIENCE:
Objective:
Seeking a professional position which comes with challenges and opportunities where my knowledge can be shared and enriched believing in performance with perfection. Professional Experience:
Over 14.5 years of Production support & Administration experience in various computing environments.
Over 13 years of experience in DBA-MS SQL Server this comprises working extensively with MS SQL Server 2000/5/8/8R2/12/14/16/17/19 upgradation (both-side by side and in-place, Oracle, PostgreSQL, DTS/SSIS/SSRS/SSAS package, Clustering (Active-Passive), VM, Log shipping, Mirroring, Replication, CDC, dynamic data masking, MDS, Cassandra, MySQL, Fog-light, NSM, TSM, JIRA, GIT, TDPSQL, IDERA, SOX, SCOM, ATOS, Cornerstone, SM9, HPSM, IBM Q-Rader, DB Encryption, Lite-Speed, PowerShell scripts, Automation, third party tools (Oracle, Access, DB2 etc.), spotlight, AWS, GCP, AZURE, batch files, ansible tower, artifactory, OpenText, and analysis deployments.
CURRENT RESPONSIBILITY: Principal Cloud Database administrator (SQL, PostgreSQL, Oracle etc.)
Working on all P1/P2 issues related to SQL DB servers, Databases, call and share the RCA
Involved in client and Onsite/Offshore co-ordination for the resolution the issues.
Part of Cloud provisioning team and On-boarding new customers to our Cloud environment.
Working on weekend, On-call support for Production issues.
DB server’s installation, Upgrade, Downgrade, Planning, Design, Documentation, Track Project Milestones and End to End responsibilities for the DB servers and Databases
Databases Backup and Recovery, Refresh, Upgrade, Migrations etc., CLOUD-GCP, AZURE and AWS.
Working extensively with other Databases (Secondary skill)-PostgreSQL, Oracle, Cassandra etc. PREVIOUS RESPONSIBILITIES: SME/TL/ DB Migration Planner/ DB Server Manager/Project Manager
SME/Tech Lead/DB Migration Planner/DB Server Manager/SPOC and handling 25 team members
DB server manager for 167 SQL DB servers (Shared environment)
Hotel SQL DB servers (more than 2400DBs) Migration Planner/Manager- (SQL server 2008/2008R2 to 2012/14/16/17) –Planning, Design, documentation, Client communication and implementation.
Experience in interviewing the NEW Hires and IJP (internal job posting) candidates.
Experience in handling internal and external calibration with clients and stake holders
Delegate tasks and responsibilities to appropriate personnel.
Track project milestones and deliverables.
Working on all P1/P2 issues related to SQL DB, call and share the RCA
Involved in client and Onsite/Offshore co-ordination for the resolution the issues.
Managing teams working in “24x7” in shifts supporting and on Production, Test and Development environment.
Supervise; motivate members to achieve high level of customer satisfaction.
Planning for project related Knowledge Transition for new team member.
Scheduling and managing weekly team meeting with Onsite and Offshore.
Managing Shift Roster and Leaves for the Team.
AS CORE SQL PRODUCTION DBA:
Upgraded Databases from SQL Server 2000 to 2005, 2008/R2 to 2012 and 2008/R2, 2012 to 2014/16/17
Working extensively with other Databases (Secondary skill)-PostgreSQL, Oracle, Cassandra etc.
Installed & configured database software, associated database tools and performance monitoring software.
Estimated disk storage requirements for database software, files & administration needs.
Implemented & managed database clustering, failover and load balance technologies as per client requirement.
Developed, tested & implemented a database backup and recovery strategy with client assistance.
Did pre- or post- restore activities (e.g. data loads).
Conducted root cause and analysis for database incidents and problems.
Participated in designing, testing and implementing an Enterprise Disaster Recovery Plan.
Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
Adhered to Change Control Procedures.
Developed & executed Change Requests in accordance with change control procedures.
Set up security and access profiles and procedures for database system administrators.
Worked on MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node.
Proven ability to handle Databases of more than 12TB in Size. Managed security by defining roles and rights.
Exposure of working on different countries clients -IND, NASD, HK, RDC, NESD and MESD, VOLVO IT (SWEDEN).
Experience as Co-corporate trainer and Technical Panelists. ACADEMIC QUALIFICATION:
Master of Business Administration (MBA)
Sikkim Manipal University, 2011.
Bachelor of Science (B.Sc.)
Tinsukia College, Assam, 2005.
TECHNICAL SKILLS AND CERTIFICATIONS:
Technical Skills:
Databases: MS-SQL Server 2000/2005/2008/2008R2/2012/2014/2016, SSRS, SSAS, T-SQL, Triggers, Stored Procedures, ODBC drivers, DTS, DDL, DML, Backup/Restore, Bulk Copy, Indexes, Server Setting & Configuration, DB Optimization, ADO and OLE DB.
Languages: C, C++, Java and UNIX.
Packages: MS Office, Web applications.
Networking: Networking with Windows NT, Assembling of PC, Troubleshooting and Installation of Software.
Certifications:
Certificate in Computer Application (CCA) from NEiit, Assam, 2002.
Computer Hardware and Networking (CHNC) from TATA INFOTECH EDUCATION, Assam, 2003.
Certificate in C Programming and Java from Third Eye Computer Education, Assam, 2005.
LinkedIn-AWS, SQL performance
GCP Participation Certificate-Cloud in Air #Google Cloud Solution On-site Experience:
Been to SWISS for 3 months for MESD (UK and SWISS) KT and L3/L4-Projects. CAREER PROFILE:
OpenText, Bangalore, India -Principal Cloud Database Administrator 08/2019 To Present OpenText Corporation is a Canadian company that develops and sells enterprise information management software. OpenText, headquartered in Waterloo, Ontario, Canada, is Canada's largest software company as of 2014 and recognized as one of Canada's top 100 employers 2016 by MediaCorp Canada Inc. Roles & Responsibilities:
Working on all P1/P2 issues related to SQL DB servers, Databases, call and share the RCA
Involved in client and Onsite/Offshore co-ordination for the resolution the issues.
Working on weekend, On-call support for Production issues.
DB server’s installation, Upgrade, Downgrade, Planning, Design, Documentation, Track Project Milestones and End to End responsibilities for the DB servers and Databases
Databases Backup and Recovery, Refresh, Upgrade, Migrations, Cloud-GCP, GIT and AWS etc.
Working extensively with other Databases (Secondary skill)-PostgreSQL, Oracle, Cassandra etc. HCL Technologies, Bangalore, India -Associate Consultant (SME)- Snr SQL DBA 04/2017 To 07/2019 HCL Technologies is an IT company dealing in IT projects. I am a Database Administrator for SQL DB servers. I am working as Associate Consultant for VOLVO IT client and managing and maintaining all SQL DB servers for client application.
Roles & Responsibilities:
I am handling approx. 1200 instances of SQL DB servers 2005/08/08R2/12/14/16/17, AZURE. I am managing Up gradation, DTS/SSIS/SSRS/SSAS package, Clustering (Active-Passive), VM, Log shipping, Mirroring, Replication, CDC and Always-ON. Also, monitoring production DB server having database size 10 GB to 24 TB. I am interacting and coordinating with VOLVO IT for routine maintenance and for gathering new requirements.
Working on all P1/P2 issues related to SQL DB and share the RCA.
Working on Patching, Health report automation and TSM/TDPSQL backup issue.
Working as a SQL Hotel DB Servers (more than 2400DBs) migration Planner -Planning, co-ordination with clients and Implementation.
AXA Technology Shared Services, Bangalore, India Specialist- Senior DBA 11/2011 To 04/2017 A fully owned AXA Group subsidiary, providing AXA Group companies with high quality IT and telecommunications infrastructure management services. To manage all AXA client’s companies’ IT foundation, with the delivery of shared infrastructure services-. Global network services, Local and wide area networks, Global security and compliance, Database services. The AXA groups of companies engage in life, health and other forms of insurance, as well as investment management. The group operates primarily in Western Europe, North America, the Asia Pacific region, and the Middle East. Roles & Responsibilities:
Tech Lead-Primary Escalation Point of contact (SPOC) and handling 5 team members
Experience in interviewing the NEW Hires and IJP (internal job posting) candidates.
Experience in handling internal and external calibration with clients and stake holders
Delegate tasks and responsibilities to appropriate personnel.
Track project milestones and deliverables.
Involved in client and Onsite/Offshore co-ordination for the resolution the issues.
Managing teams working in “12x5” in shifts supporting and on call support Production, Test and Development environment.
Supervise; motivate members to achieve high level of customer satisfaction.
Planning for project related Knowledge Transition for new team member.
Scheduling and managing weekly team meeting with Onsite and Offshore. Managing Shift Roster, On-Call Roster, On-Call and Shift allowances for the Team
Installing SQL Server 2000/2005/2008/2008R2/2012/2014/2016 on Standalone servers, SSRS, SSAS, CDC, Clusters and VM Environment.
Database creation, restoration, configuration, Logins & Users creation, security (Complete Administration).
Installing latest Service packs and Hot Fixes on the servers from time to time as they are released.
Installing, Monitoring and Troubleshooting Backup/Dbcc jobs on the servers.
Setting up and Troubleshooting Mirroring, Replication and Log shipping between 2 or more servers with different configurations.
Troubleshoot system issues, monitor scheduled jobs and set up maintenance plans for proactively monitoring the performance of all SQL Server databases including monitoring failed and long running MS SQL Server jobs.
Proficiency in using Tools like SQL Compliance Tool (Idera), Foglight, Litespeed etc.
Worked as a primary point of contact for Suwanee and Metro DR (Disasters Recovery).
Work on SOX (Reports, filing and backup set).
Coordinator/PPC for Security Audit project (Hardening-Low, Medium and High, Patching etc.) JPMorgan Services India (Pvt.) Ltd Senior Analyst 04/2008 to 10/ 2011 JP Morgan Co. is an American multinational banking corporation of securities, investments and retail. It is used by the investment banking as well as the asset management, private banking, private wealth management and treasury & securities services divisions. Roles & Responsibilities:
Responsible for maintaining and updating SQL Server UAT, DEV and PROD databases.
Installation and upgrading SQL Server 2000/2005/2008.
Database Restoration and Creation of Logins and Users and adding them to Database and Server Roles for Access control.
Monitoring and maintenance jobs and events.
Responsible for maintaining and updating the data for different process related applications.
Worked on different process related applications- ST, i-Vault, i-GDS, ED and RPS, Classification etc.
Prepared the UAT documentation for different applications.
Do communicate with the client team whenever required and try to solve the issues related to the process.
Reliance Infostearms Private Limited (RIPL) Customer Service Executive 09/2006 to 04/ 2008 RELIANCE BPO as a part of Anil Dhirubhai Ambani Group of Companies at Chennai. Roles & Responsibilities:
Directly responsible for taking escalation calls from Prepaid and postpaid departments.
Assigned responsibility of online activation and deactivation of various services.
Actively involving in assistance of all the other agents in any problem regarding the product and their success.
Met the target in Quality and Customer satisfaction.
Acted as a mentor for new employees.
Queue Monitoring of all the employees.
Maintaining the daily performances of the employees. PERSONAL DETAILS:
Fathers Name: Mr. H. P. Sharma.
Address : Horamavu, Bangalore-560043.
Passport : Valid till July 2029.
I do here by confirm that the information given in this form is true to the best of my knowledge and belief. Yours sincerely
Ashish Sharma
Contact this candidate