SUMMARY

• 9+ years of IT experience in SQL Server Database Administration, Design System Analysis, Testing, Development and Support of SQL server 2012/2008R2/2005 in PRODUCTION,DEVELOPMENT, QA and UAT Environments.
• Experienced and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping and Database Mirroring.
• Experience with SQL Server Consolidation, Virtualization and Administration of VLDB Environments.
• Experience in performing upgrades from SQL Server and, 2012
• Deploy and manage the reports to a report server and securing and managing the reports with Reporting server.
• Experience in creating Logical Design of the Database & transforming it into a Physical Design
• Experience in creating Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Expertise in Data Modeling tools such as Erwin, MS Visio, and ER/ Studio Design Tool.
• Experience in Monitoring Performance using various SQL Server inbuilt tools like Performance Monitor, SQL Profiler, Event Viewer, DMV’s/DMF’s, Execution plans, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries etc.
• Extensively worked on 32 bit and 64 bit clustered, standalone and virtualized server environments.
• Experience in scheduling maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, Tracing long running/deadlock queries, Capacity planning, Monitoring Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery solution maintenance etc.
• OLAP experience like SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), Analysis Services (SSAS) to manage data ware house environment.
• Experience in Designing, Building the Dimensions, cubes with star schema and snowflake schema, using native OLAP service Manager in Data Warehousing.
• Experience in migration of Data from Excel, Flat file, Oracle, DB2 to MS SQL Server by using BCP and DTS utility, Extracting, Transforming and loading of data using SQL Server DTS.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Experience in creating Scheduled Tasks for regular Database Backup and Maintenance Activities.
• Deploy and manage the reports to a report server and securing and managing the reports with Reporting server.
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups.
• Optimization, Backups, restore, performance tuning, data partitioning, Security and disaster recovery
• Maintained very large databases (VLDB), monitoring databases performance, daily backup and restore databases.
• Expert in using different recovery models simple, full and bulk-logged depending on availability of database.
• Experience in data modeling tools such and Erwin, MS Visio, and ER studio design tool.
• Experienced and knowledge of high availability SQL Server solutions with SQL server Failover Clustering, Database snapshot, Log shipping, and Database Mirroring.
• Experience in Upgrade server from SQL Server 2005/2008R2/2014 and handling OLTP and OLAP environment in 24/7 and on call basis
• Successfully deploy several third party applications to help DBA’s with day to day duties, Software such as Lite Speed, SQL Sentry Monitoring, and Spotlight.
• Strong ability in defining query for generating reports in SSRS, SSAS cubes development and processing including dimensions and measures design Perspectives.
• Good knowledge on processes and procedures and documentation skills.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Good knowledge on Health Insurance Portability and Accountability Act(HIPAA)
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

Databases: SQL Server 2012, 2008R2, 2005, 2000, Oracle, MYSQL, DB2,MS Access

Database Tools: SSMS, Query Analyzer, SQL Profiler, Performance Monitor, Tuning advisor, Replication monitor, DTS,BIDS(SSIS/SSRS/SSAS)

Other Tools: Commvault,MS Visio, SQL Compare, Report Builder, ERWIN, RedGate,lite-speed, Spotlight, Visual Source Safe, TFS, SharePoint, Power Shell Scripting.

Languages: T-SQL, PL/SQL, .NET, VBScript, C#, C, Java, ASP, XML

Operating System: Windows Server 2008/2003, Windows XP, Windows Vista and Windows 7.0

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL DBA\Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Water Fall SDLC model system of Confidential
• Implemented the Requirement Analysis, Design phase and development Phase of the agile process in the scrum methodology and integrated all the scrum processes with our TFS environment.
• Migrated existing Account numbers from CRI to BPS/A and implemented a logic in our development to generate account number on daily basis to satisfy new customers.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Installed SQL servers, created databases based on business needs and performed dba activities like backups, restores, maintenance work, created logins and granted access to users accordingly
• Configured ALWAYS ON AGs, Integration service catalogs in SQL 2012
• Resolved long time running queries, Blocking, CPU/IO/Memory/Tempdb bottleneckissues by making use of dmvs and windows perf mon counters.
• Automated backups, reorgs, restores, check error logs, offline dbs, copy dbs, check db status etc through scripts.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers in SSIS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files.
• Migrated Data base from Oracle to SQL Server using OLE DB provider by creating SSIS packages.
• Involved in performing migration of DTS packages to SSIS packages.
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS.
• Formatted the reports using the Global variables and expressions.
• Created new transactional replication and address the replication issues to maintain hign availability of the data between the servers.
• Generated reports using SQL Server Reporting Services 2008/2012 from OLTP and OLAP data sources.
• Logical and physical Design of the Database by creating procedures, functions and packages.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Executed manual test cases by using positive and negative data inputs and verified actual results with expected results. Report results and defects using code collaborator.

