SUMMARY

• Database administrator with over 8 years of IT experience and currently working as a SQL DBA at Confidential, MD.
• Extensive experience in installation of MS SQL Server 2014/2012/2008R2/2008/2005/2000 versions.
• Experience on SQL Server In - place and Side-by-Side upgrades from SQL server 2000 to SQL server 2005, SQL Server 2000 to SQL Server 2008 and SQL Server 2005 to SQL Server 2008
• Experience in working with Windows server 2014/2012/2008R2, Windows server 2008, Windows server 2003, and Windows 2000 Server’s.
• Expertise in planning and implementing SQL security, database permissions, users and roles.
• Having hands on experience in troubleshooting issues with SQL Server Agent and scheduled maintenance tasks
• Experience in creating Jobs, Alerts, SQL Mail, DB Mail, schedule DTS Packages and SSIS Packages
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in writing, debugging, and tuning Stored Procedures and Triggers.
• Experience in new SQL Server concepts like Partitioning and encryption.
• Ability and willingness to continue building technical knowledge and skills and mentor Analysts and Administrators to bridge technical or professional skills gaps.
• Advanced communication and professional skills and the ablility to establish relationships across business units.
• Expertise in problem solving, analyzing bugs, defect tracking using JIRA.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience in installing, maintenance of alwayson.
• Experience in configuration, maintenance and troubleshooting of log shipping.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), and SSIS.
• Hands on experience on migrating our servers from SQL to SAP
• Having knowledge regarding memory architecture of SQL Server and their recommendations for better configuration.
• Hands on experience on installing and configuring SQL Server DMVs.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Expertise with Table Design, Index Design and Performance Tuning.
• Hands on experience in performance tuning Using DMV’s.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Using powershell we have scheduled SQL ETL jobs.
• Experience in installation and configuration of SSRS.
• Experience in using tools like profiler and perfmon.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000/2003,2008,2008R2,2012/2014 Windows NT 4.0, Windows XP/98/95.

Languages: T-SQL, OSQL, C#, VB

RDBMS: MS SQL Server 2014, 2012, 2008R2,2008,2005, 2000

OLAP Tools: MS OLAP Services Manager

Data Modelling Tools: Erwin

SQL Server Tools: Enterprise Manager, SSMS, Profiler, Query Analyzer, BIDS

PROFESSIONAL EXPERIENCE

Confidential, Bowie, MD

SQL Server Production Database Administrator

Responsibilities:

• Installed SQL Server 2008/2008R2/ 2012/2014installation on windows 2008/2012/2014clusters
• Installed and configured SQL Server Reporting Services.
• Migrated SQL Server from 2008 to 2012 versions
• SQL Server upgraded In-Place from SQL Server 2005 to SQL Server 2008
• Applied partitioning on few huge databases for better maintenance and performance
• Applied encryption on sensitive databases and documented the process for database refreshes
• Designed SSIS packages to automate the maintenance process
• Tuned existing SSIS packages to perform better
• Experience in installing, maintenance of always on.
• Enhanced the database disaster recovery management and performed drills to fill up any gaps.
• Worked with end clients in capacity planning for designing new environments
• Involved in the configuration and administration of Mirroring.
• Trained the team to expertise in Database maintenance and corruption issues
• Performed SQL health check using DBCC commands
• 24/7 support provided with OFFSHORE coordination.
• Used REMEDY and SAP as ticketing tools
• Communicate with corporate customers via telephone, written correspondence, or electronic service regarding problems identified in Microsoft SQL Server software.
• Troubleshooting issues related to tools, Management Studio/SEM, SQL Agent - scheduled tasks, Maintenance Plans, Import/ Export Wizard, Migration Advisor
• Troubleshooting security and permission related issues.
• Troubleshooting all type of memory related issues (like: out of memory error) and issues related to basic connectivity and full text search.
• Took care of all performance escalation issues like index management and statistics related issues
• Configured and Administered Replication, log shipping, Mirroring and Clustering.
• Performed regular duties like Backups, Restores.
• Created SQL jobs, Maintenance plans and scheduled them as required.
• Configured DB mail setup and notified stake holders of any job failures.
• Resolved SQL connectivity and security issues for technical and non-technical staff.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008/2012, Windows 2003 Server, Windows 2008/2012 Server, SSRS, SSIS, Business Intelligence, T-SQL, DTS, Patrol, BMC Impact manager, SAP-CRM

Confidential, GA

SQL Server Production Database Administrator

