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 with PowerShellscripting languages.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure.
• Migration experience with 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 with 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 the process.
• Set-up transversal dataencryptionand service broker onSQLServer.
• Implemented Latest Features like Data Compression and Backup compression reducing me/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 with DTS/SSIS (ETL) in SQL, 2008, 2012, 2014.
• Extensive experience in SDLC in developing an application, with 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 with 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 with 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 TEMPeffective process and procedure for applications using symmetric key.
• Coordinate with 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 TEMPthan 400 servers.
• Supporting an Active - Active/Passive Cluster environment.
• Supporting over 250 databases with few databases more TEMPthan 16 TB.
• In SQL 2008R2 set up Database Partitioning to improve query performance.
• Performance Tuning of SQL Server 2008R2 environment with 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 with Log shipping
• Configured Merge and Transaction Replication from Production to Development Server for Multiple subscribers with Updatable Subscriptions
• Created stored procedures for the business logic using T-SQL.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with 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 with Legacy Oracle System and SQL server 2008 R2 Servers.
• Technologies involved in this 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 (me.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 the 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 noledge 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 the 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 me/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 with Terabytes of Data with 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 me/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 the 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 with high volume of transactions for OLTP & OLAP applications.
• ETL tool Running 24/7 transferring data between the 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 with 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 the 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 the 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 with 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 with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Work with 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 the Data Migration team and also upgraded DTS packages to SSIS packages.
• Generating Reports as per the 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 with 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 with upgrade of databases from 2000 to 2005 in a Clustered environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update 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.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server Reporting Services (SSRS).
• Created Database Maintenance Planner for the 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 the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Creating, maintaining the users, roles and granting privileges.
• 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 and Re-indexing.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Performed analysis and design of the application.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them. Did the 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 the system models using UML and ER Diagram.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Worked with developers to do the database schema changes and database restore requests.
• Creating, maintaining the users, roles and granting privileges.
• Worked closely with the developers’ team and the end users while the system is being under development phase.
• Gave training sessions to the end users for the new product such as using the product.
• Involved in writing queries and optimizing the performance of the queries.

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