SUMMARY

• Having 9 years of experience in Database Administration, Development and Design with SQL Server 2014/2012/2008/2008 R 2/2005/2000.
• Experience in supporting Very Large OLTP Databases of size 13TB and troubleshooting the performance bottlenecks.
• Experience in managing Windows 2000/2003/2008/2012 servers in a clustered environment. Configured Active/Active and Active/Passive clustering for failover.
• Experience with SQL Server 2012/2008 R2/2005/2000 installation, Migration, configuration, SSIS, SSRS and administration.
• Implemented new features in SQL Server 2012 like Always ON Availability Groups, data compressions and Contained Databases.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Database Mirroring, Log Shipping, Transactional & Merge Replication in SQL Server 2014, 2012 and 2008 R2.
• Experience in scheduling Backups and Restore, and Maintenance plans using Native & Third - party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
• Expertise in Scheduling Database tasks Jobs, Alerts, Emails, Notification.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Used PowerShell script for SQL Server Maintenance activities.
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Involved in Migrating databases from MYSQL and Oracle to SQL Server 2012 databases.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues, upgrading SSIS packages from SQL Server R2/2012.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Performed Object Level Audits using Change Data Capture (CDC) and implemented TDE (Transparent Data Encryption).
• Experience in configuring Resource Governor, Policies in Policy Management.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Extensive experience in writing T-SQL, creating Stored Procedures, Functions, Triggers, and Distributed Queries.
• Testing methodologies and tools - Automation and Performance testing.
• Excellent Communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team.

TECHNICAL SKILLS

Databases: MS SQL server 2014/2012/2008 R 2/2008/2005/2000.

Operating Systems: Windows Server 2012/2008 R2/2008.

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server.

Other Tools: Microsoft Visual Source Safe, IDERA, Redgate, Foglight, Sentry.

Data Modeling Tools: Erwin, Microsoft Visio 2007.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyser, SQL server DTS mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers Setup and Configured Always On Availability Groups for DR and Reporting.

PROFESSIONAL EXPERIENCE

Confidential, MaryLand

Sr SQL Server Database Administrator

Responsibilities:

• Responsible for Installation, configuration and complete administration of MS SQL Server 2014/2012/2008/2005.
• SQL Serverupgrade and migration from version 2008 toSQL Server 2012 andSQL Server 2014.
• ImplementedSQL 2012 Always ON Availability Groups feature.
• Implemented the transactional replication from the client facing SQLinstances to the processing SQLinstances.
• Maintained server level, database level and object level security best practices by creating logins and users, configuring permissions and assigning different roles to users.
• Managed database maintenance tasks such as Database consistencies, Index defrag/rebuild, update statistics, Log capacity Monitor.
• Used the log shipping methodology to migrate the VLDB's.
• Daily review ofSQLserver errors, maintenance jobs and server health.
• Created DB objects like Tables, Stored procedures, Functions, Triggers and Views using T- SQL.
• Implemented Transparent Data Encryption (TDE) to encrypt the sensitive data.
• Installed and applied Service Packs (SP) onSQL Server 2005, 2008, 2012 and 2014.
• ImplementedSQLserver auditing for tracking and logging events that occur on the Database Engine.
• Implemented the Resource Governor to manage theSQLServer workload and resources.
• Used Performance Monitor, Profiler, and Database Engine Tuning Advisor to solve Dead Locks/Long running queries.
• Created operators, Alerts and Database Mail using SSMS.
• Created SSIS Packages to Extract, Transform and Load data into database.
• Created and deployed reports usingSQLServer Reporting Services (SSRS).
• 24 X 7 Production Database on Call rotation Support.

Environment: SQL Server 2014/2012/2008 R2/2005/2000, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL ProfilerAlwaysOn, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager.

Confidential, KY

Sr. SQL Server System Administrator

Responsibilities:

