SUMMARY:

• Over 11 years of experience as a Database Architect / Administrator / Engineer / Developer on SQL Server 6.5 through SQL Server 2008R2 in various environments.
• Very strong in SQL Server 2008R2, 2008, 2005 and 2000 databases administration.
• A rchitecting, engineering, administrating, developing and implementing Microsoft SQL Server Database solutions for major U.S.A businesses including Confidential, Cendant Mobility and Ames Department Stores.
• SQL Server 2008R 2 / 2008 / 2005 / 2000 / 7.0 / 6.5 ;
• All components of SQL SERVER architecture: Table and Index Data Structures, Pages and Extents, Query Processing, Memory Management, Thread and Task, Transaction Log, Files and File groups, Replication, Backup and Restores, Performance tuning, SQL Server 2005/2008/2008 R2 DMVs, SQL Server Auditing
• SQL Server 2008R2/2008: Data Collection, Data Compression, Compressed Database backup.
• Relational database Design/Modeling and development of SQL Server Database Applications on a 2/3 tier environments.
• Clustering SQL Server 2008R2/2008/2005 on Windows 2008/2003/2000 environments.
• TSQL: Stored Procedures, triggers, functions, adhoc queries.
• Importing and exporting data between multiple heterogeneous and homogeneous environments using SSIS.
• Microsoft SQL Server Management Studio, POWERSHELL, SQLNexus, SQLDiag, BCP, ISQL, OSQL, SQLCMD, Client/Server Network utility, SQL Server Configuration Manager, SSRS, MSDTC, Profiler, Database Mail, SQL Agent, Linked Server, SQL Server and Windows security, Backup and Restore, DTC and RAID systems.
• Communicating with Senior Management, peers and development team Managers and members. Mentoring and training junior Database Administrators and developers.
• Documenting Information Technology (IT) and non - IT subjects.
• Deriving, documenting and establishing standards, policies, procedures and best practices on database security models, Business Continuity Plan(BCP), database engineering/development methodology and database maintenance .
• Working both independently and in a team environment.

TECHNICAL ENVIRONMENT:

HARDWARE: HP, DELL, Compaq Proliant, Hp NetServer LH4r, ICIM DRS/6000, ICIM DRS/3000, HP-9000, Confidential 3090, ICIM 101, PCs.

OPERATING SYSTEM: Windows 2008/2003/2000/ NT/XP/98/95/3.11, UNIX, SCO-UNIX, MVS/ESA, DMF-III, NOVELL NETWARE, MS-DOS, HP-UNIX.

SOFTWARE: Microsoft SQL SERVER 2008R 2/ 2008/2005/2000 /7.0/6.5 , POWERSHELL,SQL Compare, Idera Compliance Manager, Lite Speed, Veritas InDepth, CA XOsoft, Embarcadero, DBARTISAN, VBScript, Jscript, VB 6.0, Visual Studio, IIS, MTS, HTML, ASP, Viso, Natural, Adabas, Esperant, Sybase 12.5/4, Ingres.

APPLICATION: Financial Accounting, Marketing, Insurance, Retail, Manufacturing, Sales, Hedge Funds, Stock Trading.

ASSIGNMENTS:

Confidential

Lead SQL Server Engineer

Responsibilities:

• Improved the database availability to 100% from 88%.
• Improved the performance of batch process by 80% by configuring MDOP, memory and tempdb correctly.
• Re-configured database backup plans that lead to optimum usages of hardware resource and increased the backup success rate to 100%.
• Improved performance of several queries. One particular view which took 12+ hours now completes in 90 seconds.
• Initiated Database partition project to improve database scalability. Once implemented this will improve batch processes by 100%.
• Initiated Database compression technology that will improve read performance and save 80+% on disk resources.
• Initiated Server consolidation project to reduce cost.

Environment: SQL SERVER 2008R 2/ 2008/2005/2000 , POWERSHELL, Sybase, I3-Indepth, Quest LiteSpeed, Windows 2008/2003/XP,Linux, VSS, SQL Compare

Confidential

Vice President (Database Administrator)

Responsibilities:

