Shashi A

ac1o0v@r.postjobfree.com

+1-815-***-****

Summary:

Around 5 years of expertise in Database Design, Administration, Architecture as database management professional with top-notch skills in directing full cycles for complex and multi-site programs using MS SQL Server 2005/2008/2008R2/2012/2014/2016 in Production, Staging, Development Environments.

Extensive experience in Architecting, Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008/2008R2/2012/2014/2016 standalones and Failover Clusters both on Physical and Virtual environments.

Planning and Designing DB Servers with thorough understanding of underlying Hardware, To Architect Database Servers including Sizing, Capacity planning with thorough understanding SAN/RAID levels by working with SAN team for IO Optimization, Bench marking, and Implementation of DR/HR strategies within SQL Server in accordance with RPO/RTO meeting SLAs.

Hands on experience in Side by Side and In-Place Upgradation/Migration of SQL Server 2005/2008/2008R2 instances to SQL Server 2012/2014.

Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.

Solid experience and outstanding knowledge in implementing the High Availability and Disaster Recovery designs using the SQL Server Solutions like AlwaysOn Availability groups (AAGs), Mirroring, Log Shipping, Replication and SQL Failover cluster Instances.

Experience in Disaster Recovery Planning, Execution and Testing at remote site.

Very knowledgeable at SQL Server Internals and well experienced with database admin skills including Backups/Recovery, Database Maintenance, Troubleshooting, Performance Tuning, Optimization, Designing HA and DR solutions in SQL Server 2005/2008/2008R2/2012 and 2014.

Experienced in developing Stored Procedures, Triggers and Cursors using T-SQL.

Extensive experience with SQL Server Business Intelligence solutions - SSIS, SSRS and SSAS.

Solid experience in designing ETL solutions using SSIS (SQL Server Integration Services) for data extraction, transformation and loading in SQL Server 2005/2008/2008R2/2012 using tools like Import and Export Wizard, Package Installation and SSIS Package Designer (BIDS/Data Tools).

Experience in DTS package Migration to SSIS Package using Package Migration Wizard and troubleshooting migration related issues and rewriting the ActiveX Scripts to .Net Scripts.

Implemented data models, database structures, design, backup and recovery processes.

Extensive experience in dealing with BI solutions including deploying ETL packages, SSRS reports and SSAS Cubes.

Thorough understanding and hands on experience configuring and managing SQL Server 2012/2014 Always ON Availability Groups and FCIs.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

Experience with Designing/Deploying/Managing SSRS reports and managing the Report Server/Report Server security.

Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards. Served as primary DBA for critical SOX Complaint Applications with Internal and External Auditors.

Expertise in Performance Tuning and Query Optimization to achieve high database efficiency.

Expertise in with T-SQL Development skills including writing Stored Procedures, Indexes, CTEs, Indexed views, Triggers, User Defined Functions and Distributed Queries.

Extensive experience with third party SQL Server Supporting, Monitoring and Alerting tools like Red Gate, SQL Sentry, Idera, Confio and Dell.

Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.

Strong Communication, Management skills and Excellent Team player.

Very passionate in learning new features and technologies. Ability to mentor/guide fellow team members as required.

Automation using the PowerShell.

Exceptional focus and follow-through skills. Quickly and easily establish professional rapport with peers, management and application developers.

24/7 on Call Support for Production Databases.

Educational Background:

Bachelor of Technology, Sir Sarada Institute of Science & Technology, India.

Master of science, Gannon University Erie, PA

Technical Skills:

RDBMS\DBMS: MS SQL Server 2005/2008/2008R2/2012/2014/2016, MySQL 5.1/5.5, Oracle 9i/10g/11g and MS Access.

Languages: C, C++, T-SQL, ANSI SQL, Power Shell, C# .Net, ActiveX, HTML Script and PLSQL.

Web Server: Internet Information Server.

Operating Systems: Windows Server 2003/2003R2/2008/2008R2/2012/2012R2 and Windows 98/XP/Vista/7/9/10.

