Sql Server Manager
Resume:
MANMEET SINGH
**********@******.***
SUMMARY:
. 10+ years of experience in the IT industry renders me as a very well
rounded RDBMS specialist excelling both as a Development, QA and
Production DBA
. Strong technical background in utilizing Windows, MS SQL Servers, and
MySQL databases
. Technical leadership on current technologies
. I am very well versed in Performance Optimization, Large-scale
Production Environments and troubleshooting
. Strong analytical skills provide quick resolution to system issues
. Significant background in client/server database design, tuning,
management and system analysis
. Highly proficient in all DBA functions -- including server
installation, configuration, administration, security issues, capacity
planning, backup & recovery, policy & procedures, data manipulation
across all multiple SQL Servers, performance/Tuning, troubleshooting
all databases in all MS SQL Servers & MySQL Databases, Upgrades,
Migration, Extracting, transforming and loading of data using SSIS in
MS SQL Server
. Have excellent knowledge of Database Architecture, distributed
transactions
. More than 10 plus years of experience as a Sr. SQL DBA distinguished
by the ability to multitask effectively and remain calm in demanding,
fast-paced, high-stress situations with tight deadlines
. One year of experience in MySQL database 5.6
. In-depth knowledge of Replication, Clustering, Log Shipping and
mirroring
. Simultaneously worked as hands-on SQL Server and MySQL DBA for
Development, UAT, Production and DR environments
. Took part in Change Control Management, co-ordinate with other team
members in testing and deployment
. Knowledge of using Ticketing system software BMC Service Express and
Service now ticketing System to proper track and escalation issues in
the multiple environments
. Documented disaster recovery plans and participated in disaster
recovery drills for all SQL Servers versions
. Implemented Always On in SQL Server 2012 and failover the listener
from primary node to secondary node
. Successfully tested and implemented Log shipping technique used for
warm backup solution for MS SQL Servers 2005 and 2008 databases
. Experienced in Installation and Configuration of 4 to 8 node Clusters
in 32 bit and 64 bit Active/Active as well as Active/Passive mode on
all versions of SQL Servers
. Experienced in applying service packs, patches & updating instances of
all SQL Servers to latest versions
. Experienced in providing production support for 24x7as a Senior SQL
Server DBA in a very critical environments/applications for a
Pediatric Hospital, Manufacturing and Telecommunications firms. And
also been on on-call system schedule over nights and weekends
. Configured and used SCOM (System Centre Operations Manager), to
monitor all SQL servers
. Installed MySQL 5.6 version on Windows and Linux
. Created documentations for MySQL 5.6 databases i.e. Backup & Recovery
procedures, Maintenance procedures, Replication procedures,
Performance & Tuning procedures, Install & Configuration Job Aid
(SOP), and Monitoring procedures
. Responsible for performance/tuning of all the SQL Server instances and
MySQL Databases
. Installed and setup MyPhpAdmin software on Windows and Linux
environments for MySQL Databases and installed PHP plugin on Window
and Linux too
. Integrated MySQL with Oracle Enterprise Manager
. Created documentation called standard of procedure (SOP), for all SQL
Servers versions
. Strong teaching skills to teach junior DBA's and knowledge transfer to
other DBA's and a team player
. Expert in working with Third party backup tools like Tivoli (TDP/TSM),
to improve performance of backups and recovery
Education:
. MBA in IT October, 2012 - Present
. Master of engineering in Mechanical May, 2010
Certifications:
. MS MCSA SQL 2012
. MS SQL Server 2005 Implementation and Maintenance
. Designing a database Server Infrastructure by using MS SQL Server 2005
. Optimizing and maintaining a database Administrative Solution by using
MS SQL Server 2005
TECHNICAL PROFICIENCIES
. RDBMS:MS SQL Server v6.0 - 2012, MS Access, MySQL 5.6
. Operating System: Windows, Linux
. Software: SQL Server Management Studio for SQL Server 2014 (SSMS),
Business Intelligence Development Studio for SQL Server 2012
(BIDS),Windows PERFMON, Erwin, IBM Tivoli Module (TDP/TSM),Visio,
IDERA, MySQL Workbench 6.1 CE, SCOM (System Centre Operations
Manager), MyPhpAdmin, PHP plugin for Windows and Linux and Oracle
Enterprise Manager
. Hardware: Windows Servers/Workstations, HP Proliants Servers, Dell
Power Edge Servers
. Communication Software:PC Anywhere,Telnet
PROFESSIONAL AFFLIATIONS/VOLUNTEERISM
. Member of Doostang Professional Association
. Member of American society of black engineers
. Volunteer Mentor/Technology Instructor: Assist adults in enhancing
technology skills and employment ability
PROFESSIONAL EXPERIENCE
Children's hospital of Philadelphia, PA July, 2010-
Current
Senior SQL DBA (Consultant)
. Involved in installation of SQL Server 2008R2 and SQL Server 2012 on
clusters in QA as well as in Production environments with Always On
Availability group and added toits cluster ring. Since the data center
move project is also going on in the company so I moved some Dev, QA
and Production servers from one location to another by setting up
database mirroring as disaster recovery plan in there SQL Server as
well as Windows Server 2008 environment
. Successfully installed SQL Server 2008 and 2012 on 4th- node cluster
in the QA and production environments and added it to its cluster ring
in both 2008 and 2012 Windows Cluster
. Setup the Always On Availability group in SQL Server 2012 clustered
environments
. Setup database mirroring on multiple servers with manual failover
. Migrated databases from one server to other on same versions of SQL
Servers as well as different versions of SQL Servers
. Verified the backups and troubleshoot jobs which were failing
. Setup maintenance plans on 325 SQL Servers on Dev, QA and Production
Servers
. Providing 24 / 7 Production support as an On-Call Production support
DBA for all SQL Servers and MySQL Instances
. Configured and used SCOM (System Centre Operations Manager), to
monitor all SQL Servers
. Installed MySQL 5.6 version on Windows and Linux
. Created documentations for MySQL 5.6 databases i.e. Backup & Recovery
procedures, maintenance procedures, Replication procedures,
Performance & Tuning procedures, Install & Configuration Job Aid
(SOP), and Monitoring procedures
. Installed and setup MyPhpAdmin software for MySQL on Windows and Linux
Servers
. Integrated MySQL with Oracle Enterprise Manager
. Created documentation standard of procedure (SOP), for all SQL
Servers versions
. Installed and configured more than 50 SQL servers
Environment: MS SQL Server 2000 - 2012, Windows 2003 Server, Windows 2008
R2 Server, Windows 2012 Server, SCOM 2007R2 and SCOM 2012R2
Campbell Soup Company, NJ August, 2008- June, 2010
Senior SQL DBA (Consultant)
. Provided production/development/QA support for business and mission
critical applications
. Implemented, configured, and administered replication for MS SQL 2005
Servers
. Performed development and production upgrades from system 2005 to 2008
versions
. Responsible for performance/tuning of all the instances
. Designed SQL Server monitoring product to monitor multiple SQL Server
tasks on 2005 and 2008 SQL Servers
. Responsible to assign proper login/user access on instance/database
level
. Upgraded multiple 2005 databases to 2008
Environment: SQL Server 2005 - 2008, Windows 2000/2003
IBM (Consultant at Sprint Nextel & Ericson), NJ January, 2003 - July,
2008
Remote senior SQL DBA (Consultant)
. Provided 24x7 production/development supports for several third party
and in-house applications, which utilized multiple MS SQL Server
databases
. Developed monitoring module to monitor all SQL Servers on the
Enterprise level
. Configured log shipping on 2000, 2005
. Managed and Configured replication on 2000
. Supported application developers and application implementation groups
. Developed, implemented, configured and maintain operational
procedures and programs
. Configured and implemented HA cluster for SQL servers
. Installed integration, analysis, reporting and notification services
on SQL Server 2005
. Managed and administered large volume SQL server databases ranging
from 150 GB and up
. Monitored, troubleshoot and recovered databases all versions of SQL
Servers
. Setup Backup procedures for primary production servers and
synchronized them with DR
. Configured and implement HA cluster, replication, mirroring and log
shipping for SQL servers
. Developed, implemented, configured and maintained operational
procedures and programs, including disaster recovery, system security
. Installed, upgraded, configured and tuned 70 plus SQL Servers for
optimal performance
. Developed routines and procedures for failure over testing, including
Disaster Recovery procedures
. Performed application/data migrations for all SQL Servers databases
. Developed and implemented migration plans, including successful
emergency cutovers
Environment:SQL Server 2000 - 2005, Windows 2000/2003
Contact this candidate