RESPONSIBILITIES:

• Client onsite-offshore coordination.
• Preparing and providing required artifacts for different teams to accomplish their respective tasks.
• Acting as the first escalation contact for the team working in database 24/7 production support for the McKesson hospitals.
• Worked, trained and managed teams on all the database activities listed below:
• Installed and trained teams on SQL Server 2008 installation on windows 2008 clusters
• Installed and configured SQL Server Reporting Services.
• Migrated SQL Server from 2000 to 2008 versions
• SQL Server upgraded In- Place from SQL Server 2005 to SQL Server 2008
• Experience in installing, maintenance of alwayson.
• Hands on experience in installing, configuring powershell to our servers.
• Applied Policy Base Management concept to maintain centralize server to monitor company standards.
• Applied partitioning on few huge databases for better maintenance and performance
• Applied encryption on sensitive databases and documented the process for database refreshes
• Designed SSIS packages to automate the maintenance process
• Tuned existing SSIS packages to perform better
• Hands on experience on setting up Merge replication to Windows 2008/2012 Server.
• Enhanced the database disaster recovery management and performed drills to fill up any gaps.
• Worked with end clients in capacity planning for designing new environments
• Trained the team to expertise in Database maintenance and corruption issues
• Implemented SQL fog light in the organization to monitor the health from central server
• Worked with Quest and Idera to evaluate their tools and suggest the management
• 24/7 support provided with OFFSHORE coordination.
• Used REMEDY tool for change management process
• Communicate with corporate customers via telephone, written correspondence, or electronic service regarding problems identified in Microsoft SQL Server software.
• Troubleshooting issues related to tools, Management Studio/SEM, SQL Agent - scheduled tasks, Maintenance Plans, Import/ Export Wizard, Migration Advisor
• Troubleshooting security and permission related issues.
• Troubleshooting all type of memory related issues (like: out of memory error) and issues related to basic connectivity and full text search.
• Took care of all performance escalation issues like index management and statistics related issues
• Worked on performance issues like server wide performance issue, database wide performance and stored procedure tuning issues (with the help of pssdiag, read trace utility and performance dashboard reports)

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, Windows 2003 Server, Windows 2008 Server, SSRS, SSIS, Business Intelligence, T-SQL, DTS, Patrol, BMC Impact manager, SAP-CRM.

Confidential, Baltimore, MD

SQL Server Production DBA

Responsibilities:

• Database Administrator, Database Programming.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• To set up SQL Server configuration settings.
• Backups and Restoration of data/database using a Third Party Tool (SQL Lite Speed).
• Recovering the databases from backup in disasters
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the San backups.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL Lite Speed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.5

Confidential, Chicago, IL

SQL Server Production DBA

RESPONSIBILITIES:

• Testing and analyzing the performance of servers to find the baseline of when the servers will get degraded with the increase in the high volume of data or the addition of newer application to the existing volume of data on fewer databases.
• To analyze the performance of slow running queries using perfmon and SQL Profiler.
• To analyze the execution plans of slow running queries to find the root cause of its slowness and correct the issue as per the results/report obtained from the research.
• To fine tune Queries by removing bookmark/Key lookups and RID lookups and to reduce the cost of the utilization of system resources.
• Monitoring SQL 2005 and 2008 systems using DMVs, profilers and perfmons.
• Installed and configured SQL Server 2005 and 2008 Database, Integration and reporting Services.
• Migration of databases(SQL Upgrade- side by side migration) from SQL Server from 2000 to 2008 versions
• Applied Policy Base Management concept to maintain centralize server to monitor company standards
• Moving of user and system database for disk maintenances and for other planned relocations.
• To setup cluster environment to the current existing standalone SQL instances.
• Documented Disaster Recovery and High availability Plans.
• Applied encryption on sensitive databases and documented the process for database refreshes
• Migration of DTS packages to SSIS. Tuned existing SSIS packages for better performance.
• Worked with end clients in capacity planning for designing new environments
• Communicate with internal application teams to fix any database related issues.
• Troubleshooting issues related to tools, Management Studio/SEM, SQL Agent - scheduled tasks, Maintenance Plans, Import/ Export Wizard, Migration Advisor
• Troubleshooting security and permission related issues.
• Troubleshooting all type of memory related issues (like: out of memory error) and issues related to basic connectivity and full text search.
• Took care of all performance escalation issues like index management and statistics related issues.
• Involved in the configuration and administration of Mirroring.