TECHNICAL SUMMARY

• 10 years of experience in IT Services and Operations with expertise in SQL Database Administration in a global 24x7 OLTP environment.
• Supported over 160 database servers of low to high complexity in Production, UAT, Test and Dev environments. Maintained 7 TB of database.
• Experienced in Installation, Configuration, Maintenance and Administration of SQL Server 2012,2008R2/2008/2005/2000/7.0 in standalone and clustered environments. Configured more than 2GB RAM for 32-bit and 64-bit systems using AWE switches.
• Experienced in migration of SQL Server from version 2000 to 2005/2008/2008R2/2012.And documented the Upgrade process. Handful of Experience on SQL server new features like Microsoft SQL multi server administration, resource governor, performance data collector.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008/2008R2/2012 on VMware Environment. Experience in Migrating DTS 2000 packages to SSIS packages in 2005/2008R2/2012 using Migration Wizard. Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication Snapshot and Transactional with updatable subscriptions , Log shipping, Clustering Active-Active and Active Passive and Database Mirroring.
• Worked with Tivoli Data Protection TDP and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008R2/2012.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations , ETL Process Data Extraction, Transformation layer with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services SSAS , Reporting Services SSRS , Notification Services SSNS and MDX ad-hoc Reporting.
• Expertise on physical storage SAN configuration on different RAID levels.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Hands on experience with administering large databases, managed databases of size above 3 terabytes, database design, normalization and database application development using varied development tools.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in trouble shooting sql server jobs, and job monitoring tool.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Expertise in using DBCC trace flags, handling blocking and dead lock situations.
• Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Explicitly used third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager TSM .
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Checking the threshold values and baselines and monitoring in perfmon and SCOM.
• Rebuilding indexes with different fill factors and updating statistics.
• 24 X 7 Production Database on Call Support.
• Experience in Database Security and Management
• Experience in Security Patches Hot fixes installation and management schedule-coordinate-install
• Experienced in performing various SQL Server 2000 2005, 2008R2,2012 High Availability activities like Installation, Configuring and Maintaining SQL Clustered Servers Active/Active Active/Passive , Network load balanced servers, working with transactional Replication, Log Shipping and Database Mirroring.
• Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics.
• Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, SSRS, DTS, BCP, BULK INSERT etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Good hands on experience on Resolving database performance issues and monitoring the growth of the database to ensure the smooth running of daily activities.
• Worked extensively on monitoring the databases, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases in response to the Tivoli Alerting System.
• Experience in strong SQL debugging skills, application level troubleshooting skills, experience with monitoring tools and techniques, good understanding of security practices.
• Experience in successfully resolving SQL Server problems in conformance with in SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, backup/restore, database corruption, security etc
• Experience in using tools like SQL Profiler and Performance counters for Monitoring, Fog light, Performance Analyzer and Tuning MS SQL Server Performance.
• Experience in working with Windows Server 2000/2003/2008.
• Experienced in creating/maintaining automation Scripts with SQL.
• Hands on experience in trouble shooting deadlock issues, resolving performance issues, data archival on every three months, rebuilding indexes.
• Self-motivated person with strong analytical, problem solving and communication skills. Capable of working under pressure and a good team player who can be flexible and work individually.
• Experienced in ITIL process Change Management, Release Management, Problem Management, and Incident Management and IT Infrastructure, Networking, and RAID environment.
• Experienced in query optimization, DMV's, Maintenance Plans, Upgrades
• Experienced in database designing, Normalization, VB.NET,C ,ASP.NET
• Assisted and supported customers, developers,QA's in database related issues
• Experienced scheduling all the alerts in database server using
• MOM,Tivoli,Maximo,Control-M,SQL default alerting system
• Experienced in writing SQLqueries,stored procedures, functions, triggers
• Upgrading to SQL Server 2008R2/2012 Resources for SQL Upgrade with Consolidation /Virtualization experience
• Experienced with SOX/PCI compliance
• Experienced SQL Server Standards and Hardening

TECHNICAL SKILLS

Databases: MS SQL Server 2012,2008R2/2008/2005/2000/7.0, Oracle, MYSQL, Sybase

Languages: T-SQL, C, C , C , vb.net, JAVA, ASP.NET, Visual studio2005/2003

Technologies: VB.NET, .NET FRAMEWORK, ASP.NET, C , Microsoft Office Suite, Share Point.