• Reclaimed 4 TB (across all environments) of disk space by removing duplicate and obsolete indices from the most critical database of the firm. This index tuning project also improved the INSERT performance by 220%.
• Implemented database compression technology from SQL Server 2008 to compress very large read only databases. This state of the art technology has helped us to reclaim 87+% of disk space on these databases without any performance degradation
• Implemented database collection technology from SQL Server 2008 to collect SQL Server performance data from all SQL Server 2008 servers. This state of the art technology will help us to replace vendor performance monitoring tool and that will reduce the operating cost of the IT department by at least $100 thousand per year.
• Architected, developed and implemented three data archiving processes:
• First process archives 6.0 to 7.5 million rows weekly across 4 servers simultaneously. This process was originally manual intensive in which replication was dropped and application servers were shutdown before the archive. Post archive the data was backed up and restored from the publisher to the subscriber and finally replication was re-created and application servers were restarted. This entire manual process was 100% automated.
• Second process archives more than 12 million rows every night without bringing down the application and very minimum performance hit.
• Third process archives more than 100 thousand rows every night without bringing down the application and very minimum performance hit.
• Derived and implemented Least-privileged User Account (LUA) security policy on all production SQL Servers. This policy is now helping the firm in obtaining SAS 70 certification.
• Analyzed SQL Server Resources by extracting data from NETIQ application.
• Developed and implemented a process (named: Disk Procurement Forecast) to forecast future SQL Server disk space requirements.
• Developed and implemented a process (named: Process Watchdog) by which DBAs are alerted whenever any SQL Server process runs beyond a set threshold.
• Developed and implemented a process (named: Smart Retry) by which failed SQL Agent jobs are handled automatically. Whenever a job fails this process emails detailed cause of the failure and restarts the job, if it failed due to Dead lock, timeout, communication failure, etc.
• Optimized at least 40 stored procedures. These procedures were performing poorly because of frequent or in-frequent recompiles, out of date index statistics, parameter sniffing, DDL and DML inter-leaved, optimizer choosing wrong indices and very complex SQL statement.
• Developed and implemented a process to track obsolete stored procedures. The process identifies stored procedures that are not being used so that these can be cleaned out from the database.
• Developed and implemented a process that monitors missing database backups.
• Developed and implemented a process that monitors missing tape backups (tape backup that backups SQL server database backup files from disk to tape).
• Developed and implemented a process (named: Access Vault) which captures 360 degree of security (including object level permissions) for all logins - SQL, Windows Active Directory group and Windows logins. Information Security team uses this process for SAS 70 certification.
• Formulated SQL Server Disaster Recovery plan.
• Developed 12 SSIS package for development team. Bug fixed SSIS package supplied by SQL Server 2008 performance Data warehouse.
• Upgraded SQL Server 2000 to 2005 to 2008.
• Test and apply SQL Server service packs.
• On day to day all database tasks assigned to me, which includes but not limited to connectivity and performance challenges, SQL Agent job failures, backup failures, adhoc backups, install SQL packages, etc.

Environment: SQL SERVER 2008/2005/2000 , I3-Indepth, NETIQ, Quest LiteSpeed, Windows 2008/2003/XP, IIS, VSS,SVN,C++, Java, SQL Compare

Confidential

Database Architect/ Administrator

Responsibilities:

• Responsible for but not limited to: Database Administration and Development to support the requirements of more than 200 Hedge Fund Clients. Day to day database support and maintenance which included but not limited to: trouble shooting performance, connectivity and data integrity challenges; Database consistency check, index maintenance and backups; Migrating database objects from development to QA to UAT to production environments; Package final product for clients’ installation. SunGard has clients all over the globe. Upgraded SQL Server from 2000 to 2005. Data Modeling: Database Design and changes for the Hedge Fund Application.
• SQL Server development using T-SQL to build Stored Procedures,
• Triggers, Functions, Tables and other objects. Optimized databases, stored Procedures, indexes and other objects using Profiler on VLDB. Evaluated SQL Server 2005.

Environment: SQL SERVER 2000/2005, Windows 2000/2003/XP, IIS, Visual Source Safe(VSS), ASP, VB, SQL Compare

Confidential

Database Administrator

Responsibilities:

• Responsible for but not limited to: Database migration from SQL SERVER 6.5 to SQL SERVER 7.0, Database normalization, protection of data integrity, SQL Server 6.5/7.0/2000 administration. Database security and users permissions.
• Performance needs of the application. Ensured that the database design takes advantage of SQL Server features that improve performance. Achieved a balance between the size of the database and the hardware configuration.
• Extracted, validated, scrubbed, transformed and loaded data into the SQL SERVER 7.0/2000 databases from DB2 and Oracle, Databases maintenance. Optimized databases and SQL servers.

Environment: MS SQL SERVER 6.5/7.0/2000 , VISUAL BASIC 6.0 Active Server Pages, HTML, VBScript, Jscript, Oracle, Visual Studio, Microsoft office, Visual Interdev, IIS, PCANYWHERE and WINDOWS NT 4.0.