James S Bennett

**** *** ****** ******

Roseville, CA 95747

ad1pkq@r.postjobfree.com

Phone: 916-***-****

Oracle DB Architect

OBJECTIVE To be employed in a challenging and rewarding position as Oracle DB Architect so that I may utilize my education, job experience, and overall IT knowledge to make a direct and profound contribution to the company.

Work Experience

05/2021 – Present Gainwell Technologies LLC Remote

Sr. Oracle Database Administrator

Helped in supporting some 100+ Oracle Databases running on Linux, HP-UX and Windows. From version’s 11g up to 19c. From single instance to 2-node Rac up to 3-node Rac. Evaluated Oracle Database Vault product on my own built Oracle VirtualBox Server/Database guest appliances. Security hardened the environment’s OEM12 and 13c Cloud Control repositories. Built a Database Schema Security framework for all Stateside DBA’s and Offshore DBA’s and rolled out to all deemed highly sensitive Databases. Helped build a HUB designed unidirectional Golden Gate framework for 18 County Databases. Helped in upgrading Open Text Data Protector MML software from version 9.0 to 11.0. Helped build a net-new OEM 13.5.0.16 Cloud Control Console and upgraded all OMA agents to same 13.5.0.16 version. Participated in on-call rotation.

06/2020 – 10/2020 Employment Development Department – State of California Sacramento, CA

Access and Identity Management Engineer

Helped support the on-premises Identity Management Framework Architecture (OAM) that currently handles close to 15 million Claimants. Control, monitor and manage access to our critical applications such as Unemployment Insurance Online, Disability Insurance, Paid Family Leave and Benefit Overpayment Information. Participated with the project’s setup/testing/go-live deployment of the ID.me Identity Proofing layer in attempts to help reduce unemployment fraud the EDD has been encountering since March 2020.

07/2018 – 01/2020 Centene Corporation Rancho Cordova, CA

Project Lead Oracle Database Administrator

Helped in supporting close to 500 Oracle Databases ranging from version 11g up to version 18c running on the Exadata X-6 Database machine architecture. Participate in an on call rotation and shift duty to provide for 24/7 database support. Moved over to vetting all Oracle production and non-production CHG Control tickets created for our team within our Service Now application. This vetting process consisted of reviewing, approving, scheduling and often processing myself of these created changes. The process, on average, handled around 50 CHG’s per week. Created a process artifact and socialized to bring in a common structure/standardization for the process.

03/2009 – 07/2018 HealthNet, Inc./Centene Corporation Rancho Cordova, CA

CTO Oracle Database Architect

Responsible for ensuring that all database best practices, industry standards and company adopted standards are followed by our outsourced vendors IBM and Cognizant. Research and provide a database technology roadmap for Oracle classic, Oracle MySql and Oracle Rdb Database Management Systems. Work as technical CTO SME with designing new database technologies/strategies on all database projects that utilized an Oracle RDBMS. Research, plan, build and implement a great deal of new version technology ideas (ISP/ASP/Matriculation/Projects) in efforts to provide overall system and database stability at the enterprise level. Work in a Shepherd’s role as an Infrastructure Architect working on many Service Designs (8) for the INF10 project. Work in lead role capacity within the INF26 (TIP) project for all Oracle RDBMS’. Participate in Project SWAT troubleshooting initiatives within the INF10 (Boulder Dash) project when needed.

11/1999 – 03/2009 HealthNet, Inc. Rancho Cordova, CA

Sr. Production Oracle Database Administrator

Support 5 Oracle Production databases (versions 9.2.0.5.0 to 10.1.0.3.0) on HP Open VMS (version 7.3-2) ranging from 5.5 Terabytes (with 500+ tablespaces) to 4 Gig (with 12+ tablespaces). Support over 50+ Oracle Production databases (versions 8.1.7.4.0 up to 10.2.0.4.0) on UNIX and AIX platforms. Support the DEV, TST, STG, UAT versions of those production databases working with Applications Developers to ensure complete database change migration cycle. Installed and created an OLAP Oracle 10.1.0.3.0 Siebel database on HP Open VMS 7.3-2. Then I ported that OLAP database to Sun Solaris due to incompatibility issues found during testing. Perform yearly DITSCAP/DIACAP/SRR security scans and remediation with certifications enforced by the government on 9 highly visible government facing databases to maintain our State contract for those databases. Also apply the quarterly Oracle CPU’s against those government databases as well. Built and also upgraded several Oracle databases up to version 10.2.0.3.0. Built, with the direction of Applications development, and maintained the table partitioning strategy within our 5 terabyte data warehouse database – over 70+ table partitions. Developed Row Level Security (VPD) and showed proof of concept to the Applications Developers onto our Data warehouse DEV database. Have 9i/10g RAC experience with several HP Open VMS and UNIX housed databases. Exposure in the supporting of Oracle streams replication. Strong knowledge with UNIX Shell programming, VMS command procedures, and with SQLPLUS and PL*SQL. Maintain the lead role in all database storage needs as acting database storage rep for all VMS, UNIX and AIX housed databases on all environments. Helped deploy the intelligent agent onto all server VIPS so that each one could fail over successfully using its VIP upon error thus providing continuous heartbeat from the database to agent then to the OEM grid control. Proficient in Rman cloning/duplication to same server and to a remote server of databases. Proficient in database Restore and PITR, and partial recovery due to the size of the 4 terabyte data warehouse database. Created my own 9i desktop OEM Management Server, set up periodic collections using Expert and generated workload recommendations for tuning. Proficient using OEM SQL Analyzer by taking any long running, high cost, queries and running them through the Analyzer to get new index recommendations. Also use Quest SQL Analyzer to get several query re-write recommendations when analyzing any long running queries. Use of 10gR2 OEM grid control in the analysis and tuning of databases and queries against all 10gR2 databases. Proficient in using Statspack with Statspack Analyzer web site in assisting in tuning databases/queries. Ensure that all Rman backup/restore strategies remain within 100% compliance of our SLA created between our customers and the DBA team. Converted all “Cold” database backups to Oracle standard “Rman Hot” backups ensuring 24/7 uptime and availability for those databases. Attend Oracle World SF conference, for the past 6 years, in keeping up with the industry technologies and innovations. Participate in an on call rotation and shift duty to provide for 24/7 database support.

