Engineer Oracle
Resume:
Frank Curcio
*****.******@*****.***
TECHNICAL SKILLS
●Software Languages: SQL, PL/SQL, UNIX/Linux shell scripting, Python, XML, C, C++, HL7.
●Software Tools: Oracle RDBMS 9i/10g/11g/12g, Oracle RAC, Data Guard, ASM, SQLPlus, Oracle Data Pump, Amazon Redshift, Amazon S3, PostgreSQL, Vertica, AWS Pipeline, Tableau, Visual Studio C++
PROFESSIONAL EXPERIENCE
American Kennel Club (contractor via TEKSystems) Dec 2017-present
Database Administrator
● Tech Lead on Database Migration project, Oracle on-premises to AWS
● Create and manage Test, Stage and Production databases on Amazon EC2 servers
●Maintain standalone and Oracle RAC test and production instances
●Collaborate with cross functional teams within company using Agile software development methodology
● Design and implement backup and recovery strategy for new AWS databases
● Supervise offshore team of DBA contractors
Fujifilm Medical (contractor via Resolvit) 2017
Database Administrator
● Maintained and monitored Oracle databases for all phases of SDLC
● Performed backups and restores using RMAN
●Performed Oracle imports and exports dictated by development needs
● Improved query performance by working with development teams
● Created tables, views, procedures and functions as needed
Digital Turbine 2015 – 2016
Database Developer
● Created and maintained test and production AWS Redshift and PostgreSQL databases
● Utilized AWS Pipeline for ETL of Amazon S3 data to Redshift
● Created database views to interface with Tableau and internal reporting tools
● Troubleshot database and ETL data integrity issues
● Assisted development teams with writing queries, views and SQL commands
Compliance Implementation Services (CIS) 2014 – 2015
Database Developer
● Designed and modeled database structures for data analytics
Wrote Python scripts to augment ETL process
Installed and maintained test and production PostgreSQL databases
Created and executed ETL jobs connecting Talend to databases
Created database views to interface with Tableau reports
Fidelity Investments, Inc. (Contractor via Veritude) 2013 –2014
Oracle Database Administrator
● Executed Oracle imports, exports, backups and installs
● Diagnosed and correct problems with Oracle Advanced Replication
● Used SQLPlus and SQL Developer for daily duties
● Performed database upgrades and clone development and ASM databases
● Created LINUX shell scripts for RMAN database backups
Truven Health Analytics (Formerly Thomson Reuters Corporation) 2003 – 2013
Oracle Database Administrator 2007 – 2013
●Lead DBA on Thomson Reuters’ Charge Capture project
●Added nodes to RAC clusters and troubleshot RAC issues
●Designed, wrote and modified Oracle database tables, views and procedures for new and existing company products
●Created and maintained database builds
●Installed, maintained and tuned in house development databases
●Internally supported test and production environments using Red Hat Linux servers
●Utilized Oracle Job Scheduler to load data and Oracle monitoring to monitor data and compile information
(As MercuryMD, Inc.)
Database Administrator/Developer 2005 – 2007
●(Acquired by Thomson, June 2006)
●Lead DBA for QA team
●Installed and maintained more than 200 production and test databases for external customers
●Responsibilities included daily monitoring of customer databases installing Oracle software and patches
●Creating databases for new customers and performing database tuning to maintain performance benchmarks
Implementation Engineer 2004 –2005
●Integrated MercuryMD software with existing Hospital Information Systems
●Wrote Python and C++ functions to enable integration of new customers’ systems
Customer Support Engineer 2003 – 2004
●Lead engineer on MercuryMD Customer Support team. Diagnosed and repaired customer reported problems with software and database configurations
Tivoli Systems, IBM 1997 – 2001
Software Engineer
●Level 3 support of IBM’s NetView and Tivoli Decision Support
●Fixed C++ bugs reported by Level II support
●As Database Interface Engineer for Tivoli Decision Support, installed, maintained and tuned Oracle, DB2, Sybase and Informix databases on AIX and SUN Solaris platforms
CERTIFICATIONS/TRAINING
●Oracle Certified Professional DBA training, DBBasics, Inc, Durham, NC.
●Oracle Certified Professional DBA
EDUCATION
Virginia Polytechnic Institute and State University
B.S., Management Science Decision Support Systems
Contact this candidate