SUMMARY

• Over 8 years of IT experience on Database Administration and development with MS SQL Server technology.
• Hands on experience in Installation and Configuration of SQL Server 2000/2005/2008/2012/2014 technology, service packs and hot fixes.
• Expert in using different recovery models simple, full and bulk - logged depending on availability of database.
• SQL Server Virtualization & Consolidation from physical machines to VMware.
• Expert in handling Very Large Databases (VLDB) 3TB in size.
• Extensive experience in high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring and HADR and Always ON Availability Groups with SQL Server 2012.
• Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Expertize in performance tuning, with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Implemented different Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Maintained 1500 database with zero downtime and optimal performance.
• Extensive experience in automating the system by using Notification service and creating alerts, jobs and maintenance plans.
• Collaborated on numerous management initiatives, including Data Security, Data Management & Data Retention & Resource Tracking, Change Control, and Disaster Recovery Planning, High Availability.
• Implemented best Temp DB architecture and Design for Indexes and Transactional Log Architecture to meet the ACID properties for optimal performance and minimize data loss.
• Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases, file groups, files, transaction logs.
• Hand full of experience in using third party tools like Idera, Spotlight, Sql tuner, Sqlexpert, foglight, sqlsentry.
• Expert in constructing triggers, stored procedures, user functions, views, indexes, user profiles, data dictionaries, and data integrity using T- SQL.
• Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing.
• Expertise in Data Modeling tools such as ERwin, MS Visio, and ER/ Studio Design Tool.
• Expert in logical and physical modeling for OLTP and OLAP applications.
• Ample of experience in data warehousing using star schema and snow flex schema.
• Experienced in leading a team of any size.
• Excellent verbal and write communication skills.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Plenty of Knowledge on different system and tools like oracle, DB2.
• Brain Bench certified Database Administrator.
• Able to work independently and collaborate proactively & cross functionally within a team.
• ExcellentCommunication,AnalyticalskillsandInterpersonalskills. Exceptional ability to learn new concepts. Skilled at accessing client needs, working in a group, suggesting ideas that enhance Efficiency and Maximize Performance, Implementing Cutting-edge Technology Solutions and /Supporting endusers.

TECHNICAL SKILLS

Languages: Java, C#, ASP.NET, VB.NET,JSP, JDBC, JDOM, XML, VB,C,C++, Java Script-SQL, PL/SQL.

Databases: MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, Sybase, MS Access.

ETL tools: DTS, SSIS, Informatica, SSAS, SSRS.

Operating System: Windows 2000, 2003, XP, Vista.

Software Tools: Visual Studio 2005, Visual Source safe, Microsoft Visio, MS Excel, Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director, Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS sharepoint designer.

Other Tools: SQL*Plus, SQL*Loader, TOAD, SQL Navigator, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville FL

Sr. MS SQL SERVER DBA/DEVELOPER

Responsibilities:

• Data Centre Migration project for production support and migration of various version and editions of SQL server.
• Installing and configuring of MS SQL Server 2005, 2008, 2008 R2, 2012, 2014.
• Expertise in SAN Migration from NetApp to EMC along with SQL Server Migration and upgrade from SQL Server R2, SQL server 2008R2 to SQL Server 2012, SQL server 2012 to SQL server 2014 .
• Consolidation of SQL Server 2014/2012, and SQL server 2008R2 to save the cost of licenses and made easy to manage for DBA team.
• Migrated SQL server 2008 to SQL Server 2012 inMicrosoft WindowsServer 2012 Enterprise Edition and windows 2008R2 SP2 enterprise editions.
• Used NetApp Snap Manager to take the Backups.
• Worked on SAN Snapshots for Virtual SQL Servers.
• Installed and administered clustered Active/Passive on Microsoft Windows Server 2008R2 Enterprise Edition on SAN environment (NetApp and EMC Storage).
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Conducted Code Review and worked with developers to make necessary modification for the codes before deploying into Production.
• Implemented Database Partitioning for Large Databases of size of each 800GB, created alerts and developed SSRS reports for Monitoring and dailiy morning check for DBA’s.
• Checking and correcting the faulty sql server configuration in environment.
• Installed, upgraded and configured SQL Server 2012, 2014 server.
• Worked on incidents and notification mails from footprints tool based on Priority of issue.
• Occasionally supported as SharePoint admin.
• Attended RCA calls with application owners on global issues to explain the root cause and fix.
• Created various maintenance jobs in all the sql servers, when to Run Re-Organize Indexes job and when to run Re-Build Indexes job and on what databases. And Update statistics jobs on a weekly basis.
• Configured and altered alert configuration settings for the jobs and issues.
• Implemented Backup and restore the databases from production to Dev environment is automated.
• Performed hands on large applications on efficient OLTP which are dependent on sophisticated transaction management infrastructure and databaseoptimization tactics to facilitate the processing of large numbers of concurrent updates to an OLTP-oriented database to retrieve the customers details from the existing network.
• Ensured security logins and database access permissions
• Created and scheduling maintenance jobs in new environment.
• Provided support to numerous applications tuning stored procedures and modify them if necessary.
• Provided 7x24 technical supports to the production databases mission critical

