DATABASE ARCHITECT (JOB ID: 0000004080)

• Functions as a senior technical expert in the application Data Architecture.

• Establishes and maintains strategies, principles, and procedures that govern database management, maintenance and operations activities.

• Maintains fundamental technical design structures and principles of the database architecture.
• Advises and consults with management and application leads, regarding database problems, performance issues, and system changes.

• Reviews and analyzes change requests to determine the database-related scope of work and estimate the level of effort. Writes technical specifications.

• Provides problem resolution support; identifies and resolves the most complex problems, coordinating with system users to determine symptoms and ensure accurate problem definition and resolution.

• Assists in development and improvement of plans, processes, procedures, standards and priorities.
• Creates and maintains reports on the status of database issues and activities.

• Maintains direct knowledge of and applies all relevant database processes,procedures, and quality standards.

A minimum of ten (10) years of progressively complex experience and expert-level skill in analysis, architecture, design, installation, configuration, operation, and maintenance of information systems hardware and software, five (5) of which must have been in a technical lead position.

Baccalaureate-level degree in relevant technical specialty, such as computer science, management information systems, computer engineering, software engineering OR certification in software engineering disciplines, such as IEEE Certified Software Development Professional.

Expert-level skill and knowledge in database design and development, as evidenced by the following:

• Five (5) years’ experience filling a lead role as a database architect or technical expert.

Expert-level skill and knowledge and experience in at least eight (8) of the following database design, development, and administration-related concepts, methods, and tools:

• Physical and Logical Data Modeling (e.g., with UML) Database Definition Language (DDL)
• Writing SQL stored procedures
• Index analysis and management
• Normalization and de-normalization
• Referential integrity
• Data replication concepts1/1
• Locking Strategies
• Reporting Tools
• Extract Transform and Load (ETL) tools
• Data Warehouse concepts, including data mining, data marts, on-line analytical processing (OLAP), etc.

Expert-level skill and knowledge and experience in following database architecture-related technologies:

• Microsoft SQL Server
• Business Intelligence Solutions
• SQL Server Monitoring/Performance tools (system sprocs, PerfMon etc.)
• Database security and integrity

Expert-level skill and knowledge and experience in the following additional system software concepts and technologies:

• Enterprise Application Integration (EAI) patterns, topologies, and tools
• File Transfer protocols and tools, including Secure File Transfer
• Database back up and storage
• Use of modeling, administration, monitoring, and configuration management tools applicable to databases, operating systems, and/or networks.
• Database Architect should also be familiar with design and operations of DB2 databases (intermediate skill and knowledge level)

Expert skill-level and knowledge and experience with following .NET application architecture-related technologies:

• Avicode .NET Application Monitoring
• Microsoft Biztalk
• Application interfaces (with .NET or Mainframe applications) Business Rules Engine (such as ilog or InRule)
• Web services
• Enterprise Service Bus
• Load balancers such as F5
• SQL Database

Job Type: Full-time