We provide IT Staff Augmentation Services!

Database Architect & Database Coding Resume

4.00/5 (Submit Your Rating)

Santa Clara, CA

Hire Now

SUMMARY:

An innovative, resourceful, and ambitious Database Design and Programming Professional with over 15 years of experience in system design and database application transformation solutions. Offering extensive and broad based expertise in new technology, architectural layout, programming, and test management while demonstrating excellent problem solving and analytical skills.

TECHNICAL EXPERTISE:

Oracle RDBMS, PL/SQL, SQL, Oracle Label Security (OLS), Real Application Clusters (RAC), and Advanced Security (AS) Options, Oracle Data Modeler, Oracle Database Designer, EclipseLink Java Persistence API (JPA), Microsoft SQL Server, T - SQL, PostgreSQL, MySQL, Java, C, C++, Linux, Unix, Shell Scripting, Big Data Solutions

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Database Architect & Database Coding

Responsibilities:

  • Engineered, monitor, and manage the architectural layout and programming of a sizable web-based system for a governmental agency with a many year development duration.
  • Created and maintain a 20TB-100TB database utilizing the Oracle Data Modeler Entity Relationship Design (ERD) tool, and perform all internal functional programming.
  • Established a code database along with a Database Design Document (DBDD), packaging both software and documentation for client through functional releases.
  • Maintain Oracle BI reports and their SQL-based data sets, with a focus on improving report generation performance by adjusting and tuning the SQL sets.
  • Currently performing case study of Big Data solutions to offload largest data sets from Oracle.
  • Implemented conversion and tuning solutions for applications using SQL Server for their data storage requirements.
  • Created new conversion procedures utilizing SQL Server's transact-SQL language to relocate the COTS product’s Excel based data and mapped those cells into the new relational structure.
  • Tuned SQL Server database code and structures on a web-based project for a foreign client.

System Design & Proposal Development

Confidential

Responsibilities:

  • Collaborated with a small team tasked with choosing the correct hardware and software systems to implement a large customer project.
  • Determined and recorded various interfaces provided by the system.
  • Designed the new system to meet client requirements, providing a detailed use case analysis for each software component.
  • Developed a proposal on findings and recommendations and received a Confidential award.

Confidential

Senior Database Application Developer

Responsibilities:

  • Maintained a government system using an Oracle OLS database running on the Trusted Solaris operating system.
  • Implemented numerous Multi-Level Security based tools to function with the database.
  • Programmed in SQL, PL/SQL, C, and C++.
  • Performed a case study of PostgresSQL, and MySQL to determine if a label-based row level security option was feasible for either database.

Confidential, Redwood Shores, CA

Principal Lead Developer

Responsibilities:

  • Directed and collaborated with a team of six to eight developers that coded the OLS option to the Oracle RDBMS, including writing C and PL/SQL program extensions to various internal and external Oracle triggers, enforcing the logic required completing the new MLS features.
  • Cooperated with technical writers to document the new features established by OLS.
  • Ported Oracle to Unisys 5000 and Confidential 3B2 Unix computers, provided porting support to OEMs, and provided Oracle product support to customers.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship