SQL Server Database Administrator

YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-****

PROFESSIONAL SUMMARY

• 7+ years of experience as SQL Server DBA (2008, 2012, 2014, 2016) in Production, Development and Staging Environments along with Business Intelligence Developer and Data Analyst skills.

• Extensive experience in Deploying and Consolidating Multiple Instances, Installation, Upgrades, Patches, Configuration and Administration for SQL Server in a Clustered and Non-Clustered Environment.

• Expertise in Database Administration on Production Servers with server configuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities.

• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

• Experience in Setting up, Monitoring and Administering (HA) High Availability solutions like Log shipping, Database Mirroring, Replication and Clustering as a part of Disaster Recovery (DR).

• Implemented Data partitioning, Snap shot isolation, database mirroring, database snapshot, try-catch blocks, online indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection.

• Expertise in Scheduling Database tasks – Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Index rebuilding, update Statistics, Error and Event Handling, Mail Setup Jobs, Alerts, Emails, Notification.

• Excellent backend skills in creating SQL objects like tables, synonyms, Stored Procedures, Triggers, Views, Indexes, Cursors, rules, defaults, user defined data types and functions.

• Experience in using Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) for finding out long running queries.

• Experience in (ETL) Extracting, Transforming and Loading data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various SSIS/DTS packages.

• SQL Server (BI) Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.

• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

• Implemented data compression, Contained Databases, security principals.

• Proficiency and expertise in SQL Server Replication, Batch processes, Import, Export, Backup/ Restore

/Recovery, reviewing backups, integrity checks, Disaster recovery, Security Management operations and planning, Maintenance plans.

• Written PowerShell scripts and developed SQL Server Utility Tools-SQLPS using PowerShell, Batch and TSQL scripts for morning health check, Release Deployment, Script Automation, Long Running Report Kill Utility and Installation of SQL Server unattended package with email notifications.

• Worked on SQL Server 2012 /2014/2017 migration from SQL Server 2008 / 2005 with Handling Memory configurations on Windows Servers

• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.

• Expertise in Performance Tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and Spotlight

• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage

• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.

• Created Linked Servers between SQL Server & Oracle 10g and iSeries. Also created DTS package for data transfer between the two environments.

• Experienced working with SSIS Data Profiler Tool, Customization with Script Task, SSDT, ETL Wizard.

• Working experience in Fast Loads SDC implementations with Legacy Data.

• Experience in SDLC life cycle for Design, Development and Staging phases of the projects with support of YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-**** Data-Flow, Process Models, E-R Diagrams.

• Experience in performance Tuning in SSIS packages by using Row Transformations, Block/Unblock Transformations.

• Developed, Deployed and Monitored SSIS Packages for new ETL processes and upgraded the existing DTS packages to SSIS for the on-going ETL processes.

• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.

• Experience Working experience for Data Flow Tuning with Query Locks and Performance Tuning Data Flow tasks with Fast Loads Options (OLEDB)

• Working experience with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure.

• Designed and built cloud service models including Infrastructure-as-a-Service (IaaS), Platform-as-a- Service (PaaS), and Software-as-a-Service (SssS).

• Implemented high availability with Azure Classic and Azure Resource Manager deployment models.

• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.

• Worked in team to high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer with Azure Classic and Azure Resource Manager deployment models.

• Experience configuring and troubleshooting Geo Replication and OMS Storage for Event Audits

• Strong Communication & Management skills and Excellent Team player.

• Monitoring Team for Level 1 support along with Level 2/3 support DBA activities with the SLA (Service Level Agreement) established.

• Strong experience in mentoring team members, leading database projects and writing documentation.

• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

• 24 X 7 Production Database administration on Call Support on weekly rotation. TECHNICAL SKILLS

Languages :

Software :

C, C++, HTML/DHTML, JavaScript, VB, C#, T-SQL, AJAX, VB Script, PowerShell MS Office 2007/2010/14/16, Visual Studio Dot net 2005/2007/2010/2014, Active Directory SMS 2003, SCCM 2007, virtual desktops (VDI) MS Visio, MS Project Web Technologies : MS Office 2010/2016/365, Visual Studio Dot net 2005/2007/2010/2013/2014, Database : SQL Server 2005/2008/2012/2014/2016/2017, MS Access, Oracle 9i/10g/11g, My SQL, DB2 iSeries, AS400

Operating Systems : Windows Server 2000/2003/2005/2008/2012/2014 XML Technologies : XML, XAML, XSLT

Application Server : IIS 5.0/6.0/7.0/8.0 Hosting

