We provide IT Staff Augmentation Services!

Sql Server Dba Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • 8+ years of experience with the 32bit, 64 - bit environments as Microsoft SQL SERVER DBA in Production, Development and Testing in Clustered and Standalone Server Environment.
  • Experience in installing MS SQL SERVER 201, 2008R2, 2008, 2005, 2000; updating with hot fix and service packs.
  • Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client-server environments.
  • Experience in migrating SQL Server 2005/2008/2008 R2 to 2012/2014/2016.
  • Experience in implementing AlwaysOn Availability Groups in SQL Server 2012.
  • Expert in RDBMS S/W installation, applying patches, upgrading, configuring, trouble shooting of SQL SERVER on Windows 98/2000/03/03 R2/08/08R 2/ 2012/2014/2016 servers and Clustered VMware Environments.
  • Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
  • Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
  • Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
  • Handled up to 2 TB databases in Clustered environment with good Physical storage configuration and Optimizing of SAN with different Raid Levels.
  • Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
  • Experience in configuring Replication and troubleshooting the issues with transactional replication.
  • Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
  • Hands on configuring Tempdb with considerable Memory and Raid Levels for better performance.
  • Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
  • Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Replication, Linked Servers and Database Maintenance Plan.
  • Maintained User Permissions, Logins and Security Issues. Monitored Event Viewer s, SQL Error logs and Log Files Viewer for S/W and H/W errors.
  • Good knowledge in using DMVs and DMFs to finding and solving Performance Issue.
  • Hands on experience in Planning and Scheduling Maintenance Tasks and Scheduling Jobs and Alerts using SQL Mail.
  • Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
  • Involved in Change Control Management Process for maintaining the consistency of databases.
  • Working knowledge of SOX Compliance for maintaining roles and responsibilities, data integrity and database management.
  • Good knowledge with features of SQL Server like Spatial, CDC, Resource Governor, Encryption and File stream Data functionality.
  • Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
  • Maintaining the Service Level Agreements (SLA’s) according to the client’s requirement.
  • Written PowerShell scripts that are customized for a particular dataset - such as a morning health check, which outputs different base information on reporting every morning.
  • Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
  • Good Team player, Strong Communication skills and interpersonal with Self-motivation.
  • 24/7 on call production support.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2016/2012/2008 R2/2008/2003R2/2003/98/XP/Vista/7, UNIX (Sun Solar), Linux.

Databases: MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , MS Office Access 97/2000/2003/2007/2010 , Oracle.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data Transformation Services (DTS)

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, SSMS.

Other Tools: Erwin, Red gate, LiteSpeed, Spot Light, Foglight, Commvault, Idera SQL Safe, SQL Compare, Visio, PowerShell

T: SQL, C/C++, C#, java script, Visual Studio 2005/20, ASP.NET, VB.Net

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

  • Reviewed and analyzed requirements for New Projects with Application and Business teams.
  • Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
  • Installed and configured MS SQL Server 2016/2014/2012 on standalone and clustered environments.
  • Experience in migrating contents from MS SQL server 2014/2012/2008 R2 to MS SQL server 2016.
  • Implemented High Availability in SQL 2012/2014/2016 by configuring AlwaysOn Availability groups across Windows Server Failover Clustering using Failover Clustering Instances.
  • Installed and configured Windows and SQL clusters including 3 node clusters, 4 node clusters, and adding a node to an existing cluster.
  • Implemented and configured Central Management Servers to centralize and manage instances of SQL Server 2008R 2/2012/2014.
  • Configured Transactional Replication and Log Shipping with SSMS as well as basic account management and troubleshooting with connectivity, security and firewall issues.
  • Conducted Database mirroring in High Performance and High Availability mode and Troubleshooted issues with witness servers for Disaster Recovery.
  • Applying the Hot fixes and patches based on the requirements for different stores within the maintenance window.
  • Day to Day tasks including resolving incidents, performing change tasks, checking failed jobs, monitoring databases and perform database maintenance.
  • Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
  • Worked with application teams, developers on database changes, performance issues.
  • Monitored Databases for Lock Escalation, Deadlock, resource utilization by sessions, capturing long running SQL queries, fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Perform database troubleshooting, management, backup, restore and routine maintenance DBCC, Re-index of database table indexes, database performance tuning.
  • Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
  • Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management. Handling of the database backup failures, fixing the issues and make sure the availability of daily backups.
  • Resolving the Database I/O Consistency errors and Allocation errors. Performing Health checks and Monitoring performance of the Production Servers.
  • Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
  • Designed Database activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
  • Providing the access to users based on the requirement to the Production/UAT/QA/Development Servers with appropriate approvals. Handling of the low Logical disk space issues, Tempdb issues, Data file and Log file issues.
  • Implemented Transparent Data Encryption (TDE) on high-valued, enterprise edition, servers and maintained encryption key backups. Used Resource Governor for limiting the resources like CPU, Memory to applications on shared environments.
  • Worked on time to time basis with NetAPP team in configuring the path for Database Backups and issues related with backups for critical applications in Production.
  • Monitored the event logs and server logs fortroubleshootingand problem solving. Database refreshments from Production to DEV/UAT/QA environments.
  • Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures. Used DMVs, SQL Profiler, and Performance Monitor to proactively monitor and tune the Database Environment.
  • Loading data from various sources like OLEDB, flat files to SQLServer database Using SSIS Packages and created data mappings to load the data from source to destination. Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
  • Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
  • Provided 24/7 Production Support (on-call) and resolved all tickets related to SQL Server Database and tickets opened by application and operations team including SSIS/SQL Job failures, Disk space, Blocking.
  • Coordinated and managed offshore team and provided production support including weekends and supported Change control over nights.

