SUMMARY:

• SQL DBA with 7+ years of experience in different domains like Finance, Compliance, Insurance, Brokerage, Engineering, Data accumulation, Content Management, Process Engineering, Analytics, Change management and Service requests.
• Installation, configuration and administration of SQL Server 2000 and 2005/2008,2008r2 and 2012.
• Capacity planning, ensuring high availability and Disaster recovery solutions through configuring/maintaining log - shipping, Windows/SQL Clustering (Active-Active and Active-Passive), DB Mirroring and replication;
• Well versed in Performance tuning, handling blocking, Dead lock and Long running query situations, developing stored procedures, Triggers and writing scripts.
• Encourage a scientific and data driven approach to identify improvement opportunities. Working and coordinating with other teams and solving performance issues with them.
• Database migrations and upgrades from SQL server 2000, 2005 to SQL server 2008/2008r2 and 2012.
• Scaling SQL Server, Managing Messages, Setting Trace Flags / Jobs Notifications.
• Development and maintenance of the database persistence layer (stored procedures, views, functions).
• Plan and Implement database backup and recovery strategies.
• Worked on implementing Horizontal and Vertical partitioning for VLDB’s upto 1.5TB.
• Well-versed in authorizing, deploying and delivering MS SQL Server 2005/2008/2008 r2 suite of products like SSRS and SSIS with Report Generation and Preparation of weekly & monthly dashboards.
• Well experienced on BCP, DTS packages, Jobs and linked servers for MS SQL Server/Oracle
• Handled up to 2TB size database with clustered and replication environments.
• Experience in supporting huge databases, troubleshooting the problems and documenting Root cause analysis.
• Effectively maintained positive and productive working relationships in internal/external and team environments.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Leading the technical team, involved in resolving day-to-day production server issues.
• Monitor and ensure resolution as per the agreed SLA with customer.
• Problem solving, defining and analyzing problems, identifying alternative solutions, recommending a solution.

TECHNICAL SKILLS:

Languages: T-SQL, P/L SQL.

Operating System: Windows 2000/2003/2008/2008 r2 server and Windows 98 and XP Professional.

Databases: SQL Server 2000, 2005, 2008 R2,2012 and Oracle 10g.

Web Development: Overview of HTML and XML

Tools: HP Quality Center (QC) 10.0, Perforce, Remedy 7.5/7.6, Infoman, Peregrine, CME (Change management Expert), Veritas Netbackup, Foglight, SQL Litespeed, Idera, SSRS, SSIS, SSAS.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Proven ability and expertise in performing Analysis, Data Mining, Configuration, Implementation and Maintainence of MS SQL Servers 2012, 2008 R2, 2008 and 2005 in OLTP Environments.
• Expertise in installation, upgradation and configuration of Stand-alone SQL Server 2005, 2008, 2008R2 and 2012 versions and maintained Microsoft best practices in applying Service Packs and Hot Fixes on regular basis.
• Worked with building, Installing, Configuring and Maintaining MS SQL Server 2005\2008R2\2012 Active-Active and Active-Passive two node failover Clusters.
• As a high availability option, incorporated Database Mirroring in a highly Transitive SQL Server 2005 fail-over cluster instance having a 600GB very large database (VLDB); thus enhancing recoverability at Database and SQL Instance levels.
• Performed data processing by Extracting, Transforming and Loading Data (ETL) from various data sources like access, excel, flat file, Oracle and MYSQL database objects using SQL Server, ODBC, OLEDB and SQL Server Native client 10.0 connections by using Linked server and creating various TSQL\Maintenance plan jobs & SSIS Packages.
• Sufficient time spent in conducting periodic database health and performance checks. Regularly create missing indexes, update statistics, rebuild\reorganize indexes; schedule T-SQL scripts on all production servers to monitor failed jobs and disk free space issues to avoid unnecessary breakdowns.
• Used third party tool like Quest Litespeed, Veritas Netbackup, Foglight for backups & restoration and monitor and set performance thresholds.
• Authorizing, deploying and delivering reports using MS SQL Server 2005/2008/2008 r2 SSRS Report Generation and Preparation of weekly & monthly dashboards.
• Administered the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, granting the privileges to users and groups.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Effectively maintained enthusiastic and productive working relationships with Management, Application teams & End clients to achieve database solutions. Collaborated with different teams by assigning regular team meetings to resolve CA Service desk incident tickets and Business problems.
• Providing documentation and Sop’s on Installation, Configuration and Maintenance standards for MS SQL 2005\2008\2008R2 and 2012 versions as part of Marsh & McLennan Global Technology Infrastructure (MGTI) best practices

