SUMMARY

• 7+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008, 2005 and 2000.
• 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.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals.
• Intermediate experience in developing data models in HANA 1.0 SP2
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server .
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2005.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008, 2005,2000, MS-ACCESS, Oracle, SAP HANA

Programming: Visual Basic 6, XML, HTML,DHTML,T-SQL Programming, .Net, C#, ASP.NET.

DBA: Database Administration of MS SQL Server 2012,2008, 2005

Operating System: Windows 2012/2008/2003 Advanced Server, Linux, Unix, Windows 8, XP

Other Software: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project

Tools: Backup Utility, SQL LiteSpeed, Visio, Sage MAS 200, ERWIN

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, MN

SQL Server Administrator

Responsibilities:

• Providing 24/7 Production Support for SQL Server 2008 R2 / 2012.
• Installation & configuration SQL 2008R2 & 2012 on Windows 2008 R2, apply SP and security fix.
• Resolving of High CPU spikes by identify long running Queries, Blocking & Deadlocks
• Monitoring Server Performance and Activities. Tuning Queries, created necessary indexes.
• Auditing the Security checks on QA \ PRD servers as per application security standards
• Involved in creating Backup & Restore strategies.
• Implemented Disasters Recovery (DR) plans to reduce the downtime of the SQL Server.
• Created Application Roles, assign required permissions to roles, assign to database Users
• Created Linked Server for retrieving data for distributed database
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
• Setup & Monitoring of Replication agents and troubleshooting
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Creation of Update statistics on the databases to improve performance
• Scheduling SQL Server Agent Tasks to periodically running of tasks.
• Running of DBCC command for checking database consistency as part of SQL Maintenance plans.
• Working closely with application developers to participation on designing of tables and writing of views, complex SPs, UDFs, Trigger, and Indexes according to their requirements.
• Involved in Stored Procedures Tuning and Performance and Query tuning Activities
• Using SQL Profiler and Tuning Queries to improve performance and used Index tuning Wizard.
• Used BCP Command line tools to Import/export the table data into Flat Files and Flat files to tables.
• Deploying SSIS packages & Setup the non-SA jobs.

Environment: MS SQL Server 2012 & 2008 R2, SSIS, SSRS, T-SQL, IIS 6.0, Windows server 2008 R2, BCP and Bulk Load, Oracle11g, HTML, MS-Excel, ASP.Net, XML.

Confidential, CT

SQL Server DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared Data Flow & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2008 R2.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008 R2.
• Monitoring SQL server performance using SQL Profiler to find performance and deadlocks.
• Developed, deployed and monitored SSIS Packages.
• 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.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers using IDERA third party software.

Environment: SQL server 2012/2008/2005 , SSIS/DTS, Surface area Configuration, Database Engine Tuning Advisor, Oracle 10g, BCP and Bulk Load, Windows 2012/2008/2003 , Windows XP, Windows Vista/7, Microsoft Outlook. Excel (Pivot Tables)

Confidential, NJ

SQL DBA/Developer

Responsibilities:

• Migrated Databases from SQL server 2000 to SQL server 2005 and SQL server 2008
• Upgraded SQL Server 2000 DTS packages to SSIS packages.
• Configure Mirroring as an effective solution for a hot standby server for production servers.
• Set up replication from SQL 2000 publisher to SQL 2005 subscriber and SQL 2008 subscriber.
• Wrote complex stored procedures and user defined functions.
• Wrote the code from scratch to successfully build provider database for a major client.
• Successfully migrated DTS package to SSIS package and has developed number of SSIS packages for automation purpose.
• Effectively provided 24/7 production support for critical production tasks.
• Creating and managing schema objects such as tables, views, index, and procedures.
• Worked extensively and oversee all database administration team's activities and projects.
• Assist IT management in prioritizing database administration team's projects.
• Routine maintenance of all SQL server databases for optimal performance and error reduction.
• Daily monitoring of database storage allocation and usage as well as other resource usage.
• Backups and recoveries, backup standards and schedules, recovery procedures.
• Intent of the security plan is to establish a means of providing complete accountability for any and all use of the databases.
• Developing and maintaining the portions of the disaster recovery plan that pertained to the database servers and provide documentation of the steps necessary to perform the disaster recovery process.
• Advising developers / end users on issues such as database design, indexing, SQL tuning, stored procedures, triggers, DTS and SSIS packages.
• Managed the integration of data and monitored exceptions of highlight data from customers.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Configured report builder and trained business users so that they could create reports from the reports models I created.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final.

