Sql Server Oracle
Resume:
Corinne Johnson
PO Box ***
Union, ME *****
Email: *******.****@****.***
SUMMARY:
Oracle Certified Professional Database Administrator with 10 year’s experience in Oracle, Sql Server and
Maxdb database administration in a large production environment. Highly proficient in all Microsoft Office
Suite products. Proven ability to plan, organize, and prioritize multiple projects and identifying areas for
process improvements. Innovative and resourceful, seizer of opportunities, and consistently achieve goals
and objectives. Received ‘EXCEEDS’, highest performance rating, for three consecutive years.
TECHNICAL KNOWLEDGE:
Databases: Oracle; Sql Server; SAP MaxDB; MS Access
Platforms: Windows 2000 - 2008 R2; AIX 6.1;VMware; SUN Solaris
Technologies: Microsoft Office Suite; Oracle RMAN and Data Guard; SqlPlus; Transact Sql;
Programming: Unix Shell Scripting; PowerShell; PL/SQL; Visual Basic
Application Environment: SAP; PeopleSoft; ERP; CRM; PLM; EDOS; BW; JDA Manugistics; Vendavo;
SharePoint
WORK EXPERIENCE:
OSRAM Sylvania, 100 Endicott Street, Danvers MA 01923 2005 – Dec 31, 2012
System Analyst
• Production database administrator working with a team managing over 500 Sql Server and 70 Oracle
production database systems in SAP, PeopleSoft, ERP, CRM, PLM, BW, SharePoint environments.
• Run weekly comprehensive security scans against all production databases.
• Report and plan for securing system vulnerabilities.
• Implement Sarbanes Oxley and internal auditing security requirements.
• Research, plan, and document software upgrade and patching procedures for Oracle, Sql Server and SAP
MaxDb systems.
• Plan, coordinate and document routine annual disaster recovery testing.
• Train Penang Malaysia staff resource for on-call database support for space management and data guard
troubleshooting to establish weeknight on-call support relief.
• Cross-train peers on knowledge acquired from independent research, self-training, and instructor led
training.
• Process Improvements proposed and accepted by management; Mandatory peer review of written
procedures for upgrades and patches prior to applying; Developed and implemented log shipping disaster
recovery solution for SAP MaxDb production systems; Developed PowerShell scripts to automate the
management of files on local and remote Windows systems.
PFPC Global Fund Services: 66 Broadway, Lynnfield MA 01940 1997 – 2005
System Analyst
• Assist developers with database design and normalization.
• Integral member of high profile migration project involving database consolidation and migration of data
and applications from MS Access, Excel to Oracle on Red Hat Linux.
• Responsible for database and server capacity analysis, Linux file system design for interfaces, database
design and object creation, modification of interface and database scripts, unit testing and migration.
• Responsible for production database run and maintain, upgrades, patches and performance tuning.
• Established standards and schedules for database backups and recovery.
• Responsible for the automation of data loads, utilizing skills in shell scripting, Sql*Loader, FTP and
PL/SQL procedures, triggers and crontab jobs.
• Automated database administration tasks utilizing UNIX scripting and crontab jobs.
EDUCATION:
Computer Science Degree Program 2010 – 2012
Northern Essex Community College, Haverhill MA
Programming Certification; New Hampshire Technical College, Stratham NH, 1997
Business Management Information Systems Concentration; Northeastern University and Newbury
College 1993-1997
Microsoft, Oracle, IBM and SUN Microsystems Education Services:
Microsoft PowerShell; Microsoft Research and Development Center, Cambridge MA, 2012
Oracle Professional Database Administration Certification 10g, 2010
SQL Server 2005; Microsoft Corporation 2009
SQL Server 2000; Learning Tree 2005
IBM Certificate AIX Sys Admin II: Problem Determination, 2006
IBM Certificate AIX Sys Admin I: Implementation, 2006
Oracle Professional Database Administration Certification 9i, 2004
Oracle Professional Database Administration Certification, 2003
Shell Programming; Sun Microsystems Inc., Burlington MA, 2002
Fundamentals of Solaris 8 Operating Systems, Burlington MA, 2001
Oracle Network Administration; North Shore Community College, Beverly MA, 2001
Oracle Performance Tuning; North Shore Community College, Beverly MA, 2001
Oracle Backup and Recovery; North Shore Community College, Beverly MA, 2000
Oracle Database Administration; North Shore Community College, Beverly MA, 2000
Oracle Program Units; Oracle University, Boston MA, 1999
Intro to Oracle, SQL and PL/SQL; Oracle University, Boston MA, 1999
Contact this candidate