SUMMARY:

• 10+ years of IT experience in Database Administration, Design Development and Support of SQL Server2012/2008R 2/2008/2005/2000 in Production, Test, Development and Cluster Server Environments.
• Designed and develope tables, functions, stored procedures and triggers in SQL Server 2008R2
• Experience in Writng the SQL queries, Stored Procedures, Functions, and Views.
• Worked on 2014 AlwaysOn High Availabilitynode and theAvailability Groupsnode.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery inSQLServer2000 andSQLServer 2005/2008/2012.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in usingSQLServerTools like DTS, Import/Export Wizard,SQLServerEnterprise Manager,SQL Server Management Studio, SQLProfiler andSQLQuery Analyzer.
• Migration experience from MSSQLServer2000 to MSSQLServer2005/2008, MSSQLServer2005 to MSSQLServer2008 & SQL Server .
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Extensive in Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managingserverand clients.
• Good knowledge on Advanced features like MSDTC, and Full Text Indexing etc. Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQLServer and failover clustering.
• Good experience withSQLServer2005/2008 Online Database Indexing and Recovery. Solid experience on high availabilitySQLServersolutions, including Replication Models (Snapshot/Transactional) andSQLServerclustering (Active - Active, Active-Passive).
• Expert in using Bulk Copy Program (BCP).
• Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform and Data Transformation Services (DTS) packages and SSIS (integration services) with MSSQLServer2000/2005.
• Experience in creating SSIS packages and migrating SSIS packages for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Used Legato backup which provides a high-performance backup and recovery solution.
• Experience on 2014 server also.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2005/2008R2/20012, MS Access 2003

Languages: C, C+, VB Script, Java Script, HTML, XML

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import,Precise i3 for SQL Server

Operating systems: Windows 2008\2003

Software Packages: MS Office 97/2000/XP,2003,2007, MS Outlook 2003,2007,Visio

PROFESSIONAL EXPERIENCE

Confidential, Texas

Sr. SQL Server DBA\Developer

Responsibilities:

• SQL Server 2005/2008R2/2012/2014 Database Administration.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Involved in Module development
• SSIS package design and modul design.
• Physical design and implementation SQL Server databases.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Involved in creating SSIS packages for importing data from text file to database tables.
• Used SSIS to populate data from various data sources and also in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases
• Experience in writing SQL queries and optimizing the queries in SQL Server 2008.
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Involved in Table designing.
• Good in handeling
• Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
• Used SSRS to create reports that draw content from a variety of data sources
• Define DB scripts versioning system to keep track of database versions for all environments
• Prepared the reports for the day-to-day as well as weekly/monthly purposes
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies
• Installed, managed and administrated the MS SQL Server 2008R2/2012 Production and Non Production Servers
• Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments
• Migration of SQL Server 2008R2 in place as well as side by side to MS SQL Server 2012
• Worked on installation of ESM MSSQL Server Module on Production and Non Production Servers
• Monitored Log shipping/Transactional Replication and trouble shooting of errors
• Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning
• Worked on ESM Remediation removing, fixing violations using Windows ESM Console on Production and Non Production Servers
• Implemented Database Mirroring and Transactional Replication as a part of DR plan
• Rebuilt indexes with different fill factors and update statistics manually
• Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Used Database Consistency Checks - DBCC commands for database maintenance
• Supported load and performance (L&P) testing and suggested design fixes.
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
• Running Index Tuning wizard for optimal query performance
• Performed all aspects of database administration, including backups andrecovery
• Handled orphan users while moving databases.
• Proactively monitored, determined and solved issues at SQL/database/server levels
• Worked on documentation of the projects in the SharePoint
• Used HP Service Manager system for managing and completing all service requests

Environment: SQL Server 2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB

Confidential, Overland Park, KS

Sr. SQL Server DBA\Developer

Responsibilities:

• SQL Server 2005/2008R2/2012 Database Administration
• Installed, managed and administrated the MS SQL Server 2008R2/2012 Production and Non Production Servers
• Excel at developing and implementing reporting and data solutions, including custom user interfaces.
• Plan, design, and implement application database code objects, such as stored procedures and views in VB.NET.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Experience in implementing Visual Basic .NET (VB.NET) object-oriented computer programming language implemented on the .NET Framework
• Involved in all phases of the project (Documentation, Designing, Unit testing and Defect fixing).
• Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments
• Migration of SQL Server 2008R2 in place as well as side by side to MS SQL Server 2012
• Worked on installation of ESM MSSQL Server Module on Production and Non Production Servers
• Monitored Log shipping/Transactional Replication and trouble shooting of errors
• Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning
• Worked on ESM Remediation removing, fixing violations using Windows ESM Console on Production and Non Production Servers
• Implemented Database Mirroring and Transactional Replication as a part of DR plan
• Rebuilt indexes with different fill factors and update statistics manually
• Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Used Database Consistency Checks - DBCC commands for database maintenance
• Supported load and performance (L&P) testing and suggested design fixes.
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
• Running Index Tuning wizard for optimal query performance
• Performed all aspects of database administration, including backups andrecovery
• Handled orphan users while moving databases.
• Used SSIS to populate data from various data sources and also in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
• Used SSRS to create reports that draw content from a variety of data sources
• Define DB scripts versioning system to keep track of database versions for all environments
• Prepared the reports for the day-to-day as well as weekly/monthly purposes
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies
• Proactively monitored, determined and solved issues at SQL/database/server levels
• Worked on documentation of the projects in the SharePoint
• Used HP Service Manager system for managing and completing all service requests

Environment: SQL Server 2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB

Confidential, Richmond, VA

SQL Server DBA\Developer

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2005 to SQL Server 2008R2.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using VB.NET.
• Checking Database Health by using DBCC Commands.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSRS, ReportBuilder, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, Cleveland, OH

SQL Server DBA\Developer

Responsibilities:

• Installed SQL Server 2008r2 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version r2.
• Installed Microsoft Service Packs/Patches/Hotfixes.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
• Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Troubleshooted Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Collected data using PSSDIAG, MPS Reports, Profiler to analyze and tune for better optimization.
• Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
• Created Reports using SSRS 2005/2008.
• Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshooted Replication Problems.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.
• Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: Windows 2003, MS SQL Server 2005/2008/2008 r2, T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSAS, SQL Profiler.

Confidential, Chicago, IL

SQL Server DBA/ Developer

Responsibilities:

• Installation ofSQLServer2005 with latest Service Packs.
• Worked in Active/Passive Clustered Environment.
• Writing stored procedures for report generation in migration process and replication.
• Implemented the migration ofSQLServer .
• Wrote severalSQLScripts such as finding long running queries, blocking sessions, archiving data from production to archiveserverand populating reporting data.
• Experience in monitoring software tools used to monitor the environment effectively.
• Successfully implemented Database Mirroring inSQLServer2005 for high availability.
• Maintain both DEVELOPMENT and PRODUCTIONserverin sync.
• Involved in Log Shipping.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Involved in Monitoring Performance of different productionservers.
• Worked in 24x7 production environment.
• Working with the end user gathering requirements for the system.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.
• Creating and Maintaining Database Maintenance Plans.
• Requirements gathering from the end-users.
• Extensively involved in designing the SSIS packages to export data of flat file source toSQLServerdatabase.
• Involved in analyzing the system for setting up newserverandserverconfiguration.

Environment: Windows 2000/2003server, MSSQLServer2000/2005, Erwin, MS Excel, Dell/EMC CX3/CX Series SAN Arrays.

Confidential

SQL DBA

Responsibilities:

• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using T-SQL.
• Creation of Jobs Schedules, Alerts usingSQLServerAgent and Notifications usingSQLMail.
• DBAactivities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Migrated data to other databases and Created DTS Packages to import data from Excel spreadsheets and Implementing user training and providing technical support.
• Designed the logical and physical databases and development ofSQLServerDatabase and Database testing, maintaining the data and writing the procedure.

Environment: SQLServer2000/2005 Enterprise Edition, Advanced Windows 2003Server,SQLQuery Analyzer, Enterprise Manager, IBM system x3650