Lead - Database Administrator
synechron
Total years of experience :17 years, 11 Months
Production and Non Production Support (L2 and L3) to all SQL Servers.
Planning and implementation of new SQL Server infrastructure.
Providing day to day support for databases.
Performing deployments on Production, Non-Production and DEVINT SQL servers.
Managing SQL securities.
Upgrading SQL server from 2000/2005 to SQL 2008.
Managing backups and restore of databases.
Managing team of 5 DBAs.
Creating Reports in SSRS.
Senior Database Administrator
• Providing day-to-day Production support for Databases and Applications (Authenex, Khalix, GEMS, TeamMate Applications, etc), with support after business hours and 24/7
• Maintaining high availability for SQL Servers using SQL Server Clustering.
• Installing and configuring SQL Server 2005 and SQL Server 2008 with clustering.
• Handling around more than 350 Databases and 18 SQL Servers with databases around 600GB of data
• Providing Production support with IBM/Microsoft Support Team.
• Creating stored Procedures, triggers, function and SQL Scripts as per requirement.
• Performing Weekly maintenance work including windows patches on Cluster servers.
• Experience in Installation, Upgrade and support different application in the organization.
• Maintaining databases backups and Restores using Data Protection Manager (DPM)
• Handling SQL Server alerts using System center Operation Manager (SCOM) and Server alive.
• Created reports using SQL server reporting services, worked on deployment of reports on production with scheduling and subscription.
• Working on Log shipping and Replication.
• Created SSIS packages.
• Created and managed users account on sql server.
• Resolving various performance issues and running DBCC commands, SQL Profiler.
• Configured database mails and scheduled sql jobs.
Aptara Transforming Content into Knowledge
Duration Aug 2008 - May 2009
Client Aptara -Ecosystem
Technology SQL Server 2005, SQl server Replication Technology, Log shipping
Project Abstract
Aptara helps global enterprises gain competitive advantage through its capabilities in digital media innovation and world-class content production and publishing. As an Insurance domain, it deals with Life, Health, and Accident Insurance.
Ecosystem - Eco-System is an Enterprise wide business application tool covering diverse areas like Marketing, Production, HR, Finance and Client. It's a mini-ERP tool that helps in clients getting visibility into their projects and at the same time helping top management gain insight into the project performances, profitability etc.
Inhouse Development: MindMuze System
Role
SQL DBA
• Installing, configuring, design, development, managing, monitoring and troubleshooting SQL Server 2000/2005.
• Designing Database and preparing ERD Diagrams
• Provided production support for databases and applications and development with around 150 databases.
• Performed database designing, created stored procedures, triggers, functions, etc for various applications.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Created complex scripts for data migration from Excel to SQL Server 2005.
• Created linked server using Access 2003.
• Automating administration tasks like managing the disk space, Updating database Statistics, checking for fragmentation levels, database Integrity checks and rebuilding indexes using jobs and scripts.
Gharda Chemicals Ltd
Duration July 2006 - July 2008
Client Gharda Chemicals Ltd. Lote
Technology SQL Server 2000/2005, Ramco System (ERP)
Project Abstract
Gharda Chemicals Limited is a research-based company with four manufacturing units. It produces Agrochemicals, intermediates, Veterinary drugs and high performance polymers.
Role
Programmer Analyst
• Provided Production supports to Ramco System (ERP) and various applications.
• Design, development, testing, implemented and maintained various in-house applications.
• Designing Database and preparing ERD Diagrams.
• Created databases, tables, stored procedures, functions, triggers, views, indexes in SQL Server 2000 and 2005.
• Performed regular backups and restore using Veritas Backup system.
• Worked on log shipping and Transaction Replication.
• Created Reports using Ramco Report writer and Crystal Reports 7.0.
• Configured database mail for sending required reports on scheduled basis to users and scheduled jobs.
• Performance tuning of stored procedures and UDF's and optimizing of the database.
• Managed SQL server's securities.
• Worked on data migration from flat file/excel to sql server.
VISA: US H1B, US B1/B2
PGDIT (Post Graduate Diploma in Information Technology) Maharashtra Institute of Technology, Pune 2010 with First class with Dist.
Level Board/University Year % Class B.E (Industrial) Vishwakarma Institute of Technology, Pune 2006 66.67 First class with Dist.
H. S. C. Nahata College, Bhusawal; Nasik Board 2002 82.83 First class with Dist.
S. S. C. St. Aloysius High School, Bhusawal; Nashik Board 1999 66.67 First class