SUMMARY

• Microsoft Certified SQL Server DBA with good experience in MS SQL SERVER 2012, 2008R 2/2008/2005/2000 Database Administration in Production, Test and Development environment.
• 8+ years of experience in Database Administration and Development for very large and complex databases related to Financial, Medical and Insurance etc.., in SQL Server 2012/2008 R 2/2008/2005/2000 .
• Good Knowledge about the newly added features like Always ON High Availability and contained databases in MSSQL 2012.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server, internet\internet environments.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2008R2\2008\2005\2000.
• Expert in RDBMS S/W installation, database server builds, applying patches, Applying patches in VM environments (VTM), upgrading, configuring, trouble shooting of SQL SERVER on Windows 98/2000/03/08 servers and Clustered VMware Environments.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Expertise in automating the system by using System Center Operations Manager (SCOM).
• Experience in configuring Replication and troubleshooting the issues with transactional replication and Merge Replication.
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Replication, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and also to Oracle Databases.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Expert in raising the Service Requests and keep tracking of requests.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code and improving Efficiency.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Good Team player, Strong Communication skills and interpersonal with Self-motivation.
• 24/7 on call production support.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Worked Extensively on ETL process using SSIS packages.
• Hands on experience in installing, configuring, managing and troubleshooting SQL Server.
• Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.

TECHNICAL SKILLS

Relational Databases: SQL Server 2014/2012/2008/2008 R2/2005, MS-Access 2000/2003/2007, My SQL4/5, Oracle 9i/10g

Operating Systems: Windows NT/ Windows 2000 Advanced Server / Enterprise Server 2003 / Windows XP / Standard, Windows 98, Windows Vista, Windows 7, and Windows 8.

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

Languages: C#, XML, SQL, T-SQL

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0/7.0, Apache, Tomcat, Amazon web services (AWS), Service Center, Virtual Private Cloud (VPC).

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

ETL: SSIS, SSRS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor.

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C

Sr SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2014/2012 Enterprise and standard edition in the production/ Development and test environment and applied latest service packs and security fix servers.
• Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
• Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
• Implemented High Availability in SQL 2012 by configuring Always On Availability groups across Windows Server Failover Clusters using Failover Cluster Instances
• Understanding and converting business requirements into functional requirements doc, review and sign off with the customer.
• Perform Impact analysis and provide optimal solutions to the Client, Business users.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Developed and OptimizedStored Procedures, Views and User-Defined Functionsfor the Application.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Used DMV's to diagnose problems and monitor health of server instance.
• Rebuilding indexes with different fill factors and update statistics manually.
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Installing/administratingSQL Server Reporting Services (SSRS), creating schedule reports and delivering via email.
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
• Used Quest Foglight and Quest Spotlight tools to monitor SQL Server Performance and to generate Performance reports.
• Configured Transactional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors) and troubleshoot replication issues.
• Used SQL server Profiler to identify and analyze deadlocks.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Created packages using SSIS to migrate data from different data sources to data warehouse.
• Perform Impact analysis and provide optimal solutions to the Client, Business users.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Serverand Flat files.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Migrated database from SQL Server 2008 R2 to SQL Server 2012.
• Worked extensively in performance tuning of databases including query tuning, server tuning.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Assisted data migration from ODBC compliant sources (Oracle)/legacy systems to SQL Server through DTS packages and bcp utility.
• Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developing performance tuning and enhancement approaches to improve overall system performance and provide value add to the customer.
• Onboarding of new KPI cube Measures and Scorecards.
• Enhance dynamic Scorecard layout on the SharePoint server.

Environment: MS SQL Server 2012/2008 R2/2008, SSIS, SSRS, Replication, OLAP, OLTP, Alloy and TSRM Ticketing System, SQL Lite speed console, SQL sentry Spotlight.

Confidential, Indianapolis, IN

Sr. SQL Server Database Administrator

Responsibilities:

• Installed and configured SQL Server 2012/2008 R2 Database instance in a Clustered environment.
• Involved in implementing 2012/2008R2 active-passive clustering on Windows 2008R2 Operating system with consolidated environment of multiple SQL server instances in SQL 2012 and 2008.
• Responsible for Auditing/reviewing a SQL Server 2008 R2 installation by one of the agencies and produce documentation. Also responsible for migration to 64 bit SQL.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Handled up to 2 TB Size databases with clustered environment.
• Created Maintenance plans for SQL Server 2012/2008 R2 instances for index and Statistics maintenance. Rebuilding or reorganizing an index is based on the fragmentation percentage which is determined using DMVs.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• Implemented Transactional Replication and Performed Log Shipping as Disaster Recovery Solutions.
• Migrated databases from SQL Server 2008 to SQL Server 2012 using copy database wizards and resolved many issues in the process.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Extensively usedSSIS Import/ExportWizard, for performing theETLoperations.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Used Lite Speed for creating compressed backups on scheduled basis and responsible for restoring to any DEV/TEST Environment using Lite Speed Manager.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services (SSRS) and deploying them on Report Server using Report Manager.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Trouble shooting various SQL server 2012/2008 Database connectivity issues from the web applications.
• Used DMA (Database Middleware Automation) for installing SQL instances.
• Extensively worked on decommissioning the legacy databases from SQL 2008/2005.
• Responsible for maintenance and support for a two node Active-Active clustered SQL Environment.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: Microsoft SQL Server 2012/2008R2, Enterprise Edition, Microsoft Windows 2008 R2/2003 Server, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services, DB2, Access, Microsoft OFFICE 2010

