Nabin Gautam

acvro3@r.postjobfree.com

510-***-****

Sr.SQL DBA

Career Objective:

Seeking a challenging career in an honored organization to grow professionally by strengthening my functional and analytical skills, and earning good reputation with which I work, always keeping in mind the goals of the organization as the prime objective.

SUMMARY

8 years of experience in IT industry.

6 Years of having experience on SQL Server Administration.

Strong in Database Backup, Restore in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery & Scheduling the Backup jobs.

Installation, configuration and maintenance of MS SQL Server.

Experience in performing regular Backups and scheduling tasks.

Expertise with RDBMS database concepts including SQL Server 2008 and 2012

Possesses strong analytical and problem solving skills, experience in building large end-to-end enterprise wide applications upgrades.

Possess Good Communication and Interpersonal skills

Flexibility in adapting to a new environment

Administering SQL Server High Availability.

Knowledge in data transformation services like SSIS, DTS and Bulk Insert.

Expertise in Database backup and disaster recovery models.

Worked on logical and physical database modeling.

Worked on configuring SQL Server with minimum privileged access.

Worked on SQL Server 2005 migration from SQL Server 2000.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2000 and SQL Server 2005 on Windows 2008.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Involved in SQL Server Technologies like Database Mirroring, Log Shipping, Replication

Technical Skills:

Demonstrated expertise in SDLC principles & Agile methodology know-how and experience

Install DB2Connect v8.1

Ability to perform equally in Agile or Waterfall

Strong communication/escalation, time-management, leadership and collaboration skills

MS Office Suite- Excel, MS Word and Power Point and Microsoft Project

Operating Systems Windows XP, Win7, Mac OSX, and Linux

SQL, SQL Server Management Studio, HTML and XML

PROFESSIONAL EXPERIENCE

Client:

Aarp Rockville, MD

Role:

MS SQL DBA

Duration:

August 2013 – August 2016

Description: AARP, formerly known as American Association of Retired Persons, is United States based non-governmental organization founded in 1958 headquartered in Washington DC. AARP is "a nonprofit, nonpartisan membership organization for people age group 50 and over- dedicated to enhancing quality of life which provides a wide range of unique benefits, special products, and services. The project aim was creating reports and report model using SSRS according to business requirement. Migrated from Actuate to SQL Server 2008 then to 2012.

Responsibilities:

Installing, Configuring and Administering SQL server 2012

Troubleshoot IDMS problems using IDMS Performance Monitor & IDMS Application

Monitor & provide third party product installation for IDMS journal archiving.

Designing Database upgrades and estimation of future requirements.

Planning, implementation and administration of Log Shipping with MS SQL Server 2012.

Maintained and developed Fail-Over databases using Database Mirroring

Ensuring high availability of the database exploiting the concepts of clustering, replication, Log shipping etc.

Experience in using DB2 utilities for maintenance (Reorgchk/Reorg/Runstats), data movement (Export/Import/Load/Move/Look)

Wrote complex SQL queries and stored procedure to create reports using SSRS 2008/2008R2 from the relational database.

Analyzing, Identifying and Resolving performance issues of the server

Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.

Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

Configured the report server and generated the report models for user interactions.

Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.

Ensuring the database security perspective like Database up-gradation, patch implementation, DB2AUDIT integration, user ID validations, scripts scheduling, security health checks on monthly basis and trivial passwords as a compliance lead.

Developed and maintained system documentation, diagrams and flowcharts.

Worked with project manager and technical leads for resolution of technical issues.

Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.

Install DB2Connect v8.1

Monitoring the Disk spaces on all the servers.

Environment: SQL Server 20012, SQL Server 2008, Windows 2003/2000 Server, SQL Server Management Studio, SSAS, T-SQL, SQL Query Analyzer, SQL Profiler, MS Word and Excel.

Client:

Aetna Hart fort, CT

Role:

Team Member-SQL DBA

Duration:

December 2011- June 2013

