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/2012 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.
• Experience in implementing different types of Replication Models like Snapshot and Transactional.
• Well versed in database modeling including database architecture, physical and logical data modeling.
• Excellent knowledge with SQL Server Storage Structures and security Architecture residing databases on SAN storage.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Demonstrated history of SQL server integration services support in 2005/2008R2/2012 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/2012 databases using varied languages including T-SQL, PHP and Pearl.
• Hands on experience working with High Volume Databases which sizes > 5 TB.
• Provided Oracle/MS SQL Server DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data warehouse. Wrote highly complex SQL, UNIX shell and PL/SQL scripting involving reviewing and tuning SQL and PL/SQL code, triggers & stored procedure to finish the project on time and save the organization cost
• 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.
• Experience in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Experience with Performance Monitor, SQL Profiler, Quest Foglight and Quest Spotlight tools to monitor SQL Server Performance and to generate Performance reports.
• 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.
• Supported the deployment of SQL Server 2005/2008, SSAS (Analysis Service), SSRS (Reporting Service) and SSIS (Integration Service for ETL activities).
• 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/2012, 2000, 7.0, 6.5, Oracle 7/8x, 9.2.x,10g CA-IDMS and Progress.

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

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

Version Control: Visual SourceSafe (VSS), Team Foundation Server (TFS).

Software & Application Tools: Quest Spotlight, Quest Fog light, Confio Ignite, Mercury interactive Load Runner 6.5, Radview Web load 4.5, Load Balancing servers, Light speed, Idera SQL Safe\Diagnostic Manager MTS and MS BizTalk servers, SCCM, ERWIN.

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

Technical Skills: T SQL, Pl/SQL, CSS, HTML, JSP, Java Script, jQuery, DHTML, XML, Ajax

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

Sr MS SQL Server DBA/Developer

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Migrating Databases from SQL Server 2005 to SQL Server 2014.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.

Confidential, Bartlesville, OK

Sr MS SQL Server DBA/Developer

Responsibilities:

• Responsible for maintaining over 200 SQL Servers, out of which 175 are production Servers.
• Installed SQL Server 2012 Cluster and configured ‘Always On’.
• Installed different versions of SQL Server in a Clustered (Active/Active and Active/Passive clusters on SAN technology) and Non Clustered Environment
• Rebuilding /monitoring the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Extensively worked on Dynamic Management Views (DMV) in SQL Server 2008R2
• Checking Database Health by using DBCC Commands and DMVS.
• Created SSIS Packages for cleaning and Loading the Business data into the Data-warehouse.
• Managed the Log Shipping and Transactional Replication of all production environments
• Monitor daily tasks including backup and restore by using SQL Server 2005 and SQL Server 2008R2 tools like SQL Server Management Studio, using Maintenance plan.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• Working in SharePoint 2010, creating users, adding links, removing links, assigning users to a group.
• Monitoring the servers using RedGate.
• Prepared Data Flow Diagram (DFD's) & Entity Relationship(ER) diagrams.
• Writing and restructuring the store procedure using the T-SQL Programming.
• Got a good knowledge on Team Foundation Services (TFS) which we use to maintain databases up to date and we also use TFS for storage of updated scripts and also to avoid the data loss.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Monitored the Performance of the SQL Server by using Confio Ignite and Quest Foglight.
• Re-engineering Customer Cognos and People Soft modules into SQL Server 2005 Integration Services (SSIS).
• 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) in Business intelligence development studio (BIDS).
• Worked on mirroring the databases for local servers of my team to keep the data up to date in between my team members. Without disturbing the whole environment by updating the scripts in TFS server.
• Ensure the latest service packs, security patches; virus definitions, device drivers etc. are applied.
• Testing, deploying and integration of new systems and upgrades prior to deployment
• Knowledge on backup jobs on weekly basis and we store the back file in tapes and storages devices like TFS.
• To set up SQL Server configuration settings for better server management.
• 24 x 7 Production Database on Call Support
• Document SQL Server Implementations and server issues, and resolutions.

Environment: SQL Server 2008/2008 R2/2012 Enterprise Edition, Windows Server 2008 R2 Enterprise edition, Idera SQL safe Manager, SSIS, BizTalk Server 2010, SharePoint Server 2007/2010, Dell PowerEdge R900, System Center Operation Manager(SCOM)2012, Asp.Net 4.5, C#, Vb.Net, Cloud Services, SQL Server Azure, Windows AZURE, ERWIN, IIS 7.0, Visual Studio 2010 & TFS.

Confidential, Des Moines, IA

Sr MS SQL Server DBA/Developer

Responsibilities:

