SUMMARY OF QUALIFICATIONS:

• Around 6 years of experience in SQL Server DBA, Design and Development with 2012/2008 R2/2008/2005 with System Analysis.
• Expertise in 24 X 7 Production Database support and on Call Support.
• Expertise in Administration, Database Design, Performance Analysis, and Production Support for Large VLDB , Complex Databases up to 6 Terabytes and implemented policies/procedures for ensuring the security and integrity of the databases.
• Expertise in Database Backup and Recovery procedures for Disaster recovery using native and third party tools.
• Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expertise in using Performance Monitor/Profiler to resolve Dead Locks/Long running queries on 32 bit and 64 bit clustered and standalone server environments.
• Expertise in Migrating/Upgrading SQL Server 2000 to 2005 and from SQL Server 2000 and 2005 to 2008, 2008 R2 and 2012.
• Expertise in RAID configurations, SAN boxes and Virtual Environment
• Expert in Active/Active Clustering, Mirroring, Log Shipping and Replication
• Expertise in Implementing High Availability and Disaster recovery
• Expertise in diagnosing and tuning the server optimal performance using SQL Server 2005's Dynamic Management Views DMV .
• Experience in implementing High availability like different Replication models, Log shipping, clustering and mirroring on physical and virtual machines.
• Good experience with logical modeling and physical modeling by using ERWIN.
• Expertise in writing and debugging stored procedures ,triggers, Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Worked with Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs and stored procs for performance
• Experience in Software Development Life Cycle SDLC , Analyzing and Designing systems using Structured Methodologies ERD, DFD along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, and Backup.
• Created varieties of Reports using SSRS 2008/2005 like drill down, cross tab, matrix style layouts, parameterized reports, performance issues handling, Sub Reports, Ad-hoc Reporting framework design.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Good knowledge in Designing and Building the Dimensions and facts for cubes with star schema using SQL Server Analysis Services SSAS .
• Expertise In using SQL Server monitoring tools like SQL Diagnostic Manager, Spotlight.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Technical Skills:

MS SQL Server 2012/2008 R2/2008/2005/2000, Windows Server 2008 R2/2008/2003/2000, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS . Data Modeling, Erwin 4.0/3.5, PowerShell, VBScripting, OLAP Tools, SQL, Perl, Visual Basic, Oracle, Sybase, TOAD, SQL Loader, IDERA Diagnostic Manager, Apex SQL Monitoring Tools

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Server DBA

• Confidential is an independent agency that conducts nearly 400,000 administrative hearings each year. Mission is to provide fair and timely hearings. OATH oversees the operations of four tribunals: the OATH Tribunal, the Environmental Control Board, the Health Tribunal, and the Taxi Limousine Tribunal. It also offers training services through the Administrative Judicial Training Institute.
• Responsibilities:
• Responsible for maintaining 250 SQL Servers: 150 servers were production servers and 100 were mission critical and 50 were business critical servers, remaining test and development servers.
• On call 24/7 support to databases on weekly rotation
• Worked on supporting environment which in High Availability HA and DR
• Supported Systems in Clustered, Log Shipped and Mirrored environment
• Configured Failover Clustering Active/Active and Active/Passive clusters
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008 and Experience in configuring and deploying SSIS and SSRS reports
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Worked with Profiler for finding Performance problems
• Used DTA Data Tuning Advisor to load SQL Scripts and find problem areas
• Used PerfMon and SQL Server DMV's for finding performance problems and resolving them
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests
• Implementation of SQL Logins, DB Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Administering MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Used SQL Server Management Studio SSMS and SAC
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Extensively used Stored Procedures for handling the database operations
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Environment: SQL Server 2012/2008 R2/2005, Active/Active Clustering, Mirroring, Log Shipping, Replication, Physical, SSMS, SAC, SCM, DMV, DTA Virtual, Production, Development, SSIS, SSAS, Diagnostic Manager, Litespeed, Windows Server 2008 R2, SAN, VMWare, T-SQL, PowerShell, VBScrit, Oracle, SharePoint, .NET

Confidential

SQL Server DBA

• Confidential. is a Fortune 500 health care services company based in Dublin, Ohio. The firm specializes in distribution of pharmaceuticals and medical products, serving more than 60,000 locations.
• Responsibilities:
• Installed, configured and supported SQL Server 2008 R2 in clustered and non-clustered environments.
• Administered SQL Server's linked servers to facilitate distributed Queries.
• Performed capacity planning and resource allocation for SQL Servers in the environment
• Created databases and database's objects like tables, views for different SQL Server projects.
• Configured and monitored Failover clustering Active/Active, Active/Passive
• Developed and tested storage strategies and disaster recovery plans for 1.6 TB database.
• Created plans and procedures to migrate mission critical databases to HP Superdome Servers.
• Upgraded SQL Server 2000 to 2005 and 2008 versions and applied SQL service packs and patches.
• Monitored Windows and SQL Server logs to proactively resolve issues.
• Set up traces and Profiler to fix performance issues.
• Analyzed deadlocks blocking on the server.
• Fixed problems related to memory, CPU, I/O, Disk, etc.
• Enforced company's security policies by creating logins and assigning them proper roles and privileges.
• Configured Log Shipping and Mirroring for Disaster Recovery
• Generated DDLs in ERWIN to create objects in non-prod databases as per project need.
• Maintained SQL Server backups and recovery plans.
• Coordinated change controls for production rollouts.
• Performed data transfers through SQL Server import and export wizard.
• Routinely conducted database monitoring and performance tunning using tools like Diagnostic Manager, SpotLight.
• Greatly reduced slow running Queries by proper indexing and updating statistics.
• Properly configured and distributed User DBs and Tempdb files to escalate performance.
• Participated in yearly BCE Business Continuity Exercises to validate DR strategy.
• Lead a team of offshore DBAs to support 24x7 critical US-Card log shipped environment.
• Performed database migration to the HP Superdome Servers.
• Worked with Microsoft and Scalability Experts to collect performance metrics on the new HP Superdomes.

Environment: SQL Server 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Diagnostic Manager, Spotlight, ERWin, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL, PowerShell

Confidential

SQL Server DBA

• Confidential Squibb often referred to as BMS, is a pharmaceutical company, headquartered in New York City. The company was formed in 1989, following the merger of its predecessors Bristol-Myers and the Squibb Corporation. Bristol-Myers Squibb manufactures prescription pharmaceuticals in several therapeutic areas, including cancer, HIV/AIDS, cardiovascular disease, diabetes, hepatitis, rheumatoid arthritis and psychiatric disorders. Its mission is to discover, develop and deliver innovative medicines that help patients prevail over serious diseases.
• Responsibilities:
• Installed SQL Server 2008R2 with the latest security patches.
• Performed database migration from SQL Server 2005 to SQL Server 2008 R2.
• Supported SQL Server 2008 R2 in a clustered and non clustered environment.
• Greatly reduced the time to run the nightly jobs to meet the Service Level Agreement SLA .
• Installed, configured and supported SSRS as a scaled out deployment.
• Imported and exported SSIS packages.
• Performed SQL Server monitoring through Quest's spotlight.
• Backed up databases and restored databases using lite speed.
• Created and fixed linked servers.
• Participate in creating scripts, stored procedures calls as per the department needs.
• Advised for better SQL Server performance and throughput.
• Performed routine diagnostics to ensure databases and servers are in good health.

Environment: SQL Server 2008/2005 with clustering, SSIS, SSRS, T-SQL, Oracle 10g, Windows 2003/2000/XP, SharePoint 2007