Reporting Tools : Crystal Reports 9.0/10, SQL Server Reporting Services Tools : SQL Profiler, Red Gate-SQL Monitor, IDERA Sql Doctor, Oracle Databases, Visual Studio, SSIS, SSAS, VMware Workstation, SQL Developer, SQL CMS, SSRS, Crystal Reports, Microsoft Visio, PowerShell ISE

Network : LAN/WAN, DNS, Domain, Protocols, TCP/IP, FTP, SNMP, SMTP Soft Skill : Planning, Escalation, Project Handling, Analytical skill, Presentation and Communication Skill, Positive Attitude, Punctual, Strong written and verbal English language skills, Passion to do new things, Always willing to learn new technologies. EDUCATIONAL QUALIFICATION

• Master of Science in Computer Science, Concentration in Databases, Security and Privacy Stevens Institute of Technology, Hoboken, NJ. Aug 2008- May 2010

• Bachelor of Science in Computer Science

C. U. Shah College of Engineering & Technology, Saurashtra University, India Oct.2002- Jun 2006 YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-**** CERTIFICATIONS & TECHNICAL TRAINING

• 20488 Developing Microsoft© SharePoint© Server 2013 Core Solutions

• 10987 Performance Tuning & Optimizing

• SQL Server 2014/2016 Always On and High Availability

• 20462 Administering Microsoft SQL Server Databases

• 10175 Microsoft SharePoint 2010, Application Development

• VMware vSphere: Install, Configure, Manager [V5.0]

• Workshop of ORACLE 9i Database: SQL Tuning from SQL Star company, Mumbai

• Microsoft Certified Application Developer (MCAD) for SQL Server 2008. WORK EXPERIENCE

Hitachi Automotive System Americas, Inc. Farmington Hills, MI Sr. Database Administrator Feb 2017 – Oct 2018

Responsibilities

SQL Server Administration

• Performed database design, upgrades & applied software patches to databases as per applications/client requirements.

• Worked with Always-On Availability Groups (AAG) and Troubleshooting in SQL server Enterprise 2014

• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

• Implemented Snapshot replication. Used Log shipping for synchronization of database at the DR Site.

• Created Linked Servers to other Database Server (SQL, Informix and DB2).

• Expertise in T-SQL writing stored procedures, triggers and functions.

• Administering SQL Server High Availability and Disaster Recovery strategies.

• Assure quality of all reports and SSIS packages to compare data with excel spreadsheet compare.

• Deployment of SSRS reports including user permissions on site, folder and report level.

• Write down stored procedures to invoke SSIS package execution on SQL Server package catalog.

• Proficient in creating, designing, configuring, scheduling, deploying of SSIS packages to carry on smooth workflows to extract data from heterogeneous data sources to target systems.

• Actively involved in developing complex SSRS reports involving Sub Reports, Matrix/Tabular Reports, Charts, Graphs and Parameterized reports.

• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

• Rebuilding / Monitoring the indexes at regular intervals for better performance.

• Setup Snapshot, Merge and Transactional Replication between Servers, and troubleshoot and monitor Publishers, Distributors, and Subscribers. Involved in Installation of SQL Server with Multiple instances, latest SPs and hot fixes.

• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Sound knowledge of implementation, monitoring and troubleshooting of replication, mirroring, always on (AAG) availability groups HA solutions to synchronize databases in high safety available mode at single point of failure.

• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT operations.

• Implemented data compression, online indexing, Contained Databases, security principals.

• Troubleshooting production issues and raising high availability. Environment: SQL Server 2008/2012/2014/2017, SSIS, SSAS, SSRS, Visual Studio, Query Analyzer, DTS, SQL Profiler, Performance Monitor, Visio

YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-**** Script Development

• Integration, synchronization and replication of data with 3 rd parties system, AD, SQL Servers by SLQ script, PowerShell Script, VB Script, Java Script.

• Written PowerShell scripts that are customized for a particular dataset – such as a morning health check, which outputs different base information on reporting every morning with email notifications.

• Scripting in PowerShell bulk load or dump data from one interface to other [AD to SQL server sync, SQL server to AD, SQL server to SQL server Sync, AD to other party system like Concur, Inquisiq, etc.]

• Scripting in PowerShell and VB script for scheduling task, push group policy for Windows Security Updates, install plug-ins

Environment: Windows PowerShell ISE, PowerShell Plus, Visual Studio Hitachi Automotive System Americas, Inc. Farmington Hills, MI IT Administrator (Database, System) Feb 2012 – Feb 2017 Responsibilities

SQL Server Administration

• Performed migration of SQL Database servers from SQL Server 2005/2008 to 2012/2014.

• Installed & configured database software, associated database tools and performance monitoring Software.

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large

(VLDB) and Complex Databases up to 1 Terabytes.

• Analyzed long running slow queries and tune the same to optimize application and system performance.

• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment. Controlled and coordinated the installations (Security Patches, Service Packs).

