PAULA PAGE

*** ************ **** ***********, ** 25405 304-***-**** admwcz@r.postjobfree.com

SUMMARY

I worked on a project with a team of Application Developers to rewrite an overly complex system that interfaced with number of other systems. I wrote SQL Server scripts which include stored procedures, schemas, tables, indexing, functions, and triggers. I also created SQL Jobs and PowerShell scripts, database backups, database restore and performing all other Database Administration duties. I also maintain documentation for flowcharts, data dictionary and contingency plan.

I have 8 years of experience as a Software Support Specialist/ Database Administrator in a medical practice consisting of 37 doctors. I have experience working with Billing System, EHS systems and various other systems. I was responsible for creating procedure and policy for dataflow between internal systems and external systems. I have experience in creating an HL7 message interfaces as well as creating and importing data through xml files. I have experience with creating Financial Reports and Validation Reports for integrity check. I setup up an ETL server for more reporting and to generate patience’s charts in case of a power outage.

As the only IT person for a small company, I was responsible for every function of an IT Department. I ran cables from jack to the panel in order to save the company money. For my classes, I created training material for the end-users.

I performed Administrative duties for the Novell Network which included: setup of user’s accounts, user’s network storage, and network printers. I purchased all equipment and strategically planned the location of all shared devices.

I have excellent troubleshooting and problem solving skills which promoted me to being a Tech lead. As a tech lead, I gained the respect of my team and end-users. I taught my techs the importance’s of having/maintaining a good rapport with all the end-users.

EDUCATION

B.S. Degree in Computer Science: Judson College, Elgin, Illinois, May 1991.

CERTIFICATIONS, TRAINING AND SECURITY CLEARANCE

Security + 2021-2024

A semester class in Oracle at Illinois Central College in 2003

A semester class in Networking at Illinois Central College in 2003

HTML through /Professional Development Institute

Microsoft Access through Professional Development Institute

Novell Network Administrator through Professional Development Institute

PC Repair through Professional Development Institute

Secret Clearance

TECHNICAL SKILLS

Tools and Software: Microsoft Office (Access, Excel. PowerPoint, Outlook, Word and OneNote), Crystal Reports, Cloud Services and ETL (SSIS and DTS), Erwin Data Modeling

Languages: Cobol, ASP.Net, VB.Net, PowerShell, and HTML

Databases Oracle 12c, Microsoft SQL Server 2000, Microsoft SQL Server 2008, Microsoft SQL Server 2012 and Microsoft SQL Server 2012,

Hardware Custom Built PC, Compaq Servers, HP Servers, Dell Servers, Dell PCs, HP SAN, HP/Lexmark/Xerox Printers and PrintServers

Operating Systems DOS, Novell, Windows 7-10, Windows Server 2008-2012, Unix, VMware

Networking Protocols: TCP/IP, IPX/SPX, WEP/WAP, DHCP, DNS, WINS, VPN via PPTP / L2TP, LDAP, SMNP, FTP/TFTP, SFTP

PROFESSIONAL EXPERIENCE

February 2019 – Current, Database Administrator (Contractor at FT Detrick)

Install SQL Server 2012 and 2014 and Oracle 12c

Configured/Maintained SQL Server Jobs and Task/Jobs for Oracle, Performance Tuning, Monitoring and Troubleshoot Day to Day Operations

Created/Modified Database Model Diagram and Database Dictionary, Documentation

Design and Execute database Backup, Recovery and procedures, including Disaster Recovery for both Oracle and SQL Server

Configure the Database side of Share Point 2016

January 2016 -- November 2018, DMI, Database Management Specialist (Contractor for USCG)

June 2010 -- December 2015, Database Management Specialist (Contractor for USCG)

January 2010 – May 31 2010, Stanley Associates, Inc., Database Analyst III (Contractor for USCG)

Design and Maintain complex databases

Created stored procedures, functions, triggers, indexing

Created SSIS packages for Data Migration

Created as-hoc queries and generated reports for users in a timely manner

Worked closely with Programmers to provide data source for application development.

