We provide IT Staff Augmentation Services!

Sql Server Dba Resume

4.00/5 (Submit Your Rating)

IL

Hire Now

SUMMARY

  • 3+ years of extensive IT industry experience, as Windows SQL server 2008R2 and 2012 as well as an Oracle Database Administrator handling different versions of Oracle from 10g to 11g on various platforms
  • Planning, designing and building efficient client - specific relational databases.
  • Expertise in creating database objects and structures including, tables, indexes, views, snapshots, stored procedures, triggers, functions.
  • Expert in installing, upgrading SQL Server instances.
  • Possess excellent written and oral communication skills.
  • Knowledge of SQL Server 2008 R2, T-SQL, SSAS, SSIS, SSRS.
  • Knowledge of writing necessary T-SQL to pull data for end reporting.
  • Ability to work independently, with minimal supervision, and deliver results on schedule.
  • Expert in Database Backup and Recovery.
  • Expert with Tuning Tools like SQL server profiler, SQL analyzer.
  • Expert in running Server Side Trace to minimize teh impact of teh trace on teh system, especially for long-running traces on busy production servers
  • Expert in creating a maintenance plan for database performance.
  • Expert in configuring Log Shipping strategy for productions databases.
  • Experience in working with development team, resolving bottleneck issues.
  • Experience in taking appropriate steps to troubleshoot performance issues.
  • Knowledge of HA/DR strategy (Log Shipping, Mirroring, Replication, Clustering).
  • Experience in using SSRS reporting tools to pull data.
  • Experience in using SSIS tool to develop packages from different source (Excel, Notepad etc) to load data into SQL Server.
  • Apply Windows Security patches on a monthly basis.
  • Experiencing in resolving high CPU issues, memory issues when teh problem arise.
  • US Citizen and ability to work with any employer without any issues.

TECHNICAL SKILLS

Operating Systems: Windows, Sun AIX, HP-UX,RHEL

RDBMS: Oracle 10g, 11g, SQL server 2008 and 2012

Tools: SQL server profiler, SSIS, SSRS, Excel, Visio

PROFESSIONAL EXPERIENCE:

Confidential - IL

SQL Server DBA

Responsibilities:

  • Installed, configured, upgraded and managed SQL Server 2008/2012 and upgraded Service Packs for multiple instances.
  • Configured Log Shipping DR strategy for production servers.
  • Performed threshold forecasting, sizing, capacity planning, and trend analysis.
  • Finding long running queries and performed query tuning and applied appropriate indexes to enhance teh performance.
  • Used perfmon as well as 3rd party tool (Solarwind DPA) to monitor production databases and resolved CPU issues and memory issues.
  • Involved in automation of administrative tasks such as creating jobs, schedules, alerts using SQL Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail.
  • Expert in taking backups and restoring SQL server databases.
  • Involved in troubleshooting, fine-tuning of databases and resolving locking issues.
  • Implemented TDE (Encryption) on many production databases.
  • Tuned SQL Statements by looking at teh execution plan to enhance teh performance.
  • Used SSRS tool to pull data for end users.

Confidential - Rosemont, IL

SQL server DBA

Responsibilities:

  • Upgraded and administered SQL Server databases as well as Oracle databases.
  • Created backup copies of SQL Server databases and restored them when needed.
  • Developed RMAN scripts for backup and recovery of databases in Oracle.
  • Worked with development team to resolve issues on a daily basis.
  • Ran scripts to implement changes in teh Database.
  • Ran server side trace on teh production server to find teh root cause of long running queries.
  • Configured DB mail to send out alerts in case of a job failure.

Confidential - Chicago, IL

Database Administrator

Responsibilities:

  • Performed routine DBA tasks such as setting up users, assigning roles, privileges, quotas and monitoring teh database server.
  • Backed up, restored teh database manually and also by scheduling teh jobs and Maintenance Plans.
  • Database Restore and Database Recovery using various tools.
  • Full filled developers request to refresh data on a daily basis.
  • Created maintenance plan to rebuild indexes on a weekly basis and to implement Transactional log backup.
  • Monitored Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Reorganized and rebuilt indexes at regular intervals for better performance.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship