SUMMARY:

• Confidential (Information Technology) with over a decade of experience in Database Designing, SQL Designing, Troubleshooting and Client Coordination
• Expertise in SQL Database Administration activities encompassing database planning, design, installation, configuration, disaster recovery planning, back up & recovery
• Skilled in design, development & support of MS SQL Servers 2012, 2008, 2005, 2000 development environments, replication and cluster server environments
• Hands - on experience on MS-SQL Code review & approval, applying database patches, up-gradation, migrations, database cloning, user management, space management and troubleshooting on Windows platforms
• An effective communicator with strong planning, analytical and problem solving skills

TECHNICAL SKILLS:

Operating Systems: Windows 2003, 2008, Windows Azure, Linux, Ubantu and CentOS

Database: SQL Server 2012, 2008, 2005, SSISand SQL Azure

Monitoring: SCOM 2007

Big Data: Hadoop Admin

AREAS OF EXPERTISE:

• Experienced database architect with experience in designing, implementing, and managing enterprise relational and dimensional solutions.
• Accountable for database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, developer/integrator relations, script development, documentation and DBA training.
• Troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics, and Index Tuning Wizard.
• Using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Preparing application development backup policies, database migration, SQL server replication, etc.
• Creating table’s paces, rollback segments, user maintenance, and database Confidential imposition by creation and granting of roles & privileges, performance tuning, backups&tuning of SQL statements.
• Experience in creating SSIS packages,managing and automating control flow, data flow, events and logging programmatically using Confidential .NET framework for SSIS packages.
• Implementation and administration of Hadoop infrastructure; Install Linux operating system and Hadoop updates, patches, version upgrades.
• Guidance on hardware architectural, planning and estimating cluster capacity, and creating roadmaps for Hadoop cluster deployment.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SQL Server DBA

Responsibilities:

• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Performed typical maintenance (re-indexing, backups, manage recovery protocol), monitor and manage space usage, master-slave replication and processing speed. Resolve any data corruption, recommend optimizations.
• Proactively identify and resolve any performance issues.
• Monitor usage, recommended dropping any tables/indexes or making schema optimizations, promote best practices.
• Review or implement schema design, recommend technical solutions and set up platforms for new systems.
• Recommended SQL query optimisations and advise developers on the quality of their queries.
• Prototype and implement new database features, including Stored Procedures, indexes, schema changes, etc.

Confidential

Senior SQL Server DBA

Responsibilities:

• Provided 24x7 troubleshooting of 2 business critical MSSQL DBs and a number of internal ones.
• Responsible for availability, performance and scalability to support the tremendous growth of various services provided by the team.
• Performed typical maintenance (re-indexing, backups, manage recovery protocol), monitor and manage space usage, master-slave replication and processing speed. Resolve any data corruption, recommend optimizations.
• Proactively identify and resolve any performance issues.
• Monitor usage, recommended dropping any tables/indexes or making schema optimizations, promote best practices.
• Review or implement schema design, recommend technical solutions and set up platforms for new systems.
• Recommend SQL query optimisations and advise developers on the quality of their queries.
• Prototype and implement new database features, including Stored Procedures, indexes, schema changes, etc.
• SQL Server Upgrade from SQL Server 2005 to SQL Server 2012.
• Auditing Confidential settings of the MSSQL Servers and taking corrective action.

Confidential

Senior SQL Server DBA

Responsibilities:

• Providing 24x7 troubleshooting and tier-2 support for Confidential SQL Server version 2000, 2005, 2008 R2 & 2012
• Implementing Windows & SQL Server Failover Clustering and SQL Server 2012 AlwaysOn Availability Groups backup & recovery plans
• Designing & executing plan to migrate 200 production databases and 1.5 TB of data to a new secure data centres, including auto-generating all T-SQL and Robocopy scripts in advance
• Troubleshooting problems by using SQL Server Profiler, SQL Server Performance Dashboard Reports, Activity Monitor, PAL Tool and Perfmon
• Resolving critical production problems and performing point-in-time database recoveries
• Administering complex enterprise-wide SQL Server 2005, 2008 R2 and 2012 instances
• Applying SQL service packs to the current patch level and cumulative updates to address specific issues
• Managing topology and capacity planning including number of Windows, SQL server cluster nodes, SQL server instances, CPU, RAM speed & quantity and SAN disk configuration
• Upgrading DTS packages to SSIS and developing new SSIS packages for ETL
• Developing & implementing a process to auto-generate all database recovery T-SQL scripts and saving those commands with backup files and making recovery easily available

Maintaining:

• SQL server documentation including DBA manuals for most every server including design, installation and configuration, as well as detailed work logs
• Index optimization, consistency checks and data file; monitoring transaction log size using built-in tools, custom written T-SQL scripts, SQL agent jobs & database mail and enterprise monitoring using SCOM & Precise

Confidential

Senior SQL Server DBA

Responsibilities:

• Assisted over 50 instances of Confidential SQL Server 2000, 2005, 2008 and 2008 R2 across the enterprise
• Implemented SQL Server high availability solutions including failover clustering and log shipping in 32 bit & 64-bit Windows Server 2000, 2003, 2008 & 2008 R2 environments
• Ensured regular maintenance of index rebuilds, reorganization and statistics updates
• Monitored database & application performances, identified issues, troubleshoot & optimizedusing SCOM 2007, AVICODE, performance monitor, profiler, execution plans, database engine tuning advisor and performance dashboard reports
• Installed Windows Server on both physical & virtual machines in HyperV; looked after building of service accounts, configuration of networks and creation of firewall rules
• Coordinated with core infra teams, upstream (management & stakeholders) / downstream (users and partners) integrations teams on plethora of issues simultaneously while communicating
• Provided optimum work-around resolutions to application/data/configuration/environment related issues within SLA
• Worked on SQL Server (2000, 2005, 2008), Windows Enterprise Server (2003, 2008) and IIS (6&7)
• Assisted Tier-1 (Infra Monitoring Teams), Tier-2 (Application End User Support teams) and Tier-3 (Technical Escalation Team) for Confidential Incident Management Suite of Tools
• Handled entire production release process for LOB applications with more than 15 releases for 10 applications with zero escalations
• Oversaw engineering teams for various integration applications and took PMs from IT & Business Teams on prioritization of critical business impacting issues
• Analysed the trends/symptoms and worked on capacity & performance issues apart from collaborating/engaging with engineering teams, PSS teams and Confidential teams for issues beyond the support scope