Sql Server DBA

Nirav Patel

Ph: 609-***-**** E-Mail :- *********@*****.***

Professional summary:

●Over 6 years of IT experience as a MS SQL Server Developer/Admin.

●Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).

●Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.

●Extensive experience in MS SQL Server 2012/2008/2008R2, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

●Proficient in using T-SQL for developing Stored Procedures, Triggers, Tables, Views, User Defined Functions, common table expressions (CTEs), SQL joins and Query Writing.

●Performance tuning of T-SQL. and create clustered and non clustered index. also Identify/Search over indexes which reduce the performance.

●Worked on complex T-SQL statements, and implemented various codes and function.

●Backing up, restoring the database manually and also by scheduling the jobs and Maintenance plans.

●User Account Management in Management Studio.

●Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.

●Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages.

●Good in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports and deploying SSRS reports on the portal for user accessibility.

●Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.

Qualifications

Bachelor's of Engineering

Experienced SQL Developer and Administration

Experience in Developing BI Tools (SSIS, SSRS)

Optimizing and Performance Tuning.

Business/Technical skills:

MS SQL Server 2012, 2008R2, 2008, 2005 SQL Server Integration Services, SQL Server Reporting Services, Data Transformation Services (DTS), MS Visual Studio 2010/2008, Microsoft Products MS Word, MS Excel, MS Power Point, MS Access 2013/2010/2007, MS office 2013/2010/2007, Windows XP/2003/2000

Professional Experience:

HireRight, Nashville, TN

March 2015 – Apr 2017

SQL Server Developer / DBA

HireRight is one of the largest providers of employment screening services, HireRight specializes in helping organizations of all sizes and locations efficiently implement, manage and control their background screening programs (for Transportation, health care, education, retail, financial services etc.). Establishing whether an employee has a criminal record and also identity check, I-9 / E-Verify solutions, candidate Experience, verifying an educational degree from worldwide. HireRight offers comprehensive solutions for Drug testing, alcohol testing, physical testing, occupational health services.

Responsibilities:

●Documenting of the different servers (Collected the information regarding servers like: Size of tables, indexes, and reserved size, also find biggest table and database in the server).

●Deploying DB Scripts to Test, Stage and Production instances after successfully verification of scripts.

●Organizing (deleting/moving) all transaction logs manually and automatically by scheduling jobs.

●Performance tuning of T-SQL long running & older Stored Procedures, Views and Functions, also optimizes the query by using the SQL Server Profiler..

●Tuning of procedures and scripts by searching of over indexes in tables or by over joints in the scripts. Also tunes the scripts or procedures by rewriting of codes without changing of output Logic.

●User Account Management in Management Studio, maintaining the user securities, Grant or deny different permissions to the different users.

●Created jobs and also Scheduling it as per requirements in the managements studio.

●Backing up, restoring the database (refreshing the database) manually and also by scheduling the jobs and Maintenance plans.

●Created scripts for deleting/Archiving the older data from database (For deleting more than millions of rows).

●Created Complex Stored Procedures, also Know how to use Transactions, and also used some cursor, while loops in the complex scripts and complex Procedures..

●Timely searching orphaned users from the databases and remove/delete searched orphaned users.

●Monitoring & Managing the table sizes and data files growth. Analyzing Tables & Schemas, collecting system statistics and rebuilding or reorganizing indexes.

●Deploy Report Files .RDL (Report Definition Files) files to the report server.

●Assigning and Editing different roles to the users for accessing the Report Files within the Report Server.

●Created SSIS packages (Like : Extract the data from row files or from oracle database and transform them into required form and load to SQL server database)

●Used different sources (OLEDB, ODBC, excel file, flat file etc), Different Transforms (Derive Column, Merge, Merge Join, Data Conversion, Conditional Split etc), Different Destinations.

Ark Infotech, Surat, India

April 2009 – Nov2013

MS SQL Server Developer/SSIS/SSRS

Ark Infotech is one of the fastest growing IT Companies of Surat, India. The company deals with a varied range of Products & Services, namely –Customized ERP Applications, Web & Desktop Application Development, MLM Application Development, IT Consultancy, Customized Flash Presentation and Mobile Applications. The project was to extract and load data from data warehouse to SQL server, generate reports.

Responsibilities:

●Involved in data transfer from source to target specifications.

●Involved in Designing, Developing and Testing of the ETL strategy to populate the data from various source systems feeds using SSIS.

●Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.

●Created jobs and also Scheduling it as per requirements in the managements studio.

●Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse(Type 2).

●Created complex stored procedures, functions, views, triggers and indexes.

●Experienced in performance tuning and optimizing for SQL server application by using SQL server profiler

●Extensive experience in creating Sub-reports, drill-down reports, summary reports and parameterized reports in SSRS.

●Created different Parameterized Reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.

●Generated reports using SSRS that could be used to send information to different primary vendors, clients and managers

●Performance tuning to optimize SQL queries using query analyzer.

●Created indexes, constraints and rules on database objects

Tools & Technology:

MS SQL, SERVER 20012/2008R2, 2008, SSIS2012, SSRS2012, MS EXCEL.

Education And Certifications:

Bachelor's of Engineering in Electrical, S P University, India

(Graduation year : 2004)

Contact this candidate