SUMMARY

• Over 7 years of experience in Database Development, Design and Administration of MS SQL Server 2014/2012/2008/2005
• Extensive knowledge of Relational Database Management Systems especially SQL Server
• Strong experience in installation, administration and maintenance of databases on SQL Server 2014/2012/2008/2005 in standalone as well as MS clustered environments. Migrating databases and upgrading to SQL 2014/2012
• Expertise in T - SQL development, developing Stored Procedures, Views, and Complex Queries to facilitate efficient data manipulation and data consistency with all version of MS- SQL Server
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts and execution of test plans for loading the data successfully into the targets
• Proficient in T-SQL, DTS packages, troubleshoot and performance tuning of databases. Administering database backups and recovery of server failures and disaster recovery of databases
• Proficient in performing DBA tasks including installing and configuring SQL Servers, creating maintenance plans, checking job failures and troubleshooting issues
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, creating and scheduling jobs, alert and operators with SQL Server Agent and SQL Profiler
• Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks
• Hands-on experience in setting up Snapshot, Transactional Replication of databases, Microsoft SQL Server Clustering and Log Shipping. Supported large databases for OLTP/OLAP systems
• Performed database health checks using SQL profiler, SQL performance monitor and performance counters
• Experience in Developing, transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS. Migrated Data to SQL Server 2008/2012/2014 by using SQL SSIS
• Experience in installing, administering SQL Reporting Services and SQL Analysis Services. Experience in developing reports by using SQL SSRS and maintaining OLAP cubes using SSAS and data warehouse systems
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS

Languages: T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Operating Systems: Windows 2000/2003/2008/2012/2012 R2/XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2005/2008/2012/2014, MS Access, Oracle 9i/10g/11g/12c.

ETL Tools: Data Transformation Services, SSIS

Reporting Tools: SSRS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008/2010/2012/2013, Visual Source Safe, TFS, MS Office Suite

Third party Tools: Erwin, Visio, Red gate, Lite Speed, Remedy ITSM

PROFESSIONAL EXPERIENCE

Confidential, FL

MS SQL Server Developer/DBA

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2012 and 2014 in development and production environments.
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2012/2014 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2012/2014 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between SQL server 2012 and 2014 servers.
• Involved in Migration from SQL Server .
• Created Database Diagrams using ERWin Data Modeler.
• Performed Logical and Physical Data Modeling for the Warehouse.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2012/2014 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in the creation of cubes in the MS SQL Analysis Services.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 2012/2014, IIS Server 7.5/8/8.5, Windows 2012/2012 R2 servers, Outlook Express, .NET, MS Access.

Confidential, Des Moines, IA

SQL Server DBA

Responsibilities:

• Prepared documentation to set standards, guidelines and best practices for SQL Server database installation, administration, backup & restore procedures, database security, and SQL database development
• Monitored performance monitor and SQL Profiler to optimize queries and enhance the performance of servers
• Experienced on database creation, database tuning, and performance planning, backup planning and database administration
• Created DTS packages to pull data from oracle and flat files
• Configured IIS using TCP/IP protocols (Web Server)
• Design new database reports for employees to view daily sales data, finance, customer Care, and management using Reporting Services SSRS
• Provided back-up DBA support for all DBA team members
• Extracted data from SQL Server for report and testing purpose by using SSIS
• Designed complex queries, stored procedures, functions and packages using T-SQL for SQL Server 2008
• Used DBCC utilities to fix data corruption in application databases
• Created new database with objects such as tables, views, indexes etc
• Development of business rules implemented as constraints, triggers and stored procedures.
• Scheduling jobs on various stored procedures and packages.
• Maintained login and user management in SQL Server database

Environment: SQL Server 2008 Enterprise, Windows Enterprise Server 2008/2008R2/2012, SSRS, DTS, SQL Profiler, and Query Analyzer

Confidential, Tampa, FL

SQL Server DBA/Developer

Responsibilities:

• Used SSIS to migrate databases such as Oracle and Access database, flat files to centralized SQL server destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8minutes.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2005/2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by the clients and advisors.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard. Involved in Creation of Crystal Reports, Created ODBC Connections and database Connections.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: SQL Server 2008/2005, BIDS, Integration Services, TFS, T-SQL, MS Access, Windows XP/7/Vista Server, SSIS, SSRS.

Confidential, Richmond, VA

SQL DBA

Responsibilities:

• Installed SQL Server 2008R2/2005, service packs, hot fixes and security patches.
• Implemented and maintained Database Mirroring as a Disaster Recovery solution.
• Worked on the migration of SQL Server 2005to SQL Server 2008R2.
• Used data Partitioning, Snapshot Isolation in SQL Server 2008.
• Created and scheduled Backup jobs, index maintenance jobs, consistency checks and update statistics.
• Designed and implemented comprehensive Backup plan and maintenance plan.
• Worked extensively on Query Analyzer and Profiler fortuning queries.
• Used Log Shipping for synchronization of database.
• Used DMVs and DMFs for identifying missing indexes, index usage stats and fragmentation level of indexes for query tuning.
• Managed MS SQL database security by creating Logins and Users with required permissions.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks).
• Optimized stored procedures and queries using Index Tuning Wizard.
• Worked on database Design and Architecture based on business user requirements and performed Normalization (3NF) and De-Normalization.
• Performed analysis for setting up a comprehensive Backup and Recovery strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Worked on DTS, BCP and Bulk Insert.
• Automated backup and DBCC scripts for database.
• Restored the databases to point in time.
• Created and modified stored procedures and functions to generate reports.
• Used T-SQL to create database objects including tables, views, indexes, functions, CTE and triggers.
• Used Red Gate SQL compare and Data compare tools to compare and synchronize SQL database schemas.
• Supported 24/7 Production environment.

Environment: MS SQL Server 2008/2005, Windows 2003, SSRS, SSIS, SSMS - SQL Server Management Studio, BIDS - SQL Server Business Intelligence Studio, Red Gate.

Confidential, Boston, MA

SQL Server DBA/Developer

Responsibilities:

• Prepared DFD & 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 (Informatics) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2008.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Tune various packages for reducing their processing time by using parallel processing approach and using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created SQL server dynamic configurationsforSSISpackages. Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for creating reports based on the requirements using SSRS.

Environment: MS SQL Server 2008, SQL server Reporting Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, MS Visio 2008, SQL Profiler, Report Builder.

Confidential 

Intern/Trainee SQL Server DBA

Responsibilities:

• Designed and created SQL Database, tables, indexes, and views based on user requirements.
• Created User Defined Functions, cursors, and Triggers.
• Created & used stored procedures for database transactions in SQL Server.
• Created tables, views, clustered & non-clustered index, user defined data types and functions.
• Developed stored procedures and views for managing efficient data retrieval.
• Wrote various stored procedures for the purpose of application development.
• Developed backup & restore scripts for SQL Server as needed.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used multiple join statements to retrieve data from multiple tables.
• Worked in the team for gathering and analyzing the needs of end user requirements.
• Worked in enhancing the bug/issue tracking system used by the entire team, to produce flexible reporting with respect to the life cycle of an issue.

Environment: MS SQL Server 2005/2008 Enterprise Edition, MS Access, MS Excel, DTS, SQL Profiler, PL/SQL.