SUMMARY

• Over 8+ years of SQL Server DBA experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2012, 2008, 2005, 2000 in Production (24x7), Testing, Development, Replication & Cluster Server Environments.
• Expertise in Security Issues such as creating logins and granting permissions on various objects as well as Administering security for servers logins regularly (Windows and SQL Accounts) and guest user logins.
• Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in implementing of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Excellent T - SQL Programming skills, Execution Plan, query optimization & performance tuning. Used SQL Profiler, Performance Monitor and DBCC Commands.
• Hands on Experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
• Experience in Query Optimization, Re-Indexing, Updating Statistics, tuning Stored Procedures and performing Maintenance Tasks.
• Created maintenance plans to perform index defragmentation, re-indexing and update the index statistics.
• Experience working with DTS Packages, migrating DTS packages.
• Working on SSIS Package performance Improvements by analyzing various attributes of package and Dataflow task buffer tuning.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.
• Experience in Using Performance Monitor/Profiler to resolve Dead Locks/Long Running Queries and to resolve System Hardware bottlenecks.
• Expert in Database migration and up gradation from MS SQL Server 2000 to MS SQL Server 2005, MS SQL Server 2005 to MS SQL Server 2008, and MS SQL Server 2008 to MS SQL Server 2012.
• Experience with Reporting Services SSRS and Analysis Services SSAS .
• Worked extensively in OLTP & OLAP environments that included Production (24x7), QA and database development in SQL Server.
• Good Knowledge in operating third party tools efficiently like TOAD, VERITAS Netbackup, LiteSpeed Pervasive ETL, SQL Assistant, ArcSDE, ERWIN, Visio 2007, Red-Gate and Spotlight.
• Good experience with the entire phases of Software Development Life Cycle (SDLC)
• Experience in working with Production support 24x7.
• Worked closely with development and Technical Support team to resolve quality issues.
• Very good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.
• Designed various approaches like CDC (Change data capture), Auditing control Recovery strategy, Scheduling jobs etc.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008/2005/2000/7.0 , MS-Access 2000/2003/2007 , My SQL4/5Oracle 9i/10g

Operating Systems: Windows NT/ Windows 2000 Advanced Server / Enterprise Server 2003 / Windows XP / Standard, Windows Vista / 7 / 8.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSASSSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: C#, ASP.NET, XML, PL/SQL, T-SQL

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAPOLTP.

ETL: SSIS, SSRS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, RedgateSQL compare, Lite speed.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SQL Server DBA

Responsibilities:

• Installed SQL 2008 standard edition with SP1 for testing present application and migrating test databases to test any upgrade issues.
• Installed and configured ArcSDE layer for using ArcGIS applications like ArcMap, ArcView to work with SQL server by creating geodatabase repository in SQL server.
• Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting, and other tasks as assigned or expected from DBAs.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Responsible for all major database components of SQL Server and has strong knowledge of the various interrelationships between major system components including networking, storage, server, operating system, cluster, authentication, application code, and disaster recovery technology.
• Involved in Data modeling, designing and building relational databases using Erwin tool. Product enhancements, and other technical issues related to the SQL Server components being administered.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Creating batch scripts for providing smooth solution to the ETL process.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space and implemented an e-mail notification solution to be notified when a threshold or error is encountered.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Environment: MS SQL Server 2008, Windows 2000/2003 servers, Active Directory, IBEAM, Oracle, ArcGIS server, Arc SDE, Pervasive ETL tool, Titanium Application, Outlook Express, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services, diagnostic Manager, Microsoft Reporting Services, Microsoft SQL Server Integration Services (SSIS), SSRS, Litespeed, TOAD, DTS Xchange, Oracle APEX.

Confidential, Hartford, CT

SQL Server DBA

Responsibilities:

• Involved in installation of SQL Server 2000 and 2005, Configuration and Maintenance.
• Involved in Data modeling, designing and building relational databases.
• Created various Cubes and Dimensions for SSAS project. Worked with ASCMD command line utility for SSAS.
• Verify, maintain & troubleshoot database backups, integrity checks and scheduled jobs.
• Wrote triggers, stored Procedure, scripts, cursors for the bulk application, tested them on the test servers and moved them to the production.
• Creating and managing schema objects such as tables, views, index, and procedures.
• Involved in side by side migration from .
• Upgraded SQL Server 2000 to SQL Server 2005 on DEV and Testing Environment.
• Worked on Development of system maintenance tasks such as Database Backup & Recovery, replication and apply in Dev and Testing Environment.
• Assigned permission to user(s), roles), and object. Administrate security for server logins (Windows and SQL Accounts).
• Installation of Replication Server, Configuration and Monitoring the replication, implemented Transactional Replication, Merge and Snapshot, writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
• Upgraded DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
• Supported Development Team in deploying and testing the application, which uses SQL Server backend.
• Daily monitoring of the database performance, Dead lock and network issues.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Provided 24x7 dedicated support to all Production and development servers.

