| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Cell: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLESQL Server DBAExperience SummaryExperienced on SQL server 2008R2 on Windows 2008R2, SQL server 2012 on Windows 2012, SQL server 2014 on Windows 2012 and SQL server 2016 both in standalone as well as in Cluster.Writing codes, script for Tables.Experienced in Database Designing, Implementation and System Administration using Microsoft SQL Server as well as Windows Servers 2003/2008/2008R2/2012/2014.Strong experiences in Installing/Upgrading/Patching, Memory Configuration and security management.Experience in SQL Clustering on different version of windows Servers.Experience in monitoring SQL server, capturing performance problem and improve performance by tuning Databases.Proactively used Tuning Advisory, Query Optimization plan and Query Execution plan in order to address Database locking, deadlocking and blocking issue.Experience in creating and maintaining Backup and Restore strategy, Replication and Log-Shipping strategy as a part of Disaster recovery.Excellent in Capacity Planning and storage management.Experience in supporting and troubleshooting huge databases performance as well as security problems.Expert in installing different Software both in Cluster and non-Clustered environment.Experience in Security auditing and managing performance monitoring tools.Experienced in Developing and Implementing Project plans in MS Project.Worked as both independently as well as in team-oriented environments.Excellent analytical and communication skills with 24/7 rotated support experience.Create and manage Logins, users, roles and add groups to windows and SQL server.Monitoring database growth activities & and take proactive steps to avoid Transaction Log & Space Issues.Responsible to Monitor and troubleshooting Log Shipping.TECHNICAL SKILLS:RDMS: MS SQL Server 2005, 2008, MS Access 2000/97Programming: SQL, T-SQL C, C++, Java, Java Script, COBOL, ASP, HTMLOperating Systems/Server: Windows 2003/ 2008/2012, Workstation, Windows NT/XP/VISTA/98,Applications: MS Office, MS Visio, Cute FTP, WS FTP and Paint Shop-ProTools: LiteSpeed (Backup Tools), Diagnostic Manager (Idera), Compliance Manager (Idera) SQL native Monitoring tools, NT Performance monitor/System monitor, TSQL, SQL Profiler and SQL Query Analyzer.Veterans Affairs Jun 2017 - PresentFalls Church,VASenior SQL server DBAInstalled, Configured, and Maintained SQL Server 2016, 2014 and 2012 in development, test, and production environment.Build automated deployments through the use of configuration management technology. Deploy new modules and upgrades and complete fixes within the production environment.Make modules ready for production, which entails moving them according to specific procedures and documenting knowledge transfer.Engage in service capacity planning and demand forecasting, software performance analysis and system tuning,Configured and Maintained Fail-Over Clustering using SQL Server 2012.Installed and Configured SQL Server Reporting Services (SSRS).Writing Codes, Scripting for data import export.Developed and deployed different types of Reports using different data sources like SQL Server, Excel, CSV files.Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats.Worked in a fast-paced, dynamic team environment to provide basic administration for Microsoft SharePoint and other enterprise-level content management portals and manage organizational content to meet the needs across multiple project teams.Experience working in the Azure Cloud.Extensive hands-on experience implementing scalable solutions using Azure services: Azure SQL DB/DW, Azure storage.Maintain Azure database, migrate database to AzureConfigured and Maintained Replications, Log Shipping, and Mirroring for High Availability.Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2008 R2 to 2012Migrated MS Access Databases into MS SQL Server 2012 and 2014Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues.Performed database and SQL/TSQL Performance Tuning.Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers.Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.Developed Different Maintenance Plans for database monitoring.Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications.Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check).Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like ERWin, Toad Data Modeler, and SQL Server Data DiagramDeveloped SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data SourcesDeployed SSIS packages to move data across server, move logins, load data from different data sources.Used Imp/Exp Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources.Manual, on Demand and setup jobs for Database Backup, and design backup strategy.Deployed and Restored database including Point in Time Recovery.Monitor Server Activity, Error Log, space usage and solving problem as needed.Virginia Hospital Center July 2011 Jun 2017Arlington, VASQL SERVER DBAUpgrade, Install and support SQL servers including production, Test and developing servers.Troubleshoot issues across the entire stack. Solve problems relating to mission critical services and build automation and monitoring to help prevent problem recurrenceBuild Infrastructure as code automation templates.Leads the release of new software and systems, typically for key infrastructure.Installed and configure SQL server 2005/2008/2008R2/2012/2014 on standalone machine as well as on Cluster environmentInstalled and reviewed SQL server patches as well as service packs.Design and configure Database, tables, indexes, store procedures, functions and triggersTroubleshoot database status, performance, Replication, Log-shipping, Always On Availability as well as various errors on production, development and UAT servers.Configured and deployed Reporting Service.Create maintenance plan for Backup and Restore, performance tune up.Involved in setting up the backup strategy for production, test and development.Experienced in Point-in-time restoring databases in production and development servers.Export and import DTS/SSIS packages for source serve to destination server in all environments.Monitoring SQL servers for performance pro-activelySupport customer and application deployment round the clock.Manage and maintain database security and accessCreate documents for deployment and troubleshot issue for references.Configured database mailing for notification servicesVerizon Wireless Nov 2009 June 2011Warren, NJSQL Server DBA (1s Level Support)ResponsibilityAct as a production support and upgrade DBA, maintained 36 SQL Servers including production, test and development servers.Participate in upgrading/Patching SQL Server 2005 servers and SQL 2008.Upgrade SQL server 2005 to 2008Installed SQL Server 2005, 2008/2008R2, applied service packs and security fix for the servers installed on windows 2003, 2008R2 servers.Installed and configured the MS SQL Fail over clustering for production servers.Involved in setting up the backup strategy for production, test and development.Experienced in Point-in-time restoring databases in production and in development servers.Configured and deployed Reporting Service.Configured the log shipping in production environment to create the backup server.Experienced with SQL Disaster recovery processes and documented the processes.Configured the SQL mail/DB Mail to send email alerts to the operators.Created the maintenance plan for database optimization and integrity checks.Experienced in monitoring\capturing SQL Server performance issue by using Windows Performance Monitor\Task Manager\SQL native Monitor\SQL profiler.Experienced with improving databases performance using execution plan, index tuning wizards and SQL profilers.Analyze SQL server deadlocking, locking and blocking and troubleshoot the root of those issue.Experienced in securing the SQL Servers and assign the permissions to SQL Server users.Actively involve and participate in team meetings and author how-to documents and knowledge base articles for various database related tasksSunTrust Bank, July 2008-Sept 2009Falls Church, VAJunior DBAResponsibilityWorked in Active passive cluster environment.Used log shipping for synchronization of databases.SQL Server 2005 Database Administration.To handle the migration of SQL Server 2005 to SQL Server 2008.Responsible to Monitor and troubleshooting Log Shipping.Update statistics, database integrity check and Backup operation.Wrote and debugged Stored Procedures, Triggers and Functions as per client requirements.Daily tasks of Developer/DBA like space issues on Production and Test Servers and handling maintenance Jobs handling and users permissions.Designed and implemented comprehensive Backup plan and disaster recovery.Worked extensively in Query analyzer and profiler for tuning queries.Performed Performance Tuning of the Stored Procedures.Experience in trouble shooting database issues.Monitoring SQL server performance using profiler to find the performance and deadlocks.Education/CertificationMCITP: Microsoft Certified IT ProfessionalMCTS: Microsoft Certified Technology SpecialistMicrosoft SQL Server 2005/2008/2008R2 Administration Training at Microsoft, DCBachelor of business administration |
