SUMMARY:

• SQL Server DBA with 9+ Years of experience in MS SQL SERVER 2014/2012, 2008R2/2008/2005 Database Administration in Production, Test and Development environment.
• 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 2014/2012/2008 R2\2008\2005.
• 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 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.
• 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, Defrag 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.
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• 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 / R2 / 2005, MS-Access / 2007, My SQL 4/5, Oracle 9i / 10g

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 2012, Windows 2008R2, 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: SSRS, DTS.

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

PROFESSIONAL EXPERIENCE:

Confidential, CT

SQL Server DBA/ Developer

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2014, 2012, 2008r2, 2008, 2005.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshooted issues with the same. Applied hot fixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and trouble-shooted issues with witness servers.
• Involved in migration of SQL 2008R2 TO SQL 2012/2014
• Performed daily backups and developed recovery procedures.
• Patching all the SQL Servers 2008, 2008R2, 2012,2014 with the latest service packs.
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Design and implementation of large databases and data warehouses utilizing both relational and dimensional design concepts.
• Proficiency in analyzing large sets of data.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Trouble-shooted issues with log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Involved in Capacity Planning, data modeling and Logical/Physical database Design
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources
• Provided support to the application developers on the application databases
• Handled the database components of application releases
• Handled 24/7 production issues.
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Developed few reports using SSRS.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Working with Remedy Tickets (Any changes on staging and development environment need to Create Remedy Tickets)
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
• Proactively monitored, determined and solved issues at SQL/database/server levels.

Environment: Windows 2003/2008,2012, MS-SQL Server 2014/2012/2008 r2/2005, .NET Framework, Visual Studio, i3 performance tool, SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, AJAX, Visual Studio, HTML, XML, XSLT.

Confidential, MD

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.
• Configured mirroring on SQL Server 2012 Databases.
• Involved in migration of databases from SQL Server 2008 R2 to 2012 and SQL Server
• Implemented High Availability in SQL 2012 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
• Worked on pre-live BCP exercise to make sure mirroring will work after live migration.
• Implemented Log Shipping for warm backup solution for MS SQL Server databases.
• 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.
• Developed and Optimized Stored Procedures, Views and User-Defined Functions for 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 Tand Native tools like Profile and the Activity Monitor.
• Installing/administrating SQL Server Reporting Services (SSRS), creating schedule reports and delivering via email.
• Integration of Archer using various data feeds. Performing data transformation and system integration activities
• 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 Transitional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors) and troubleshoot replication issues.
• Used SQL server Profile to identify and analyze deadlocks.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Perform Impact analysis and provide optimal solutions to the Client, Business users.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• 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.

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

Confidential, Columbus, Ohio

SQL Server Database Administrator

Responsibilities:

• Installed and configured SQL Server 2012/2008 R2 Database instance in a Clustering 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.
• Involved in setting up, managing and maintaining High availability technologies: Log shipping, Mirroring and Replication.
• 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.
• Handled up to 2 TB Size databases with Clustering 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.
• Implementing current Policy and Risk Process in Archer.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Monitoring SQL server performance using profile 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.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Extensively worked on decommissioning the legacy databases from SQL 2008/2005.
• Responsible for maintenance and support for a two node Active-Active Clustering 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, AWS, DB2, Access, MS OFFICE 2010

Confidential, Los Angeles, CA

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 Clustering and AlwaysON technologies
• Data Migration (transformations) from DB2 & Oracle to SQL Server 2008/2008R2 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 troubleshooting 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 2008/2008R2/2005, T-SQL, Windows Server 2003, Windows Server 2008R2.

Confidential, Princeton, NJ

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.
• 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.
• 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 the reports based on the requirements using SSRS.
• 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, 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 2005 databases into SQL server 2008 databases by In-place upgrade and also used upgrade advisor tool for up-gradation.
• Migrated SQL server 2005 DTS to SQL Server 2008 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.
• 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 2005/2008, T-SQL, Windows Server, HTML 4.0, JavaScript, Access

Confidential

Jr Database Admin

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 2005, T-SQL, CVS, Windows NT/2000/XP