SUMMARY

• Over 8 years of experience wif the 32 - bit, 64-bit Microsoft SQL Server in Production, Pre-Production, Testing/Quality Assurance, Development in Clustered and Stand-alone Server Environments.
• Experience in installing, configuring and hardening MS SQL Server Azure/ 2016/2014/2012/2008 R 2/2008/2005/2000 and applying patches, hotfixes and service packs.
• Expertise in implementing Side-by-Side Migration and in-place Upgrade of MS SQL Server 2016/2014/2012/2008 R 2/2008/2005.
• Started a project to consolidate servers and remove/migrate old and unused databases.
• Experience in working wif Windows Server 2012, 2008 R2, 2008, 2003.
• Expertise in configuring, implementing and monitoringdiverse types ofHigh Availability and Disaster Recovery including Replication, Log Shipping,Database Mirroring and Clustering.
• Experience in implementing AlwaysOn Availability Groups in SQL Server 2014/2012.
• Expertise in backup, restore the database manually and scheduling jobs and Maintenance Plans.
• Worked extensively on Performance Tuning by analyzing index fragmentation, execution plans, and finding missing indexes.
• Extensively used the native tools SQL Server Profiler, PerfMon, Activity Monitor, Index Tuning Wizard, Database Tuning Advisor, Log Viewer and Event Viewer for performance analysis.
• Experience configuring and working MS SQL Server 2012/2008 and MS SQL Server 2005 on VMware Environment.
• Proficiency in troubleshooting SQL Server jobs.
• Expert in creating database objects like Tables, Views, Indexes, Cluster Column-store Indexes, Stored Procedures, Cursors and Triggers using T-SQL.
• Sound noledge of RDBMS concepts including Normalization, Joins, Keys and Constraints.
• Hands on experience in Configuring SMTP Server for Database Mail.
• Handled multiple SQL Instances on clustered environment for projects built on SAN using RAID levels.
• Rebuilding indexes wif different fill factors and updating statistics.
• Experience in creating SSIS packages using control and data flow elements.
• Experience in extracting and transforming (ETL) data using SSIS, Import/Export, Bulk Insert and BCP.
• Working noledge of Analysis Services (SSAS) and Reporting services (SSRS).
• Experience in Database design, Performance Analysis, Production Support for very large (VLDB) and Complex Databases.
• Experience in SQL Programming, logical and physical data modeling of the database in Erwin, Power Designer and MS Visio.
• Extensively used Team Foundation Server (TFS) for database object deployments.
• Experience in using third party tools including Foglight, Spot Light, LiteSpeed, Idera Diagnostic Manager, Solarwind DPA and EMC Avamar and scheduling tools like Control-M.
• Extensive experience of Software Development Life Cycle (SDLC), Agile and SCRUM methodologies.
• Strong experience in mentoring, working wif a team, coordinating wif developers, effective communication and documentation skills, decision support meetings and 24/7 dedicated support to all production servers.

TECHNICAL SKILLS

Operating System: Windows Server 2012/2008R 2/2008/2003/2000

RDBMS: MS SQL Server Azure/ 2016/2014/2012/2008 R 2/2008/2005/2000, MySQL, Oracle

Database Tools/ Technologies: SSMS, BIDS, SSIS, SSRS, SSAS, SQL Profiler, Query Analyzer, MDS, Power Shell

Programming Languages: T-SQL, C++, Java, HTML

Other Tools: TFS, LiteSpeed, Foglight, Red Gate, Idera SQLDM, MS Visio, Erwin, Power Designer, JIRA, MS Project, Avamar, DPA

Network Topologies: TCP/IP, SMTP, FTP

PROFESSIONAL EXPERIENCE

Confidential, West Bend, WI

SQL DBA

Responsibilities:

• Worked on projects to provide DBA support for building SQL Server 2016/2014/2012 for new applications.
• Worked wif vendors to install and manage third party databases for new applications.
• Managed and administrated SQL Server 2016/2014/2012/2008 R2 on production and non-production servers.
• Performed side by side upgrade from SQL Server 2005/2008 to SQL Server 2016/2014/2012.
• Created containers wif Windows Azure and migrated databases to cloud.
• Created Azure SQL Databases using Azure Management Portal.
• Started a project to consolidate servers and remove/migrate old and unused databases.
• Extensively worked on hardening of sql servers as per CIS benchmarks.
• Participated in a Business Continuity Process (BCP) to check the Disaster recovery solution.
• Worked on setting upthe SQL Server Configuration to resolve various resource allocation and memory issues for SQL Server databases and to setup min/max memory, max DOP server options.
• Created Logins and Users wif appropriate permissions and performed security management.
• Extensively implemented Partitioning on large tables to improve the performance wif Data Warehouse team.
• Involved in Capacity planning for different servers.
• Implemented and maintained Database Mirroring and Transactional Replication as a Disaster Recovery solutions.
• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
• Involved in reviewing, planning, testing and installing database security patches and service packs.
• Deployed various SSRS reports and Cubes using SSAS.
• Created SSIS packages for maintenance of databases and as an ETL solution.
• Performed day-to-day activities/tickets including full, differential and log backups, database restores/refreshes and proactive monitoring of sql server health.
• Diagnosed and fixed sql server agent job errors.
• Worked on point in time recovery and point of failure recovery.
• Automated monthly manual database restores to non-prod databases from prod databases.
• Created databases and database objects including tables,views and indexes/columnstore indexes using T-SQL as per naming standards.
• Deployed schema changes to QA, PreProd and Prod servers as per change management using TFS.
• Used Power Designer for physical and logical data modeling.
• Used third party tools including Idera Diagnostic Manager, Solarwind Database Performance Analyzer for performance monitoring and analysis.
• 24/7 dedicated on-call support on team rotation basis and supported monthly and weekly production releases outside business hours.
• Managed more TEMPthan 100 SQL servers wif 2000 plus databases of various sizes and up to 2TB.
• Documented process for migration and decommission of unused databases.

