Brian E. Starke

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

Albany, NY ****3

518-***-****

acxycs@r.postjobfree.com

CAREER SUMMARY: As a developer, system designer, database architect, database administrator, Oracle expert, and consultant, I have consistently provided excellent solutions to difficult computer system problems that require keeping the business and the details in mind. I am very good at understanding, using, and adapting software packages with regard to the current business needs.

EDUCATION: SUNY Polytechnic, Utica, NY BS Computer and Information Science 2015 EMPLOYMENT HISTORY:

Superior Group (at GlobalFoundries), Malta, NY 10/2014 – 12/2015 Contract Oracle Database Administrator

Performed all activities related to maintaining a successful Oracle database environment including design, implementation, security, and maintenance of the database and use of the database management system.

Designed and implemented a system for tracking employee skills and training.

Used Oracle RMAN to backup databases on a regular schedule and on an ad hoc basis with an appropriate mixture of full and incremental backups.

Monitored the Oracle environment to identify and eliminate factors that could result in operational failures.

Recovered databases from failure and user errors, including coordination with appropriate staff.

Effectively managed space, including allocation of database storage and advisement on future storage requirements.

Modified database structures as necessary, including adding and dropping indexes, adding tables and columns, and adding and removing partitions.

Responded to database-related questions and issues from operational staff. Assisted developers as necessary.

Created users and maintained database security with appropriate roles, profiles, and privileges.

Managed the database instances (implemented archive log mode, no archive log mode, restricted modes, non-automated start ups and shutdowns, etc.).

Configured and managed TNS, SQL Net and related services.

Created database links as needed.

Implemented utilities for continuous collection of database performance statistics. Reviewed the data and then optimized the databases based on these data.

Managed and utilized Oracle Enterprise Manager.

Identified, tested and applied critical patch updates to the Oracle environment.

Modified and wrote UNIX and Linux shell scripts to automate routine monitoring tasks and other repetitive work that can be prone to human errors, using ksh, bash, awk, sqlplus, and other appropriate scripting languages.

Copied databases, tablespaces, tables, and selected data using Oracle Datapump.

Installed the Oracle RDBMS software suite, including real Application Clusters (RAC), Automated Storage Management (ASM), and Oracle Enterprise Manager (OEM).

Performed Oracle database upgrades across major and minor releases.

Maintained Oracle Golden Gate database replication from Oracle, MS SQL Server, and DB2.

Migrated databases to new hardware, upgrading Oracle as appropriate during the migration.

Habitat ReStore, Albany, NY 6/2014 – 10/2014

(Volunteer) Assistant Donations Coordinator

Maintained web page

Customer Service

Researched software for scheduling trucks and for CRM.

Developed forms for data collection.

Created daily truck schedule for donations pick up. Schoharie Creek Technologies, Delanson, NY 7/2007 – 10/2014 Owner

Offered computer consulting services and computer maintenance.

Gave technical advice to Mindful Journeys Mentoring on video storage and distribution.

Bank of America, Portland, ME 6/2003 – 7/2005

Infrastructure Engineer III

Performed activities administering five Oracle database environments.

Migrated database and program changes through the five environments.

Maintained Shareplex database replication from the transactional database to the data warehouse.

Customized per client web pages.

Updated Apache Server forwarding and rewrite rules.

Used Oracle RMAN to backup and restore databases as needed.

Monitored the Oracle environment to assure all database administration jobs ran successfully and to prevent operational failures.

Used rsync to establish a pseudo-production environment with data obfuscation and password reset to allow development staff to investigate production programming issues.

Rewrote a data exchange process with the Federal Office of Financial Asset Control which was running three hours and then failing so that it ran in three minutes by using good PL/SQL programming techniques.

Assisted programming staff with difficult database queries and query performance issues.

Acxiom, Little Rock, AR 9/2000 – 7/2002

Senior Database Administrator

Created best practices standards.

Supported customer solicitation campaigns.

Automated backup procedures.

Implemented campaign management tools such as Epiphany and Unica.

Setup demonstration databases including creating “fake” household relationships for sales presentations both in house and at client sites.

Reduced a SQL update statement run time from 25 hours to 21 2 hours by rewriting the statement.

Installed and tested BMC Patrol for customer recommendation. Assisted BMC support with fixing a bug created by an Oracle version upgrade. Oracle Corporation, Rochester, NY 10/1997 – 9/2000 Senior Consultant

Installed and upgraded Oracle Applications.

Acted as a database administrator for multiple clients.

Acted as an Oracle Applications database administrator for several clients.

Upgraded Oracle RDBMS.

Performed best practices reviews.

Tuned databases.

Assisted in creating a “Golden CD” to allow cloning of the Oracle Applications standard database to implement Oracle’s “One Hour Install”. Decided on the tablespace layout and created the database.

Recovered a client's production medical manufacturing database on an emergency basis, preventing significant financial loss and allowing eye surgeries to continue across the nation.

Recognized as an Oracle Consultant of the Month.

Installed and customized Oracle Applications US Federal Financials for the US Coast Guard.

New York State Department of Social Services, Albany, NY 11/1979 – 10/1997 Manager of Data Processing Technical Services (Database)

Created a system for fraud detection and prevention on the part of Medicaid clients and Medicaid providers allowing auditors to change selection criteria “on the fly”, replacing a mostly paper based system that allowed changing selection criteria only once per month. This saved New York State money by utilizing auditors’ time more efficiently, reducing usage of expensive computer paper, catching more fraud and more quickly finding suspicious activity,

Designed and implemented hierarchical and relational databases on Unisys and Oracle database systems.

Implemented financial interfaces systems linking mainframes from different hardware vendors.

Built a transaction-based system for Medicaid services prior approval using TIP, DMS 2200, and Unisys COBOL.

Backed up and recovered hierarchical and relational databases, handling production media failure, user errors, and program logic errors.

Created and tested disaster recovery plans.

Implemented Oracle Procedural Gateways to query New York City and New York State agencies’ data to determine the assets and life data of Medicaid and financial assistance recipients utilizing existing transactional programs.

Designed a standard method for queuing and satisfying requests for mainframe data between New York State agencies such as the Department of Labor, the Department of Motor Vehicles, and the Department of Social Services.

Created Entity Relationship Diagrams for new database systems.

Designed and coded PL/SQL procedures, packages, and triggers.

Designed and coded an online Medicaid prior approval system to screen the use of certain easily abused Medicaid services.

Contact this candidate