SUMMARY

• Skillful Information Technology DBA with 8+ years of demonstrated expertise in installation, configuration, administration and production server maintenance of MS SQL Server 2005/2008R2 database.
• Solid command of database object creation and modifications, backup/recovery, security administration, troubleshooting, performance monitoring and tuning, database propagation, capacity planning, consultation with developers on technical issues, database design, and systems analysis.
• Strengths include administration, database design, performance analysis, and production support for clustered (VLDB) and complex databases.
• Hands on experience includes administering large and complex databases, database design, normalization, replication, log shipping, full - text indexing, and database application development using varied development tools. Skillfully use DTS in SQL server, performance tuning, application design, hot and cold backups, disaster recovery planning, security management, managing server and clients, T-SQL, stored procedures, functions, cursors and triggers.
• Well versed in database modeling including database architecture, physical and logical data modeling.
• Demonstrated history of SQL server integration services support in 2005/2008R2 in moving DTS packages.
• Successfully gathered data requirements, designed and fine-tuned databases as per the requirement of clients. Excel in providing complete administration of MS SQL Server 2005/2008R2 databases using varied languages including T-SQ, PHP and Pearl.
• Adept in providing 24/7 production database on call support.
• Exceptional capacity to play a key role in business requirements analysis, architecture design, physical and logical data modeling, application development, testing, training, production support and project review with client.
• Able to batch processes and support import, export, backup, and DB Monitoring tools.
• Innovative problem solver skilled formulating new methods of issue resolution for data processing, able to quickly and efficiently uncover and rectify issues, and provide highly effective systems tuning to increase functionality.
• Known for providing a high level of adaptability and flexibility to adjust to changing work positions.
• Adapt quickly to changing environments.

TECHNICAL SKILLS

Operating Systems: MS Win 2K, 2003, XP, Terminal Server, UNIX Sun Solaris, and OS/390, Windows Server 2008

Hardware: IBM Cluster Servers, Dell and Compaq Servers, Dell PERC and IBM raid array controllers, Sun SPARC E3000, EMC Storage, HP Disk Array Management

Database: MS SQL Server 2005/2008R2, 2000, 7.0, 6.5, Oracle 7/8x, 9.2.x, CA-IDMS and Progress

Database Tools: DTS Designer, Enterprise Manager, SQL profiler, SQL

Data Warehouse: OLAP, MS analysis server, Data mining server, Multi dimensional cubes, Star and Snow flake schema, SQL Data Transformation services (DTS)

Reporting Tools: Crystal Reports, Microsoft Reporting Server

SQL Server Tools: SQL profiler, Meta Data services, Microsoft Reporting Server, MS Visio and XML

Software & Application Tools: Mercury interactive Load Runner 6.5, Radview Web load 4.5, Load Balancing servers, MTS and MS BizTalk servers, SCCM

Backup Tools: SQL Backtrack, Legato Networker 6.0 & other Third party tools.

System/Network Monitoring: HP Open View, March NT, Bind view, BMC monitoring tools and TND scheduler

PROFESSIONAL EXPERIENCE

MS SQL Server DBA

Confidential, Montville, NJ

Responsibilities:

• Installed new MS SQL Server 2008/R2 and maintained 6 servers.
• Implemented SQL logins, roles and authentication modes as a part of security policies for various categories of user support.
• Maintained database consistency with DBCC at regular intervals.
• Monitored SQL server performance using profiler to find performance and dead locks.
• Designed and implemented comprehensive backup plan and disaster recovery strategies.
• Monitored and modified performance using execution plans and index tuning.
• Used SQL Server Integration Services in 2008R2 for moving DTS packages.
• Rebuilt indexes at regular intervals for better performance.
• Troubleshot and fine-tuned databases for performance and concurrency.
• Completed documentation about the database.
• Monitored SQL server performance using profiler to find performance and dead-locks and blockings.
• Exported or imported data from other data sources, such as, flat files using import/export of DTS.
• Recovered databases from backup in disasters.
• Analyzed long running slow queries and tuned the same to optimize application and system performance.
• Performed login, user and role administration.
• Wrote stored procedures/transact-SQL scripts and utilized PHP and Pearl commands.
• Created and scheduled jobs, alerts and reports (Excel).
• Altered and re-indexed tables.
• Monitored locks, blocking and other general DBA duties.

Environment: SQL Server 2005/2008R2 with clustering, DTS, T-SQL, Win 2008, Oracle 8i, VB, ASP

MS SQL Server 2005/2008 DBA

Confidential, Chicago, IL

Responsibilities:

• Acted as a DBA in supporting all SQL Servers2005/2008 and RDBM systems in large environments in the data center.
• Installed new MS SQL Server 2008R2 and maintained 12 servers with total size of the database at 5.1 TB.
• Installed MS SQL Server 2008R2 on Win 2008 advanced servers, applied services packs and security fixes in a clustered environment.
• Implemented snapshot replication process for updating servers.
• Performed database capacity planning for Siebel analytics and BizTalk servers.
• Changed location of user and temp database.
• Provided architectural design for database table, indexes, views and stored procedures.
• Implemented SQL logins, roles and authentication modes as a part of security policies for various categories of users and user support.
• Performed administration, database programming, upgrade and database architectural design.
• Played an active role in requirements gathering, blueprint, design, configuration, project reviews with users and sign offs.
• Designed and developed SQL Server Integration Services (SSIS) for data migration.
• Implemented data partitioning for new SQL server 2008R2 databases, namely, created partition function, partition scheme mapped to a partition function and created the table on the partition scheme.
• Developed T-SQL stored procedures as a part of database maintenance plan for new SQL Server 2008R2.
• Performed all aspect of database administration, including backup, recovery, proactive maintenance, identify blocking transactions, archive/purge data and replication for SQL 2008R2.
• Migrated database from Oracle to MS SQL Server 2008R2.
• Migrated database from MS Access to SQL Server 2008R2.
• Developed and enhanced custom queries extracting data from source system and wrote required enhancements on existing DTS packages.
• Conducted database design and capacity planning.
• Rebuilt indexes at regular intervals for better performance.
• Designed and implemented comprehensive backup plan and implemented disaster recovery strategies.
• Tuned SQL queries and stored procedures using SQL profiler and index tuning wizard.
• Scheduled jobs and alerts using SQL server agent.
• Used system stored procedures and DBCC commands.
• Conducted database and log backups and restoration, backup strategies, and scheduling.
• Performed backups, backed up master and system databases and restored them.

