SUMMARY

• 8 years of Experience in Database Administration and Development for very large and complex databases inSQLServer 2014/2012/2008/2008 r 2/2005/2000.
• Expertise in installing MSSQLServer 2000, 2005, 2008/R2, 2012 and 2014, updating with latest service packs and security patches.
• Supported several applications such as MS Dynamics CRM, BizTalk, SharePoint and several other OLTP systems.
• Exquisite in implementing different types of High Availability & disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping, Database Mirroring, Clustering and Always On Availability group.
• Proficient in database Backup, Restoration, Linked Servers and Database Maintenance Planning.
• Created maintenance plans for performing Optimizations, Rebuilt and Reorganize indexes.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities
• Extensively used tools likeSQLProfiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoringSQLServer performance.
• Worked with Popular Third Party monitoring solutions like SCOM, Fog - light, Red gate.
• Creating stored procedures, functions, packages, triggers, according to business requirements.
• Monitoring Event viewer,SQLError logs and Log Files for Software and hardware related errors.
• Outstanding experience inSQLEnterprises Manager and SSMS - creating and scheduling jobs, alert and operators withSQLServer Agent,SQLProfiler, Backup/Recovery databases.
• Expertise in planning and implementing Database Security by creating users, Roles, and assigning permissions to them.
• Migration ofSQLServer 2000 databases intoSQLServer 2005 andSQLServer 2008.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Created Linked Servers betweenSQLServer 2000 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Administered multipleSQLInstances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Sound knowledge in stored procedures, views and Triggers.
• Expertness in trouble shooting database issues like Locking, deadlocks, performance and blocking.
• Build complexSQLqueries (ex: using various joins and sub-queries) and stored procedures.
• Acquaintance in supporting Very Large databases and troubleshooting the problems.
• TuneSQLServer Integration Services (SSIS) packages, analysis services (SSAS) cubes and reporting services (SSRS) reports and models.
• Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MSSQLServer by using Import/Export utility, bulk insert and SSIS using BIDS.
• Experience in working with Reporting tool Microsoft Reporting Services, (SSRS).
• Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
• Worked with Microsoft premium support in troubleshooting production level issues.
• Strong experience in mentoring team members and writing technical documentation.
• Involved in domain level. System's administration.
• 24 X 7 Production Database on Call Support.

PROFESSIONAL EXPERIENCE

Confidential - Silver Spring, MD

Sr. SQL DBA

Responsibilities:

• Implemented column store indexes insqlserver 2012.
• Perform Database Backups and Recovery.
• Created Database Maintenance Plans for the performance ofSQLServer which covers Database Integrity checks, update database Statistics and Re-indexing.
• Expertness in trouble shooting database issues like Locking, deadlocks, performance and blocking.
• UpgradedSqlserver using in place and side by side techniques.
• Monitor SQL server performance, utilization, usage of DMV queries to performance tuning.
• Migrate datacenter consisting of sixty databases instances.
• Identified, tested and resolved database performance issues.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Exquisite in implementing different types of High Availability & disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping, Database Mirroring, Clustering and Always On Availability group.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Involved in the migration of existing DB environment to a highly available Active Passive Failover cluster Environment.
• Worked with the Microsoft premium support in troubleshooting production level issues.
• Written business related and Technical documentation.
• Creating store procedure, scripts, triggers.

Environment: SQLSERVER 2014\2012\2008\2005, Windows 2012\2008\2003 Server, Avamar, Red Gate, SCOM, Microsoft Dynamics CRM, BizTalk, SharePoint.

Confidential - Marysville, OH

Sr. SQL DBA

Responsibilities:

