We provide IT Staff Augmentation Services!

Sql Server Administrator Resume

PROFESSIONAL SUMMARY:

  • Hands on experience in installation, configuration, backup and recovery in SQL Server 2005/2008.
  • Experience in upgrading of SQL server 2005 database to SQL Server 2008.
  • Extensive experience in using T - SQL (DML, DLL) in SQL Server2008/2005 platforms.
  • Experience in creation of database authentication modes, configuring permissions and assigning roles to users.
  • Experience in performance monitor, tuning and query optimization
  • Experience in creating jobs, alerts, schedules, Database Mail using SQL Server Agent.
  • Knowing Link Server, Data Mirror, Replication, Log Shipping and Cluster Failover
  • Knowing in using SQL Server Integration Services(SSIS) to build Data Integration and Workflow Solution, Extract, Transform and Load(ETL) solution for Data warehousing applications
  • Knowing in creating several reports such as drill down reports, parameterized reports, linked reports and chart reports using SQL Server Reporting Services

TECHNICAL SKILLS:

Databases: SQL Server 2005/2008, MS Access, MS Excel

Programming Languages: T-SQL, Visual Basic, VB.NET

Operating Systems: Window Vista, Window 2008 Server, Window 2003 Server

BI Tools: ETL, DTS, SSIS, SSRS

PROFESSIONAL EXPERIENCE:

SQL Server Administrator

Confidential

Responsibilities:

  • Install and configuring SQl Server and software
  • Up gradation of database from SQL Server 2005 to SQL Server 2008
  • Monitor, tune and analyze database performance and locate server resource to achieve optimum database performance
  • Manage SQL Server privileges and permissions of all database users
  • Created backup and restore procedures to the databases as a recovery method.
  • Created jobs, alert and schedule backup, database and transaction log fail
  • Migrate data movement between source and destination system (excel, access, text file, SQL server) using Import and Export Wizard
  • Performance tuning of SQL queries and store procedures using SQL Profile and Index Tuning Wizard

Hire Now