The Database/Application Architect’s core responsibility is the definition, implementation, and governance of the logical architecture of the agency-wide software systems, applications and Oracle databases. He/She will evaluate Oracle databases, their related applications and underlying systems not only to meet current business needs of the company, but to also meet future business needs. He/She will assess the functioning of HRT’s overall database technology and application systems to support upgrades and optimize systems for requirements. He /She will participate in projects to upgrade or implement new or existing database-based applications, Oracle databases, or other enterprise software. The application architect should have experience in defining the architecture of N-Tier and messaging-based enterprise applications. The role of the person in this position is to expand the company’s use of data as a strategic enabler of corporate goals and objectives. May serve as database lead, database technical expert or project manager with team(s) concerned with database application development, systems management and networking to coordinate changes and support enterprise technology initiatives. Provide technical and database architectural subject matter expertise to the various application management teams including communicating architectural decision rationale, collaboration and possibly mentoring other technical staff around the various enterprise technologies. Confer with business units and application development staff to understand both the business and technical requirements and to define architectural constraints on proposed application development projects or increases in scale of production software. Provides Oracle database support in installation, administration, deployment, infrastructure management and upgrades of all agency wide database-based application systems. Maintains database and application-specific documentation and metrics. Design, develop, administer and supervise Oracle database back-up, database security and data maintenance. Manages infrastructure / storage / web and deployment needs for all production system. Come with solutions to support 24x7 applications by designing fail-over system and determine MTTR and MTBF from database and application point of view. Provides help in creating RFP’s, and requirements needs evaluation for new applications agency wide. Plans and evaluates management infrastructure for key production application, involves management of test system, recovery system and storage of both actual and recovery data. Writes technical approach and design documentation. Collaborates with agency department managers to define hardware/software requirements, plan and execute the integration of acquisition applications and corporate initiatives, and coordinate project schedules, budgets, management requests and work authorizations. Works on complex medium to large size projects. Works with Business Owners on assigned projects by defining, developing, testing, documenting, and implementing PMP standards, scheduled time lines, and project budgets. Manages multiple projects that may have competing business and technology requirements. Manages enterprise wide functional resources and consultants during all phases of projects. Develops strategies for data acquisitions, archive recovery, and implementation of a database including security protocols. Demonstrates high level of leadership and software project management. Required Knowledge, Abilities and Skills essential to Job Functions: Extensive working knowledge of Oracle database architecture, terminology, processes; extensive use and knowledge of Oracle SQL, PL/SQL, Import/Export/Load, backup and recovery methodologies; working knowledge of relational database technologies (OLTP, OLAP, ETL); significant development experience in a Microsoft Windows server environment with C++, writing complex stored procedures, queries, views, and triggers is also required; mastered physical database design and have expertise with database indexing, statistics and tuning; Good critical and analytical thinking Training and/or Education: BS in Computer Science, Systems Engineering, Management Information Systems or Information Systems or Related Field. Required Experience: 5+ years Oracle DBA experience in a production environment. Extensive Oracle database programming/scripting/development experience. 5+ years proven experience in enterprise application systems administration and programming. Extensive MS Windows server, network infrastructure and technology background. Licenses or Certificates: Oracle Certification preferred.
