SUMMARY:

• Around 7 years of experience in Database administration, development and support of SQL Server 2014/2012/2008 /2005.
• Experience in installing, configuring and upgrading of SQL Server 2014/2012/2008 /2005 applying Service Packs and Hot Fixes.
• Wide knowledge on Implementing and monitoring of security at Server, Database and Objects level.
• Experience in performing Backup & Restore using different backup medias, Involved in creating & documenting Backup strategy & Disaster Recovery plan for production and development servers within specified maintenance Window.
• Actively involved in Installation, Configuration and Maintenance of Microsoft SQL Server Active/Active, Active/Passive Clustering.
• Configured a ‘warm standby’ by implementing Log Shipping as a fault tolerance mechanism for some of the critical operational databases.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and transactional log backups.
• Good experience in Automation Configuration by Creating Jobs, Alerts and Maintenance plans.
• Hands on experience with SQL Server Management Studio and T - SQL in constructing triggers, tables, user functions, views, indexes, covering indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Hands on experience on using Extraction, Transformation and Loading (ETL) tools like Data Transformation Services (DTS), SQL Server Integration Services (SSIS), BCP and Bulk Insert.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using BCP, Bulk Insert & DTS utility.
• Hands on experience setting up Resource Governor for performance tuning.
• Knowledge on SQL Server and Database Monitoring & Tuning for better performance using different tools like Database Tuning Advisor, Systems Performance Monitor, Event viewer, SQL Profiler.
• Extensive knowledge in resolving Deadlocks, Optimizing SQL queries, Stored Procedures to improve performance to the optimal level.
• Experience in implementing database consistency checks using DBCC utilities.
• Experience in connecting remote SQL servers as Linked Servers.
• Good Knowledge of RDBMS and Database design issues like Normalization and De-normalization.
• Experience in Data Modeling using Erwin Design Tool.
• Worked with third party monitoring tools like Idera diagnostic manager, Quest lite speed

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012, 2008R2, 2008, 2003

Databases: Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000

Programing Languages: T-SQL,SQL,PL/SQL, PowerShell, HTML, C#, C/C++ &XML

Database / ETL Tools: SQL Server Integration Services (SSIS), SSAS, DTS, JQuery Analyzer, SQL Profiler, TOAD

Reporting Tools: SQL Server Reporting services (SSRS), Cognos, Business Objects, Report Builder

Third Party Tools: SQL Lite speed, IDERA, ERwin Data Modeler and SQL Compare, TFS, JIRA, BMC Patrol

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, FL

Sr. SQL Server Database Administrator

Responsibilities:

• Expertise in installing and configuring of Microsoft server 2014 for database administration and development.
• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
• Implemented and Maintained Transactional and Snapshot Replication for reporting purposes.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Scheduling jobs and monitoring and troubleshooting them.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and built in performance reports.
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.
• Creating logins and database users, roles and providing permissions to users and roles according to the requirement and security policy.
• Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
• Worked in designing of SSIS packages for integrating data using OLE DB connection from heterogeneous sources(Excel, CSV, Flat file, Text format data) by using multiple transformations provided by SSIS such as Aggregate, Data conversion, conditional split, bulk insert, fuzzy grouping.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.
• Resolving SCOM alerts and implemented maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries and purging old files for preventing space issue.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks

Environment: SQL Server 2014/2012/2008 R2,C#.Net, MVC,Windows Server 2008(x64), JQuery, SQL Server Management Studio, T-SQL,SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, SCOM, SSRS, SSIS

Confidential, Boston, MA

Sr. SQL Server DBA

Responsibilities:

• Responsible for installing and maintaining SQL 2008 R2, SQL 2012 Cluster environment.
• Performed migrations from SQL server 2008R2 to SQL server 2012.
• Applying existing servers with relevant Service Packs, Hotfixes and any Critical Security Updates released by Microsoft .
• Implemented High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and log shipping.
• Implementing backup, restores and log shipping using Lite speed tool.
• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Monitoring locking/blocking and space management issues.
• Scheduling jobs and monitoring and troubleshooting them.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of users.
• Scheduled Backup/Recovery jobs and developed Disaster Recovery Plans.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Created and maintained data objects such as tables, views, indexes, referential integrity depending on user requirements and converting them to technical specifications.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.
• Provided 24x7 Production support for the database and application issues.