Environment: MS SQL Server 2000, 2005, 2008R2, 2012, 2014, 2016, TSQL,OLTP,OLAP, Windows Server 2008/2008R2/2012/2016, Redgate, VMware, Spotlight, Visio 2007, SSIS, SSAS, SSRS, Visual Studio 2005/20 .

Confidential

SQL Server DBA

Responsibilities:

  • Worked on Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
  • Created and maintained various databases for Production, Development and Testing environments using MS SQL Server 2014, 2012, 2008R2, 2008, 2005.
  • Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also Troubleshooted issues with the same. Applied hot fixes and Service Packs in clustering environments.
  • Worked on 2014 AlwaysOn High Availability node and the Availability Groups node.
  • Involved in migration of SQL 2012 TO SQL 2014.
  • Migrated Servers from SQL Server 2000/20 R2/2012/2014 based on the application team requests.
  • Implemented AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
  • Based on the business need created Transactional Replication on Different applications.
  • Configured and maintained Log Shipping and Database Mirroring for disaster recovery.
  • Patching all the SQL Servers 2008, 2008R2, 2012, 2014 with the latest service packs.
  • Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management.
  • Provided highly available Database and Application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
  • Handling of the database backup failures, fixing the issues and make sure the availability of daily backups. Resolving the Database I/O Consistency errors and Allocation errors.
  • Creation of user databases and ensuring file group creations and also ideally placing files in appropriate locations. Performing Health checks and Monitoring performance of the Production Servers.
  • Participate in capacity planning, trend analysis, performance forecasting exercises and propose recommendations to meet the ongoing performance and scalability demands.
  • Database refreshments from Production to DEV/UAT/QA environments.
  • Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures.
  • Used DMVs, Alerts, SQL Profiler, and Performance Monitor to proactively monitor and tune the Database Environment. Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
  • Providing the access to users based on the Requirement to the Production/UAT/QA/Development Servers with Appropriate Approvals.
  • Handling of the low Logical disk space issues, Tempdb issues, Data file and Log file issues.
  • Implementing Policy Based Management, Backup Compression and Transparent Data Encryption (TDE).
  • Monitored the event logs and server logs fortroubleshootingand problem solving.
  • Evaluated new features in SQL Server 2012 and SQL Server 2014 in lab environment namely Enhanced to Backups, contained databases, Security Principals and AAG.
  • Created Database Maintenance Plan to implement Database backups, Integrity Checks and indexing.
  • Performance testing on stored procedures, indexes, and triggers.
  • Evaluated 3rd party SQL Server Monitoring Tools that could be used for database administration.
  • Extensively Used tools SQLServer Profiler, Extended Events, Dynamic Management Views and Functions (DMVs and DMFs) for optimizing performance of SQL Server systems.
  • Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008, 2008R2 and 2012 and 2014.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments. Migration ofDTSpackages toSSISpackages. Designed, Developed, Configured and Deployed custom build business reports using SSRS.
  • Trained offshore resources in all aspects of SQL Server database administration practices and provided production support whenever required.
  • Provided 24/7 Production Support (on-call) and resolved all tickets related to SQL Server Database and tickets opened by application and operations team including SSIS/SQL Job failures, Disk space, Blocking.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014, Windows 2003/2003R2/2008/2008R2/2012 servers, VMware, RDBMS, SQL Monitor-Red Gate, SCOM, SQL Diagnostic manager-IDERA, CA Service Desk, BMC Remedy Tool, TOAD, Net VERITAS Backup Tool, PowerShell, SSIS, SSRS, Visual Studio 2005/20, Spotlight, Quest Software TPAM, IT Service Catalog, Incident Request, ECHO, OMDB TMEIM, HP Server Automation Tool.