Environment: MS SQL Server 2000,2005,2008R2,2012,2014 SQL Agent, SQL Profiler, Redgate pro 7,Database Tuning Advisor, Database Mail SQL, Windows2003, 2008 server, Footprints Incident management tool, SharePoint 2010,Vmware.

Confidential, Dallas, TX

Senior SQL SERVER DEVELOPER/DBA

Responsibilities:

• Production support for SQL server environment.
• Responsible for MS SQL 2012, SQL2008 R2, 2005 Installation, Configuration and Tuning.
• Installing and configuring of SQL Server 2008 and 2008R2.
• Configured and maintaineddatabase mirroringfor high availability.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked onDynamic Management Views (DMV’s).
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Developed, deployed and monitored SSIS Packagestool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgradingDTS to SSIS.
• Data center Migration where migrated SQL Server 2000toSQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
• Involved in designing and deploying cubes in SSAS using Star Schema.
• Patched server with latestSQL Server service packsandCumulative updates.
• Managed MicrosoftActive\ActiveandActive\PassiveClustered SQL Server 2000, 2005 and 2008/R2 environments.
• Data retrievaldone using XMLdata types
• PerformedDBCCutilities and fixed data corruption in User databases.
• Worked on monitoring andtuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such astables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Migrated Data from Access, Oracle and Sybase databases to and from SQL Server
• Setup, implement, and maintain industry standards in database management
• Performed Server&Application fine-tuning&troubleshooting.
• Monitored MS SQL Serverperformance and network issues.
• Monitored Databases forlock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
• Scheduled thebackups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Worked on OLTP network to gather and process input information of financiers and update the existing information to make it like a client server system.
• Controlled user access rights, and managed data security.
• Developed reports, sub reports, wrote complex queries for reports, used TFS for versioning of stored procedures, reports, configured data sources in SharePoint, native mode SSRS, troubleshoot issues in reports.
• Involved introuble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, WizardsandSQL Profiler.
• Documented application userguide for endusers.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2000/2005/2008/2008 R2, Windows 2000/2003/2008 R2, VERITAS Net Backup, TSQL, SharePoint, TSM, Redgate, EG Monitoring.

Confidential, OH

MS SQL Server DBA

Responsibilities:

• Install and configure SQL Server 2005 and 2008 instances in both production and development environments on standalone and clustered environments (Active/Active and Active/Passive).
• Configured SSAS SQL Server 2008R2 and maintained, monitored and scheduled Cubes processing, involved in manual processing upon requests and debugging the failures for the cube jobs.
• Apply regular security fixes and service packs in a timely manner.
• Upgraded/migrated most of the sqlserver 2000/ 2005 instances to sqlserver 2008
• Deployed database changes accordance with change management policies and procedures.
• Created Stored procedures and SSIS packages import the data from access, oracle databases to SQL Server
• Data center migration performed wherein Data from Access, Oracle and Sybase databases to and from SQL Server
• Used linked server’s on SQL Servers to import tables from other SQL Servers & oracle databases
• Worked on REDGATE to compare databases across the environments and compare the data and synchronize all database objects.
• Designed a Database and a Data Warehouse for the system using Star Schema.
• Created automated scripts, SQL Jobs, Operators, Alerts and Mail Profile to monitor/generate report on the database health
• Created the database maintenance plans for monitoring, optimization and integrity check.
• Involved installation of SQL Server Analysis Services(SSAS) 2005/2008 by Using Setup.
• Monitor daily backup of databases on production servers.
• Monitor and schedule existing/ new jobs on production server.
• Implemented the Partitioned Tables and Indexes in SQL Server 2005/2008
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Changed Sysadmin passwords automatically and periodically using password vault.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005 on Windows 2003
• Data migration from other data storage like Oracle and DB2 using SSIS.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL queries
• Involved in monitoring performance and managing parameters to provide fast query responses
• Create Views to access the tables and assign specific permission to the users
• Monitored and managed database growth and capacity and tuned database performance using Performance Monitor, SQL profiler and quest spotlight.
• Setup, implement, and maintain industry standards in database management
• Assisted application analysts with report writing functions using SSRS as requested
• Assisted application analyst in converting all applicable Microsoft Access databases to SQLSERVER
• Configured and worked on SSRS in SharePoint integration and native mode
• Coordinated with software vendors and performs all database upgrades
• Implemented HIPAA security measures to monitor data security and activity.
• Assisted application analysts to Facilitate inter-database access and report writing using SSIS and linked servers
• Documented application userguide for endusers.
• Stored large documents in tables as XMLtypes
• Deployed and scheduled SSIS package
• Create detailed documentation of all database administration policies and procedures and detailed troubleshooting documentation

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008,DB2, T-SQL, DTS, Windows 2003 Server, SSIS, SQL profiler, SSRS, TABLEAU, SharePoint, Redgate, Questlite Speed, VBScript, Veritas Netbackup, DBartisian, Quest spotlite, Password Safe, Terminal Services, IP Monitor, SQL Trace, BCP, DTS Import/Export, Visual Source Safe 2008,Profiler, Query Analyzer