Other DB Tools and Softwares/Services: SQL Server Enterprise Manager, SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SSRS, SSIS (as ETL), SSAS, Informatica, SQL Server Data Tools, Visual Studio, SQL Developer, SQL Server Migration Assistant, SQL Server Upgrade Advisor, VMware VCenter, VMware VSphere, Nutanix, Idera Diagnostic Manager/SQL Doctor, SQL Sentry Power Suite 8.1/Plan explorer, MS system center operations Manager (SCOM), dbForge SQL Complete, Red Gate SQL Backup/SQL Compare/Data Compare, light speed, CA Erwin, MS Visio, MS Project, 4.0, Microsoft Team Foundation Services (TFS), MS-Office 2007/2010/365 Suite, MS Visio, TOAD, Crystal Reports, Windows Active Directory, MAP Tool, SharePoint, Solarwinds Performance Analyzer, Azure, Dell Foglight, SQLIO, PSSDIAG, KeePass, WinDirStat, IIS, PlanView, BMC remedy and Service Now.

Professional Experience:

Client: Toyota, Erlanger, KY

Role: SQL Server DBA

Jan 2017 to till date

Roles & Responsibilities:

Working on upgrading 20+ SQL Server instances from SQL 2008/2012 to SQL Server 2014/2016.

To research, recommend, implement and maintain third party monitoring tools for SQL Server environment for monitoring and alerting purposes.

Responsible for analyzing the environment for missing standards and providing the best practices to manage and maintain the SQL Server instances effectively and efficiently.

Installed and providing support for various Database Engines, SSRS and SSIS for Production, Development and Testing environments at different plants for local developer and application teams.

Involving in building SQL Server instances, databases and other required components for upgrading core applications like Team Foundation Services, Trend Micro (Anti-virus), Equitrac (Printing) and System Center Configuration Manager (SCCM).

Implementing AlwaysOn Availability Groups (AAG) as HA solution for Missions Critical applications in SQL Server 2014/2016.

As a SME, was responsible for recommending the best HA/DR strategies from database environment based on the application Sensitivity/criticality and RTO/RPO as per SLA.

Designed different SQL Server db Performance and maintenance related KPI reports using the SSRS for Management and Peers.

Handling the database components for different Business Critical/Sensitive application releases and bug fixings.

Primary support Contact for AlwaysOn Availability Groups and Transparent Data Encryption related issues for mission critical instances. Handled 24/7 production issues.

Configuring Oracle/PostgreSQL client tools and drivers for installing the heterogeneous Linked servers.

Working with Internal and External auditors on audit requirements/regulations to make sure the SQL Server database environment is SOX Compliant.

Designing POC on new features/technologies like Contained Databases, Always Encrypted in SQL Server 2016 and Buffer Pool Extensions and In-memory Tables in SQL Server 2014 and Query Store in SQL Server 2016.

Pro Active monitoring of all mission critical SQL Servers and fixing the highly critical issues before they start impact Production lines.

Environment: Windows Server 2008R2/2012/2012R2/2016, SSMS, Enterprise Manager, MS-SQL Server 2008/2008r2/2012/2014/2016, Red Gate tools, .NET Framework, Visual Studio, SCOM monitoring tool, SQL Sentry Power Suite 8.1/Plan Explorer, SSIS and SSRS, VMware machines, Data Tools, Query Analyzer, Idera Diagnostics manager/SQL Doctor, Dell LiteSpeed, Confio Ignite, MAP, Apex, Idera SQL Secure, SharePoint, VMware VCenter, SQLIO, WinDirStat, ServiceNow, PowerShell, SQL profiler.

Gannon University, Erie, PA.

Role: SQL Server DBA

Sep 2015 to Dec 2016

Role & Responsibilities:

Configure and Maintain the SQL Servers 2012, 2014 and 2016 in the Computer Lab.

Monitor SQL Error Logs, Schedule backup jobs and the database activity.