11/1999 – 03/2009 HealthNet, Inc. Rancho Cordova, CA

Sr. Production Oracle Rdb Database Administrator

Currently support on 25+ Production Oracle Rdb databases ranging from 800 Gig – with 550 Tables to 300 MB – with 30 tables. Also support 120+ UAT and Development Oracle Rdb databases. These databases run on a several multi-node Clusters of HP Alpha machines running Oracle Rdb V7.1-511 in the production, DSS, UAT and DEV environments. I also supported 10+ additional Oracle Rdb databases on a multi-node/multi-environment Cluster of HP Dec Vax machines that ran Oracle Rdb V6.02 which were decommissioned a few years back. Currently perform database analysis and tuning by using RMU/ANALYZE and RMU/SHOW STATISTICS commands. Have successfully performed collections with Oracle Rdb Trace and used those collections in Oracle Expert Rdb to create tuning recommendations. Performed several Rdb and SQL*SERVICE version upgrades across DEV, UAT, DSS and Production environments. Make database structural changes through Remedy Change Control procedures. Fine-tuned all RMU backups and RMU restores to tape using media management application Storage Library System. Participate in our annual Disaster Recovery exercise conducted offsite in New York. Have written several database procedures, operdocs, Visio diagrams and binders for the department. Currently participate in an on call rotation to provide 24/7 database support. Created several database monitoring command procedures. Maintain the lead role in all database storage needs as the database storage rep for all databases on all clusters.

10/1997 - 11/1999 Foundation Health Systems/HealthNet, Inc. Rancho Cordova, CA

Senior Production Control Analyst

Streamlined a PC based application called Procomm Plus 2. Wrote all procedures and created a “procedure binder” for the department. Posted all of the procedures up into a Lotus Notes database. Set up a Microsoft Visual Basic 4.0 program to remind the department of when a Procomm procedure was to be executed. Created a Microsoft ACCESS 97 database for the FHS print room to track all items ordered and purchased. Assisted in the hardware migration of a Dec-Vax 6000 and Alpha 2100 to Foundation Health Systems (FNSRV Dec-Vax cluster). Created a Dec-Vax training presentation in Microsoft Windows PowerPoint 97. Conducted 2-three hour training sessions using the PowerPoint 97 presentation to all associates of the Production Control and Operations departments. Trained all off shift Production Control personal the production running of the newly acquired Dec-Vax FNSRV cluster. Migrated all PC based (resident on their C: drives) software running on two older 486 computers to a newer Pentium II 233 PC for our Production Control department. Currently troubleshoot and repair all Dec-Vax DCL/IBM JCL program abends. Assist in submitting all IBM user requested jobs through OPC scheduler or through JES. Assist in submitting all Dec-Vax user requested jobs/requests through either batch or through a scheduling application called Polycenter scheduler. Attended AS-400, VMS, OS-390, Lotus notes 4.6 training, Xerox, and Elixir training. Moved to a weekend dayshift position in April of 1998 to run four Dec - Vax clusters that were moved from the Health Net data center in Woodland Hills, CA to our Rancho Cordova, CA site. Created a production control shift responsibility/activity binder for the Dec-Vax PRD cluster. Ran dayshift/partial swing shift weekend Capitation processing on the PRD (Production) and DSS (Kbase) Dec-Vax clusters. Ran dayshift/partial swing shift weekend Month end processing on PRD (Production) and DSS (Kbase) Dec-Vax clusters. Implemented DCL program moves and IBM migrations once approved by the change management process. Participated in a weekly on-call rotation for the production control department covering both IBM and DCL applications.

