SEARCH

SQL SERVER DBA Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SQL SERVER DBA
Profile
Seeking a challenging DBA position in an organization that enables me to excel and offers an advancement opportunity with increasing related task knowledge.
Core Qualifications
  • Operating Systems: Windows Server 2012, 2008, 2003
  • Databases: MS SQL Server 2014/2012/2008R2/2008
  • GUI Tools: SSMS, SQL AZURE, SSIS, SSRS
  • ETL Tools: SQL Server Integration Services (SSIS), Visual studio 2010, 2013, SSRS
  • Languages: T-SQL, PL SQL, Basic R language
  • Third Party Tools: Red Gate, SQL Compare, Lite speed, Avamar, Excel, Microsoft Word, Outlook, PowerPoint
  • Ticketing Tools: HPSM, Team Track, DBA Support, Service Now and Service Desk.
Professional Experience
03/2016 to 03/2017Company NameCity, State
  • DATA CENTER MIGRATION: Primary objective of the GOOM project is to migrate the whole datacenter from the old data center to two new data centers (two different regions).
  • As a team, we worked on migrating 180 clusters' and 300 standalone boxes, as a DBA I am not only limited to building and migrating the SQL servers, besides that I used to support production issues, raise the change request (when needed), manage all the databases, and support the other team members.
  • RESPONSIBILITIES:.
  • Administration of Install, Upgrade, Migration of SQL Server 2008 R2 & SQL Server 2012 to SQL Server 2012/2014.
  • Implemented High Availability solutions such as Mirroring, Log shipping, Always on and clustering.
  • Take part in Troubleshooting High availability scenarios involving Clustering, Database Mirroring, Log Shipping, Always on and Replication.
  • Designed and implemented the comprehensive Backup plan and disaster recovery strategies for OLTP databases.
  • Developed DTS Packages to transfer the data between SQL Server database and files.
  • Controlled and monitored user access to the database, backed up and recovered the database, maintained system security and monitored/optimized database performance for Data warehouse and OLTP applications.
  • Managed all aspects of the junior team including day-to-day supervision, performance evaluation, and assignment to IT Projects and Production Support functions.
  • Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
  • Extensively worked on 24 X 7 Production Database on Call Support and involved in troubleshooting SQL Server issues in various levels.
SQL SERVER DBA06/2015 to 02/2016Company NameCity, State
  • Build Team DBA: As a part of SQL build team, we used to configure the SQL servers and work with the application team & vendors to load the required data into SQL servers using the third-party applications.
  • Once the SQL servers are in production as a build team DBA we used to support those SQL servers for certain period and handover them to SQL run team.
  • RESPONSIBILITIES:.
  • Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2012 Server.
  • Configure and supported replication and log shipping in both SQL 2008 and 2012 on OLTP databases.
  • The regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager).
  • Performed many database upgrades using import/export wizard.
  • Designed database Mirroring (synchronous & Asynchronous) as the disaster recovery solution and Log Shipping, Replication, Always On, clustering as the high availability solution.
  • Proactively monitored the database health through automated scripts for checking the database growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
  • Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.
  • Extensively worked on creating the packages using the data tool and liable for Index fragmentation.
  • Extensively worked on 24X7 Production support and involved in troubleshooting SQL servers at various levels.
  • Configuring SQL Server Integration Services (SSIS) & SQL Server Integration Services (SSRS) and granting required access.
  • Participated in the on-call schedule to respond to SQL Server alerts and potential production database issues.
Intern08/2014 to 12/2014Company Name
SQL Server DBA\Developer05/2013 to 12/2013Company NameCity
  • As Intern DBA worked on SQL installation, learned about software Development Life Cycle (SDLC), trained in basic works such as Backup, Restore, Scheduling Maintenance plans, running jobs, Opening tickets for Modifying data on databases.
  • Responsibilities:.
  • Installed SQL Server 2008R2/2012 on windows 2003/2008 on the standalone environment.
  • Migrated SQL server jobs using the Visual studio and SSIS Packages.
  • Migrated DTS packages to SSIS packages.
  • Moved the entire phase from the Staging to the Production.
  • Experience in working with the Backups and Restore.
  • Configured Database Mail for SQL Servers for the Positive Mail Notification.
  • Created Maintenance Plans that helped in effective disk utilization and index maintenance.
  • Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
  • Job Monitoring to ensure all jobs run successfully every night.
  • Reporting on a weekly basis to the project manager.
Education
Master of Science (MS)May 2015Wright State UniversityState, USA
Bachelor of Technology (B. TECH)May 2013Scient Institute of Engineering& TechnologyCity, India
Microsoft Certified Solution Associate(MCSA): Administrating Microsoft SQL DBA (2012/2014)
Accomplishments
  • 1.
  • Designed Alive Human Detection Robot which involves PIR 2.Image sensor Processing for automatic turn on\off lights 3.Implemented FPGA architecture for developing NANO circuits.
  • 4.
  • Designed web application for student Login's and accessing accounts.
  • Vamshikrishna P 2 | Page.
Personal Information
https://www.linkedin.com/in/vamshi-p-44866b108
Skills
Backup, Basic, Clustering, DTS, Data warehouse, DBA I, DBA, Databases, Database, Disaster Recovery, documentation, ETL, GUI, team lead, Scheduling Maintenance, access, Microsoft Certified, Excel, Mail, Outlook, PowerPoint, Microsoft SQL, Microsoft Windows, Windows, Microsoft Word, works, MIGRATION, Enterprise, Operating Systems, PL SQL, Policies, processes, QA, Reporting, SDLC, Servers, scripts, Shipping, software Development, MS SQL Server, SQL, SQL Server, supervision, User Support, T-SQL, troubleshoot, Troubleshooting, upgrades, Upgrade, Visual studio, Windows Server
Additional Information
  • LINKEDIN: https://www.linkedin.com/in/vamshi-p-44866b108
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Wright State University
  • Scient Institute of Engineering& Technology

Job Titles Held:

  • SQL SERVER DBA
  • Intern
  • SQL Server DBA\Developer

Degrees

  • Master of Science (MS) May 2015
    Bachelor of Technology (B. TECH) May 2013
    Microsoft Certified Solution Associate(MCSA): Administrating Microsoft SQL DBA (2012/2014)

Similar Resumes

View All
MID-SQL-SERVER-DBA-resume-sample

MID SQL SERVER DBA

Atlanta, Georgia