• Installing, configuring, monitoring and administration SQL Server.
• Responsible for Database backup and recovery of System and User databases.
• Created Users, Roles and managed security and permission of database.
• Involved in an Upgrade project by upgrading productionSQLserver r2 using a side by side upgrade strategy.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging andSQLServer and also bottleneck ofSQLServer such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Responsible forSQLPerformance tuning by usingSQLdatabase tuning advisor,SQLProfiler.
• Creating, configuring and managing Always on Availability groups onSQLserver 2012.
• Worked on backup tools like Lite Speed, Red Gate, and IderaSQLsafe.
• Worked with Popular Third Party monitoring solutions like PAL, Fog-light.
• Used System Center Configuration manager SCOM to monitor servers.
• Experience in using partitioning inSQLServer 2005 by allowing tables and indexes to be partitioned across multiple file groups.
• Used SSIS (SQLServer integration services) 2008 for data extraction, transformation and loading (ETL).
• Performed regular reviews of database security and adjusted accordingly to ensure access and modification only to authorized users and/or applications.
• Involved in the design and implementation of Disaster Recovery or data recovery plan (DRP), involving database servers and application servers.
• Responsible for high availability methods like clustering, transaction log shipping, replication, database mirroring.
• Configured Active/Active and Active/passiveSQLServer Clusters.
• Identified and analyzed expensive T-SQLstored procedure by using theSQLProfiler (Tracing),SQL analyzer and Index tuning wizard. Optimized long running Stored Procedures & queries for effective data retrieval.
• Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Involved in the migration of existing DB environment to a highly available Active Passive Clustering Environment.
• Handled multiple tasks and responsibilities independently as well as a proactive team member.
• Have been worked as a system administrator.
• Involved in writing technical documentation.

Environment: SQLSERVER 2012\2008\2005, Windows 2008\2003 Server, SSIS, Light Speed, Red Gate,SQLProfiler.

Confidential - Dallas, TX

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQLServer 2008/2005/2000 production and Non-production servers.
• Involved in the migration ofSQLServer 2000 databases toSQLServer 2008 R2.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using TransactSQLStatements,SQLServer Management Studio and Database Wizard.
• Involved in a multiple Consolidation projections by moving multiple databases to a single instance.
• Used System Center Configuration manager SCOM to monitor servers.
• Created Database Maintenance Plans for the performance ofSQLServer which covers Database Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database 0structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Maintaining the database consistency with DBCC utility Confidential regular intervals.
• Worked on log shipping for synchronization of database.
• Worked on Failover Cluster Environment.
• Authenticated logins and validated permissions. CreatedSQLServer Database users and Roles.
• Involved in database Normalization, logical and physical data modeling using ERWIN.
• Created and supported complex database schemas.
• Managed VERITAS net backups and lite speed backups.
• UsedSQLProfiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• InstalledSQLServer 2005 and created Development Database for testing, upgrades and development.
• Monitored servers using SCOM.
• Troubleshootsqlserver performance issues with Microsoft premium support.
• Worked on DTS, Import and Export utility, for transferring data.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Environment: Windows 2008/2003 server, MSSQLServer 2008/2005/2000, T-SQL, MS Access, MS Excel, VERITAS.

Confidential - San Diego, CA

SQL Server DBA

Responsibilities:

• Involved in merging existing databases and designed new data models to meet the requirements.
• Ensure data recovery, maintenance, data integrity and space requirements for physical Database.
• Fine-tuned the logic in Stored Procedures and Triggers for optimum performance.
• Run DMV, DBCC consistency checks for checking the allocation and structural integrity and fixing data corruption in application databases.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Maintain and configure Failover Cluster.
• Reorganize database structures as needed, automate procedures Confidential regular intervals.
• Involved in the design and implementation of Disaster Recovery, involving database servers and application servers.
• Created and maintained all types of Backups and recovery strategies and set up jobs.
• Performed Database backups (operating system, flat file backups & export/import).
• As an administrator was responsible f0000or high availability methods like transaction log shipping, replication, database mirroring.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Performed the peer to peer transactional log replication
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
• Optimize long running Stored Procedures & queries for effective data retrieval.
• Performed user and security level administration tasks which included creating and maintaining users and assigning them appropriate privileges.
• Scheduled jobs, alerts and analyzed business requirements.

Environment: SQLSERVER 2008\2008r2, DTS, Windows 2008\2003 Server, Visual studio, SSIS, Erwin,SQLProfiler, SSAS.