We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

SUMMARY OF QUALIFICATIONS

  • Senior MS SQL Server DBA with 6 years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2012/2008/R2/2005/2000/7.0 in Production, Testing and Development Environment's.
  • Experience in Data Migration from MS SQL server 2000/2005 to 2012/2008 R2.
  • Implemented SQL Server 2012 in Beta/Test Version
  • Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
  • Expert in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active environments.
  • Implemented Sync and Async MIRRORING for Disaster Recovery Implementation
  • Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like Veritas NetBackup, Sandpiper, TSM and LITESPEED.
  • Expert skills in VMware and Virtual environments
  • Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
  • Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
  • Expert in Creating, Deploying, Scheduling solid ETL Packages in SSIS
  • Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
  • Experience in Software Development Life Cycle SDLC and configuring Alerts using SQL Mail.
  • Expertise in planning and implementing MS SQL server Security and database Permissions.
  • Well aware of SOX compliance, SQL Server change control management and Reporting Services.
  • Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using T-SQL, PL/SQL on Unix and Windows environment
  • Expert in T-SQL writing and developing Database Objects, Triggers, stored procedures, Functions and Views.
  • Expert in Using extensive SQL Server DMV's for performance tuning and Monitoring
  • Sound experience of writing POWERSHELL scripts
  • Developed Oracle based SQL and PL/SQL programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
  • Extensively involved in writing SQL queries Sub queries and Join conditions , T-SQL programming and Query Level Performance tuning
  • Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
  • Proficient in Oracle tools such as TOAD and SQL Navigator
  • Experienced in Loading data into multiple tables using DB Management Tool like SQL LOADER, Import /Export.
  • Experienced in providing quality operational Support for Production Environments
  • Provided 24/7 database maintenance and production support.

TECHNICAL SKILLS

RDBMS

MS SQL Server 2012/2008 R2/2005/2000 Oracle 9i, 10g .

Requirements definition, Systems Analysis and Design

SSAS and Oracle Designer.

Business Process Reengineering

SQL Plus and Visual Studio.

Languages

C, C , Shell Script, T-SQL and PL/SQL POWERSHELL

Knowledge of Corporate Information Factory

SSRS, Crystal Reports 8.5 and VB, Business Objects

Operating Systems

UNIX, Ms-Dos, Ms-Windows 98, 2000 and XP , Windows NT 2000 Advanced Server, Windows Server 2000/2003/2008R2, Solaris and AIX.

ETL/Data Modeling

DTS, SSIS and Informatica.

Other Tools

Toad, SQL Profiler, Query Analyzer, SSIS, ERWIN,VERITAS NetBackup, Sandpiper, MS Office 2000/XP/2003, LiteSpeed, JDBC, TSM, ODBC, OSQL and Shareplex.

PROFESSIONAL WORK EXPERIENCE

Confidential

Role: Senior SQL SERVER DBA

Responsibilities:

  • Production support for SQL server environment.
  • Applied SQL Server service packs and Cumulative updates based on the errors and flaws that are found in the application.
  • Migrated SQL Server 2000 to SQL Server 2005 2008 and SQL Server 2005 to SQL Server 2008.
  • Used Data Transformation Services DTS an Extract Transform Loading ETL tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
  • Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
  • Expertise in SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Extensively worked on Dynamic Management Views DMV's .
  • Implemented different types of Replication Models like Snapshot, Transactional and Merge.
  • Configured and maintained database mirroring and Log shipping for high availability.
  • Managed Microsoft Active Active and Active Passive Clustered SQL Server 2000, 2005 and 2008 environments.
  • Controlled user access rights, and managed data security.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
  • Maintained log shipping for disaster recovery.
  • Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
  • Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
  • Monitored MS SQL Server performance and network issues.
  • Performed Server Application fine-tuning troubleshooting.
  • Created and managed schema objects such as tables, views, indexes, procedures, triggers maintained Referential Integrity.
  • Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
  • Performed DBCC utilities and fixed data corruption in application databases.
  • Managed the use of disk space, memory and connections.
  • Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV's, Wizards and SQL Profiler.
  • Implemented Backup and Restore in SQL Server using Third party tools like Veritas NetBackup, LITESPEED and Sandpiper.
  • Maintained multiple instances SQL Servers with maximum availability.
  • Involved in 24x7 on call support.

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003/2008, IIS 6.0, VERITAS Net Backup, TSQL,VB.NET, Sandpiper, IBM TSM, Litespeed, SQL Job Manager, BMC Patrol.

Confidential

Role: SQL SERVER DBA

