Database Architect 4

Innovative Computer Solutions Group, Inc; New York (NY); On-site; USD 95,000 - 130,000; Full time

Job summary

Innovative Computer Solutions Group, Inc in New York is seeking a systems professional to support the Contract Management Financial System (CMFS). You will design specifications, document architectures, ensure data integrity, and help maintain high availability of critical workloads.

The role emphasizes SQL databases, security, and operational procedures, with collaboration across the SQL group and occasional customer interactions to clarify feature intent and resolve issues.

Qualifications

• A minimum of 4 years of experience in system development and documentation.
• Experience designing databases, data structures and security controls.
• Proven ability to develop system specifications and operational procedures.

Responsibilities

• Develop system design specifications and architecture diagrams.
• Create documents for general design meeting security requirements.
• Design and optimize complex database structures for evolving needs.
• Plan migration procedures and upgrade techniques for operations.
• Produce End-User Manual and technical documentation.
• Ensure high availability and performance of critical workloads.
• Collaborate with SQL group for problem resolution.
• Occasionally contact customers to clarify feature intents.

Skills

MS Access

VBA

Data structures

Databases design

Technical documentation

System environments exposure

Tools

MS Access

VBA

Job description

PROJECT DESCRIPTION

The Contract Management Financial System (CMFS) application, which underpins essential business functions, including contract lifecycle management, financial tracking, work order processing, and invoice management, is utilized by Contract Managers, Payment Analysts, and the Budget Director. Given its central role, the stability, performance, and ongoing enhancement of this system are paramount.

Tasks & Duties

• Develop system design specifications
• Develop and prepare documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.
• Develop specifications for databases, hardware, network, security, storage requirements.
• Develop structured diagrams for the specifications of databases, computer or storage area networks, security or network programs.
• Develop, compile, maintain and document configurations of the following:
• Databases, servers, computers, security and network monitor systems.
• Develop system documentation
• Develop operational procedures for migration
• Develop guidelines and upgrade techniques of new operational procedures for the support of databases
• Develop detailed systems operations designs
• Develop End-User Manual
• Design and optimize complex database architectural structures to support evolving business requirements.
• Ensure high availability and performance tuning for critical workloads.
• Implement data integrity and security measures aligned with organizational and regulatory standards.
• Establish troubleshooting and rapid resolution of production issues, minimizing downtime and operational risk.
• Establish strategic improvements, including data model enhancements and system scalability planning.
• Design reports, audit trails/logs, security mechanisms
• Plan Collaboration with SQL Group for problem resolution
• Occasionally contact customers as may be needed to clarify the intent of a new feature or resolve a problem
• Perform Testing/Evaluation.

Tasks

• Tests programs and systems and integrates system modules.
• Develop, implement, and monitor information Database quality assurance standards.
• Document testing and QA methods

Required Skills

A minimum of 4 years of experience with the following skill sets:

• Strong hands-on experience in MS Access
• Strong hands-on experience on VBA
• Data structures, data manipulation, databases, design, testing and implementation
• Technical and user documentation
• Exposure to environments include but are not limited to mainframe, mid-range, personal computers, laptops