SUMMARY:

• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Explicitly used third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager TSM .
• Experience in Troubleshooting and documenting root cause analysis.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• 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.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Expertise on physical storage SAN configuration on different RAID levels.
• 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.
• Worked with Tivoli Data Protection TDP and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008R2/2012/2014.
• Experience configuring and working Microsoft SQL server 2008R2, Microsoft SQL Server 2008/2008R2/2012/2014 on VMware Environment. Experience in Migrating DTS 2000 packages to SSIS packages in 2005/2008R2/2012/2014 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.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures
• Experienced in migration of SQL Server from version 2000 to 2005/2008/2008R2/2012/2014.And documented the Upgrade process. Handful of Experience on SQL server new features like Microsoft SQL multi server administration, resource governor, performance data collector.
• Experienced in Installation, Configuration, Maintenance and Administration of SQL Server 2014,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.
• Supported over 160 database servers of low to high complexity in Production, UAT, Test and Dev environments. Maintained 7 TB of database.
• 10 years of experience in IT Services and Operations with expertise in SQL Database Administration in a global 24x7 OLTP environment.
• 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.
• 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, Foglight
• 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.
• 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, 2014 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, Foglight
• 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
• Installed, Configured, Worked with Foglight for SQLServer tool

TECHNICAL SKILLS

Databases: MS SQL Server 2014,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, SharePoint.
• 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, Foglight
• Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008R2,
• Windows 95/98/XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA / Architect

Responsibilities:

• 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, PowerShell scripts
• 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
• Installed, Configured, Worked with Foglight for SQLServer tool

Confidential

Sr. SQL Server DBA / LEAD

Responsibilities:

• 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
• Installed, Configured, Worked with Foglight for SQLServer tool
• Exposure to supporting ETL based applications.
• Exposure to the Credit Card Banking Domain.
• Experience with GEO cluster

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, PowerShell scripts, Foglight

Confidential

Sr. SQL SERVER DBA

Responsibilities:

• 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
• Expertise in creating and supporting in OLAP Cubes
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• 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.
• Creating and Maintaining Database Maintenance Plans.
• Backup Restore Plans.
• Performance Monitoring using SQL Profiler and Windows System Monitor.
• 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
• Installed, Configured, Worked with Foglight for SQLServer tool
• 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, PowerShell scripts, Foglight

Confidential

Sr. SQL SERVER DBA

Responsibilities:

• Strong experience in working on Very Large Databases VLDB over 80 GB for OLTP and 2TB for OLAP databases.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Configured more than 2 GB ram on 32 bit Environment.
• 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.
• Monitoring the Disk spaces on all the servers
• Monitoring the Scheduled jobs
• As a part of the DBA team providing 24/7 production support to the clients
• Creating DTS packages and Maintenance plans and jobs for automation of the repetitive task.
• Performing Database maintenance activities like Backups, Restoring.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options
• 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
• Expertise in creating and supporting in OLAP Cubes
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• 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.
• Installed, Configured, Worked with Foglight for SQLServer tool
• Experience in trouble shooting database issues.
• Experience with GEO cluster

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

Confidential

Sr. SQL Server DBA

Responsibilities:

• To provide day to day support to user queries and customer advice Due to the nature of the environment, there is often a necessity to carry out scheduled work outside of Working hours.
• Responsible for day-to-day support of SQL databases for all the mission critical credit card databases High OLTP
• SQL Server Performance Monitoring and problem resolution
• Excellent team working skills balanced with ability to work alone and a positive attitude.
• Backing up System, User databases Complete Backup, Differential Backup, Transaction log backup and Scheduling
• Restoring Complete Backup file restore, Differential Backup file restore, Transaction logs backup files restore , Monitoring Error Logs, Jobs
• Trouble shooting Memory Bottlenecks log , D-drive space issue, Blocking etc Worked on basic Administration, DTS packages, Database Security, Performance Tuning, Worked on the KFS PCI SOX Compliance MAPI areas Managing Database vs. Data files .Mdf, .Log files Hands on Experience in Enterprise, Standard Edition, Developer edition Personal Edition Creating Databases, Database Size estimation, File growth, log data files System User Databases Maintenance and Administration Setting Database properties, SP Migration, Tables migration, Database Security Available production support for 24 7 whenever required. Worked on ITIL process Ticket handling, Change Management, Problem management, Incident management, SCOM. Support International customers to fulfill their MS SQL SERVER DB Maintenance and Administration needs
• Expertise in SQL server Reporting Services SSRS , VB.NET,C ,ASP.NET
• Worked on setting up backup jobs for OLAP databases, VB.NET,C ,ASP.NET
• Working with various vendors in implementing new projects
• Worked on setting up Log Shipping using Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages,SCOM.
• Worked on tickets sent by customers for migrating objects and data from test server to production server, restoring and backing up databases in production environment.
• Expertise in SQL server Reporting Services SSRS
• Installed, Configured, Worked with Foglight for SQL Server tool.

Environment: ASP, MS SQL Sever 2005, 2000 Windows NT/XP, VB, Query Analyzer, Enterprise Manager, MS Access and SSIS,Veritas net backup, Tivoli,Share Point,SCOM, VB.NET,C ,ASP.NET., PowerShell scripts, Foglight

Confidential

SQL Database Administrator

Responsibilities:

• Installing, Configuring and Administering SQL server 2000, 7. Worked with SQL Server 2000 inplace and side by side upgrade from SQL server 7.
• Strong experience in working on Very Large Databases VLDB over 80 GB for OLTP and 2TB for OLAP databases.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Configured more than 2 GB ram on 32 bit Environment.
• 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.
• Monitoring the Disk spaces on all the servers
• Monitoring the Scheduled jobs
• As a part of the DBA team providing 24/7 production support to the clients
• Creating DTS packages and Maintenance plans and jobs for automation of the repetitive task.
• Performing Database maintenance activities like Backups, Restoring.
• Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options
• Migration of SQL Server 7 to 2000and also side-by-side upgrade
• Strictly adhering to SLA and ensuring all the metrics are met without a breach
• Maintaining instance/database documentation and ensuring it is Up-to-date
• Weekly status calls and also preparing Minutes of meeting
• Good experience in resolving blocking/locking and dead lock Issues
• Verifying Index Fragmentation and performing re-org and rebuild as per
• Perform SQL Installations and configuration SQL Server 2000.
• Worked on rolling out the latest security patches across all the SQL servers in the organization
• Worked on capacity planning for existing production servers before consolidation and moving them to new data center
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc
• Performing code reviews and approving before deploying to production
• Code deployments to production servers
• Installed, Configured, Worked with Foglight for SQLServer tool