Configured and Maintained SQL Jobs and SSIS Packages, Performance Tuning, Monitoring and Troubleshoot Day to Day Operations

Created/Modified Database Model Diagram and Database Dictionary, Documentation for the setup of a Mission Essential System, Monitor Standards and Procedures and Integration of Systems through Database Design

Design and Execute database Backup and Recovery and procedures and including Disaster Recovery

Managed, Replication, Microsoft Windows Failover Clustering, Database Mirroring and Database Snapshot

STIGs implementation

August 1999 – August 2008 HeartCare Midwest, Software Support Specialist/ Database Administrator

Responsible for database maintenance on all database applications which includes GE Logician (EMR application), GE Practice Management (Billing system), and Medtronic Paceart application and custom in-house applications.

Database Maintenance consists of implementing and monitoring ongoing database maintenance plan in regards to performance, tuning, backup and recovery, and providing technical support for the data replication database.

Monitored and troubleshoot SQL Server and hardware utilization and responsible for new server recommendations.

Performed software upgrades on SQL Server databases.

Developed complex queries, stored procedures, functions, DTS packages, and triggers, table indexing.

Automated data extraction into client or vendor format specifications.

Setup FTP server to send and receive data files to and from clients and vendors.

Data reporting for day-to-day operations including financial outcome of gains and loses, using Crystal Reports, Excel, Access, Monarch and other reporting tools.

Implemented and monitored the vendor’s HL7 interface applications.

Designed and implemented custom in-house applications using ASP.Net and VB.Net.

Recommend the appropriate cost effective tools by assessing the current operation/function and the needs of the end-users as well assessing current tools available.

Design and created databases in Access and MS SQL for in-house applications.

Created an Insurance database for the Billing Dept in Access from an Excel spreadsheet for the purpose of simplifying and maintaining the process of data entry and searches.

Designed and Developed a Patient Chart Summary database and report from two different types of SQL database platforms for case of power outage in order to continue the day to day clinical functions.

The ability to develop a good rapport with end-users to inspire confidence within and to achieve the appropriate and desired outcome.

Maintained and monitor database integrity including data input.

SSIS Data Migration, ETL processing

Review and develop communication between various platforms of databases.

Created testing environment for upgrades and new projects.

Created HL7 messages from an external vendor’s data dump.

Research and analyze applications issues and communicate with vendors to resolve any issues.

Log and document all daily activates and helpdesk request through a Helpdesk and Tracking system.

Performed Administration duties on a Novell Network, Windows Server 2000/2003, Unix, AIX.

Performed Administrative duties: setup user’s accounts, network storage, and network printers.

Responsible for hardware repair and software installation.

Used Zenworks and Norton Ghost.

Trained users in Windows Operating System, Microsoft Office (Word, Excel, Access, PowerPoint, and Outlook), Groupwise, WordPerfect, and Quattro Pro.

Recovered files from backup tapes.

Network wiring from wall jack to patch panel.

Use JetAdmin for use with network printers.

August 1997- March 1999, Systems and Computer Technology, Microcomputer Specialist - Lead Technician

Responsible for hardware repair and software installation

Trained users in Windows Operating System, Microsoft Office (Word, Excel, Access), and Email for all of Peoria County government

Perform network administrative duties on IBM Mainframe, Windows NT

Setup users accounts, users network storage, and network printers

Use backup software to backup network files to tape

Recovered files from backup tapes

Performed printer repair on HP Laser, IBM Laser, and dot matrix printers

Network wiring from wall jack to patch panel

Use JetAdmin for use with network printers

Log and document all daily activates and helpdesk request through a Helpdesk and Tracking system.

August 1994 - August 1997, Peoria Association for Retarded Citizens, EDP Network Supervisor

Performed Administrative duties: setup users accounts, users network storage, and network printers

Responsible for pc-setup, hardware repair and software installation

Trained users in Windows Operating System, WordPerfect, and Groupwise

Network wiring from wall jack to patch panel

Recovered files from backup tapes

Use JetAdmin to setup network printers

Contact this candidate