We provide IT Staff Augmentation Services!

Database Architect Resume

4.00/5 (Submit Your Rating)

DC

SUMMARY:

Multiple years of experience in Software development and support. Specialist in the field of Database Distributed Systems development, and support. Extensive expertise in Identity Management. Oracle Expert. Comprehensive knowledge of Internet Systems Development and Architecture.

Programming Interface to RDBMS Basisplus, Information Dimensions Inc. Object Oriented Analysis and Design, Martin Marietta,nrogramming for PowerBuilder, Applied Technology Associates, Inc. Advanced Programming for PowerBuilder 5.0, Sybase/Powersoft; Oracle Database Administrator; Oracle Database Backup and Recovery; Tuning Oracle Applications; Oracle Server Tuning, Design Complex Database Objects,ORACLE Networking, Oracle Parallel Server Implementation, ORACLE 8I new features, Oracle Advanced Replication,  Fast Track to Java, Sybase.

TECHNICAL SKILLS:

LANGUAGES SPOKEN: English, Russian, Ukrainian.

KEY WORD LIST: IBM PC, INDIGO, SUN SPARC(10k,15k,..), RS6000, Alpha, IBM Mainframe; EMC SAN and NAS; Network Appliances NAS SOFTWARE MS - Windows NT 4.0, 2000,XP, NOVELL 4.0, UNIX(IRIX, OSF/1, Sun OS 8,9), PowerBuilder 4-6.5, JDeveloper 9.0.3, ASP, Cold Fusion 3.0-4.0, VisualBasic 4-6, Protogen, Q+E, Windows SDK, WEB-Logic, iPlanet Web Server, Oracle 9ias/Report/Forms/Discoverer 9.0.2.2, 10G Ias, Oracle InterMedia, Appache, Raisin LANGUAGES C++ (BORLAND 4.0, MVC++ 4.0), J2EE, VBScript, SQL, PL/SQL, Korn Shell, C++ASSEMBLER, Prolog, Cold Fusion, JavaScript, T-SQL, DTS DBMS ORACLE OPS 7.2-8, RAC 9.2.05,10G,SQL Server 7,8, DB2 7, Sybase 7, IMS VS, MySQL 4.0, Objectivity 1.0 CASE/CM TOOLS System Architect, ERWin, Oracle Designer (6i and 9i), QA-Center, CCC/Harvest, Clarify, Siebel, Clear Quest/Clear Case/Rational Suite; ORACLE BPEL 10.1.2.2, Oracle Application 11.5.9; Oracle Warehouse Builder 9i and 10.2.0.2; Web Center 10.1.3.2; Jdeveloper 10.1.3-11; Oracle Application Server 9.0.4 - 10.1.2.2 ; OID/SSO - 10.1.4; Oracle Portals 9i - 10.1.4.1; Oracle SOA suite 10.1.3.1; Oracle BAM; Oracle Data Integration Suite, Oracle Golden Gate, Oracle RAC, Exadata, Tomcat.

PROFESSIONAL EXPERIENCE:

Confidential, DC

Database Architect

