SUMMARY

• 7+ years of experience in Database Administration and Development for very large and complex databases in SQL Server 2012/2008/2005/2000.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security and Data Transformation Services.
• Migration of SQL Server 2000 databases into SQL Server 2005, 2008 and 2012 versions.
• Dexterity inimplementingdifferent types ofHigh Availability & disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping,Database mirroring and clustering.
• Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevels.
• Exquisite skills in database Backup, Restoration, Recovery, Replication, Linked Servers, Database Maintenance Planning.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Outstanding experience inSQLEnterprises Manager and SSMS - creating and scheduling jobs, alert and operators withSQL Server Agent,SQL Profiler, Backup/Recovery databases.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Good experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
• Setting up SQL Server 2005, 2008 on MS VirtualPC, VMWare.
• Implemented Data collector, Change data Capture and Resource governor in SQL.
• Experience in creating maintenance plans, Jobs and Sending Alerts using SQL Mail.
• Experience in installing Service Packs for SQL Server and OS.
• Good Knowledge in preparing and updating cost cutting and disaster recovery documentation.
• Developed backup and recovery strategies for production environment.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Experience in data normalization and de-normalization.
• T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures etc.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Worked on partition table in SQL 2005/2008/2012.
• Designed documents for Capacity Planning and System Maintenance for Production.
• Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler.
• Worked on DMVs, System tables and Stored Procedures for performance tuning.
• Handling Database designing and Query optimization.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Creating stored procedures, functions, packages, triggers, according to business requirements.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Good experience in resolving blocking and dead lock Issues.
• Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
• Migrated DTS Packages to SSIS Packages and Deployed SSIS Packages to MSDB and File system from development to Production environment.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services, (SSRS).
• Excellent communication skills.
• Flexible, enthusiastic and project oriented team player with solid leadership skills to develop creative solution for challenging client needs.
• Experience working with 24x7 Production support for 2012, 2008, 2005 and 2000 SQL Server.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008, 2005, 2000, SQL*Plus, SQL*Loader.

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA: Administration of MS SQL Server 2005, 2008, 2000 databases

Operating System: Windows 2008/2005/2003/2000 Advanced Server, NT.

Tools: Perf Mon, Backup Utility, SQL Lite Speed, Visio, ERWIN, RML Utility, Pal.

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

SQL Server DBA / Developer

Responsibilities:

• Managed and Administrated theSQL Server 2012/2008 production and Non-production servers.
• Installation ofSQL Server 2008onWindows Server Clustered environment.
• Upgraded/Migrated SQL Server 2008/2005 databasestoSQL Server 2012 databasesand mentored Jr.DBAs and other technical staff.
• Performedbackup using backup compression and Data compression in SQL Server 2012, 2008 on clustered environment.
• Handled upto 2.5 TB Size databases with clustered environment.
• Application support for front end feeds and ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev servers.
• MonitoredLog shipping/ Transactional Replicationand trouble shooting of errors.
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeOracle, DB2 to SQL server.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• Involved in Database Modeling, Database Mapping, And Normalization Using ERWIN.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.

Confidential, Kansas City, MO

SQL Server DBA / Developer

Responsibilities:

• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Fine tune application logic for better performance.
• Responsible for SQL Performance tuning by using SQL tuning advisor, SQL Profiler.
• Identified and analyzed expensive T-SQL stored procedure by using the SQL Profiler (Tracing), SQL analyzer and Index tuning wizard. Optimized long running Stored Procedures & queries for effective data retrieval
• Handled multiple tasks and responsibilities independently as well as a proactive team member.
• Design, develop and schedule the various DTS package for data migration, BCP (bulk copy program) for import / export of data.
• Used Microsoft Dynamics CRM(customer relationship management) & Microsoft Dynamics GP servers for business accounting applications.
• Experience in SQL Server troubleshooting guidelines DNS /Authentication /Data /Common errors.
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL
• Experience in using partitioning in SQL Server 2005 by allowing tables and indexes to be partitioned across multiple file groups.
• Used SSIS (SQL Server integration services) 2008 for data extraction, transformation and loading (ETL).
• Performed regular reviews of database security and adjusted accordingly to ensure access and modification only to authorized users and/or applications.
• Involved in the design and implementation of Disaster Recovery or data recovery plan (DRP), involving database servers and application servers.
• Responsible for high availability methods like clustering, transaction log shipping, replication, database mirroring.
• Configured Active/Active and Active/passive SQL Server Clusters.
• Performed the peer to peer transactional log replication.
• Provided the data security by using encryption in SQL Server2005 like for protecting passwords used encryption by passphrase
• Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
• Monitored the event logs and server logs by troubleshooting.
• Involved in the migration of existing DB environment to a highly available Active Passive Clustering SAN DB environment.

