Summary

• Over 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 to 2008 R2
• Experience in using the DMVS, DMFS, SYSTEM VIEWS and in-built Global 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 to SSIS packages in 2005 using Migration Wizard
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Auditing of database for Worked on logins, user permissions and security in SQL server level and fixing orphaned users.
• Worked on logins, user permissions and security in SQL server level.
• Loading Data Warehouse using SQL Server Integration Services SSIS and building reports using SQL Server Reporting Services SSRS in star schema
• Extensive experience in the development of Reports using SQL Server 2000/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.
• Strong experience in mentoring and working with team, coordinating with developers , good communication skills documentation , supporting architects, decision support meetings and 24/7 on call production support.

Technical Skills

• Databases: MS SQL Server 2012/2008R2/2008/2005/2000 7.0, oracle8i.
• Programming: Visual Basic 6, Visual Basic 5, C, C , JAVA, .NET SQL
• Operating System: Windows 2008 R2/2003/2000 Advanced Server, NT Windows 9x, Linux
• Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML
• Tools: SQL DB Access, Performance Monitor, Backup Utility, SQL LiteSpeed, Visio 2000, RedGate, FogLite
• Network Topologies TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Professional Experience

Confidential

Sr. SQL DBA

Responsibilities:

• Installed stand-alone and clustered SQL Server 2008 and 2008 R2 on 64 bit systems.
• Migrated SQL Server 2005 databases to SQL Server 2008 R2 databases including SSIS packages
• Performed in-place upgrade from SQL Server 2008 to 2008 R2.
• Implemented and maintained Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery solution.
• Managed and administrated SQL Server 2008R2/2008/2005 on production and non-production servers
• Developed a SSIS package to load data from SQL Base to SQL Server 2008 R2
• Performed Failover drill tests to check the High Availability during disasters
• Used LiteSpeed for backups and maintenance jobs which includes updating statistics, database integrity checks
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans
• Configured DB mail by creating accounts and profiles.
• Worked on Linked servers.
• Monitored alerts using FogLight and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Provided On call Production support.
• Implemented partitioning on large table to get the performance.
• Tuned stored procedures by using execution plans.
• Used table hints in the queries to avoid locks in the server.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV's and DBCC commands.
• Day-to-day activities like taking backup or schedule the backups daily for database and transaction log on disk and restore the databases.
• Created Logins for the users and manage their permissions.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Used Bulk insert to load huge tables.

Environment: MS SQL Server 2005,2008 R2,2012 Windows 2003 Server, Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, Excel, HTML,JIRA 4.3.

Confidential SQL DBA

Responsibilities:

• Installed SQL Server on both 64 32 bit systems
• Managed and administrated SQL Server 2008R2/2008/2005/2000 on production and non-production servers
• Installed SQL Server 2008/05 and service packs on Windows Server Clustered environment
• Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases including DTS to SSIS packages
• Updated statistics, performed database integrity checks and Backup operations
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Set up and monitored transactional replication, database mirroring on Production, QA and Dev servers and troubleshot errors.
• Developed and created the new database objects including tables, views, index, stored procedures, functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Configured SQL Server and SSRS using IIS
• Experience in using ERWIN tool for designing the reporting databases
• Responsible to monitor and troubleshooting Log Shipping
• Assisted on the Adhoc-Query requests based on the requirement by using joins, sub queries and co-related sub queries
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks
• Created SSIS packages to load robust data from different heterogeneous data sources like Oracle, DB2 to SQL server
• Created, scheduled database maintenance plan using SSIS Maintenance plan task
• Used Online Indexing and online Restoring in SQL 2005
• Extensively used Repositories like Team Foundation Server TFS .
• Prepared, maintained and modified SQL server installation and configuration documents.

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

Confidential SQL DBA

Responsibilities:

• Installation of SQL Server 2008/2005, service packs, hot fixes, security patches, Litespeed
• Implemented and maintained Database mirroring as a Disaster Recovery Solution
• Worked on the migration of SQL Server 2000 to SQL Server 2005
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005
• Update statistics, database integrity check and Backup operations
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
• Designed and implemented comprehensive Backup plan and disaster recovery model
• Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
• Created and modified Stored Procedures and Functions to generate reports
• Used log shipping for synchronization of database
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
• Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism
• Practical experience in managing the internal and external MS SQL database security .
• Maintained databases with DBCC Rebuilding Indexes, Integrity Checks
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Worked on database Design and Architecture based on business user requirements and performed Normalization Third Normal Form and De-Normalization.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Familiar with taking backup of Regex with Akeeba Backup Tool.
• Involved in validating credit card number using regular expressions.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.

Confidential SQL DBA/Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Experienced in T-SQL development, documenting, coding, modifying and implementing business technology solutions using MS SQL Server.
• Good knowledge in normalization and relational database management systems.
• Developed Complex Queries, Joins and Sub queries in SQL Server 2005.
• Actively participated in gathering of User Requirement and System Specification.
• Dropped and recreated the indexes on tables for performance improvements.
• Used Stored procedures, Inline and Multi statement Functions extensively.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained referential Integrity.
• Imported Data from text files and Excel into SQL Server 2005 database using SSIS/DTS package.
• Bulk insert from one table to another across database using SSIS Packages.
• Performed data type conversion while importing data from another sources DB2, Microsoft Access .
• Created Data Models and Data Mining in SQL Server.
• Export or Import data from other data sources like flat files using Import/Export of DTS.
• Generated Report Models using Model Designer, to enable the business users to build ad-hoc reports using Report Builder.
• Developed ETL application using SSIS packages to get data from different sources and load into SQL server database and also to send the file into different format from SQL Server Database.
• Developed Drill-through and Drill-down reports using MS SQL Server Reporting Services SSRS .

Environment: Erwin, XML, T-SQL, SQL Server2000/2005, VisualStudio.NET IDE, Microsoft Access 2003, Business Intelligence Tools SSRS, SSIS, SSAS .