Database Architect, Principal Leader Resume
Washington, DC
OBJECTIVE:
To obtain challenging senior - level-lead software engineer/architect/DBA/Manager position, requiring design, analysis and hands-on skills as well as mentoring and managerial experience.
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.
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.
QUALIFYING EXPERIENCE:
Confidential, Washington, DC
Database Architect, Principal Leader
Responsibilities:
- Develop architecture for Confidential 11G Infrastructure upgrade, and provide input to Confidential Infrastructure design and planning.
- Develop Enterprise Deployment of 11G infrastructure implementation workflow, and Leaded implementation of 11g FMW installation and configuration on all Confidential environments for the new Confidential 11G infrastructure.
- As a Technical lead developed project scope and planning for Confidential new Oracle IDM system for Confidential external users federation. Designed, Architected and leaded OID 11.1.1.5 cluster implementation in Confidential 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 Confidential Infrastructure Configuration Management efforts. Provided analysis to security standards to implement on Confidential Infrastructure; includes STIG and SCAP methods. Compiled proposed vulnerabilities list based on Oracle best practices. Support Confidential infrastructure components including SOA suite, SSO/OID and multiple J2EE applications within Oracle 10g Application Server.
- Designed and configured Weblogic environment to migrate major J2EE application from JBOSS - 4.2.3 to Weblogic 10.3.5. Participated in the migration process and subsequent application performance tuning.
- Provide Support to multiple instances of Confidential Oracle 11g and 10g Database servers.
Confidential, MD
Principal Consultant
Responsibilities:
- Design 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.
- Participate 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 Confidential critical system
Confidential, MD
Sr. Identity Management Consultant/ Project Lead / Oracle DBA
Responsibilities:
- 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 / Oracle DBA
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.
Confidential, McLean, 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 in corporate 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, Washington, 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 Confidential 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.
- 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 Confidential Infrastructure monitoring implementation utilizing GRID technology. Currently the technology was successfully moved to production environment and cover entire Confidential UNIX/LINUX infrastructure.
- Coordinated with QA and Designed Promotion Model for the IM project Configuration Management using PVCS.
Confidential, Washington, 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 Confidential domains; designed and implemented into production Data Model for the selected Confidential 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.
- 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, Washington, 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 f 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 Confidential .
- 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 Confidential Databases utilizing VB6,TSQL and DTS.
- Developed EDM and Data Warehouse for Confidential domain.
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.
- 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
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 Confidential to accommodate Spacecraft testing information.