We provide IT Staff Augmentation Services!

Sql Server Dba Resume Profile

Skills

Skill

Experience

Last Used

Expertise

  • Experience in SQL Server Software installation, upgrades and administrations
  • 8 Years
  • 2012
  • 3 - Expert
  • Experience in SQL Performance Tuning
  • 6 Years
  • 2012
  • 2 - Proficient
  • Experience in SQL database replication, Mirroring and Reporting Services
  • 6 Years
  • 2012
  • 3 - Expert
  • SQL database Backup and Recovery
  • 6 Years
  • 2012
  • 2 - Proficient
  • Design and Implement SQL database cluster and farm across datacenter
  • 5 Years
  • 2012
  • 3 - Expert
  • Experience with Windows Server operating systems and services

8 Years

2012

3 - Expert

Employment History:

Confidential

Lead SQL Server/ Sybase DBA

Responsibilities:

  • Functional Focus team Lead for SQL Server.
  • Standardize the SQL Server DBA process, best practices and documents for all teams.
  • Performed Lead DBA role in Data Center Migration activities of 100 SQL Servers from Berkley Heights NJ to Conway AR.
  • Provided 24x7 Remote on-call support for SQL Server and Sybase
  • Installed and Configured SQL Server 2005 and SQL Server 2008/R2 Standalone and Cluster servers on Windows 2003 R2 /2008/R2 servers.
  • Upgraded SQL server 2000/2005 databases to SQL Server 2008/R2.
  • Work on Requests through Unicenter ServiceDesk ticketing tools.
  • Setup of Replication, Trouble shooting the issues related to it.
  • Performed SQL Server emergency recovery.
  • Created and managed databases in production and development servers.
  • Managing user security/permissions.
  • Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
  • Involved in installation and configuration of SQL server 2000
  • Perform database maintenance - Backups/restores using SQL Litespeed, Index tuning.
  • Proactive monitoring of space usage and effective capacity planning.
  • Experience in working with Reporting Services to manage reports for organizations.
  • Optimizing stored procedures, Views and defining guidelines for developers.
  • Prepare and maintain SOX Auditing.
  • Responsible for General Database Administration and Performance tuning.
  • Troubleshoot SQL Server issues related to Datacenter migration.
  • Involved in upgradation of Sybase IQ from 12.6 to 15.3
  • Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
  • Perform weekly Sybase IQ maintenance tasks.
  • Apply patches/Service packs to SQL Server
  • Conduct Interviews for new DBA position.

Environment: SQL Server 2000/2005/2008/R2, Win 2003, Win 2008 /R2 Servers, SQL LiteSpeed, Windows Cluster Sybase 12. , 15. , HP UNIX, Powershell.

Confidential

SQL Server DBA

Responsibilities:

  • Primary DBA for 20 applications and 35 SQL Servers.
  • Provided 24x7 Remote on-call supports.
  • Installed and Configured SQL Server 2008 and SQL Server 2005.
  • Upgraded SQL server 2005 databases to SQL Server 2008 and SQL Server 2000 databases to SQL Server 2005.
  • Performed SQL Server emergency recovery.
  • Installed and Configured 64 Bit SQL Server 2005 active active cluster instances.
  • Designed and Implemented end to end activities of Data center move for SQL server from Leonia to Atlanta.
  • Work on Requests through ITSM ticketing tools.
  • Setup of Log shipping, troubleshooting the issues related to it.
  • Created and managed databases in production and development servers.
  • Managing user security/permissions.
  • Perform database maintenance - Backups/restores using Tivoli TSM , Index tuning.
  • Proactive monitoring of space usage and effective capacity planning.
  • Responsible for General Database Administration and Performance tuning.
  • Troubleshoot SQL Server issues related to Datacenter migration.
  • Install, configure and upgrade MS SQL Server.
  • Optimizing stored procedures, Views and defining guidelines for developers.
  • Setting up of Transactional Replication to remote servers.
  • Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
  • Implemented DR tests from 3rd party DR site IBM at Sterling forest NY
  • Enhanced the existing SOX Reports to eliminate hidden privileges to users.
  • Troubleshoot SQL Server connectivity issues using protocols.
  • Experience in working with Reporting Services to manage reports for organizations.
  • Enhanced the existing DR model by renaming the virtual name of DR server to match Production server.
  • Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.

Environment: SQL Server 2000/2005/2008, Win 2003 Servers, SQL LiteSpeed, Windows Cluster, Idera, Foglight

Confidential

SQL Server DBA and Offshore Mentor

Responsibilities:

  • Primary DBA for 40 applications and 150 SQL Servers.
  • Provide transition of new applications to our team.
  • Performed SQL Server emergency recovery.
  • Do initial planning and provide requirement of hardware specifications to application team.
  • Consolidate small mid size databases to our shared form servers.
  • Test and prepare documentation of new hot fix service packs.
  • Work on escalations from offshore team.
  • Installed SQL Server on Windows 2000 Server
  • Provided 24x7 Remote on-call supports.
  • Escalation to Microsoft on critical issues on Production servers.
  • Automated reports to list non-compliance objects for SOX servers.
  • Experience in working with Reporting Services to manage reports for organizations.
  • Installed and Configured 64 Bit SQL Server 2005 active active cluster instances.
  • Upgraded SQL Server 2000 databases to SQL Server 2005.
  • Work on Requests through ITSM ticketing tools.
  • Perform database maintenance - Backups/restores, Index tuning.
  • Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
  • Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
  • Creation monitoring of replication and troubleshooting it in case of failure
  • Proactive monitoring of space usage and effective capacity planning.
  • Monitored and Tuned SQL Performance using SQL Profiler.
  • Troubleshoot SQL Server issues related to Datacenter migration.
  • Optimizing stored procedures, Views and defining guidelines for developers.
  • Responsible for General Database Administration and Performance tuning.
  • Involved in DRP activities
  • Represent SQL team in change control meetings.

