We provide IT Staff Augmentation Services!

Sql Developer Resume

RedmonD

SUMMARY:

  • Over 8 years of experience with recent 8 years of SQL Server DBA extensive experience.
  • Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime.
  • Involved directly with the Project Team, Engineering Team to help and steer them on their new requirements and provided Solutions for the upcoming Change Release to the Project Team.
  • Provided assistance to Project Team with application - related issues or problems.
  • Working on alerts triggered from the Monitoring tool for getting Alerts messages if any job fails, Space Crunch issues, Server downtime, Log files size increases, blocking etc.
  • Creating Service Request for Infrastructure Change of Upgradation of Software, Hardware’s. Working closing with the Engineering Team, Site Services team for any application, server downtime issue. Involved in the Duty Manager escalations for any downtime.
  • Driven the Major Incidence happened for application downtime with several teams across the project and given a resolution.
  • Monitoring all the Environmental SQL Servers / IIS Servers / Windows Servers using the Monitoring Tool - Scom.
  • Excellent troubleshooting and debugging abilities. Possess excellent analytical, communication, and interpersonal skills.
  • Creating Troubleshooting Guide for issues occurred at Service Ops Level and sharing the same with the Line3 Team to predict and prevent problems in future. Also created Knowledge based articles which will help for new onboarding team members.
  • Extensive knowledge and worked with Incident management, change management, problem Management & release management teams in Confidential Corporation.
  • Excellent knowledge on SLA,SOW process models
  • Hands on experience with database backup and recovery
  • Expert in creating standards, compliances, processes and guidelines for database design, coding, test and release and well versed with full SDLC
  • Extensive experience in SQL Enterprise Manager - creating and scheduling jobs, alert and operators with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
  • Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Failover Clustering.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
  • Creation and maintenance of Databases, creating Roles and managing user permissions.
  • Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
  • Extensively worked on DTS, SSIS, Bulk insert, BCP,T-SQL,VB for data transformation and SSRS for Reporting Services
  • Ability to manage and troubleshooting IIS problems/Issues.
  • Setting up sitescope alerts and installation of avicode in web servers.
  • Expertise in monitoring and resolving blocking issues using SQL profiler and DBCC commands.
  • Strong analytical, technical, interpersonal and communication skills.
  • Self-motivated, creative team player with effective communication and leadership qualities.

TECHNICAL SKILLS:

Databases: MS SQL Server 2000, 2005, 2008

Tools: & Utilities: SSRS, Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, SQL Server Management Studio, BCP, DTS Packages

Operating System: Windows 2003, 2008 & Win7

Web Related: IIS Server 6.0 & 7.0, HTML, ASP, XML, .net

Domain Knowledge: PAYROLL and Retail

Monitoring Tools: MOM, SCOM, Keynote and Sitescope

Reporting: Crystal Reports, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Redmond

SQL Developer

Responsibilities:

  • Application support and resolving tickets.
  • Restoring large DB’s in SQL 2005/2008
  • Created automated scripts to validate the schema as per legacy system includes data.
  • Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime.
  • All the Production servers are in NLB and SQL Servers are in Clusters.
  • Working on alerts triggered from the Monitoring tool for getting Alerts messages if any job fails, Space Crunch issues, Server downtime, Log files size increases, blocking etc.
  • Creating Service Request for Infrastructure Change of Hardwares, Upgradation of Software, Hardwares. Working closing with the DCOPS, Site Services team for any application, server downtime issue. Involved in the Duty Manager escalations for any downtime.
  • Monitoring all the Environmental SQL Servers / IIS Servers / Windows Servers using the Monitoring Tool - SCOM and Keynotes.
  • Creating TSG for issues occurred at Service Ops Level and sharing the same with the Line3 Team.
  • Configured the MOM 2005 for sending auto generated mails to the Support Group if SQL/ IIS/ Windows Server causes Issues like heart beat failure, LOG space issue, blocking, failed jobs, Server hung / down etc.
  • Configured the ssmon for sending auto generated mails to the Support Group if SQL/ IIS/ Windows Server causes Issues like heart beat failure, LOG space issue, blocking, failed jobs, Server hung / down etc.
  • Working on issues for SQL Clusters, NLB issues, troubleshooting with log files, replications issues, log shipping issues etc.
  • Installations of the avicode in web servers .
  • Password updates activities on Cluster environments.

