SUMMARY

• Over 9 years of professional experiencein DBA, design, development and maintenance of Database using tools of MS SQL Server 2000/2005/2008 R2/2012 as a DBA, Developer.
• Experienced in software development life cycle in all phases.
• Backup/Restore and Disaster Recovery procedures Design, implement, execute and maintain disaster recovery plans and procedures.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Expertise in creating Packages using SQL Server Integration Services (SSIS).
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Expertise in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using MS SQL Server 2000/2005/2008 .
• Strong knowledge of creating Tables, Views, Indexes, Replication, and other SQL joins and query writing.
• Involved in moving databases between servers using attach/detach, backup/restore and import/export methods.
• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering.
• Experience with high availability systems, terabyte databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes.
• Has teh ability to work in a fast paced environment, Good team player and can work independently. Helped teh database developers on technical issues.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Designing and Deployment of Reports for teh End-User requests using Web Interface & SSRS.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008 R2/2012

Languages: SQL, T-SQL, HTML, VB Script

Applications: Excel, Word, PowerPoint

Operating Systems: Windows 2000/2003/2008 Servers, Red Hat Linux

Miscellaneous: Stored Procedures, DTS Packages, SQL Functions, SSIS, SSAS and SSRS, Log shipping, Replication, Database Mirroring and Database Snapshot

PROFESSIONAL EXPERIENCE

Confidential - Corvallis, OR

DBA/SSIS Developer

Responsibilities:

• Creating and maintaining various databases on Production and development environments using SQL Server 2012/2008R2/2005.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Data Export, Import using SSIS.
• Writing SQL Server Integration Services (SSIS) packages and deploy it in Development/Testing and production server.
• Work with teh developers, data quality analysts and customer support and operations technicians to troubleshoot all databases.
• Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded teh data into target tables by performing different kinds of transformations using SSIS. Performed Documentation for all kind of SSIS packages.
• Deploy, upgrade and configure new database and Coordinate database migrations with developers and other stakeholders.
• Experienced in creating package dynamics by using SSIS transformations and variables.
• Database and Transaction log backups & restoration, backup strategies, scheduling teh backups. Backing up system & user databases and restoring them whenever necessary.
• Extensively worked on decommissioning teh legacy databases from SQL 2005/2000.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into teh SQL table.
• Created and modified Stored Procedures, Functions, and Indexes.
• Responsible for maintenance and support for a two node Active-Active clustered SQL Environment.
• Experience on working in Agile/Scrum environments.

Environment: Microsoft SQL Server 2012/2008 R2 /2005, Microsoft Windows 2008 R2/2003 Server, Visual Studio, Microsoft SQL Server Integration Services, SSRS, SQL Profiler, Microsoft OFFICE 2010

Confidential - Atlanta, GA

SQL DBA/SSIS Developer

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Converted all existing DTS package of MS SQL 2005 to SSIS packages by using package migration wizard and Deployed new Package in different Server.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded teh data into target tables by performing different kinds of transformations using SSIS.
• Migrated packages from development server to production server using package configuration.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in teh databases
• Improved Performance of teh database by creating Clustered and non-clustered Indexes and by optimizing teh T-SQL statements using SQL profiler.
• Monitored Scheduled jobs and alerts.
• Developed, monitored and deployed SSIS packages.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Developed teh BI solution that led to cost savings and helped improve operational efficiency and workforce productivity.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Developed T-SQL (DDL, DML) statements using dynamically generated SQL and defined Referenced relationships with teh measure groups and fact tables.

Environment: Microsoft Windows Server 2008 R2/2003 Server, Microsoft SQL Server 2005, 2008 R2, Microsoft SQL Server Integration Services, Red Hat Linux, Visual Studio, BIDS, Microsoft OFFICE 2003.

Confidential - San Francisco, CA

SQL DBA/Developer

Responsibilities:

• Well versed with SQL Server 2005/2008R2 Installation, Administration and Monitoring, Database Backup and Recovery and day-to-day database monitoring activities.
• Designed teh ETL processes using SSIS to load data from Oracle, SQL Server, Flat Files and Excel files to target SQL Server staging database.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into teh data warehouse database from heterogeneous databases/data sources (SQL, Oracle, Excel Sources).
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Data Validation using Excel and SSIS
• Data Cleansing using SSIS.
• Created Queries in T-SQL, Stored Procedures, and Views to store teh data of clients and advisors.
• Developed T-SQL (DDL, DML) statements using dynamically generated SQL.

Environment: Windows 2003 Server, MS SQL Server 2000/2005/2008, T-SQL, SSIS, Red Hat Linux, MS Office.

Confidential - Santa Monica, CA

Developer/DBA

Responsibilities:

• Installation of SQL Server 2005 on production, development and testing environments.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Migrated teh data from various sources using DTS.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into teh Data warehouse from Heterogeneous databases such as Oracle.
• Well versed with teh usage of variables to make teh packages dynamic and scheduling teh package in SSIS (sequential scheduling).
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Designed high level SSIS architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse.
• Successfully transferred old data from various sources like flat files and Excel into MS SQL Server 2008 using SSIS Packages.
• Managed teh Metadata associated with teh ETL processes used to populate teh Data Warehouse.
• Enhanced teh old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.

Environment: Windows 2003, MS SQL Server 2000, MS SQL Server 2005/2008, T-SQL, Visual Basic 6.0,MS Access, SSIS,SQL Profile.

Confidential

DBA/Developer

Responsibilities:

• Install and maintain desktop workstations, printers and peripherals locally and remotely.
• Designed and implemented comprehensive Backup plan and Disaster Recovery strategies. Implemented and Scheduled Replication process for updating our parallel servers.
• Recovering teh databases from backup in disasters.
• Monitoring/troubleshooting teh existing DTS packages.
• Created Maintenance Plans for performing various tasks on SQL Server.
• Monitoring and Managing use of disk space and connections.
• Well versed with teh usage of variables to make teh packages dynamic and scheduling teh package in SSIS (sequential scheduling).
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
• Created indexes on teh database tables and generated trace events to improve teh query performance and optimize data access.
• Designed and Implemented teh Stored Procedures and Triggers for automating tasks.

Environment: SQL Server 2000/2005, Enterprise Manager, Windows 2000/2003, SQL Profiler, T-SQL, Linux, Solaris.

Confidential

Linux Admin/Windows Admin

Responsibilities:

• Installing, Upgrading and Administrating Operating Systems and applying Patching & Packages for applications.
• Setup, maintain and manage teh User Accounts and groups.
• Scheduling of automatic repetitive jobs using commands, and shell scripts with Corntab.
• Install and maintain desktop workstations, printers and peripherals locally and remotely.
• Windows Server 2000 and 2003 environment.
• Configure/assemble/troubleshoot Desktop PCs/Laptops.
• PC and laptop data migration.