Environment: SQL SERVER 2005, Microsoft Dynamics CRM 3.0, Microsoft Dynamics GP 9.0, Microsoft SQL Server Integration services SSIS, Windows Server 2003, DTS, SQL Profiler.

Confidential, Irving, TX

SQL Server DBA / Developer

Responsibilities:

• Installation of SQL Server 2005 with latest Service Packs.
• Migration of SQL Server 2000 to SQL Server 2005 using side by side strategy.
• Designed new databases architecture according to Business requirements like logical design and physical design.
• Handled Clustering between 3 Production Servers and performed daily backups and developed Recovery procedures.
• Implemented Log Shipping in SQL 2005/2000.
• Implemented Transactional and Snapshot Replication in SQL 2005.
• Implemented Disaster Recovery Strategies.
• Involved in creation of database snapshot.
• Created partition tables using partition functions and partition scheme.
• Providing 24x7 supports to SQL application developers in implementing the applications on Production server.
• Migrated stored procedures from SQL 2000 to SQL 2005 to refer Dynamic Management Views (DMV).
• Resolved locking and blocking issues.
• Created stored procedures, scripts, cursors for the Bulk application, tested them on the test servers and moved them to production.
• Daily monitoring of the database performance and network issues.
• Performance tuning and optimization of procedures and queries.
• Rebuilding indexes (online and offline) on various tables.
• Connecting SQL servers remotely using Terminal services.
• Worked with SQL Server Profiler to generate traces.
• Monitored databases and alerts from Fog-light application.
• Creating backup strategies and scheduling them for execution.
• Created crystal reports and scheduled them as daily and monthly reports.
• Creating logins, users and assigning them permissions on demand.
• Helped Development Team in deploying and testing the application.
• Upgrading DTS Packages to SQL Server Integration Services (SSIS).
• Scheduled SSIS Jobs and Maintenance Plans.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Create Packages and jobs to perform filtering operations and import the data on daily basis from the Oracle DB to SQL server.
• Created and Migrated DTS packages from SQL Server 2000/2005 to SQL Server 2005/2008 Integration Services (SSIS).
• Developed and Tested SSIS (SQL Server Integration Services) Packages for data extraction, transfer, and loading for different applications.
• Involved in moving SSIS packages between various environments including Development, Test, System Test, UAT (User Acceptance Testing) and Production.
• Set up jobs to schedule SSIS packages using SQL Agent.

Environment: MS SQL server 2000 and 2005, Windows 2000, Enterprise Manager, SSMS, DTS, SQL Profiler, SSIS, Crystal Enterprise, Foglight, Veritas backup solution.

Confidential, St Louis, MO

SQL Server Developer

Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel.
• Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdReport templates, bar graphs and pie charts based on the financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back end data validation testing.
• We handled lo t of production issues like data correction and resolves error handling
• Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into the databases.
• Configured the new servers using failover clustering and SAN technology.
• Migrated all the databases from old servers to new servers to test for a month.
• Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Writing and testing stored procedures.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server, .XML,Microsoft Visio 2003, SFTP, SQL Server Reporting services (SSRS), JAVA,J2EE.

Confidential

SQL Server Developer

Responsibilities:

• Converted logical Database Design into Physical schema using the balanced normalization in 2ndand 3rdNormal form for highest performance.
• WroteStored Proceduresto implement business logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Improve theperformanceof SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Transfer data from flat files, Excel spreadsheets to and from SQL Server usingDTS, BCP and Bulk Insert.
• Created and managed users, roles and groups and handled database security.
• Managed test data and their updates between development and production databases.
• Regularly monitor the system for bottlenecks(CPU,RAM, Disk IO)
• Use XMLdocuments to pass multiple parameters for Stored Procedures to read and write database table. Alsogenerate XML documents from tables.
• Handle development and production support, document reviews, test plans, integration of the system.
• Document all process and Data Flow involved in the database for future reference.

Environment: SQL Server 2000, T-SQL, Access, Excel, Crystal reports, Asp, Windows 2000 Advanced Server, Unix, Oracle and Windows NT.