• Regular Database Maintenance process, Checking the disk, Defrag procedures in Development environments.

• Used SQL Profiler for Performance Monitoring to resolve Dead Locks and Long running queries by checking appropriate changes.

• Performed database/infrastructure physical design, database upgrades & applied software patches to databases with estimating of Disk storage requirements as per application/client requirements.

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

• Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

• Created Data-driven Packages in SSIS as part of the automating the process for the Referral Process.

• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.

• Reviewed & Tested packages, fixing bugs (if any) using Business Intelligence Development Studio.

• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

• Using SSIS, migrated data from various data sources like Oracle, Flat-files, upstream systems into Staging.

• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.

• Providing optimal database file layout for utilization of storage and performance acceptable to client.

• Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Trouble-shooting for Business work flow with Log Shipping mechanism

• Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions.

YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-****

• Understanding and developing PowerShell Script for Integration and synchronization between different platforms

• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.

• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms.

• SQL Administration like setting up SQL Server Agent jobs, operators, and alerts.

• Monitoring Database Server Performance, tuning, backup integrity checkup Environment: SQL Server, SSIS, SSAS, SSRS, Visual Studio, Excel Spreadsheet Compare, SQL Profiler, Performance Monitor, Visio

Web Application Development/System Administration

• Working with team to configure, maintain Share Point application in-house.

• Designed, developed and maintained end user web interface, documentation of web sites

• Directly responsible for developing, planning, and executing IT projects, strategies, and operations

• Provided comprehensive leadership to the strategic planning process for short- and long-term IT related needs for the company for specific projects

• Administrated for users' account on Cisco Call Manager, Cisco Unity, Lotus notes Admin servers.

• Directly responsible for developing, planning, and executing IT projects, strategies, and operations Provided comprehensive leadership to the strategic planning process for short- and long-term IT related needs for the company for specific projects

Environment: SQL Server, Visual Studio 2014/2016, Ajax Controls, Share Point 2010/2013, Agile Point, CorasWorks, Visio, Cisco Call Manager, Cisco Unity, Lotus notes Admin servers Kelly Services.

Work Site: Hitachi Automotive System Americas, Inc. Berea, KY DBA Programmer July 2011 – Dec 2012

Responsibilities

• Worked with of SQL Server 2000, 2005, 2008.

• Worked gradation of Database from SQL Server 2000 to 2005 and 2008.

• Monitoring the server for High availability of the servers.

• Day-to-day administration of live SQL Servers.

• Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Trouble-shooting for Business work flow with Log Shipping mechanism

• Setup Snapshot, Merge and Transactional Replication between Servers, and troubleshoot and monitor Publishers, Distributors, and Subscribers. Involved in Installation of SQL Server with Multiple instances, latest SPs and hot fixes.

• Performed Database Refresh tasks from production to Development and Staging Servers

• Involved in auditing / performing the transactions to database and resolve the issues with PerfMon and SQL Profiler

• Performance monitor for Memory, Processor, Disk I/O, and fine-tuning Disk usage, Cache-hit ratio, Transaction p/s.

• Fine Tuned stored procedures for Better performance and also maintaining data Integrity in SQL Server, Written Stored Procedures for Application Developers.

• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.

• Involved in Creation of databases, writing queries, monitoring of execution plan for tracing the execution flow for critical throughput

• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.

• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of DTS Packages to load the Data from various Databases and Files. YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-****

• Configured Delayed Log Shipping for synchronization of Production Database with Standby Database.

• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server enterprise manager, Database Wizard and Transact SQL Statements.

• Analyzed long running /slow queries and tune the same to optimize application and system performance.

• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

• Implemented Snapshot replication. Used Log shipping for synchronization of database at the DR Site.

• Created Linked Servers to other Database Server (SQL, Informix and Oracle). Environment: SQL Server, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility Kelly Services.

Work Site: Hitachi Automotive System Americas, Inc. Berea, KY Software Developer/ Programmer September 2010- June 2011 Responsibilities:

• System Study, Requirement gathering, Analysis and documentation

• Creating various Stored Procedures, Tables, Views in SQL Server 2005/2008 and DB2 for iSeries

• Using database level triggers code for database consistency, integrity and security.

• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.

• Use all the SQL Server tools for the Implementation and Administration of the databases. The tools include Performance Monitor, Profiler Trace, Index Tuning Wizard, ISQL, OSQL, Query Analyzer, Enterprise Manager, Component Checker.

• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes.

• Involved in Creation of logins, Users as per Security standards and groups, roles, jobs, alerts and sending mail confirmation upon tasks. Performed Uploading of bulk data using BCP Utility

• Database support with Store Procedures, Cursors and Queries, monitoring the flow of Order Management by the Oracle Back-End support.

