SUMMARY

• 9+ years Experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server also specialize in MS SQL Server 2012/2008/2005/2000 across various Client Server/mission critical Environments.
• Experience in RDBMS database design, performance tuning, Optimization, backup and recovery in SQLServer2000 andSQLServer 2005/2008/2012 .
• Experience in Data Extraction, Transforming and Loading (ETL) from Heterogeneous sources like Excel, MS Access, XML, Oracle, and DB2 to MS SQL Server using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in migration of Databases from SQL Server 2000/2005 to SQL Server 2008/2012 and troubleshooting migration issues on both 32 - bit and 64-bit Environments.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Experience in Configuration, Upgrades migrations, High Availability, Security Administration, Database Development and data modeling across various Clustered/Stand-Alone Database environments.
• Designed and developed tables, functions, Complex queries, stored procedures and triggers.
• Installation, Configuration & Administration of SSRS 2000/2005, SSIS, SSAS, Legacy Components, and Feature packs.
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Experience in Database administration activities for DB Security (creating logins, users, roles and assigning permission to them).
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Extensive in Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managingserverand clients.
• Good knowledge on Advanced features like MSDTC, and Full Text Indexing etc. Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQLServer and failover clustering.
• Experience in Performance& Query Tuning using SQL Profiler, Perf-Mon, and Index Tuning Wizard (2000), Database upgrade advisor (DTA 2005), PSSDIAG’s, SPOTLIGHT, Deadlock Analyzer and various DBCC utilities.
• Configuring Replication (Merge, Transactional & Snapshot) to replicate data to regional and remote servers and troubleshooting Replication issues.
• Expert in using Bulk Copy Program (BCP).
• Experience in Working with Production 24/7, Disaster Recovery, Development and UAT Environments.
• Experience in Database Backup & Restore methodologies using Maintenance Plans, SQL Lite-speed
• Expertise in Performance tuning - DTA (Data Tuning Advisor), Indexing, profiler trace and locking scenarios.
• Expertise in SQL Server Agent and SQL Server Profiler.
• Expertise in creating Backups & restoring of databases and devise strategy for Backups, recovery & fine-tuning.
• Expertise in creating, implementing and scheduling Jobs.
• Creation of Application Roles for a particular database security imposition by creation and granting of roles and privileges, performance tuning, backups & tuning of T-SQL statements.
• Plan, implement, test and document backup and recovery procedures. Participate in disaster recovery exercises.
• Provide DBA support/sustenance with handling incident (trouble shooting & break fix) in SSIS & DTS packages and Migration of DTS 2000 packages to SSIS 2005/2008.
• Responsible for planning, development, peer reviews, testing, providing client support and involved in all phases of database development and Production lifecycles.
• Performed planning of database capacity.
• Experience with leveraging Hadoop ecosystem components including Pig and Hive for data analysis, sqoop for data migration, oozie for scheduling, and HBase.
• Importing and exporting data into HDFS and Hive using sqoop.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice versa.
• Excellent understanding of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.
• Responsible for timelines and deliverables of teh project with strict adherence to quality.
• Involved in Unit testing and System testing.
• Constantly working towards developing skills in teh latest emerging technologies

TECHNICAL SKILLS

Operation System / Hardware: Windows 98/NT/2000/XP, 2003 Servers, UNIX.

Languages: T-SQL, PL/SQL

Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import,SSIS

Database / RDBMS: Oracle 7.3, 8i and 9i, Sql Server 2000, 2005,2008

Hadoop/Big Data: HDFS, Mapreduce, Pig, Hive, Sqoop

PROFESSIONAL EXPERIENCE

Confidential, Florham Park, NJ

Senior SQL Server DBA

Responsibilities:

• Experience in writing SQL queries and optimizing teh queries in SQL Server 2008.
• SQL Server 2005/2008 Database Administration.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Implement Replication for Reference Data across different Instances of teh application.
• Worked on Active/Active and Active/Passive Clustering.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Developed standards and guidelines to maintain and develop and administer teh SQL Server database.
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS.
• Involved in creating SSIS packages for importing data from text file to database tables.
• Used SSIS to populate data from various data sources and also in teh creation of packages for different data loading operations for applications and to export data from other sources to SQL databases.
• Experience in writing SQL queries and optimizing teh queries in SQL Server 2008.
• Scheduled weekly jobs and Maintenance tasks for better performance, created teh alerts with Database Mail SMTP
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Involved in writing Transact-SQL command line script for various needs.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
• Used SSRS to create reports that draw content from a variety of data sources.
• Knowledge on SSAS to perform operations like source data access, processing etc.
• Define DB scripts versioning system to keep track of database versions for all environments
• Prepared teh reports for teh day-to-day as well as weekly/monthly purposes.

Environment: SQL Server 2005/2008/2012, T-SQL, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), Windows 2003 Server.

Confidential, Moorestown, NJ

SQL Developer/DBA

Responsibilities:

• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins
• Checking Database Health by using DBCC Commands.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Scheduling Backup and Recovery Jobs, Implementation using Litespeed, and integrating them with enterprise environment .
• 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 and users with permissions in SQL server 2005/2008.
• Administration of SQL server 2005/2000servers. Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Developed DTS packages and schedule jobs for loading data between different sources.
• Created Linked Servers between SQL server 2005/2008 and Oracle/DB2 servers in teh environment.
• Configured Snapshot and Transaction Replication.
• Performed query tuning, assigned proper Indexes for better performance.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Implementing different Development and Test Server instances for teh Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services that included paper-based and interactive web-based reports.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for teh Disaster Recovery plan
• 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.
• Good experience in data modeling and metadata services.
• Used SSAS to connect to teh underlying database to load teh data for processing.
• Automated teh process of recurring SUB reports through SSRS.

Environment: MS SQL Server 2005/2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005.

Confidential

SQL Developer/DBA

Responsibilities:

• Creation of Functions, Cursors, Packages, Stored procedures. Database triggers using by SQL Server 2008.
• BDL EDL Development.
• Data Migration from Siebel to GSX and EDM.
• Worked on Weekly Drops.
• Creating jobs to perform necessary actions.
• Integrating teh Code.
• Created maintenance plans in SQL Agent to backup teh database.
• Involved in Deployment of Drops.
• Writing teh unit test cases.
• Involved in code review for T-SQL objects.
• Involved in Backup, Restore & job schedule database level.
• Import, Export of Data from one Instance to another Instance.
• Through SSIS, used Control Flow Tasks, Data Flow Tasks.

Environment: MS SQL Server 2005/2000, T-SQL, DTS and Crystal reports 8.0, IIS 5.0, VB 6.0, Windows 2000 Server/Pro.

Confidential

SQL Developer

Responsibilities:

• Database design and coding.
• Creating SQL, T-SQL statements and Stored Procedures.
• Creating DTS Packages.
• Scheduling Jobs.
• Automation of jobs through coding.
• Preparing design document for teh requirement.
• Preparing test cases and for teh requirement.
• Unit testing and System testing.

Environment: SQL Server 2000, T-SQL, SQL Enterprise manager, Query Analyzer, ERWIN, DTS, MS Access 97 / 2000 & Windows Server /x64.