Environment: MS SQL Server 2005/2008R2, T-SQL, Win 2008, DTS, Oracle 9i, VB, ASP, SAP R/3,XSL, XML Web Services, JavaScript, CSS, IIS 6 and MS SQL Reporting Services

MS SQL Server 2005 DBA

Confidential, Wilmington, PA

Responsibilities:

• Installed new MS SQL Server 2005 for SAP and maintained 10 clustered servers with size of the db at 3.5 TB.
• Migrated database from Access to SQL server 2005.
• Implemented SQL logins, roles and authentication modes as a part of security policies for various categories of user support.
• Designed and developed SQL Server Integration Services (SSIS) for data migration.
• Designed and developed reports using reporting services on MS SQL 2000/2005 platform.
• Implemented database maintenance plan for new MS SQL server 2005 databases.
• Implemented data partitioning for new MS SQL Server 2005 databases and created partition function, partition scheme mapped to a partition function and created the table on the partition scheme.
• Restructured the stored procedure, designed, coded and developed the same using the MS SQL Server Integration services (SSIS).
• Prepared ad-hoc reports using MS SQL server reporting services.
• Set up alerts, operators, SQL mail, SQL agent mail, and notifications.
• Set up and scheduled jobs that performed backups and database structure checks.
• Monitored MS SQL servers for errors and performance degradation.
• Performed all aspects of database administration, including backup, recovery, and replication for MS SQL server 2005.
• Coordinated with SQL Server Integration Services in 2005 for moving DTS packages.
• Troubleshot and fine-tuned databases for its performance and concurrency.
• Exported and imported data from other data sources, such as, flat files using import/export of DTS.
• Maintained database consistency with DMV’s/DMF’s at regular intervals.
• Analyzed some of the long running slow queries and tuned the same to optimize application and system performance.
• Migrated database object using SSMA (SQL Server Migration Assistant).
• Conducted database upgrade planning from SQL server 2000 to SQL server 2005.

Environment: MS SQL Server 2005, SSIS, SSAS, SSRS, T-SQL, DTS, Win2003, Oracle 8i, VB, ASP, SAP

MS SQL Server DBA

Confidential, Baskin Ridge, NJ

Responsibilities:

• Installed new MS SQL Server 2000 and maintained 21 servers.
• Implemented SQL logins, roles and authentication modes as a part of security policies for various categories of user support.
• Maintained database consistency with DBCC at regular intervals.
• Monitored SQL server performance using profiler to find performance and dead locks.
• Designed and implemented comprehensive backup plan and disaster recovery strategies.
• Monitored and modified performance using execution plans and index tuning.
• Supported SQL Server DTS packages.
• Rebuilt indexes at regular intervals for better performance.
• Troubleshot and fine-tuned databases for performance and concurrency.
• Completed database documentation.
• Monitored SQL server performance using profiler to find performance and dead locks and blockings.
• Exported or imported data from other data sources, such as, flat files using import/export of DTS.
• Recovered databases from backup in disasters.
• Analyzed long running slow queries and tuned to optimize application and system performance.
• Performed login/user/role administration.
• Wrote Stored Procedures/transact SQL scripts.
• Utilized DBCC commands.
• Created and scheduled jobs, alerts and reports (Excel).
• Altered and re-indexed tables.
• Monitored locks, blocking and other general DBA duties.

Environment: MS SQL Server 2000 with clustering, T-SQL, Win 2003, Oracle 8i, Visual Basic 6.0, ASP

System Administrator

Confidential 

Responsibilities:

• Acted as the primary customer contact until requests were closed.
• Received, logged and prioritized all services requests from external and internal customers.
• Developed strong partnership with customers.
• Established repeatable processes for delivery of technical services.
• Coached technical service employees to develop businesslike working habits.
• Maintained consistent technical support quality on a first call basis during scheduled support hours.
• Coordinated with other department managers to improve cross-department processes and procedures.
• Projected internal purchase requirements for hardware and software to ensure internal productivity.
• Provided administrative and technical support services for a UNIX, Novell Netware, and Windows NT local and global networks.
• Performed system management activities including tape backup management, disk storage management, and user management.
• Installed, maintained and troubleshot standard application load set for various sizes of client companies.
• Scripted automation tools for system maintenance/monitoring activities.
• Implemented disaster recovery and backup recovery plans.
• Assisted application developers in applying DBMS technology and participated in logical and physical database design.
• Assisted in documenting database strategies and architectures, and participated in tool evaluation.
• Monitored and troubleshot network inconsistencies.
• Configured and installed of Cisco routers, routing protocols and firewalls.
• Performed basic to intermediate diagnostics for system and network performance.
• Organized and implemented network infrastructure upgrades, enhancements and new releases of applications.
• Escalated requests that required additional attention to the appropriate internal group.

Environment: Windows NT/2000, SQL Server, Novell Netware