SUMMARY

• 8 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2008 R 2/2008/2005/2000 comprising OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2008R2, 2008, 2005 and 2000, updating with latest service packs, hot fixes and security patches.
• Dexterity inimplementingdifferent types ofHigh Availability & Disaster Recovery scenarios like Replication models (Snapshot, transactional), Log Shipping,Database Mirroring and Clustering.
• Migration of SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008 as well as SQL server 2005 into SQL server2008.
• Experience in working with SQL Server 32 bit and 64 bit environments.
• Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevels
• Proficient in SQL Server 2008 new features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try - Catch blocks, Online Indexing, Online Restoring, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, Database Tuning Advisor, SQLCMD
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators withSQL Server Agent, handling Backup(warm, hot and cold backups)/Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
• Expert in using Native tools like SQL server profiler, database tuning advisor, perfmon.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Soundknowledge in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Indexed views, file group modifications, User Defined Functions (UDF), Triggers, Distributed Queries, Common Table Expressions and adding scheduled jobs to re-index and update statistics in databases.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Acquaintance in supporting Very Large databases(VLDB) 2TBand troubleshooting the problems in OLTP Environment
• Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach.
• Prowess in planning and implementingDatabase Securityby creating Logins, Users, Roles, and assigning permissions to them.
• Expertise in working with Active Directory for user account management.
• Experience in developing and tuningSQL Server Integration Services (Derivatives) packages, Analysis Services (SSAS) cubes and Reporting Services (SSRS) reports and models.
• Proficient in high level design ofETL, DTSPackagesandSSISPackagesfor integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multipletransformationsprovided bySSISsuch asAggregate,Data Conversion,Conditional Split,Bulk Insert Fuzzy Grouping, Fuzzy Lookup, OLEDB Command andMerge.
• LeveragingSSISto integrate data from source SQL Server databases to build thedatamart.
• Experience in CreatingReport Subscription,Data Driven Subscription, Report Snapshotsand caching, linked, cascadedandparameterized reports, complex drill down reportsusingSQL Server reporting services (SSRS). Configuring and maintainingReport ManagerandReport Server.
• Good understanding withSQLbasedreportingtoolslikeCrystal Reports.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• CreatedLinked ServersbetweenSQL Server & Oracle 9i and 10g. Also createdDTS packagefordata transfer between the two environments.
• Handled numerous Change Management requests on production servers
• Explicitly used Litespeed, Foglight, Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Supporting databases for CCM software like HP Exstream.
• Strong experience inmentoring team members and writing documentation.
• 24 X 7Production Database on Call Support.
• Knowledge in VB, VB.NET and C#
• Good experience in configuring and troubleshooting IIS and XML.
• Implemented VMware in cluster environments.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012, 2008 R 2/2005 / 2000 / 7.0 , MS-Access 2000/2003/2007 , Oracle 9i & 10g, My SQL4/5, Microsoft Active Directory Services.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: T-SQL, C, C++, C#, JAVA, VB.NET, ASP.NET, XML, Batch Scripting

Operating Systems: Windows 2008, Windows 2003, Windows 2000 server, 64bit & 32Bit

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLTP, OLAP

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS SourceSafe, Biztalk Server 2006,Source Control, MS Visio, Windows System Monitor, SQL COMPARE, lite speed, ArcGIS Enterprise 9.0.

PROFESSIONAL EXPERIENCE

Confidential, New Kensington, PA

Sr SQL Server DBA

Responsibilities:

• Installed configured and managed SQL server 2005, 2008 R2 and 2012.
• Migrated Databases, from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008 R2.
• Worked as an APO ( Confidential Self-Assessment Process Owner) in high level auditing team to manage, maintain and design process for making the server environment safe and compliant.
• Designed different Tests and Tasks to check if the processes followed were compliant with company policies.
• Worked along with security team to analyze server configuration and database Turnover process.
• Helped security team to design rules for Squirrel Scans.
• Performed monthly compliance Tests and Tasks and guided other team members.
• Involved in weekly compliance meetings and discussed with other team leads and managers about how new processes effect the environment in performance and compliance perspective.
• Designed various queries and stored procedures to compare user related information with AD.
• Fixed various collection jobs which were failing for the past 2 years.
• Worked with patching team in updating the patches on over 100 servers.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Provided 24 X 7 dedicated supports for the claims records database.
• Provided 24 X 7 supports for Production environment.
• Planned and modified the permission issues in the production servers.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.
• Created the backup and restore strategy for production environment.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Installed and configured active/passive clustered environment.
• Rebuilding indexes on various tables.
• Resolving locking and blocking issues.
• Implemented log shipping in standby mode to support DR servers.
• Documented and tested Merge replication in test environment for generating reports.
• 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 on daily basis in email format.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
• Assisted other teams in stress-testing applications, locating bottlenecks, and recommending possible solutions.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Worked with management to develop database strategies to support company needs.
• Responsible for creating and maintaining technical documentation for the database environment to follow Confidential rules.

