Technical Architect (Oracle)

360 IT Professionals; City of Albany (NY); On-site; USD 100,000 - 130,000; Full time

Job summary

360 IT Professionals is looking for a Technical Architect in Albany, NY. The role requires extensive experience in Oracle database design and PL/SQL coding. Candidates will interact with business users and have a significant role in the development process.

The ideal candidate will have over 7 years of documented experience and a strong understanding of database architecture, ensuring security and compliance with industry standards.

Qualifications

• 7+ years of experience as a Technical Architect.
• Experience with designing and implementing IT solutions.
• Strong understanding of Oracle databases and security.

Responsibilities

• Write complex queries in PL/SQL for multiple applications.
• Develop migration scripts for QA and Production.
• Interact with business users to translate requirements.

Skills

PL/SQL

Oracle database design

Agile methodology

Database security

Technical architecture

Tools

Toad

Job description

Technical Architect (Oracle)

Location: Albany, NY 12231

Duration: - 24 months

Daily Tasks

• Write complex queries in PL/SQL for multiple applications.
• Participate in daily Scrum meetings to support Agile methodology used for system development on multiple systems.
• Write migration scripts for QA and Production for multiple applications.
• Develop scripts for automating support and maintenance for multiple applications.
• Interact with business users to translate requirements into technical models.

Qualifications

• Candidate must be an Expert Technical Architect with documented employment experience of 7+ years.
• Candidate must have technical experience centered around a technology, technologies or a portfolio of applications. Designing and implementing Information Technology solutions.
• Demonstrated work experience ensuring the soundness of the architecture and security of Oracle databases for multiple applications in Production/Quality Assurance/ Development environments.
• Demonstrated work experience creating Oracle schema objects and reviewing developers work to ensure they meet industry and in-house standards for multiple applications.
• Demonstrated experience with Oracle: Database design, PL SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc., including the use of a tool to write and test SQL code and manipulate data (such as Toad).
• Demonstrated experience building and maintaining Oracle tables that contain Personal Health Information (PHI).
• Analyzing, coding and troubleshooting processes that update patient data with information obtained from other databases, by matching on patient identifiers and admission/discharge information.

NOTE: “Candidates that are offered a position are required to pass pre-employment drug and background screening”