SQL DBA

I have over 7 years of experience in Database administrator (DBA) with Implementation and Production Support, extensive experience designing, coding, testing and supporting database solutions in SQL Server environments. Proficient in an assortment of technologies, including SQL Server 7, 2000, 2005, 2008, 2008 R2 DBA, SSIS, SSRS and T-Sql002E

DBA skills include:

• Experienced in Installing, Upgrading and Configuring MicrosoftSQLServer 2008 R2/2005/2000.
• Maintained 300 Production, UAT and Development Clustered Servers, around 500 instances with 3000 databases including 2TB VLDB’s.
• Migration and upgrade(In place and side by side) from SQL Server 2000 to SQL Server 2005, and SQL Server 2000 to SQL Server 2008.
• Solid experience on configuration and maintenance of high availability SQL Server solutions, including Log shipping, Database Mirroring, Replication(Transactional and Merge) and SQL Server Clustering.
• Experience with implementation of disaster recovery (DR) and strategy planning.
• Having good expertise in production change management process.
• Used DBCC commands, DMVS and DMFs to troubleshoot, tune and monitor the health of Production database and SQL Server, Maintained Windows and SQL Server authentication modes, creation of users, configuring permissions and assigning roles to users.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Clustering experience using SAN/NAS with shared file-systems and dedicated hardware load balancing, Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Working Experience on configuration and maintenance of Windows 2000, 2003 and 2008 Clustered servers. Proactively monitor the clustered servers to ensure secure services with minimum downtime
• Responsible for working with application developers inidentifying, resolving and proactively working to prevent performance or other production impacting issues
• Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies.
• Established and wrote Performance Tuning guidelines to enhance quality of our product for all current and future code development.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts and Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, and Performance Monitor
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T-SQLstatements for various applications.
• Experience on Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS
• Expert in design and development ofSQLServer Integration Services (SSIS) packages and using various control flow task and data flow transformation
• Having Experience in On call DBA rotation responsibilities, which include application support, trouble-shooting, server migration, server configuration, backups, monitoring, performance planning

and proactively working to prevent performance or other production impacting issues

• Support and Troubleshooting in business critical production environment (24/7)

Skill Summary

RDBMS Software and Tools: MS SQL Server 7, 2000, 2005,and 2008 R2,T-Sql, Enterprise Manager, Profiler, Query Analyzer, Export & Import, DTS, Replication, SSIS, Sybase 11, Sybase 12.5, Oracle 9i, 10g,PL/SQL,SQL-Backtrack, Ms-Access.
Hardware/Operating Systems: Windows NT, Windows 2000, 2003 and 2008 server, UNIX, AIX 4.3.x, Solaris, HP-UX 11.0 and 11i, SAN.
Development Languages: Active Server Pages (ASP), ASP.NET, VB.NET, C#.Net, Visual Studio, Internet Information Server (IIS 6.0), VBScript, Visual Source Safe, Crystal Reports, Red Gate, Erwin, Visio

Experience

Confidential,SDMS, London, UK.
Sr. SQL Database Administrator and Developer

10/2010 – at Present

Ford Motor began a manufacturing revolution with mass production assembly lines in the early 20th century. One of the world\'s largest auto makers, Though it operates about 90 plants worldwide, Ford Motor gets more than half of its sales from North America.
Key Responsibilities:

• Served as Sr. DBA & Developer in Production and Implementation of SDMS, Maintaining 200+ Production, UAT and Development Servers, databases size including 2TB VLDB’s.
• Worked as a 3rd line Production DBA Support.
• On Call DBA support for 24X7.
• Gathering and Understanding the business requirements (Hardware and Software), Building UAT and Development servers accordingly.
• Installation of SQL Server 2008 and its configuration and DB migration from SQL 2000 and 2005 to SQL server 2008.
• Maintained and Configured Log shipping, Database mirroring and Replication (Transactional and Merge)
• Maintain MS SQL Server 2005/2008, including security, configuration and install service packs upgrades.
• Database refresh in QA or Development environment
• Proactively configure and monitoring of live site production databases in Microsoft clustered environment.
• Configuration and Maintaining As part of a team SLA’s, analyzed the different high availability solutions and implemented database log shipping, mirroring and replication (Transactional and merge).
• Experience on Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• SQL Server 2005/2008 profiling with Dynamic Management Views in both Server-scoped DMV and Database-scoped DMV.
• Established and wrote Performance Tuning guidelines to enhance quality of our product for all current and future code development.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• MS SQL Server database administration, configure Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Performance Monitoring of MS SQL Server 2008/2005 using various tools SSMS, Performance Analysis, Spotlight, BMC – Proactive net, IBM Tivoli.
• Deployment of Production Builds. Deploying Build in Pre-prod environment and working with QA team for Functionality Testing and Regression Testing.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Troubleshooting of site issues, DB Performance issues and long running queries.
• Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Troubleshooting of SQL job failures, DTS and SSIS packages.
• Performance Monitoring using SQL Profiler, Performance Monitor, planning for CPU and Disk space requirements and db maintenance and optimization using DBCC commands.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs

Environment: SQL Server 2008 R2/2005/2000/7/6.5, Windows 2K/2003/2008 R2, SQL Profiler, Spotlight, LiteSpeed Backup software, SSIS 2005/2008 R2, SSRS 2005/2008 R2, IIS 6.0, Erwin, ASP.NET, C#, Sybase 12.5 ASE, Oracle 10g.

