SUMMARY

• Over 7+ years of extensive experience in database design, development and administration with MS SQL Server 2012/2008/2005/2000 using SSIS, SSAS, SSRS in different industries.
• Highly experienced in Database Designing, Implementation and System Administration using Microsoft SQL Server as well as Windows 2003, 2008 & 2012
• Experience using Performance Monitor/Profiler to solve Dead Locks, long running queries.
• Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
• Experience in Data Migration by using side - by-side upgrade process Management.
• Experience in implementing SQL Server security and Object permissions.
• Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions.
• Expertise in implementing and maintaining efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive) and database mirroring
• Good experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC.
• Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace, DTA.
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Expertise in Identifying the Bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
• Extensive experience in T-SQL for developing complex Scripts, Batches, Stored Procedures, Cursor, Triggers, Tables, Views, User Defined Functions, Data Integrity, and SQL joins.
• Experience in ETL between Homogenous and Heterogeneous System (Oracle/DB2/Access/Excel/CSV/XML) using SQL tools (SSIS, DTS, Bulk Insert, BCP) and providing a definite solution.
• Oracle DBA activities include but not limited to Installation, configuration, importing/exporting, migration, patch installs capacity planning, DBMS SCHEDULER, DBMS JOBS, backup and recovery of mission critical databases and data files using command line syntax as well as Oracle RMAN, and Performance Tuning of databases.
• Experience in creating several Master-Child report (drill-down, matrix, tabular, linked, sub-report) model for Monthly/Quarterly client reporting system on SSRS Crystal reports.
• Knowledge of SQL Server Database Administration tasks such as planning, scheduling jobs, backup and recovery strategies, index tuning and performance tuning, and archiving data.
• Experience in monitoring SQL server, capturing performance problem and improve performance by tuning Databases.
• Experience in creating and maintaining Backup and Restore, Mirroring and Log-Shipping strategy as a part of Disaster recovery.
• Excellent in Capacity Planning and storage management.
• Excellent analytical and communication skills with 24/7 rotated support experience.

TECHNICAL SKILLS

Database: MS SQL Server 2000/2005/2008/2012 , Oracle 10g/11g, My SQL

Language: T-SQL, PL/SQL, C#, Java, SSAS, SSRS, SSIS

Server: Windows Server 2000/2003/2008/2012 , Unix, Linux

DB Tools: LiteSpeed (Backup Tools), SQL native Monitoring tools, NT Performance monitor/System monitor, TSQL, SQL Profiler and SQL Query Analyzer, SQL Server Management Studio

Reporting Tools: Crystal Reports, BID, SQL Server Report Builder, Visual Studio

Data Migration: MSDTS, SSIS, ETL, BCP, Data Migration, Import/Export Wizard, SSMA

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL server DBA

Responsibility:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2008
• Installed, upgrade, and configuration of MS SQL Server 2005/2008/2008 R2 and MS SQL Client clustered and stand-alone environments.
• Worked on Client/Server tools SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Estimation and Monitoring Space requirements for databases and log files.
• Planned the Complete Back up Database and restored the Database from Backups.
• Managed security of SQL logins, roles and user accounts; Grant/revoke permissions for table, view, sp, etc.
• Performance monitoring of baseline and daily usage of SQL resources including processor, memory, disk I/O, paging, cache, locking and blocking, etc.
• Creating Stored Procedures, Triggers, Functions, and Jobs for all databases.
• Responsible for Design, Implementation and Performance Tuning of the databases.
• Develop Database Backup, scripts and automated this process.
• Implementation and Administration of Data Replication and Disaster Recovery management Process.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes and update database statistics weekly for fixed data corruption in application databases.
• Scheduled Jobs, batch, alert and E-mail notification settings.
• Working in test server with SQL 2008 R2/2005 for research and testing data before migrate to production.
• Work for enabling/disabling the script, trigger etc.
• Responsible for SQL Server Database administration and production support.
• Work on Active Directory for user permission/access/creations etc.
• Monitor the process for maximum optimization by 3rd party tools.
• Use Idera SQL Management Tool and other 3rd party software for Database space management, alert management, and performance monitor database services on travel or on leave from anywhere.
• Upgrade and consolidation for application and database and DR environment implementation etc.
• Worked with the closed liaison with Business unit, application user and lead to provide different type of support like password reset, user logins create, provide different object permission to make sure application is operating well.
• Meeting with server engineers, network engineers, application support team etc. for project related solution and production support needs.
• Used bcp utilities, Data Transformation Services (DTS), SSIS an Extract Transform Loading (ETL) tool to populate data from various data sources, created packages for different data loading operations for application.
• Implemented backup and retention strategies based on business policies and DB maintenance plans for DB optimization.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeeded.
• Update and generate script files of the databases whenever changes were made to sp/views/tables.
• Using DBAtrisan tool for performing administrative task for both MS SQL and Oracle servers.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Using performance dashboard and Idera SQL Management for resource utilization like disk space used in percentage etc.
• Work with Business unit for auditing quarterly user access review.

Confidential, VT

SQL server DBA

Responsibility:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2008
• 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.
• Performed all types of Oracle DBA activities including Installation, configuration, importing/exporting, migration, patch installs capacity planning, DBMS SCHEDULER, DBMS JOBS, backup and recovery of mission critical databases and data files using command line syntax as well as Oracle RMAN, and Performance Tuning of databases.
• 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: s: 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, CA

SQL Server DBA

Responsibility:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2005. Planning the location of data and Transaction log files on the disk.
• Install and configure SQL Server 2005/ 2008 on the server and client machines.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• F 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.
• Providing 24*7 supports to SQL application developers in implementing the applications on production server.
• 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.

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

Confidential

System Analyst

Responsibility:

• Install and configure workstation and windows server 2003.
• 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: s: SQL Server (SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, Visual Studio