Confidential, Redmond

SQL Developer

Responsibilities:

  • Application support and resolving tickets
  • Restoring DB’s in SQL 2005/2008
  • Resolving replication issues.
  • Created automated scripts to validate the schema as per legacy system includes data.
  • Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime.
  • All the Production servers are in GTM and SQL Servers are in Clusters.
  • Working on alerts triggered from the Monitoring tool for getting Alerts messages if any job fails, Space Crunch issues, Server downtime, Log files size increases, blocking etc.
  • Creating Service Request for Infrastructure Change of Hardwares, Upgradation of Software, Hardwares. Working closing with the DCOPS, Site Services team for any application, server downtime issue. Involved in the Duty Manager escalations for any downtime.
  • Monitoring all the Environmental SQL Servers / IIS Servers / Windows Servers using the Monitoring Tool - SCOM.
  • Creating TSG for issues occurred at Service Ops Level and sharing the same with the Line3 Team.
  • Configured the ssmon for sending auto generated mails to the Support Group if SQL/ IIS/ Windows Server causes Issues like heart beat failure, LOG space issue, blocking, failed jobs, Server hung / down etc.
  • Working on issues for SQL Clusters, NLB issues, troubleshooting with log files, replications issues.

Confidential, Redmond

SQL Developer

Responsibilities:

  • Application support and resolving tickets and application deployments.
  • Restoring large DB’s in SQL 2005/2008
  • Created framework for the SSIS Packages
  • Created automated scripts to validate the schema as per legacy system includes data.
  • Created some customization Reports using SSRS.
  • Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime.
  • All the Production servers are in NLB and SQL Servers are in Clusters.
  • Working on alerts triggered from the Monitoring tool for getting Alerts messages if any job fails, Space Crunch issues, Server downtime, Log files size increases, blocking etc.
  • Creating Service Request for Infrastructure Change of Hardwares, Upgradation of Software, Hardwares. Working closing with the DCOPS, Site Services team for any application, server downtime issue. Involved in the Duty Manager escalations for any downtime.
  • Monitoring all the Environmental SQL Servers / IIS Servers / Windows Servers using the Monitoring Tool - SCOM.
  • Creating TSG for issues occurred at Service Ops Level and sharing the same with the Line3 Team.
  • Configured the MOM 2005 for sending auto generated mails to the Support Group if SQL/ IIS/ Windows Server causes Issues like heart beat failure, LOG space issue, blocking, failed jobs, Server hung / down etc.
  • Working on issues for SQL Clusters, NLB issues, troubleshooting with log files, replications issues, log shipping issues etc.

Confidential, Redmond

SQL Developer

Responsibilities:

  • Application support and resolving tickets and application deployments.
  • Installation of CRM on IIS box.
  • Restoring large DB’s in SQL 2005/2008
  • Created framework for the SSRS Packages
  • Created automated scripts to validate the schema as per legacy system includes data.
  • Created some customization Reports using SSRS.
  • Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime.
  • All the Production servers are in NLB and SQL Servers are in Clusters.
  • Working on alerts triggered from the Monitoring tool for getting Alerts messages if any job fails, Space Crunch issues, Server downtime, Log files size increases, blocking etc.
  • Creating Service Request for Infrastructure Change of Hardwares, Upgradation of Software, Hardwares. Working closing with the DCOPS, Site Services team for any application, server downtime issue. Involved in the Duty Manager escalations for any downtime.
  • Monitoring all the Environmental SQL Servers / IIS Servers / Windows Servers using the Monitoring Tool - Sitescope.
  • Creating TSG for issues occurred at Service Ops Level and sharing the same with the Line3 Team.
  • Configured the MOM 2005 for sending auto generated mails to the Support Group if SQL/ IIS/ Windows Server causes Issues like heart beat failure, LOG space issue, blocking, failed jobs, Server hung / down etc.
  • Working on issues for SQL Clusters, NLB issues, troubleshooting with log files.