• Responsible for System development & troubleshooting based on VB 6.0, VB.NET and AS400

• Tested functionality and usability of software product base on requirement

• Solving the request raised by user support.

• Participate in implementation of new releases into production.

• Facilitates application deployment and joint effort deployments.

• Meet the SLA (Service Level Agreement) established.

• Working closely with development team in adding functionality and fixing bugs

• Working in a team for ticket generation, account sheets in physical inventory on monthly bases.

• Generating and implementing Label programming base on client request.

• Performed code optimization from AS400, VB 6.0 to VB.NET with conversation and transferring the database. Environment: SQL Server 2005/2008/2010, Visual Studio .NET (VB.NET) 2005, DB2 - iSeries Creative InfoTech Solutions Pvt. Ltd., Surat

Work Site: KRIBHCO, Hazira, Surat Gujarat, India

Application Developer December 2006 - July 2008

Responsibilities:

• System Study, Requirement gathering and Analysis

• Responsible for Design of Data Model, Data Flow and Entities & Relations.

• Created various Stored Procedures and Views in SQL Server 2000/2005 YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-****

• Responsible for Software development & troubleshooting based on ASP.NET

• Tested functionality using different testing methods

• Worked in a team for creating and manipulating database and systems

• Responsible for data analysis, loading data from Data Sources to Data Warehouse tables.

• Developed queries using various Joins and Sub queries in Data Warehouse in OLTP/OLAP environment.

• Created reports using SSRS (SQL Server Reporting Services).

• Solving the request raised by user support.

• Participate in implementation of new releases into production.

• Facilitates application deployment and joint effort deployments.

• Meet the SLA (Service Level Agreement) established.

• Day-to-day administration of live SQL Servers.

• Designed and implemented Security policy for SQL Servers.

• Configured and maintained Report Manager and Report Server for SSRS.

• Integrated PowerBuilder application to Visual Studio .NET. Environment: PowerBuilder, Visual Studio .NET, Oracle 8i/9i, SQL Server 2000/2005 Projects:

• KRIBHCO Transportation System

This window application maintain all the data and transaction that is for purchasing and selling KRIBHCO products, it also give brief description of flow of transportation via different vendors, consignee through different types of roots based on validate condition and security. Environment: PowerBuilder, Visual Studio .NET, Oracle 8i/9i, SQL Server 2005

• Online Library Management System

This web application is give facilities to access online e-books, catalogs, Journals, Projects, PowerPoint Slides and other stuffs and also give all information of all departmental employees and users. Environment: ASP.NET 2005 with C# and SQL Server 2005 as a back end Diligent Infosys, Ahmedabad Gujarat, India

Software Developer (Apprentice - Trainee) May 2006 - December 2006 Diligent Infosys is IT base company and provide complete IT support for multiple market segments. Based on internal strength, we offer a wide range of spectrum in Enterprise IT solutions. Environment: Visual Studio .NET, SQL Server 2005

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.

• Developed HTML/XML scripts for use on website by parents and employees

• Tested and debugged code by using Unit testing, Integrations testing

• Managed and configured Master Data for materials and vendors, Info Record and maintained Source List.

• Created domain networking, network administrating by using com utilities and permissions, worked in workstations, central processing unit of the system

• Created various T-SQL queries, Stored procedures, Views, Functions in SQL server for project database

• Involved in Creation of databases, writing queries, monitoring of execution plan for tracing the execution flow for critical throughput

• Responsible for Software development & troubleshooting based on ASP.NET

• Tested functionality using different testing methods YAMINI PATEL Email- ******.******@*****.***

Sr. SQL Database Administrator Phone: 734-***-****

• Worked in a team for creating and manipulating database and systems

• Responsible for data analysis, loading data from Data Sources to Data Warehouse tables.

• Developed queries using various Joins and Sub queries in Data Warehouse in OLTP/OLAP environment.

• Worked for System development & troubleshooting based on VB 6.0, VB.NET and AS400

• Tested functionality and usability of software product base on requirement

• Solved the request raised by user support.

• Participated in implementation of new releases into production.

• Facilitated application deployment and joint effort deployments. Projects:

• Gasoline Transaction and Maintenance

This web application was created to maintain information & statistics about purchasing and selling gasoline, the main features of this software are role based security, profile management etc., working in USA. Environment: ASP.NET 2005 with C# and SQL Server 2005 as a back end

• Railway Announcement System

This software is very useful in Railway Management. This project is to provide Announcement of trains at Railway Station. The announcement contain train information like arrival time, departure time, platform no, approximate late time, original station, destination station, weekly timing, holiday special train timing etc. Environment: Visual Basic 5.0 and Oracle 8i as a back end

Contact this candidate