SUMMARY

• Experience in troubleshooting using SQL Tools, Performance Monitor, execution plans, Trace, statistics, index tuning wizard and optimizing the queries, tracing long running queries and deadlocks.
• Experience in migrating packages from DTS to SSIS.
• Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.
• MCTS - Microsoft Certified Professional in Administering Microsoft SQL Server 2012 Database
• Senior Microsoft SQL Server Database Administrator with over 7 years of Experience (SQL DBA).
• Expert in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2005.
• Experience in using SQL Server Native tools (Profiler, DTA, SSMS, SSIS, SSRS, SAC, PerfMon, DMVs, DMFs) and 3rd party DBA tools and applications (spot light, Erwin, Light Speed, RedGate, Idera )
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages
• Strong functional knowledge of T-SQL, Store procedure, Triggers and Views
• Quick learner and result- oriented individual with strong analytical aptitude and effective interpersonal and communication skills.
• Data Security, Backup & Recovery
• Standby/Failover Administration
• Microsoft SQL Server Administration and Maintenance
• SQL Server Performance Tuning and Troubleshooting
• SQL Server Upgrade and Migration
• Standardization of SQL Server environments
• SQL Server Failover Clustering Solution for High Availability
• SQL Server operational support (24x7) for critical applications

TECHNICAL SKILLS

Software: MS SQL Server 2012, 2008/R2, 2005.

SQL Server Tools: Enterprise Manager, Management studio, Profiler, SAC,SSCM, PerMon, DMV’s, DMF’s, Query Analyzer, Export & Import, DTA, SSIS, Replication, SQL Analysis services, Reporting services

Operating System: Windows server 2012/2008/2005/2003 Advanced Server, NT & Windows

Hardware: DELL 6850 Servers, DELL 6300 Servers, SAN arrays and Windows 2000 Servers

Third part Tools: Red gate, SQL Lite Speed, Idera, Erwin, spotlight

PROFESSIONAL EXPERIENCE

Confidential, Queens, NY

Senior SQL Server DBA

Responsibilities:

• Oversaw daily activities for 40 SQL Servers including security management, storage space, backups and restores.
• Installed & Configured SQL Server 2012 on windows 2008 servers and applied service packs and security fixes for all individual servers & Clusters.
• Worked on upgrade and migration from SQL Server 2008 to SQL Server 2012.
• Managed critical hourly backups using Quest Light Speed, database server and table optimization & restores, high transactional monitoring and optimization for multiple databases.
• Writing scripts and creating scheduler jobs to automate the tasks.
• Monitored SQL server performance using profiler to find performance issues or deadlocks.
• Designed and implemented comprehensive backup plan and disaster recovery strategies.
• Worked with SSIS and DTS packages, Created SQL clustered environment that was active-passive on 2 nodes.
• Troubleshot databases issues for clients during implementation, maintenance, upgrade, and migration processes.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Proactively used drive space, database size, and backup status for reporting historical and trending information to avoid any production disasters.

Environment: SQL Server 2008R2/2012 Enterprise, Windows Enterprise Server 2012, .NET, SSIS

Confidential, Freemont, CA

SQL Server DBA

Responsibilities:

• Assessment of SQL Environment for installation, configuration, storage, CPU, Memory, IO and security.
• Assessment of Batch Processes, ETL, SSIS, Database design for Optimization and Performance improvement.
• Administration and maintenance of SQL Server Instances into Production and Test environments.
• Setup of log shipping, Mirroring, Replication, Always On, Disaster Recovery planning and procedures.
• Setup of SQL Server High Availability Failover Clustering.
• Setup of jobs and alerts for Backup Restore (VLDB), re-indexing, integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes.
• Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs.
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup and archival software, hardware, and media, offsite storage.
• SQL Server upgrade and migration from version 2005 to SQL Server 2008.
• Development of Installer package for Microsoft SQL Server Analysis Services and required components.
• Maintenance and Administration of Databases and Multidimensional Cubes (Process, Backup, Restore).
• Setup, administration and maintenance of SQL Server Master Data Services (MDS).
• Assessment, Setup, Monitoring and troubleshooting of routine maintenance jobs and processes.
• Documentation, Leading projects, management, Training, Troubleshooting and support.
• Participating in production on-call rotation.

Environment: SQL Server 2008/ R2/2005, SSMS, SSIS, Windows 2008, Red-gate, SAN, VM

Confidential, Paramus, NJ

SQL Server DBA

Responsibilities:

• Installed and configured SQL server 2005/2008/R2 and administered 250+ servers.
• Monitored, Maintained, supported and optimized mission critical application databases.
• Upgraded SQL Server and applying service packs and hot fixes and unattended Installations.
• Responsible for enhancing database objects including Tables, Indexes, and Stored Procedures and SQL jobs.
• Worked with development team to optimize application specific database operations and implement security restrictions.
• Developed and maintained DTS packages using SQL server 2008 R2.
• Designed and implemented scheduled Database maintenance plans and back up procedures to enhance over all database performance and disaster recovery.
• Implemented database policies and procedures to ensure the integrity and availability of Databases and their accompanying software.
• Created SSIS Packages to migrate the data from database to flat files.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Respond to and resolve database access and performance issues.
• Set up alerting system by using performance counters for monitoring system performance.
• Created and scheduling SQL jobs for application specific data maintenance tasks and data purging strategies.
• Prepared scripts and scheduled maintenance tasks.
• Planned and implemented SQL clustering and stand by servers for minimizing system downtime.

Environment: Windows Server 2008R2, SQL Server 20012/2008, Transact SQL, SQL Query Analyzer, and Profiler

Confidential, Carol Stream, IL

Junior SQL Server Database Administrator

Responsibilities:

• Administration, Maintenance of multiple SQL Server instances into Prod-Stage-DEV environment.
• Design, Setup, Implementation, upgrade and migration of SQL Server databases.
• Setup of SQL Server High Availability Failover Clustering.
• Setup of STANDBY Disaster Recovery Server using custom Log Shipping and Backup Restore process.
• Setup of jobs and alerts for Backup Restore (VLDB), re-indexing, integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes.
• Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs.
• Query optimization using Show Execution Plan, SQL profiler, System Monitor and Query analyzer.
• Development of Indexes, stored procedures, views, functions and triggers using T-SQL scripts.
• Setup, monitoring and maintenance of SQL Server data Replication.
• Development and Maintenance of multi-dimensional cube using SQL Server analysis services.
• Installation, configuration and maintenance of security of SQL Server 2005 Reporting services.
• Documentation of coding standards, best practices, Technical specifications, policies and procedures.
• Troubleshooting, Training and support to users.
• Performed production support and on call duties.

Environment: SQL Server 2005, Windows 2003, VMWARE, SAN, Quest Diagnostic tools, Red-gate, SSIS, SSRS