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, 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