SUMMARY

• 8+ years of experience wif the 32bit, 64 - bit MS SQL SERVER and Oracle 11g/12c Databases in Production, Development and Testing in Clustered and Standalone Server Environment.
• Expertise in RDBMS s/w Installation, upgrading, configuring, managing, monitoring database integrity/consistency and troubleshooting SQL Server 2012/2008 R2/05/00 on Windows 2008/03/00 servers built on Clustered VMware
• Expertise in writing good standard T-SQL CODE, Windows Batch scripts and scheduling wif halp of Automated tools like Tidal Enterprise Scheduler, SQL Agent jobs
• Experience in database performance tuning, Tuning Indexes, Table structures and query optimization, Execution Plan Analysis, data integrity and Table statistics, setting up SQL Profiler Traces, capturing events, Tuning Deadlocks, Blockings.
• Configuring appropriate Transactional Isolation Levels for appropriate Transaction Management and resolve resource contention issues on Production Databases
• Tested and applied latest service packs and hotfix for SQL 2000/2005/2008/2008 R2 on SQL Failover Clusters and Standalone database instances.
• Expertise in Performance Tuning database Objects, Indexes, Partitions, and analyzing the Execution Plans wif halp of Dymanic Management Views (DMV’s) and automating tasks wif halp of Shell Scripts.
• Detecting Deadlocks, Blockings, stored procedure calls and Tuning Transaction Isolation Levels for Concurrent Execution of Critical application workloads.
• Partitioned large tables wifin Multiple Files and File groups by implementing various partitioning strategies (Partition schemes and Partition functions)
• Design Comprehensive Disaster Recovery solutions, Backup-Restore Strategies to Production Databases.
• Upgraded SQL Server databases, SSRS, SSIS Packages from SQL 20 /2014 Platforms
• Good noledge of Data Marts, Data warehousing, Operational Data Store(ODS), Star Schema Modeling, Snow-Flake Modeling, Facts and Dimensions Tables.
• Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
• Responsible for developing drilldown reports and Drill through in SSRS using MDX, SQL, and PL/SQL in Oracle.
• Good noledge in the installation and configuration of SQL Server 2008.
• Extensive experience in T-SQL: stored procedures, triggers, functions, tables, views, indexes and relational database models.
• Implemented the SQL Server 2005/2008/2012 concepts like Data partitioning, Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-catch blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Very good skillset as a developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Deployed and Debugged SSIS packages for import, export and bulk insert data wif transformations from various data sources.
• Sound noledge of Client Server Architecture/Database Architecture/Server architecture and Administration Architecture.
• Hands on experience wif performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in creating packages to extract data from Excel, Flat file, Oracle, DB2, Sybase to MS SQL Server by using MS SQL Server DTS and SSIS.
• Cleansed Datawhile loading and written logic to perform different kinds of transformations likeIncremental Data loads using SCD-Type 2, Pivot, UnPivot, etc.
• Good Experience wif SSIS Package Configurations, Logging, Package deployments using Manifest files, and scheduling package execution.
• Good understanding of SSRS Report Architecture, Report Manager and Report server url.
• DefinedShared Data sources, Datasets, parameters,variablesand evaluated expressions at dynamic run time parameters and using propertiesand dynamically filtered result sets for SSRS reports
• Experience in Developing Tabular, Matrix, and parameterized Reports and cascading Parameterized SQL Reports using SQL Server Reporting Services (SSRS).
• Experience in SSRS wif Report security, Report management, Report Delivery, Subscriptions, Data driven Subscriptions, Report snapshots.
• Experience in developing Ad-hoc and Parameterized Reports, Create complex reports (Sub Reports, Drill Down and Drill Through reports, and generating runtime Totals) using SSRS.
• Evaluating report properties at Runtime using parameters, Expressions in SSRS
• Worked wif a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects wifin scope, time and costs while following department standards, methodologies and guidelines
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills
• Excellent Team Player and provided 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/ 2000/2003/2008 R2 Server, UNIX, Red-HAT Linux

RDBMS/Databases: MS SQL Server 7.0/2000/2005/2008/2012, Oracle 8i/9i, 10g Teradata V2 R5/R6

Data modeling and ETL Tools: MS Visio, SSIS, DTS, Informatica

Reporting Tools: SSRS, MS Excel

Packages: MS Office, Visual Basic

Languages: C, SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE

Confidential, South Brunswick, NJ

SQL Server Developer

Responsibilities:

• Managed SQL Server 2005/2008 R2/ 2012 and 2014 instances containing 4 TB of Data
• Installed and administered two node Active/Active cluster on MS Windows Server 2008 R2 Enterprise database Servers
• Implemented normalization principles, logical and physical modeling, database design principles, tuned queries, stored procedures, and provided production support
• Implementing Disaster Recovery solutions like Transactional Replication and Clustering for high availability.
• Setting up proactive database monitoring using centralized tools like Idera Diagnostic Manager, Batch scripts, and jobs.
• Implemented Database Migration and upgraded databases from SQL Server 2008 r2 to SQL 2014.
• Partitioned large FACT tables into multiple file groups and compressed data using Row and Page level compression and switched out yearly partitions on a scheduled basis.
• Worked wif Business Analysts and Users to understand the requirements.
• Worked extensively on installation, upgrade and configuration of MS SQL Server and MS SQL databases.
• Involved High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Created complex Stored Procedures, DTS (Data Transformation Service) packages, triggers, cursors, views
• Configured the compatibility levels of the database and updated software, installed service packs, hot fixes in Clustered environment
• Daily tasks included Troubleshooting performance tuning issues: dead locks, blocking, memory, I/O, disk and network bottlenecks, wait events and also monitored space requirements, and file growth, and security issues, and fixed orphaned users, managed logins
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked in SSIS script task, look up transformations and data flow tasks using VB scripts.
• Actively involved in CHANGE CONTROL Process using Remedy change tracking.
• Involved and Handled Server and SAN migrations and provided 24*7 Support POST MIGRATIONS.
• Configured wif checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Worked wif SSIS Execute SQL task, script task using C#, data flow tasks, look up, conditional split, script component, row count, union all, multicast, derived column transformations
• Designed and created Data Marts, Databases, Indexes, Views, Stored Procedures, Partitions and Data Integrity in Oracle 11g Database.
• Backed up master & system databases and restoring them when necessary. Supported production environment.
• Point of contact for all Disaster Recovery tests and was extensively involved in the design
• Developed Sub Reports, Matrix Reports, Tabular Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder, Report Rebuilding indexes wif different fill factors and update statistics manually and developed automated scripts
• Designed and implemented comprehensive Backup plan and disaster recovery wif and wifout compression
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and QA Servers and handling maintenance Jobs including backups and restores.

