Sql Server Information Technology

To secure a challenging position as a junior DBA in an established organization and utilize my technical skills and IT knowledge for managing organization's projects. Had attended multiple SQL DBA conferences and has prior experience as a junior DBA. The duties pertaining to my prior experience were

Performed SQL Server production database analysis.

Performed troubleshooting for LAN problems for individual client basic software.

Provided customer assistance and support relating to database system queries and complaints.

Inspected the operations of the database as per the standards set by the organization.

Maintained a backup or recovery options to retrieve the lost data.

Performed data cleansing and data migration functions.

Assisted in building strategies for installing and improving the database.

SPECIALIZATION:

Designing and implementing database server solution in SQL Server. Engineering and administering SQL Server security, database backup and recovery, performance monitoring, performance optimization, query tuning and query performance optimization, high availability solutions and SQL Server Clustering. Highly self-motivated, goal oriented and always looking forward to taking the expertise and performance to the next level.

Install and Configure Microsoft SQL Server on production, QA, development servers.

Configure maintenance plan, database mail, performance monitoring.

Design and implement SQL Server security including logins, server roles, users, database roles, server/database/schema/object permissions, cross database ownership chain.

Create database objects including tables, views, triggers, stored procedures, functions, implement referential integrity and add constraints.

Partition tables and indexes, optimally archive data from portioned table and loading new data (Sliding Window). Determine poorly performing SQL queries, analyze execution plan for them, tune-up and optimize the queries.

Design indexing strategies and implement necessary indexes.

Backup and restore databases.

Utilize Extended Events for performance monitoring.

Configure SQL Server Reporting Services.

Create and schedule SQL Server Agent jobs, manage jobs, alerts and operators.

Install and configure Microsoft SQL Server 2014, 2012 for development servers.

Configure Memory Optimized (In-Memory) databases in SQL Server 2014.Create memory optimized tables, stored procedures.

Estimate memory utilization and requirements for In-Memory tables.

EDUCATION

Loyola University Chicago Expected Graduation: August,2017

Master of Science in Information Technology.

Cumulative G.P.A: 3.7 /4.0

Jawaharlal Nehru Technological University Graduated: November 2012

Bachelor of Electrical and Electronic Engineering.

Cumulative G.P.A: 3.6 /4.0

TECHNICAL SKILLS AND EXPERTISE

Database Server Tools : Microsoft Server Management Studio(Enterprise), Microsoft SQL Server Express, Bitnami MySQL Server

Programming languages : C, R, MySQL, C#, ASP.Net, CSS.

Data Analysis : R and R Studio, Rapid Miner, MS Excel (Mega stat, Pivot table, VLOOKUP)

Operating Systems : Windows 7,8,10 and MAC

Reporting Tools : Tableau, Crystal Reports, Team Track

MS Office : Word, Excel, PowerPoint, Access.

ACADEMIC EXPERIENCE

Google Map Enhancer (C#, Asp.Net, Jscript, CSS)

Jan 2017 – April 2017

Integrate Google Map and real time location weather services by using C# and ASP .NET.

Utilize Google Map API with Geo-Location Matrix and Open Weather API for real time location weather updates.

‘Unemployment Pattern Analysis’ – Data Mining Project (Rapid Miner)

Aug 2016 – Dec 2016

Preprocessed BLS approved 5yr of data for unemployment pattern analysis using transformation, clustering and association.

Reduced dimensions, impute missing value using K-NN model, performed association rule mining and forecasting.

‘Flight Delay Impact Analysis’ – Data Warehouse Project (Tableau- ETL and Reporting)

Aug 2015 – Dec 2015

Extracted and transformed archived flight delay data of American airlines using Tableau

Created visual dashboard and quarterly reports using Tableau for delay and revenue analysis.

Data analyst assistant, Moghal College of Engineering and Technology

June 2012-June 2013

Increased the admissions rate up to 10% with an extensive admissions market research

Made spreadsheet reports, tables, charts, etc. from readily available information and managed admissions database.

Authorized to work in USA for any employer (GREEN CARD).

Contact this candidate