SUMMARY

• Extensive experience on developing and working with diverse collection of applications and over Seven (7) years of professional experience as MicrosoftSQLserverdatabase administrator (DBA) and developer where effectively planned, installed, configured and optimized the IT infrastructure to achieve the high availability goal and maintained the overall performance of the database systems.
• Expertise in MSSQL Server Database Administration, installation, configuration, monitoring and maintenance with effectively finding and troubleshooting root caused capabilities in both Cluster and Standalone environment
• Proven experience in the areas of Database Performance Tuning using SQL Server Profiler, Execution Plan, PerfMon, Activity Monitor, DMV, DBCC, Extended Events, Database tuning Advisor(DTA) and Policy Based Management
• Strong work experience and knowledge with High availability(HA) solution using Replication, Database Mirroring, Clustering, Log shipping, Always - On Availability - includes Installation, Configuration and Administration
• Experienced in upgrading SQL Server ( 2000/2005/2008 /2008 R2) instances to SQL Server 2012/2014/2016 and migrating (databases) from Oracle, MySQL, MS Access to SQL Server
• Strong knowledge and experience in capacity planning and implementing disaster recovery solutions- database Backup, Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines
• Experience in applying service Pack (SP) and Hot Fixes in Standalone, Mirrored and Clustered environment
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization, E-R diagram and building Referential Integrity Constraints, Operating Systems (Windows server 2003/2008R2/2012R2), AD (Active Directory)
• Excellent T-SQL skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, Temp table, Table variable, Synonyms, CTE etc. and knowledge on HTML, SQLCMD and PowerShell
• Experience on creating and trouble shooting of SQL Server Agent Jobs, Scheduling and set up Alerts and Notification and Database Mail and Proxy Account
• Extensive work experience in Table Partition, Backup Compression, Performance Optimization of Database and server, query Optimization
• Implement Linked Servers configuration within SQL Servers & Other Database platforms, maintain & troubleshoot SQL Server Security
• Experience on troubleshooting locking, blocking and dead locking, log file growth, jobs, server and database related issues
• Solid experience in SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Experience inETL processes, developing,monitoring, extractingandtransformingdata usingSSIS, Import Export Wizard, and Bulk Insert
• Extensive work experience in creating and deploying SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Merge,union all etc.
• Hands on experience on configuring and managing SQL server instances in Azure Environment
• Knowledge and Experience on Third party Tools: IDERA 9.0 and 10.1, Apex, JIRA, TSM and TDP (for backup and recovery)
• Experience on using Team Foundation Server(TFS) for version controlling and internal ticketing, System Center Operation Manager(SCOM) for server monitoring
• Strong knowledge on Domain Controller, Group Policy Management on Windows Server 2008 R2/2012 R2, VMware, Hyper-V, VPN Server, FTP Server and IIS Web Server and storage systems RAID level (ISCSI and SAN)
• Excellent Team player, detailed oriented, strong analytical and problem solving skills and managing large OLTP and OLAP Databases in 24X7 in Production, Test and Development environment

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator(DBA)

Confidential, Dublin, OH

Environment: MS SQL Server 2016/ 2014/2012/2008 R2/2005/2000, MS System Center 2012, Data Tools, Apex, TFS Server, AD, Windows 7/10, SCOM, Sales force, SMC, Windows Server 2012 R2/2008 R2/2003 R2, IIS 8.5/ 8/ 7.5, ESXi 5.5, ASP.NET, Power BI, Java, ETL, UNIX, IDERA 9.1/ 10, Visual Studio 2013/ 2015

Responsibilities:

