David Pinkham Jr
Malden, MA ***** C: 781-***-**** **********@*****.*** www.linkedin.com/in/dpinkhamjr
Database Administrator
Database administrator (DBA) with extensive experience designing, coding, testing, and supporting next-generation database solutions in multiple versions of Oracle. Proficient in an assortment of technologies, including: Oracle 11g, Amazon RDS for Oracle, Oracle Internet Directory, Oracle E-Business Suite, Dell EMC XtremIO, IBM AIX, HP-UX, Red Hat Linux, and Unix. DBA skills include:
Oracle Database Administration
AWS Cloud Administration & Migration
Performance Tuning & Capacity Monitoring
Standby/Failover Administration
Oracle RAC & ASM Administration/Installation
Oracle EBS, SOA, & OBIEE Support
Oracle OID/LDAP
Data Security, Backup, & Recovery
Experience
Agero Inc., Medford, MA
Database Engineer (March 2015 to Present)
March 2010 to Present
Manage Oracle databases on HP-UX, IBM AIX and Red Hat Linux servers. Provide 24 x 7 support for OLTP contact center operations for servers on premise, co-location, and AWS for the largest provider of roadside assistance, accident management services, and telematic solutions in North America. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups for production stability. Ensure technical and functional designs meet requirements.
Key projects:
Migrated multiple databases from on premise and co-location to AWS as part of a corporate initiative.
oSet up failover between different regions using a replicated copy of the database
oMigrated databases from Oracle Enterprise Edition to Oracle Standard Edition in RDS
oMigrated Oracle databases from IBM AIX to Red Hat Linux
oDeveloped process to share encrypted RDS Snapshots between AWS accounts
Lead DBA for Oracle EBS, SOA, and OBIEE databases.
oIncluded the upgrade of Oracle EBS, SOA, and OBIEE databases from Oracle 11.2.0.3 to 11.2.0.4
oMigrated ASM storage to Dell EMC XtremIO
oDeveloped process to create virtual databases using Dell EMC XtremIO
Lead DBA for Oracle Internet Directory Services on premise and in AWS.
oCreated and managed structure of Directory Tree
oCreated and managed ldap.ora files for servers and workstations
oLed the migration of thousands of workstations and servers from tnsnames to ldap files
oDocumented migration process and trained other engineers
Associate Database Engineer (June 2013 to March 2015)
Managed Oracle databases mainly on IBM AIX servers that supported development, qa, and staging operations for engineering teams. Developed and enhanced RMAN cloning and refresh process to support a Disciplined Agile Delivery model. Created specific database profiles to meet security standards for account management.
Accounts Receivable Coordinator (August 2011 to June 2013)
Network Management Associate (March 2010 to August 2011)
Education & Training
Assumption College, Worcester, MA
Bachelor of Arts, Major in Management and Minor in Economics
2005 - 2009
Training: Certified Scrum Training, Disciplined Agile Delivery, ITIL Foundation, Linux Academy: AWS Certified Solutions Architect – Associate Level, Udemy: AWS Certified Developer – Associate 2018