PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2016, 2014, 2012, R2, 2008, 2005 and 2000 in Production, QA, Reporting, Staging, Testing, Development, Replication and Clustered Server Environments.
• Expert in handling production systems in 24/7 environment.
• Good knowledge in Administering and managing Databases ranging several gigabytes.
• Expertise in Performance, Administration and Recovery (PAR) of production databases according to service level agreements (SLAs).
• Good experience with configuring Always On, Clustering, Mirroring and Replication for high availability and disaster recovery (HA/DR).
• Installed and configured MS SQL Server 2016/ 2014/2012/2008 R2/2008 and 2005 systems in all environments.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in - depth of T-SQL.
• Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Expertise in migrating and configuring SQL servers to AWS (AMI, RDS, ELB, EC2, S3)and from physical disks to Azure& VM.
• Good knowledge in tuning MS SQL Server 2008/2005 systems for optimal performance.
• Good skills in handing MS SQL Server systems in Clustered environments on 2008/2003
• Implemented SQL Clustering for MS SQL 2012/R 2/2008/2005/2000.
• Published Reports to SharePoint Server utilizing Business Intelligence Development Studio.
• Scheduled Reports to be delivered to SharePoint Document Library.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS).
• Good knowledge in implementing log shipping mechanism (Manual & Wizard).
• Implemented Database Mirroring on SQL Server 2008/2005 systems.
• Sound knowledge of performance tuning MS SQL Server 2008/2005 for best performance.
• Experience in fine tuning parameters on operating systems.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity, and Database Consistency Checks using Trace Flags, DBCC Utilities, DMVs and DMFs.
• Expertise in resolving locks, deadlocks, handling Isolation levels and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Good skills in using SQL Server 2008/2005 profiler trace for bottlenecks and long running queries.
• Good knowledge in fine tuning stored procedures for better performance.
• Good knowledge in understanding query plans and statistics data.
• Good Knowledge in querying the databases using the PowerShell scripting and Visual C#.
• Worked on database tuning wizard in MS SQL Server 2008/2005.
• Created Linked Servers between SQL Server & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Implemented sound backup strategy for all MS SQL Server 2012/2008/2008 R2/2005/2000 database servers.
• Timely full backup / Differential backup and transaction log backup for all production servers.
• Good knowledge on third party backup tools like LiteSpeed,RedGate for quick and better backup and restore process.

TECHNICAL SKILLS:

RDBMS: SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000.

Database Tools: Management Studio (SSMS), BI Development Studio (BIDS), SQL Profiler, Query Analyzer

Other Tools: Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Reporting services(SSRS),FOGLIGHT,ERWIN, IDERA, RedGate (SQL compare, SQL Monitor, SQL Backup, SQL Doc), LiteSpeed, Microsoft Visio.

Languages: SQL, Transact-SQL, PowerShell,C#,.net Framework, Visual Basic 6.0.

Applications: Microsoft Office, MS VISIO, MS Access.

Operating Systems: Windows 2003/2008/2012.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. MS SQL SERVER DBA

Responsibilities:

• As a SQL PLM DBA responsible for upgrade/migration of 200 SQL Servers out of which more than 125 servers are Production Servers and rest all are Development, Test and Staging servers.
• Responsible for migrating SQL versions to SQL 2012& 2014 with proper planning and documentation in place.
• Acted as liaison between UHG management, Clients & application team actively involving in gathering information based on business requirements.
• Researched, designed and tested a migration plan from SQL Server 2005 to SQL Server 2012 and from 2008/2008R2 to 2014 acting as technical in charge for migration.
• Built servers in azure and VM according to client’s requirements and provisioned databases according to hardware requirements and storage capacity planning.
• Implementation of SQL logins, roles & authentication modes as part of security setup for different kinds of users and responsible for data security & integrity according to HIPAA requirements.
• Involved on installation, migration/upgrade, patching and security setup in all the environments of SQL versions from .
• Implemented new 2012 techniques like data compression, online indexing, contained databases, security principals and AAG.
• Good knowledge on SAN & RAID levels and building SQL clusters on SAN boxes.
• Experience with configuring SQL Server Replicationand Always On for High Availability and Mirroring&Clustering for Disaster Recovery across all production servers in SQL Server 2012 & 2014.
• Installed, configured & maintained SQL Server Replication models like snapshot, merge&transactional on production servers for High Availability based on business justification.
• Formulated and monitored policies, procedures, and standards relating to database management by providing project leadership within a functional database area of specialization.
• Configured and maintained HA/DR like Clustering and Always On making critical production servers 24/7 up and running.
• Involved in migrating DTS packages from SQL Server 2005 to SSIS packages in SQL Server 2012 environment.
• Designed and deployed various ETL & SSIS packages using Business Intelligence Development Studio(BIDS) and generated reports according to business requirements.
• Worked with technical architects and database analysts for creating reports in SSRS with different properties like chart controls, filters and sql parameters deploying them onto Microsoft Office SharePoint Servers.
• Wrote business logic code in C# code behind files to read/pull data from database stored procedures.
• Experience in using SQL Profiler, Database Engine Tuning Advisor (DTA), Foglight and responsible for monitoring and recommending performance improvements by optimizing queries, indexes, views & stored procedures and by analyzing, tuning long running queries resolving bottlenecks.
• Involved in change management and resolved incident tickets on daily basis for production issues related to SQL backups, Disk space, Job failures, system checks, HA/DR P1 issues using Service Nowticketing tool and involved in 24/7 Production on Call.
• Used third party backup tools like IBM Tivoli Service Manager for backup and restore of databases with sizes more than 4TB.
• Monitored databases and instances using third party tools like Foglight along with native tools and worked extensively on performance tuning, database tuning and index tuning for better performance of databases.
• Acted as a liaison between the offshore team and onshore team.

