PROFESSIONAL SUMMARY:

• Around 10 years of experience in MS SQL server DBA and looking for MS SQL server Database Administrator position. Have thorough knowledge on MS SQL server 2014/2012/2008.
• Expertise in Managing PRODUCTION Databases on MS SQL Server 2014/2012/2008 R 2/ 2008/2005/2000 in VIRTUAL and PHYSICAL environments.
• Proficient experience in Upgrading and migrating from SQL server 2005/2008/200 R2 to SQL server 2008R2 and SQL server 2012.
• Automated daily weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing
• Expertise in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering
• Experience in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring and Log Shipping.
• Provided 24/7 and On - call Support for PRODUCTION environment
• Expertise in VMWARE and managing multiple SQL Server Instances on VMWARE
• Expertise in In-Place and Side-by-side migration of Data.
• Experience with Always On Availability group set up on windows 2012 servers in Dev/Test & Prod environments.
• Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL Backups
• Used third party tools like Redgate, SQL Litespeed and Netbackup for Backups
• Used IDERA, FOGLIGHT and SQL Sentry for Monitoring and Performance tuning
• Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2008 R2
• Expert in Data Migration and Upgrades
• Expert in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN and INDEX TUNING WIZARD
• Expertise in AWR Reports and having experience in SQL Monitoring to debug the performance issues.
• Extensive use of SQL Server DMV's for Performance Tuning.
• 5+ years’ experience in SSIS/SSRS
• Created heavy duty SSIS packages and deployed the packages from development to different environments.
• I involved in Migrating MYSQL/Oracle/DB2/Sybase databases to SQL Server databases using SSMA tool.
• Administered DB2/Oracle subsystems in Prod, QA, Test & Dev regions.
• Worked heavily on SSIS transformations and laid out strong SSIS packages
• Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance of multiple SQL server environments.
• Performed Capacity Planning, Data Modeling and Logical/Physical database design.
• Performed Logical/Physical Modeling and Reverse engineering with ERWIN and VISIO
• Experience in developing and managing Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Locking.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency.
• Experience in resolving Database Performance, Capacity and Distributed data issues.
• Strong in Power Shell scripting and automating day to day maintenance tasks using Power Shell scripts, converting existing TSQL batch scripts to Power Shell scripts and improving SQL Server maintenance jobs performance.
• Created extensive reports using SSRS ( Tabular, Matrix)
• Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS and Data Warehouse concepts.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2005/2000 , Windows 98/ XP/ Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise ManagerQuery Analyzer, Business Intelligence Development Studio, and SSIS

Web Technologies: XML, HTML, JAVA Script

RDBMS: SQL Server 2012/2008R2/ 2008/2005/2000 , MS Access

Languages: T: SQL, C, and JAVA

Networking: TCP/IP, Named Pipes, VIA

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Other Tools: Lite Speed, Spotlight

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Server DBA/Production Support

Responsibilities:

• Installed and maintained GLOBAL (North America, South America, Europe and Australia) regions SQL servers 2012 on Windows 2012 both Enterprise and Standard editions and also worked extensively on applying CU patches and Security Hot-fixes on 2012 and 2008 R2 servers.
• Maintained 130+ GLOBAL SQL servers 2012, 2008 R2 and 2005 on Windows server 2012, 2008R2
• Installed and Maintained SQL server 2012 Azure servers.
• Worked on Gathering SQL project request requirements which include Analysis, Definition Execution and Project Management.
• Administrated the SQL Server 2012/2008/2005 servers in Production, QA and Test and Development databases and Performance Analysis/tuning.
• Installed and maintained SQL 2012 Active/ Passive cluster environments for the production servers.
• Worked on SQL Change Ticket creation/ Approval as per the clients work activity.
• Worked on SQL Customer Escalations - Level 3.
• Worked on several Vendor projects for Confidential clients simultaneously through PMO requests and worked also as a Project Manager for the projects.
• Extensively worked on GO-Live Application support related projects for Confidential Customers.
• SQL server 2012 new Cluster build for the Clients. Involves migrating Servers/ Databases from Old Environment to New Environment ( migrations).
• Worked on SQL server 2005 / Windows server 2003 refresh projects which are migrated to SQL server 2012 on Windows server 2012.
• Extensively worked on MSBI 2012 environment which includes setup of MDS and DQS environment along with SSIS, SSAS & SSRS.
• Worked on setting up the SharePoint 2013 environment and also on TFS environment.
• Worked on SQL server capacity planning process and Architecture reviews and BI Analysis services/ SSAS cube migrations and SSIS catalog and package deployments.
• Implemented SSAS Backup strategy for all BI Supported servers for both Multi-Dimensional and Tabular models. Also worked on Power Pivot models.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Worked extensively on Database level & Server level Collations on SQL 2012.
• Troubleshooting and resolved Application issues, database performance and deadlocking issues.
• Monitoring SQL server performance using SQL profiler to find performance, Deadlocks blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintain database security (create and maintain users and roles, assign privileges).
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-indexing.
• Actively involved in deploying the scripts on to the production databases and also involved in deploying the post production scripts for live websites.
• Worked with Squirrel scanner tool to maintain the security with the accounts on all the SQL servers.