Environment: MSSQL Server 2008R2/2014 Enterprise Edition, Windows Server 2003/2008/2012 , Business Intelligence Development Studio(BIDS), T-SQL, Management Studio, Enterprise Manager, SSIS, SSRS, SQL Profiler, Team foundation server,Agile,Windows Performance Monitor, DTS, Testing.

Confidential, Houston, TX

MS SQL Server DBA\Developer

Responsibilities:

• Installed and configured SQL Server production environment servers and applied service packs and security fix for all servers.
• Configured the SQL instances\servers in to commvault, schedule the policies and check the backup status on job controller.
• Check the status of the SQL server databases backups on commvault tool; track the status on Event viewer.
• Work on solar winds alerts storage issues of databases.
• Involved in the configuration and maintenance ACTIVE/PASSIVE Cluster Environments for the production servers
• Ability to detect and troubleshoot SQL Server related CPU, memory bottlenecks, I/O, disk space and other resource contention
• Effectively using DBCC commands, Dynamic Management Views (DMV), SQL Profiler, Performance Monitor, SQL Server Management Studio, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database consistency checks using DBCC Utilities.
• Proficient in Migration of Data from various heterogeneous sources to MS SQL server by using SSIS/DTS utility or by Linked Server
• Experience in Query Optimization, analyzing the execution plan and index management for better Query performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS
• Performed Troubleshooting of client’s database related issues during implementation, maintenance, and upgrading migration process.
• Designing Back-ups restores strategies and Disaster Recovery solutions, Scheduled SQL Jobs and error handling.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Installed SQL Server Failover clustering to meet customer needs for Development environment, applied patches on different nodes and administered each node.
• Daily tasks including backup and restored the databases from backups as needed
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development activities Advisor for index recommendations.
• Involved in implementation of replications like Snapshot, Transactional and Merge.
• Created an implementation document for the step-by-step migration of data and schema to the new instance.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Experience in Data Ware Housing Concepts, Including Star Schemas, Snowflake Schemas and Dimensional modeling.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development activities Advisor for index recommendations.
• Experience working on storage area networks (SAN) and cluster server (installation, troubleshooting, replication, DR and performance & tuning).
• Involved in implementation of replications like Snapshot and Transactional in OLTP environments
• Configured SNAPSHOT Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors)
• Successfully Migrated/Upgraded SQL Server 2000 to SQL Server 2005/2008/2012 on Development, Testing Production Environments for various mission critical applications
• Setting up SQL Trace, SQL Profiler to capture various Database activities, application Responses and Performance tune them.
• Responsible and Involved in SQL Server Performance Monitoring, Server and Database optimization and Query tuning. Used SQL Server Dynamic Management Views and functions to monitor & optimize the performance
• Installed SQL Server Failover clustering to meet customer needs for Development environment, applied patches on different nodes and administered each node.
• Daily tasks including backup and restored the databases from backups as needed
• Migrated the SQL Server 2008R2 to SQL Server 2012 and implemented CDC(change Data Capture) feature
• Experienced in configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.

Environment: MS SQL Server 2008R2,Commvault,solarwinds, SQL Integration Services, SSRS,SSAS, Microsoft Visual Studio, C#, SQL Server Management Studio,RedGate,Erwin,Toad, Oracle, MS Excel, T-SQL.

Confidential, Houston, TX

SQL Server DBA\Developer

Responsibilities:

• Install, Configured SQL Server 2008R2, 2008, 2005 Enterprise and Standard editions on 32 and 64 bit systems.
• Experience in developing SSIS package using various transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split, Multicast, Derived Column, Data Conversion, Slowly Change Dimension, Fuzzy grouping, and Fuzzy Lookup.
• Configured the SQL instances\servers in to commvault, schedule the policies and check the backup status on job controller.
• Check the progress of database backups on commvault job controller.
• Designed and configured SQL Security with help of AD Groups, SQL Roles for users, applications and assigning appropriate permissions to the databases.
• Installed SQL Server Failover clustering to meet customer needs for Development environment, applied patches on different nodes and administered each node.
• Daily tasks including backup and restored the databases from backups as needed
• Involved in Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring and SQL server native tool PerfMon. Counters and performance tuning.
• Developed database packages, procedures, functions, and database triggers to implement business functions.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional Models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS
• Reduced the dead locks by using the SQL Server Profiler and setting up Trace flags for every day monitoring
• Designed Dimensional Modeling using SSAS packages for End-User and Created Hierarchies in Dimensional Modeling
• Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations
• Responsible for creating and deployingdifferent types of reports like Conditional, Parameterized, Sub-reports, Drill-down reports, Matrix or Crosstab reportsand Summary reports based on the requirements using SSRS 2008 R2
• Automated daily, weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing.
• Scheduled maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, Tracing long running/deadlock queries, Capacity planning, Monitoring Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery Solution maintenance etc
• Installed SQL Server 2012/2008R2 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Production database support (24*7*365) on all versions.

