We provide IT Staff Augmentation Services!

Senior Data Architect Resume

3.00/5 (Submit Your Rating)

Washington, DC

SUMMARY

  • Over 30 years’ experience with relational/dimensional database technologies using Oracle, Netezza, SQL Server, an senior Oracle Database Administrator/data architect and an Oracle Certified DBA (Oracle v7x - 12c).
  • Thorough understanding of the Oracle RDBMS engine and utilities, Oracle Business Intelligence architecture/solutions, ETL, and Oracle Security. Understanding of analysis and database design, normalization, data modeling, and capacity planning in N-tier, cloud, and virtual environments.
  • Extensive experience implementing Oracle/Netezza solutions. Project manager implementing Agile development environments including Scrum/Kanban Methodologies. Solid understanding of networks, GUI design and implementation, excellent written, communication and interpersonal skills.

TECHNICAL SKILLS

ETL tools: Oracle Data Integrator (ODI), IBM InfoSphere DataStage, Informatica installation/configuration of the Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor

Other: Oracle Data Visualizer, Oracle Data Discovery, Oracle Data Mining, Oracle APEX (installation, upgrade, in-house training, application creation), PL/SQL, Talend Open Studio for Data Quality/Data Profiling

PROFESSIONAL EXPERIENCE

Confidential, DC

Senior Data Architect, Data Warehouse Architect, Project Manager, Senior Oracle DBA

Responsibilities:

  • Senior systems architect, senior database administrator (DBA), business intelligence architect, Oracle GoldenGate developer (Sybase-Oracle), applications/data SME, and OID/IDM Administrator
  • Worked on the eFAP Case Management System developed using Oracle Fusion Middleware that provides features, functions, and capabilities through a flexible SOA technology layer, web application user interfaces, business process workflows, case configurations, security, and content management with supporting analytics and auditing capabilities hosted on a modern, flexible, and scalable technology platform.
  • Developed/supported custom-built application using Oracle Real Application Clusters (RAC), Oracle WebCenter Portal, Oracle WebCenter Content, Oracle BPM for case management workflow, and Oracle Identity and Access Management for Single sign-on (SSO) and password management.

Confidential, Washington, DC

Senior Oracle DBA

