SUMMARY

• Over 6.5+ years of experience in Database Administration using MS SQL Server 2014/2012.
• Expert Level skills in providing 24x7 DBA Level 3 support in Production, QA and Development.
• Experience in development wif PowerShellscripting languages.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Knowledge working wif Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure.
• Migration experience wif multiple databases/servers from SQL 2008R2 and SQL 2012.
• Design, Architect and capacity planning OLTP or OLAP requirements.
• Monitoring Indexes for Performance Related issuesPowerShell.
• Monitoring wif DDL TriggersSQLServer Profiler Event NotificationsPowerShell
• Experience and Knowledge on HA/DR like log shipping/Mirroring/Clustering & Replication.
• Extensive experience in implementingClusteringand mirroring on physical and virtual machines.
• Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations.
• Extensively worked on Active - Active and Active-PassiveClustering.
• Successfully Implemented TDE (Transparent DataEncryption) to secure data at rest and document teh process.
• Set-up transversal dataencryptionand service broker onSQLServer.
• Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption in SQL 2012 Resource Governor and policy based management.
• MonitoringSQLserver Error logs, Disk Space growth,ClusteringEnvironment.
• Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization.
• Experience in working wif DTS/SSIS (ETL) in SQL, 2008, 2012, 2014.
• Extensive experience in SDLC in developing an application, wif Installation, design, architecture, data flow, Maintenance and Operations of a system.
• Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management
• Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages.
• Experience in working wif VLDB databases up to 16TB, Managing Backups, Disk & Drive Space issues, managing indexes, Partitioning, compression, free space etc.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Experienced in Design, Development, Testing, Implementation and production, Support SDLC of Client/Server, and Web based applications.
• Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, Lite Speed, SQL sentry etc.
• Good team player wif communication Interpersonal and business analysis skills.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, Maryland

Senior SQL Server DBA

Responsibilities:

• Supported 250+ SQL 2012/2008/2005 databases in clustering environment (A/P & A/A) including database mirroring/Logshipping on critical databases having 6+ TB in size.
• Performed successful Migrations SQL 2008 to SQL 2012 and Stand alone to cluster servers.
• Optimized Data center migration & consolidation by employing various migration strategies; such as virtualization, fork-lift migration and server consolidation.
• Implemented Disaster Recovery solution.
• Experience designing interfaces between various integrated applications.
• Implemented and designed SSAS server, cubes, automated backup and restore using powershell and XMLA scripts.
• Design HA solution by automate Failover in Log Shipping Databases for DR.
• Automated daily database refreshes using Power shell from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2012/2008.
• Developed various Administration Reports of SQL inventory, Objects modified by Logins and Error reports.
• Expertise in performance Tuning OLAP environments Implementing Data Partitioning, Compression, Efficient data purging, partition elimination queries.
• Implement Data Encryption and Decryption on Databases and effective process and procedure for applications using symmetric key.
• Coordinate wif Network and storage team for Planning, building and Performance tune Blade chasis at datacenter level.
• Setting up application from scratch, build databases, cubes as per standards.
• Implement and test Database Backup to a Data duplexing device and confirm RPO and RTO to implement retention of backup and storage.
• Automate scripting logins, jobs and other server objects for DR.
• Involved in Change Management, Problem management, process management before implementing database changes in production and development activities.
• Implemented backup and restore strategy for SQL, SSAS production and DR environments using PowerShell and T-SQL.
• Developed an Automatic process to Backup, Compress and FTP a zipfile.
• Expertise in configuration, installation, and efficient utilization of third party tools Idera DM, SqlMonitor, Lite speed, Toad, DTA, Task Factory,7z etc.
• Performance tune application interfaces, database queries, and legacy systems using, Performance monitor SQL Profiler, DMVs, SQL Query Analyzer and Index tuning wizards.

Confidential, Miramar, Florida

Sr. SQL Server DBA/Developer

Responsibilities:

