Sql Server DBA
Resume:
Tim Ryf
Dubuque, IA *****
Email: ******@*******.***
EMPLOYMENT OBJECTIVE: SQL Server Database Administrator
EXPERIENCE:
Technical Support Specialist - IBM, Dubuque, IA
June 2009 to Present
Perform Microsoft SQL Server 2000, 2005, and 2008 physical database administration support. Use Remote Desktop, Citrix, and VPNs to connect to client servers over the Internet. Create, modify, detach and attach databases. Execute scripts to modify database objects. Create user logins and assign permissions. Create and modify maintenance plans and jobs. Shrink data and transaction log files. Backup and restore databases. Use Current Activity window to identify any blocking processes and kill processes to allow users to execute jobs. Create and execute Profiler traces. Filter Profiler trace files to identify processes with the highest read and write counts. Use Import/Export Wizard to export tables between instances and servers. Use Replication Monitor to re-start failed agents. Re-create Replication using scripts. Apply Service Packs, patches, and hotfixes. Create Linked Servers. Import and run DTS packages. Respond to emergency pager and conference calls with System Administrators to troubleshoot and correct SQL Server problems. Use Cluster Administrator to bring SQL resources online. Participate in Disaster Recovery exercises which included installing SQL Server software and restoring databases from tapes. IBM and their clients use ticket management software such as Remedy, Managenow, and Peregrine to record tasks and track the time worked for each job. Adhere to Service Level Agreement time frames and definitions for Problem and Change requests. Learning Tree provided a 3 day training course on High Availability. This training covered Log Shipping, Peer to Peer Replication, and Failover Clustering.
Data Processor - HM Graphics, West Allis, WI
May 2005 to Dec 2007
Process data files received from clients. Import data files into Mail Manager database software to modify and encode address information. Create templates, sort routines, and export files
for printing department. Perform Merge/Purge processes and remove duplicate records. Use utility software to defrag hard drives, identify bad sectors, and delete spam files. Import files
into Microsoft Word from Excel for printing. Train co-workers to develop databases and troubleshoot printing errors.
Computer Operator - Monster Worldwide, Milwaukee, WI
April 1997 to June 2004
Create Microsoft Access databases including tables, forms, and reports. Create search and sorting queries. Submit programs to create order forms, write tapes, and print reports.
Assist programmers during the test phase of projects which involved the transfer of files to the Unix system. Read/Write permissions needed to be assigned to files which were received
over the Internet. Convert data from Unix to ASCII format and write files to disks.
CERTIFICATION: MCDBA Microsoft Certified Database Administrator
TechSkills, Brookfield, WI November 2008.
EDUCATION: Associates Degree, Microcomputer Applications Analyst
Fox Valley Technical College, Appleton, WI, May 1987.
Contact this candidate