Environment: SQL Server 2008, / SQL server 2005, DTS, SSIS, Surface area Configuration, Database, Engine Tuning Advisor,, Client tools, BCP and Bulk Load, Windows 2003,2008 Reporting Services, Windows 2000/XP/Vista, Microsoft Outlook, Excel (Pivot Tables)

Confidential, NY

SQL DBA/Developer

Responsibilities:

• Installed and Configured SQL Server 2005/2008 in Dev, Val, Integration, Pre-Production & Production environments for new company-wide WDPE database systems.
• Provides business as usual support for production databases. Pro-active monitoring of production databases by analyzing growth trends.
• Working on Data Auditing in SQL SERVER 2008 Databases.
• Upgraded SQL Server 2005 instances to SQL Server 2008 and guided the development and application team to fully utilize SQL Server 2008 enhancements.
• Implemented Transparent Data Encryption (TDE) on SSA wide databases to provide comprehensive security and protection on customer’s PII information.
• Worked on High Availability solution process by configuring the Replication, Database Mirroring and Clustering on multiple environments.
• Involved in Capacity Planning (SAN) and provided disk space requirements by analyzing database sizes and recommended separate drives for Data, Logs, Backups and TempDB.
• Interacted with Developers in identifying the requirements and designing and implementing the Database Schema.
• Worked and Coordinated with Microsoft Support team to fix the Cases/Tickets.
• Checking, Space monitoring, Index Defrag, Update Statistics.
• Run performance monitor, SQL profiler and other tools to monitor and report on database performance.
• Scheduling Database Online/Offline Backups and Log Backups, Restoration, Backup Strategies.
• Backing up master & system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Developed, monitored and deployed SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Experience on created reports usingstored procedure. Involved in scheduling, creating snapshot and subscription for the reports.
• Successfully implemented Database mirroring on SQL 2008 Servers for Disaster Recovery and monitored databases involved in mirroring sessions.
• Conduct daily health checks for production databases and resolve any possible issues.
• Administer SharePoint issues as the team migrated from live-link document repository to SharePoint.
• Integrate MS Excel spread sheets with SharePoint lists.
• Performing restore of databases per the requests from the AD team. Managing User Creations, assigning Roles to SQL Databases.
• Responsible for deploying the scripts in UAT Environment.
• Used Third party tool Quest Lit speed version 5.2 for large database backups, Log shipping and database maintenance plans.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, NJ

Junior SQL DBA/Developer

Responsibilities:

• Installation and configuration of SQL Server 2000 and SQL Server 2005
• Monitored and maintained SQL Servers in Production, QA, Test and Development Environments.
• Set up SQL Mail, Created Jobs to Automate & Scheduled tasks.
• Managing of Logins, Users, Roles and permissions.
• Implementing of Automated Backup and Database Maintenance / Cleanup jobs.
• Imported Data from Text files and Excel Spread sheet into SQL Server 2000 database using DTS package using BCP.
• Created Data Mart using Analysis services for finance, inventory and sales department to review the data from production databases.
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Creating DTS Packages for migration of data across different servers and Other Databases such as Oracle and DB2.
• Assist Developers in writing and creating new procedures.
• Troubleshooting Replication Errors and handling Logs.
• Creating new procedures using Dynamic SQL and Table Variables.
• Assisted users in modifying store procedures over performance issues.
• Check consistency of databases using the DBCC commands.
• Check the fragmentation of tables and indexes and run INDEXDEFRAG and DBREINDEX at appropriate time.
• Implemented the Reporting Services in SQL Server 2005.
• Implemented Database mirroring, snapshot databases.

Environment: SQL Server 2005 and SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, VSS and Password Updater.