• Installing and maintaining and SQL server 2005/2008 R2 Servers. Productions support 24/7 for more than 400 servers.
• Supporting an Active - Active/Passive Cluster environment.
• Supporting over 250 databases wif few databases more than 16 TB.
• In SQL 2008R2 set up Database Partitioning to improve query performance.
• Performance Tuning of SQL Server 2008R2 environment wif UAT load testing for capacity and performance analysis. New Application Snapshot deployment.
• Prepare deployment packages and instructions. Perform said deployments in succession, handing these off for execution in production environment.
• Standardize and automate packaging and developer handoff. Utilize TFS for collaboration and code safekeeping.
• Implement CDC and Replicate data to Data HUB.
• Set up Transactional Replication between Primary and many Secondary servers for reporting.
• Implemented Resource Governor on SQL Server 2008R2.
• Planned, Configured, Installed and Maintained for SQL Server in Clustered (Multi-Node) and Non-Clustered environments.
• Maintained High Availability such as Replication (both Transactional and Merge replication) as far database disaster technique.
• Extensive experience in supporting and developing high-availability client server OLTP and OLAP database applications.
• Tuning database environments for OLTP or OLAP requirements as necessary.
• Configured and Monitored Database Mirroring along wif Log shipping
• Configured Merge and Transaction Replication from Production to Development Server for Multiple subscribers wif Updatable Subscriptions
• Created stored procedures for teh business logic using T-SQL.
• Involved in Installation, Configuration and Deployment of Reports using SSRS wif Scale-Out topology
• Involved in Designing for Logical Databases for SQL Server2005 and SQL Server2008R2.
• Involved in Upgradation of Servers from SQL Server 2000, SQL Server 2005 to SQL Server2008R2.
• Involved in Migration of Databases from SQL Server2005 and SQL Server2008R2.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Environment: SQL Server 2005/2008R2, Windows NT/2008R2/2008/2003, IBM Lombardi BPM 7.5, T-SQL, SSIS, and SSRS, ETL.

Confidential, Boston, MA

SQL Server DBA/Developer

Responsibilities:

• Worked wif Legacy Oracle System and SQL server 2008 R2 Servers.
• Technologies involved in dis application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft DTS (ETL).
• Responsible for Installations and configurations of SQL Server 2008, applying Service packs.
• Installed and Configured SQL Server 2008 and Clustering Services.
• Worked on SSIS packages using SQL Server 2008.
• Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.
• Implemented high availability solutions, including Clustering, Database Mirroring, Replication and Log Shipping.
• Worked extensively on Data Modeling on creation of new data models add existing tables to teh data models and creation of new tables.
• Used Replication (both Transactional and Merge replication) to move databases from SQL server 2000 to SQL server 2005
• Extensively worked on SharePoint projects and applications having Terra bytes of databases.
• Good knowledge and experience in TEAM FOUNDATION SERVER(TFS)
• Experienced in Configuring, Implementing and Maintaining Database Mirroring.
• Extensive experience in Configuration, Implementation and Maintenance Using Log Shipping, Transactional and Merge Replication in SQL Server2000/2005.
• Used Microsoft SQL Server Migration Assistant 2008 for Oracle.
• Created Normalized staging databases and used them for efficient data migration process.
• Created Linked Server to Oracle 11 to open query for SSRS.
• Creating SSIS packages for Nightly pulls from Legacy to SQL server 2008R2 server.
• Performance Tuning to increase teh speed and performance of website, tuning hardware and software requirements.
• In SQL 2008R2 set up Database Partitioning to improve query performance.
• Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
• Suggested and modified code and schema changes for database objects and scripts following Best practices.
• Monitoring and Troubleshooting jobs, Backups and Restore database policies.

Environment: SQL Server 2005/2008R2, Oracle 9i, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential, Atlanta, GA

Senior SQL Server & Sybase DBA

Responsibilities:

• Worked wif Terabytes of Data wif over 500 databases.
• Installed recommended service packs and security patches on production, test and development servers.
• Set up data Replication from Sybase ASE 12 and Sybase ASE 15 to SQL Server Dev and Production systems.
• Upgraded Test and Production databases from SQL 2005 to SQL 2008R2.
• In SQL 2008R2 set up Database Partitioning to improve query performance.
• Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
• Suggested and modified code and schema changes for database objects and scripts.
• Utilized Resource Governor to handle two applications on teh Server.
• Supported and learned a very complicated Replication system between hundreds of Sybase and SQL Servers. Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Perfmon and Best Practice Analyzer.
• Good experience in working wif high volume of transactions for OLTP & OLAP applications.
• ETL tool Running 24/7 transferring data between teh SQL Servers.
• Experience in Shell scripting (Perl, power shell).
• Expertise in Using Third party tools like Dbartisan, sqlDeveloper, Sybase central to Oracle, Sybase servers
• Monitoring and Troubleshooting jobs, Backups and Restore database policies.
• Worked wif Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Thorough understanding of standard SOP’s, SLA’s and change control management process.
• Generating Reports as per teh requirement using SSRS 2005/2008.
• Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
• Develop SSIS Packages to transform data from excel/Access file to SQL Server database.

