SUMMARY

• Skillful Information Technology DBA with 7+ 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.
• Datamigrationand integration experience, Solid experience in the migration of SQL
• 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.
• Knowledge of HTTP, HTTPS, TCP/IP, SMTP, DNS, SSH, TELNET, SNMP, FTP
• Adept in providing 24/7 production database on call support.
• Good exposure to MS SQL Server 2012.
• 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.
• Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with .NET, Import/Export data, Bulk insert and BCP
• Experience in Data Loading, ETL process and Supported Cube Processing in SSAS and Transferred data to Data Warehouse Environment (ETL) using SSIS.
• 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, Microsoft Dynamics, SharePoint,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

Data Modeling: Dimensional Data, Erwin, ER/Studio, Visio, Star Schema, Snowflake, Tables, Physical and Logical

PROFESSIONAL EXPERIENCE

Confidential, Des moines, IA

MS SQL Server DBA

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.
• Configured and troubleshooting replication, log shipping, mirroring, clustering and databasemaintenance jobs.
• 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.
• Involved deploying of Cubes, SSIS packages and report for different groups.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2005/2008R2 with clustering, SSIS, SSRS, ETL,Java, VB Scripts,HTML, TFS,DHTML, XHTML DTS, T-SQL, Win 2008, Oracle 8i, VB, ASP

Confidential, Philadelphia, PA

MS SQL Server 2005/2008 DBA

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.
• Responsible for transferring packages using SSIS and transferring SQl Server Objects from QA to Production Using SSIS Packages.
• Worked on SQL Server Reporting Services (SSRS), drill down, parameterized reports, and cascading reports deployed them on Report server from Report Manager.
• 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, SSRS, Oracle 9i, VB.Net, CVS,ASP, SAP R/3,XSL, XML Web Services, AJAX, JavaScript, Power Shell, Perl Scripting, CSS, IIS 6, NET Framework, IIS 6.0, Log Shipping, Clustering, Mirroring, and MS SQL Reporting Services

Confidential, Los Angeles, CA

MS SQL Server 2005 DBA

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.
• Extensively used ETL and SSIS tool to load data from Excel spreadsheets, flat files, and xml files into the target SQL Server database.
• 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.
• Developed various reports and reporting interfaces utilizing Microsoft SQL Reporting Services (SSRS) and deploying them on Report Server using Report Manager.
• 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, AJAX, T-SQL, IIS 6.0, Perl Scripting, DTS, Win2003, Oracle 8i, VB, ASP, SAP

Confidential, Annapolis, Maryland

MS SQL Server DBA/ Developer

Responsibilities:

• Installed and maintained MS SQL Server 2000.
• 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.
• Transferred SQL Server Objects from QA to Production Using SSIS Packages.
• 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.
• Configured Reporting Server Using Reporting Services Configuration Tool and created and Deployed Reports using SQL Server Reporting Services (SSRS).
• Fixing bugs that are Assigned from TFS(Team Foundation Server)
• 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, SSRS, SSIS, T-SQL, Win 2003, TFS, Oracle 8i, Visual Basic 6.0, ASP.

Confidential

SQL Server Developer/Programmer

Responsibilities:

• Creating and Managing of database objects like Tables, views, indexes etc.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files
• Creation and management of Database maintenance plan for various database consistency checks.
• Wrote SQL stored procedures to implement business logic.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Documented daily tasks & operations
• Employing indexing strategies and optimizing them using SQL Profiler and Index Tuning Wizard.
• Created stored procedures, scripts, tested them on the test servers and moved them to Stage before deploying on production.

Environment: SQL Server 7.0/ 2000, Enterprise Manager, Query Analyzer, Windows 2000 Server, SQL Profiler, DTS, T-SQL, BCP.