SUMMARY

• Over 7 years of strong MS SQL Database Administration experience in Real Estate, Retail, IT solutions, and Insurance domains with expertise in installation, configuration and administrationof MS SQL Server 2012/2008/2005/2000 .
• Extensive experience in installing, configuration and administration of MS clustering.
• Well versed with development life cycle including business process analysis, requirements gathering and analysis, high level design, detailed design, development, testing, QA and post implementation support.
• Experienced in maintaining the database systems includes but not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Well - versed in Coordinating with the Systems Administration team, install and maintain approved application software and systems that integrate with company’s database systems.
• Responsible to Monitor and troubleshooting Log Shipping,Database mirroring and transactional replication.
• Proficient in implementation and maintenance of database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Database Mirroring, SQL Mail, database mail.
• Proven skills in data compression techniques such as Row, Page and Dictionary compression to store and allocate the data on the page.
• Setup and configured Database mirroring in High Performance and High Availability mode as standard Disaster recovery strategy.
• Review of physical and logical database design; promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Extensive experience working with Dedicated Admin Connection (DAC) for connecting the SQL server when normal connection attempt fails. Prepare current database structure and configuration for high-performance through analysis and optimization.
• In-depth knowledge working with SQLCMD for the enhanced performance of the SQL server.
• Well-read with tuning and functioning of Utility Control Point (UCP) to collect configuration and performance related information from SQL server.
• Expertise in Tuning queries that are running slow using Profiler and Statistics by using different techniques to evaluate joins, indexes, updating Statistics and code modifications.
• Hands on experience working with XEvent for any extended SQL server events.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG (Always On Availability Group).
• Worked on logical and physical database modeling with UML and ERWIN tools.
• Experienced in configuring the standby servers like hot standby, warm standby and cold standby.
• Expert in copying tables, schemas and views from one SQL server to another.

TECHNICAL SKILLS

Tools: and Technologies: MS SQL Server 2012/2008/2005/2000, SQL Server Integration Services, SQL Server DTS, Data Stage, Database mirroring, MS clustering, Rational Rose, Replication, VB6, Log shipping, failover clustering, MS Word, MS Excel, Share Point 2010/2007.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

SQL DBA/Engineer

Responsibilities:

• On routine basis was responsible for providing 24 X 7 critical production support to numerous production, development and clustered servers.
• Implemented and maintained high availability solutions that included clustering, database mirroring and log shipping.
• Successfully migrated 100+ SQL 2008 databases to SQL 2012.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2008 to MSSQL 2012.
• Employed Resource Governor to control and allocate CPU and memory resources depending on the priority of the applications.
• Configured Resource pools, Workload groups and Classification functions to deploy Resource Governor in SQL server.
• Implemented different backup strategies such as full backup, Differential backup and Transactional log backups depending on the need of the company.
• Engaged in using Piecemeal Restore on SQL server to allow administrators restore missing file groups in stages while the database is still online.
• Used Peer-to-Peer replication providing a scale-out and high availability solution by maintaining copies of data across multiple servers.
• Installed Failover Clustering instances on various SQL server databases.
• Configured Database Mirroring and applied the transaction from any insertion, deletion of update made on the principal database.
• Worked with signing modules with a certificate for granting various permissions from auditing perspective.
• Proactively monitored the production database(s) and optimize stored procedures for better performance.
• Extensively worked with resolving locking conflicts and resource utilization in SQL server.
• Implemented security, generate and review report periodically and enforce security mechanism.
• Administered, maintained, developed and recommended policies and procedures for ensuring the security and integrity of the company’s databases and systems.
• Diagnosed problems using tools such as SQL Profiler and System Monitor and also worked with vendors and developers as needed to resolve various kinds of other issues.
• Monitored database systems performance, capacity and availability.
• Worked on data mapping and conversion, manage disk space, change control and bug fixes.
• Developed and implemented Disaster Recovery (DR) on production SQL Server 2005
• Managed and resolved problematic database-related issues submitted by clients.

Confidential, New York, NY

SQL Server Technical Database Administrator

Responsibilities:

• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations to avoid any bottlenecks.
• Created and maintained various databases on Production and development environments usingSQLServer 2008/2005.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed necessary Service Packs for SQL server 2005.
• Installed SQL server2005,2008and2012on a test environment to be the future production environment.
• Upgraded legacy 2000 databases to SQL server2005/2008.
• Involved inDatabase Backupandrecovery.
• Implemented high availability on the various servers usingreplication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Used stored procedure in a backup and restore process to copy data from Development node to a production node.
• Experienced in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Day-to-Day administration of SQLServers on Standalone and Cluster Environments.
• Extensively trained to use Peer-to-Peer replication providing a scale-out and high availability solution by maintaining copies of data across multiple servers.
• Responsible for Load and Performance testing of the database servers and application servers.
• Performing Health checks and monitoring performance of the Production Servers.
• Support enhancements and install bug fixes following proper scheduling.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Schedule meetings with managers/executives to gather business requirements.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Clearly define the requirements/issues based on the analysis of the informational needs.
• Strictly adhered to data security policies and procedures.
• Performed database administrative tasks.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Performed installation of SQL Enterprise bit version on Windows 2007 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
• Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• 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.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2012.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.

Confidential, St. Louis, MO

SQL Database Administrator

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Managed multiple SQLservers.
• Developed PowerShell scripts contorted by XML configuration files to do data backup from production and restore on test and training instances along with running maintenance SQLscripts.
• Managed security on Production and Development environments.
• Created and maintained various databases on Production and development environments usingSQLServer 2008/2005.
• Tuned databases for better performance.
• Repeatedly developed and ran SQLscripts to maintain data and software integrity.
• Supported IT Operations by performing database related analysis tasks, report writing and handling multiple database projects.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Managed BI Portals in SharePoint.
• Understood the functionality of many interfaces and map data to user interface design or enhancements and ensure correct functioning, retrieval and update of data.
• Worked on data migration techniques using SQL Loader, Import/Export, bulk and batch processing.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction
• Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experienced in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Extensively worked on Dynamic Management Views in SQL Server 2008.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Analyzed long running slow queries and tune to optimize application and system performance.
• Experienced to set up SQL Server configuration settings for better server management.
• Monitored the servers using third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Confidential, Bloomfield Hills, MI

MS SQL DBA

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Performed business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship (ER) diagrams.
• Monitored SQL server performance using SQL Profiler to find performance bottlenecks and deadlocks issues.
• Extensively operated on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Significantly worked on DBCC commands and Dynamic Management Objects.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Created Linked Servers between SQL Server 2005 & Oracle 9. Also created DTS package for data transfer between the two environments.
• Employed Resource Governor to control and allocate CPU and memory resources depending on the priority of the applications.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Creating and maintaining various databases on production/development servers and provide 24x7 support
• Involved in migrating SQL Server Databases from Development to Production Server.
• Configured Log shipping from Production to Disaster Recovery server as part of the disaster recovery plan.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• 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.
• Troubleshooting high availability and disaster recovery scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Deployed and scheduled SSIS package.
• Maintained security policies. Managed Logins and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures..
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2008 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2008 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe (VSS) for version control.

Confidential, Santa Clara, CA

MS SQL Server Developer

Responsibilities:

• Created tables, indexes and constraints.
• Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports.
• Created SSIS package to automate maintenance tasks such as database back up, update statistics, database consistency checks, re-build and reorganize indexes as well as create error log for event during data load.
• Used event handlers for accepting handling in SSIS packages and
• Involved in Developing, scheduling and deploying SSIS Packages to the Production environment and administering the packages.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports usingSQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Used Data Transformation Services (DTS), an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Broad experience in using SQLServer Profiler to monitor theSQL server for blocking and deadlocks, long running queries and tunes to improve performance.
• Responsible for installing, upgrading and configuring the SQL environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Traced frequently called procedures/packages and pinning them to improve the performance.
• Responsible for Load and Performance testing of the database servers and application servers.
• Used SQL Profiler, Query Execution Plan and Statistics to tune numerous slow running queries using different methods to evaluate joins, indexes, and statistics and code variations.