Tools: Active X, IIS, MTS, Litespeed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0,SSIS,SSRS,SSAS,SCOM,Tivoli TSM,SCOM

Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008R2, Windows

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA Architect

Responsibilities:

• Working with 35 critical database servers. And 1200 databases in Boston and Montreal, China.
• Our largest database size is 650GB. Our overall average database size is 40GB.
• In our environment 12000 transactions per second going on during business hours.
• Provides support for the further evolution of the data architecture for new and existing data warehouses.
• Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures
• Manages the SQL server transactional database that collects data from our network of users
• Ensure the systems are functioning optimally and that users are able to upload
• Manage all technical aspects of the databases and processes
• Assist in maintaining and improving database operational efficiency
• Perform daily, weekly, and monthly data maintenance tasks
• Assist in client support and setup configurations
• Participates in defining data requirements and designs of databases
• Participates in design reviews and assists with platform selection and allocation of functionality to specific system components
• Participates in developing security and monitoring for data architecture
• Participates in developing reporting and data analysis architecture
• Participates in data migration and integration activities
• Assist in developing data models, implementing databases, and conducts database operations such as writing stored procedures and triggers
• Analyzes content and quality of databases, recommend data management procedures and develops extraction processes
• Works on project teams to develop target logical and physical data models
• Participates in development, testing and optimization of database applications
• Assist other associates at Online technology in the technical understanding and abilities of database architecture
• Works closely with project teams, vendors and other groups to coordinate plans and activities
• Recognizes and identifies potential areas where existing policies and procedures require change
• Provides guidance and assesses requirements for additional services and promotes use of IT services, where appropriate
• Makes recommendations regarding scope, timeline or budget changes/improvements
• Involved in multiple projects simultaneously, potentially across multiple business units

Confidential

Sr. SQL Server DBA LEAD

Responsibilities:

• Worked with 100 critical database servers. And 900 databases in RW SSB and NA ODC .
• Our largest database size is 800GB.Our overall average database size is 50GB.
• In our environment 18000 transactions per second going on during business hours.
• Supporting the ETL based Titanium application in the production environment
• Troubleshoot MS SQL Server related issues in PROD
• Plan and support the version upgrade activities
• Manage day-to-day activities of the Database Production team
• Designs and maintains database structures and coordinates or performs installation, configuration and
• troubleshooting of SQL 2008 R2, SQL 2008, 2005 and 2000 servers.
• Implement SQL Server high availability/DR solutions like Clustering, Database mirroring, Log Shipping and
• Replication
• Supporting SQL server reporting service SSRS , SQL Server Analysis Service SSAS and SQL Server Integration Service SSIS
• Member of DBA team which provides 24x7 supports of over 100 production database servers.
• Developing T-SQL scripts/PowerShell scripts/SSRS reports for database maintenance purpose
• Deploying and troubleshooting SSIS/DTS packages with a multitude of Data sources and complex data conversion logics
• Manage backup/recovery strategy for all production database servers
• Proactively monitor and profile production database servers for load and performance bottlenecks and provide solutions for query optimization and performance tuning
• Provide recommendations for new server design, storage requirement and database design
• Advance knowledge of all facets of SQL 2008 R2, SQL 2008, SQL 2005 and SQL 2000
• Expert knowledge in SQL failover clustering and SSRS installation, configuration and maintenance
• Worked with TSQL and have experience in automating tasks through complex scripts
• Good understanding of SSIS packages design, development and implementation
• Knowledge in data warehouse, SSAS and other ETL processes
• Knowledge in SQL Server 2012,2014
• DBA support, MS SQL Server, ETL scripts, Titanium, Credit Card Banking
• DBA support and version upgrade of MS SQL Server.
• Worked environment which MS SQL Server is being used to host ETL scripts of the given application.
• Demonstrated a mature and experienced approach to troubleshooting.
• Supporting the ETL based Titanium application in the production environment
• Troubleshoot MS SQL Server related issues in PROD,DR,PA,DEV
• Plan and support the version upgrade activities
• Exposure to supporting ETL based applications.
• Exposure to the Credit Card Banking Domain.

Environment: SQL Server 2008R2,2K8 2005, Apache Web Server 2.2.11, Jboss Application Server 5.1.0 GA, Java JDK 6,,SAN,Windows 2008 server, RHEL 5.5 server, Linux, Teradata, Pervasive, clustering, Replication SQL Sentry, Nagios, Lite speed, Net backup, EMC Networker Legato , VB.NET, C , ASP.NET,TFS,Visual Studio

