SUMMARY:

• Senior MS SQL Server DBA with Extensive knowledge in Managing SQL Server environment
• Over 7 years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2014,2012,2008 R2, 2005 in Production, Development & Replication Environments
• 6+ years of experience in installation, configuration, and maintenance of MS SQL Server 2014/2012/2008 R2/2005
• 2+ years of experience in setting up AlwaysON Availability groups with SQL Server 2012
• 4+ years of experience as a MS SQL Server Developer with extensive practical knowledge of SSIS, SSRS and SSAS
• Proficient in upgrading and migrating from SQL server 2005/2008 to SQL server 2008 R2/2012/2014
• Expert in working in Virtual Environment using VMWARE for SQL Server
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification
• Extensive practical understanding of maintaining High Availability and Disaster Recovery using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2008 R2/2005/2000 to provide robust database solutions
• Expert in Active/Passive and Active/Active Clustering
• Proficient in implementing database mirroring which includes Synchronous and Asynchronous Mirroring
• Expert in implementing Log Shipping for Disaster Recovery and Reporting
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
• Effective knowledge of SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity
• Proactively manage SQL server using PowerShell scripts
• Hands-on experience with Migration of Databases to AWS Technology
• Adept at managing security of SQL Server 2000/05/08/08 R2 by creating Database Users, Roles and assigning proper permissions according to business requirements
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP)
• Expert level skills in Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, and Upgradation from previous versions

TECHNICAL SKILLS

TECHNICAL SKILLS: MS SQL Server 2014/2012/2008 R2/2008/2005, Windows Server 2012 R2/2008 R2/ 2008/ 2003, SSIS, SSRS, SSAS, Erwin 4.0/3.5, Star Schema Modeling, OLAP Tools, SQL, PL/ SQL, PowerShell, Visual Basic, TOAD, SQL* Loader, IDERA Diagnostic Manager, Apex SQL Monitoring Tools

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior SQL Server DBA

Responsibilities:

• Work primarily as a Production support DBA giving 24/7 Support
• Manage Production, Development, QA and UAT environments
• Work extensively across 90 servers and on more than 100 databases with OLTP Database Size 2 TB in Physical and Virtual VMware Environments
• Carryout Performance Tuning on Production, QA and Staging servers
• Manage Production environment for High Availability in Active/Active and Active/Passive mode
• Maintain various databases for Production and Testing using SQL Server 2014/2012/2008 R2
• Upgrade SQL Server 2008 instances to SQL Server 2008 R2 and SQL Server 2012/2014 environment
• Implement AlwaysON availability groups
• Disk-location planning of data, index and transaction log files on the disk (SAN)
• Work extensively with SQL server Profiler for performance problems and bottlenecks
• Create Backup and Restore strategy for production and development environment
• Design ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.)
• Load data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Database Integrity Checks, Update Database Statistics and Re-indexing
• Use SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Create and schedule SQL Server Integration Services (SSIS) packages
• Manage schema objects such as tables, views, clusters, indexes, procedures, triggers
• Maintain referential Integrity depending on user requirements and convert them into technical specifications
• Execute backup and restore strategy for SQL, SSAS production and DR environments using PowerShell and T-SQL
• Heavy migration using SSIS, DTS and Data Integrator
• Create Linked Servers for data retrieval using OLE DB data sources and providers

Environment: MS SQL Server 2014/2012/2008 R2, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003, VMWARE, Clustering, Mirroring, Log Shipping, Replication, AlwaysON, IDERA, PowerShell, RedGate, ERWIN

Confidential, Bloomington, IL

Senior MS SQL Server DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service packs
• Identified, tested and resolved database performance issues to ensure data optimization
• Managed Production SQL Servers on VIRTUAL and PHYSICAL environments
• Installed and Configured SQL Server 2005/2008/2008 R2
• Provided 24/7 support and maintained 99.999 uptimes depending on the application and business SLA requirements
• Involved in database design, database standards, and T-SQL code reviews
• Configured Active/Active and Active/passive SQL Server Clusters
• Implemented Mirroring and Log Shipping for Disaster recovery
• Executed transactional and snapshot replication
• Identified bottlenecks using tools like SQL Server profiler, Performance Monitor
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2
• Involved in troubleshooting all the performance issues for different database applications
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications
• Monitored and scheduled jobs on production and staging environment
• Carried out troubleshooting to minimize SQL Server Performance issues like blocking, deadlocks and long running queries using SQL Profiler and Index Tuning Wizard
• Used the Execution Plan to improve the optimization of the T-SQL code

Environment: MS SQL Server 2008 R2/2008/2005, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003, ERWIN, Clustering, Mirroring, Log Shipping, Data Modeling

Confidential, New York, NY

Senior MS SQL Server DBA

Responsibilities:

• Maintained SQL Servers database servers in Production, Development and QA Environments
• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers
• Implemented Failover clustering for Active/Active and Active/Passive for HA
• Managed SQL Server Clusters in a SAN environment
• Implemented Database Mirroring on SQL Server 2008 environments and configured Log shipping architecture to provide backup server solution for 4 environments for DR/HA
• Implemented Transactional replication for data refresh and managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL Profiler, Execution Plan and Query Tuning Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Implemented Database Mirroring on SQL Server 2008 environments
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution
• Created the standard documents for Disaster recovery testing and implemented the documents
• Experience with database sizing and capacity planning for production servers
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers
• Designed SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Worked with Developers to create database schema changes and database restore requests

Environment: MS SQL Server 2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008, 2003

Confidential

SQL Server DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008/2008 R2 on standalone and clustered environments and applied service pack
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Database Statistics and Re-indexing
• Planned the complete Backing up of Database and restoring the Database from Disaster Recovery
• Planned and modified the permission issues in the server
• Worked with SQL Server Reporting Services (SSRS)
• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing
• Created tables, views, indexes, cursors and stored procedures
• Involved in creating data models and designing logical and physical models of database
• Designed system models using UML and ER Diagram
• Carried out performance tuning, and optimization of procedures and queries
• Worked closely with the Developers’ team and the end users while the system is being under development phase

Environment: MS SQL Server 2008 R2/2008//2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2003