SUMMARY

• Microsoft Certified Professional in Administering SQL Server 2016/ 2014/2012/2008 R/2008 with 8 years of experience as a SQL Server DBA in managing production and non - production environment.
• Experienced in core DBA tasks; such as installation and configuration as well as designing and implementing disaster recovery procedures.
• Hands on experience in Log Shipping and Database Mirroring.
• Possesses over 3 years of experience with patching and server virtualizations, previously responsible for upgrading and installing patching on operating system and applications.
• Well experienced on troubleshooting performance problems, fine-tuning of databases, and index analysis.
• Strong experience in mentoring team members and writing detailed documentation.
• Excellent problem-solving abilities, team player, ability to learn new emerging technologies & adapt quickly.

TECHNICAL SKILLS

RDBMS: SQL Server 2016/ 2014/2012/2008 R2/2008

Database Tools: SSIS, SSRS, DTS, BCP, ODBC, SQL OLEDB, Business Intelligence Studio, Data Service, Crystal Reports

Languages\Tools: Visual Basic, PowerShell, T-SQL

Operating Systems: Windows Server 2012, 2008R2, 2008, Windows 10/8/7

Modeling Tools: MS Visio and Erwin

Monitoring Tools: SQL Profiler, Performance monitoring and activity monitor

Third Party Tools: TOAD for SQL, LiteSpeed, Redgate, SQLcompare, SQLSafe and spotlight

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP

Other Tools: MS Visual Source Safe, Source Control, MS Visio, VMware, Jira, SharePoint, MasterData Services (MDS), Active Directory

PROFESSIONAL EXPERIENCE

Confidential - Asheville, NC

SQL Server DBA

Responsibilities:

• Managed, monitored, installation and security of company databases.
• Worked with Infrastructure Team on system incident reports.
• Imported and exported data in support of customer implementations and requests ETL.
• Training and Development of Database Team to support existing system(s).
• After hours on-call, maintenance, and release availability required.
• Ensured database integrity, stability, and availability.
• Maintained database backup and recovery strategies.
• Configured 2008R2 Pear to Pear replication.
• Designed infrastructure changes for growth and high availability/disaster recovery strategies (HADR).
• Enabled transparent database encryption (TDE) on a new server.
• Exported server certificate and performed database cloning.
• Administered SQL Server Reporting services (SSRS) including report design, advanced scheduling, and integrations.
• Strong Transact SQL (T-SQL) programming skillset including writing stored procedures, functions,and maintenance scripts.
• Performance tuning of complex stored procedures and database objects.
• Skilled at identifying bottlenecks, design challenges and creating solutions.
• Worked closely with Development and QA teams to optimize code and efficiency.
• Monitored a SQL server daily database activity summary.
• 24x7 Production on Call Support and performed other duties as needed.

Confidential - Pasadena, CA

SQL Server DBA

Responsibilities:

• Installed, configured, administered SQL Server 2014/2012/2008 R2 production and development environments.
• Worked on clustered virtual host and migrated to other hosts during the patching process.
• Responsible for upgrading and installing patching on operating system and applications.
• Determined if the patch corrects a problem or if it is a value that will benefit the company.
• Reviewed the software dependencies and proof-of-concept test in a lab environment before the patch is applied to production system.
• Monitored and managed the Table spaces and data files growth. Analyzed Tables & Schemas, collectedsystem statistics and rebuilt indexes.
• Installed maintained & monitored production SQL servers and made sure they were up-to-date with latest rollup hot fix and service packs.
• Installed and configured windows server 2012 failover clustering Active/Passive and configured Always-ON for High availability and (DR) disaster recovery solutions.
• Designed and implemented log shipping, mirroring, and replication from primary site to the secondary site to support mission critical applications and offload queries.
• Migrated multiple databases, SSIS packages, SSRS reports, SSAS cubes between different SQL versions 2014/2012/2008 R in both in In-place and Side-by-Side migration methods.
• Moved several existing production databases, jobs, packages, reports, linked server, logins, and other computer objects to new versions of SQL server.
• Worked closely with application team, development team and infrastructure team for planning and Implementation of the migration and for new application requirements\releases.
• Experience on performance tuning, optimization of stored procedures, and queries.
• Responsible for database Maintenance tasks such as index fragmentation, DBCC operations, monitoring performance and optimizing queries for maximum efficiency.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Migrated new database structures (tables/indexes/stored procedures) from test to production environment.
• Automated database refresh from production to test using custom scripts.
• Set up linked servers between SQL servers, DB2, and Oracle data sources.
• Supported VMware and SharePoint back-end databases.
• Created databases, Logins, Roles and granted appropriate permissions.
• Worked with offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
• Developed and deployed SSIS packages and SSRS reports.
• Managed windows and SQL database users/groups accounts using Active Directory.
• Handled day to day support tickets and development issues.
• 24x7 Production on Call Support and performed other duties as needed.

Environment: SQL Server 2014/2012/2008 R2, Windows server 2012/2008R2, Backup Utility (netbackup), SSRS/SSIS, Quest, SQL Litespeed, Idera technologies Like SQL secure, VMware, SharePoint, Master Data Services (MDS).

Confidential - Rockville,MD

SQL Server DBA

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from users.
• Performed Day to day database maintenance operations, SQL server database backup & restore, point in time recovery, job scheduling in a real-time production and Stage environments.
• Oversaw backup, clustering, mirroring and failover and send (automate) daily status report and confirm that the database is up and running as expected.
• Involved in partition of the tables, Index to improve the performance, estimated the table space to hold the ETL process and bulk data flow from source to target.
• Fine tuning of database objects and server to ensure efficient data retrieval.
• Involved in performance tuning, optimization of stored procedures and queries.
• Troubleshoot database performance issues and tune database objects by using traces and profiler.
• Proficient in working with production change management and change control procedure.
• Developed various T-SQL stored procedures & functions for data validation process.
• Created and maintained various databases for Production, Development and Testing using SQL Server and planning the location of data, index, and Transaction log files on the disk.
• Supported Development team in deploying and testing the application.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Provided 24x7 support to SQL application developers in implementing the applications on production server.

Confidential- Boston, MA

SQL Server DBA

Responsibilities:

• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, Mirroring, database integrity verification, indexing and statistics updates.
• Implemented the Data Collector to capture the CPU, DISK, Memory counters.
• Implemented table partitioning to improve performance and data management.
• Implemented database and SQL Query Tuning to improve performance of loads.
• Reduced the deadlocks by using the SQL Server Profiler hence the performance of the query is tuned.
• Created automatically running stored procedures for day-end operation using SQL Server agent
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Provided daily support, troubleshooting, monitoring, optimization and tuning of server, and SQL server environments across entire system.
• Created logins and roles with the appropriate permissions.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Successfully implemented database mirroring between Primary server and Mirror Server.
• Implemented log shipping to support DR servers, worked on high availability concepts like and clustering.
• Assisted in maintaining and updating the SharePoint platform.
• Provided 24x7 dedicated supports for SQL Server production server.