James McBride
Longmont,CO
Summary
Senior Software Engineer who installs and operates Oracle and Postgres databases on Unix systems, driving customer satisfaction, mentoring teammates, and optimizing financial performance for IT departments.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior Engineer, Oracle/Postgres DBA
USDA Forest Service
01.2023 - 01.2025
- Led migrating Oracle from RedHat Linux 7 to 8 for 70 servers
- Team lead for Oracle Recovery Manager and Oracle Internet Directory (OID). Mentored others on how to apply security patches to OID but still took responsibility. Lead for fixing security scan findings.
- Developer and level 3 support of Oracle and Postgres deliverables: Single Sign On (SSO) using Oracle Enterprise Users with Oracle Internet Directory, Oracle Recovery Manager, Postgres user and group provisioning (pg-ldap-sync), Oracle integration with Splunk
- Wrote 90% of the Postgres Security Technical Implementation Guides (STIGs) checks for 120 checks
- EDB Failover Manager (EFM) and pgBouncer: designed and implemented failover solution. Project lead called it a “world class solution.”
- Integrated Splunk with EnterpriseDB Postgres Advanced Server (EPAS) Security Auditing
- Ansible subject matter expert for team, for reports, and OS and database administration
- Postgres skills: pg_hba.conf, EnterpriseDB migration toolkit
- Obtained and implemented SSL/TLS certificates from Certificate Authority for Oracle Internet Directory and EDB Postgres Advanced Server
- Most production database restores in the enterprise
- Federal agency serving United States natural resources.
Senior Engineer, Oracle DBA
TechTrend
01.2020 - 01.2023
- Disaster Recovery for High Availability Clusters, Auditing, Critical System Security Patches for WebLogic, and Oracle Identity Manager for business operations (40,000 end users). Project lead for of the Recovery Manager backup solution as a contractor. Administered database operation and maintenance, including ensuring databases efficiently collect, store, and process large volumes of data.
- Designed, developed, delivered Postgres user and group provisioning from Microsoft Active Directory objects. Extensive database design. Customized 50% of 1,000 lines of Ruby from public git repo—added in single sign in capabilities.
- Evaluated and determined feasibility of PostgreSQL integration with Forest Service Active Directory for user authentication. Successfully demonstrated to the Geographic Information Services (GIS) management and users. Implementing solution for Postgres and Oracle. Coworker: "Your help has been invaluable. I can’t thank you enough."
- Project lead to develop migrate Oracle Internet Directory (OID) from version 12.2.1.3 to 12.2.1.4.
Senior Engineer, Oracle Database Administrator (DBA)
Bristol Bay Native American Corporation, and subsidiaries
01.2012 - 01.2020
- Project lead successfully developed software packages for Oracle to Active Directory Integration for US Department of Agriculture (USDA) Forest Service in support of their 40,000 end users throughout the country meeting management’s goal of reducing the enterprise’s Lightweight Directory Access Protocol (LDAP) directories.
- Authored 56,000 of lines of production code for automation, and deployment of Oracle products, written in Linux Bourne Again SHELL (BASH).
- Help maintain a 120-page operation manual/documentation specific to customer environment, for Oracle and Linux coordination with stakeholders
- Developed and demonstrated the solution to avoid our data center shutdown that was threatened without a two-factor authentication. My solution has been used in production for 4 years running.
- Integrated Oracle Engineer for Splunk Forwarder with Oracle database. Identified resources and tuned solution. Written in Linux Bourne Again SHEll. Resolve security violations.
Education
Bachelor's degree, Of Science - Electrical and Computer Engineering
Brigham Young University
Provo, UTSkills
- Oracle 21
- PostgreSQL
- Oracle WebLogic
- Oracle Architecture
- Oracle Internet Directory
- Oracle Backup
- Oracle Enterprise Users
- Oracle Tuning
- Linux Administration
- Server sizing, capacity planning
- Network troubleshooting
- Postgres integration
- Interpersonal skills
- Postgres Replication
- Oracle to EDB Postgres migration
- Product evaluation
- Service Now problem reports tracking
- Microsoft Active Directory
- Systems integration
- Postgres Backup and Restore
- Occasional Travel
- IT Security STIG
- Oracle Data Guard
- Postgres Security
Certification
- Oracle administration
- Oracle security
- Puppet Professional certification
- Oracle Recovery Manager certification
- Linux/AIX/Solaris administration
- Project Management Skill via IBM
- Oracle Identity Management (OIM)
- Postgres administration
Timeline
Senior Engineer, Oracle/Postgres DBA
USDA Forest Service
01.2023 - 01.2025
Senior Engineer, Oracle DBA
TechTrend
01.2020 - 01.2023
Senior Engineer, Oracle Database Administrator (DBA)
Bristol Bay Native American Corporation, and subsidiaries
01.2012 - 01.2020
Bachelor's degree, Of Science - Electrical and Computer Engineering
Brigham Young University
ENGINEERED SOLUTIONS AT THE USDA FOREST SERVICE
- Oracle Database Real Application Clusters (RAC) installation and non-RAC installation
- Oracle Database RAC backup and restore design, implementation and ultimate support
- Oracle Application Server backup design, implementation and support
- Database storage tuning
- Git distributed version control, Docker containerization
- Oracle Enterprise and Proxy Users design, implementation and support
- Oracle/Postgres Auditing integration with Splunk, implementation and support
Significant US Forest Service Oracle Accomplishments
- Architected, designed, and developed Oracle backups for 40,000 user enterprise
- Architected, designed and developed Kerberos, Enterprise Users, and Proxy Users
- Architected, designed and developed Oracle auditing solution
Other
Active Teir 4 security clearance