Resume

Sign in

Sql Server Data

Location:
Chicago, Illinois, 60616, United States
Salary:
$40
Posted:
March 15, 2019

Contact this candidate

Resume:

Amit Kumar Dantani

872-***-**** ac8spy@r.postjobfree.com

SQL DBA

Summary

3+ years of IT experience in Database Administration and SQL Server in various domains like Finance, Insurance and Healthcare

Expert in installation, configuration and maintenance of MS SQL Server2008 R2/2008/2005/2000 in standalone and clustered servers.

Highly experienced in investigating and applying necessary SQL Server database service packs, Hot fixes and Security Patches.

Experienced in developing and deploying the cubes using SSAS.

Experience of Upgrading and migration from earlier version of SQL Server to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 in different environments

Experience in installing SQL 2012.

Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications.

Worked with SSIS & SSRS for various BI requirements.

Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.

Experience in Installation of SSRS 2005/2008. Hands on generating different types of Reports using SQL Server Reporting Services (SSRS).

Good experience with the entire phases of Software Development Life Cycle (SDLC) that include analysis, design, development, testing and deployment.

Good knowledge in creating SQL objects like Databases, tables, views, stored procedures, Indexes, Triggers, User defined data types, cursors and Functions.

Good knowledge of Relational Database Management Systems (RDBMS)

Experienced in Installation, Configuration, Database Migrations and Upgrading of SQL Server from 2005 to SQL Server 2012

Experienced in Upgrading SQL Server Software to new versions with required Service Packs and Patches and hot fixes.

Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.

Education

Master’s in Computer Science

Chicago State University, IL

Technical Skills

Databases

MS SQL Server 2005/2008/2008 R2/2012, MS Access 2000/2005/2007

Programming

SQL, TSQL, BASIC, C / C++, XML, HTML, Perl and Shell Scripting

Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Query Analyzer, SQL Profiler, Data Transformation Services, SQL reporting, SSIS, SQL Compare, TSM, SCOM,

Case Tools

MS Office 2000/XP/ 2003/2007/2010, MS Outlook 2000/ 2003/2007/2010, Visio, Clear Quest

ETL Tools

SSIS, SSRS, DTS, Import Export Data, Bulk Copy Program

Operating System

Windows 2012/ 2008R2/2003/2000, Advanced Server, NT & Windows 9x, Linux

Experience

Humana, IL

SQL Server DBA May 2018 - Current

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Implemented Log shipping and mirroring as a part of HA and DR.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

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.

Deploy SSIS packages in various environments Development/test/Stage/production.

Proficiency in developing Maintenance plans, backup, recovery strategies and Rebuild/Reorganize strategies.

Reviewing and verifying Database backup details, Database user privileges, Inactive user accounts.

Configured Database mail and linked servers between SQL Server to SQL Server, SQL to Oracle Servers, and SQL to MS Access Databases.

Ensured security logins and database access permissions.

Monitoring Year Old SQL Authenticated accounts, Sys Admin Accounts and Password Policy Check for SQL Accounts.

Experience with moving physical data and log file from one drive to another drive.

Time Warner, IL

MS SQL Server DBA Jun 2015 – Nov 2016

Checking the general health of the servers and the databases.

Successfully Installed different versions of SQL Server on the Production.

Installed and Maintained high availability of database using Database Mirroring.

Monitored SQL Server Performance and Activity by using SQL profiler.

Monitored Dashboard Reports for Performance Tuning and finding bottlenecks in database.

Monitored the server’s status, database file growths, disk space alerts etc.

Experienced in improving/Tuning SQL Server performance using native and third party tools.

Analyze reports for long running queries, locks, deadlocks, backup history check and retention.

Involved in trouble shooting of database and vendors’ application problems.

Designed and executed SQL Server 2005 to SQL Server 2008 upgrade plan.

Successfully upgraded the databases from SQL Server 2005 to SQL Server 2008/2008 R2.

Implemented SQL logins, roles and authentication modes as part of security policies.

Backup and Restoration of Databases using Redgate Backup and SQL native methods.

Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Transparent Data Encryption, Table and Page level compression and Resource Governor.

Written complex SQL statements using joins, sub queries and correlated sub queries.

Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.

Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2005 & 2000(SSAS).

Responsible for transfer of data from client’s existing software to e-Clinical Works databases.

Exert Infotech, India

Jr. SQL Server DBA Jan 2014 – Apr 2015

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Created SSIS packages to export data from Oracle to SQL Server Database.

Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.

Configured product meta-data tables to support client data reporting needs.

Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems.

Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Migrated few objects from SQL Server 2000 to SQL Server 2005.

Provide 24 X 7 supports to all production, development, staging and clustered servers.

Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.

Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).

Expertise in Security Issues such as creation and granting permissions on various Objects.

Preparing the reports for the day-to-day as well as weekly/monthly purposes.

Utilized tuning tools such as Perfmon, Trace files, SQL profiler, and Query analyzer to diagnose performance issues and tune the database.

Design and develop backup and restore plans and procedures for backup, full and incremental backups.



Contact this candidate