SUMMARY

• 12+ years of IT experience in Database Planning, Design, Installation, Administration, Analysis, Tuning, Development, Upgradation, Virtualization and Support of MS SQL Server 2008/R2/2005/2000, MYSQL 5 Server and ORACLE 9i/10g grid Servers in Production, Testing and Development Environments as a Database Administrator
• Excellent Experience in Installation, Configuration, Upgradation, Virtualization and Migration of SQL Server 2008R2/2005/2000 to provide the optimum performance to high volume OLTP and OLAP Environments
• Expert in Database Planning and Implementation, Performance Monitoring and Tuning, Troubleshooting, Backup and Recovery, Security and Administration in MS SQL Server 2008/2005/2000
• Solid Experience in Managing MS SQL Server 2008/2005/2000 Databases including Security, Space Management, Database Migrations, Database and System Tuning, and User Resource Management
• Strong hands on Experience in Scheduling & Automation of Back - Ups of SQL Server 2008/2005/2000 databases and Transaction Logs
• Expert in using different recovery models Simple, Full and Bulk-logged depending on availability of database
• Solid Experience in Query Optimization, DB Optimization, Fine Tuning and Optimization of Indexes for better server performance
• Good Experience in Configuration and Management of SQL Server High Availability solutions like Active Fail Over Clustering, Database Mirroring and Log shipping
• Good Experience in implementation and management of Transactional, Snapshot Replication between OLTP and OLAP Servers
• Strong hands on Experience in Scheduling Jobs for optimization, consistency and integrity checks of the databases using DBCC and DMV
• Experience in MS SQL Server tools like SQL Server Management Studio, Enterprise Manager, SQL query analyzer, SQL Server Profiler, Database Tuning Advisor and Performance Monitor
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Experience in Designing Data Transformation Services (DTS) packages, SQL Server Integrations Services packages for import and export data to/from SQL Server Databases
• Good Experience in writing and optimizing stored procedures, triggers, cursors and user defined functions in T-SQL Language for SQL Server
• Experience in Designing and Implementation of Business Information Cube structure and dimensionality using SQL Server Analysis Services (SSAS) as per the Business Requirements
• Experience in Design and Implementation of SQL Server Reporting Services (SSRS) Reports as per the Clients Requirements
• Experience in Creating Maintenance Plans, Jobs and sending Alerts using Database Mail service
• Worked with third party backup tools LiteSpeed, Red Gate, Idera SQL safe for fast and compression of Backups
• Good Experience in Configuration and Management of MS SQL Servers in VM Ware and Microsoft Hyper-V Virtual Environments
• Good Knowledge and Experience in Managing SAN and ISCSI storage systems
• Good Knowledge and Experience in Software Development Lifecycle using Agile SCRUM methodology
• Good Knowledge and Experience in ISO 9001:2000 QMS Process Environment
• Good experience in system administration, configuration, troubleshooting, performance tuning, planned maintenance and security procedures in Windows Server 2008/2003/2000

TECHNICAL SKILLS

Languages: C, C++, T-SQL, PL/SQL, VB script, PERL

Databases: MS SQL Server 2008, 2005, 2000 & 7.0, Oracle 11g/10g & 9i, MYSQL Server 5

Operating Systems: Windows Server 2008/2003/2003 , Windows 95/98/XP/Vista/7, Solaris, Linux, VM ware ESX/WS, Microsoft Hyper-V

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Design and Optimization of existing Databases as per the requirement
• Planned and Migrated Databases from SQL Server 2005 to SQL Server 2008R2
• Virtualization of Databases and corresponding Servers with VM WARE
• Re augmentation and integration of Databases to reduce the Licensing cost per Server per CAL
• Optimized and Managed SQL Server Instances and Databases using Idera’s Diagnostic Manager Application
• Scope Change Request Procedures Prepared and Documented for future reference
• Built SSIS Packages for data transfer from heterogeneous data sources using T-SQL Stored Procedures
• Created and monitored SQL Server automated jobs to transfer data from various data sources
• Verified the Stored procedures created by developers and fine tuned the scripts for better performance
• Designed user access and permissions to access the database at various levels to provide better security, created and implemented the scripts in various production and development servers
• Designed and Implemented the High Availability Fail Over Clustering and TXN Replication between OLTP and OLAP Servers
• Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards
• Designed and implemented ETL (Extraction, Transform and Load) for data migration and data staging from heterogeneous environment like MS Access and MS Excel using SSIS
• Various Reports Design Building and Generation and then transfer to Reporting WEB Servers using SSRS and Batch Program Jobs
• Worked with DBCC checks to ensure the physical consistency of the database and objects.
• Provide standardization and consistency across SQL Server environments, including documentation of any deviations from the standards
• Managed Data Files, File Groups, Partitions, Storage Space and Allocations and Memory
• Monitored the databases to identify performance issues using SQL Server Profiler and resolved the issues
• Automation of effective Backup and Recovery plan by Transactional Log, Differential and Full Database Backups and utilized to recover data in point in time in case of disaster of database or server
• Configuration of Database mail for automated jobs notification and alerts to corresponding Operator
• Virtualization of Database Servers for Development, UAT and EUT using VM Ware ESX