Confidential, Owings Mills, MD

Sr SQL Server Database Administrator

Responsibilities:

• Ensure backups and redundancy is maintained to assure failover mechanisms
• Proactively monitor the database systems to ensure secure services with minimum downtime
• Troubleshoot and problem solving of SQL related issues, including advising on customer issues
• Set up SQL server cluster andAlwaysONtechnologies
• Data Migration (transformations) from DB2 & Oracle to SQL Server 2012/2008 using SSIS, BCP and Import/export tools
• Developing queries and various database objects like stored procedures, functions and triggers using TOAD and SSMS
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder
• Monitored Log shipping/Transactional Replication and trouble shooting of errors.
• Improve and maintain databases to include rollout and upgrades
• Implement and release database changes according to agreed time scales and costs
• Monitoring SQL instances and correcting issues that arise
• Work with application development staff to abide by database architectures, coding standards, and quality assurance policies and procedures
• Work with Application Development Manager to create models for new database development and/or changes to existing ones
• Install and configure relevant network components to ensure database access as well as database consistency and integrity as approved by management
• Respond to and resolve database access and performance issues
• Monitor database system details within the database, including sp’s and their execution time
• Monitor, optimize and allocate physical data storage for database systems as approved by management
• Experience with SCOM to monitor and manage critical database servers from a centralized location
• Create, or support creation of, required reports in response to business user needs
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts
• Used multitask data pump in DTS/ETL. Assist with database transaction and security audits.
• Develop routines for end-users to facilitate best practices for database use
• Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases
• Setup, monitor, and resolve database mirror issues
• Apply SQL service packs and patches

Environment: SQL Server 2005, SQL Server 2008, T-SQL, Windows Server 2003, Windows Server 2008

Confidential

SQL Server DBA/ Application DBA

Responsibilities:

• Installing and configuring Windows and SQL clusters including 3 node clusters, 4 node clusters, and adding a node to an existing cluster.
• Involved in the migration of databases from SQL server 2005 to SQL server 2008 R2.
• Implemented and configured Central Management Servers to centralize and manage about 30 instances of SQL Server 2008 R2 and SQL 2005.
• Implemented Data Collector and Data Management Warehouse to collect performance data of all the SQL instances.
• Enabled Transparent Data Encryption on critical databases.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Deployed SSAS cubes to the server and created security roles.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Used server scoped DMV’s and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS).
• Upgraded DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
• Involved in full life cycle of the project from Requirement analysis, Design, Development and Testing.
• Analyzed the requirements and significantly contributed in developing database architecture for the application.
• Responsible for creating the Entity-Relationship diagrams, Class diagrams, Sequence diagrams and Flow diagrams using Visio 2002 and documenting the project architecture.
• Trouble shooting and fine-tuning of databases for its performance and concurrency.
• Backing up the databases and restoring them in different environments.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Created stored procedures, views, triggers, user defined functions to apply business rules to the data.
• Worked on replication and Change Data Capture.
• Responsible for creating thereportsbased on the requirements usingSSRS.
• Responsible for maintaining versions of source code using Team Foundation Server.
• Involved and communicated test results for application level testing, and Integration Testing.
• Involved in writing System Documentation and Code Documentation.

Environment: SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, .Net, Visual Studio.

Confidential

SQL Server DBA/ Application DBA

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.
• Worked on Server Native tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Responsible for migration of databases from one version to other versions and applying patches
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
• Migrated SQL server 2000 DTS to SQL Server 2005 and above into SSIS packages incoordination
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Assign permission to users, roles, and object. Administrate security for server’s logins with Windows and SQL Accounts.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Implement the New features like Table and Index Partitioning for Larger Tables in SQL Server 2005 for achieving performance enhancement.
• Performed transformations and data flow tasks using VB scripts.
• Worked with Application development using Visual Basic.
• Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
• Actively participated in gathering of User Requirement and System Specification.
• Used DDL and DML to writing triggers, developed stored procedure, functions, views and triggers.

Environment: SQL Server 2000/2005, T-SQL, Windows Server, HTML 4.0, JavaScript, Access

Confidential

SQL Server DBA

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Involved in Data modeling to develop the database design using Erwin.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Provided 24/7 critical production support for data issues and given appropriate solutions.

Environment: SQL Server 2000/2005, T-SQL, CVS, Windows NT/2000/XP