Environment: MS SQL Server 2000 / 2005, Win 2003 Servers, SQL LiteSpeed, and Windows Cluster

Confidential

Project Lead

Confidential a leading Financial and Investment bank, Confidential acquired another company Confidential Scope of the project was to migrate the new company's databases into Merrill lynch Data Center and provide 24/7 production support. Project Lead for a team of 23 DBA's in India.

Responsibilities:

  • Worked in UK for 7 months.
  • Managing Huge databases of over 2 T.B
  • Involved in end to end activities of migrating SQL Server Databases from a newly acquired company Mortgages into Merrill lynch Data Center environment.
  • Managing over 250 Production servers and 500 Dev and UAT servers.
  • Upgrade of Databases from SQL Server 2000 to SQL Server 2005.
  • Built 2, 3 and 4 node clusters. Built 2 instances of SQL Server 2005 on x64 2 node cluster.
  • Responsible for General Database Administration and Performance tuning.
  • Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
  • Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
  • Setting up of Escalations to Production and Development SQL Servers.
  • Expertise in Performance tuning using precise 7.5.
  • Setting up of Transactional Replication to remote servers.
  • Expertise in Scheduling SQL jobs through Autosys.
  • Rolling out of changes in production environment through change control.
  • Troubleshoot SQL Server issues related to Datacenter migration.
  • Experience in working with Reporting Services to manage reports for organizations.
  • Expertise in scheduling and restoring of flat file backups from Legato and Tivoli storage manager.
  • Install, configure and upgrade MS SQL Server.
  • Work on requests and alerts through Ticketing tool
  • Performed SQL Server emergency recovery.
  • Conduct technical interview for recruiting new member into team
  • Responsible for providing Knowledge Transfer to new team members
  • Responsible for providing training on new process and technologies
  • Handling day to day issues from client with related to offshore team.
  • Preparing RCA incase of any issues done by my team.
  • Awarded best DBA in this Project.

Environment: SQL Server 2000 /2005, VERITAS Backup, Tivoli Storage Manager, Autosys, Precise, Windows 2003 Server, Win 2000 Prof/Advanced Server, SQL LiteSpeed, Windows Cluster.

Confidential

SQL Server DBA

Confidential now Known as Confidential offers Contact Center and BPO services to its clients in Telecom and Healthcare sectors.

Responsibilities:

  • Provide support to 20 SQL Server 7 and SQL Server 2000 instances running on Windows 2000
  • Implemented Cincom CRM software on SQL server 7.0 database.
  • Installed and Configured OLTP environment for 250 concurrent users
  • Creation of Databases and granting required access
  • Perform database maintenance - Backups/restores
  • Experience in working with Reporting Services to manage reports for organizations.
  • Maintained ER diagrams for each database and data flow diagrams for each applications.
  • Developed Stored Procedures, Triggers and Views for Database Maintenance.
  • Tuned database performance thru SQL Profiler. Tuned memory and server related issues.
  • Optimizing SQL Query and procedures by creating appropriate indexes.
  • Setting up of Transactional Replication to remote servers.
  • Installed SQL Server on Windows 2000 Server
  • Troubleshoot SQL Server issues related to Datacenter migration.
  • Monitoring common performance problem and solving them.
  • Responsible for General Database Administration and Performance tuning.
  • Designed DTS packages to transfer data from different sources such as from Excel, Text file, Access
  • Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
  • Design and implemented Disaster recovery plan.
  • Setting up replication with multiple remote servers to different sites through ODBC using TCP IP connections across WAN.

Environment: MS SQL Server 6.5 / 7.0, WIN 2000 /Advanced Server, SQL LiteSpeed, Windows Cluster, TCP/IP

Confidential

SQL Server DBA / Sr. Developer

Confidential provides various health care insurance policies in India. I was part of 3 member team which designed software in VB for printing the policies of customers.

Responsibilities:

  • Analyzed the existing system and designed application to meet the requirement
  • Designed and created databases after Normalization
  • Developed Stored Procedures, views and triggers
  • Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
  • Setting up of Transactional Replication to remote servers.
  • Developed front end application in VB 5.0
  • Involved in installation and configuration of SQL server 2000
  • Designed output forms using Crystal reports.

Environment: MS SQL Server 7.0, MS Access, VB 5.0, Crystal Reports.

Confidential

Software Engineer

Confidential Technology is a Software development company which developed Inventory system application for their which is Garment Export Company in Chennai and Tirupur.

Responsibilities:

  • Design and creation of databases
  • Creating stored procedures, triggers, and views
  • Optimizing stored procedures and defining guidelines for developers
  • Creating and Maintaining DTS Packages and SQL Agent Jobs
  • Scheduling of Backup and other Maintenance jobs.
  • Managed Users and Permissions.

Environment: MS SQL SERVER 7.0

Hire Now