Responsibilities:

  • Production support for SQL server environment.
  • Responsible for Query optimization and Performance tuning.
  • Rebuilding of indexes to improve data retrieval performance
  • Managed Microsoft Clustered SQL Server 2005 and 2008 environments.
  • Involved in Migration from SQL 2005 to SQL 2008.
  • Managing server logins, database users and permissions.
  • Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
  • Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
  • Used Data Transformation Services DTS an Extract Transform Loading ETL tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
  • Worked on Data Partitioning and Snapshot Isolation in SQL Server 2008.
  • Used the SQL server integration services SSIS as a part top transfer logins from SQL server 2005 to 2008 and to move data from one server to another server.
  • Configuration and Administration of IIS 6.0, Windows 2003 server.
  • Used DBCC commands to check physical and logical consistency of the databases
  • Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler
  • Involved in coding complex stored procedures and debugging for optimum performance
  • Implemented Backup and restore in SQL Server using Third party tool Idera SQL safe.
  • Maintained multiple instances SQL Servers with maximum availability.
  • Involved in 24x7 on call support.

Environment: MS SQL Server 2005/2008,Windows 2005/2008,Siebel,IIS 6.0, Data Warehousing ,SQL SAFE , TSQL,VB.NET, Snap Manager, SQL Job Manager.

Confidential

Role: SQL Server DBA

Responsibilities:

  • Daily responsibilities include administration and monitoring of Database servers.
  • Fine tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
  • Used Activity monitor and SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
  • Created Users and Roles, and managed security and permission of database
  • Involved in Migration from SQL 2000 to SQL 2005.
  • Implemented and Monitored Transactional Replication in SQL Server 2005
  • Tuning database and SQL statements for optimal performance.
  • Created SQL Server Jobs to automate the running of routine tasks such as backups, restores.
  • Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
  • Maintained log shipping for disaster recovery.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
  • Transferred logins and passwords between instances of SQL Server 2005.
  • Monitoring the event logs and Server error logs for troubleshooting purposes.
  • Created various maintenance plans for the regular databases maintenance jobs in the SQL server.
  • Used different kinds of SSIS packages in order to move the data from one server to another.
  • Providing Mentoring and guidance to the other staff personnel and help desk on database related issues.

Environment: MS SQL Server 2000/2005, Windows 2000/2003 servers, IIS 5.0,VB.Net,T-SQL, Replication, Outlook Express, MS Access.

Confidential

Role: Senior SQL SERVER DBA

Responsibilities:

  • Production support for SQL server environment.
  • Installing and configuring of SQL Server 2012 and 2008R2.
  • Configured and maintained database mirroring for high availability.
  • Implemented different types of Replication Models like Snapshot and Transactional.
  • Extensively worked on Dynamic Management Views DMV's .
  • Expertise in SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS .
  • Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
  • Patched server with latest SQL Server service packs and Cumulative updates.
  • Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
  • Managed Microsoft Active Active and Active Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
  • Installed and Implemented Async and Sync Mirroring / Log Shipping for Disaster Recovery
  • Performed DBCC utilities and fixed data corruption in User databases.
  • Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
  • Created and managed schema objects such as tables, views, indexes, procedures, and triggers maintained Referential Integrity.
  • Implemented POWERSHELL Scripts for Database Administration
  • Performed Server Application fine-tuning troubleshooting.
  • Monitored MS SQL Server performance and network issues.
  • Controlled user access rights, and managed data security.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
  • Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
  • Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
  • Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
  • Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV's, Wizards and SQL Profiler.
  • Implemented Backup and Restore in SQL Server using Third party tool VERITAS Net Backup, SRDF, TSM and LITESPEED.
  • Maintained multiple instances SQL Servers with maximum availability.
  • Involved in 24x7 on call support.

Environment: MS SQL Server 2000/2005/2008/2008R2/2012, Windows 2000/2003/2008R2, VERITAS Net Backup, TSQL, Litespeed, SQL Job Manager, TSM, EG Monitoring.

Confidential

ROLE: SQL Server DBA

Responsibilities:

  • Responsible for Query optimization and Performance tuning.
  • Involved in Data Migration from SQL 2000 to SQL 2005.
  • Implemented database mirroring as a part of disaster recovery plan.
  • Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
  • Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
  • Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
  • Used DTS and SQL server integration services as part of creating the jobs on the server.
  • Configuration and Administration of Windows 2000 and Windows 2003 server.
  • Used DBCC commands to check physical and logical consistency of the databases.
  • Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler.
  • Performed DBCC utilities and fixed data corruption in application databases.
  • Managed the use of disk space, memory and connections.
  • Involved in coding complex stored procedures and debugging for optimum performance
  • Involved with the integration of SQL Server on a Storage Area Network SAN platform.
  • Managed replication issues during DDL changes over data in Production development servers.
  • Implemented transactional replication model and involved in maintenance of the replication.
  • Implemented Backup and restore in SQL Server 2005.
  • Maintained multiple instances SQL Servers with maximum availability.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, IIS 5.0, SAN, .NET, Excel, TSQL, Replication, SSIS.

Hire Now