Responsibilities:

  • Provided Data Science Big Data solutions for multiple proposals as a Data Architect.
  • Provided SME support to migrate Oracle Directory Server (ODSEE 11.1.17.2) to AWS for EDSC CMS clients.
  • Provided analysis and design HA platform for ODSEE, configuration and performance.
  • Leaded an effort (from CSC) to evaluate performance degradation on FDIC DW. Provided recommendations as a SME to re - architect the DW system. Worked closely with FDIC DW system owners, DBAs, ETL developers to develop remediation for the issues.
  • Leaded CSC FDIC contract transition of Middle tier team.
  • Leaded support of Oracle Database and Middle tier products for FDIC customer.
  • Provided day to day operation and engineering support for multiple Oracle products such as Weblogic Servers 10.3.6 and above, Grid Control 11.1.1, OID 11.1.7, Oracle Waveset 8.1.1, and the others.
  • Provides engineering and architecture solutions for multiple FDIC efforts. Developed architecture for Waveset gateways high availability architecture. Designed, developed High Availability solution utilizing Oracle Real application cluster (RAC). Installed and configured RAC 12.1.0.2 in multiple environment and developed Enterprise Deployment Guide cookbook. Developed and implemented HA solution using Veritas Cluster System. Configured and Set Up server chaining for OID and password authentication plug - in to support EUS. Configured EUS for 11g databases. Engineered and implemented security patching best practices for RAC, and VCS Database cluster environments FDIC wide.
  • Provided analysis and helped to troubleshot Centrify and CyberArk issues.
  • Provided database and middle tier support for IRS DITE, RRP, MEF and other projects. Support BIG DATA projects utilizing EMC Green Plum distributed RDBMS.
  • Architected and developed solution to support AQT testing for Big Data environment. Implemented the solution for Green Plum / Oracle environment. Designed and Developed ETL to process raw XML data from MEF into Green Plum RRP structures. Designed and developed application to process and load IRS RRP structured metadata into a large ontology database.
  • Designed, and developed processes to provide AQT for IRS DW more than 50,000 attributes, and more than 7,000 entities. Target Green Plum, and sources Oracle, FF, XML, and the others.
  • Developed architecture for PBGC 11G Infrastructure upgrade, and provided input to PBGC Infrastructure design and planning.
  • Developed Enterprise Deployment of 11G infrastructure implementation workflow, and Leaded implementation of 11g FMW installation and configuration on all PBGC environments for the new PBGC 11G infrastructure.
  • As a Technical lead and project manager developed project scope and planning for PBGC new Oracle IDM system for PBGC external users federation. Designed, Architected and leaded OID 11.1.1.5 cluster implementation in PBGC across all environments and SDLC.
  • The infrastructure consists of: Oracle Web Center 11.1.1.5, Weblogic 11.1.1.5, OCM 11.1.1.5. Apex 4.1, OID 11.1.1.5, Oracle EE 10.2.0.5, 11.2.0.3.
  • As a Technical Lead Provide analysis, and design to Infrastructure monitoring tools such as Oracle GRID Control to support PBGC Infrastructure Configuration Management efforts. Provided analysis to security standards to implement on PBGC Infrastructure; includes STIG and SCAP methods. Compiled proposed vulnerabilities list based on Oracle best practices. Support PBGC infrastructure components including SOA suite, SSO/OID and multiple J2EE applications within Oracle 10g Application Server.
  • Architected and configured WebLogic environment to migrate major Filenet application from JBoss.4.2.1.
  • Provided substantial contribution to improve JBoss migration performance process.
  • Developed and performed performance, functional and stress and load testing for various infrastructure components and Applications using LoadRunner and Test Director.
  • Provided Support to multiple instances of PBGC Oracle 11g and 10g Database servers.
Confidential, MD

Principal Consultant

Responsibilities:
  • Designed and Implement Security Tier Framework for ADF J2EE applications. Technical Architecture layers consist of Weblogic 10.3 server, OAM 11.1.1.3, Web Gates 11.1.1.3 and SOA suite 11.1.1.3 utilizing Oracle Database Server EE with Data Guard 11.2.0 for metadata repository.
  • Set up and configured Oracle IDM 11.1.1.3. The Identity Management Datastore configuration involves OID/OVD/OIF 11.1.1.3.
  • Participated in various proposals submissions.
  • Installed and configured OIM 11.1.1.5 and designed effective approach to recon/provision multi - valued attributes within OIM using AD and DB user management adaptors for NIST critical system

Confidential, MD

Sr. Identity Management Consultant/ Project Lead / Oracle DBA

Responsibilities:
  • As a member of a team work on ICAM/HSPD12 Agency Enterprise solution project.
  • Develop architecture and security Model for IPortal multiple Oracle Fusion Middleware 11G components: such as WEBCenter 11.1.2, UCM 11.1.2 and Oracel Identity Management Suite; Installed and configured Oracle Identity Management Suite Infrastructure including Oracle 11.0.7 Database for metadata and 11.1.3 Identity Management OID, OVD and OIF components.
  • Installed OAM 11.1.3 suite, and configured WebGates 11.1.3 for WebTier.
  • Developed API to access remote Directory using PL/SQL and set up OVD adapters. Set up OID 11.1.3 synchronization with AD and developed LDAP structures to accommodate multiple AD sources.
  • Provide DBA support for Datawarehouse environment. Supported Oracle SOA Suite 11g and WebCenter 11g and OBIEE 11G.
  • Upgraded SOA suite 11g and OID 11g to 11.1.1.4.
  • Designed and implemented integration of cold fusion application with OSSO WNA accessing Active Directory and Oracle OID 11.1.1.2.
Confidential, MD

Sr. Middle Tier Architect