• Administer MS SQL Server 2016/ 2014/2012/2008 R2 in both Clustered and Non-Clustered Development, Test and Production environment and provide information and solutions for various groups such as Developer, QA, DA, Client, Users
• SQL 2016
• Installed, Configured and manage SQL server 2016
• Migrated databases to 2016 from 2008R2
• Testing and implementing new features such as
• Dynamic Data Masking
• Row Level Security
• Utilization of Stretch database technology
• Live query Statistics
• Query Store and forced plan
• Set up Azure Blob storage and Polybase
• Installation
• Installed, configured and manage SQL Server 2014, 2012, 2008/R2, 2005 & 2000 in DEV, TEST, and PROD environment
• Planning and maintaining installation documentation followed by Microsoft recommended white paper
• Backup/Recovery
• Created and implemented backup strategy in the event of disaster
• Experience in Point-in-Time recovery
• Refresh database in Test, UAT and dev environment based on requirement
• Implemented automated job for database refresh
• Restored system databases in case of corruption
• High-Availability/Disaster Recovery
• Implemented Multi nodes active/passive cluster on 2012/2008R2 to achieve High-Availability
• Configured and maintain Mirroring including Synchronous/Asynchronous options in SQL Server 2014/2012/2008 R2
• Created automated CMD script to configure mirroring for multiple databases
• Implemented database snapshot to use mirror database for reporting purposes
• Configured Log Shipping and implemented secondary Standby database options for reporting purposes
• Configured and maintain snapshot and transactional Replications
• Implemented AlwaysOn technology and use secondary for read only and backup purposes
• Database Security
• Maintain and Troubleshoot day to day database security
• Created custom database and application role when required
• Implemented triggers for security auditing and to capture object definition changes
• Upgradation and Migration
• Planned and maintained step by step documentation before upgradation and Migration
• Utilized upgrade advisor to generate and analyzed report before upgrade
• Upgraded SQL Server 2000/2005/2008 R2 to 2008R 2/ 2012/2014/2016
• Implemented Side by side and In place upgradation
• Used SSMA for data Migration
• Migrated database from MS Access/Oracle databases into MS SQL Server 2008R2/2012
• Patch Management
• Apply SP, Hot Fixes and CU on cluster, standalone and mirror environment
• Create and maintain documentation on SP
• Change Management
• Manage changes including all development related works using TFS (Team Foundation Server)
• Create, Maintain and assign internal projects through TFS
• Script Deployment
• Maintain documentation before script execution
• Suggest developer in case of error
• Implemented standard template and maintain execution log in SQL table
• Data Modeling
• Experienced to work with Data Modular Team on Data Modeling (Logical and Physical)
• Worked on data modeling projects from end to end including generating scripts for objects, Developing Relationship, and Creating E-R Diagram
• Tools used: Toad Data Modeler
• Create and manage Objects, Keys, Schemas, Indexes, Constraints
• Database Monitoring/Performance Tuning
• Monitor Server and database performance using SQL Server native tool such as PerfMon, Profiler, DTA, Activity Monitor, DBCC, Execution Plan, DMV, Extended Events
• Implemented and Scheduled jobs to collect different activities such as database health, file growth, disk space, locking, blocking and deadlocking
• Created Maintenance plan for index maintenance, statistics maintenance and database integrity
• Troubleshooting server/database slowness and query optimization when required
• Use DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance
• Use DMV to find current activities of the server
• Monitor real-time activities on server using IDERA, SCOM and Alerts
• Report Development
• Installed, configured and administer SQL Server Reporting Services (SSRS)
• Developed and deployed DBA Reports and client reports
• Experience on creating drill down report, matrix report, parameter report and sub reports using SSRS
• Developed server performance report using IDERA and PerfMon
• Knowledge on creating report using power BI
• SSIS/DTS
• Create, deploy and manage SSIS Package
• Upgraded SSIS package from older version to newer version
• Loading, Transporting and moving data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server and vice versa using export/import and SSIS
• Used BCP/bulk to load large amount of data
• Login and job transfer during upgradation
• Database Programming
• Extensive knowledge and experience in T-SQL to create and manage database objects such as Keys, Constraints, Trigger, Synonyms, Functions, Stored-Procedures, temp table, table variable, CTE etc
• Created stored Procedure for database refresh using CMD
• Use PowerShell Scripting for table copying and disk inventory
• Work and assist Developers to optimize SQL queries and Store Procedures
• SQL Agent
• Extensive experience in Job creation, scheduling and troubleshooting job failure
• Set up Alerts, operators and db mail
• Created proxy account and execute SSIS package use proxy
• Created different maintenance plan to implement backup, statistics/index maintenance, disk cleanup etc
• Troubleshooting
• Locking, blocking and deadlocking
• SQL Agent Job Failure
• Unexpected growth of TempDB and Transaction Log
• Server Performance Optimization and Query Optimization
• High availability issues
• Login failure and security issues
• Server Virtualization:
• Installed SQL Server on VM and migrating Databases from physical host to VMware
• Worked with Network OPS/Windows Admin for SQL Server Virtualization
• SQL Azure:
• Installed, Configured and maintain SQL Server in azure environment
• Worked in Database deployment, Security Settings and maintenance plan
• Table copy into Azure cloud platform databases
• Miscellaneous
• Worked on Schema comparison using Visual Studio/Apex/Native SQL queries
• Used Extended events to capture real time info
• Implemented table Partitioning for large table in case of space issue and performance
• Worked on Server/database collation change
• Knowledge and experience on Powershell Scripting
• Implemented Policy base management to maintained company standard policy
• Worked on database encryption