Responsibilities:

  • Project Manager (PMP), Senior Data Architect, Senior DBA, data warehouse architect, business intelligence developer, OBIEE developer, applications/data SME, Discoverer administrator and developer, BPA/BPA Administrator, OID/IDM Administrator, UPK Administrator, Serena Dimensions Administrator, HP Quality Center Administrator, ER/Studio Administrator, Pega Architect, Linux Administrator
  • Data architect for project to migrate all on-premise Oracle custom-built applications to MS SQL Server on AWS
  • DBA for all Oracle and Netezza development and test databases in End-to-End Test environment (ETET). Installed and configured Oracle 12c, 11g, 10g, 9i, 8i on Windows NT and Sun Solaris for the Sun 6800s implementing EMC storage technologies.
  • Implementation experience in Master Data management (MDM), Data Governance (DMBoK-DAMA), business glossary/dictionary, source to target mapping (STTM) and Business Intelligence (BI) systems.
  • Configured, developed, and administered the Netezza appliance working with OBIEE and Business Objects. Patched/upgraded Netezza and stress-tested the appliance to determine break points and limits.
  • Upgraded Oracle databases starting with 8i, recently upgraded 11.2.0.4 to 12.1x, and patched databases
  • Pega architect ensuring the new case management application using Amazon Web Services (AWS) interfaces with legacy systems
  • Sole Netezza DBA at ATF responsible for security design/implementation, configuration management, administration, and performance troubleshooting for BI applications.
  • Converted OLTP relational models to dimensional models on data warehouse platform Netezza-Linux and Oracle using IBM ETL tools DataStage (DS), QualityStage (QS), Change Data Capture (CDC), Information Analyzer (IA) including data cleansing/profiling, Oracle Data Integrator (ODI) and Oracle GoldenGate.
  • Member of Agile Scrum/Kanban development teams, experience in the use of Agile approaches including extreme programming, test-driven development and Scrum.
  • Installed, configured, and developed in Oracle Business Intelligence EE (OBIEE) v10g/11g/12c on UNIX and Windows platforms. Architected complete Business Intelligence solutions with OBIEE, BI Publisher, Business Objects, IBM Cognos, and Oracle Discoverer. Converted Oracle Discoverer business areas and reports to OBIEE.
  • Serena Dimensions administrator supporting the Project Management Office (PMO) as configuration management (CM)/Quality Assurance (QA) lead to review key project deliverables and ensured all projects are compliant with the SDLC artifacts, processes and procedures. Worked with team to migrate artifacts from Dimensions to GitHub/GitLab.
  • Team lead for Independent Verification and Validation (IV&V) and performance test engineers to create test plans, test cases in HP Quality Center, HP Quick Test Professional (QTP), HP LoadRunner scripts, and AccVerify for 508 compliance testing.
  • Developed applications using Oracle Application Express (APEX) using virtualization and cloud technologies.
  • Installed and configured Oracle Business Process Architect (BPA) and Oracle Business Process Publisher (BPP).
  • Worked with ERwin, ER Studio, Oracle SQL Developer Data Modeler, Toad Data Modeler, DBArtisan and Oracle Designer in several projects in Data Warehouse/Data Mart, OLTP and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
  • Installed, configured, and documented detailed steps to implement Oracle Recovery Manager (RMAN) and Oracle Data Guard - Physical standby (Redo Apply), Logical standby (SQL Apply), Active Data Guard
  • Integrated several Oracle11g Fusion Middleware products into the infrastructure including OBIEE11g, Identity Management, Oracle Virtualization, Oracle Data Integrator (ODI), Essbase, Fusion Middleware-ADF, Database Audit, Database Vault, Exadata/RAC, Data Masking, WebCenter Suite, SOA Suite, WebLogic, data cleansing/profiling, and Oracle Universal Content Management (UCM).
  • Installed and configured Oracle 10g Grid Control and agents for all servers/databases, implemented 11g new features, identity management, single-sign on.
  • Installed/configured Oracle databases in several cities throughout the US for the Access2000 project
  • DBA for Explosive Catalogue System (ECS), an Oracle Financials/E-Business v11.5.10.2 application (test, development).
  • Installed and configured several Oracle WebLogic-Application Servers (OAS) for Sun Solaris for the Sun 280Rs, Windows NT, and Windows/2000.
  • Configured security on Oracle 9iAS according to ATF security regulations, provided development standards to the various ATF contractors regarding configuration management issues on the web servers, provided a J2EE development environment for ATF developers.
  • Provided design and source code reviews for developers on most ATF custom built applications to ensure ATF standards are maintained.
  • Provided leadership and technical direction to several junior database administrators, Oracle Discoverer Administrators and Oracle 9iAS support personnel. Lead DBA and Discoverer Administrator for the Firearms Crime Gun project which involved installing Oracle, configuring database replication to various US cities.
  • Designed Oracle database backup and recovery procedures.
  • Lead designer for the Firearms data scrubbing project and its integration with the ArcView GIS Geocoder and John Henry Geocoder tools.
  • Installed and configured Oracle Enterprise Manager with Change Management, Diagnostics and Performance packs and worked with Enterprise Manager 12c.

Confidential, Oakton, VA

Project Manager

Responsibilities:

  • Designed and installed Oracle v7x, v8.15 for Windows NT, created several Oracle databases, created and documented the backup and recovery procedures, configured end user workstations.
  • Reverse engineered several applications using ERwin, developed the associated data models for the development team, and then forward engineered the model to the RDBMS for the developers.
  • Installed and configured Oracle Enterprise Manager (OEM), Performance Pack, Diagnostic Pack and Tuning Pack to monitor database activity and schedule routine jobs, and increase database performance.
  • Created the backend database structure to implement two Cold Fusion web applications, tuned and monitored the Oracle database to ensure peak performance, assisted in creating and designing the three-tier architecture for implementing the web application.
  • Developed Oracle packages, procedures, functions and SQL scripts to assist the development team related to the web application and client server applications using PowerBuilder.

Confidential, Alexandria, VA

Project Manager

Responsibilities:

  • Installed and configured Oracle7 on a DEC Alpha, performed several upgrades to the RDBMS, created several databases, configured end user workstations.
  • Database administrator for the TIMSS system which involved application tuning, preparing testing environment, migrating data to production, and general application trouble shooting issues.
  • Migrated data from legacy mainframe system into Oracle, migrated several Access applications/tables into Oracle, created several Excel spreadsheets as Oracle tables for the analysts.
  • Installed, upgraded and tuned Lawson’s Accounting software using the Oracle database in UNIX, fixed many performance issues related to report generation and end user interaction with the application.
  • UNIX system administrator, created all UNIX and Oracle backup and recovery procedures.