Environment: MSSQL 2014/2012/2008 R2/2005, VMware, Azure, windows OS, Windows Cluster Server,Always On, Replication, Mirroring, BIDS, SQL Server Management Studio, FOGLIGHT, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS,SNOW, TSQL, Stored Procedures, Triggers, Views, DTS, BCP, Data Compression, Power Shell,C#,.net Framework, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, SAN, PowerShell, Active Directory, ODBC, TSM-TDP.

Confidential, St. Louis, MO

Sr. MS SQL SERVER DBA

Responsibilities:

• As a Production and development support DBA responsible for maintenance on 520 SQL Servers out of which more than 300 servers are Production Servers and rest all are Development and Staging servers.
• Responsible for migrating SQL /R2 versions to SQL 2012 with proper planning and documentation in place.
• Implementing new features of SQL 2012 like Always on, Column Stored Indexes & Contained databases in newly migrated servers.
• Installing, configuring and maintaining Iderathird party tool for monitoring performance, database backup and restore.
• Created and scheduled SQL JOBS using SQL Agent.
• Working closely with Development & Application teams to guide with best practices on writing t-sql queries.
• Writing PowerShell scripts to make enhancements to existing functionality.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity.
• Solving tickets on daily basis for production issues using BMC Remedy ticketing tool.
• Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
• Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
• Worked on migrating SQL servers from physical drives to AWS with good knowledge on elastic load balancing (ELB), elastic compute cloud (EC2).
• Worked on creating new users and roles and managing security for all users.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2012.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Managing SQL server using PowerShell scripts.
• Created maintenance plans for good running database health.
• Created monitoring scripts to alert for blocking, dead locks, sql agent job failures, backups etc.,
• Working with SCOM to monitor server across all the domains.
• Good knowledge on system maintenance procedure like upgrade all Microsoft Products,
• Patches, defrag the all Drives, apply OS updates (including thoroughly tested service pack).
• Apply application specific updates (SQL post SP4, Exchange post SP3 hot fixes).
• Good knowledge on upgrade process from & 2008R2.
• Provide good support to the Developer and QA Environment.
• Involved in DR (Disaster recovery) environment.
• Created standard operating procedures (SOP) for SQL Clustering, replication and log shipping.
• Configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.

Environment: MSSQL 2012/2008R2/2008/, VMware, windows OS, Windows Cluster Server, BIDS 2005/2008/R2, SQL Server Management Studio, Erwin, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, IDERA, Remedy, TSQL, Stored Procedures, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, SAN, PowerShell, Active Directory, ODBC.

Confidential, Columbia, MO

Sr. MS SQL SERVER DBA

Responsibilities:

• Involved in installing, configuration and administration of log shipping, Replication and Mirroring based on business requirement.
• Provide support to application developers in designing and implementing physical database structures.
• Creating stored procedures to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization.
• Researched, designed and tested a migration plan from SQL Server 2005 to SQL Server 2008/2008R2 and also from 2008/2008R2 to 2012.
• Responsible for migrating over 80 databases from SQL Server 2005 to SQL Server 2008/2008R2 SSMS and native scripts.
• Designed DR plan, database backup and restore plan to point in time.
• SQL Server performance statistics collection, Server monitoring and performance tuning using perfmon, SQL Server profiler and Index tuning advisor, Database tuning wizard.
• User account management and connection troubleshooting issues with application team.
• Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes.
• Trained members of the Network Access team to handle SQL Server account management.
• Audit and generate monthly management reports using third party tool.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Experience in installation, configuration and administration of SQL Server 2005/2008/2008 R2/2012 and technical in charge of migrating SQL Server 2005 to SQL Server 2008/2008R2 and 2012.
• Formulated and monitored policies, procedures, and standards relating to database management.
• Provided project leadership within a functional database area of specialization.
• Manage and resolve trouble tickets for database-related issues submitted by customers.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 (R2), Microsoft SQL Server 2000 and 2005, Windows 2003/2008 Server, Share point, IIS 6.0, SCOM, BMC Remedy.

Confidential, Albany, NY

SQL SERVER DBA (Department of Health)

Responsibilities:

• Installed SQL Server 2012 in production and development environments.
• Successfully upgraded from SQL Server 2005 to SQL Server 2012 on Development and Testing Environments.
• Involved in system requirements and the upgrade matrix for SQL Server 2005.
• Worked in 2- node Active/Passive Clustered Environment.
• Worked on virtual environments like Azure creating instances and configuring replication and also involved in migration of databases to Azure.
• Involved in migrating DTS packages from SQL Server 2005 to SSIS packages in SQL Server 2012 database.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2012.
• Implemented Log Shipping in SQL 2008 from Primary Server to Standby Server to support DR Solution.
• Worked in 24x7 production environment.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Writing PowerShell scripts to make enhancements to existing functionality.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler, Windows Performance monitoring tool.
• Utilized RedGate for taking comparing databases, monitoring, taking effective backups and restores across multiple servers.
• Creating Logins and Roles with appropriate permissions.
• Acted as a liaison between the offshore team and onshore team.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Involved in daily production server check list, SQL backups, Disk space, Job failures, system checks, checking performance statistics for all servers using monitoring tool and research and resolve any issues, checking connectivity.
• Involved in checking the replication on each server by checking each publication to make sure the distributor is running for each subscription.
• Maintained log book to write down any issues and how they were resolved.
• Daily production server check list Include checking connectivity i.e. log into customer application\billing application to ensure it can connect to databases.
• Checking replication on each server by checking each publication to make sure the distributor is running for each subscription and maintaining log book to record the issues and their resolutions.

Environment: MS Windows 2008/2012 Enterprise Server, MS SQL Server 2000/2005/2008 R2/2012,MS Visio, SSIS, Azure, RedGate,SCOM 2007 R2.

Confidential

SQL Database Administrator

Responsibilities:

• Installed SQL Server 2008 applied service packs and security fix for all servers.
• Configured and maintained Log shipping architecture to provide server backup solution for 4 different environments.
• Implemented and managed all Publisher, Distributor and Subscriber database environments for the replication.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Implemented SQL Server Mirroring on SQL 2008/2005 environments
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQLServers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used containers for repetitive control flow tasks
• Provided maintenance for SCOM R2 infrastructure and ensured capacity and security metrics for SCOM reports.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import, Export control extensively inSSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
• Scheduled package execution in SSIS.
• Installing of packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created extensive reports using SSRS (Tabular, Matrix)
• Installed, configured and maintained MS SQL Fail over clustering to provide server high Availability.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Involved in setting up transactional replication in production environment.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Used PowerShell scripting for complex queries
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve theserver performance.
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008/2005, Windows 2000/2003/2008 Server Operating systems, SSIS, Windows Cluster Server, Windows Server 2003, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS.

Confidential

SQL Database Administrator

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 on standalone and clustered environments and applied service packs.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
• Interacted with Developers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and trouble shooting.
• Involved in installing SQL Server 2005/2008 on Development, Production and WTC (Testing) machines.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008.
• Involved in troubleshooting all the performance issues for different database applications.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Interacted with concern application team in fixing the problems when ever needed.
• Involved in setting up database mirroring for production server.
• Using third party tool like LiteSpeed for backup and restore the databases and also preparing and documenting database Backup & Maintenance Plans.
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduling jobs on production and staging environment.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries.
• Provided 24 x 7 Production support for the database and application issues.
• Daily tasks Include handling ticketing tools resolving issues from development and production team.

Environment: SQL Server 2005/2008, Windows 2000, Windows NT, Windows 2003 Enterprise Edition, LiteSpeed, Profiler, Clustering.