Sql Server Data

Location:

Edison, NJ

Posted:

September 29, 2016

Contact this candidate

Resume:

**************@*****.***

Mob: 908-***-****

SUMMARY:

Over 9+ Years of total IT experience including SQL Server Database Administration for very large and complex databases in SQL Server 2000/2005/2008/2008 R2/2012/2014.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Experience in working with enterprise environment supporting all aspects of a sql server Database Server with emphasis on 2-tiered and 3-tiered architecture.

Good expertise in handling vulnerability remediation activities.

Implemented "Always On Availability groups" in SQL 2012 on multi-subnet/Geo Cluster environment.

Expertise in SQL Server Cluster Implementation (Active-Active / Active-Passive) and troubleshooting the failure.

Handled multiple SQL Instances on Cluster environment for projects built on SAN using RAID levels.

Configured VMware Infrastructure higher levels of availability for SQL Server. VMware Distributed Resource Scheduler (DRS), VMware High Availability (HA), and the VMware Site Recovery Manager.

Having hands on experience working with HA/DR SAN Production environment - Always-on, Clustering, Mirroring, Log Shipping, & all types of Replication techniques(Snapshot, Merge and Transactional).

Worked extensively on Clustering and server consolidation, Troubleshooting production issues and raising high availability.

Experience on disaster recovery planning and implementing Security Management operations.

Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).

Familiar with Virtualization technology and running Windows inside a Virtual Machine.

Involved in ITIL Service Support areas of Incident, Problem, Change, Release, Configuration Management and Service Desk.

Experience in Data Modeling (Logical and Physical Design of Databases), Normalization of Databases and building Referential Integrity Constraints.

Analyzing and meeting SLAs as per the severity.

Proficiency and expertise in migrating Database from SQL Server 2012/2008/2005 under various process like Backup/Restore; Detach/Attach, import/export etc.

Experience to recover data in case of disaster of server.

Creating and managing of multiple Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g with all required accessibility for Data pull through SQL Jobs.

Worked on fine-tuning databases, created Clustered and Non-Clustered Indexes for tables, identified Fragmentation.

Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas. Working in both MOLAP and HOLAP environments.

Creating and configuring Databases based on the clients specifications

Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.

Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).

Experience and proven understanding of managing database audit events and audit records. Expertise in creating, implementing and monitoring Maintenance Plans/SQL Jobs, job scheduling.

Expertise with the role of Transaction logs and action accordingly Log Space Maintenance and Temp database space issues.

Hands on experience in using Performance Monitor/Profiler and also good experience in data (table) partitioning.

Highly skilled in implementing SME Standards for database issues.

Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc depends on scenarios.

Expertise in Migrating SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008 and also expert in migrating DTS packages to SSIS Packages.

Experience in using the DMVS, DMFS, INFORMATION_SCHEMA, SYSTEM VIEW Sand in-built Global variables for the instant analysis.

Worked with DTS packages to load the massaged data into Data warehousing system.

Administering Database security by creation of SQL logins/users and granting of roles. Implemented Rev Login scripts while creating logins.

Implemented Secure SQL environment using SOX compliance standards.

Applying the Patches on the Instances based on both Operating System (OS) and SQL Server on the analyst’s requirement

Performance Tuning like identifying long running queries; Open Transactions; Blockings; Deadlocks, Trace Flags etc.

Handful experience in Installs, deployments, certificate renewals, service accounts resets, process job tickets & bugs, test verify backups and recovery.

Expert in Data Integrity and Query Optimization and tuning complex queries.

Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Functions, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Involved in Huge data migrations and Data center migration, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations, CDC (Change Data Capture).

Experience in ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.

Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Experience in deploying created reports in various sources like Web browser, XML and PDF

Performing Online/Offline database DR Drills as per the customer requirements.

Regular monitoring and workaround on Disk Management and Database File growths and take appropriate action.

Experience in using tools like spotlight, TSM, light speed,SQL Sentry,Commvault.

Strong communication, presentation and interpersonal skills and good experience in handling Team as well as end users.

Certifications:

70-462::Administering Microsoft SQL Server 2012\2014 Databases.

EDUCATION:

Master of Computer Science, SMIT, INDIA.

Awards

“WOW” award received for best DBA service support provider from the KPIT Cummins Info System.

TECHNICAL SKILLS:

Operating System:

Windows 2000/2005/2008 Server, Windows 95/98/XP/NT.

Databases:

MS SQL Server 2014,2012,2008 R2,2008, 2005,2000, Oracle 8i,9i.

SQL Server Tools

Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Log Shipping, SSIS, SSRS, SSAS, Microsoft Clustering Services (MSCS), PowerShell

