We provide IT Staff Augmentation Services!

Sql Server Developer/ Dba Resume

SUMMARY:

  • Over 5 years of experience as SQL Server Developer/DBA (2005, 2008, 2012,2014) in Production, Development and Staging Environments.
  • Performed Installation, Upgrades, Patches, Configuration and Administration SQL Server Development & Production Environments.
  • Involved in migration of database and SSIS Packages 2005/2008 to 2012 and troubleshoot migration issues
  • Experience in Upgrading the database version from SQL Server 2005 to SQL Server 2008 & SQL Server 2012
  • Extensive experience in writing T - SQL as part of developing database schema & objects.
  • Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
  • Experience in Configure, Implement and Maintain HA solutions including Log Shipping, Transactional Replication and Mirroring in SQL Server 2008/2012 versions.
  • Optimize T-SQL code for better performance of the queries without compromising the business requirements.
  • Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel sources
  • Involved in Designing the backup and restore strategy based on database criticality with minimal RTO
  • Expertise in Scheduling Database tasks - Jobs, Alerts, Emails and Notification.
  • Experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
  • Knowledge in optimizing the database query performance using Activity Monitor, SQL Profiler and Database Tuning Advisory tool.
  • Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling
  • Experience in Monitoring and troubleshooting SQL Server performance using DBCC Commands, Dynamic Management Views (DMVs) and performance counters.
  • Experienced in T-SQL programming tasks-Stored Procedures, Triggers and Cursors
  • Knowledge in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
  • Involved in VLDB data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert based on requirement.
  • Provide on-Call Support for Production Database.
  • Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets.
  • Good knowledge in OOP’s concepts and Business Objects & Database analysis and database design experience using Erwin.
  • Working knowledge of .Net Framework 3.5 (VB.Net), IIS 6.0
  • Strong Communication & Management skills and Excellent Team player.

TECHNICAL SKILLS:

Databases: SQL SERVER 2005/2008/2008 R2/2012/2014

O/S: Windows Server 2003/2008/XP/98

Programming Languages: T-SQL, VB 6.0, VB.Net, C#, VBScript

Web Technologies: Asp.Net, HTML, XML, IIS 6.0, Java Script

Tools: MS Visual Studio .Net 2003, Quest LiteSpeed 5.0/4.5,Toad for SQL Server, VERITAS Netback up, Erwin, BMC Portal

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Developer/ DBA

Responsibilities:

  • As a team member I was part of SDLC in which we designing, coding and testing the application
  • Interact with BA to collect the requirements and interrupt the user requirements to write in VB.NET language
  • Developed ASP.net pages to meet the business requirements and also involved in requirements gathering
  • Implemented input validation using the Java Script.
  • Creating and maintaining user and technical documents
  • Worked with the team for coding and handled coding of batch process operation
  • Created the triggers, functions and stored procedures in SQL Server 2005/2008/2012/2014 versions
  • Implemented changes in coding and designs using knowledge of VB .NET
  • Conducted release testing, bug verification and software testing
  • Worked and enhanced the flow of internal applications like PRM (Public Relations Management) and Help Desk Support application.
  • Involved in Creation of logins, Users as per Security standards and groups, roles, jobs, alerts and sending mail confirmation upon tasks. Performed Uploading of bulk data using BCP Utility
  • Responsible for validating the T-SQL Queries for effective performance and coordinate with the application team
  • Database support with Store Procedures, Cursors and Queries, monitoring the flow of Order Management by the Oracle Back-End support using TOAD tool.
  • Performance tuning with application teams to isolate and resolve performance issues
  • Implemented DB schema changes in SQL server 2014 as part of performance improvements.
  • Involved in Creation of databases, writing queries, monitoring of execution plan for tracing the execution flow for critical throughput.
  • Evaluated data storage considerations to store databases and transaction logs.
  • Created databases using SQL Server enterprise manager, Database Wizard and Transact SQL Statements.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS and also prepared ETL mapping processes and maintained the mapping documents
  • Work closely with the application team on the Migration and Upgrade SQL Server version 2005 to SQL Server 2014.

Environment: VB.NET, C#, IIS, SQL Server 2005/2008, DTS, Import/Export tools

Hire Now