Environment: MS SQL Server Azure/ 2016/2014/2012/2008 R2/2005, Windows Server 2012/2008/2003, BIDS - SQL Server Integration services 2012 (SSIS), SSRS, SSAS, Idera DM, Solarwind DPA, Power Designer, EMC Avamar.

Confidential, Springfield, OR

Database Administrator

Responsibilities:

• Migrated production and non-production SQL Server 2008 R2 databases to SQL Server 2012 databases side by side.
• Managed and administrated SQL Server 2012/2008R2 in Prod, QA and Dev environments.
• Daily QA and Prod deployments of SQL objects like stored procedure, functions and tables using Team Foundation Server (TFS).
• Created Logins and Users wif appropriate permissions and performed security management.
• Created user-defined roles and assigned to users.
• Proactively monitored Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Performed day-to-day activities including full, differential and log backups (scheduled backups for databases and transaction logs) to disks and restored the databases.
• Performed database refreshes.
• Health checking of prod and non-prod servers.
• Monitored Replication setup on databases.
• Created SSIS package for CDC (Change Data Capture) as a proof of concept.
• Created entities, views using Master Data Service (MDS).
• Developed database size tracking system and created monthly reports using PowerView and PowerPivot.
• Extensively worked on extracting, transforming and loading (ETL) of data to SQL Server using Informatica tools (PowerCenter Designer, Workflow manager, Workflow monitor and Repository)
• Developed and deployed SSIS Packages to create logins and users.
• Applied patches and service packs to keep the servers at current patch level.

Environment: MS SQL Server 2012/2008R2, Windows Server 2012/2008R2, BIDS - SQL Server Integration services 2012 (SSIS), SSRS, SSAS, PowerView, PowerPivot, Informatica, Redgate.

Confidential, Charlotte, NC

SQL DBA

Responsibilities:

• Installed stand-alone and clustered SQL Server 2012 and SQL Server 2008R2 on 64-bit systems.
• Migrated SQL Server 2005 databases to SQL Server 2008R2 and SQL Server 2012 databases.
• Performed side by side upgrade from SQL Server 2005 to SQL Server 2008R2.
• Implemented and maintained Database Mirroring, Log Shipping and Transactional Replication as a Disaster Recovery solutions.
• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
• Managed and administrated SQL Server 2012/2008R2 on production and non-production servers.
• Participated in a Failover drill to check the High Availability solution.
• Developed and deployed SSIS Packages to extract, transform and load (ETL) the data from Excel, Flat file and Oracle to MS SQL Server.
• Supported building reports, drill-down reports and drill-through reports using SSRS.
• Manipulated Cubes using SSAS.
• Worked on setting upthe SQL Server Configuration to resolve various resource allocation and memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Created Logins, Users and Proxy accounts wif appropriate permissions and performed security management.
• Configured Database mail by creating accounts and profiles.
• Created Linked servers.
• Implemented Partitioning on large tables to improve the performance.
• Successfully implemented capacity planning for different servers.
• Used table hints in the queries to avoid Locks and improved the performance.
• Performed day-to-day activities including full, differential and log backups (scheduled backups for databases and transaction logs) to disks and restored the databases.
• Worked on point in time recovery and point of failure recovery.
• Developed and created the database objects including tables,views, indexes, stored procedures using T-SQL and also updated statistics.
• Modified Stored Procedures and complex T-SQL queries to improve query execution.
• Used Erwin for physical and logical data modeling.
• Used third party tools including Foglight, LiteSpeed.
• More TEMPthan 100 servers and more TEMPthan 1500 databases.

Environment: MS SQL Server 2012/2008R2/2005, Windows Server 2008/2003, BIDS - SQL Server Integration services 2012 (SSIS), SSRS, SSAS, Foglight, LiteSpeed, MS Visio.

Confidential

Developer/ SQL Server DBA

Responsibilities:

• Administrated SQL Servers 2008 and SQL Servers 2005 in production as well as non-production environment.
• Performed database administration including installing, upgrading, patching and backup.
• Installed SQL Server 2008R2/2008/2005 on Windows clustered environment.
• Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration.
• Extensively used DMVs, DMFs and PerfMon to tune queries and improve performance.
• Monitored SQL Server Agent and error logs on regular basis.
• Created backup/restore and disaster recovery plan for production servers.
• Administered servers by creating logins wif appropriate roles, granting permissions, denying permissions, monitoring user accounts, creating groups, granting the privileges to users and groups.
• Recreated indexes on tables by dropping previous indexes to improve performance.
• Used Import/Export of DTS to import and export data from data sources like flat files.
• Used third party tool like Quest LiteSpeed for backups and restoring them.
• Monitored database status including CPU, memory, me/O, space, and dead lock issues using SQL Server Utilities.
• Participated in implementing and managing Log Shipping.
• Created and documented Schema designing, ER diagrams using Erwin and MS Visio.
• Created database objects including tables, views, stored procedures and triggers using T-SQL.
• Created tables wif constraints and relationships between multiple tables using T-SQL.
• Created tables in MySQL RDBMS.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Used try-catch blocks for error handling.
• Used various transformations in SSIS including Data Conversion, Derived Column, Conditional Split and Lookup.
• Actively participated in gathering client requirements and system specifications.
• Worked on all phases of database management wif application development team and other vendors to maintain maximum availability.

Environment: Microsoft SQL Server 2008R 2/2008/2005/2000 Enterprise Edition, MySQL, SSMS- SQL Server Management Studio, SSIS, SSRS.