Responsibilities:
  • Developed architecture, Installed, configured and troubleshot J2EE/Web Services Architecture various middle tier components including SOA suite and Oracle IDMS. Deployed and developed automated process to deploy J2EE/Web Services application into clustered SOA environment. Lead Application Identity Management component installation, configuration and support, including schema classes and organizational unit creation and support for multiple staging environments. Installed and configures XML publisher cluster on Linux 5.2 - 5.4.
  • Leaded, and managed project involving multiple Organizations and teams to Architect and Provision IDMS content from NOVEL IDMS to Oracle IDMS OID to support Security Tier for the Census major critical Application. Installed, configured and developed architecture of Oracle identity Management System multi - tier cluster for multiple environments.
  • Supported and configured Oracle RAC database for 8 nodes share three cluster architecture.
  • Provided Performance Tuning Recommendations for multiple tiers of J2EE/SOA Application and RAC based back-end for Production and BETA environments. Utilized multiple Oracle Fusion Middleware 10G components such as:
  • Oracle IDMS OID 10.1.4.3, SSO 10.1.2.2, SOA suite 10.1.3, Oracle BI XML Publisher, and Oracle RAC 10.2.0.4 and Load Balancer F5.
  • Provided analysis to Performance and Load/Stress testing results from LoadRunner and OPNet.
Confidential, VA

Sr. Database/SW Architect / Oracle DBA

Responsibilities:
  • Designed and developed Subject Data Model Diagrams for selected existing Harbour Management System (HMS) schemas.
  • Provided ongoing production and development DBA support for multiple installations of Oracle Application Servers and Oracle Database Instances.
  • Develop HMS product Architecture to incorporate Oracle Web Center 10.1.3.2 tier into the current Application infrastructure and support JSR 168 portals functionality; installed and configured all tiers(Oracle Portals 10.1.4, Oracle Infrastructure 10.1.2.0.2 and Web Center 10.13.2) for the development environment. Developed deployment process to portalize ADF/JSF AJAX web service within Oracle Portals 10.1.4.0 and Oracle Web Center 10.1.3.2 Web Center. Configured SSL for OIDDAS on production server. Participated in Architecture design for HMS product test lab. Participated in development and Architecture of HMS Portal security model utilizing Oracle Internet Directory.
  • Provided support for Oracle 10.2.0.3 RAC databases with two shares one and Data Guard architecture at DHS US Coast Guard Financial Center. Provided Analysis and Designed new SQL Server 2005 Architecture for American University Client Infrastructure, provided solutions for HA based MS clustering and data mirroring technologies.
  • Develop SOA architecture for ESS products using Oracle SOA Suite 10.1.3.1.0 and BAM 10.1.3.3 with Oracle Data Integration suite.
  • Installed and configured SOA suite components including Oracle BPEL, ESB, Oracle Rule Engine and Oracle Web Services manager and ODI suite. Architected and Developed ESB WEB Services workflow
  • Installed, configured and set up working environment for Oracle Service Bus former BEA Aqua Logic Service Bus 10.1.3.
Confidential, DC

Sr. Infrastructure Architect/Sr. DBA/Technical Lead

Responsibilities:
  • Designed Installed and Configured Data warehouse environment for the development environment; including Warehouse Builder server on LINUX and metadata repository on SUN Solaris 8. Set up architecture and configured OWB metadata for ETL and workflow processes development based on the PBGC requirements. Provided recommendations on the testing and production Oracle Warehouse Builder environment setup.
  • Participated in design of Identity Management (IM) Infrastructure cookbook.
  • Set up Identity Management Infrastructure; installing and configuring Oracle 10.1.2.0 SSO server cluster and 10.1.2.0 OID server; set up integration of the OID and multiple Active Directories(AD). Troubleshoot AD - LDAP and OID - LDAP synchronization. Troubleshot integration of OID and Oracle Application E-Business Suite 11i (CRM and CFS components); OID and J2EE applications.
  • Leaded Oracle Application Server components performance assessment effort; Developed Organization Oracle Identity Management System Load/Stress testing scenarios and evaluated performance monitoring tools. Utilized LoadRunner and Test Director.
  • Lead Grid Technology Implementation effort; Installation and Configuration of Oracle GRID 10.2 on Sun 5.8 and Linux RH4 servers, Set up and Monitoring for the Organization Infrastructure multiple Oracle Targets Types: Databases, Identity Management, Oracle Applications 11i, Oracle BPEL and SOA and J2EE WEB Applications. Develop cook book for PBGC Infrastructure monitoring implementation utilizing GRID technology. Currently the technology was successfully moved to production environment and cover entire PBGC UNIX/LINUX infrastructure.
  • Coordinated with QA and Designed Promotion Model for the IM project Configuration Management using PVCS.
Confidential, DC

Team Lead