• Maintaining over 400 Instances of SQL Server which include SQL /2005.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Installed new MS SQL Server 2008/R2/2012 and maintained 6 servers.
• Implemented SQL logins, roles and authentication modes as a part of security policies for various categories of user support.
• Analyze and troubleshoot problems related to SQL Server Environment.
• Performed upgrades from SQL Server 2005 to SQL Server 2008 and applied Service Packs on them.
• Optimized, automated and redesigned a cost accounting system from Oracle Forms 3.0/Korn Shell to the Web using Perl 5, Oraperl and PL/SQL.
• Designed and implemented a web based solution in Perl and DBI: DBD for capturing and reporting metrics from STATSPACK, Database Resource Manager, Shared Server Architecture(formerly known as Mutli-Threaded Server), latching and wait event statistics and the efficiency of the Shared Pool.
• Excellent knowledge with SQL Server Storage Structures and security Architecture residing databases on SAN storage.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Involved in Architecture, Design, Management, Support, Troubleshooting of SharePoint environment.
• Experience in implementing different types of Replication Models like Merge and Transactional.
• Developed BI solutions that integrated SharePoint, SS Analysis Services, SS Reporting Services, SS Integration Services and Dashboards for enterprise consumption.
• Determine appropriate risk levels of Vendors, and categorize Line of Business payments based on existing rules. Then write queries to pull global Spend data for analysis, based on manually entered data, categorized by department.
• Working with System Center Operation Manager(SCOM) to monitor server across all the domains.
• Monitored the Performance of the SQL Server by using SQL Profiler, Quest Foglight and Quest Spotlight.
• Redesigned a thorough backup and recovery strategy for all major production systems. This initiative involved the design and development of several UNIX shell scripts used for both physical and logical backups.
• Created SQL Server maintenance plans for Disaster recovery planning.
• Maintained database consistency with DBCC at regular intervals.
• Involved in migrating SQL Server Databases from Development to Production Server.
• Migrated databases and database objects between multiple servers across production.
• Monitored SQL server performance using profiler to find performance and dead locks.
• Oversaw servers’ performance, wrote batch and shell scripts, and solved many technical problems in security management, patching, performance monitoring and disc administration
• Designed various approaches like CDC (Change data capture), Auditing control, Recovery strategy, Scheduling jobs.
• Created SSIS packages to move data from SQL Server 2005 to SQL Server 2008 R2.
• Batch job support, Creating batch jobs for the retail business use.
• Implemented an OLAP Data warehouse to Create BI reports using Crystal Reports& Excel for Multi-Million dollar Arbitration.
• Monitored Log shipping/Transactional Replication and trouble shooting of errors.
• 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.
• Has started, stopped, paused, resumed and restarted the BizTalk Server Services.
• 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.
• Work with the development teams and setup test and QA systems as per the project specifications and grant access to the development teams.
• Monitored locks, blocking and other general DBA duties.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• 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).
• Provide 24x7 on-call support services to the application databases in production.

Environment: SQL Server 2005/2008R2/2012 with clustering, SSIS, SSRS, Composite Software, Oracle 9i, 10g, 11g, MS SharePoint (MOSS 2K3, 2K7 & WSS 2.0, 3.0), DTS, T-SQL, System Center Operation Manager(SCOM), Erwin, Cloud Services, SQL Server Azure, Windows AZURE, Win 2008, LDAP Server, Biz Talk Server 2007, Oracle 8i, VB.Net, ASP, TFS.

Confidential, Philadelphia, PA

Sr 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 in a Clustered (Active/Active and Active/Passive clusters on SAN technology) and Non Clustered Environment
• Implemented snapshot replication process for updating servers.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• Performed database capacity planning for Siebel analytics and BizTalk servers.
• Created SharePoint Global Knowledgebase for Sys Admins, Field Service, Networking, and Help Desk as part of ShareTran - streamlining trouble ticket resolution, asset management, and increased SLA standards.
• Changed location of user and temp database.
• Setting up and Monitored transactional replication, Database mirroring on Production servers.
• Migrated data from different databases and also from lower to higher environments and maintained batch files.
• Maintaining batch procedures up to date with latest changes.
• Developed complex Stored Procedures, triggers, views and other necessary T-SQL batch scripts for Database administration purpose.
• Created extensive reports using SSRS ( Tabular, Matrix ).
• Support multiple SQL Server databases in both clustered and non-clustered environments with replication/DTS, pulling data from UNIX each night. Troubleshoot issues within a clustered server configuration.
• Developed the strategies like CDC (Change Data Capture), Auditing, Recovery Strategy etc.
• 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 data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives (Used report services as and OLAP client schedule reporting tool ).
• Hands on experience in understanding of BizTalk architecture and supporting the behavior of BizTalk Server Host Instances during SQL Server Failover.
• 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 with clustering, Biz Talk 2009, T-SQL, Win 2008, DTS, SSRS, MS Sharepoint, Oracle 9i, DB2, Teradata, C#, VB.Net, ASP.Net 3.0/3.5, SAP R/3,XSL, XML Web Services, JavaScript, CSS, IIS 6 and MS SQL Reporting Services, Red Hat Linux

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. using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Monitor and Troubleshoot of Performance Issue like Long Running / High Insensitive Queries using and SCOM alerts
• 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, T-SQL, DTS, Win2003, Oracle 8i, Teradata, My SQL, C#, MS Visual Studio VB.Net, ASP.Net 3.0, HTML, Java Script, CSS, SAP, Linux.

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).
• 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, Oracle 8i, Visual Basic 6.0, ASP, Java, J2EE, JSP, HTML, CSS, Java Script, UNIX Shell Scripting.

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, Java, j2EE, JSP, HTML, BCP, Unix Shell Scripting.