Programming:

T-SQL,PL-SQL,HTML,CSS,C

DBA:

Database administration of MS SQL Server 2014, 2102, 2008 R2,2008, 2005,2000

Data Migration

SSIS, BCP, Data Migration, Import/Export Wizard

Backup Utility

Quest Lite speed, Commvault, Redgate,Tivoli, Idera

Build Tools &

Analytical Tools

FreeNAS, Relativity, Equivio Zoom Virtual Box, MS Project and Visio

Professional Experience:

PricewaterhouseCoopers,

300 Madison, NY Mar 2016 to till date

Sr Sql Dba

PricewaterhouseCoopers (trading as PwC) is a multinational professional services network. It is the world's second largest professional services network, as measured by 2014 revenues, and is one of the Big Four auditors,along with Deloitte, EY and KPMG.Portfolio management is much more than simply managing multiple projects. It is the management of the entire project portfolio in a way that maximizes the impact of projects to the overall success of the organization.

Responsibilities:

Experience in installing, managing and troubleshooting SQL Server 2014, 2012, 2008R2, 2008.

Configured ALWAYS ON setup between different Datacenters and on Multi Subnet Cluster.

Installed and Worked on SQL Server 2012 failover clustering which is built on top of a Windows 2012 server cluster.

Strong experience in monitoring and tuning sql server databases for optimum performance and assistance in capacity planning of sql server database servers.

Configuring and Managing Log Shipping and Database Mirroring.

Configured different types of replication like Snapshot Replication, Transact replication from Multiple publishers to one subscriber and one subscriber to multiple publishers.

Responsible for Performance and tuning of SQL servers and application issues related to migration.

Checking the SQL Error logs for any errors that may have occurred overnight.

Checking available physical Disk space, Log Space, jobs for failed completion, backups and log sizes, Monitoring performance with PERFMON COUNTERS.

Implemented DMV and dynamic management functions for finding out long running queries.

Designed various approaches like CDC (Change data capture), Auditing control Recovery strategy, Scheduling jobs etc.

Extensively worked on DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters

Checking for outstanding active or blocked transactions. (stored procedure)

Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements.

Migrated SQL server 2008 R2 to SQL Server 2012 and SQL SERVER 2012 to 2014.

Worked with filestream by storing varbinary(max) binary large object (BLOB) data as files on the file system. Worked with filestream filegroups.

Experienced with end to end Automation using Powershell for User Account/ Mailboxes/ Distribution Group/ Security Group provisioning and management.

Implemented encryption of sensitive data in the databases using Data encryption Standards like TRANSPARENT DATA ENCRYPTION(TDE).

Installed patching and administered 2-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.

Extensively worked on SQL Server Integration Services (SSIS)

Rebuilding/Reorganizing the indexes at regular intervals for better performance.

Experience in using SQL Server Profiler, SQL Server Agent.

Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used execution Plan, DBCC Commands, Profilers and WAIT TYPES.

Responsible for monitoring and making recommendations for performance improvement in hosted databases.

Implemented ITIL frameworks to manage level of complexity.

Implemented security considerations for SQL Server during installation, logins,

configurations, while encrypting.

Periodically checking the health of the server and providing recommendations.

Performance tuning and monitoring of databases, data archiving and purging, troubleshooting and management of production databases and disk space management.

Export or Import data from other data sources like flat files using Import/Export through SSIS.

Analyzing long running slow queries and tunes the same to optimize application and system performance.

Set up SQL Server configuration settings for better server management.

Upgrading of SQL server software 2005/2008/2008 R2.

Designing and creating backups & recovery strategy and meet RPO/RTO objectives.

Working with customers on Application rollouts and server migrations.

Perform SQL Server service pack and Windows Service pack upgrades.

Designed and implemented comprehensive Backup plan using Commvault & Lite Speed.

Resolved and tweaked memory pressures caused during product release.

Environment:MS SQL Server 2000/2005/2008/2012/2014, Windows 2003/2008, SSIS, SSAS, PL/SQL, MS Access, LiteSpeed, commvault, Idera, TSM/TDP

MANPOWER GROUP,

99park Avenue,NY Jan 2012 – Feb 2016

Role: Sr Sql Dba

Manpower Group (NYSE: MAN), the world leader in innovative workforce solutions, creates and delivers high-impact solutions that enable our clients to achieve their business goals and enhance their competitiveness. The Manpower Group suite of solutions is offered through Manpower Group Solutions, Experis, Manpower, and Right Management.

Responsibilities:

