SUMMARY

• Over 8 years of IT experience in SQL Server Administration, Development and Database Design in Production, Test and Dev environments with MS SQL Server 2012/2008R 2/ 2008/2005/2000 /7 and in Virtualization with VM ware ESX 3.5 and 4.0.
• Excellent understanding of SQL Server architecture and Database storage structure.
• Well Experience in file and file group’s management and Supported for very Large databases (VLDB) over 3TB, highly transact and Complex Databases.
• Solid experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
• Handful experience in installing SQL Server 2000, 2005, 2008 & 2008R2, 2012 applying service packs and patches on stand-alone and Cluster Environment and Configuring, on 32 bit, 64 bit and i64 Architectures.
• Experience on working and understanding SQL 2012 always on availability groups.
• Configured SQL Server 2005 Two Node Cluster in a Box for test environments using VM Ware Work station 7.
• Well experience in analyzing Performance, Query optimization and tuning, creating Indexes, writing stored procedures.
• Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.
• Experience in with working Agile methodology under 3 week Sprint.
• Attending the daily stand ups and updating the status of the user stories.
• Experience with working with Rally and Cognos reporting tool.
• Attended the Planning and pre planning sessions of the sprint and story pointing the user stories.
• Experience in Index Maintenance Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and, Update Statistics to check Data Integrity.
• Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backup)
• Having good experience in Space issues, Transaction log file size growth, Connectivity issues and regular monitoring of SQL Server error logs and windows Event viewer.
• Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
• Experience in Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Experience in SQL Server up gradation from SQL Server 2000 to SQL Server 2005 and (Side by Side and in place) in 32bit to 64 bit architecture.
• Experience in configuring DB Mail.
• Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL LiteSpeed, Commvault for performance Foglight for alerting Idera.
• Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services.
• Responsible for SSIS package deployment and execution, SSAS cubes deployment, SSRS reports publishing, report generation and availability.
• 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.
• 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 business staff at all levels.

TECHNICAL SKILLS

Languages: C, T-SQL

RDBMS: SQL Server 2012/ 2008/2005/2000 , 7.0, MS-Access, Oracle Database 11g/10g/9i, DB2, MySql, and Teradata V2RX.

Web Technologies: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0),MOSS 2007

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services, EDI.

Data Modeling Tool: Erwin, Visio, Quest Litespeed, DB Artisan. Visual Source safe4.0/6.0,Foglight, Spotlight, Rally

Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7, Unix.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. SQL DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008, 2008R2, 2012 on Test, Development and Production Environments.
• Worked with installation, configuration and deployment of SSIS, SSAS, and SSRS.
• Working closely with different QA teams and maintaining the servers.
• Updating the new changes to the servers based on the ETL logic performed by the developers.
• Experience in working under the sprints with the different team members.
• Attending all planning and Pre-Planning sessions of the different QA teams and story pointing the user stories.
• Created and managed databases across Development and Production instances using SQL Server Management Studio.
• Worked on setting up the always on availability for mirroring and all HR and DR techniques.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Implemented enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN)
• Creating the triggers for the jobs whenever they fail due to any reasons.
• Closely working with the job executions as all the new changes are executed through ETL which takes place through the jobs.
• Created Operators and Configured Database Mail
• Monitored the event logs and server logs for troubleshooting and problem solving.
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms

Environment: MS SQL Server 2005/2008/2008 R bit, Enterprise, Windows server 2003/2008/2008 R2 32 and 64 bit, BIDS, SSIS, SSRS, SSAS, Performance Monitor, Clustering, Mirroring, SQL Profiler, SQL compare and Data compare, Database Tuning Advisor, Lite speed, MS Visio, Alloy ticketing tool, Rally, ALM, ESX 4.0 and VI Client.

Confidential, PA

SQL DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005, 2008, 2008R2, 2012 on Test, Development and Production Environments.
• Worked with installation, configuration and deployment of SSIS, SSAS, and SSRS.
• Created and managed databases across Development and Production instances using SQL Server Management Studio.
• Experience in implementing Failover Clustering support for SQL Server Active Passive Cluster configuration.
• Configured SQL Server 2005 four Node Cluster (Active-Active) in virtual environment using VM Ware Workstation for testing.
• Experience in working SQL 2012 always on availability groups.
• Migrated more than 2000 databases in test, development, and production,
• Refreshed more than 1000 databases from test and development to production during Transition.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle, Teradata and SAS using third-party RDBMS driver tools.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Created Operators and Configured Database Mail
• Understanding and configuring backups on secondary servers for availability group databases.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans on daily/weekly jobs on newly installed SQL servers.
• Used compression Techniques in SQL Server 2008 for backup and restore jobs.
• Scripted logins and users using DB-Artisan tool and ran against the refreshed and migrated databases.
• Created Logins and Roles with appropriate permissions and Fixing the failed logins and user permissions security in ACTIVE DIRECTORY.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Ensured quality support and delivery to the end-user.
• Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
• Worked on setting up the always on availability for mirroring and all HR and DR techniques.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Implemented enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN)
• 24 X 7 On-Call Support.

