SUMMARY

• Over 8+ years of IT Experience in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server 2012/2008 R2 / 2008 / 2005 / 2000 in production, development and test Environments on various business domains like Financial, Insurance and Manufacturing.
• Expert in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008/2005/2000 on Clustered and Standby Environments.
• Experience in implementing and monitoring different types HA and DR scenarios like Replication, log shipping in Cluster Environment on Production, QA and Dev environments.
• Supported Very Large Database (VLDB) more TEMPthan 6TB and troubleshooting problems.
• Expertise in Database Backup and Recovery procedures by using Native, and LiteSpeed to/from Disk /Tape.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Created Stored Procedures, Functions and Triggers using T - SQL and also expert in tuning Complex Queries. Checks using DBCC Utilities and DMV's and DMF's, Re-indexing, Updating Statistics and online indexing.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Good in monitoring using SCOM Monitoring, Event Viewer, and SQL Error logs.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Experience inDTS MigrationandMetadata Management:Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Extensive experience on Business Intelligence Tools to create SSRS Reports, SSIS Packages and SSAS. Scheduled jobs to backup OLAP cubes.
• Performed data transformations between servers using BCP, DTS, SSIS and bulk insert. And also Expert in using DMV's, DMF's.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience wif logical and physical data modelling and database design using Erwin.
• Experience in Database administration activities forDB Security(creating logins, users, roles, and assigning permission to them).
• Design, document, and promote security "best practices", policies, standards and protocols.
• Knowledge on In Line memory of SQL server 2014.

TECHNICAL SKILLS

Languages: C, DDL, DML, T-SQL, J2EE

Tools: SQL DB Access, Performance Monitor, Backup Utility, TDP/TSM, LiteSpeed, RedGate, SSRS, VSS, CPS, Quest Spotlight.

Web Server Technologies: IIS 5.1/6.0

Data Modelling Tool: Visio 2003, Office Visio 2007

Operating System: Windows 2008, 2003, 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP.

PROFESSIONAL EXPERIENCE

Confidential, NJ

LEAD DBA

Responsibilities:

• Determine database structural requirements by analyzing client operations, applications, and programming; reviewing objectives wif clients; evaluating current systems.
• Configuring and Maintaining 2 node Active-Passive, Active-Active Cluster.
• Develop strategies for data acquisitions, archive recovery, and implementation of a database.
• Setting up replication (snapshot, transactional), log shipping and troubleshooting issues when encountered.
• Worked wif the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Developed SSIS package to automate daily debit and Credit transactions.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions
• Worked on DB performance issues.
• Created backup policy and archival jobs.
• Designed weekly job to De fragment the tables based on fragmentation.
• Implemented Always On feature.
• Provide 24*7 database support by coding utilities, responding to user questions, and resolving problems.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Confidential, Baltimore, MD

LEAD DBA

Responsibilities:

• Configuring and Maintaining 4 node cluster wif 8 SQL instances.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Planning of architecture and Upgrade of SQL Server 2005 to 2008 and 2008 R2.
• Applying Service packs and patches on the SQL servers.
• Worked on Active-Passive, Active-Active Cluster environment as a High availability solution.
• Created and maintained Database mirroring wif automatic failover, Replication, Metro Mirroring (SAN Mirroring) and Resilient infrastructure as a High availability
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Worked wif the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked wif Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008) and Worked wif SCOM Monitoring.
• Implemented Always On feature.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• DR DB Restore in which we restore all the production databases to a DR server to check whether the backups are fine or not.
• Creation and management of Database maintenance plan for various database consistency checks.
• Providing a case studies on new features and tools like quest spotlight, always on feature.
• Providing 24*7 supports for all database issues and activities.

Confidential, San Francisco, CA

SR SQL Developer / SQL Server DBA

Responsibilities:

• SQL Server 2005 & 2008 Database Administration.
• Performed the migration of SQL Server 2005 to SQL Server 2008.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 dat are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• Expertise in SQL Server Analysis Services.
• Hands on creating, Deploying and supporting in OLAP Cubes
• Managed VERITAS net backups and Litespeed backups.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency wif DBCC at regular intervals.
• Involved in creating and supporting in OLAP Cubes Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Confidential

SR SQL Developer / SQL Server DBA

Responsibilities:

• Setting Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability solution.
• Installed SQL 2008 on stand-alone machines
• Created Transactional & Snapshot Replication as a High availability.
• Used Policy Based Administration feature (SQL Server 2008).
• Created Table Valued Parameters (SQL Server 2008) of a table value data type and be able to pass dis variable into a stored procedure.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Used DTSXchange tool for migrating DTS packages to SSIS
• Performing Backup/Restore to/from Legato server (Tape) and Disk
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMV’S
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs wif Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Routine DBA jobs like Backups and Restores
• Good experience in data modeling and metadata services.

Confidential, London, UK

SQL Server DBA

Responsibilities:

• Installation, configuration of MS SQL Server 2000, 2005 for development and testing purpose.
• Migration of SQL server 2000 to SQL server 2005 and monitoring and solving the issues after migration.
• Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers.
• Created and monitored database maintenance plans for checking database integrity
• Creating databases, logins and Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Responsible for database backups & restoration and scheduling backup strategies.
• Implemented Disaster Recovery Plan using Log shipping, Mirroring and Replication.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Planning, implementing and troubleshooting Snapshot and Transaction Replication.
• Prepared Estimates for Database, table size growth.
• Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers.
• Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber).
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Monitoring the event logs and server error logs for troubleshooting.
• Performance tuning, finding the CPU Bottlenecks, SQL Server Bottlenecks.
• Performance tuning in Database level, T-SQL level and operating system level.
• Upgraded all the servers from 2000/2005. Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Responsible for SQL server Edition upgrades and SQL Server patch management.
• Supporting the business 24*7, maintaining 99.999 uptimes, depending on the application and business SLA requirements.
• Trouble shooting and supporting all user problems by using SQL server profiler and network traces, windows logs etc.