Environment: WINDOWS 2008/2003 (Enterprise Edition), MS SQL Server 2008/2005 (Enterprise Edition), VM Ware Esx/WS

Confidential, Jamesburg, NJ

Production DBA/Developer - SQL Server

Responsibilities:

• Installing, Configuring and Maintaining of SQL Server Databases in Production, Staging, Development and QA Environments
• Planned and Migrated Databases from SQL Server 2000 and 2005 to SQL Server 2008
• Managed and Optimized SQL Server Instances and Databases using SQLDBManager Application
• Migration of Auxiliary Databases to MYSQL Servers to Reduce Licensing Cost
• Managed Users and Security Administration
• Designed and Implemented the High Availability Active Clustering between Production Nodes
• Designed and Implemented the SNAPSHOT Replication Solution between OLTP and OLAP Servers
• Created and monitored SQL Server batch scripts and jobs to automate the transfer data from/to various data sources
• Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards
• Designed and implemented data migration and data staging from heterogeneous environment like Flat files and MS Excel using SSIS
• Designed storage strategies and established standards for complex database environments, physical structures, and specialized database applications
• Reports Building and Publishing as per Clients requirements in SSRS
• Creating Stored Procedures and Functions in SQL Server as per Application Developers requirement
• Documentation of all the processes involved in maintaining the database for future reference
• Worked with DBCC checks to ensure the physical consistency of the database and objects.
• Created Linked Servers with MYSQL for Data Access from/to SQL Servers Reports
• Monitored the performance of SQL Server and Windows using SQL Server Profiler, Windows 2003 Performance monitor and SQL Server Query Analyzer
• Created Automation Scripts for effective Backup and Recovery plan by Transactional Log, Differential and Full Database Backups and utilized to recover data in point in time in case of disaster of database or server
• Tested the Recovery of the database frequently to ensure that Backup files not corrupted and optimal

Environment: WINDOWS 2008/2003 (Enterprise Edition), MS SQL Server 2008/2005/2000 (Enterprise Edition), MYSQL 5 Server, RHEL 4.5

Confidential, Northbrook, IL

SQL Server Database Administrator

Responsibilities:

• Responsible for ensuring availability and performance of the databases that support our internally developed applications and reports
• Responsible for Migration of Databases from SQL Server 2005 to 2008
• Responsible for Database Security and User Administration
• Meet enterprise requirements by planning and developing database structure, developing database utilization policies, procedures, security, backup and recovery procedures
• Work to ensure that the associated hardware resources are properly allocated to the databases and to ensure high resilience and performance tuning
• Maintain design structure by directing implementation of SQL standards and guidelines
• Confirm database requirements by conferring with clients, studying operations and objectives, integrating enterprise requirements, applying database concepts and functional capabilities
• Responsible for providing trend analysis to the management team to enable them to make informed decisions regarding resource management
• Responsible for troubleshooting and problem solving of the SQL Server environment
• Responsible for improvement and maintenance of the databases to include rollout and upgrades
• Responsible for implementation and release of database changes and upgrades according to agreed upon timetables and costs
• Complete platform upgrades and migrations by issuing instructions, monitoring performance, coordinating actions
• Maintain data integrity by establishing standards, monitoring performance
• Responsible for working with the application development team to ensure best practices are utilized when developing new databases, tables, views and reports

Environment: WINDOWS 2008/2003, MS SQL Server 2008/2005 (Enterprise Edition)

Confidential, Mishawaka, IN

SQL Server DBA/ Developer

Responsibilities:

• Extensively used T-SQL Queries, stored procedures, and views for the database transactions.
• Active Interaction with managers to understand business requirements.
• Created customized SSIS packages to load operational data into production system.
• Involved in Index and performance Tuning.
• Extensively used SQL Server 2008 Log Shipping to distribute the data to different locations and to maintain the databases in sync.
• Created and administered Jobs to maintain referential integrity.
• Moved the legacy inspection applications data from various heterogeneous sources like MS Access, and MS Excel and text files to SQL Server 2008 database using BCP and dynamic DTS packages.
• Created proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Managed the Security creating Users, Groups and Roles in SQL Server 2008.
• Database backups & log file backups and recovery procedures.
• Documentation of all the processes involved in maintaining the database for future reference.
• Automated many operations for backing up the tables (such as archiving centralized table to a different server) by scheduling multiple Batch packages using jobs.

Environment: WINDOWS 2008/2003 (Enterprise Edition), MS SQL Server 2008/2005 (Enterprise Edition)

Confidential

Senior Database Administrator

Responsibilities:

• Planned and Migrated Databases from SQL Server 2000 and 2005 to SQL Server 2008
• Optimized SQL Servers Instances from 61 to 42 in SQL server 2008
• Optimized the SQL Server Databases from 1047 to 604 above 40% Reduction
• Scope Change Request Procedures Prepared and Documented for future reference
• Migrated DTS Packages to SSIS Packages
• Built SSIS Packages for data transfer from heterogeneous data sources using Active X Scripts and T-SQL Stored Procedures
• Created and monitored SQL Server automated jobs to transfer data from various data sources
• Verified the Stored procedures created by developers and fine tuned the scripts for better performance
• Designed user access and permissions to access the database at various levels to provide better security, created and implemented the scripts in various production and development servers
• Designed and Implemented the High Availability Fail Over Clustering for Production Servers
• Designed and Implemented the Log Shipping Solution between Production and Staging Enviroinments
• Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards.
• Designed and implemented ETL (Extraction, Transform and Load) for data migration and data staging from heterogeneous environment like MS Access and MS Excel using SSIS/DTS.
• Designed storage strategies and established standards for complex database environments, physical structures, and specialized database applications
• Worked with DBCC checks to ensure the physical consistency of the database and objects.
• Provide standardization and consistency across SQL Server environments, including documentation of any deviations from the standards.
• Monitored the database to identify performance issues using SQL Server Profiler and resolved the issues.
• Created effective Backup and Recovery plan by Transactional Log, Differential and Full Database Backups and utilized to recover data in point in time in case of disaster of database or server.
• Tested the Recovery of the database frequently to ensure that Backup files not corrupted and optimal.
• Virtualization of Database Servers for Development, UAT and EUT using VM Ware ESX

Environment: WINDOWS 2008/2003 (Enterprise Edition), MS SQL Server 2008/2005 (Enterprise Edition), VM Ware Esx/WS

Confidential

Production DBA (SQL Server & Oracle)

Responsibilities:

• Installing, Configuring and Maintaining SQL Server and Oracle databases
• Planned and Migrated Databases from SQL Server 2000 to SQL Server 2005
• Migrated 423 SQL Server Databases to 2005 Server
• Scope Change Process Documentation
• User administration on SQL Server and Oracle databases
• Creating database backup plans using Maintenance Plans
• Monitor the health of the database servers
• Recover databases in case of any crashes
• Populate OLAP cubes using scheduled Jobs, as needed
• Schedule incremental Full Text Indexing on the database servers
• Monitor the hard-disk usage on the servers, and free up the disk space, if needed
• Database designing for new applications
• Planning & Implementing Server Migration
• Importing DB’s from different sources as required by application team
• Capacity planning of servers as per growth of DB’s
• Performance optimization of servers.
• Troubleshooting performance issues.
• Windows Server Administration & File server Administration
• Service Account password change management
• Setting up of database mail for job alerts

Environment: Windows 2003 (Enterprise Edition), Red Hat Linux, Sun Solaris, MS SQL Server 2005/2000 (Enterprise Edition), Oracle 9i/10g, SSIS, SSAS, MS DTS, MS Analysis Services

Confidential

Database Administrator

Responsibilities:

• Worked as a Data Modeler, and Database Administrator
• Built DTS Packages for data transfer from heterogeneous data sources like flat files to SQL Server using VBScript and T-SQL Stored Procedures
• Created and monitored SQL Server automated jobs to transfer data from various data sources
• Performed query optimization using SQL Server query analyzer to fine tune the views to get best performance
• Created database objects like Stored Procedures, Triggers, Rules, Defaults, Indexes, Primary Keys, Foreign Keys
• Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards
• Provided secured and scalable environment in Windows2000
• Improved the performance by query optimization and fine tuned Stored Procedures and Triggers for better performance
• Performed DBCC checks to ensure the physical consistency of the database and objects
• Created effective Backup and Recovery plan and utilized to recover data in point in time in case of disaster of database or server
• Designed and implemented Transactional Log, Differential and Full Database Backups to minimize the data loss and point-of-time recovery of data incase of database corruption
• Tested the Recovery of the database frequently to ensure that Backup files not corrupted and optimal
• Monitored the performance of SQL Server and Windows using SQL Server Profiler, Windows 2003 Performance monitor and SQL Server Query Analyzer
• Provided 24/7 call support
• Supported multiple servers and databases in development, test and production environment

Environment: Windows 2003 (Enterprise Edition), MS SQL Server 2000 (Enterprise Edition), MS Visual SourceSafe, MS DTS, T-SQL, MS Analysis Services

Confidential

Jr. SQL Server Production DBA

Responsibilities:

• Installation/ configuration / maintenance /performance tuning of SQL Server 2000
• Backup and recovery of databases
• Security and User Administration
• Monitoring SQL Server Agent jobs
• On call support 24/7

Environment: Windows 2000 (Data Center), MS SQL Server 2000