We provide IT Staff Augmentation Services!

Database Administrator / Architect Resume

5.00/5 (Submit Your Rating)

Rockville, UsA

CAREER SUMMARY:

Lockheed Martin Principal Enterprise Architect focusing on database architecture and database administration with extensive experience on creating robust database architectures for mission - critical systems and delivering OLTP, OLAP, Data Mart, and Data Warhouse strategies supporting client’s primative businesses. Lead in system and solution architecture and migration of legacy operations with Oracle, WebLogic, Informatica, Business Objects, Unix, Windows and Linux technologies, and C#, ASP.NET, and Java. Possessed the skills to quickly adapt to any environment during any point of the project cycle and provide efficient response to company deadlines and system complications. An energetic self-starter with excellent organizational, analytical, and creative skills with an in-depth knowledge of the Oracle database and other products. A passion for excellence and a tracible performence through out career tracks.

TECHNOLOGY PROFILE:

  • Oracle 7, 8, 8i, 9i, 10G, 11G database administration and management
  • SQL*Plus, SQL and PL/PQL programming and development
  • Unix systems: HP-UX, Solaris, AIX, Linux
  • Oracle*Net, Net8, SQL*Net, TCP/IP
  • Oracle Real Application Clusters (RAC)
  • Determining the Oracle RAC architecture
  • Choosing the best RAC servers and hardware
  • Installing Oracle RAC software
  • Oracle Data Guard
  • Configuring Database, SQL*NET, Listener for Data Guard
  • Standby database for reporting purpose
  • Standby database for Disaster Recovery automatic fail-over
  • Oracle Weblogic Portal, Oracle WSRP Producer, Web Services
  • Business Objects, Informatica, SAS DataAccess, ERWin, ArchiMate
  • Visual Studio, C#, ASP.NET, Java, VB, VBScript, JavaScript, Shell Scripting
  • IIS, Apache, Tomcat

PROFESSIONAL EXPERIENCE:

( )

Confidential,Rockville, MD Ginnie Mae ( )

Lead Principal Database Administrator / Architect

  • Lead migration of 12 databases and systems to Enterprise Portal successfully
  • Redesigned the databases and converted the data successfully with compliance to the customer standards
  • Designed data marts and data warehouse to support risk analysis and decision making processes
  • Designed and developed a fast track of data disclosure flow to support the investment transparency to help investors make smart decisions and make the Ginnie Mae Programs more attractive for investors
  • Designed and developed an automated financial risk management triggering system sending risk level alerts to account management executives
  • Setup and managed a production RAC database system in two Solaris 10 nodes
  • Setup and administrated other two production databases which each contains two remote standby databases
  • Eliminated or reduced database maintenance downtime through the Data Guard strategy
  • Configured automatic fail-over which resulted a Disaster Recovery in no down time
  • Scripted and managed the RMAN backup to disk and to tape with VERITAS NetBackup
  • Migrated the client’s data center to a different location with all new servers and installations
  • Migrated the client’s Disaster Recovery data center to a distant location with all new servers and installations
  • Wrote more than 100 stored procedures, packages, and functions to support the 12 systems business processes
  • Automated backup and restore scripts
  • Effectively negotiated with and influenced others, building and maintaining relationships with stakeholders; communicating successfully with business teams, development teams, and executive management
  • Provided sources of new enhancements and CPI for expanding business and new funding with customer

Confidential,Arlington, VA EPA ( )

Senior Enterprise Architect / Project Lead- EPA Office of Water Projects

  • Designed and created UIC database in IBM AIX server that supports a large monthly payload process flow
  • Created and administered databases in Red Hat Linux that support the EPA Content Management project with Documentum
  • Infrastructure lead of the Content Management System development and deployment team and installed and managed the Documentum Content Server and integrated with Lotus Notes email system content management
  • Led development efforts using Agile and CMMi frameworks through full lifecycle to produce data centric systems for Environmental Protection Agency
  • DBA center of excellence lead and mentored junior database administrators and database developers to ensure the project completion within schedule
  • Successfully designed and delivered a multi-tier data flow system using SOAP, XML, XML Schematron, web services and dimensional data warehouse
  • Created system development schedule, LOE, system verification and validation methodologies, test plans/cases, system performance analysis and reports to manage development risks during SDLC
  • Successfully conducted JRP (Joint Requirement Planning) events and provided multiple training sessions to IPT(Integrated Program Team) members

Confidential,Rockville, MD Ginnie Mae ( )

Senior Database Administrator & Architect

  • Led multiple system migrations design and development efforts using Oracle and Unix technologies with web-based Cloud applications that performs verification and reporting of mortgage-backed security system for loan reporting and decision support. Provided disaster recovery and 99% uptime of production database systems.
  • Designed and built Ginnie Mae e-Access which serves as customized portal that provided single-sign-on capability
  • Designed, architected, and developed highly innovative Customer Relationship Management and online delivery system to replace the traditional way of fax, mail, tape document delivery system with full customer satisfaction
  • Designed and delivered WEBIIS, SCRA, ENOTE, IEDS, and MATCH databases on time, budget, and quality
  • Designed the architectural solution for GPADS and Chase Manhattan ENOTE enterprise systems

Confidential,Bethesda, MD ( )

Senior Database Engineer Consultant

  • Responsible for designing, developing and delivering web applications in a mixed Oracle and SQL Server database environment. Delivered SDLC phases: analysis, design, development, testing, deployment and maintenance using Active Server Pages and MS SQL Server database application. Converted a commercial database Titanium to SQL Server.
  • Applied ASP, IIS, VBScript and JavaScript, HTML to develop a dynamic web-based intranet system to administer government patent process.
  • Converted an Access 97 database to Oracle 8.x and implemented business rules by writing triggers, functions, procedures and packages. Developed user interfaces and reports using Oracle Developer/2000 and Oracle Forms 6.0
  • Worked in the full life cycle of Oracle (Unix and Windows/NT) RDBMS, duties on business process modeling, analysis, logical and physical design, DFD, ERD, database schema and application development
  • Conduct database design and development: using CASE tools (Designer/2000 and ERWin) and Rapid Application
  • Provided process models, data flow diagrams, and Entity-Relational Diagrams for the creation of databases in Oracle, MS SQL Server and MS Access

We'd love your feedback!