SUMMARY

• 7.5+ years of experience in Database Administration using MS SQL Server 2014/2012/2008 R2 /2005.
• Expert Level skills in providing 24x7 DBA Level 3 support in Production, QA and Development.
• Day - to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Performed and designed Data Center Migration and Disaster recovery Solutions.
• Knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure.
• Migration experience with multiple databases/servers from SQL 2000, 2005, SQL 2008R2 and SQL 2012.
• Design, Architect and capacity planning OLTP or OLAP requirements.
• Experience and Knowledge on HA/DR like log shipping/Mirroring/Clustering & Replication.
• Experience in configuring the NLBS clusters.
• Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations.
• Experience with the SSIS, SSRS and SSAS.
• Experience managing Onsite & Off shore team.
• Good understanding of the Mongo DB and its clustering and replication.
• Experience in working with different virtualization technologies like VMware, Citrix, and Azure.
• Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption in SQL 2008 R2 Resource Governor and policy based management.
• Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization.
• Experience in working with DTS/SSIS (ETL) in SQL, 2000, 2005 and with SSRS 2005, 2008, 2012.
• 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.
• Hands on experience with TFS and SharePoint.
• Experience in Active Directory domain services and other infrastructure related support.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, Lite Speed, SQL sentry, Idera, Ignite etc.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Microsoft SQL Server Database Administrator

Responsibilities:

• Involved in Designing for Logical Databases for SQL Server 2012 and SQL Server 2014.
• Involved in Upgradation of Servers from SQL Server 2000, SQL Server 2005 to SQL Server2012.
• Monitoring the production environments with SQL SERVER 2005/2008/2012 and 2014.
• Migrated the databases form the Sql server 2000 to the Sql server 2012.
• 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).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Migration of databases from SQL 2000 to SQL server 2012 and 2014.
• Monitoring and managing the NLBS clusters of different environments.
• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Configured and maintained SSRS for local area reporting and have good knowledge in SSAS
• Migrated DTS packages to SSIS packages
• 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.
• 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.
• Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
• Designing Logical and Physical Data Model with Erwin tools.

Confidential, New York

VMware Administrator/SQL Database Administrator

Responsibilities:

• Installing, maintaining the SQL server 2005/2008 R2 Servers. Productions support 24/7 for more than 400 servers.
• 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.
• Experience in Active Directory domain services and other infrastructure related support.
• 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.
• Monitoring and configuration of the NLBS.
• Patch management of the servers including the SQL Server.
• Planned, Configured, Installed and Maintained for SQL Server in Clustered (Multi-Node) and Non-Clustered environments.
• Maintain the stability of all Windows 2008R2 Active Directory Servers and Group Policies.
• Install Configure and Administration of VMware Horizon View 5.1and VCloudVirtual Desktop Infrastructure (VDI) environment.
• Upgrade and maintain Active Directory domain, domain Services and authority.
• Day to day activities include installing, configuring and management of VMware Horizon View Virtual desktops, RDS Hosted Desktops and Citrix Xendesktops.
• These Include management of Floating and Dedicated pools in VMware View and Private, Existing Streamed and Shared Desktop Groups and Catalogs in Citrix Xendesktop Environment.
• Currently working as VDI Infrastructure Engineer for Virtual Desktop infrastructure implementation, providing 24*7hr VDI production L3/L2 support.
• Implemented VMware Horizon View Virtual Desktop infrastructure with more than 12000 Virtual Desktops and Performed VMware View upgrade from View 5.0 to View 5.1.
• Configured and Implemented VMware Horizon View Linked clone technology using View Composer to migrate 12000 Virtual Desktops to Windows 7 OS from XP OS.

Confidential, State Of Alabama, AL

SQL Server DBA

Responsibilities:

• 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 with 24x7 zero downtime database management on Postgre SQL.
• Experience with Java and high-available web applications
• Experience designing interfaces between various integrated applications.
• Implemented and designed SSAS server, cubes, automated backup and restore using power shell and XMLA scripts.
• Performing the ETL jobs using the SSIS and other tools as per the requirement.
• Monitoring of the SQL agent jobs, SSIS jobs, and other maintenance jobs.
• Good understanding on the Databases like Oracle and Operating System level issues and security.
• Design HA solution by automate Failover in Log Shipping Databases for DR.
• Responsible for configuring, integrating, and maintaining all the companies Development, Staging and Production PostgreSQL databases. This position will be responsible for all backup, recovery, and upgrading of all of the companies PostgreSQL databases.
• Experience in Security access control Experience with testing.
• 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.
• Implement Data Encryption and Decryption on Databases and effective 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.
• 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.
• Expertise in configuration, installation, and efficient utilization of third party tools Idera DM, SqlMonitor, Lite speed, Toad, DTA, Task Factory,7z etc.
• Performance tune for the application interfaces, database queries, and legacy systems using, Performance monitor SQL Profiler, DMVs, SQL Query Analyzer and Index tuning wizards.