Environment: SQL Server 2005/2008 R2/ 2014,T-SQL,MOSS 2007,Oracle 10g/11g/ 12c, Analysis Services (SSAS)2008 R2, Reporting Services (SSRS)2008 R2, Report Builder 3.0, Integration Services (SSIS)2008 R2, MS Visual Studio.Net, C#, VB, Microsoft Visio, SQL Profiler, Enterprise Manager, Windows 2003 Server OS.

Confidential, Philadelphia, PA

Database Developer

Responsibilities:

• Installing, configuring, administering SQL Sever 2005/2008 r2 Instances and securing production servers
• Setup new MS SQL Server instances and databases and involved in Capacity planning of MS SQL Servers
• Data Analysis and Designed the logical and physical model architecture for database.
• Responsible for providing 24 X 7 critical production supports to 500 + Production, development and clustered servers.
• Responsible for administrating multiple database systems (around 2 TB) using clustered SQL Server 2008 R2 servers.
• Setting up and Configuring SQL High Availability Clusters on Windows server 2003 & 2008 in ACTIVE-ACTIVE and ACTIVE-PASSIVE Configuration
• Configured DATABASE MIRRORING, TRANSACTIONAL REPLICATION as part of DISASTER RECOVERY solutions
• Implemented Comprehensive Disaster Recovery solutions, backup-restore strategis.
• Interacted directly wif the various SME for gathering the Business Requirements.
• Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Created stored procedures/Packages using Pl/SQL programming according to the business requirements
• Creating Maintenance plans and scheduling recurring SQL Jobs for daily backups, history clean up, index rebuilds as per client requirement.
• Setting up proactive database monitoring using centralized tools like Idera Diagnostic Manager, Batch scripts, and jobs.
• Setting up database tuning wif SQL Database Tuning advisor
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files.
• Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS wif custom error handling and worked wif different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Written T-SQL Code to generate datasets for Reports and applied filters and Parameters to generate data for Reports.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Tabular Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Performed Query Optimization by extensive use of Index implementation and ITW
• Maintained the database consistency wif DBCC commands at regular intervals
• Database Refresh on Dev/QA servers from production and maintained database security
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc, in all the SSIS Packages.
• Set up ETL Jobs to run on a nightly basis into the Data marts by Scheduling SSIS Packages via SQL Server Agent.

Environment: SQL Server 2008, SQL Server Integration Services (SSIS), Analysis Services (SSAS), MS Visual Studio.Net, C#, Microsoft Visio, SQL Profiler, Windows 2003 Server OS.

Confidential, Mt. Laurel, NJ

SQL DBA/Developer

Responsibilities:

• Installing, configuring, administering and securing production servers
• Developed Stored Procedures, functions and DTS packages and error-handling using T-SQL for SQL Server 2000
• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Involved in Up gradation of Touch works Database.
• Touch works application was implemented in Active Passive clustered environment.
• Administered SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilt indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Using the Litespeed to take backups.
• Migrated data from Oracle to SQL Server
• Involved in Weekly Change Management, in which code developed by developers is run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered databases from backup in disasters
• Maintained database consistency wif DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Implemented log shipping for synchronization of database.
• Excellent experience in data modeling and metadata services.
• 24 X 7 Production Database on Call Support.
• Expertise in SQL Server Analysis Services(SSAS) and SQL Server Reporting Services(SSRS).

Confidential

SQL DBA/Developer

Responsibilities:

• Installing, configuring, administering and securing production servers
• Developed Stored Procedures, functions and DTS packages and error-handling using T-SQL for SQL Server 2000
• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Involved in Up gradation of Touch works Database.
• Touch works application was implemented in Active Passive clustered environment.
• Administered SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilt indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Using the Litespeed to take backups.
• Migrated data from Oracle to SQL Server
• Involved in Weekly Change Management, in which code developed by developers is run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered databases from backup in disasters
• Maintained database consistency wif DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks wif ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS
• Administered SQL Server configuration settings.
• Used Data Partitioning in SQL Sever 2005.
• Used Snapshot Isolation in SQL Sever 2005.
• Implemented log shipping for synchronization of database.
• Excellent experience in data modeling and metadata services.
• 24 X 7 Production Database on Call Support.
• Expertise in SQL Server Analysis Services(SSAS) and SQL Server Reporting Services(SSRS).
• Monitored SQL server performance using profiler to find performance and dead locks.
• Responsible for Maximum performance and uptime in production environment.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Setting up proactive database monitoring using centralized tools like Idera Diagnostic Manager, Batch scripts, and jobs.