SUMMARY

• 11+ years of IT experience in SQL Server Administration in SQL Server 2012, 2008, 2008r2, 2005, and 2000.
• Extensive experience in SQL Server Database Administration in SQL 2012, 2008, 2008r2, 2005, and 2000.
• Proficient in SQL Server Performance Tuning, Installation, configuration, maintenance, and Upgrade
• Extensive experience in Database High Availability solutions using Mirroring, Log Shipping, Clustering, Replication, and AlwaysOn Availability.
• Strong Knowledge of Storage Area Network (SAN) architecture and technology
• Experience in troubleshooting and resolving database integrity, performance issues, blocking, replication issues, connectivity issues, and security issues.
• Expert in SQL Server Configuration, Maintenance, and Performance Tuning.
• Strong knowledge of Indexes creation and maintenance and application of Service Park, and vulnerability patches.
• Cognizant of Databases security and Hardening.
• Strong experience in monitoring, detecting, and troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention
• Extensive knowledge in Backup - Recovery that meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
• Strong experience in DTS using Business Intelligence tool - SSIS, Confidential, & SSAS.
• Strong Knowledge of installation and configuration of SQL Server performance monitoring tool.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications

TECHNICAL SKILLS

RMDBS: MS SQL Server 2000, 2005, 2008, 2008r2, and 2012.

SQL Server Tools: SSMS, SSIS, SSAS, Confidential, Profiler, Query Analyzer, PerfMon, Enterprise Manager, BI Tools, IBM Tivoli, Redgate, Spotlight, Foglight, SiteScom, HP Polyserve, LiteSpeed, Symantec Backup, and Quest, etc.

Programing Lang: T-SQL, PL/SQL, PowerShell, Java, C, C++, C#, Pascal, Visual Basic, COBOL, etc.

Operating System: Windows Server 2000/2003/2008/2012 , NT, 95/98/XP, Linux

Migration: SSIS, DTS, BCP, Data Migration, SQL Loader, Import/Export Wizard

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Adhere to SQL Server databases and instance Hardening and security
• Perform 24x7 production support and on call rotation in supporting databases to achieve maximum performance and uptime.
• Ensure all databases are backed up in a way that meets the business’s Recovery Point Objective (RPO).
• Install and configure SQL Server with minimum access privileges for service accounts and logins to improve security and attain high rating in auditing.
• Perform all the Database related activities such as Database Backup, Restore, Migrate, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc.
• Provided optimal database file layout for utilization of storage and performance acceptable to client.
• Implement and manage database clustering, failover and load balance technologies as per client requirement.
• When performance issues arise, determine the most effective way to increase performance - including hardware purchases, server configuration changes, or index/query changes.
• Involve periodic Disaster Recovery exercise in preparation for actual disaster.
• Maintain, configure, and monitor database availability solutions. I.e. Mirroring, Log Shipping, Clusters, and Replication.
• Using free tools, online resource, DMVs, third party tools, and various resources to diagnose performance issues and server reliability.
• Analyze long running slow queries and tune the same to optimize application and system performance.
• Involve in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Adhere to SQL Server databases and instance Hardening and security
• Perform 24x7 production support and on call rotation in supporting databases to achieve maximum performance and uptime.
• Ensure all databases are backed up in a way that meets the business’s Recovery Point Objective (RPO).
• Install SQL Server with minimum access privileges for service accounts and logins to improve security and attain high rating in auditing.
• When performance issues arise, determine the most effective way to increase performance - including hardware purchases, server configuration changes, or index/query changes.
• Conduct and document periodic Disaster Recovery exercise for preparation for actual disaster.
• Maintain, configure, and monitor database availability solutions. I.e. Mirroring, Log Shipping, Clusters, and Replication.
• Using free tools, online resource, DMVs, third party tools, and various resources to diagnose performance issues and server reliability.
• Troubleshoot and fine-tune of databases for its performance and concurrency.
• Analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers and SQL Server using third party software.
• Rebuilding and monitoring indexes at regular intervals for better performance gain.
• Involve in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Provide 24x7 supports for SQL Server databases to achieve maximum performance and uptime in production environment and systems with high availability requirements.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases
• Established and maintained policies, database security, standard operating procedures, and associated documentation for user interaction with the database environment.
• Managed SSIS/DTS packages, stored procedures, jobs, and alerts
• Troubleshooting and resolving database integrity issues, blocking issues, availability issues, connectivity issues, security issues, etc.
• Upgrade of SQL Server from old version to new i.e. SQL 2005 to SQL server 2008/2008r2/2012
• Configured database availability solution like Failover Clusters, Mirroring, Log Shipping, Replication, and AlwaysOn.
• Migrated Database Instances, user databases, user logins, maintenance plan, Jobs, packages, and database objects between multiple servers in Production, Test, and Development platforms.
• Performed Disaster Recovery procedure, performance tuning, Backup/Recovery options, and database Security
• Worked with Application team, Server-OS team, Storage team, Network teams, and Security team to discern, fine-tune, and debug SQL Server and Windows related issues

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Implemented backups to network drive to replace obsolete tape backups.
• Backup windows shortened from as long as 16 hours down to less than 2 hours, enabling company to keep more backups online
• Provided 24x7 supports for SQL Server databases to achieve maximum performance and uptime in production environment.
• Modified and tuned-running SQL queries to cut execution time, ease database load, and improve scalability
• Implemented backups to network drive to replace obsolete tape backups.
• Backup windows shortened from as long as 16 hours down to less than 2 hours, enabling company to keep more backups online
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS
• Aided developers in writing efficient codes and making efficient use of the resources leading to better performance and optimization.
• Supported the data loads into the database and ensure that the application and any enhancements interact efficiently with the database
• Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.
• Recommended database clustering to client for failover in disaster recovery and to enhance database high availability and data protection.

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Worked with the Information Architect and Database Designer to help implement the physical data model. Assisted developed and validated the database implementation plan.
• Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
• Gave recommendations to the management on various hardware and software updates that will enhance production, security, and performance.
• Implemented database refreshment with hot backup using duplicate or full export.
• Used Export/Import to do table level and full database defragmentation.
• Monitored the server for High availability of the servers.
• Participated in implementation of new releases into production.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.

Confidential

System Admin

Responsibilities:

• Provided security and access control by adding, deleting, and assign users previledges
• Oversee network connectivity, implementation, integration, and troubleshooting for servers, routers, remote access, wireless, storage devices, printers, print servers, and scanner for clients and numerous departments on campus
• Earned a reputation for on-time, on-budget completion of high-profile projects involving different platforms of operating systems, connectivity, consultation, and problem resolution
• Networked and deployed of Servers and Workstations as well as adding and deleting users
• Delivered internal design, implementation, cost analysis, and negotiation of current TCP/IP-based network consisting of a point-to-point DS-1, securely connecting companies to the internet and customer WAN via dual Ethernet Cisco router and Nortel Contivity VPN client for windows
• Installation, Configuration, and Troubleshooting of Hardware, Software, DSL, and Router