We provide IT Staff Augmentation Services!

Software Engineer Resume

OBJECTIVE

  • To achieve a challenging position as an MS SQL Server Database Administrator in a result - oriented company, where my acquired skills and education will be utilized towards continued growth and advancement.

SUMMARY

  • Over 3+ years of experience as an MS SQL Server Database Administrator driving high availability and security in Production Environment.
  • Maintained over 2000 production MS SQL Server 2000/2005/2008 and SQL Cluster Servers in worldwide wif 24X7
  • Improved and maintained the high availability of 24X7 production servers wif disaster recovery management which includes Database snapshots, Backups, Standby servers(Log shipping), Replication and Clustering.
  • Good experience on setting up and troubleshooting of Log shipping and Replication for MS SQL Server 2000/2005
  • Monitor and troubleshooting SQL Performance using Perfmon, Profiler and system tables.
  • Troubleshooting issues like Locking, Blocking and Deadlocking.
  • Installing and Configuring SQL Litespeed, third party tool for SQL server backup and recovery.
  • Handling user requests like point in time restores, Database restore requests from tape Backups

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008

Operating Systems: Windows 98/NT/2003

Languages: Core Java, Servlets, JSP

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer

Environment: Windows 2003, MS SQL Server 2000/2005/2008 , SQL Litespeed

Responsibilities:

  • Installing and Configuring of MS SQL 2000/2005/2008 .
  • Installing Service Packs
  • Installing and Configuring SQL Litespeed, a third party tool for SQL server backup and recovery
  • Monitoring Production server issues through ITSM queue and troubleshooting and resolving the incidents.
  • Troubleshooting Log shipping, Database Mirroring, Replication, SQL clustering issues.
  • Handling user requests like point in time restores, Database restore requests from tape Backups
  • Monitoring Backup jobs and DBCC jobs
  • Doing regular server health checks before starting the business hours.
  • Server maintenance on Weekends like rebuild indexes and updates statistics to improve the Performance.
  • Maintaining SLA and implementing Production changes and attending change management calls and Problem management calls.
  • Providing 24*5 support

Confidential

Software Engineer

Environment: Windows 2003, MS SQL Server 2000/2005/2008 , SQL Litespeed

Responsibilities:

  • Monitor and troubleshooting SQL Jobs.
  • Worked on the space requirement of data, checking the data, checking the data & log file growth.
  • Monitor and managing event viewer.
  • Documentation of day to day problems and solutions.
  • Working on the alerts generated from various production servers. The basic alerts would be Disk capacity Full, Log Full, Blocking, Deadlock, Server Down, Database suspect, SQL job failures, Logshipping out of sync, Memory Alerts Etc.
  • Monitor and troubleshoot SQL Performance using Perfmon, Profiler, and system tables
  • Monitor, analyze and troubleshoot SQL server concurrency issues like blocking and deadlocks using system tables and DMVs. Provide feedback on code improvements to app teams where ever applicable.
  • Design and Troubleshoot SQL Server high availability using Log Shipping, Database Mirroring, Replication and Clusters.
  • Keep the knowledge base updated wif new troubleshooting information and procedures.

Confidential

Junior SQL DBA

Environment: MS SQL Server 2000/2005, Windows 2003

Responsibilities:

  • Installation & Configuration of MS SQL Server 2000/2005.
  • Creation of logins, Roles and granting rights
  • Database backups and restoration.
  • System Performance monitoring and tuning
  • Ensuring high availability of the database through log shipping and mirroring.
  • Configuring alerts.
  • Monitoring Log files size and Database files size.

Hire Now