Confidential

SBE

Environment: Windows 2003, SQL SERVER 2005, IIS 6, T-SQL, SSIS

Responsibilities:

  • SQL server Administration
  • Installation of the SQL 2008 and Lite speed.
  • Building new VM from the scratch.
  • Creating website, SSL s and troubleshooting the issues.
  • Restoring large DB’s in SQL 2005/2008
  • Replication, log shipping and mirroring.
  • Creating the Views, Stored Procedure, Backups and DTS operations.
  • Monitoring Systems for Disk capacity, DB Capacity, Blocking.
  • Monitoring and escalating the issues for web servers and NT servers to appropriate teams and follow up.
  • Taking backups regularly, restoring whenever required.
  • Peer reviews of work items
  • Unit and Functional Testing of Reports
  • User acceptance testing and documentation
  • Involved directly with the Project Team, Engineering Team to help and steer them on their new requirements.
  • Providing Solutions for the upcoming Change Release to the Project Team.
  • Involved as a key member of various projects teams to analyze operational procedures / information generation / utilization needs, etc., covering analysis, design, testing, and deployment of various complex mission critical applications.
  • Provide technical system and database support for Space management, Backup and recovery.
  • Working on alerts that were configured on MOM serves for getting Alerts messages if any job fails, Space Crunch issues, Server downtime, Log files size increases, blocking etc.
  • Creating Service Request for Infrastructure Change of Hardwares, Upgradation of Software, Hardwares.
  • Involved in rebuilding of the Servers, up gradation of Software’s, Security patching on a monthly basis etc.
  • Excellent troubleshooting and debugging abilities. Possess excellent analytical, communication, and interpersonal skills.
  • Applying Patches, Code Drops to UAT & Production Servers and releasing them for further Testing to the Test Team as well as Client for Functionality Testing.
  • Was involved in SQL Server Administration implementing the following concepts. SQL Replication, LOG Shipping in Test / Production environment.
  • Monitoring all the Environmental SQL Servers / IIS Servers / NT Servers using the Monitoring Tool - Confidential Operations Manager 2005.

Confidential

Weekend Analyst

Environment: Windows 2003, SQL SERVER 2005, IIS 6, T-SQL, SSIS

Responsibilities:

  • Application support and resolving tickets and application deployments.
  • Restoring large DB’s in SQL 2005/2008
  • Created framework for the SSRS Packages
  • Created automated scripts to validate the schema as per legacy system includes data.
  • Created some customization Reports using SSRS.
  • Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime.
  • All the Production servers are in NLB and SQL Servers are in Clusters.
  • Working on alerts triggered from the Monitoring tool for getting Alerts messages if any job fails, Space Crunch issues, Server downtime, Log files size increases, blocking etc.
  • Creating Service Request for Infrastructure Change of Hardware’s, Up gradation of Software, Hardware’s. Working closing with the DCOPS, Site Services team for any application, server downtime issue. Involved in the Duty Manager escalations for any downtime.
  • Monitoring all the Environmental SQL Servers / IIS Servers / Windows Servers using the Monitoring Tool - Site scope.
  • Creating TSG for issues occurred at Service Ops Level and sharing the same with the Line3 Team.
  • Working on issues for SQL Clusters, NLB issues, troubleshooting with log files.

Confidential

SQL Developer

Environment: T-SQL, SSIS packages, VBScript, Batch Jobs, Win 2003, SQL Server 2005, IIS 6.0, ASP.NET