Environment: MS SQL Server 2005/2008/2008 R bit, Enterprise, Windows server 2003/2008/2008 R2 32 and 64 bit, BIDS, SSIS, SSRS, SSAS, Performance Monitor, Clustering, Mirroring, SQL Profiler, SQL compare and Data compare, Database Tuning Advisor, Erwin, MS Visio, Alloy ticketing tool, ESX 4.0 and VI Client.

Confidential, Overland Park, KS

Production Support SQL DBA

Responsibilities:

• Installed and configured SQL Server 2008/2008R2 on both cluster and stand-alone environment.
• Installed SQL SERVER Service Packs to keep the SQL Server up to date.
• Experience on DB Security in creating logins, users, roles and permissions for the business people.
• Responsible for the code reviews for the store procedures running on both development and production services
• Working with ticketing tool HP service manager and handling the tickets.
• Responsible for activities taking backup restore, refreshing databases as per requirements.
• Working with developers and clearing their doubts in writing better queries.
• Scheduled and created Maintenance plans on databases and also created automated jobs.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping between production server and Secondary servers for high availability solution.
• Configured Database Mirroring with high performance and high availability mode.
• Experience in implementing Failover Clustering support for SQL Server Active Passive Cluster configuration.
• Configured SQL Server 2005 four Node Cluster (Active-Active) in virtual environment using VM Ware Workstation for testing.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle servers.
• Maintaining both Development and Test servers in sync with PRODUCTION server by doing Database Refreshes.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Created Operators and Configured Database Mail
• Monitored the event logs and server logs for troubleshooting and problem solving
• Upgraded the SQL Server 2005 to SQL Server 2008.
• Provided 24x7 On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
• Created SSIS Packages to migrate the data from Oracle databases, XML, text files, Excel files.

Environment: SQL Server 2008/2005/2000 , MS-Access, Windows 2000/2003/2008 , DTS/SSIS, SSRS 2008/ 2005/2000 , SSAS, Visio, HP service manager, Litespeed, SQL Diagrams, Activity Monitor, Spotlight. Indextuningwizard, SQLProfiler, Query Analyzer, Enterprise Manager, SCOM, Silverlight.

Confidential, Atlanta, GA

SQL DBA

Responsibilities:

• As overview of this project I built new Clustered SQL Server 2008R2 environment on bare metal from the scratch. Including Prod, Test and Dev environments.
• Installed and configured SQL Server 2008R2 Instances on both cluster and stand-alone environment.
• Created backup strategies based on database size and scheduled Maintenance plans.
• Responsible for daily routine activities backups, updating stats, refreshing databases as per requirements.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping between DC and DR servers for Disaster recovery solution.
• Implemented SAN replication and performed test failover.
• Configured Database Mirroring with high performance and high availability mode.
• Configured SQL Server 2008R2 two Node Cluster (Active-Active) in virtual environment.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Created Operators and Configured Database Mail
• Monitored the event logs and server logs for troubleshooting and problem solving .
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 2003/2008/2008 R2 64 bit, BIDS, SSIS, SSRS, SSAS, Performance Monitor, Clustering, Mirroring, SQL Profiler, RedGate's SQL compare and Data compare, Database Tuning Advisor, Erwin, MS Visio, Alloy ticketing tool, ESX 4.0 and VI Client.

Confidential, FL

SQL DBA

Responsibilities:

• Created the complex stored procedures, user defined functions to meet the business rules.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in Incremental Loading of Data Warehouse using SSIS and Change Data Capture. multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Designed high level ETL architecture for overall data transfer using SSIS from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Drill down reports, Ad-hoc reports, Drill through reports using ROLAP as source.
• Responsible for creating the reports using the SSRS 2005 and maintained them. Used the various parameter passing techniques to create input for reporting parameters.
• Designed, deployed and maintained various SSRS Reports in SQL Server 2005.

Environment: SQL Server 2005 Enterprise Edition, MS Visual Studio 2005 (SSIS, SSAS, SSRS), Oracle Database 10g, Enterprise manager, EDI, MS PowerPoint, MS Access 2007,Erwin 7x.

Confidential, Jacksonville, FL

SQL DBA

Responsibilities:

• Created tables, views, stored procedure as per design needs.
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Developed, monitored and deployed SSIS packages.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Wrote the queries for the drill down reports.
• Deployed the generated reports on to the server.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Coordinated with onsite folks and mentored the offshore team.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, MS Visual Studio 2005 (SSRS, SSIS, SSAS), Windows Server 2003, MS Access 2007, Oracle 9i.

Confidential

SQL Developer

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on servers.
• Defined various facts and dimensions in the data mart including Fact less Facts and designed the Data Mart defining Entities, Attributes and relationships between them.
• Involved in the entire System study, analysis and design.
• Involved in the creation of schema objects like indexes, views, stored procedures.
• Created SQL tables with referential integrity and developed queries using SQL.
• Involved in writing Triggers which internally called procedures and functions.

Environment: SQL Server 2000, T-SQL, DTS, MS Visual Studio 2005 (SSRS, SSIS, SSAS), Crystal reports 7, Windows 2000 Server, .Net Programming, VSS 4.0.