Environment: SQL Server 2012/2008/2005 , Windows NT/2008R2/2003, SSAS, T-SQL, SSIS, and SSRS, ETL.

Confidential, Mclean, VA

Sr. SQL Server DBA

Responsibilities:

• Supported 300+ SQL 2012/2008/2005 databases in clustering environment (A/P & A/A) including database mirroring/Log shipping 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 power shell and XMLA scripts.
• Perform the ETL jobs using the SSIS packages.
• 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 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 for the application interfaces, database queries, and legacy systems using, Performance monitor SQL Profiler, DMVs, SQL Query Analyzer and Index tuning wizards.

Environment: SQL Server 2012/2008/2005 , Windows NT/2008R2/2003, SSAS, T-SQL, SSIS, and SSRS, ETL.

Confidential, St Louis, MO

Sr. SQL Server DBA/Developer

Responsibilities:

• Installing, maintaining the SQL server 2005/2008 R2 Servers. Productions support 24/7 for more than 400 servers.
• 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.
• Created both Tabular, Matrix, drill down reports using SSRS.
• Using SQL Net Backup tool for backup and restore.
• SQL Nexus a Microsoft helpful to analysis the entire server using a PSSDIAG.
• Configured and Monitored Database Mirroring for one of the Business Development scenario
• Involved in Configuration, Administration, Implementation using Log Shipping and Replication
• Configured Merge and Transaction Replication from Production to Development Server for Multiple subscribers with Updatable Subscriptions
• Hosting SharePoint to Internet with SSL.
• Involved in development of SSIS packages for ETL applications
• Configured TFS and maintained the security for TFS (Team Foundation Server).
• 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).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Implemented a Customer Records Management system using SharePoint Portal Server.
• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Configured and maintained SSRS for local area reporting and have good knowledge in SSAS
• Migrated DTS packages to SSIS packages
• Supporting an Active - Active Cluster environment.
• Supporting over 250 databases with few databases more than 16 TB.
• In SQL 2008R2 set up Database Partitioning to improve query performance.

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

Confidential, Bloomington, MN

SQL Server DBA /Developer

Responsibilities:

• Worked with Legacy Oracle System and SQL server 2008 R2 Servers.
• Data Migration from Legacy system SQL 2000 to SQL Server 2008.
• Designed and worked with Different RDBMS.
• 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 (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 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 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 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 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/2008/2008 R2, Oracle 9i, Windows NT/2003/2008 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential, Wayzata, MN

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.
• Designed and worked with Different RDBMS and applications collecting customers information of all BU’s into a Database and generated a Report on Customer’s overall Expenditure and Business to Cargill Agriculture business.
• Created Linked Server to Oracle 11 to open query for SSRS.
• Set up data Replication from Sybase ASE 12 and Sybase ASE 15 to SQL Server Dev and Production systems.
• Performance Tuning to increase the speed and performance of CargillAg.com tuning hardware and software requirements.
• Used various report items like tables, sub report and charts to develop the reports in SSRS
• 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.
• Performed a Security Audit for all SQL and Sybase servers.
• Extensive experience using Data Mining tools Microsoft Analysis Services (SSAS).
• 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).
• Used Putty to connect and work with UNIX servers hosting Sybase databases.
• Worked on UNIX operating system hosting Sybase and successfully applying patches and deploys.
• Expertise in Using Third party tools like Dbartisan, sqlDeveloper, Sybase central to Oracle, Sybase servers. Worked with TOAD and LiteSpeed for Backup and restore.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis
• 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/2003/2008 Advanced Server, T-SQL, SSIS, and SSRS, PLSQL, UNIX,AIX servers.

Confidential, Bradenton,FL

SQL Server DBA

Responsibilities:

• Providing support to Production, QA and Development servers.
• Migrating of databases from Oracle to SQL server 2008.
• Migrating data from MS Access to SQL Server 2005/2008.
• Successfully migrated the data from Visual Foxpro to SQL Server 2008.
• 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.
• Created SSIS packages to import data from VFP, Oracle and MS access.
• 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.
• Assisted in the design and development of the data warehouse.
• 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.
• 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/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential, Atlanta, GA

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.
• 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/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential

Developer/DBA

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

Environment: SQL Server 2000/2003, T-SQL, CVS, Windows NT/2003