Jonathan W. Rose
Fairfax, Virginia *****
(H): 703-***-**** • (M): 703-***-**** • ***.*.****@*****.***
linkedin.com/in/jonathan-rose-294a6396
Oracle Solutions / Senior Systems Engineer
Technically advanced professional with 16-year track record of planning, designing, and administering innovative solutions in dynamic, fast-paced environments
AREAS OF EXPERTISE
Seasoned in each step of the software development life cycle (SDLC); solid expertise in web application design and implementation.
Skilled in data migration, database installation, and proactive maintenance; able to reliably leverage vast technical knowledge in advancing complex organizational objectives.
Solid history of performing elaborate analysis to locate and eliminate corrupt data, determine source of defects, and apply time-sensitive, appropriate corrective action.
Excel within independent and collaborative environments; capable of rapidly learning and performing new processes and exceeding expectations.
TECHNICAL PROFICIENCIES
Environments:
Oracle, Microsoft SQL Server, MySQL, PostgreSQL, Linux, UNIX, Windows, Domain Name System,
Tools:
SQL, XML, Java, JavaScript, Perl, Apache HTTP Server, Microsoft Office Suite, JIRA, Confluence, Jenkins, Apache Subversion
Methodologies:
PL/SQL, Shell Scripting, Requirements Analysis, Troubleshooting
Professional Experience
Network Solutions, Herndon, Virginia
Senior Systems Engineer / IV (3/2012 – 3/2018)
Orchestrated full-scale development and application of Oracle database. Scrutinized SQL statements and instituted necessary upgrades to stored procedures. Appraised database properties and verified adherence to standards and protocols. Collaborated with software developers in redesigning existing tables. Generated and introduced triggers. Engaged in thorough debugging exercises, promptly rectifying discrepancies. Championed proactive detection and resolution of issues and failures.
Key Achievements:
Created multiple scripts, dramatically curtailing procedural repetition and simplifying processes for new hires.
Repeatedly turned around requests within one to two business days, permitting developers to perform operations without delay.
Recovered development database following major hardware failure, reinstituting program with minimal data loss.
Employed Unix shells and Perl scripting to routinely stimulate productivity and accelerate complex task completion.
Network Solutions, Herndon, Virginia
Senior Systems Engineer / III (4/2005 – 3/2012)
Served in key leadership capacity, overseeing data audit preparation and execution. Instilled confidence in customers, rapidly responding to all concerns and inquiries. Corroborated client data authenticity and assessed functionality. Meticulously managed data cleansing operations. Composed expansive Perl scripts, effectuating task automation and optimizing efficiency. Established valuable relationships with developers, uniting to devise solutions to effectively address client-related issues.
Key Achievements:
Produced hundreds of scripts, enabling staff training efficiencies and cost reductions directly impacting team productivity.
Leveraged expertise in addressing and resolving an eclectic range of product complications.
Collaborated with developers to enhance comprehension of customer data flow, enabling clients to independently manage data.
TRX, Tyson’s Corner, Virginia
Production Support Developer (10/2004 – 4/2005)
Superintended Linux, IBM DB2, and IBM AIX fabrication. Deployed Perl and Java to examine production and correcting oversights. Conceptualized streamlined methods of database loading through ETL solutions. Promoted adoption of commercial off-the-shelf (COTS) applications.
Additional Experience
Nextel/SpecialTech Staffing Solutions Datastage Developer, Consultant • Herndon, Virginia
Verizon/ACF Solutions Programmer/Analyst, Consultant • Herndon, Virginia
Freddie Mac/Systems Engineering Services Corporation Programmer/Analyst, Consultant • Herndon and Tyson’s Corner, Virginia
Global Crossing Telecommunications Software Engineer • Southfield, Michigan
Education and Credentials
MICHIGAN STATE UNIVERSITY, East Lansing, Michigan
Bachelor of Science in Mathematics and Computer Science