Confidential

Sr. SQL SERVER DBA

Responsibilities:

• Worked with 178 critical database, application, web servers. And 1492 databases in SLC and JAX.
• Our largest database size is 2TB.Our overall average database size is 60GB.
• In our environment 12000 transactions per second going on during business hours.
• Worked in Active passive cluster environment.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• SQL Server 2012, 2K8 R2, 2K8 2005 Database Administration.
• To handle the migration of SQL Server 2000 to SQL Server 2012, 2008 2K8 R2.
• Responsible to Monitor and troubleshooting Log Shipping.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Used Data Partitioning, Snapshot Isolation.
• Update statistics, database integrity check and Backup operations
• Expertise in SQL server Reporting Services SSRS ,VB.NET,C ,ASP.NET
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Expertise in creating and supporting in OLAP Cubes
• Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
• Daily tasks of Developer/DBA like space issues on Production and Semi-Production Servers and handling maintenance Jobs handling and user's permissions, SCOM.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Performed Performance Tuning of the Stored Procedures.
• Experience in trouble shooting database issues.
• Monitoring SQL server performance using profiler to find the performance and deadlocks.
• Experience in using ERWIN tool for designing the reporting databases.
• Performance Monitoring using SQL Profiler and Windows System Monitor.
• Backup Restore Plans.
• Creating and Maintaining Database Maintenance Plans.
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM.
• SQL Server installation, configurations, backup/restore handled large databases Monitoring SQL Server agent jobs and troubleshooting the Trouble tickets
• Space optimization Working knowledge of SQL Server advanced technologies e.g. Replication, Log Shipping
• Configuring perfmon, blocking analysis, Enabling of AWE and PAE, Maxdegree Parallelism.
• Installation of SQLSERVER 2005, service packs, hot fixes, Security patches, Lite speed.
• Practical experience in managing the internal and external MS SQL database security
• Install SQL Server instance and database including Service Pack , Upgrade SQL Server Service Pack

Environment: SQL Server 2012, 2K8R2, 2K8 2005, 2000 with clustering, Replication SQL Sentry, Nagios, Lite speed, Net backup, VB.NET, C , ASP.NET,TFS,Visual Studio

Confidential

Sr. SQL SERVER DBA

Responsibilities:

• Managed 190 critical database, application, web servers. And 2000 databases around the globe. Our largest database size is 7TB.Our overall average database size is 50GB.In our environment 21000 transactions per second going on during business hours.
• Strong experience in working on Very Large Databases VLDB over 80 GB for OLTP and 2TB for OLAP databases.
• Configured more than 2 GB ram on 32 bit Environment.
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Worked in Active passive cluster environment.
• Performed data partitioning for efficient management of database tables and indexes.
• Developed Backup strategies for Database Recovery.
• Export or Import data from other data sources like flat files using Import/Export through DTS. Experience in applying Service Packs at database and OS Level.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
• Experience in using ERWIN tool for Entity Relationship diagrams.
• Did Performance Tuning of the Stored Procedures.
• Performing Database maintenance activities like Backups, Restoring.
• Creating DTS packages and Maintenance plans and jobs for automation of the repetitive task.
• As a part of the DBA team providing 24/7 production support to the clients
• Monitoring the Scheduled jobs
• Monitoring the Disk spaces on all the servers
• Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• SQL Server 2012, 2K8 R2, 2K8 2005 Database Administration.
• To handle the migration of SQL Server 2000 to SQL Server 2012, 2008 2K8 R2.
• Responsible to Monitor and troubleshooting Log Shipping.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Used Data Partitioning, Snapshot Isolation.
• Update statistics, database integrity check and Backup operations
• Expertise in SQL server Reporting Services SSRS ,VB.NET,C ,ASP.NET
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Expertise in creating and supporting in OLAP Cubes
• Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
• Daily tasks of Developer/DBA like space issues on Production and Semi-Production Servers and handling maintenance Jobs handling and user's permissions, SCOM.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Performed Performance Tuning of the Stored Procedures.
• Experience in trouble shooting database issues.

Environment: SQL Server 2012, 2K8R2, 2K8 2005 with clustering, Replication DBM, SCOM, VB.NET, C , ASP.NET