What are the responsibilities and job description for the Database Developer / Architect (OBIEE/OAS) position at Trigyn Technologies, Inc.?
Trigyn's direct government client has an immediate long-term need for Database Developer / Architect in Menands, NY.
Description:
This resource will serve as backup support for both Data modeling and ETL.
? Perform data analysis of current and future WIC systems, including system comparison, to support ongoing and future data needs.
? Collaborate with customers, vendors, and technical teams to gather requirements, perform gap analysis, and prioritize reporting needs.
? Design and maintain enterprise data architecture, including conceptual, logical, and physical data models, while performing ongoing data modeling and schema design.
? Define and enforce data standards, naming conventions, governance practices, and ensure data quality, integrity, and consistency across all environments.
? Develop and maintain documentation of business processes, workflows, and data flows using modeling techniques and flowcharts.
? Develop, review, and optimize ETL processes and mappings for data migration (Sybase, MS Access to Oracle), improving performance and efficiency.
? Design and support reporting solutions, including dashboards and prototypes, aligned with end-user requirements.
? Develop and execute test plans, scripts, and validation scenarios to ensure data accuracy and compliance with business requirements.
? Monitor and optimize database performance through query tuning, indexing, partitioning, and overall system optimization.
? Implement and maintain database security, access controls, auditing, and compliance with organizational and state data privacy requirements.
? Evaluate implementation strategies, identify risks and issues, and support resolution and mitigation planning.
? Provide technical guidance, conduct design reviews, mentor team members, and support release planning and post-implementation reviews.
? Facilitate and document meetings, support reporting development discussions, and ensure proper tracking of outcomes.
Administrative tasks: Perform administrative duties including attendance at meetings and completion of timecard and monthly timesheets.
Mandatory Qualifications:
? Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system.
? Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
? 84 Months Experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancement, migrations, web catalog, RPD, and BI Publisher deployments across enterprise reporting environments.
? 72 Months Experience leading ETL teams and designing enterprise data integration architecture using Informatica, including data standards, governance, best practices, and mentoring for data warehouse initiatives.
? 72 Months Experience in Oracle database development, including advanced SQL/PL/SQL programming, performance tuning, optimization, and conversion of complex SQL, stored procedures, and SAS logic into Informatica mappings.
? 72 Months Experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security setup, patching, migrations, and production support across DEV/QA/UAT/PROD
? 84 Months Experience in OBIEE performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements.
? 48 Months Experience in data modeling and system analysis, including dimensional modeling, star/snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses.
? 48 Months Experience in ETL and BI testing, including test strategy development, SIT, UAT, regression testing, data validation, reconciliation, and defect resolution across BI and data warehouse systems.
? 48 Months Experience in advanced data validation and troubleshooting using SQL/PL/SQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems.
? 48 Months Experience in end-to-end BI implementation and data governance, including requirements gathering, ETL development, semantic layer design, dashboard/report development, deployment, and enterprise data governance, lineage, and quality frameworks.
? Bachelor's Degree in IT field.
For Immediate Response call , or send your resume to
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.