Environment: MS SQL Server 2012/2008 R2/2005, Windows Server R2/2003, Squirrel scanner tool, SSIS, SSRS, SSAS, ACTIVE/PASSIVE Clustering, Mirroring.

Confidential

Senior SQL Server DBA/Production Support

Responsibilities:

• Worked as primarily a production support DBA giving 24/7 Support on SQL 2014/2012/2008 R2
• Managed PRODUCTION, DEVELOPMENT, QA and UAT environments
• Worked extensively on Virtual and VMware Environments.
• Installed SQL Server 2012 Cluster and configured Always On Availability group set up on windows 2012 servers in Dev/Test & Prod environments.
• Involved in Planning for Upgrades and Migration of major systems from SQL Server 2000 to SQL Server 2008 R2 and from SQL Server 2008 R2 to 2012/2014.
• Involved in Mapping data for safe and secure Data Transfer
• Involved in Quality Test (QA) of Data for successful Migration
• Created SSIS packages for various Data Source and Data Destination Mappings for transfer
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Worked on setting up and managing Snapshot and Transactional Replication
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring and Log shipping for disaster recovery.
• Created extensive reports using SSRS ( Tabular, Matrix )
• Maintained various databases for Production and Testing using SQL Server 2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
• Worked on creating SSAS cubes and laying out SSAS designs
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Created extensive SQL Server Integration Services (SSIS) packages for ETL.
• Migrated MS SQL Server 2000/2005 to MS SQL Server 2008 R2/2012/2014
• Extensive Data Mapping and Migration of Data for Production Environments created database logical/physical modeling with ERWIN
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers& maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Heavy migration using SSIS, DTS and Data Integrator.
• Used SSRS for daily client reporting.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: SQL Server 2014/2012/2008 R2/2005/2000, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2012/2008 R2/2003/2000, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager

Confidential

Senior SQL Server DBA

Responsibilities:

• Responsible for supporting over 100+ SQL instances which include SQL 2012/2008 R2/2005.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2 2012 in Production and test Environments.
• Involved in heavy duty SQL Server Migration, Upgrades and QA Testing
• Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times and proactively generated performance reports.
• Automated most of the DBA Tasks and monitoring stats.
• Responsible for SQL Server Edition upgrades and SQL Server patch management.
• Created a mirrored database for reporting using Database Mirroring with high performance mode.
• Created database snapshots and stored procedures to load data from the snapshot database to the report database.
• Involved in data modeling for the application and created ER diagrams using Erwin and VISIO.
• Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Moved databases from SQL Server to SQL Server 2000.
• Created Linked servers for distributed queries.

Environment: MS SQL server 2000/2005/2008 R2, Windows 2003/2008 R2, Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS, SSRS, Erwin, VISIO.

Confidential

Senior SQL Server DBA

Responsibilities:

• Installed SQL Server 2008 in production, test and development environments.
• Managed servers in Clustered, Mirrored and Log Shipping environment
• Managed SQL Servers in Virtual and Standalone environments for OLTP and DSS systems
• Involved in database design, database standards, T-SQL code reviews.
• Configured Active/Active and Active/passive SQL Server Clusters.
• Implemented Mirroring and Log Shipping for Disaster recovery
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
• Designed and implemented database changes.
• Reviewed and tune up SQL queries, stored procedures, views and triggers.
• Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
• Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
• Managed health of SQL Servers including backups, restores and monitoring.
• Provide a working model of transaction processing environment for capacity assessment and planning.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
• Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.
• Provided technical support during the development, design enhancement and implementation of production databases.
• Worked with the transaction processing area to develop both the physical and the logical database administration functions.
• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Worked with vendors in evaluating and implementing new technologies.
• Trouble shooting and supporting all user problems by using SQL server profiler, network traces, Windows logs etc.
• Hands on experience on SQL Server Data Collector.
• Migrated DTS Packages to SSIS Package.
• Monitored event and server error logs for troubleshooting.

Environment: MSSQL Server 2005 and 2008, MS Windows Server 2003, 2008, SSIS, SSRS.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R2
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Configured CDC on Replicated Database.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Developed ER Diagrams using Visio 2000. Designed Star and Snowflake data model.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle, Sybase and DB2 UDB.
• Implemented MS SQL Server security policies and granted object level permissions.
• Created jobs for rebuilding of indexes and updating statistics.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.

Environment: Windows Server 2000/2003, VMware, SQL Server 2005, Windows 2003, DTS, T-SQL.

SQL Server DBA

Responsibilities:

• Planned and Successfully Installed SQL Server 2005 on the Production and Development Servers.
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.

Environment: Windows Server 2000/2003, MS SQL Server 2005/2000, XML and Erwin.