Confidential, NORFOLK, VA

SQL SERVER DBA

Responsibilities:

  • Administrated and Managed SQL Server 2014/2012/2008 R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
  • Upgraded/Migrated SQL Server 2000/2005/2008 databases into SQL server 2008R2/2012 and mentored other technical staff.
  • Comprehensively utilizedVMwaretechnologies in the deployment of mission critical SQL Server environments.
  • Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
  • Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
  • Responsibilities include the Production and Application Support for the Database and Application Servers.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Resolving performance issues using DMVs (Dynamic Management Views).
  • Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
  • Worked on everyday tasks and tickets based on priority levels from TFS ticketing system and saved/ updated all scripts related to the tasks in TFS using visual studio 2010.
  • Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
  • Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
  • Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008R2/2005 and participated in Disaster Recovery Drill processes.
  • Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
  • Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
  • CreatedPartition function,Partition schemeandmultiple file groups and filesto host the table data forData partitioning.
  • Encrypted data and log files usingtransparent data encryption (TDE)solution.
  • Worked in OLTP and OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
  • Implemented new features inSQL 2008likePolicy based Management, Table Compression backup compression, SQL Server Auditing, Resource Governorand MERGEstatement inT-SQL.
  • Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
  • Performed data partitioning for efficient management of database tables and indexes.
  • Extensively working on performance issues like update statistics, Auto Stats.
  • Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
  • Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
  • Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
  • Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
  • Involved in designing Partitions in Cubes to improve performance using SSAS.
  • Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: MSSQL Server 2012/2008/2008 R2/2005/2000, Windows Server 2003/2003R2/2008/2008R2/2012, VMware, SQL Profiler, Database Tuning Advisor, SCOM, T-SQL, LiteSpeed, Erwin, Idera, Spotlight, Visual Studio 2005/20, SSAS, SSIS (ETL), SAN, SSRS, SharePoint Server 2007, Oracle, Linux, Unix, Mainframe, Sybase, DB2, NetAPP.

Confidential, BALTIMORE, MD

SQL Server DBA

Responsibilities:

  • Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000/20 R2/2012 on Windows. Designed and deployed HA and DR solutions usingVMwaretechnologies.
  • Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
  • Configured the AWE and 3 GB switch for the 32 bit 2005 server.
  • Applied Patches and Service packs to update different versions of MS SQL SERVER.
  • Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
  • Implemented native log shipping on MS SQL SERVER 2008R2.
  • Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
  • Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA,SQLCMD and dedicated admin connection, Common table Expression(CTE).
  • Used CDC (Change data capture), Table valued parameters and other new features in new applications.
  • Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2.
  • Moved files between the File Groups and partitioned the tables to improve the performance.
  • Extensively used LiteSpeed backup with MS SQL SERVER 2008R2.
  • Good knowledge on new concepts of 2008 like PowerShell.
  • Extensively worked on Transparent Data Encryption (TDE) and Auditing.
  • Troubleshooted performance problems, fine-tuning of databases and index Analysis.
  • Documented and performed the database health checks regularly.
  • Re-factored and fine-tuned the queries and stored procedures in T-SQL.
  • Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
  • Implemented log shipping for Production server database as part of the disaster recovery.
  • Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Transparent Data Encryption, Table and Page level compression and Resource Governor.
  • Created baseline and sampling intervals in the Perfmon considering threshold values of the counters.
  • Rebuilding indexes with different fill factors and update statistics manually.
  • Implemented native log shipping for HIGH AVAILABLITY of the Production Server DATA BASE.
  • Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
  • Deployed SSIS package for bulk insert and maintained archival data.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: TSQL, MS SQL SERVER 2000/ 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS, SAN, NetAPP, EMC, Query Analyzer, Business Intelligence Development Studio (BIDS)Visual Studio 2005/20, Sybase, VMware, Oracle, Unix, Mainframe, Linux VBScript, .NET, C#, Windows Server 2003/2003R2/2008/2008R2, LiteSpeed, Spotlight, Redgate, IIS.

Confidential

SQL Server DBA

Responsibilities:

  • Database Administration, Database Programming. Migrated SQL server 2000 databases into SQL server 2005 and 20 R2 databases by In-place upgrade and Side-by-Side migration.
  • Solved SQL Server performance issues onVMwareenvironment.
  • Designed and implemented Security policy for SQL Servers.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • 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.
  • Rebuilding the indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies. Implemented and Scheduled Replication process for updating our parallel servers
  • Automated messaging services on server failures, for task completion and success.
  • Intensively used LiteSpeed to take backups.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Monitored and modified Performance using execution plans and Index tuning.
  • Recovering the databases from backup in disasters
  • Maintaining the database consistency with DBCC at regular intervals
  • Configured log shipping for synchronization of database.
  • Good experience in data modeling a metadata services.
  • Expertise in SQL Server Analysis Services.
  • Monitoring SQL server performance using profiler to find performance and deadlocks.
  • To provide 24x7 production support for over 150 SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
  • Involved in Change Data Capture process.
  • To provide direction and development DBA support to over 50 software developers located in various branches in US, Europe, and Asia.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing,, production support and Project review with client.
  • To setup, implement, and maintain industry standards in database management.
  • To maintain change control and release management process for all database objects like tables, views, procedures, and triggers.
  • To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
  • To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development,, QA, and production SQL Servers databases.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and generated reports using Crystal Reports.
  • Developed OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
  • To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
  • Provided 24/7 Support for Production, Development & Test Servers.

Environment: SQL Server 2000/ 2005/2008/2008 R2, Clustering, Replication, Windows Server 2003/2003R2/2008/2008R2, VMware, Visual Studio 2005/2008/2010 , SSIS/SSRS/SSAS, SQL Profiler, Database Engine Tuning Advisor, ERWIN, LiteSpeed, Oracle, Unix, Linux, Mainframe, Sybase, T-SQL, Spotlight, VB Script and ASP.NET.

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Installed SQL SERVER 2005/2008/2008 R2 in PROD/TEST/DEV from scratch. Installed and administered two node cluster Active/passive. Migrated and Documented SQL SERVER 2000/20 R2.
  • Successfully implemented Database Mirroring in SQL Server 2005/2008R2 for high availability on two VMware servers.
  • Configured the compatibility levels of the database and updated software with service packs.
  • Implemented Transactional Replication, Log shipping for database high availability.
  • Regularly installed service packs and hot fixes for both clustered and standalone environment.
  • Implemented and Maintained routine DBA tasks like job scheduling, creating maintenance plans.
  • Creating logins and mapping the user to roles by assigning permissions.
  • Configured the alerts and jobs for the regular monitoring of the database Server.
  • Detected and Resolved locks and deadlocks using the trace flags and native tools like profiler and the activity monitor.
  • Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005.
  • Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
  • Conducted Consistency Checks on the database and analyzed the fragmentation on the indexes.
  • Troubleshooted SSIS packages which failed to execute in the scheduled jobs.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files, etc. to SQL Server using SSIS.
  • Performed development support, document reviews, test plan, integration of the system.
  • Developed and debugged the SSIS packages with lookup, union all, Conditional split and Script task extensively.
  • Involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Experience in improving SQL Server performance by using Index tuning wizards, performance tuning methods, execution plans and SQL Profiler.
  • Retrieved data from partition of the Cube from DATA WARE HOUSE(OLAP ) using the BIDS
  • Interacted with the testing team to fix the bugs.
  • Involved in 24/7 production support.

Environment: SQL SERVER 7/2000/ 2005/2008/2008 R2, MS-Access, Visual Basic, Windows Sever 2003/2003R2/2008/2008R2, VMware, Visual Studio 2005/2008/2010 , LiteSpeed, SQL Compare, Spotlight, Database Engine tuning Advisor, SSIS, SSRS, SSAS, BCP, SQL Profiler, Enterprise Manager, SSMS, SQL Query Analyzer Business Intelligence Development Studio, Index Tuning Wizard, Data Transformation Services (DTS)

We'd love your feedback!