Environment: Microsoft Windows Server 2003, XP, Vista Microsoft SQL Server 2000/2005 Enterprise Edition, Microsoft Visual Studio 2005, VB 6, ADO, Active directory, ISA 2004, IIS, Net Framework 2, MS Access, Oracle, Oracle Apex, Query Analyzer, Event Viewer, Database Maintenance Plan Wizard, MOM SSIS, SSRS, Crystal Reports, Visio2007, Spotlight.

Confidential, Mt Laurel, NJ

SQL Server DBA/Developer

Responsibilities:

• Created, modified stored procedures, Triggers, and Views.
• Maintaining jobs for data massaging from production server to Business Objects server.
• Involved in generating daily reports for financial and marketing team.
• Created and managed the database and objects.
• Customization of DTS workflow thought active x task.
• Managed and coordinate with remote user for change request and optimization of application.
• Management and maintenance of data, including backups, data fixes, replication, restoration and high availability of operational systems
• Configuration and management of security of company SQL servers, including troubleshooting
• DTS for Import from Oracle & Excel for Analysis server.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Ability to write SQL scripts. Hands-on experience with disaster recovery techniques and database failure contingency planning.
• Monitoring SQL Server, at the physical server and database layer.
• Significant experience in database redundancy strategies, and disaster recovery (Data Mirroring, Replication, Log Shipping, Clustering).
• Windows 2003 multi-node clustering. Experience with transactional replication required Experience with MS BI Stack SSIS, SSRS and SSAS.
• Responsible for fine tuning of the database, trouble shooting, user administration, memory management, and running DBCC.
• Involved in Performance tuning and Query Optimization.

Environment: Windows 2000 Advanced Server, Active Directory, MS SQL Server 2000, Excel Objects, Oracle, MS Projects, DB2, Unix, Erwin.

Confidential, PA

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2000/2005 components in Development, and UAT, Integration, Performance testing, UAT/Training and Production environments.
• Installing and configuring Windows 2003 fail over cluster for SQL 2000/2005.
• Administration of Clustered SQL servers in 24x7 Windows data center environment.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Managing Log Shipping for hot standby computers.
• Implemented in Linked Server setup.
• Managing Replication of Data (Snapshot, Transactional, Merge method used).
• Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting.
• Designing and managing SQL DTS packages.
• Involved in Cluster implementation and Migrated SQL .
• Developing SQL stored procedures, views and triggers.
• Designing, testing and implementing DTS packages.
• Design and documentation of operational specifications of the system.
• Verifying the new database code meets company standards for readability, reliability, and performance.
• Monitoring Server Level Blocks/deadlocks.

Environment: Windows 2000 Advanced server and Enterprise Server 2003, MS SQL Server 2000/2005, TSQL, Microsoft Integration Services SSIS, Microsoft Reporting Services SSRS .

Confidential, Madison, NJ

SQL Server DBA/Developer

Responsibilities:

• Monitored and maintained over 6 SQL Servers in Production, QA, Test and Development Environments.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Imported Data from Text files and Excel Spread sheet into SQL Server 2000 database using DTS package.
• Creating and maintaining documentation including data dictionary. Installation and maintenance of DBMS software and connectivity to client tool.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Change management ensuring all changes are tested, communicated, approved, and documented.
• Setting up logical/physical backups for the databases.
• Create packages, procedures, functions, triggers, and handle database performance with tuning.
• Implemented replication model like Merge, Transactional and Snapshot.
• Demonstrating Communication skills and leadership ability. Previous marketing and/or CRM expertise a plus. Demonstrating project management skills.
• Backed up system and user databases related to Merge, Transactional and Snapshot Replication.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle and DB2.
• Participating in 24x7 on-call rotation. Good analytical and troubleshooting skills required. Been a good team player with good communication skills and a can do attitude.
• Managing Logins, Users, Roles and User permissions.

Environment: SQL Server 2000/2005, SSIS, SSRS, SSAS, T-SQLMOM, IIS, Oracle, Active Directory, ISA 2004, MTS & Windows 2000, 2003, MS Access, MS Excel, Teradata, VB.Net, DB2, TOAD, LITESPEED, Erwin, Spotlight.

Confidential

Principle SQL DBA 24x7 Production support

Responsibilities:

• Responsible for Logical & Physical Database Design.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Creation of New NT Logins and granting privileges to users/Groups and objects.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Backup and recovery of Master, MSDB and Application databases.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current.
• Implemented log shipping and performed changing roles when production data base goes down.
• Responsible for Query optimization and Performance tuning.
• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users applications.
• Worked extensively on DTS Package designs for Import/Export from various Data Source Flat file, Excel, MS Access to MS SQL Server and schedule the jobs in SQL Server.
• Implemented in Linked Server setup, which allows access to the distributed, heterogeneous queries against OLE DB data sources for EXCEL, MS ACCESS, Text files.
• Provide 24x7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers with Maximum Database Availability, Reliability & Investigate and resolve any Database.
• Related issues /performance related issues with Minimal Downtime & Maximum Reliability.
• Responsible for deployment from development to test, UAT and production environments.

Environment: SQL Server 2000, 2005, T-SQL, Excel, Advanced Windows 2003 Server & PVCS Version Control Management.