Environment: MS SQL Server 2008R2/2012,Commvault,solarwinds, TOAD, Oracle, SSIS, SSRS,SSAS,C#, Microsoft Visual Studio, SQL Server Management Studio, Erwin,RedGate, Team foundation server, Agile, MS Excel, T-SQL.

Confidential, Nashville, TN

SQL Server DBA\Developer

Responsibilities:

• Performed troubleshooting of client’s database related issues during implementation, maintenance, upgrading, and migration process.
• Monitored and troubleshoot jobs in production, preview and development servers.
• Migrates DTS packages to SSIS packages using DTS exchange
• 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.
• CreatedSSIS packages and Extract data from different sources like MS Excel, MS Access, SQL server 2008, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• 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 the SQL table
• Created new Transactional replication and addressed the Replication Issues to maintain high availability of the data between the servers
• Participate with infrastructure with database clustering, failover and load balance technologies as per client requirement.
• Efficient in managing replication like Debugging, Latency, dropping and Re-creating the Publishers and Subscribers
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, Functions and Views.
• Experience working on storage area networks (SAN) and cluster server (installation, troubleshooting, replication, DR and performance & tuning).
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application, Cleansing and solving Database troubles.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores
• Created Star Schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.

Environment: SQL Server 2005/2008R2,Windows 2008/03 Server, SSIS, SSRS,Replication, Microsoft Visual Studio,.Net, C#, MS Excel, T-SQL,ERWIN.

Confidential, Pasadena, CA

SQL Server DBA/ Developer

Responsibilities:

• Applied Patches and Service packs to update different versions of MS SQL SERVER in Clustered and Standalone Environments
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views
• Wrote complex SQL queries using joins, Stored Procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Developed dependant, dynamic menu objects to allow end-users selection and data filtering capabilities
• Implemented and Scheduled Replication process for updating our parallel servers
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application, Cleansing and solving Database troubles
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Designed and created data marts, databases, indexes, views, aggregations, store procedures, partitions and data integrity
• Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
• Monitoring the application and database performance using SQL Profiler and Performance Monitor
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Expert in automating SQL server using SQL server Severity in Production, Development and automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and rebuild indexing.
• Created Database Maintenance Plans for Database Backups, Re-indexing and Data Integrity Checks
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
• Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations.
• Created SSRS Data Model projects using Microsoft Visual Studio 2005 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users

Environment: Windows NT/2003 Server, SQL Server 2005/2008, SSRS, SSIS, Replication, T-SQL, Visio, Excel, VSS, Share Point.

Confidential, MO

SQL Server DBA/Developer

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2000/2005 on windows 2000/2003 Servers.
• Installation of SQL Server Service Packs & hot fixes
• Data Analysis and Designed the logical and physical model architecture for database.
• Interacted directly with the various SME for gathering the Business Requirements.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Data Migration from Flat files, CSV, MS-Access, Excel and OLE DB to SQL Database
• Created and modified and maintained the ETL packages- Extraction, Transformation and Loading of data from various Database tables from Source Tables to Mapping the Target table in respective databases.
• Collected data from Various Heterogeneous sources to MS SQL, DB2, ORACLE, Flat File, Access, EXCEL sheets, CSV format and used complex data conversion to target.
• Set up, configure and administer Snapshot and Transactional Replication on MS SQL Server 2005.
• Involved in writing Stored Procedures, Triggers, User-defined Functions, Views and Cursors for handling business logic and functionality of various modules
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores

Environment: Windows 2003,Replication, MS SQL Server 2008/2005/2000 , SSIS, SSRS, MS-Access, Erwin, VB Script, WIN2000/XP

Confidential

SQL Server Developer/DBA

Responsibilities:

• Extensively involved in installing and configuring SQL Server.
• Writing scripts and stored procedures to automate the routine database administration tasks managing user accounts and maintaining system security.
• Evaluated data storage considerations to store databases and transaction logs.
• Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard
• Managed trouble shooting of Client connections, viewing error log and applications
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Created complex Stored procedures, triggers and Cursors in SQL Server
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created database and database objects such as Table, index, stored procedure, view, trigger and function using T-SQL.
• Administering 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
• Generated Reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL Server 2000/2005, Windows 2000, MS ACCESS, DTS, MS Office.