Keywords
Skills
- Over 9+ years of experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2016/ 2014/ 2012/ 2008 R2/ 2008/ 2005 in Production, Test, Development, Replication and Cluster Server Environments.
- Expertise in Database Administration on Production Servers with Server Configuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities.
- Experience on High Availability/Disaster Recovery solutions; Failover Clusters and Always On Availability Groups, Log Shipping and Mirroring.
- Experience in Upgrade/Migration of MS SQL Server 2008R2 to MS SQL Server 2012/2014/2016
- Experience in Backup and Recovery, Query Optimization and Security.
- Experience in Installing & configuring the ‘R’ services in MS SQL Server
- MDS application services installation / configuration, administration and support
- Responsible for securing SQL Server, user management, assigning permissions and roles.
- GoAnyWhere (Secure File Transfer) & Citrix ShareFile application Support
- Key Skills:
- SQL Server Administration.
- Participation in project activities.
- Maintaining Production Servers without Fail.
- Working on Clustering Environment.
- Knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for SQL Server.
- Troubleshooting SQL Server Issues.
- GoAnyWhere (Secure File Transfer) application Administration & Support.
- SSRS & SSIS Administration & Support
- Citrix ShareFile application Administration & Support.
Project history
Project-1:
Client : GMAC
Duration : March 2011 to till date
Roles & Responsibilities:
• Installation and Configuration of MS Sql server2005 and Sqlserver2008 in windows 2007 environment.
• Taking all types of backup (full, differential, T- log) and Restorations.
• Fix backup failures and fix resolutions.
• Creating the jobs and troubleshooting the jobs.
• Troubleshooting database availability issues including issues with high tempdb or Transaction log file growth issues.
• Up gradation of SQLServer from 2005 to 2008 servers.
• Experienced with database transformation services (DTS), BCP and Bulk insert for import and export operations.
• Ensuring enough free space in servers.
• Configuring and Monitoring Replication, Log shipping, Mirroring.
• Monitoring & Troubleshooting jobs.
• Restoration of databases for recovery purposes.
• Creating maintenance plans for databases
• Checking for any blocks/deadlocks.
• Resolving Server and Database performance issues.
Project-2:
Client : National Default Exchange service (NDEX)
Duration : December 2009 - March 2011
Roles & Responsibilities:
• Installation and Configuration of Sqlserver 2008 Enterprise edition.
• Giving 24/7 support to SQL Server DB in production environment.
• Designing backup and Recovery plans for point in time recovery.
• Monitoring Log Shipping, Replication, Mirroring
• Importing and exporting data using DTS, Query and Packages.
• Disaster Recovery plan and Test.
• Handled security issues.
• Resolved Blocking, and Dead Lock issues
• File group management and space management.
• Troubleshooting Data and T.Log space issues
• Troubleshooting jobs
• Creating Maintenance plans
Client : GMAC
Duration : March 2011 to till date
Roles & Responsibilities:
• Installation and Configuration of MS Sql server2005 and Sqlserver2008 in windows 2007 environment.
• Taking all types of backup (full, differential, T- log) and Restorations.
• Fix backup failures and fix resolutions.
• Creating the jobs and troubleshooting the jobs.
• Troubleshooting database availability issues including issues with high tempdb or Transaction log file growth issues.
• Up gradation of SQLServer from 2005 to 2008 servers.
• Experienced with database transformation services (DTS), BCP and Bulk insert for import and export operations.
• Ensuring enough free space in servers.
• Configuring and Monitoring Replication, Log shipping, Mirroring.
• Monitoring & Troubleshooting jobs.
• Restoration of databases for recovery purposes.
• Creating maintenance plans for databases
• Checking for any blocks/deadlocks.
• Resolving Server and Database performance issues.
Project-2:
Client : National Default Exchange service (NDEX)
Duration : December 2009 - March 2011
Roles & Responsibilities:
• Installation and Configuration of Sqlserver 2008 Enterprise edition.
• Giving 24/7 support to SQL Server DB in production environment.
• Designing backup and Recovery plans for point in time recovery.
• Monitoring Log Shipping, Replication, Mirroring
• Importing and exporting data using DTS, Query and Packages.
• Disaster Recovery plan and Test.
• Handled security issues.
• Resolved Blocking, and Dead Lock issues
• File group management and space management.
• Troubleshooting Data and T.Log space issues
• Troubleshooting jobs
• Creating Maintenance plans
Local Availability
Only available in these countries:
India
sql sever DBA