SQL DBA/Database Administrator

Confidential, Silver Spring, Maryland

Environment: Windows Server 2012, 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache Tomcat 5.5, SQL Server 2012/2008 R2/2005SSIS/SSRS/SSAS, ASP, ASP.net, Citrix, TFS, SCOM, PHP, AD (Active Directory), JIRA

Responsibilities:

• SQL Server
• Installed, configured and managed SQL server instances in business critical production, dev and staging environments
• Deployed and managed SQL Server (2005,2008R2, 2012) Clustering using Microsoft Clustering Service (MSCS) on windows server 2003 and 2008R2 and 2012R2
• Configured Mirroring with automated failover using witness server and implemented database snapshot from mirror
• Configured and managed Transactional and Snapshot Replication
• Implemented backup/recovery strategy using maintenance plans and TSQL scripting
• Configured and managed log shipping and used secondary for reporting purposes
• Managed database security and troubleshooting security issues
• Created, managed and troubleshooting Agents Jobs, Alerts, DB mail and notification
• Implemented and tested Azure Technology to match company needs.
• Used JIRA for ticketing
• Applied SP, Hot Fixes and CU in Cluster, Standalone and mirrored environment by maintain proper documentation
• Database Up gradation and Migration:
• Planned, Tested and maintained documentation before upgrade
• Upgraded SQL Server 2000/2005 to 2005/2008/2008 R2/2012 both Side by Side and In place
• Migrated databases from other RDBMS (MS Access, Oracle, MYSQL) to SQL Server 2008R2 using SSMA
• T-SQL:
• Created and modified different database objects like tables, Views, Indexes (Clustered/Non-Clustered), Constraints, Triggers, Stored-Procedures etc.
• Created automation scripts for server and database maintenance
• Wrote complex Select query using temp table, table variable, Joins etc for reporting purposes
• Assisted Database Developers to optimize and Troubleshoot TSQL codes
• Reporting
• Installed, configured and managed SQL Server Reporting Services (SSRS)
• Developed and deployed reports, developed ad-hoc reports using Report Builder 3.0, 2.0, BIDS (Business Intelligence Development Studio)
• Maintained Report server Security
• SSIS and SSAS:
• Created, deployed and managed SSIS Package
• Implemented and Scheduled Agent jobs using SSIS packages from file systems.
• Loaded data from different sources to SQL Server using Export/Import, BCP, Bulk Insert
• Maintained SSAS Cube security
• Performance Tuning:
• Monitored Server and database performance using SQL Server native tool such as PerfMon, Profiler, DTA, Activity Monitor, DBCC, Execution Plan, DMV, Extended Events
• Created Maintenance plan for index maintenance, statistics maintenance and database integrity
• Troubleshooting server/database slowness and query optimization when required
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance
• Used DMV to find current activities of the server and Generated performance report using Perfmon
• Helped developers to optimize queries
• Developed Database Maintenance Plans for various purposes like backups, integrity checks and health checks, index managements and updating statistics
• Managed 24 X 7 dedicated environment

SQL DBA/Database Administrator

Confidential, Seattle, WA

Environment: Windows Server 2008 R2, 2003, 2000, IIS 6.0, SQL Server 2008/R2, 2005, 2000, ASP, PHP, AD (Active Directory), Internal (Registration System, Reporting System) and third party applications (Timesheet, Payroll, HR)

Responsibilities:

• Installed, Configured and Maintained SQL Server 2000/2005/2008 , /2008R2 in DEV, DEV and PROD environment
• Managed Backup/Restore, Point-in-Time Recovery including backup verification and database security
• Implemented different types of Replication Models (such as Transactional, Snapshot)
• Implemented high availability solutions such as Log shipping and Database Mirroring
• Applied SP (Service Pack) and patches on SQL Server 2005, 2008r2, Windows Server 2003, 2008r2 Enterprise Edition
• Maintained Server and database performance using native Tools
• Worked on database Performance tuning, Server tuning and Query optimization
• Strong working experienced in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers etc
• Managed Database Backup, Restore and Point-in-Time Recovery process based on RPO/RTO.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Installed and Configured SSRS and Generated Report using SSRS/Report Builder
• Loaded data from Excel/Flat/CSV files, and Oracle to SQL Server Database using DTS, SSIS, and BCP utility