Monitor the right use of servers and computers in lab.

Managing the DB Security (creating logins, users, roles, and assigning permissions).

Applying service packs and worked with SQL server 2012 and 2014.

Worked and demonstrated the ETL and Reporting solutions available with SQL Servers.

Demonstrated different HA and DR solutions for SQL Servers.

Designed and supported Multi-Instance clusters.

Involved in creating maintenance plans for consistency checks, maintaining indexes and statistics, performing fine Tuning of Databases based on standard process.

Implemented and configured database monitoring tools like SCOM/Idera Diagnostic Manager to focus on providing a highly available SQL Server instances/Databases.

Documenting the new feature/technology implementations and Best practices for managing SQL Servers.

Providing guidance (Mentoring) to the student on fixing critical issues, SQL Server best practices and standards/Procedures/Methods.

Environment: Windows Server 2008R2/2012/2012R2, SSMS, Enterprise Manager, MS-SQL Server 2012/2014/2016, .NET Framework, Visual Studio, SCOM monitoring tool, SSIS/DTS and SSRS, VMware machines, Data Tools, Query Analyzer, Apex, SharePoint, VMware VCenter, SQLIO, WinDirStat, Database Tuning Advisor, SQL profiler.

Employer: Apollo Microsystems Private Limited, Hyderabad, India

Role: SQL Server DBA and Developer

May 2012 to July 2015

Roles & Responsibilities:

Implemented data models, database structure design, backup and recovery processes.

Involved in installation of SQL Server 2014, 2012, 2008 and 2008 R2 on Consolidated and Standalone environments and maintains development and production databases (e.g., SQL Server databases).

Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG (Always On Availability Groups).

Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes

Audits and maintains small-scale to large-scale databases.

Worked on Active/Active and Active/Passive Clustering.

Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.

Responsible for verifying all data to be entered database meets set standards and requirements.

Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.

Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Involved in migration of SSIS (2008) packages to SSIS (2012) packages.

Developed, deployed and monitored SSIS Packages for new ETL Processes.

Identifies tests and resolves complex database issues (e.g., monitoring and tuning).

Involved in database system management functions (e.g., software installs, version upgrades and configuration management).

Responsible for fine tuning of the databases, troubleshooting, user administration and resource management on SQL Server instances.

Implemented best SQL Server practices on existing SQL Server services to make the SQL Server database perform efficiently.

Suggested best practices for servers and hardware RAID configuration solutions for Enterprise Solutions.

Implemented HR and DR solution like Mirroring (Synchronous and Asynchronous), Log shipping and Replication (Snapshot\Transactional).

Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located at different sites.

Working with Internal/External Auditors on Audit Requirements/Regulations and making sure that we are SOX Compliant.

Involved in Change Control Management, it is the discipline of systematically identifying and controlling production change migrations and deployments.

Managed SQL Server security and recommended best practices to the team as needed.

Took the lead in many occasions to Analyze/Fix Performance Issues of Applications.

Documenting SQL Server Best Practices for our environment and LOB specifics for Supporting SQL Servers.

Performed SQL Code Index Reviews.

Worked with Database tools IDERA, SQL Diagnostic manager, Sitescope for Multi Queries, Space analyzer, SQL alerts (Disk space alerts, SQL Service alerts, CPU utilization alerts).

Involved in Ensuring optimal performance and availability of databases.

Involved in creating SQL jobs and troubleshoot failed jobs.

Environment: MS SQL Server 2005/2008/2008R2/2012, SSRS, SSIS/DTS, SSMS, Enterprise Manager, SQL Profiler, Windows Server 2003/2003R2/2008/2008R2/2012, Active Directory, SQLIO, SQL Server Upgrade Advisor, Red Gate SQL ToolBelt, .NET Framework, Visual Studio, SCOM monitoring tool, SQL Sentry Power Suite/Plan Explorer, SSIS/DTS and SSRS, VMware machines,, BMC Remedy, Database Tuning Advisor.

Contact this candidate