SUMMARY:

• 13+ years of experience with the 32bit, 64 - bit environments as Microsoft SQL SERVER DBA in Production, Development and Testing in Clustered and Stand alone Server Environment.
• Experience in installing MS SQL SERVER 2017, 201, 2008R2, 2008, 2005, 2000; updating with hot fix and service packs.
• Good knowledge and handful of experience on implementing Always ON High availability feature.
• Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in Backing up, restoring the databases manually and also by scheduling the jobs and Maintenance Plans.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Handful of experience in PowerShell Scripting.
• Implemented In place and Side by Side Migration of MS SQL SERVER 2005/2008/2008 R2 to MS sql server 2012, 2014 & 2016 environments.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Tables, Functions, Normalization, Indexes, Stored Procedures, Cursors, Triggers, Views and other SQL joins and query writing.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc. for finding out long running queries.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Expert in developing T-SQL (DDL, DML, DCL ) statements.
• Expertise in Data Modeling Concepts.
• Also Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MS VISIO.
• Configured the AWE and /3 GB switch for the SQL server 2005 on 32-bit boxes.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in handling the Change Data Capture (CDC) with different retention time.
• Experience in SQL Upgrades SQL and Building SQL Clustering.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Experience in using the DMVs, DMFs, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Experience with Microsoft SQL Server Integration Services or any compatible ETL tool and Reporting tool with SQL Server Reporting Services using Business Intelligence Development Studio (BIDS)
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Expert in creating SQL Server Reports using SSRS 2005 and 2008.
• Expert in using Version Control Software like Visual SourceSafe (VSS).
• Extensive experience in the development of Reports using SQL Server 2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, Drilldown reports in multiple formats using multi - dimensional objects.
• Strong ability in Scheduling and deploying reports on Report manger.
• Experience working with change control process
• Expert in using MS Office suite 2007 including MS Access.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Tools: SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Operating Systems: Windows 2000/2003/2008/2008 r2/2012/2016/XP/VISTA/7, UNIX (Sun Solar), LINUX (RHEL, CentOS)

MS: SQL Server 7.0/2000/2005/2008/2012/2014/2016/2017 , mysql, MS Access

ETL Tools: Data Transformation Services, SSIS, SSISDB

Reporting Tools: SSRS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer, Profiler, Database Tuning Advisor, DMVs, DMFs, server side trace.

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

Third party Tools: Erwin, Visio, Red gate products, Lite Speed, spotlight, SCOM

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

SQL Server DBA

Environment: MS SQL Server 2017, 2016, 2014, 2012, 2008R2, 2008,2005, TSQL,OLTP,OLAP, Windows 2008/2008R2/2012/2016 versions, Redgate’s DataMasker, Erwin, Redgate Monitoring tool and other redgate products, EMC networker backup tool, SSIS, SSRS, SSAS.

Responsibilities:

• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Masking Sensitive/PII data in non-production databases using Redgate’s Product called DataMasker.
• Have good experience in Automation of the Data Masking PII/Sensitive data on all Non-Production Databases.
• Installation of MSSQL Server 2017, 201, 2008R2 on Production, UAT, Testing and Development environments.
• Working on tickets\incidents within the SLA’s, as a part of operations support DBA in all sql environments.
• Plan, create, implement, and maintain database maintenance plan,s including DBCC commands, defragging indexes etc. including all supporting documentation.
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Strong knowledge in working on Very Large databases (OLTP) and involved in troubleshooting the problems and dealing with complex databases.
• Managing and maintaining the current database deployment process. Maintain proper Patch levels in all environments of SQL Servers.
• Migrated databases from sql server 2008, 2008R2, 2012 to Sql Server 2014, 2016, 2017.
• Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Mirroring experience with both synchronous and Asynchronous and applying service packs.
• Handful of experience in configuring Log shipping and troubleshooting the related issues.
• Extensively used Repositories like Team Foundation Server (TFS) and Visual Source Safe.
• Plan, implement and maintain Backup and Disaster Recovery Solutions.
• Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
• As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
• Participate in strategic planning of database technology usage such as SQL Server Version levels, hardware levels, jobs automations, failure notifications, server monitoring etc.
• Good knowledge and handful of experience in configuring and working with Always on Availability Groups. Also Used Powershell to automate admin tasks.
• Querying the databases using the Power shell scripts.
• Expertise in working on Virtual Machines with SAN and NAS Storages.
• Familiar with Virtualization technology and running Windows inside a Virtual Machine .
• Fixed the failed PRINCIPALS (logins), user permissions and security in Active Directory and SQL Server Level.
• Used the Powershell scripting to get the most consistent production environment.
• Created numerous reports using reporting services SSRS and deploying them on SharePoint.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Expertise on physical storage SAN configuration on different RAID levels.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal, vertical partitioning and Setting up clustered Instances.
• Handful of experience in PowerShell Scripting.
• Creating Logins and Roles with appropriate permissions. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
• Good knowledge and handful of experience on implementing & maintaining Always on High availability starting on sql server 2012, 2014, 2016 & 2017.
• Plan, monitor, request allocation and maintain appropriate amounts of disk storage for all SQL Server, communicate storage estimates to Network Solutions group.
• Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Involved in capacity planning, sizing and database growth projections.
• Monitor and modify performance using execution plans and Index tuning.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Interacting with development team in writing good standard TSQL queries. Rebuilding indexes with different fill factors and updating statistics
• Extensively worked on Backup compression and data compression in SQL Server 2017/2016/2014/2012/2008 R2/2008.
• Good Knowledge and experience in implementing SQL database in SQL Azure and AWS cloud computing platform.
• Handful of experience in implementing automation of operational tasks using scripts.
• Applied patches, hot fixes, cleared .NET framework corruption errors.
• Provide technical support, troubleshooting and resolution for database related issues. Actively participated in forums, newsgroups and as a volunteer in Technology Meetings.
• Handful of experience in implementing & maintaining SQL databases in SQL Azure and AWS RDS cloud Computing platforms.
• Extensively worked on Active-Active and Active-Passive Clustering
• Review query plans, optimize index usage, perform TSQL code review and optimization as needed.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Confidential, Charlotte, NC

SQL Server DBA

Environment: MS SQL Server 2005, 2008R2, 2012, 2014, 2016 TSQL,OLTP,OLAP, Windows 2008/2008r2/2012, Spotlight, LiteSpeed, Fog light, SSIS, SSRS, SSAS, Visio 2007/2010/2013.

Responsibilities:

• Installation of MSSQL Server 201, 2008R2 on Production, UAT and Development environments.
• Working on tickets\incidents within the SLA’s, as a part of operations support DBA.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Strong knowledge in working on Very Large databases (OLTP) and involved in troubleshooting the problems and dealing with complex databases.
• Migrated databases from sql server 2008, 2008R2, 2012 to Sql Server 2014.
• Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Mirroring experience with both synchronous and Asynchronous and applying service packs.
• Handful of experience in configuring Log shipping and troubleshooting the related issues.
• Extensively used Repositories like Team Foundation Server (TFS) and Visual Source Safe.
• Good experience in migrating data from MySQL to Sql server databases.
• Handful of experience in configuring and trouble shooting Master-slave replication in Mysql both in windows and linux operating system.
• Migrated the 5.7.21 MySQL servers from RHEL linux to CentOS 7 environments and coonfigured same Disaster recovery plan, backup strategies, users, cron jobs, logins in new environment as well.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
• As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
• Also implemented Mirroring for DR Plan.
• Good knowledge and handful of experience in configuring and working with Always on Availability Groups. Also Used Powershell to automate admin tasks.
• Querying the databases using the Power shell scripts.
• Expertise in working on Virtual Machines with SAN and NAS Storages.
• Familiar with Virtualization technology and running Windows inside a Virtual Machine .
• Fixed the failed PRINCIPALS (logins), user permissions and security in Active Directory and SQL Server Level.
• Used the Powershell scripting to get the most consistent production environment.
• Created numerous reports using reporting services SSRS and deploying them on SharePoint.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Handful of experience in PowerShell Scripting.
• Creating Logins and Roles with appropriate permissions. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
• Good knowledge and handful of experience on implementing Always on High availability starting from sql server 2012 and 2014 versions.
• Good experience with handling 15 to 20 TB sizes of Databases and configured Disaster Recovery Plans to meet the application partner's requirements.
• Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Involved in capacity planning, sizing and database growth projections.
• Monitor and modify performance using execution plans and Index tuning.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Interacting with development team in writing good standard TSQL queries.
• Handful of experience in implementing automation of operational tasks using scripts.
• Applied patches, hot fixes, cleared .NET framework corruption errors.
• Documentation, Training and mentoring the staff.
• Actively participated in forums, newsgroups and as a volunteer in Technology Meetings.
• Handful of experience in implementing SQL databases in SQL Azure and AWS cloud Computing platform.
• Good Knowledge and experience in implementing SQL database in SQL Azure and AWS cloud computing platform.
• Extensively worked on Active-Active and Active-Passive Clustering
• As a part of the team, was always involved in production deployment or production release.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Confidential, Wilson, NC

SQL Server DBA

Environment: MS SQL Server 2005, 2008R2, 2012, 2014, 2016, TSQL,OLTP,OLAP, Windows 2008/2012, Visio 2007, SSIS, SSAS, SSRS.

Responsibilities:

• Reviewed and analyzed requirements for New Projects with Application and Business teams.
• Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
• Installed SQL Server 2008R2/2012/2014 manually and by using HP Server Automation tool.
• Installed, configured and administered SQL Server Integration and Reporting Services.
• Migrated Servers from SQL Server 2000 and 2005 and 2008R2 to 2008R2 and 2012 and 2014 based on the application team requests.
• Based on the business need created Transactional Replication on Different applications.
• Configured and maintained database mirroring for high availability.
• Implemented AlwaysOn Availability Group as a High Availability solution on SQL Server 2012 and 2014.
• Applying the Hot fixes and patches based on the requirements for different stores within the maintenance window.
• Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
• Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management.
• Created Database Maintenance Plan to implement Database backups, Integrity Checks and indexing.
• Evaluated 3rd party SQL Server Monitoring Tools that could be used for database administration.
• Configured SQL Server 2008R2/2012 Active/Passive Clusters in different environments applying the installation and configuration standards.
• Handling of the database backup failures, fixing the issues and make sure the availability of daily backups.
• Resolving the Database I/O Consistency errors and Allocation errors.
• Performing Health checks and Monitoring performance of the Production Servers.
• Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
• Providing the accesss to users based on the requirement to the Production/UAT/QA/Development Servers with appropriate approvals.
• Handful of experience in implementing SQL databases in SQL Azure and AWS cloud Computing platform
• Handling of the low Logical disk space issues, Tempdb issues, Data file and Log file issues.
• Monitored the event logs and server logs for troubleshooting and problem solving.
• Used Powershell to automate admin tasks.
• Querying the databases using the Powershell scripts.
• Used the Powershell scripting to get the most consistent production environment.
• Database refreshments from Production to DEV/UAT/QA environments.
• Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures.
• Used DMVs, Alerts, SQL Profiler, Performance Monitor to proactively monitor and tune the Database Environment
• Adhered to the Change Management procedures.
• Evaluated new features in SQL Server 2012 and SQL Server 2014 in lab environment namely Enhanced to Backups, contained databases, Security Principals and AAG.

Provided 24/7 Production Support (on-call) and resolved all tickets related to SQL Server Database and tickets opened by application and operations team including SSIS/SQL Job failures, Disk space, Blocking

Confidential, Omaha, NE

SQL Server DBA

Environment: MS SQL Server 2008R2/2012, TSQL,OLTP,OLAP, Windows 2008, Idera, Erwin, Visio 2007, SSIS, SSAS, SSRS.

Responsibilities:

• Migration of databases from SQL Server 2005 to SQL Server 2008R2.
• Migrated the SCOM (System Center Operations Manager) 2007 R2 and installed required Service packs and cumulative updates to the SQL Server 2008R2 environment.
• Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via Active Directory.
• Providing 24/7 support for critical production databases (OLTP and OLAP).
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
• Expert in Deploying, Scheduling and running SSIS jobs by using Proxy Accounts.
• Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Data migration using bulk copy program (BCP) and DTS to Flat files and Expertise in Data Staging.
• Handful of experience in working with 12-15 TB sizes of databases and did partition of tables involved and configured Disaster recovery plans.
• Experience in writing scripts like retention of data using batch deletes.
• Export or Import data from other data sources like oracle, flat files using Import/Export, SSIS.
• Good Knowledge and experience in implementing SQL database in SQL Azure and AWS cloud computing platform.
• Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Developed, deployed and monitored SSIS Packages, Incremental loading and dynamic SSIS Packages with parent package variables.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Worked on SQL Server Reporting Services (SSRS), drill down, parameterized reports, and cascading reports deployed them on Report server from Report Manager.
• Performed horizontal data partitioning for efficient management of database tables and indexes, Full text indexes, Using Contains, Tuning LOB, BLOB data types.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Mirroring experience with both synchronous and Asynchronous and applying service packs.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
• Experience in using ERWIN tool for Entity Relationship diagrams and reverse engineering.

Confidential, Atlanta, GA

SQL Server DBA

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2012, 2008 (R2), Microsoft SQL Server 2005, Windows 2003/2008 Server, IIS Server 7, MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2)/2012 on Test, Development and Production Environments.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
• Experience working with TSM Backups and Restore.
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
• Implemented Database Mirroring, Log Shipping, Transactional Replication as a part of DR plan.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Configured Database Mail for failure Job notifications
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Enabling and Disabling Change Data Capture (CDC).
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler
• Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
• Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Worked with DTS Packages to load the massaged data into Data Warehousing System.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Extensively worked on performance issues like Update statistics and Autostats
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Mentored team members to optimize SQL Queries.

Confidential, Columbus, OH

SQL Server DBA

Environment: MS SQL Server 2000/2005, IIS Server 5.0, Windows 2000/2003 servers, Outlook Express, .NET, MS Access.

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2000 and 2005 in development and production environments.
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Did Migration from SQL Server .
• Created Database Diagrams using E RW in Data Modeler.
• 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 2005 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.

Confidential

SQL Server DBA/Developer

Environment: MS SQL Server 2000/2005, Excel, Query Analyzer windows NT/2000 server & Professional

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using ERWin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000\2005.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.