4/1996 - 10/1997 Gtech Corporation Sacramento, CA

Lead Computer Operator III/Comm Tech

Worked the majority of the time in a lead operator position handling swing, night and day shift responsibilities for approximately one year. Such responsibilities included: Conducted and supervised nightly lottery draws in the background presence of a California State lottery official. Ensured that proper all procedures were followed in protecting the sensitive lottery data. Participated in Disaster Recovery at our secondary site ensuring proper failover in case of a actual disaster. Ensured that sensitive data on reports and tapes were created and delivered to the State on time without penalty. Supervised anywhere from 4 to 6 personnel during a shift. Assisted in the troubleshooting of our LAN/WAN with TELCOM vendors ensuring 99% availability to all lottery terminals. Created three ACCESS databases; one for Dec-Vax 6600 disk pack description, one for control room/communications hardware, and the last one for keno play slot. Created a Dec-Vax command procedure for the swing shift called pack maintenance. Trained several new associates the swing and production running of the Dec-Vax systems, Primary, Secondary, and Spare as well as the UNIX based GLITS system. Worked closely with our customer service representatives and numerous telco companies’ troubleshooting any line problems.

7/1994 - 3/1996 Gtech Corporation Austin, TX

Computer Operator II/QA Software Analyst

Played a major role in assisting with numerous software releases. Wrote test plans, test scripts, test logs, test incident reports and such in accordance with IEEE format. Worked closely with a State official in testing the new software release. Prepared both the Dec-Vax and Stratus environments for testing, this included preparing the disk packs with the correct data and correct version of software. Loaded new instant lottery games on the Stratus. Assisted in the migration of new software releases and monitored activity of CAT and GVT terminals. Ran all three Dec-Vax consoles on production shift (Primary, Secondary, and Spare systems). This mainframe handled all on line games. Monitored and processed the proprietary created GLITS system on the Sun Sparc station (UNIX based system). Monitored and ran the nightly processing on the instant ticket Stratus midrange system. Created many off site tapes and reports then delivered to the State lottery of Texas. Handled all responsibilities and duties of day shift operations. Conducted nightly lottery draws in the presence of a Texas State lottery official. Conducted numerous research projects for the State lottery to maintain the integrity of their department.

3/1992 - 10/1993 State Farm Mutual Automobile Insurance Company Austin, TX

Data Processing Assistant II

Ran printer peripheral devices in the print area, i.e.…Storage Tech 5000 impact printer, Xerox 4090 laser printer, and a Siemens 2140 led printer. Ran peripheral devices in the burst/decollate area, i.e.…two Standard register 2500 bursters, one Moore 3500 burster, and one Swingline 6300 decollator. Maintained tape library by handling all tape mount requests, pulling scratch tapes as needed, filing tapes “written to” into library. Created nightly microfiche using the Anacomp system/XL Datamaster II peripheral device. Assisted in the Master console room with job setup and running of jobs.

3/1990 - 7/1991 Anchor Swan Incorporated Worthington, Ohio

Computer Operator I

Ran swing shift production job schedule on an IBM 4381 and System 38. Trained other associates to run the production shift. Printed numerous reports and delivered to in house associates. When needed, ran the night shift production schedule. Moved to day shift to handle all help desk activities and computer operations day shift responsibilities.

Education 1986-1987 The Computer Learning Center of Houston

11200 Westheimer Road Houston, Texas 77042

Diploma in Mainframe Computer Operations – Honors

Computer Skills RDBMS

•Oracle Classic Databases (7, 8i, 9i, 10g, 11g, 12c and 18c) on LINUX/UNIX/OpenVMS

•Oracle Rdb/OpenVMS (6, 7)

•Oracle MySQL (5.x)

Operating Systems

•Unix(Solaris/Linux/AIX)

•OpenVMS

•MS Windows

Software Utilities

SQLPLUS, PL/SQL, Sqlloader, Exp/Imp, ExpDP/ImpDP, Rman, OEM Grid Control/Cloud Control, TDPOSYNC, SQL/Rdb, RMU, Rdb/VMS, PLSQLDeveloper, SQLDeveloper, SQL- Services, ACMS

Training

•Oracle 9i SQL Tuning

•Oracle 9i Database Administration Fundamentals I

•Oracle 9i Database Administration Fundamentals II

•Oracle 9i Database Performance Tuning

•Oracle 10g Real Application Cluster

•Oracle Database 11g: New features for Administrators

•Using Oracle Enterprise Manager Cloud Control 12c/13c

•Exadata X3-2/X3-8 Database Machine Administration Workshop Ed3

•Oracle MySQL Performance Tuning

•Oracle MySQL for DBA

•Designing and Implementing a SQL Server 2008 R2 Database

•Understanding the Microsoft SQL Server – In-house training

•Oracle Golden Gate Architecture

Accreditations

•NACLC (National Agency Check with Law Enforcement and Credit)

Contact this candidate