PROFESSIONAL SNAPSHOT:

• Over 7+ years of experience in SQL Server database design and implementation, database administration, database development, database programming and production server support related to HealthCare, Banking, and Financial domains using versions 2005, 2008, 2012 and 2014.
• Over 7+ years of experience in Administration, Database Design, Server Virtualization, Performance Analysis and Production Support for Large (VLDB) and Complex Databases of terabyte size.
• Experienced in installing and configuring SQL Server 2005/2008/2012/2014 & applying their respective hot fixes and service packs on 32 bit and 64 bit clustered and standalone server environments.
• Administration, maintenance and implementation of policies and procedures for ensuring security, integrity of the complex databases and compliance with audits.
• Managed upgrade and migration of SQL Server 2000/2005 databases to SQL Server 2005/2008 respectively on clustered and non clustered environments.
• Experience in establishing and implementing high availability solutions such as Database Mirroring, Replication, Log shipping and Failover Clustering in SQL Server 2000, 2005 and 2008 versions
• Hands on experience on Instance and Server Consolidation for MS SQL Server 2000/ 2005/2008/2012/2014
• Involved in optimizing, tuning and debugging code for improving batch efficiency with databases including re - indexing, updating statistics, recompiling stored procedures and functions
• Hands on experience with faster data availability solutions like Online Restore, Online Index Operations, and Database Snapshot restore to ensure minimal downtime
• Hands on knowledge, experience about SQL Server Profiler, windows performance monitor, activity monitor, SQL Server features like DMVs, DMFs and performance dashboard to determine and resolve performance bottle necks, I/O issues and issues with long running queries
• Expertise in Performance Tuning and Query optimization using native and third party tools such as Idera’s SQL diagnostic Manager
• Migrating an existing on-premises application to AWS and Azure
• Used SQL Server 2008 Concepts like Resource Governor, performance data collector, filtered indexes, Backup Compression, Data Compression & Lock Escalation
• Expertise in T-SQL for implementing business logic by writing complex stored procedures, triggers, cursors, indexes, functions and designing Tables, databases on file groups
• Analyzing and developing Conceptual, Logical and Physical database models using CA’s Erwin data modeler tool and Microsoft Visio
• Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
• Skilled in major UX design tools including Visio, OmniGraffle
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Leading the project from initiation to completion with testing coordination and implementation of Guardium monitoring solution for 58 distributed applications.
• SQL Server Business Intelligence Development Studio knowledge to create SSIS packages, SSRS reports and SSAS cubes for OLTP and Data Warehouse environments.
• Experienced with ETL processing using SSIS packages and its components such as script tasks, control flow tasks, look up transformations, data flow tasks and event handling.
• Created necessary templates for various requirements gathering anddocumentation.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.

TECHNICAL SKILLS:

Databases: SQL Server 2005/2008/2012/2014 , Oracle, MS Access

Tools: /Utilities: Enterprise Manager, Management studio, Profiler, Query Analyzer, Export & Import, DTS, SSIS-Integration Services, Replication, SSRS-Reporting Services, ETL, and SSAS. .Net Frame Work Solarwinds ignite, Idera SQL Safe, Quest Litespeed, backup Pro, Compliance Manager, Idera Diagnostic Manager, ERP, MS Office 2007/2010

Reporting: Crystal Reports, Microsoft SQL Server Reporting Services

ETL Tools: MS Data Transformation services, SQL Server Integration Services

Programming Skills: T-SQL,C, HTML

Modeling Tool: Erwin 4.1, MS Visio.

Operating Systems: Win 98/ 2000/ 2003/ 2008 R2/2012

Scheduling Tool: Windows scheduler, SQL Server Agent

Front End Tools: MS FrontPage … MS Office … MS Project 2000, MS Outlook 97/2000

Microsoft products: MS Office Suite- Word, Access, Excel, Word and Power Point, and MS-Access …

WORK EXPERIENCE;

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Provide SQL Server database Administration and monitoring support across production, development and staging environments
• Design databases and apply normalization to minimize data redundancy
• Support and co-ordinate merging DBA support across company’s legacy systems.
• Manage SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access
• Deploying, managing, and operating scalable, highly available, and fault tolerant systems on AWS and Azure
• Migrating an existing on-premises application to AWS and Azure
• Implementing and controlling the flow of data to and from AWS and Azure
• Install and configure SQL server 2012. Analyze results of upgrade advisor and perform database upgrades from 2005 to 2008/2012.
• Perform cleansing of data loaded from legacy systems using data conversion scripts and produce clean formatted data which can be loaded into production system.
• Setup monitoring jobs for monitoring Security changes, Administrative activities, Login failures, and DDL changes. Weekly, quarterly and daily reports are in place for review
• Automation of frequent refresh requests are taken care of by creating SQL jobs that copy the backup from production, backup roles and users from development database, perform refresh and reapply the roles and users on to development.
• Experience in handling sensitive or confidential data (HIPPA).
• Manage disk space on SQL servers by shrinking data and log files. Determine and forecast the growth of the databases and increase disk space as required
• Check alerts from SQL Log and work with Server team to fix any I/O or operating system issues. Help troubleshoot error and perform Root Cause Analysis
• Work towards achieving 100% results with Service Level Agreements by handling requests as per severity and getting back to the users well before SLA with resolution
• Ensure daily and weekly Database maintenance jobs succeed. Also take care of other application related jobs that are critical for the application
• Help application team identify the blocking process by collecting information on block processes after the fact using scripts querying DMVs
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Identify errors in the HL7 messages during each phase of the QA process
• Reviewed HL7 version 2.5.1 immunization messages (VXU, VXQ and QBP, and response messages) during each phase of the QA process
• Deploy SSIS packages on to production server and configure configuration files
• Ensure standard backup policies are implemented across all servers depending upon the application criticality. Make sure we have backup cleanup tasks are in place
• Plan, test and apply SQL patches on SQL servers to make sure we are up to date
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Created necessary templates for various requirements gathering anddocumentation.
• Understand changes required and attend Change Control Board meetings to explain the changes to happen on the DB and justify the changes required
• Gather service account information and document the same for all locations
• Maintain DBA Share point site with updated reports and scripts used by DBA team