Aetna is one of the nation's leading diversified health care benefits companies, serving people with information and resources to help them make better informed decisions about their health care and financial security. As a DBA I was responsible for on data migration from various data sources such as access, excel, flat file to SQL Server database systems. As well as involved in Database Maintenance Plans for the performance of SQL Server.

Responsibilities:

Prepared, maintained and modified SQL server installation and configuration documents.

Database Administrator, Database Programming.

Daily activities include removing deadlocks, transaction log resolution, bottle necks, dropping & re creating staging tables, optimizing complex queries using explain/db2exfmt.

Environment: DB2 V9.7/V10.5, Linux, AIX, DPF, HADR/HA, HACMP, OPM.

Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.

Developed Backup strategies for Database Recovery.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

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

Migrating SQL Server 2005 data bases into SQL Server 2008.

Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.

Installed SQL Server 2008 and created Development Database for testing, upgrades and development.

Recovering the databases from backup in disasters.

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Rebuilding the indexes at regular intervals for better performance.

Involved with development team and developed functions, procedures and packages performed Logical Backups by Export and Import utilities.

Handled numerous change management requests on production servers.

Configured SQL Server settings using configuration manager.

Worked on log shipping for synchronization of database.

Involved in creating functions to provide custom functionality as per the requirements.

Recovering the databases from backup in disasters.

To analyze long running slow queries and tune the same to optimize application and system performance.

Performing Database maintenance activities like Backups, Restoring, and indexing.

Environment: SQL Server 2008, SQL Server 2005, Windows 2003/2000 Server, T-SQL, SQL Query Analyzer, SQL Profiler, SSAS, MS Office 2010

Client

Genewiz South Plainfield, NJ

Role

Team Member DBA

Duration

December 2009- August 2011

GENEWIZ, Inc. is an award-winning global contract research organization (CRO) specializing in DNA sequencing, molecular biology, and regulatory services. The aim of the project is to create the database model and load the XML file from the ftp to the relational database. Involved in creation of various reconsolidation views for reporting in Collector Vehicle conversion Project and created various stored procedures and packages to extract data from SQL server tables and load into csv files for Cognos TM1 tool.

Responsibilities:

Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.

Performing Transition activities for Non-Mainframe DB2 Database Servers and basic administration activities of Oracle database.

Used SSIS jobs for importing data from the flat files that brings the data to the application tables.

Monitored and killed processes that create deadlocks within the database.

Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

Developed and deployed data transfers packages to the appropriate destinations using SSIS.

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

Created SQL server configurations for SSIS packages.

Responsible for creating reports based on the requirements using SSRS 2008.

Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.

Generated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Scheduled the monthly/weekly/daily reports to run automatically.

Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.

Developed and implemented procedures to ensure the quality, usability and accuracy of reports.

Database performance tuning for optimal results.

Ensured back-up procedures executed without failure

Creating Maintenance plans and jobs for automation of the repetitive task

As a part of the DBA team providing 24/7 production support to the clients Monitoring the Scheduled jobs

Checking the general Health of the servers for identifying Bottlenecks

Planning, administration, and implementation of Transactional Replication on MS SQL Server Databases

Install DB2Connect v9.5 gateway z/LINUX z/VM LPAR.

Environment: SQL Server 2008R2/2008/2005 Enterprise Edition, SQL Server Management Studio, SQL Profiler, SSRS, SSAS, T-SQL, MS Office 2010

Client:

Wireless 4 U, Baltimore MD

Role:

Technical Manager

Duration:

May 2008 – December 2009

Responsibilities:

Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.

Customer service, inventory management, maintain friendly working environment, decision making, preparing schedule for other employee, take annual end of year inventory and cycle counts.

Managerial roles, for instance, decision making, solving variety of unexpected problems in a professional manner, choosing right vendors and perform risk analysis, receive count and date shipment.

Technical roles consisting troubleshooting network, managing files, sorting confidential and regular documents, implementing sales tracking spreadsheet

Planning and strategy – determine competitive advantage, networking, setting yourself apart

Education:

Bachelors in Science Information Technology - Towson University

Masters in Applied Information Technology - Towson University

Dean’s List

Contact this candidate