OBJECTIVE:

• Having 9 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.

SUMMARY

• Senior MS SQL Server Database Administrator with 10 years of experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT environments
• Expertise in Managing PRODUCTION Databases on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in VIRTUAL and PHYSICAL environments.
• 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 Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization.
• Expertise in VMWARE and managing multiple SQL Server Instances on VMWARE
• Expert in Data Transfer and Data Migration of SQL Server environments
• Expertise in In-Place and Side-by-side migration of Data.
• 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
• 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.
• 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
• Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures.
• 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.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling jobs with SQL Server Agent and SQL Profiler.
• Strong in PowerShell scripting and automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell 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

Databases: MS SQL server 2014/2012/2008 R 2/2008/2005/2000

Operating Systems: Windows XP/Vista/8, VMWare

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS

Other Tools: Microsoft Visual Source Safe, IDERA, Redgate, Foglight, Sentry

Data Modeling Tools: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Senior SQL Server DBA/Production Support

Responsibilities:

• Worked primarily as 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.
• Worked on ACTIVE/ACTIVE and ACTIVE/PASSIVE clusters
• 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.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• 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.
• Performance tuning and optimization of procedures and queries. extensive use of SQL Server DMV's for Performance Tuning
• 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.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• 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 2008 R2/2003/2000, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager

Confidential, Columbus, OH

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
• Installed SQL Server 2012 Cluster and configured Always On availability group set up on Windows Server 2008R2 in Development production environments.
• Configured Monitored Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery. Support and troubleshooting for Transactional replication.
• 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
• Scheduled package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Configured transactional and snapshot replication and managed publications, articles.
• 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.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server .
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• 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

SQL Server DBA/ Production

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.