Database Architect Resume

SUMMARY:

33 years of database design and development
28 years of Oracle development and DBA
25 years of PL/SQL and Ada programming
24 years of Unix and Linux
24 years of system design and architecture
20 years of custom ETL development
16 years of management and team leadership
15 years of data modeling and process modeling
14 years of scripting languages
14 years of OLTP systems development
14 years of BI, OLAP, and Data Warehousing
8 years of CASE, including DB/Artisan and Erwin
8 years of C programming
8 years of Scrum and other Agile
6 years of Agile tools such as JIRA
5 years of Object - oriented design and programming
4 years of management consulting

TECHNICAL SKILLS:

Keywords: Oracle, Performance Tuning, PL/SQL, Data Mart, Corporate Information Factory, Enterprise Data Model, Operational Data Store, ODS, Data Warehouse. Dimensions, Fact Table, OLAP, Cube, Database Administration. Code Generation, Rules Engine, Metadata, CASE, OLTP, Scrum Agile, Theory of Constraints, Agile, Extreme Programming, Advanced Queuing, Startup, Entrepreneur, ERP, Migration, ETL, Team Leader, Unix, Linux, C, OCI, Pro*C, Python, Ada.

EXPERIENCE:

Confidential

Database Architect

Responsibilities:

Built an Oracle real - time scheduling system supporting ETL and messaging traffic.
Designed a data warehouse and operational data store (ODS) capable of implementation in either Oracle or PostgreSQL.
Performed as DevOps engineer for Oracle, Unix, and Linux systems.
Built a data mart for political data synthesizing multiple data sources using Oracle 12.2, RHEL 7.4, and the Mulesoft Anypoint platform.

Independent Consultant

Confidential

Responsibilities:

developed a data warehouse, star schema, and Analytics platform using Oracle, PL/SQL, and Unix. developed components of a network health and incident reporting system on an Oracle/Linux platform. designed and developed components of an Operational Data Store (ODS) on an Oracle/Linux platform. Managed a small team using Agile methods. solved performance problems of an Oracle/Linux reporting system. Reengineered the database and a dozen PL/SQL and Korn shell modules. solved performance problems in a VLDB data mart and billion row Cognos cubes. Created a data mart in Oracle 11g and developed an ETL subsystem using Oracle Data Pump and and flashback databases. developed a reporting subsystem using Oracle, Cognos Framework Manager and Cognos Report Studio. Developed a demo Business Intelligence application using Cognos Transformer and PowerCubes. Developed a data migration subsystem using Oracle 10g, and PL/SQL. developed a high volume DSS database using Oracle 10g and PL/SQL. Also managed a team, performed production support, and designed the data model using ERwin. Maintained applications written in Python. Designed a data mart using dimensions, fact tables, and cubes. investigated and fixed a crashed production system using Oracle 10g and PL/SQL. Developed database administration and programming tools, acted as DBA and developer. evaluated a data warehouse reporting on an Oracle Applications 11i implementation, produced reports recommending technical and organizational changes. Analyzed a data mart using dimensions, fact tables, and cubes.
Designed a reporting system using Hadoop and MapReduce. represented and developed a DSS system in Java, PL/SQL, Javascript, and Cold Fusion. rganized and led a team of developers in producing a budgeting system using Oracle 10g and the Oracle Developer Suite 9i. Produced development and configuration management documentation and procedures. Used Scrum as a project management method. tuned Oracle high - volume financial applications, resulting in orders of magnitude performance gains. Used integrated Oracle/Java testing environment, becoming proficient in UT/PLSQL, Junit and Cactus. Produced financial and demographic reports using PL/SQL and APEX. developed a data model and database using Postgresql, Hibernate, and Eclipse.

Database Architect

Confidential

Responsibilities:

Developed a batch external interface subsystem in 2 months without requirements, design, or ICDs.
Refactored and ported 70,000 lines of PL/SQL code to a new Oracle 9i application.
Produced an Oracle coding standards document. Produced system documentation using DB/Artisan and DBMS DDL.
Produced system performance studies demonstrating orders of magnitude of improvement.
Organized and managed a new team of production and development DBAs for a government agency.
Participated in the organization of the larger IT staff for the same agency.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship