SUMMARY

• Over 14+ yearsof IT experience inDatabase Administration,Architecture,Developmentand Production Support of MS - SQL Servers, Business Intelligence Tools - SSRS/SSAS/SSIS, SQL, TSQL, PLSQL, Java Script and VB Script in Production, Development and Testing Environments, alsoDeployment Activitiesover all the Environments.
• MS SQL Server installation, configuration, performance tuning, client/ server connectivity, query optimization, back-up/recovery, running Database consistency checks using DBCC for SQL Server 2014, 2012/2012R, 2008/2008R2, 2005, 2000 and 7.
• Monitoring and Automating SQL Server like configuring database mail, creating an operator, jobs, alerts and database maintenance plans.
• Experience in Tablespace, Schemas, Database Tuning and Performance Monitoring and patching Database.
• Experience in implementing Disaster Recovery and High Availability solutions using Replication, Log Shipping, Mirroring, Clustering and Always on high availability groups and Implementation.
• Experience Active Directory security configuration, set up domains, logins and groups and maintenance of them.
• Tuning the database using database engine tuning advisor and identifying and rectifying the cause of blocks and monitoring the traces. Monitoring memory usage, Monitoring batch jobs, running trace and create standards reports on query performance, and migrating of SQL Server database from 2005 to SQL 2008R2, Experience working with production (24x7), Development Environment & Regression Testing landscapes.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as backup, integrity verification, replication verification and indexing updates.
• Used PowerShell to automate server administration, application deployment and to manage Windows, Exchange, SharePoint, and SQL Server,Experience in PowerShell scripts.
• Configured Log shipping from production to disaster recovery server and Support.
• Designing SSIS packages those involved in different tasks like ETL, maintenance plans, monitoring and Deployments.
• Supporting VM environments and production support in large scale environments.
• Migration of SSRS reports from SQL 2008 to SQL 2012/2014 and SQL.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in Performance Tuning, Query Optimization, and Database Consistency Checks using DBCC Utilities.
• Experience in Monitoring Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Hands on experience in Backup and Restoration of databases, Automation of administrative tasks using SQL Server Agent, Security Management and in Managing server and clients.
• Experience in writing T-SQL, SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions, Optimizing Code and Improving Efficiency in databases including DMVs, Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Analyzing query plans, using extended stored procedures, managing indexes and locks, and troubleshooting deadlocks. Security and integrity of the databases.
• Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) to manage data ware house environment and migrations.
• Batch processes, BCP, DTS and SSIS utilities to migrate data from Excel, Flat files, Oracle etc, also various problem-solving and troubleshooting of Web-based applications and Database objects. Resolving database performance issues, database capacity issues and distributed data issues.

TECHNICAL SKILLS

Databases: SQL Server 2014/2012R/2012/2008R 2/2008/2005/2000/7 , Oracle and Teradata

Operating Systems: Windows Server 2008R2, 2008, 2003R2, 2003, Windows 2000 Server/ Advanced Server, Windows XP/7/8, Windows XP/7/8, IBM MVS/ZOS, MVS/ESA and Unix

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query AnalyzerLanguages T-SQL, SQL, XML, Power Shell, COBOL, ASP, SQL and PL-SQL

BI Tools: SQL Server Reporting Server 2008/2005, SSIS, SSAS, Data Cubes, OLTP and OLAP.

Application Programs: SQL Diagnostic Manager, SQL Server Profiler, SSMS, Dreamweaver, Microsoft

Others: Power Shell, Data Modeling, Data Normalization, Relational Database DesignImplementation, Log shipping, Mirroring, Replication, Query optimization andPerformance tuning, Database backup and recovery, Database upgrade, StoredProcedure, functions and triggers, DTS, HP Quality Center, AOTS BMC Remedy.

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

SQL Server DBA

Responsibilities:

• Database Administration, Development and support of MS SQL Servers 2012R, 2005 in production, QA, Development and Replication environments.
• Disaster Recovery and High Availability solutions using Replication, Log Shipping, Mirroring, Clustering and Always on high availability groups and Implementation.
• Involved in migrating of SQL Server database from 2005 to SQL 2012R including consolidating.
• Experience working with production (24 x 7) and development environment.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as backup, integrity verification, replication verification and indexing updates.
• MS SQL Server installation, configuration, performance tuning, client/ server connectivity, query optimization, back-up/recovery, running Database consistency checks using DBCC.
• Configured Log shipping from production to disaster recovery server.
• Database creation, restoration, recovery, User/Schema creation and maintenance space management.
• Monitoring memory usage, Monitoring batch jobs, running trace and create standards reports on query performance.
• Tuning the database using database engine tuning advisor and identifying and rectifying the cause of blocks and monitoring the traces.
• Monitoring and Automating SQL Server like configuring database mail, creating an operator, jobs, alerts and database maintenance plans.
• Writing TSQL code and stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Designing SSIS packages those involved in different tasks like ETL, maintenance plans, monitoring etc.

Environment: SQL Server 2012R, SQL Server 2005, Microsoft Office SharePoint, Microsoft Windows Server 2008R2 Enterprise, Microsoft SQL Server Report Server, Microsoft Internet Information System, ETL, PowerShell.

Confidential

SQL Server DBA

Responsibilities:

• Extensively worked on installing, configuring (32bit/64bit), optimizing and managing different versions SQL Server 2005, 2008 R2 updating with latest hot fixes and service packs.
• Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
• Daily administration, monitoring, and documentation of SQL Servers 2008R2.
• Monitoring replication and make correction actions in case of problems.
• Tuned queries which are running slow using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Closely working on Production issues and production deployment tasks
• Experience in security procedures, SQL Server security and auditing procedures.
• Leading database environment on SQL Server 2008 R2 with service pack upgrades and migrations SQL R2
• Align and set up database policy standards and security procedures for all servers globally.
• Implemented project timelines and standards for SQL Server builds capturing pre-build phase, implementation, production readiness and final rollouts which helped in streamlining the existing initiatives and in giving estimates from the database perspective to various internal customers.
• Scheduling SSIS packages by creating the corresponding job tasks for updating the synchronizing of data between two databases.

Environment: MS SQL Server 2008 R2/ 2008, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2012/2010, Visual Source Safe, MS Office.Net Framework 4.0, C#.Net, Asp.Net 4.0, JavaScript, SQL Profiler, Teradata, Excel and Access.

Confidential - Atlanta, GA

Sr. Technical associate

Responsibilities:

• Installed and Configured MS SQL Server 2005.
• Migrated SQL Server 2005 data bases into SQL Server 2008.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Maintained Replication in SQL 2005/2008.
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Maintained the database consistency with DMV and DMF’s at regular intervals.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

Environment: SQL Server 2008/2005 with clustering, CA Erwin 7.2, Litespeed, T-SQL, Windows 2003, Autosys, Active Directory, Quest LiteSpeed.

Confidential

Sr. Technical Associate

Responsibilities:

• Done CPU Performance tuning for the servers as disk space.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Setup replication within the SQL databases.
• Did trouble shooting of Client connections, viewing error log and applications.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented Database Mirroring and worked with Stored procedures, triggers, cursors etc
• Monitored, set and controlled system capacity plan for future system requirements. Made recommendations for space management and monitoring.
• Code reviews to move it to the production developed by developers.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server 2003, IIS 6.0, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

Confidential

Sr. Software Engineer

Responsibilities:

• Installed and Configured MS SQL Server 2000.
• Performed daily tasks including backup and restore by using SQL Server 2000 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Maintained the database consistency with DMV and DMF’s at regular intervals.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

Environment: SQL Server 2000 with clustering, T-SQL, Windows 2003, IBM MVS/OS, Active Directory, Quest LiteSpeed, db2, focus, Quality Center, Mainframes, Cobol and JCL.

Confidential

Sr. Software Engineer

Responsibilities:

• Done CPU Performance tuning for the servers as disk space.
• Installed and Configured MS SQL Server 2000.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Did trouble shooting of Client connections, viewing error log and applications.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented Database Mirroring and worked with Stored procedures, triggers, cursors etc
• Monitored, set and controlled system capacity plan for future system requirements. Made recommendations for space management and monitoring.
• Code reviews to move it to the production developed by developers.

Environment: SQL Server 2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, IBM MVS/OS, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service, db2, focus, Quality Center, Mainframes, Cobol and JCL.

Confidential

Software Engineer

Responsibilities:

• Coding of ASP Programming, Designing Static and Dynamic HTML web pages.
• Client side Validations were written using Java script.
• Participated in design & development of database using MS Access and Sql server7 and uploading the web portal module and involved in SQL Server 7.
• Module of reports for User lever and Admin level based on custom level.

Environment: IIS, ASP, VB Script, Java Script, HTML, DHTML, Dreamweaver and MS Access, SQL Server 7