Confidential,GTS, USA.
Sr. SQL DBA

1/2009 – 5/2010

Manage SQL database administration assignments for Citi Bank. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
Key Responsibilities:

• Sr. Production Database Administrator and SSIS Developer.
• Taking care of 300 servers for SQL Server 2000, 2005 and 2008. Litespeed backup.
• Configure and Maintenance, Monitoring, Installation, patches, DBA tools and Clustering.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.
• As part of a team, analyzed the different high availability solutions and implemented database mirroring and replication.
• Migrating the database from Sybase to SQL Server 2005 and 2008
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks
• Migrating SQL Server 2000 data bases into SQL Server 2005 and 2008.
• SQL Server 2005 profiling with Dynamic Management Views in both Server-scoped DMV and Database-scoped DMV.
• Established and wrote Performance Tuning guidelines to enhance quality of our product for all current and future code development.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
• Redesigned a thorough backup and recovery strategy for all major production systems.
• Upgraded all SQL Server 2000 to SQL Server 2005 and 2008 without service interruption
• Responsible for logical and physical design with a significant effort towards application and database tuning.
• Major activities include advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards.
• Export or Import data from other data sources like flat files/ raw files using Import/Export through DTS, SQL Server Integration Services (SSIS).
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plan and Index tuning.
• To set up SQL Server configuration settings.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Using log shipping for synchronization of database.
• Created and developed the stored procedures, triggers to handle complex business rules and audit analysis.
• Monitoring the servers using spot light third party Quest software.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index de-fragmentation by DBDEFRAG and DBREINDEX.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Experience with SQL Server Integration Services(SSIS) and SQL Server Reporting Services(SSRS)

Environment: SQL Server 2000, 2005 and 2008, Windows 2K/2003 Data Center, SQL Profiler, LiteSpeed Backup software, Reporting Services

Confidential,UK.

6/2008 – 12/2008

The ROS is a project of the Scotland. It deals with the QTP for migrated data which is actually belonging to Scotland where the govt. This project has been organizing the group of Scotland government in different locations across the world
Key Responsibilities:

• Perform day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues. Proficient with Server-Side System Default & Black box Traces to analyze other issues on the server.
• Replication issues & existing publications & subscriptions to keep data in synch & solved and monitoring Snapshot and Transaction Replication.
• Setup and configure SQL Server for other business functions. Index & Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Manage user and data security to allow access to appropriate resources. Proven experience in maintenance of SQL Server in a VLDB environment.
• issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.
• Writing DTS/SSIS packages using advanced tasks for data Extraction, Transformation and Loading. Writing Customized DTS/SSIS Packages for Import/Export of Data. Used Crystal Reports for writing reports.
• Backup and restoring databases using various tools and T-SQL Scripts. Point in time recovery and Disaster Recovery.
• Configuring, Monitoring and Troubleshooting DB mirroring Replication, Log shipping.
• Planning and implementation of database backup/restore Strategies.
• Working with Development team to normalize the database and optimize Queries.
• Writing customized scripts for monitoring of the SQL Servers and other database administration work.
• Installation and configuration of various Quest tools such as Litespeed 2005, Performance Analysis, and Spotlight.
• Deployment of Production Builds. Deploying Build in Pre-prod environment and working with QA team for Functionality Testing and Regression Testing.

Environment: SQL Server 2008/2005/2000, Windows 2K/2003/2008, SQL Profiler, SSIS 2005/2008, SSRS 2005/2008, IIS 6.0, Erwin, ASP.NET, C#, Sybase 12.5 ASE, Oracle 10g.

Confidential,IND.
Database Administrator and Developer

6/2006 – 5/2008

Replacement Lence Insurance is a USA based insurance company, which provides insurance to the personal lines and commercial lines of business, Insurance system, and Insurance system has major modules like Policy
Key Responsibilities:

• Monitored all production SQL Server Databases.
• Responsible for database creation, database tuning, performance planning and database administration
• Monitored and managed transactional and snapshot Replication.
• Created stored procedures, scripts, and cursors for the Bulk application, testing on the test servers and moving them to production.
• Managed Disk space, memory and User connections.
• Experience in Database Backup and recovery -- worked on different DR strategies with Logshipping, Replication and Clustering.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Gathered and analyzed specifications, created custom Business Intelligence reports written in SQL Server Reporting Services against a SQL Server data warehouse.
• Used VB.NET, ASP.NET, Visual Studio.NET, XML, HTML and SQL Server Reporting Services. ADO.NET used to develop Datasets to manipulate data in the application. Developed based on MS Solutions Framework Best Practices.
• Used ASP.NET and VB.NET to develop System Management Utilities application for systems administration task automation and inventory collection. Created VBScript WMI scripts.
• Created Tables, Views and Functions using T-SQL.
• Worked extensively on IMS performance issues like statistics update, index rebuilding at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Created and managed user accounts and tracked user activities as and when required.
• Created and optimized Clustered and Non Clustered Indexes.
• Develop and manage DTS Packages and scheduled jobs for periodic and nightly batch processes. 24x7 Production support.

Environment: Windows Server 2000,SQL Server 2000, ASP.Net, ADO.Net, VB.Net, VB 6.0, Visual Studio 2005, HP-UX 11.11, .Net Framework 2.0, Internet Information Server (IIS), Oracle 9i.

Education

Master of Science, in Computer Science