Confidential, Herndon, VA

Senior Oracle DBA

Responsibilities:

  • Installed and configured Oracle v7x, v8.15 on several NT3.51 and NT4.0 servers in the US, Europe, South America and Asia, migrated several databases from v7x to v8x.
  • Development Oracle DBA on the LOIS asset tracking project which used Oracle Designer/2000, Developer/2000, Discoverer/2000 and Oracle Power Objects as the development tools in client server and Citrix three-tier architectures.
  • Production DBA for LOIS application in several countries worldwide.
  • Installed, configured and administered Windows NT3.51 and NT4.0 servers, addressed tuning issues related to database performance in conjunction with NT operating system performance.
  • Installed/configured Oracle Enterprise Manager including v2.04, monitored and addressed performance issues for all databases, installed and configured Oracle Application Server 4.0 and WebDB.
  • Installed and configured Designer/2000, ERwin 3.5, Visio Pro, developed logical and physical data models and entity relationship diagrams for the application, reverse and forward engineered application schemas.
  • Developed application using PowerBuilder v6, v5 to help maintain statistics of all databases worldwide, developed reports in InfoMaker for the members of the analysis team.
  • Designed the backend for the web based application, Access Management Circuits System (ACMS), performed all Oracle DBA tasks, developed backend procedures, triggers, referential integrity constraints, configured IIS for this application which implemented MS InterDev, Active server pages, and Visual Basic.
  • Developed all primary and foreign key constraints, worked with replication between the various countries which involved updateable snapshots, and synchronous and asynchronous replication.

Confidential, Crystal City, VA

Project Manager

Responsibilities:

  • Installed and configured Oracle7 Parallel Server on 3 HP9000s, created several Oracle databases in exclusive and shared mode using Oracle Multi-threaded Server (MTS), and performed upgrades to the database.
  • Performed advanced database and application tuning using SQL*Trace/TKPROF, Explain Plan, UTLBstat/UTLEstat, database triggers, and database auditing.
  • Installed Oracle and configured Oracle WebServer 2.1 on Windows NT.
  • Modeled systems using ERwin; forward and reverse engineered DDL to and from the Oracle database.
  • Worked with Oracle Enterprise Manager, Performance Pack and Enterprise Backup Utility.
  • Configured the Oracle database to interact with several Genesys applications, the Scopus development environment, and the Rockwell IGS Oracle database and associated switch in support of the Computer Telephone Integration (CTI) group.
  • Performed UNIX system administration on several HP9000s running HP/UX v10.20 including adding users, backing up and restoring the file system, and performing minor troubleshooting tasks.
  • Installed and configured Windows NT, installed and configured several versions of MS SQL Server, assisted in backend development tasks implementing Sybase System 11.

Confidential, Rockville, MD

Administrator/Task Leader

Responsibilities:

  • Established requirements for the installation and implementation of a LAN with 225 users implementing 10BASE-T and FDDI technology on an intra network, installed and upgraded NetWare 2.15, and 3.11 on several file servers, configured remote print servers and a NetWare Asynchronous Communication Service (NACS), conducted several training workshops for the LAN and cc:Mail, completed all CNE courses.
  • Task Leader of a nine member team consisting of senior systems analysts, programmers, LAN specialists, and ad hoc support personnel supporting 350 users at the Dept. of Energy (DOE).
  • Liaison between CDSI management, the DOE Project Management Officer, the user community, and the CDSI team to provide task and deliverable activity coordination.
  • Developed monthly Technical Status Reports on the technical status of project activities to DOE and CDSI management, conducted employee performance reviews and participated in the interviewing and hiring of new personnel, participated in developing management plans and resource requirements for the client and prepared contract documentation to client for deliverables.
  • Developed and maintained applications on the IBM 4381, Amdhal 470/V7A, Pro*Cobol, PowerBuilder v2, dBase III Plus, dBase IV, Paradox, FoxPro, and Clipper, provided support as the Professional Office System (PROFS)/Office Vision technical administrator on an IBM mainframe with 250 users, installed and maintained several bulletin board systems.

We'd love your feedback!