Responsibilities:

  • Created Stored Procedures & SSIS Packages for converting their Data from Mainframe to CSV, TXT, and Excel file and from files to their Respective database as required in ORACLE Conversion format.
  • Done the Performance Tuning of their database to meet their timelines.
  • Creating appropriate groups in SQL SERVERS for their Clients.
  • Have done the Query Optimization for their Stored Procedures which were not performing well.
  • Created DBA Jobs for sending Alerts if Blocking Occurred, SQL Job Fails, Updation of Statistics, Backup Restore Jobs, Process Releasing etc on their Production SQL SERVERs.
  • Developed a Maintenance Plan for the SQL SERVER Database for their day to day activities for their Production Environment.
  • Created custom reports as per client request using SSRS.
  • Involved in writing Complex Stored Procedures, Functions, Views, SSIS packages and SQL Jobs for their regular usages.
  • Was involved in SQL performance tuning which involved Selecting and optimizing the Index Selection. Tuning the SQL queries.
  • Was involved in SQL Server Administration implementing the following concepts. SQL Replication, LOG shipping in their Production environment.
  • Creating Backup and Restore plan for Database Maintenance.
  • Debugging the Jobs and Store Procedures.

Confidential

Senior Software Engineer

Environment: Win 2003, SQL SERVER 2005, IIS 6.0, ASP.Net, VB 6.0 and Crystal Reports.

Responsibilities:

  • Involved in Database design and writing complex Stored Procedures, Functions, Views, DTS packages and SQL Jobs.
  • Creation of MIS Reports using Crystal Report and Business Objects
  • Was involved in SQL performance testing which involved Selecting and optimizing the Index Selection. Tuning the SQL queries.
  • Was involved in SQL Server Administration implementing the following concepts. SQL Replication, LOG Shipping in DEV / Test / Production environment.
  • Creating Backup and Restore plan for Database Maintenance.
  • Debugging the Jobs and Store Procedures.
  • Involved in creating Message Queues for different Interfaces to collect data on a remote location.
  • Created Packages, Maintenance plans, SQL Jobs for Internal DBA Team Activities.

Confidential

Developer

Environment: ASP.NET, VBScript, SQL Server 2000, Win 2003, IIS 6.0

Responsibilities:

  • Involved in Design and creation of Database and coding for various stored procedures and Testing.
  • Configured, Upgraded, and documented all MS SQL Server instances that comprise the company's Windows 2000 Server.
  • Developed and documented DBA best practices, development database standards, and created the database security policy affecting a worldwide customer base.
  • Planned and created a managed backup and recovery plan for the company server farm.
  • Facilitated an effective management plan to handle ongoing SQL Server performance monitoring and tuning.
  • Synchronized database staging of pre-populated tables by developing a Data Transformation Service (DTS) plan for point-in-time synchronization of table structure and data changes.
  • Created a series of utility stored procedures, one of which is used in production to encapsulate DTS packages and facilitate data transfers between local databases and remote servers.

Confidential

Developer

Environment: ASP, VBScript, SQL Server 2005, Win 2003, IIS 6.0

Responsibilities:

  • Developed a baseline management plan to facilitate change control in a rapid application development environment.
  • Mentored and taught back-end SQL techniques to MS ACCESS programmers who were new to SQL Server database design, SQL programming, tuning, and client server connectivity.
  • Authored the SQL Server database security procedure and guideline documents, which Improved overall database security management when installing the SQL Server, applying hot fixes, and patches.
  • Testing - Unit Testing & Integration Testing.
  • Synchronized database staging of pre-populated tables by developing a Data Transformation Service (DTS) plan for point-in-time synchronization of table structure and Data changes.
  • Created the environment for LOG SHIPPING, Replication and Additional Server for Scheduled Backup’s and Restoration of the database Periodically through SQL Jobs with the help of SQL SERVER Agent.
  • Creating Backup and Restore plan for Database Maintenance.
  • Debugging the Jobs and Store Procedures, functions, Triggers, DTS Packages etc.

Hire Now