• Planned and Successfully Installed SQL Server 2005, 2008 and 2012 on the Production and Development Servers.
• Successfully applied Service Pack 2 and Hot-fixes for SQL Server 2005, 2008, 2008 R2 and 2012 in all the Dev and Prod Environments.
• Involved in migrating the existing 2005 databases to SQL Server 2008 R2and 2012 (Side by Side).
• Installing, configuration and troubleshooting of change data capture(CDC).
• Involved in physical to virtual migration using VMware.
• Worked with windows team installing new sql servers in VMware.
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Raising the change management request and following up with the customer approval, for making any changes in the production server.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of Transactional Replication as HADR concept.
• Implementing Database maintenance plan for Database consistence & Integrity.
• On call 24/7 support to databases on weekly rotation.
• Experience with SSIS (Integration Services),SSAS (Analysis Services),SSRS (Reporting Services).
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Used SSRS to build health check reports & deploying the SSRS.
• Experience in using Data driven Subscription to prevent unforeseen circumstances.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Involved in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Recovered many Databases at the time of Database crashes or data loss.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Experience in monitoring databases and SQL Servers using IDERA Diagnostic Manager and generate reports for storage forecasting purpose.

Environment: SQL Server 2012/2008 R2/2005/2000, VMware, Virtualization, DTS, SSIS Packages SSAS, SSIS, SSRS, DTS, SQL Profiler, Log Shipping, Replication, Report Builder, Windows 2008 R2/2003/2000, ERWIN, Idera Diagnostic Manager.

Confidential, Indianapolis

SQL Server Administrator

Responsibilities:

• Installed, Configured and Maintained SQL Server 2008 in production, development, QA and Staging environments.
• Provided Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008 R2/2008/2005).
• Upgraded to SQL Server 2008 R2and guiding the development and application team to fully utilize SQL Server 2008 R2 enhancements.
• Created Merge Replication between different data centers.
• Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements.
• Used SQL Server Profiler to monitor the server by running traces on various events like User connections, stored procedure execution time etc.
• Evaluated the Database Performance of Index tuning with using DTA to resolve Performance issues.
• Setup and configured SQL Server for other business functions. Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Scripted the Database Consistency Checks (DBCC), scheduled the scripts to run daily and weekly basis.
• Monitored via SQL modules like Idera Diagnostic manager, Tivoli etc for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks.
• Responsible for SQL Server tuning, performance evaluation, optimization and utilized new features like SQL Dynamic Management Views for the same.
• Used Visual Source Safe 2008 for version control. Created various Stored Procedures to enforce the business logic.
• Created Database Diagram using Erwin Data Modeler, Data Dictionary Document, Database Installation and
• Configuration Document and Merge Replication Setup Document.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• The SSIS packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Provided primary pager support on rotation basis.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT 4.0,SSIS

Confidential

SQL Server DBA /Developer

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows 2003 Server.
• Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2003 server cluster.
• Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.
• Modelled and designed the architecture of the SQL Server 2005 database.
• Successfully applied Service Packs and Hot-fixes for SQL Server 2005 in all the Development and Production Environments.
• Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24 X 7 dedicated support to allProduction/staging/development servers.
• Involved in tuning Complex SQL Queries as a part of Query optimization.
• Configured Log shipping from one production server to the staging server.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS from Oracle Databases and Flat files.
• Ensure the database consistency and integrity through various database maintenance plans.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins.
• Job Monitoring and making sure all jobs run successfully every night.
• Used third party tool, LITESPEED to speed up backup operations.
• Monitor SQL Error Logs, Schedule tasks, database activity.
• Had good experience in 24/7 production support.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005/2008 R2SSIS packages and resolved issues during migration.
• Migrated Stored Procedures from 2000 to SQL Server 2005/2008 R2 to refer to Dynamic Management Views.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Analysed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application & database performance using SQL Profiler, Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases and rebuilding only necessary indexes for faster query response.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Implemented backup and retention strategies based on business policies.
• Performed Backup/Restore by using VERITAS Net Backup.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
• Improved performance of slow running queries using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.

Environment: T-SQL, SQL Server 2000/2005, Windows 2003/NT, Log shipping, Clustering, DTS, LITESPEED.