Customer Service Oracle

Megan Range

*** ******** **. • Shiloh, IL ***** • *******@*****.*** • 618-***-****

objective

Information systems technical professional with extensive database management, customer service and technical expertise prepared to contribute teamwork and leadership skills in an Oracle Database Administrator role.

Education

CompTIA Security+ certified Dec 2010

Active DOD Secret Security Clearance Granted Oct 2009

Oracle Database Administrator Certified Associate In Progress

Southern Illinois University Carbondale, IL May 2009

Bachelor of Science: Information Systems Technologies

John A. Logan College Carterville, IL May 2007

Associate of Applied Science: Computer Support & Networking: Electronic Systems Technologies

Languages

Oracle SQL Microsoft SQL SQL Plus UNIX Linux

Experience

SRA International Scott Air Force Base, IL Mar ‘12 – Present

Senior Database Administrator for U.S. Transportation CommandMaintain production & development Oracle databases using Oracle Enterprise Manager Database Control & Grid ControlMaintain production & development SQL Server database users, tablespaces, roles & rights using Oracle SQL DeveloperApply major database upgrade from Oracle 10g to 11g on production and development Windows and Solaris servers in both standard and RAC server environments Apply critical patch updates (CPUs) on Oracle databases on Solaris servers using oPatch quarterly and as neededMaintain Solaris database servers using UNIX, connecting via Putty with SSH or direct connections and Bash shell scriptingMaintain backups and perform recovery of data using RMANExposure to Oracle Streams/GoldenGate synchronization softwareCreate database users, maintain access, create synonyms & grant user roles using Oracle Enterprise Manager, TOAD, and Oracle SQL DeveloperMaintain code with SQL Plus, running SQL and PL/SQL commands, writing scripts using SQL and PL/SQLMaintain government standard STIG requirements in regards to database access, government standard security levels, and maintenance of database integrity requirementsPerformance tuning and replication on current projects and capacity planning for future projects and for security testingTransfer Microsoft SQL Server data to Oracle servers using SQL Server Migration Assistant (SSMA) and SSISMaintain SQL databases using SQL Server Management Studio (SSMS)Create and approve data models for database design prior to implementation of new databases and/or new serversTransfer data to servers using WinSCP for updates & upgrades

Complete Professional Services, LLC. Scott Air Force Base, IL Oct ’11 – Mar ‘12

Global Freight and Cargo Policy and Procedure Representative for U.S. Army Surface Deployment and Distribution Command HQUtilize Defense Transportation Regulation (DTR) Cargo Movement and the Military Freight Traffic Unified Rules Publication to provide clarification of policies and procedures on government shipments to global carriersProvide clarification of policies, rules and responsibilities for motor, rail, water, pipeline, air and tank-truck to global freight and cargo transportation service providersAid transportation service providers in providing safe, reliable, and best value service to DoD shippersReceive and process calls/e-mails from global freight carriers requesting technical assistance for SDDC applicationsDetailed documentation of support administered using Siebel 7.8

Dell Services Federal Government, Inc. St. Louis, MO Jun ’11 – Oct ‘11

System/Network Administrator for U.S. Coast GuardExtensive use of Active Directory in verifying, maintaining, and updating user accounts Coast Guard-wideCoast Guard approved software installations and upgradesTransfer active duty USCG members’ data, permissions, and security groups between district servers and between domains ensuring all data, profile, and folder structure transfer successfully using UTT (User Transfer Tool)Create new user accounts for active duty USCG and auxiliary members, unlock accounts, update user info and rates/ranks in Active Directory using ITIL standardsMicrosoft Outlook 2007 configuration, troubleshooting, and repairUpdate user information for GAL listing using DMT (Directory Management Tool)Provide IT software support for active duty USCG members via Remote Desktop and Remote AssistancePlatforms included: Windows XP Professional, Vista, Server 2003, Server 2008Detailed documentation of support administered using Remedy Action Request 6.3 and 7.6

NCI Information Systems, Inc. Scott Air Force Base, IL Jul ’09 - Jun ‘11

Database Administrator for Surface Deployment and Distribution Command HeadquartersMaintain TOPS and DPS production databases and backups using Bourne shell UNIX and Oracle SQL 11gDatabase supported includes 122 servers for all 5 branches of the military, including approximately 3 million usersRun Oracle SQL queries of interstate and intrastate carriers upon request from Naval officersProvide ad-hoc queries, monitoring and problem resolution using SQL in TOADDatabase tuning to improve functionality, performance and efficiencyBackup and recovery of database through Bourne shell scripting and SQL commands on schedule and as neededMonitor and update database and scripts due to major upgrade from Oracle 10g to Oracle 11gProvide database analysis to management using Oracle Applications: Oracle Forms and Oracle ReportsDesktop and laptop tech refreshes throughout SDDC including patch testing and deploymentActive Directory maintenance including new user accounts, updating user information, enabling/disabling users, etc.Broad-spectrum customer service including on-site & remote desktop for desktops, laptops, & Blackberry devicesVarious approved software installation and support throughout organizationHardware support including: CAC reader support, hard drives, RAM, monitors, CD/DVD-ROM drivesDetailed documentation of support administered using Remedy Action Request 6.6

Southern Illinois University Carbondale, IL Aug ’07 - May ‘09

Systems AnalystBroad-spectrum computer customer service, hardware and software on student, faculty, and staff computers for both

personal and work computers and laptopsCampus-wide student and faculty support on various PCs, laptops (HP, Dell, IBM, Compaq, etc), and Macintoshes Platforms included: Windows 2000, Me, XP, Vista (32- and 64-bit), Windows 7; Linux; Macintosh OS 9, OS XVirus detection and removal using CCleaner, Norton, Avast, AVG, but predominantly manual registry editsVPN, TCP/IP and IPv4 configuration for dial-up and Ethernet connectionsMaintenance of network IDs, password resets, e-mail configuration, SIUC web browser configuration standardsSoftware updates for security software, Clean AccessFirewall and security configuration to meet Illinois state requirementsDetailed documentation of support administered using Remedy Action Request

Memorial Hospital Belleville, IL May ’07 - April ‘09

Systems AnalystMonitor ‘Meditech’ database connections, intranet interface, automated scripts, and Gnu Linux print serverMonitor virtual servers using VMWare, and ParallelsTroubleshoot networking both logical and physical and ‘Meditech’ database operationsTroubleshoot hardware and software issues on:

Servers, virtual servers, printers, PCs, laptops, network hardware, heart monitors, battery backups, and cablingPerform daily backup operations using tape drives, ensuring backups ran thoroughly and accuratelyDetailed documentation of support administered using Lotus Notes

SIUC Student Development Carbondale, IL Jan ’05 - June ’05

WebmasterHTML web design using Dreamweaver and line-by-line codingGraphic designs for Student Development functions, web sites, etc. both hard and soft copies (print and web)Web design assistance for RSOs (registered student organizations) per requestDatabase input, design, and maintenance using Microsoft AccessVolunteer experience for Saluki Volunteer Corps

Contact this candidate