Confidential, Denver, CO

SQL DBA.

Responsibilities:

• Provide 24X7 support of enterprise level production databases maintaining the security, integrity and stability of the databases. Primary responsibilities include analyzing the SQL Server 2000, 2005 & 2008 based Databases for optimization.
• Implement and maintain HA and DR solutions for both Clustered (Active-Active and Active-Passive) and non-clustered environments, maintain replication and Mirroring between servers, used SAN replication and Logshipping as a DR.
• Worked with Network, Backup and storage and application teams in upgrading SQL server clustered environment from 32 bit to 64 bit.
• Migrated Databases from and from .
• 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.
• 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.
• Setting up indexing strategies, writing T-SQL scripts, doing backup and recovery, administering the several Windows based systems in the production environment.
• MaintainDBAstandard policies in implementing service packs, patches or any change dat may impact environment. Changes are thoroughly tested and documented before being implemented in production.
• Assisted end users on several occasions to troubleshoot the performance related to newly developed SSIS packages, stored procedures, user defined functions, triggers, views using T-SQL as per business logic.
• Involved in various issues encountered while converting existing DTS Packages to SSIS Packages.
• Deployed the SSIS packages to MSDB database and file system using the wizard utility.
• Installed SQL Server 2005 and on windows 2003/2008 servers, applied service packs.

Confidential

Production Support DBA.

Responsibilities:

• Build new SQL servers for the migration to 2005 and 2008.
• Installed MS SQL SERVER 2005/2008, Service pack and hot fixes on active/active cluster nodes.
• Handled up to 2TB size database with clustered and replication environment.
• Responsible for implementing and Monitoring Transactional Replication.
• Migrated SQL Server 2000 to SQL Server2008 Using Side-by-Side Up gradation.
• Used Erwin for physical and logical data modeling.
• Tested Database Encryption and Back up Compression Features in SQL Server 2008.
• Installed SQL Server service packs based on the errors and flaws dat are found in the Application.
• Touch works application was implemented in Active Passive 2 node clustered environment.
• Configured and maintained database mirroring as a high availability solution.
• Maintained log shipping for disaster recovery.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore using Litespeed.
• Rebuild Indexes, creating jobs and alerts for the automated environment on various tables.
• Configured Log shipping for the disaster recovery plan in sql server2005.
• Suggested proper SAN and RAID for the particular servers during the Server build
• Performed T-SQL commands to troubleshoot the performance related issues
• Involved in Migration of SQL server2k to 2k5 and 2k8 & also on new hardware.

Confidential

SQL DBA/Developer.

Responsibilities:

• Complete administration of MS SQL 2000/2005 servers.
• Installation and configuration of MS SQL Server on Windows 2000/2003 Servers.
• Migration of databases from MS SQL 2000 to MS SQL 2005.
• Logical and Physical design of database for projects on basis of user requirement.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Implemented and maintained database security.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Worked on Active/Active and Active-Passive Clustering.
• Used Query Analyzer to optimize SQL Queries.
• Monitor the size of the transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology and SAN.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Handled corrupt databases diagnosed and repaired them and was involved to transfer the OLTP data to Data Warehouse

Confidential, Chicago, IL

SQL Developer/Jr.DBA.

Responsibilities:

• Installation and configuration of SQL Server 2000/2005 on windows 2003 and maintenance of Servers in Production, QA and Development Environment.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions
• Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Handled 2-node Clustering as a high Availability Solution.
• Used third party tool like Quest litespeed for taking backups and restoring them.
• Created Jobs to Automate & Schedule database administrative tasks.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non production database code as well as T-SQL code from developers.

Confidential

Jr. DBA

Responsibilities:

• Installation and Configuration of SQL Server 2000.
• Creating Stored Procedures, Triggers and Views as per requirement.
• Administering Login and User permissions.
• Extensively used Import/Export for data transit between local servers to clients remote server.
• Scheduled the jobs for backup/restore on production/development databases.