SUMMARY:

• Over 7+ years of IT experience on Database Administration and development with MS SQL Server technology.
• Hands on experience in Installation, Configuration and up gradation of SQL Server 2000/2005/2008/2012 technology, service packs and hot fixes.
• Expert in using different recovery models simple, full and bulk - logged depending on availability of database.
• Experienced and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot,Log shipping, and Database Mirroring.
• Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Solid experience in performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Good understanding in implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Expert in automating the system by using SCOM and creating alerts, jobs and maintenance plans.
• Expert in working in Data Center high availability servers.
• Collaborated on numerous management initiatives, including Data Security, Data Management & Data Retention & Resource Tracking, Change Control, and Disaster Recovery Planning, High Availability.
• Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases, file groups, files, transaction logs.
• Experienced in creating and optimizing tables, indexes, schemas, views.
• Extensive experience in managing the Database Security at granular level.
• Hand full of experience in using third party tools like idera, Spotlight, Sql tuner, Sqlexpert, etc.
• Expert in constructing triggers, stored procedures, user functions, views, indexes, user profiles, data dictionaries, and data integrity.
• Worked on SQL 2008 database partitioning for existing large tables, deleting data from partitioning & indexes.
• Worked on setting up CDC (Change Data Capture) for both auditing and Change Transfer to otherdatabase.
• Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing.
• Expert in using MS SQL Server tools SSIS and SSRS.
• Hand full of experience with Very Large Databases (VLDB)
• Expertise in Data Modeling tools such as ERwin, MS Visio, and ER/ Studio Design Tool.
• Expert in logical and physical modeling for OLTP and OLAP applications.
• Ample of experience in data warehousing using star schema and snow flex schema.
• Ample of knowledge in Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).
• Excellent verbal and write communication skills.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Brain Bench certified Database Administrator.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS:

• SQL Server 2000/2005/2008/2012, Windows Server 2000/2003/2008 \R2/2012, T - SQL, MS Access,Visual Studio
• BIDS, Query Analyzer, CDC(Change Data Capture), Database partitioning, DTS, Erwin, SSIS, SSRS, Idera tools
• SQL Profiler, Database Tuning Advisor, Performance Monitor, Client Configuration Utility, Server Configuration Utility
• MS Visio, MS Access, MS Office, HTML, Lite-speed, GRS (Global Resolution Services), Remedy
• ISSAC, DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Power Shell.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SQL server DBA

Responsibilities:

• Fashion and maintain various databases for Production, and in Installation, Configuration and up gradation of SQL Server 2000/2005/2008/2012 technology, service packs and hot fixes using MS SQL Server 2008.
• Responsible and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.
• Responsible for Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Solid hand on performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Responsible for implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Extract, Transform, and Load data (ETL) from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Responsible for Database and Log Backup & Restoration Process, Backup Strategies and Scheduling Backups.
• Responsible for Security Administration- creating users and assigning them roles and privileges.
• Migrating contents from SQL server 2005/2008 to SQL Server 2008 R2 using migration wizard.
• Performance tuning of Queries and Stored Procedures using graphical execution plan, Query analyzer, monitor performance using SQL Server Profiler and Database Engine Tuning Advisor.
• Implemented transactional replication between Primary Server and Read Only servers.
• Experience in configuration of Report Server, Report Manager, Report scheduling, give permissions to different level of users in SSRS 2008/2008R2/2005.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or Network Latency.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Experience in table/index partitioning and full text search and tuning the Production server to get the performance improvement.
• Maintaining both DEV/QA/Test and PRODUCTION Servers in sync. Installed and reviewed SQL server patches as well as service packs.
• Creating Backup strategies and scheduling using third party tool like Lite Speed, as a part of database maintenance plans.
• Created the MS SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Design and configure Database, tables, indexes, store procedures, functions and triggers
• Troubleshot database status, performance, Replication, Log-shipping as well as various errors on production, development and UAT servers.
• Experienced in Point-in-time restoring databases in production and development servers.
• Migrate DTS and SSIS to import and export the data from SQL Servers.
• Monitoring SQL servers for performance ad-hoc and pro-actively
• Design and implement T-SQL Scripts and Stored Procedures and tune up them
• Providing 24/7 supports to SQL application developers in implementing the applications on production server.

Environment: SQL Server 2012(SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, MSSQL Server 2012 Analysis Server), Microsoft Visual studio 2012 MS-Reporting Services, ADO.NET, XML

Confidential, OH

SQL Server DBA

Responsibilities:

• Various databases and server Installation, Configuration and up gradation of SQL Server 2000/2005/2008/2012 technology, service packs and hot fixes using MS SQL Server 2008.
• MS SQL Server 2005. Planning the location of data and Transaction log files on the disk.
• Responsible and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.
• Responsible for Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Solid hands on performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Create and maintain various databases for Production, Development and Testing Servers using Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Responsible for implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Implementing DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or network latency.
• Resolve locking and blocking issues.
• Experience with Database consistency checks using DBCC & Dynamic Management Views using DMV’s
• Experience in table/index partitioning and full text search.
• Tuning the Production server to get the performance improvement.
• Running Index tuning wizard to identify missing indexes.
• Use of Microsoft Diagnostic utilities to take memory dumps and automated traces.
• Implementing and Monitoring SQL Server jobs using custom scripts.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Connecting SQL Server remotely using Terminal services.
• Maintaining both DEV/QA/Test and PRODUCTION Servers in sync.
• Creating users and assigning appropriate permissions.
• Creating Backup strategies and scheduling using third party tool like LiteSpeed, as a part of database maintenance plans.
• Created the MS SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance Tuning for source databases, target databases.
• Maintained BizTalk Application Servers and BizTalk SQL Servers 2008.
• Providing 24*7 supports to SQL application developers in implementing the applications on production server.

Environment: SQL Server (SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, Visual Studio

Confidential, CA

DBA

Responsibilities:

• Install and configure workstation and windows server 2003.
• Installation, Configuration and up gradation of SQL Server 2000/2005/2008/2012 technology, service packs and hot fixes using MS SQL Server 2008.
• MS SQL Server 2005. Planning the location of data and Transaction log files on the disk.
• Responsible and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot,Log shipping, and Database Mirroring.
• Responsible for Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Solid hands on performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Create and maintain various databases for Production, Development and Testing Servers using Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Responsible for implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Implementing DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or network latency.
• Resolve locking and blocking issues.
• Experience with Database consistency checks using DBCC & Dynamic Management Views using DMV’s.
• Desktop/Laptop, Network connectivity support to end users.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• System configuration, update patches, drivers, setup user and administrative accounts, assign permissions and security.
• Provide local and remote help desk support to all staff members, resolving various technical issues
• Maintain and install applications/devices on Local and Wide Area Network level Server 2003 Win XP, MS Office, LAN/WAN & WLAN connectivity, Network Setup, IP configuration(HTTP,TCP/IP,DNS, DHCP and WINS),Network Printer configuration, share files folders.
• Deployment and manage Exchange Server including server backup, email backup and support end users.
• Create and manage Server 2003 security, such as monitoring system performance, Event Viewer log, Firewall, Virus protection, Windows update, Spyware Protection

Environment: SQL Server (SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, Visual Studio