SUMMARY

• 8+ years of experience as SQL SERVER Database Administrator/Developer/Designer.
• Experience in maintaining Production Servers containing very large and complex databases in SQL Server 2000/2005/2008/2008 R2.
• Expertise in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB), Complex Databases up to 2 Terabytes and implemented policies/procedures for ensuring the security and integrity of the databases.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in upgrading SQL Server 2000 DTS packages into SQL Server 2005 Integration Services (SSIS) packages.
• Exposed to new features in SQL Server 2008 like Data and Backup compression, Performance Data Collection, Transparent Data Encryption.
• Expertise in Migrating/Upgrading SQL Server 2000 to SQL server 2005 and from SQL Server 2000 and 2005 to SQL Server 2008R2.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts.
• Expertise in Creating Linked Servers between different SQL Servers in SQL Server 2000/2005/2008 environments and also between 32 and 64 bit servers to access database objects in remote locations.
• Worked with SQL Server LiteSpeed tool for backup and recovery and Implemented Database Mirroring to provide high availability and fault tolerance.
• Worked with Ignite in the recent project to monitor the performance, memory used etc.
• Experience in implementing and setting up Disaster Recovery and High availability solutions like different Replication models, Log shipping, clustering and mirroring on physical and virtual machines.
• Extensively Worked onTransactional Replication, Snapshot Replication and peer to peer Replication.
• Expertise in using Temporary Tables, Table Variables, and CTEs.
• Monitoring the event logs and Server error logs using DBCC utilities for troubleshooting purposes.
• Expertise in Database Backup and Recovery procedures for Disaster recovery.
• Good experience with logical modeling and physical modeling by using Erwin.
• Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expertise in using Performance Monitor/Profiler to resolve Dead Locks/Long running queries on 32 bit and 64 bit clustered and standalone server environments.
• Expertise in Performing database consistency checks using DBCC Utilities and handling data corruption in user databases.
• Expertise in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
• Verified the Stored procedures created by developers and fine - tuned the scripts for better performance using Database tuning advisor.
• Created reports using SSRS.
• Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards.
• Monitored the database activity to identify and resolve the performance issues using SQL Server Profiler.
• Expertise in writing and debugging stored procedures, triggers, Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, and Backups.
• OLAP experience using Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) to manage data ware house environment.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to multitask.
• 24 X 7 Production Database Administrator on Call Support.

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and Database Administration of MS SQL Server 7.0/ 2000/2005/2008/2008 R2

RDBMS: MS SQL Server 2000/2005/2008/2008 R2.

Languages: C, C++, XML,HTML, TSQL, Java script

Tools: SQL DB Access, Performance Monitor, Erwin, DTS, SSIS, MS Office 2000/2003/2007 , Visual Studio.

Operating Systems: Windows Server 2000/2003/2008/2008 R2, XP/Vista/7, Unix, Linux.

Backup and Monitoring Tools: Ignite, Lite Speed, VERITAS Net Backup, Spotlight, Idera, RedGate.

PROFESSIONAL EXPERIENCE

Confidential, Miami

SQL Server DBA

Responsibilities:

• Importing bank’s data using Import and Export wizard into tables every week.
• Making sure that maintenance plans on all the servers worked well without errors each day. And if any errors, solving them immediately.
• Installing and also upgrading SQL server for some banks i.e. moving them from stand alone servers to shared database servers and hence upgrading SQL versions.
• Shrinking log files and data files to solve space related issues.
• Discussed in a team and documented everything required for a fail-over clustered environment and eventually helped in building it.
• Checking database performance on ‘Ignite’ which is a performance monitoring tool every hour. ‘Ignite’ also shows the long running queries, memory used, CPU time etc.
• Sending data in CSV files to the developers (As they had no access to the Production databases)
• Arranged meetings on a weekly basis with the managers and other DBA’s so as to discuss the progress and the new changes which can be made for the better performance of the databases.
• Maintaining database consistency using DBCC commands and DMV’s.
• Using Activity Monitor and sp who2 to check for blocking or any deadlocks.
• Rebuilding the indexes which had a fragmentation higher than 30% and if the table had more than 1000 pages (on Sundays) as process would take some time which would make it difficult for the banks.
• Looking at the execution plans, using the trace in the Database tuning advisor and finding the missing indexes.
• Dropping the indexes which had the maximum number of writes and almost ‘0’ reads.
• Setting the ‘max dop’ with the number of processors a server has.
• Converting DTS packages into SSIS packages as some of the servers used SQL 2000.
• Helped in developing an internal book on ‘Rules and better ways to develop databases and tables’ along with two other team members.
• Production support during emergencies i.e. when the servers go down during the first week of the month or after a long weekend.
• Migrating servers from SQL 2000 to 2008R2 and 2005 to 2008 R2.
• Creating test databases for developers for testing and writing new codes(if needed) by taking a part of information from the production databases. The backups of the newly created databases are sent to them.
• Working with developers on stored procedures which take a long time to run.
• Setting isolation levels in some cases in order to avoid locks.
• Solving tickets which is a everyday responsibility. (Tickets on performance issues, space related, data needed, reports making etc)
• Creating reports using SSRS for presentations (which managers needed to present to banks).
• Involved In Database Design, Normalization, Indexing.
• Writing T-SQL join queries in order to extract data in the required way.
• Creating indexes on some views which take a longer execution time.
• Adding Primary key and foreign key constraint relationships to some of the tables which were created long ago. .
• Discussions about the newly added features in the latest version of SQL i.e. ‘Denali’ in the regular weekly meetings.