Responsibilities:
  • Lead Development and Architected Data Warehouse for National Community Services Domain.
  • Supervised four persons: one Sr. ETL Developer, one Sr. Oracle Discoverer Report Developer, one Sr. Data Modeler/Architect and one Oracle Discoverer Report Developer.
  • Developed ETL procedures, utilizing Oracle Warehouse Builder, CDC and Oracle Workflow. Was responsible for Security and Authorization aspects of the reporting tier, utilizing SSO/OID/LDAP on the top of Oracle 10g IAS. The reporting tier consisted of Oracle Portal and Oracle Discoverer. Designed and Implemented inconsistent DATA logging and cleansing progress monitoring automating system; Designed and Implemented in production ETL for several NCS domains; designed and implemented into production Data Model for the selected NCS application; set up SSO and implemented into production for Oracle Portal and Oracle Discoverer. Provided daily support for five server including production that constituted Data Warehouse environment.
Confidential

Consultant

Responsibilities:
  • Provided Support to SUN Micro system customers. Developed solutions: Evaluated and Improved SW/Database Infrastructure and Architecture, and performed Oracle Database Performance Assessment and Improvement for customers mission critical Applications.
  • Provided SW Architecture analysis, improvement recommendations and Database Performance Assessment, and developed solutions that improved system performance by 200% - 500% for NASD applications.
Confidential, DC

Lead SW/DB Architect

Responsibilities:
  • Designed Architecture for Enforcement Data Mart and develop ETL procedures, utilizing Oracle Advanced Replication. Responsible for release and CM. Provided analysis to the Data Mart reporting/viewing tools.
  • Designed, Implemented and Configured HA Architecture for Enforcement WEB Services with Oracle 9ias/10G Report/Discoverer/BI components.
  • Installed and configured 9ias cluster (reports/forms servers) for development, testing, and
  • production environments. Configured BI components Installed multiple patches on different tiers
  • of 9iAs. Provided troubleshooting for production and development environments, and supported multiple teams of developers and deployed their WEB applications on the servers
  • Setup, supported, troubleshot production environment in the Data Center
  • Develop J2EE objects to establish a bridge with a legacy SW and Oracle 9Ias release 2 and 10G
  • Developed Database objects, and performed Database performance tuning as well as Database Migration. Designed and implemented into production Oracle DHS Enforcement Database security modules on IBM AIX 5.3 Regatta Oracle RAC environment.
Confidential, MD

Sr. SW Engineer/Database Architect

Responsibilities:
  • Provided services to the clients at DOS. The services included: Data Modeling, Systems Architecture, Data Replication across distributed nodes, Data Security, Database High Availability as well as performance tuning. Developed ETL procedures to sustain major DOS Databases utilizing VB6,TSQL and DTS. Developed EDM and Data Warehouse for DOS domain. Utilized Rational ClearCase and ClearQuest.
Confidential, MD

Lead Internet Consultant/Unit Manager

Responsibilities:
  • Developed hands - on Solutions and provided projects technical management for various customers Internet Applications. Supervised three Sr. DBAs.
  • The Solutions: Database Systems High Availability using: Oracle 8i Parallel Server on Sun OS cluster and with Veritas VM ; Oracle/SQL Server Advanced Replication, Hot Standby; Database performance assessment/tuning; installation, configuration, back-up, recovery and troubleshooting; Data Warehouse with Oracle 8i for CRM; Database/Mid Tier Objects Development using Java(EJB-WEBLOGIC;ARIBA;ATG DYNAMO;iPlanet Web Server) and VB for MTS; Back-End System Architecture and Database Design for Internet Platform; Customers: JCREW, Edmunds, BlueFly, United Airlines, Barclays Investments, Baskin and Robins, Dole Food, FMC corporation, Blue Shield of California, Imation, Ajunto, Anheiser Bush etc.
Confidential

Sr. Software Engineer, Project Leader

Responsibilities:
  • Evaluated multiple WEB/Client/Server Software Development strategies and platforms and provided recommendations to the Application Development Division Management. Evaluated Oracle, Sybase and Microsoft technologies.
  • Lead full life cycle client/server development of Spacecraft Hardware Environmental Database and Data Warehouse System.
  • Performed Object Oriented analysis and design using Object Modeling Technique (OMT) approach by J.Rumbaugh and System Architect as a case tool. Developed front-end utilizing PowerBuilder and MVC++.
  • Provided Oracle DBA support
  • Installed, maintained multiple Oracle servers and developed back-up and recovery
  • strategies. Designed logical and physical Database schemas for the system back-end and Data Warehouse with a Staging Area and Data Marts. Used case tools to facilitate the design process.
  • Implemented back-end non-GUI modules on Oracle RDBMS server; used PL/SQL and OCI for implementation.
  • Developed Efficient Strategies on Managing very large(Multiple TB) databases and databases with Binary Large Objects to accommodate Spacecraft testing information. The first production release of the system was implemented in October of 1997 and was commended at NASA publication.

We'd love your feedback!