Environment: Microsoft SQL Server 2012/2008 R2/2008, C#.Net, MVC, Windows 2012/2008 Servers, T-SQL, SQL Server Profiler, SSIS

Confidential, Detroit, MI

SQL Server Production DBA

Responsibilities:

• Installed, upgraded and configured SQL Server 2012, 2008R2 for several applications with latest service pack
• Migration of SQL Server 2005 Databases and In place Upgrade from SQL 2005 to SQL 2012
• Administrated and managed SQL Server 2012/2008R2/2008/2005 databases in production, Staging, QA and development environments.
• Experience in Database Mirroring, Database Snapshot and Isolation Levels.
• Ensure the compatibility level changes and perform database checkup routines to ensure consistency and integrity is preserved
• Capture performance baselines for old and new environments using perfmon.
• Daily periodically monitored performance using both System Monitor and Profiler.
• Proficiency in developing Maintenance plans, backup, recovery strategies and Rebuild/Reorganize strategies.
• Reviewing and verifying Database backup details, Database user privileges, Inactive user accounts.
• Monitoring Year Old SQL Authenticated accounts, Sys Admin Accounts and Password Policy Check for SQL Accounts.
• Experience with moving physical data and log file from one drive to another drive.
• Monitoring CPU resource usage and SQL Server disk management.
• Configured Database mail and linked servers between SQL Server to SQL Server, SQL to Oracle Servers, and SQL to MS Access Databases
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Implemented and maintained Transaction replication, Mirroring for high availability.
• Applying service packs for old and new environments according to the Enterprise Architecture standards
• Working on Visual studio 2010, 2012 and on TFS to deploy projects
• Good Knowledge of using SSRS (SQL Server Reporting Services).
• Experience with the IP Compliance Check list to get the performance report of the Server.
• Ran DBCC CHECKDB on all the databases to verify database integrity after migrating.

Environment: MS SQL Server 2005/2008/2008 R2/2012, (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, T- SQL,Windows2003/2008 Visual Studio, TFS

Confidential, Bothell, WA

Microsoft SQL Server DBA

Responsibilities:

• Installing SQL Server 2005 and 2008 and administration of nearly 100+ servers ensuring zero downtime.
• Installed and Configured SQL Server 2005 and 2008.
• Upgraded the existing database to SQL Server 2005.
• Involved in setting up, managing and maintaining High availability technologies: Log shipping, Mirroring and Replication.
• Involved in implementation of replications like Snapshot and Transactional.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Involved in Partitioning Databases and Tables for better Performance issues.
• Implemented Databases log shipping using the Lite-speed.
• Security Compliance on the servers to bring the server under compliance and security policies.
• Involved in upgrading the instance of development environment of SQL Server 2000 to 2005.
• Defined report layouts including report parameters, Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005/2008.
• Resolving locking (Dead Locks) and blocking issues.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Involved in SQL Server Cluster and Database Mirroring implementation.
• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
• Worked as a team member for 24X7 on call production support.

Environment: MS SQL Server 2000/2005/2008, Business Intelligence - MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, Database Tuning Advisor, T- SQL,Windows2003/2008 server.

Confidential, Virginia Beach, VA

ETL / Business Analyst

Responsibilities:

• Involved in complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Architecture and design support to provide solution for business initiated requests/ projects
• Analyzed the functional specs provided by the data architect and created technical specs document for all the mappings.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved in business analysis and technical design sessions with business and technical staff to develop
• Performance tuned and optimized various complex SQL queries.
• Prepared user requirement documentation for mapping and additional functionality.
• Analyzed current system and programs and prepared gap analysis documents
• Experience in Performance tuning & Optimization of SQL statements using SQL trace
• Created several TD scripts for the ETL and DBA needs
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Created stored procedures using in MS SQL Server
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Responsible for creating workflows. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager
• Prepared user requirement documentation for mapping and additional functionality.
• Responsible for conversion of Informix-based client data transfers to Oracle-based electronic reporting system
• Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.

Environment: SQL Server 2005/2008, MY SQL, PL/SQL, Informatica, Oracle, ETL, MS SQL Server, SQL Agent, SQL Profiler, Database Tuning Advisor, T- SQL,Windows2003/2008 server.