Environment: SQL Server 2008, SQL Server 2000, SQL Server 2005, Visual Studio 2005/2008, T-SQL, SSIS, SSRS, Ignite, Red Gate, MS-Excel, XML, Windows 2003/NT/XP.

Confidential, GA

SQL Server DBA/Developer

Responsibilities:

• Installed and Upgraded from Sql Server 2005 to Sql server 2008 and 2008R2 on Various Production Servers.
• Implemented Sql Data Compression Using Sql server 2008 For Compressing Data and Log Files, Back Up Level.
• Migrating Databases from Sql server 2005 to Sql server 2008.
• Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using Sql server 2008.
• Used Policy Based Administration feature (Sql Server 2008).
• Created Table Valued Parameters (Sql Server 2008) of a table value data type and be able to pass this variable into a stored procedure.
• Rendered Reports to Microsoft Word using Sql Server 2008.
• Created new database objects like Tables, Procedures, Triggers, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Data loading into Tables using SSIS Packages.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Data Extracting from Different online Forms and Integration Data to Load into the Tables.
• Involved In Database Design, Normalization, Indexing.
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Try-Catch, Common Table Expression (CTE), Ranking Functions.
• Installed SQL Server 2000/2005 on windows 2003 advanced servers, applied services packs.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Designed and Developed Various Reports Like Adhoc, Matrix and Tabular Using SSRS
• Involved in maintaining Sharepoint Server to host web sites that access shared workspaces, information stores and documents.
• Documented database design and developed a data dictionary for corporate database.
• Identified and resolved database Performance issues, database capacity issues and other distributed data issues.
• Maintaining SQL Script for creation of Database Objects.
• Analyzing long running slow queries and tune the same to optimize application and system performance.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Scheduled jobs for backup, and created alerts for error reporting.
• Compared Database Objects using Red gate Tool for schema Changes, Data changes during up gradation Process from Development to Production Servers and Sql lite Speed for Monitoring.
• And also configured SQL servers on Foglight for monitoring.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Generated reports using SSRS .
• Expertise in creating and supporting in OLAP cubes.
• Expert in creating Dimensional, fact table, star schema and Snow flake in SSAS.
• Expert in Normalization and De-normalization techniques for OLAP.
• Comfortable with writing Multidimensional Expression(MDX)
• Checking Database Health by using DBCC Commands.

Environment: SQL Server 2008, SQL Server 2005, Visual Studio 2005/2008, T-SQL, SSIS, Red Gate, Lite Speed, MS-Excel, XML, Windows 2003/NT/XP.

Confidential, CA

Sr. SQL Server DBA/Developer

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2000/2005 on windows 2000/2003 Servers. Installation of SQL Server Service Packs & hot fixes.
• Installed and Configured SQL Server 2005 with 64 bit clustered environment.
• SQL SERVER 2005/2000 Production Environment.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005 on Windows 2003.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation
• Database mirroring, database snapshot, DDL triggers, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQL CMD and dedicated admin connection.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Configured more than 2 GB Ram on 32 bit Environment.
• Migrated DTS packages to SSIS packages.
• Expertise in SQL server Reporting Services(SSRS) and SSAS(Building OLAP cubes)
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Worked in Active passive cluster environment.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan.
• Implemented new topics like CLR integration on Development Server.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• 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.
• Did Performance Tuning of the Stored Procedures.
• Routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.
• Experience in creating cubes in SSAS.
• Used APPLY clause and also implemented with CROSS and OUTER APPLY to join tables and table variable functions.
• Hands on experience in trouble shooting database issues.
• Update statistics, database integrity check and Backup operations.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows 2003 64-bit, DTS, SSIS, SSAS, SSRS, Profiler, Share point, TFS, LiteSpeed.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installed and configured SQL Server 2000.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Migrating SQL Server 7.0 data bases into SQL Server 2000.
• 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.
• Dropped and recreated the indexes on tables for performance improvements.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Created indexes to speed the execution of data retrieval queries and stored procedures.
• Experience in applying Service Packs at database and OS Level.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• 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.
• Worked on Fail over Clustering for SQL Server databases for mission critical applications.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.

Environment: SQL Server 2000, T-SQL, Windows 2003, DTS.

Confidential

SQL Server Developer

Responsibilities:

• Worked on call 24/7 Support on weekly basis.
• Installation and configuration of MS SQL Server and Clients.
• Database designing, Logical and Physical Data modeling using Erwin.
• Implement high availability through database mirroring and Merge Replication.
• Knowledge Import / Export using DTS and BCP utility.
• Setting up DR sites using log-shipping and wrote dynamic stored procedures for moving Databases from production server to DR server.
• Setting up Replication using Dynamic scripts and solving problems.
• Designed DTS packages to refresh data on Development and QA.
• Wrote dynamic stored procedures to create Database Roles and grant permission to roles and adding logins to specified roles.
• Designed new schema for data partition and created Partition views for better performance.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.
• Created updatable partitioned views.
• Created Stored Procedures and triggers to perform automated rules, updating to related tables.
• Discussions with Product team for new features.

Environment: SQL Server 2000, T-SQL, DTS, Enterprise Manager, Query Analyzer, MS Access 2000.