Environment: SQL Server 2012/2008/2008 R2/2005/2000, Windows 2003, Windows 2000, Windows NT, SQL backup5, SQL secure, ETL, SSIS, SSRS, ASP.NET, MS Excel and MS Access, Oracle, SharePoint 2007, UNIX, SSAS, System Monitor / Performance Monitor, Microsoft Active Directory Services.

Confidential, Princeton, NJ

Sr SQL Server DBA

Responsibilities:

• Installed and configured SQL server 2005 and administered 10 servers with minimal downtime
• Functional breakdown includes 70% DBA and 30% Development.
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2005.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Administered the SQL server 2000/2005 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Experienced working on Redgate SQL COMPARE tool to compare the structures between databases in order to synch them
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003 servers.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Responsible for developing, monitoring and deploying SSIS packages.
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed
• Used Lookups Transformation to get the data from reference data sets.
• Installed SQL server 2008 for SharePoint backend database.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Created permanent tables, temporary tables and table variables.
• Conducted design reviews with users/team for development and production strategies.
• Translating business requirements into technical design specifications and actively supported business users for change requests.
• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
• Good experience in handling onsite-offshore model.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2005/2000, Windows 2000, Windows NT, lit speed, SQL backup5, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET, MS Excel and MS Access, Oracle, SharePoint 2007, UNIX, SSAS, System Monitor / Performance Monitor.

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
• Interacted with Developers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and trouble shooting.
• Involved in installing SQL Server 2005/2008 R2 on Development, Production and WTC (Testing) machines.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Supported SQL server 2005 databases for CRM.
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
• Used Active directory to create and manage user accounts.
• Involved in troubleshooting all the performance issues for different database applications.
• Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Knowledge in Setting up of SharePoint Database in SQL Server 2008.
• Documented all the steps and procedures for future references.
• Interacted with concern application team in fixing the problems when ever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduled jobs on production and staging environment.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues with the help of Redgate SQL Monitor tool.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries.
• Provided 24 x 7 Production support for the database and application issues.

Environment: SQL Server 2005/2000, Windows 2000, Windows NT, lit speed, SQL backup5, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET, MS Excel and MS Access, Oracle, SharePoint 2007, UNIX, SSAS, System Monitor / Performance Monitor, Microsoft Active Directory Services.

Confidential, San Diego, CA

Sr SQL Server DBA/Developer

Responsibilities:

• Installed SQL Server 2005 with SP2 in production and development environments.
• Successfully upgraded from SQL Server 2000 to SQL Server 2005 on Development and Testing Environments.
• Involved in system requirements and the upgrade matrix for SQL Server 2005.
• Worked in 2- node Active/Passive Clustered Environment.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
• Installed SCOM 2007 R2 on SQL Server 2008 R2, configured alerts for SQL Services, log files etc
• Worked in 24x7 production environment.
• Integrated SQL Server 2005 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to a Share Point portal.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler, Perfmon and using a monitoring tool called DBArtisan.
• Used BizTalk server to connect to SQL server databases.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented database Backup & Maintenance Plans.
• Acted as a liaison between the offshore team and onshore team.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Daily production server check list Include
• Verifying SQL backups, Disk space, Job failures, system checks, checking performance statistics for all servers using monitoring tool and research and resolve any issues
• Checking connectivity i.e. log into customer application\billing application to ensure it can connect to databases
• Checking replication on each server by checking each publication to make sure the distributor is running for each subscription and also maintaining log book to record the issues and their resolutions.

Environment: MS Windows 2003/2008 Enterprise Server, MS SQL Server 2000/2005/2008 R2, Visual Studio 2005,IIS 6.0, HP ProLiant DL380 G4 with 12 GB RAM, Dell PowerEdge Servers, ERWIN, DBArtisan, SharePoint, SCOM 2007 R2, BizTalk Server 2006

Confidential

MS SQL Server DBA/Developer

Responsibilities:

• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing
• Involved in creating tables, views, indexes, cursors and stored procedures
• Involved in creating data models and designing logical and physical models of database
• Upgraded SQL server 2000 to SQL Server 2005 on standalone and clustered environments and applied service pack
• Involved in designing the system models using UML and ER Diagram
• Performance tuning, and optimization of procedures and queries
• Worked with SQL server Profiler
• Worked with developers to do the database schema changes and database restore requests
• Creating, maintaining the users, roles and granting privileges
• Worked closely with the developers’ team and the end users while the system is being under development phase
• Gave training sessions to the end users for the new product such as using the product
• Involved in writing queries and optimizing the performance of the queries

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition