Summary

Fourteen years of professional experience in computing; Twelve years of Database Administration dedicated to the development, maintenance, and performance of MS SQL Server databases in high-availability, Enterprise environments.

• Over 14+ years of experience in the Information Technology as a SQL Server and System\\Infrastructure Administrator.
• Over 12+ years of experience as a Database Administrator.
• Prioritizing of scopes and manages infrastructure projects.
• Worked as an architect of infrastructure design of Development and Production.
• Worked extensively on SQL Server tools like replication, Mirroring, MSDTC, SQL profiler, Backup & Recovery.
• Thorough knowledge on SQL Server Architecture.
• Experienced on handling various data sources, data scrubbing and loading using SQL DTS, SSIS.
• Skilled in SQL Server 2008R2/2008/2005/2000/7/6.5 & Windows NT/2000/XP/2003/2008

Strengths

• Managed a team of employees, consultant and vendor partnerships.
• Excellent written and oral communication skills
• Self starter who learns quickly
• Work well independently and in groups
• Strong leadership and training experience
• Excellent analytical and problem solving skills
• Solid experience in customer service and sales support
• Capacity planning and Disaster recovery.

Technical Skills:

Operating Systems: Microsoft Win XP, Win2k, NT4, Terminal Server, Linux & Novell Netware operating systems.
Hardware: IBM Net Infinity Servers, Dell, HP & Compaq Servers.
Database: MS SQL Server 2008 R2, 2008, 2005, 2000, 7.0 and 6.5, Access 2000/XP & Sybase System 10 on UNIX
Data warehouse Tools: OLAP, SQL Data Transformation services (DTS)
System & Network monitoring: HP Open View, Bind view, Empirix monitoring tool
Reporting tools: Brio, Crystal Reports, Microsoft Reporting Server.
SQL server Tools: SQL profiler, Meta Data services, Data Junction ETL tool, Microsoft Reporting Server
Software & Application tools: Mercury interactive Load Runner 6.5, Radview Web load 4.5, Internet Information Server (IIS) 5.0& 4.0 & Microsoft Front Page 2000, Visual InterDev 6.0, Visual Source Safe 6.0, MS Office, ActiveX, VB Scripts.
Mail servers: Microsoft Exchange Server 5.0.
SQL Server Tools: Litespeed2005, Entegra, Embarcadero & other Third party tools.

Major Assignments:

August 2011 – August 2012
Confidential, (Database Consultant\\Architect, Portland, OR\\WFH)
Responsibilities:

• Planning and architecting of new infrastructure for legacy servers.
• Procurement order and narrowing server requirements (VM’s and database consolidation)
• Actively involved in the architecture of database in term of new implementation or performance.
• Creation of documentation and process as per SOX Policies and procedures.
• Maintenance of Database on regular basis which includes automation process.
• Actively involved in the architecture of database in term of new implementation or performance.
• Effectively managing capacity planning and disaster recovery testing (quarterly).
• Monitoring performances through SQL Server or third party tools, Query optimization and other resources.
• Worked with securities, roles, schema, backups and recovery, database migration, indexing schemas and implementation, query optimization.

January 2011 – September 2011
Confidential,(Database Team Lead\\Architect, Minneapolis\\Palo Alto, MN\\CA)
Responsibilities:

• Planning and architecting of new datacenter (infrastructure) for move of 240+ application databases.
• Procurement order and narrowing server requirements (VM’s and database consolidation)
• Management of requirement from UCS and software licenses.
• Created process for data center move and standardization
• Managing Team of SQL DBA (8) for the transition.
• Actively involved in the architecture of database in term of new implementation or performance.
• Worked on DR with Application SLA’s and assigned Metal Chart.
• Maintenance of servers and databases on regular basis, which includes automation process.
• Creating and managing capacity planning and disaster recovery.
• Providing service restoration and performance tuning for SQL 2000, 2005 and 2008(R2) production legacy systems
• Managing and creating fail over through mirroring in disaster recovery.
• Monitoring performance for DW Environment and its maintenance.
• Developed, managing and testing disaster recovery and backup strategies.
• Daily archiving process of Data ware house and working with architecture
• Maintenance of Database on regular basis, which includes automation process.
• Creating architecture of database in term of new implementation or performance.
• Effectively managing capacity planning and disaster recovery.
• Working with Backup and Recovery, database migration, indexing schemas and implementation, query optimization and stored procedures development, server clustering, and database partitioning

November 2010 – July 2011
Confidential,(Sr. SQL Server Consultant\\\\Architect, Hoffman Estates, IL)
Responsibilities:

• Monitoring performance for DW Environment and its maintenance.
• Developed, managing (capacity planning) and testing disaster recovery and backup strategies.
• Daily archiving process of Data warehouse and working with architect of warehouse.
• Maintenance of Database on regular basis, which includes automation process.
• Creating architecture of database in term of new implementation or performance.
• Working with database migration, indexing schemas and implementation, query optimization and stored procedures development, server clustering, and database partitioning
• Providing service restoration and performance tuning for SQL 2000, 2005 and 2008 production legacy systems
• Managing and creating fail over through mirroring on other applications.

March 2010 – October 2010
Confidential, (SQL Server Consultant, Minneapolis, MN)
Responsibilities:

• Maintenance of Database on regular basis, which includes automation process.
• Creating architecture of database in term of new implementation or performance.
• Effectively managing capacity planning and disaster recovery.
• Working with Backup and Recovery, database migration, indexing schemas and implementation, query optimization
• Working on stored procedures with development team
• Providing service restoration and performance tuning for SQL 2000, 2005 and 2008 production legacy systems
• Managing and creating fail over through mirroring.

October 2009 – March 2010
Confidential, (SQL Server Consultant, Santa Clara, CA)
Responsibilities:

• Reviewing SharePoint Databases and performing database optimization.
• Suggesting the path towards best practice and performance.
• Suggesting and making some changes in Database maintenance for better performance.
• Resolving bottle necks of SQL Server in related to CPU, I/O and Memory.
• Reviewing and suggesting development team to make changes as per the issues.
• Creating scripts and jobs for the future maintenance as per the business requirement.
• Working on Migration plan from 32 Bit to 64 Bit SQL 2008 which involves big changes as per the best practice.

November 2007 – October 2009
Confidential, (Sr.SQL Server DBA, Minneapolis, MN)
Responsibilities:

• Migration of SQL 2000 databases to SQL 2005 and currently working SQL 2008 migration projects.
• Working with infrastructure team on the migration of stand alone server to cluster environment.
• Ensured that the database infrastructure meets the availability, uptime and projects deadline.
• Effectively managing projects to implement hardware and software components of the technology infrastructure.
• Creating polices and other documents such as process and standardization.
• Creation of documentation and process as per SOX Polices and procedures.
• Maintenance of Database on regular basis which includes automation process.
• Actively involved in the architecture of database in term of new implementation or performance.
• Effectively managing capacity planning and disaster recovery testing (quarterly).
• Monitoring performances through SQL Server or third party tools, Query optimization and other resources.
• Worked with securities and roles.
• Worked with Backup and Recovery, database migration, indexing schemas and implementation, query optimization and stored procedures development, server clustering, and database partitioning
• Responsible for Enterprise-wide reconstruction of the SQL Server environment for US Bancorp -Powertrack.
• Designing the new systems for SQL Servers at each of the two Powertrack sites in two states to include consolidated clusters, multiple SANs, updated softwares, security policies, and 24x7 system monitoring.
• Defining the requirements of each component and working with vendors in the acquisition process.
• Writing processes and procedures; setting policies for the IT organization.
• Defining the roles and responsibilities of the DBAs for the organization.
• Providing service restoration and performance tuning for SQL 2000 and 2005 production legacy systems

May 2007 – November 2007
Confidential,(Sr.SQL Server DBA -Lead, Chicago, IL)
Responsibilities:

• Managed team of SQL DBA and mentor the team profile and projects.
• Migration of SQL 2000 databases to SQL 2005.
• Developed capacity planning and strategies with increased availability.
• Developed and implement strategies for providing facilitative support resulting in fewer incidents, increased availability, or accelerated deployments.
• Worked with Backup and Recovery, database migration, indexing schemas and implementation, optimization and stored procedures development, server clustering, and database partitioning
• Worked extensively oversee all database administration activities, in house projects and vendor projects
• Installation, upgrades and migration of SQL server database servers and databases
• Routine maintenance of all SQL server databases for optimal performance and error reduction (using third party tool)
• Daily monitoring of database storage allocation and usage as well as other resource usage
• Backups and recoveries: backup standards and schedules, recovery procedures. (using third party tool)
• Managed database in cluster environments, stand alone and remotely.
• Managed database user’s security.
• Advising developers / end users on issues such as database design, indexing, SQL tuning, stored procedures, triggers and DTS (Data Transformation services).
• Exporting / importing data and data replication

June 2006 – May 2007
Confidential,(Sr.SQL Server DBA, Chicago, IL)
Responsibilities:

• Hands on experience on SQL 2005.
• Worked extensively oversee all database administration activities and projects
• Installation, upgrades and migration of SQL server database servers and databases
• Routine maintenance of all SQL server databases for optimal performance and error reduction (using third party tool)
• Daily monitoring of database storage allocation and usage as well as other resource usage
• Backups and recoveries: backup standards and schedules, recovery procedures. (using third party tool)
• Managed database in cluster environments, stand alone and remotely.
• Managed all kind of replication their backups.
• Managed database user’s security.
• Intent of this security plan is to establish a means of providing complete accountability for any and all use of the databases
• Advising developers / end users on issues such as database design, indexing, SQL tuning, stored procedures, triggers and DTS (Data Transformation services).
• Exporting / importing data and data replication
• Security auditing and testing
• Security plan development and maintenance.

October 2005- April 2006
Confidential, (Sr. SQL Server DBA, Peoria, IL)
Responsibilities:

• Creation of documentation and process as per SOX Polices and procedures.
• Worked extensively oversee all database administration team\'s activities and projects
• Assist IT management in prioritizing database administration team\'s projects
• Installation, upgrades and migration of SQL server database servers and databases
• Routine maintenance of all SQL server databases for optimal performance and error reduction
• Daily monitoring of database storage allocation and usage as well as other resource usage
• Backups and recoveries: backup standards and schedules, recovery procedures.
• Managed database in cluster environments, stand alone and remotely.
• Managed all kind of replication their backups.
• Managed database users.
• Managed financially significant databases under surveillance of SOX (Sarbanes Oxley).
• Intent of this security plan is to establish a means of providing complete accountability for any and all use of the databases
• Developing and maintaining the portions of the disaster recovery plan that pertained to the database servers and provide documentation of the steps necessary to perform the disaster recovery process.
• Advising developers / end users on issues such as database design, indexing, SQL tuning, stored procedures, triggers and DTS (Data Transformation services).
• Exporting / importing data and data replication
• Security auditing and testing
• Security plan development and maintenance.

August 2005 – October 2005
Confidential, (SQL Server Consultant, Downers Grove, IL)
Responsibilities:

• Maintenance plan of the Database.
• Maintaining SQL production, development, staging environment databases
• Backup/Recovery, Support, Documentation, Indexing, and Table Creations
• Log checking, index rebuilding, database performance check, database space usage, checking performance and maintenance job, lock monitoring, creating Daily, Weekly & Monthly database performance report.

Confidential, (SQL Server Consultant, Bannock burn, IL)
Responsibilities:

• Migration of Database from Standard (7.0) to Enterprise version 2000.
• Maintenance plan of the Database.
• Maintained SQL production and development environment databases.
• Supported the development team on SQL programming (Stored Procedure with Timed out and dead locks) security & performance needs.
• Worked on Log Shipping, disaster recovery techniques, log monitoring, backup & restore technology.
• Daily monitoring – Log checking, index rebuilding, database performance check, database space usage, Checking performance and maintenance job, lock monitoring, creating Daily, Weekly & Monthly database performance report.

July 2003 – August 2005
Confidential, (SQL Server DBA Chicago, IL)
Responsibilities:

• Designed & maintained the OLTP & database.
• Maintained SQL production, development, staging environment databases.
• Supported the development team on SQL programming (Stored Procedure, T-SQL, XML), security & performance needs.
• Worked on Log Shipping, disaster recovery techniques, log monitoring, backup & restore technology
• Daily monitoring – Log checking, index rebuilding, database performance check, database space usage, Checking performance and maintenance job, lock monitoring, creating Daily, Weekly & Monthly database performance report.
• Wrote extensive DTS packages for data scrubbing.

Confidential,
Responsibilities:

• Project planning and management.
• Utilizing system development life cycle methodologies
• Providing business systems analysis training/mentoring
• Understanding of data modeling fundamentals and techniques
• Developing quality assurance strategy and test plans
• Managed day-to-day Network and Database Services.
• Implementation and tracking of security and patches in networks and databases.
• Monitors manage and maintain backup, performance and recovery schedules for database servers.
• Database Designing and implementing (SQL Server 7.0, SQL Server 2000).
• Support to system management (Desktop & networking) and Database Management.
• Solving Day-to-day problems in databases & taking corrective actions.
• Supporting the development team in the designing, performance tuning the development databases
• Auditing of all databases for security violations.
• Setting up SQL server Transactional, Snapshot replication across multiple databases
• Worked extensively on data transformation services (DTS) for transferring data between discrete data sources.
• Worked extensively on BCP utilities for bulk data & image file uploading.
• Worked extensively on SQL & stored procedures programming.
• SQL Server Performance Tuning, Data Migration, Database replication, Relational Database.
• Assist users with databases, computer and application related queries.
• Installation of Servers and up gradation of Operating System from Windows NT4.0 to Windows 2000.

Training/Certifications:

• Bachelor’s degree in Science
• Master in Computer Science
• Microsoft Certified Systems Administrator (MCSA)
• Microsoft Certified Database Administrator (MCDBA)
• Diploma on Computer Hardware /Network Technology from National Institute of Information Technology (NIIT).
• Training on SQL 2005, Global Knowledge, Chicago, IL