Environment: Windows 2000, Windows 2003, Windows 2008, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, Redgate SQL backup Pro, Idera Diagnostic Manager, ITSM ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint

Confidential, Lewiston, ME

Database Administrator

Responsibilities:

• Provide Production, Staging and Integration SQL Server database Administration support with databases as large as 700 GB
• Extract data from external systems, transform data and load them into the existing databases using SSIS packages
• Implement backup plans, monitor and maintain Backup and Recovery on servers
• Perform daily, weekly and monthly Database Maintenance tasks
• Database design and optimization of databases for better performance
• Migration of databases from SQL 2000/2005 to SQL 2008 after careful analysis of Upgrade Advisor reports. Share results with application team for code change review
• Creation of Virtual databases using Idera’s Virtual Database tool to reduce space usage and to manage multiple copies of Production databases
• Managing SQL Server security by creating roles and security groups
• Monitor and resolve blocking issues in coordination with application team
• Configuring Linked Servers as per user request and trouble issues with RPC
• Proactively check the SQL Error log and take appropriate action to avoid downtime
• Import/Export data as per user request using import export wizard and BCP
• Apply data fixes and code change on to production after analysis
• Deploying/Migrating DTS and SSIS packages. Help troubleshoot issues with packages
• Revoked public access to DB objects from all production servers to ensure security
• Perform database refresh and fix orphaned users on the refreshed database
• Iteratively developed use cases, information flowcharts and UI prototypes
• Delivered flowcharts, functional templates, and UI prototypes using MS Visio
• Delivered Use Case, Process Flow documentation.
• Setup and manage Transactional Replication databases and make sure the latency is current. Mainly the Subscriber was used as reporting database which reduces burden on the production server.
• Created necessary templates for various requirements gathering anddocumentation.
• Make changes to the replication articles as per requirement without issues
• Support Disaster recovery project planning, testing and implementation
• Coordinate with external vendors and make changes to improve performance of the application. Implement Microsoft’s recommendations to improve server performance
• Review and suggest improvements to Application patch release procedures as we have replicated servers involved and precautionary measures are taken to avoid break in replication. The patch steps are reviewed in the presence of all teams involved
• Capacity planning by using DB growth forecasting option in Idera Diagnostic Manager and help resolve space issue across all servers across all environments
• Participate in weekly Change Board meetings and explain the DB changes proposed

Environment: Windows 2000/2003, Windows 2008, SQL Server 2000, SQL Server 2005, SQL Server 2008, Idera SQL Safe, Quest Litespeed, Idera Virtual Database, Idera Diagnostic Manager, HEAT ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint, MS Visio

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Maintain SQL Server Production databases and ensure high availability
• Analyze slow running queries across environments and find the root cause for the same and resolve by introducing missing indexes, partitioning tables and placing them in different file groups on different drives to improve performance
• Attend requirement gathering meetings along with application team and understand the requirement or change to be incorporated in the existing
• Database objects design and normalization, review and implementation
• Support change projects where database objects are designed, reviewed and created as per change requirement and ER Diagrams produced using Erwin tool
• Interact with the client, understand and gather requirement, identify the DB objects to be modified and new objects to be created
• Manage space on database servers by proactively forecasting the DB growth
• Back databases before change implementation and ensure rollback capability
• Perform ETL operations with the help of SSIS packages for the initial setup of DBs
• Restore development and staging databases to help development team work on the current version of the database to avoid errors during production move up
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Create roles and grant permissions to users upon proper approval from business
• Ensure the change process is followed religiously and suggest changes required
• Document the changes made to the database objects and update ER diagrams
• Attend weekly change control meetings and participate in discussions

Environment: Windows 2000, Windows 2003, Windows 2008, SQL Server 2000, SQL Server 2005, SQL Server 2008, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint, Webstar ticketing tool

Confidential

Database Administrator

Responsibilities:

• Responsible for installation and configuration of SQL server 2005 database on Dell Servers.
• Implementing Sql Clustering
• Implementing the Archiving of document database of around 1.8 TB based on the app point of view.
• Used Microsoft DPM for backup and disaster recovery.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Provided 7 x 24 Production support for the database and application issues.
• Implementing Log shipping.
• Installing and configured the SSRS
• Estimating of Table sizes and Record sizes.
• Solved critical production problems
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Updating with latest service packs and security patches
• Developed Database Backup Scripts and automated this process

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Windows 2003 Server, .NET 2.0 and C#, Msbuild, VS 2008