Jobs via Dice
Database Architect / Data Modeler (Erwin / SQL)
Jobs via Dice, Albany, New York, United States
Database Architect / Data Modeler (Erwin / SQL)
Trigyn's direct government client has an immediate need for a Database Architect / Data Modeler in Albany, NY. This position will support the development and maintenance of business solutions on SQL Server and Oracle platforms using advanced database development techniques. The role involves designing complex relational database systems, developing PL/SQL objects, and creating ETL processes using shell scripting and SQL. The candidate will follow agency software lifecycle methodologies, creating design documents, coding, debugging, and testing. This individual will participate in the following activities: Implementing Integrated Justice Portal standards related to database development Utilizing use cases, business requirements documents, and flow diagrams to design complex relational databases Following all phases of the Software Development Life Cycle (SDLC) – analysis, design, testing, implementation, maintenance Contributing to agency standards and applying industry best practices Developing queries and stored procedures for data extraction using SQL on Oracle or SQL Server; writing complex efficient SQL Performing ongoing support for production applications, including system monitoring, processing, user support, and performance tuning Creating, maintaining, and deploying batch processes to support portfolio business processes Researching emerging technologies to improve current processes Mandatory Qualifications: Experience in Information Technology, with expertise in development platforms, technical architectures, or business applications beyond programming Ability to provide guidance to large teams and/or possess extensive industry experience, recognized at the top of the field 84 months experience creating Views, Triggers, stored procedures, functions, and writing SQL in Oracle (12c or higher) and SQL Server (2014 or higher) 84 months experience using data modeling tools such as ERWIN to create physical and logical data models, reverse engineer existing databases, and compare existing databases in SQL Server (2014 or higher) and Oracle (12c or higher) 84 months experience developing complex ETL processes using shell scripts (Korn, Bash, and PowerShell), SQL scripts, PL/SQL, and T‑SQL objects 84 months experience performing data analysis and creating reports for customers 84 months experience optimizing SQL queries and debugging PL/SQL packages, functions, and procedures 60 months experience developing Korn shell and Bash shell scripts in a Linux environment For immediate response call or send your resume to TRIGYN TECHNOLOGIES, INC. We are an EQUAL OPPORTUNITY EMPLOYER and have been in business for 35 years. TRIGYN is ISO 9001:2015, ISO 27001:2013 (ISMS), ISO 20000:2018, and CMMI Level 5 certified. Seniority level
Mid‑Senior level Employment type
Full‑time Job function
Information Technology Software Development
#J-18808-Ljbffr
Trigyn's direct government client has an immediate need for a Database Architect / Data Modeler in Albany, NY. This position will support the development and maintenance of business solutions on SQL Server and Oracle platforms using advanced database development techniques. The role involves designing complex relational database systems, developing PL/SQL objects, and creating ETL processes using shell scripting and SQL. The candidate will follow agency software lifecycle methodologies, creating design documents, coding, debugging, and testing. This individual will participate in the following activities: Implementing Integrated Justice Portal standards related to database development Utilizing use cases, business requirements documents, and flow diagrams to design complex relational databases Following all phases of the Software Development Life Cycle (SDLC) – analysis, design, testing, implementation, maintenance Contributing to agency standards and applying industry best practices Developing queries and stored procedures for data extraction using SQL on Oracle or SQL Server; writing complex efficient SQL Performing ongoing support for production applications, including system monitoring, processing, user support, and performance tuning Creating, maintaining, and deploying batch processes to support portfolio business processes Researching emerging technologies to improve current processes Mandatory Qualifications: Experience in Information Technology, with expertise in development platforms, technical architectures, or business applications beyond programming Ability to provide guidance to large teams and/or possess extensive industry experience, recognized at the top of the field 84 months experience creating Views, Triggers, stored procedures, functions, and writing SQL in Oracle (12c or higher) and SQL Server (2014 or higher) 84 months experience using data modeling tools such as ERWIN to create physical and logical data models, reverse engineer existing databases, and compare existing databases in SQL Server (2014 or higher) and Oracle (12c or higher) 84 months experience developing complex ETL processes using shell scripts (Korn, Bash, and PowerShell), SQL scripts, PL/SQL, and T‑SQL objects 84 months experience performing data analysis and creating reports for customers 84 months experience optimizing SQL queries and debugging PL/SQL packages, functions, and procedures 60 months experience developing Korn shell and Bash shell scripts in a Linux environment For immediate response call or send your resume to TRIGYN TECHNOLOGIES, INC. We are an EQUAL OPPORTUNITY EMPLOYER and have been in business for 35 years. TRIGYN is ISO 9001:2015, ISO 27001:2013 (ISMS), ISO 20000:2018, and CMMI Level 5 certified. Seniority level
Mid‑Senior level Employment type
Full‑time Job function
Information Technology Software Development
#J-18808-Ljbffr