SUMMARY:

• 8+ years of experience with the 32bit, 64 - bit Microsoft SQL Server in Production, Development and Testing in Clustered and Stand-alone Server Environments
• Experience in installing MS SQL Server 2000, 2005, 2008, 2008R2 2012 and updating with hot fix and service packs
• Extensive experience in implementing high availability solutions on physical and virtual machines
• Implemented Side-by-Side Migration and in-place Upgrade of MS SQL Server 2000/2005/2008 R2 to 2012
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-builtGlobal variables for the instant analysis
• Expert in Data Integrity, Performance Tuning and Query Optimization
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements
• Performed BCP, BULK INSERT, imported and exported data from different Data Sources.
• Experience in Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003/2008 Server
• Experience in analyzing Locks, Dead Locks and handling the Isolation Levels and Concurrency Effects
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis
• Experience in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans
• Configured SMTP Server for Database Mail setup and received alerts for the Threshold values
• Experience in Migrating DTS 2000 packages toSSIS packages in 2005 using Migration Wizard
• 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
• Auditing of database for user transactions, login and database action and in removing orphaned users
• Experience in using SSIS tools like Import and Export Wizard, PackageInstallation, and SSIS Package Designer
• Expert in creating SQL Server Reports using SSRS 2005, 2008, and 2012
• Extensive experience in the development of Reports using SQLServer2000/2005 Reporting Services (SSRS) and MS Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, and drilldown reports in multiple formats using multi - dimensional objects
• Thorough understanding of different RAID levels implementation
• Strong ability in Scheduling and deploying reports on Report manager
• Responsible for SSIS package deployment and execution, SSAS cubes deployment, SSRS reports publishing, report generation and availability.
• Experience in Analysis Services(SSAS) OLAP Cubes, Star Schema and Snow Flake Schema, ETL and Data Warehousing
• Derived and documented the Root cause analysis for production issues.
• Experience in working with version control management team.
• Provided support for 24x7 availability of database Services and ensure to meet the SLA.
• Flexible enthusiastic and project oriented team player with excellent written verbal communication and leadership skills to develop creative solutions for challenging clients need.
• Zeal in self learning newer versions of SQL Server and upcoming technologies from MSDN articles.
• Researched and having conceptual knowledge on SQL Server 2012(Denali) implemented AlwaysOn on customized self built PC using windows server 2008R2 and SQL Server 2012 developer previews.
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and Hands on experience with SQL Server 2012 Always On High Availability Groups.
• Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach. Prowess in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions to them.
• Experience in developing and tuning SQL Server Integration Services (SSIS) packages and Reporting Services (SSRS) reports. Experience in creating deployment utility to Deploy SSIS Packages over Production and QA Systems.
• Hands on experience with SQL Server 2012 Always On High Availability Groups.
• Expertise in extracting and transforming data using data transformation services like import/ exportwizard, BCP, Bulk insert, attach/detach. Prowess in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions to them.
• Experience in developing and tuning SQL Server Integration Services (SSIS) packages and Reporting Services (SSRS) reports. Experience in creating deployment utility to Deploy SSIS Packages over Production and QA Systems.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008R2/2008/2005,2000/7.0, Oracle, MYSQLMS Office Access 97/2000/2003.

Languages: T-SQL, C, C++, JAVA, ASP.NET, Visual studio2005/2003, XML

Technologies: VB.NET, .NET FRAMEWORK, ASP.NET, Microsoft Office Suite

Tools: Active X, Litespeed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0,SSIS,SSRS,SSAS,SCOM,Tivoli TSM

Operating Systems: Windows 2000, Windows NT, Windows Server 2003/2008/2008 R2,2012 Windows 95/98/XP/Vista/7/8.

Others: Microsoft office, Microsoft Project, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, North Carolina

SQL Developer/DBA

Responsibilities:

• Installed and configured SQL Server 2008 and 2012
• Performed backups, DBCCutilities, updated index statistics, monitored database and disk space.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• To set up SQL Server configuration settings.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Rebuilding the indexes at regular intervals for better performance.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2008/2012 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET, T-SQL, Microsoft Reporting Service.

Confidential, Duluth, GA

Sr. SQL Server DBA

Responsibilities:

• Installation of Teradata 13.10 with ODBC drivers.
• Expert in security of SSRS and Subscription schedules of RS.
• Setting security levels for each report and checking monthly reports up to date.
• Worked both 32 bit and 64bit of ODBC administrator.
• Experience Connected the SQL server database through SQL assistant from ODBC settings.
• Worked both Development and production of the Teradata environment.
• Experience in linked server connection between SQL server and Teradata server.
• All historical data stored in Teradata database, push the old data from cube to Teradata.
• Changed the passwords of the Teradata in every 90 days through SQL assistant.
• Expert in solving issues in BO (SAP).
• Expert in solving Login issues, Requesting new access process, checking security level in BO (SAP).
• Worked both Web intelligence reportsand Desk intelligence reports in BO (SAP).
• Worked in BO (SAP) issues like not retrieving data while running the report, Spool space error, Web page hanging or takes more time running the report.
• Worked both SQL 2005 and SQL 2008 servers in development and Production environment.
• Expert in creating SQL authentication logins and providing different permission to users in different databases.
• Created the backup in maintenance wizard with cleanup historical backups.
• Based on the maintenance plan created job schedule in SQL server agent.
• Creating environment variable in production server and Config files.
• Expert in creating new site collection in SharePoint sitein central administration.
• Adding groups in the SharePoint site in different level of permissions.
• Deployed the Dev SharePoint site to Prod SharePoint site.
• Reduce the pending messages in Message queue server in both Development and production server.
• Expert in taking backup and Restore used third party tool Quest, Idera and redgate.
• Export in High Availability and Disaster Recovery like Mirror, Log shipping, Replication and Clustering.
• Migration from one server to another server and DTS packages to SSIS package.
• Export or import the data from one instance to another instance using EXPORT/IMPORT wizard.
• SSIS package deployment from development server to production server in both SQL server and File system Deployment.
• Expertise in SQL Server Analysis Services (SSAS).
• SQL Server Reporting Services(SSRS)
• Integrated SQL server profiler traces with Performance monitor to find performance and dead locks.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005, 2008, and 2012
• Transferred data (ETL) to Data ware house Environment using SSIS
• Expert in creating Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Successfully deployed reports in various sources like XML, Web Browser and PDF.

Environment: SQL Server 2012/2008/05/00 , Windows 2003, Windows 2008 Server, MS SQL Server 2000/2005, C#.net, VB and ASP.NET, Windows admin.

Confidential, North Carolina

SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Developed logical design and physical design.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Fine tuning of database objects and server.
• Worked with SQL Server 2005 side by side upgrade from sql server 2000.
• Expertise in setting up and troubleshooting Database mirroring.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs. reated Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• 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
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Developed SSIS packages, stored procedures, functions, triggers.

Environment: SQL Server 2005, T-SQL, Excel, Advanced Windows 2000 Server, Visual Source Safe 6.0 Version Control Management), TFS (Team Foundation Server), 2003/2005.

Confidential, Florida

SQL DBA

Responsibilities:

• Managed and developed the SQL Server 2008/05/00 servers.
• Installation and configuration of SQL Server 2008 on Clustered Environment.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Involved while Configuring the Log shipping and creating the Standby server.
• Created New Databases and maintained existing User / System Databases.
• Monitored and tuned databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2005.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Wrote various Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports
• Designed database by using principles of normalization.
• Responsible for Design and Normalization of the database tables.
• Created database triggers to implement complex business rules and processes.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Increased the size of the database, transaction logs and database devices.
• Created and maintained scheduled jobs and checked consistency of databases.
• Created OLAP cubes to meet business requirements and allow users to perform fast queries.
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.
• Created jobs for Transfer logins, SSIS packages execution Schedules.
• Transformed data from various data sources using OLE DB connection by creating SSIS and DTS packages.
• Used SQL Profiler and Tuning Advisor to improve the performance by adding suggested tasks on the tables.
• Designed and developed various complex reports and deployed over the network.
• Looked after the backup jobs across different servers.

Environment: SQL Server 2000/2005/2008 , Windows server 2003, SSIS, DTS, C#, .NET, Web Services, JavaScript.

Confidential, Atlanta, GA

SQL Server DBA/Developer

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2000 and 2005
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Prepared estimates for Database, table size growth
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules
• Monitor connections, locks and performance of SQL server
• Responsible for MS SQL Server 2000 configuration, tuning and provide 24x7 dedicated support to all Production, Development and Cluster Servers
• Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevel
• Worked on physical storage SAN configuration on different RAID levels
• Installed and configured Microsoft SQL 2 node Clustering (Active/Passive)
• Creating Logins and Roles with appropriate permissions
• Involved in the logical and physical data modeling using Erwin
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications
• Developed and managed DTS Packages and scheduled jobs for periodic and nightly batch processes
• Configured Log shipping of production servers and created the DR servers
• Assigned permissions to users and roles. Supported column level permission. Administered secure authenticated logins including both Windows and SQL Server Accounts
• Expertise in Security Issues such as creation and granting permissions on various Objects.

Environment: MS SQL-Server 2000/2005, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.