Confidential, Cincinnati OH

SQL Server DBA/Developer

Responsibilities:

• Create and maintain various databases for Development and Testing Environment using SQL Server 2005/2008 and involve in actual Relational Database Design for high OLTP environment
• Installed and configured SQL Server 2008 and performed data migration from SQL Server 2005 to SQL Server 2008 through attach/detach and backup/restore method.
• Worked with Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server
• Responsible for maintaining security by creating Logins and Users and assigning proper permissionsto various groups in both SQL server and Sybase.
• Installed and configured SQL Server 2008R2 SSIS and SSRS and SSAS.
• Created a database model by using Erwin 4.0 and also designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity
• Implementation of Microsoft Office SharePoint Server 2007 Beta for corporate intranet, document management, collaboration.
• Created scripts for tables, stored procedures, and DTS and SSIS, (SQL 2K5) tasks
• Physical Implementation and application of Schema changes to SQL Server database using Power Designer View
• Worked on OLTP systems for rolling back transaction to retrieve the update information into database which is clustered built to rectify the duplication of information.
• Designed and built the dimensions, cubes with star schema using SQL SERVER ANALYSIS SERVICES (SSAS).
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language
• Sending and Receiving the dataand Images using XMLtechnology
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Good experience on working with Extract, Transform and Load (ETL) tool
• Exposed to data conversion from different data sources to SQL server 2008 using SSIS
• Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS
• Worked on reliable data sources EMR’s from the Payer side to understand the code conduct on the claim received.
• Hands on HIT/EMR experience forms additional design of the SQL Server analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Retrieved information from other databases like Oracle into SQL atmosphere through which HIT/EMR platforms form major centric to form scripts.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports
• Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions

Environment: SQL Server 2008, SSIS, SSRS, Windows Server 2003, Visual Source Safe 6.0, SharePoint, C#, Visual Basic.

Confidential, Malvern, PA

SQL Server DBA

Responsibilities:

• Install, configure SQL Server 2008 and SQL Server 2005 versions.
• Configure relevant SQL Server components including database backup, consistency, integrity and network utilities to ensure health and access of each database.
• Resolving the day to day maintenance tasks.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS)
• Applied service packs on SQL Server 2000 and SQL Server 2005.
• Data center migration activity to involve support 24*7 for production support servers and migration of SQL 2005 to SQL 2008/2008R2.
• Worked extensively with SSIS SQL Server 2005 to automate DBA tasks.
• Migrated DTS packages and jobs from SQL Server 2000 to SQL Server 2005.
• Worked extensively with backup and restore requests.
• Worked with application development staff to enforce SQL Server database architectures coding standards and quality assurance requirements in accordance with Cephalon change control and testing procedures and policies.
• Respond and resolve database access and performance issues to meet business SLA's.
• Monitor database system details with in the database including the stored procedures and execution times and implement efficiency improvements .Also must be able to perform database transaction and security audit.
• Support redundant systems for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Wrote SQL Procedures to retrieve data in XMLformat
• Performance tuning of SSIS packages
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Created a mirrored database on the report server using database mirroring.
• Proactively monitor, optimize and allocate physical data storage for SQL Server database systems to ensure minimum down time.

Environment: SQL Server 2008/ 2005/2000 , T-SQL, SQL Server Integration Services, Window server 2008, Windows Server 2003

Confidential, NY

SQL Server DBA

Responsibilities:

• Interacted with users to gather business requirements
• Modified existing database by adding tables and relationships
• Configured database backup schedules to help in disaster recovery
• Created views as per the requirement of front-end developer for easier implementation on ASP.NET pages
• Worked with BCP and DTS to load text files to SQL Server.
• Maintaining the data, database backups and restoration, backup strategies, scheduling backups
• Created stored procedures and functions to support complex wealth management logic
• Ensured the performance of queries by removing unnecessary columns, normalizing tables, established joins and created indexes wherever necessary
• Created stored procedures and functions to support complex wealth management logic

Environment: SQL Server 2000, Windows server 2003, Windows 2000/XP, MS Visual Studio

Confidential

SQL Server DBA

Responsibilities:

• Actively participated in gathering User Requirements and System Specifications.
• Filtered unnecessary data using complex T-SQL statements, implemented various Constraints and Triggers for data consistency.
• Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.
• Created Reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee’s requirements and generating records between front end and back end.
• Created various reports using Crystal Reports after performing Data Analysis on the various Views of Business Intelligence.

Environment: SQL Server 2000, Windows NT 4 Platform, EXCEL, Erwin 3.x, Crystal Reports 9.