Environment: SQL Server 2000/2005/2008 , Sybase ASE 12,15, Sybase Replication 15 MS Access, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS, PLSQL, UNIX,AIX servers.

Confidential

SQL Server DBA

Responsibilities:

• Providing 24x7 supports to Production, QA and Development servers.
• Involved in installations, upgrades, patches and fixes.
• Successfully migrated teh data from SQL Server 2000 to SQL Server 2005/2008.
• Worked on data compression features of SQL 2008 R2.
• Monitoring and Troubleshooting jobs, Backups and Restore database policies.
• Worked on high availability SQL solutions, including Log shipping, Replication and SQL Server clustering.
• MySQL database performance optimization.
• Worked wif Application manager to accommodate data to MYSQL.
• Working experience on Active -Passive and Active -Active Clustering model.
• Successfully migrated SQL 2005 mirror model to SQL 2008 cluster model.
• Worked wif Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Work wif project teams for Migrating data from MS Access to SQL Server 2005/2008.
• Writing DTS (SQL 2K) as well as SSIS (SQL 2K5) packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for teh Data Migration team and also upgraded DTS packages to SSIS packages.
• Generating Reports as per teh requirement using SSRS 2005/2008.
• Configuring and Setting up BMC Patrol alerts in Production, Preview, QA & DR, Test environment.
• Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
• Designing Logical and Physical Data Model wif Erwin tools.
• Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Environment: SQL Server 2000/2005/2008 , MS Access, Windows NT/2000/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential

SQL Server DBA

Responsibilities:

• Upgraded most of SQL Server 2000 to SQL Server 2005.
• Involved wif upgrade of databases from 2000 to 2005 in a Clustered environment.
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned teh Complete Backing up of Database and restoring teh Database from Disaster Recovery.
• Planned and modified teh permission issues in teh server.
• Designed a report on teh monitoring of SQL Server Performance. dis report gives a detail report to teh management on teh Performance of teh server.
• Worked wif SQL Server Reporting Services (SSRS).
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• 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 application.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Administering teh MS SQL Server by creating user logins wif appropriate roles, dropping and locking teh logins, monitoring teh user accounts, creation of groups, granting teh privileges to users and groups.
• Involved in Performance Tuning on Production, QA and Staging servers of teh current project.
• Fine tuning teh Database Settings as well as teh Server Settings.
• Configured Mail Profile for sending automatic mails to teh respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Creating, maintaining teh users, roles and granting privileges.
• Created teh backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Performed analysis and design of teh application.
• Database and Transaction log backups & restoration, backup strategies, scheduling teh backups. Backing up system & user databases and restoring them. Did teh database administrative job of Security, Backup/recovery, ODBC connections etc.
• Involved in Monitoring Performance of different production servers. Implemented Database mirroring for disaster recovery.

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

Confidential

Jr. SQL Server DBA

Responsibilities:

• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
• Involved in creating tables, views, indexes, cursors and stored procedures.
• Involved in creating data models and designing logical and physical models of database.
• Upgraded SQL server 2000 to SQL Server 2005 on standalone and clustered environments and applied service pack.
• Involved in designing teh system models using UML and ER Diagram.
• Performance tuning, and optimization of procedures and queries.
• Worked wif SQL server Profiler.
• Worked wif developers to do teh database schema changes and database restore requests.
• Creating, maintaining teh users, roles and granting privileges.
• Worked closely wif teh developers’ team and teh end users while teh system is being under development phase.
• Gave training sessions to teh end users for teh new product such as using teh product.
• Involved in writing queries and optimizing teh performance of teh queries.

Environment: MS SQL Server 2005/2000, Waterfall, Windows Server 2000.