●Responsible for 24 hour support to manage and maintain database server to ensure that all server available and up and running.

●Responsible for Database support, SQL Server Installation, troubleshooting, planning and migration.

●Performed installation and update of latest SQL Server Service Packs.

●Upgraded databases from SQL Server 2005 to SQL Server 2008 R2.

●Designed and implemented comprehensive Backup plan using SQL Lite Speed

●Ensure optimal performance, reliability, security and optimizing of database server.

●Implemented microsoft tools such as Microsoft security baseline analyzer for SOX security analysis.

●Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

●Used advanced SQL query, store procedure, function, indexes, trigger and cursor to design and development of database Server.

●Troubleshoot locking, blocking, deadlocks, high resource in long running queries.

●Worked with the FILESTREAM filegroups on shared disk resources, When implementing failover clustering.

●Setup Database Maintenance Plans to reorganize indexes, rebuild index and update the index statistics on the production databases.

●Performed database maintenance and performance tuning for the database server.

●Used SQL Server Profiler to monitor and record database activities of certain database objects. Involved in capacity planning, sizing and database growth projections.

●Extensively worked with powershell automation.

●Used System monitor and Dynamic management view to find the bottlenecks in CPU, Disk I/O and memory to improve the database and application performance.

●Performed DBCC and DMV commands to troubleshoot issues related to database performance consistency.

●Create and implemented language conversion to support multi languages like English, US-English, French, Spanish, German etc.

●Created monitoring scripts to error alert for database issues.

●Fine-tuned Stored Procedures using Execution Plan for better performance.

●Implement and maintain database audit and server security.

●Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

●Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

●Create and maintain offline cube using SSIS and SSAS tool of SQL Server.

●Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.

●Implement and manage SQL Azure database for cloud server.

Well point, US

KPIT Cummins Infosystems Aug 2010 – Dec 2011

Role: Sql Dba/Developer

Health care is changing and WellPoint is leading the way to help improve the system, make health care easier for consumers to access and use, and improve the health of the people we serve. Our affiliated health plans and companies are empowering consumers and driving innovation to control costs and improve the quality of care everyone receives.

Responsibilities:

●Installed and maintained MS SQL Server 2005/2000 on Windows 2003 Server.

●Monitoring database performance using SQL Profiler and the DB’s percent log space for all database servers using SCOM and Windows Performance Monitor counters.

●Maintained the Active-Passive Clustering as a disaster recovery solution

●Implemented different types of Replication Models like Snapshot and Transactional Managed the use of disk space, memory and connections.

●Performed DBCC utilities and fixed data corruption in application databases.

●Configured and maintained database mirroring for high availability.

●Using log shipping for synchronization of database.

●Monitored Databases for lock escalation, DeadLock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries using SQL Profiler.

●Traced long running queries and deadlocks using SQL Profiler

●Created and managed schema objects such as tables, views, indexes, procedures, and triggers maintained Referential Integrity.

●Analyzed designed, developed, implemented and maintained the instances of databases. Worked on monitoring and tuning the SQL scripts

ICICI,

KPIT Cummins, Bangalore May 2009 to Jul 2010

Role: Sql Dba

ICICI is one of the top credit card issuers in India. The company offers Visa and Master Cards with a variety of annual percentage rates, credit limits, finance charges, and fees. Project was to gather requirements from Business users and designed, developed and maintained the tool for making decisions depending on different scenarios.

Responsibilities:

●Maintaining of over 1200 standalone/Cluster servers.

●SQL Server 2000,2005,2008 installations, configuration and security settings for standalone servers.

●Monitoring database performance using SQL Profiler and the DB’s percent log space for all database servers using SCOM and Windows Performance Monitor counters.

●Maintained the Active-Passive Clustering as a disaster recovery solution

●Having experience on file moment activities on standalone servers.

●Develop and implement database administration/ maintenance plans.

●Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication, Clustering.

●Performed DBCC utilities and fixed data corruption in application databases.

●Traced long running queries and deadlocks using SQL Profiler

●Created and managed schema objects such as tables, views, indexes, procedures, and triggers maintained Referential Integrity.

●Analyzed designed, developed, implemented and maintained the instances of databases. Worked on monitoring and tuning the SQL scripts

Essar Oil and Petroleum/ KPIT Cummins Jan2008 – April2009

SQL DBA

Essar Oil is an India-based company engaged in the exploration and production of oil and natural gas, refining of crude oil, and marketing of petroleum products. It is a part of the Essar Group based in Mumbai. It operates a major refinery in Vadinar, Gujarat, India, which made it the second largest non-state refiner in India in 2009.