We provide IT Staff Augmentation Services!

Database Administrator Resume Profile

2.00/5 (Submit Your Rating)
Hire Now

SELF STUDY:

Used trial versions of SQL Server t study and practice Data Replication, DB Mirroring, Log Shipping, DB Snapshots, Horizontal Partitioning, XML Data Types, Performance Tuning, and other DBA related topics.

WORK EXPERIENCE:

Confidential

Database Administrator/Support Technician

  • Provide database administration and support t customers, nationwide, for SQL 2000 and 2008 database issues related t software developed by ScriptPro.
  • Write SQL scripts related t the above.
  • Troubleshoot SQL jobs related t backups.
  • Perform DB restores as a part of system fail-overs, upgrades, and for other data recovery needs.
  • Use SQL Profiler trace inf t determine source of performance issues.
  • Examine execution plans t further narrow down source of performance issues and find appropriate places t add indexes.

Confidential

  • Developed MS SQL 2005 database for project time tracking on clinical research studies in cardiology treatment outcomes.
  • Developed user interface for database in MS Access using VBA.

Confidential

Database Developer

Provide support and additional development for product developed while under contract with Tek systems. See below.

Confidential

  • Developed MS SQL 2005 database for tracking physicians and their associations with hospitals, practices, medical schools, board certifications, etc.
  • Developed user interface for database in MS Access using VBA.

Confidential

  • Developed SSRS reports and created T-SQL stored procedures, user defined functions, triggers and scripts in SQL Server 2005 2008 for the data behind
  • reports for test results - used by students and faculty at colleges and universities nationwide.
  • reports t look up test data used by customer report reps. t assist students and faculty.
  • reports for modifying test data.
  • Developed DB for Marketing Dept. that included VBA application front end with Access DB and MS SQL DB back end components for importing, filtering, and viewing customer data.
  • Trained under ATI's DBA for general DB Development skills in SQL Server 2005 2008 including SSRS, SSIS, SSAS, Data Warehousing, and OLAP cubes.
  • Continued t perform DB maintenance and troubleshooting on ERI's DBs after ERI was acquired by ATI.
  • Used Activity Monitor t find and kill blocking SPIDs.
  • Monitored replication.
  • Created and modified maintenance plans.
  • Performed maintenance and customer service for ERI's web based and installed software based products.

Confidential

  • Used Crystal Reports t troubleshoot and modify reports created by the accounting system report wizard.
  • Developed VBA apps. Access DBs for customer issue tracking, asset tracking, and order fulfillment.
  • Modified stored procedures t patch test data for student assessments.
  • Wrote T-SQL queries t answer customer questions, adjust student test data, for other reasons.
  • Troubleshot issues with DTS package.
  • Performed DB maintenance and troubleshooting.
  • Used Activity Monitor t find and kill blocking SPIDs.
  • Reconfigured and monitored replication.
  • Troubleshot issues with DTS package.
  • Created and modified maintenance plans for database backups.
  • Tested web site updates and web based application updates prior t deployment.
  • Advanced use of Excel and VBA for Excel.
  • Transferred data between Excel, Acces, MS SQL.
  • Updated web pages sometimes using Dreamweaver Ultradev sometimes by directly editing HTML.
  • Wrote FAQ web page and linked pages with end user instructions.
  • Wrote manuals for software based products.
  • Configured Layer 3 Layer 2 switches t implement VLANs.
  • Deployed and managed antivirus anti-adware/antispyware on servers workstations.
  • Installed and managed WSUS t deploy MS Updates t servers and workstations.
  • Applied Group Policy t control settings on workstations and servers.
  • Installed Win 2000/2003 OS on servers and set up Active Directory.
  • Restored Win 2000 Server and Active Directory from backup.
  • Restored MS Exchange 5.5 server from backup after system failure.
  • Migrated mail server from Exchange 5.5 t Exchange 2003.
  • Developed and wrote procedures including disaster recovery for Exchange Server and Active Directory.

Confidential

Contractor for EDS/Sprint PCS

  • Responsible for equipment tracking, accounting, QA inspection of computer hardware.
  • Contractor for World Travel Partners - BTI Americas Business Travel Agency
  • Troubleshot PC/Network issues including connectivity, printing, e-mail, hardware, and software.

Confidential

  • Operated and programmed CNC Coordinate Measuring Machine t perform statistical reproducibility and reliability studies of manufacturing processes.
  • Developed procedures for ISO9000.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship