Tasks & Duties
- Designing and Developing Software Systems
- Design, develop, and maintain Oracle 19c CARES DataMart and SQL Server database objects, ensuring optimal structure, performance, and scalability for both transactional and analytical systems
- Create and maintain critical operational and analytical reports (e.g., 24/7 Resource Room reports) to support agency decision-making
- Support and enhance key housing subsidy programs including applications that automate eligibility, budgeting, and document generation
- Design, implement, and maintain secure interagency data exchange processes, ensuring timely and accurate data sharing that directly supports client services
- Perform database performance tuning using advanced techniques (indexing, query optimization, execution plans) to ensure system efficiency and responsiveness
- Develop and support database services for .NET and Java-based applications, ensuring seamless integration with backend systems
- Implement and manage database security controls, including user roles, permissions, and data access policies to protect sensitive information
- Evaluate and recommend new database technologies, tools, and cloud solutions (AWS, Azure, Oracle Cloud) to improve system capabilities and scalability
- Build and maintain data warehouse components to support operational reporting, analytics, and long-term data strategy
- Analyzing User Requirements and Quality Assurance
- Collaborate with business stakeholders to gather, analyze, and document detailed requirements, ensuring alignment with operational needs and data security standards
- Evaluate current system functionality, identify gaps, and recommend enhancements to improve performance and usability
- Analyze and support system integrations across multiple agencies, ensuring data consistency and compliance
- Develop comprehensive test plans, test cases, and acceptance criteria based on business and technical requirements
- Support and coordinate User Acceptance Testing (UAT), ensuring solutions meet business expectations and quality standards
- Ensure all applications and changes comply with established quality assurance processes and audit requirements
- Provide Environment Support
- Perform core DBA functions, including database installation, configuration, schema design, performance monitoring, and deployment of database changes
- Provide ongoing maintenance and production support, including troubleshooting issues, applying fixes, and ensuring system stability
- Coordinate with development teams, infrastructure teams, and external agencies to resolve technical issues and support data exchanges
- Manage and enforce release management processes, ensuring all production changes are properly tested, approved, and deployed
- Support system migrations, upgrades, and implementation of new features or enhancements
- Create Design and Test Documentation
- Develop detailed system design documents, including technical specifications and data architecture diagrams
- Create conceptual, logical, and physical data models to support system development and maintenance
- Prepare process flow diagrams and documentation (using Visio) to clearly illustrate system logic and workflows
- Build business process mockups and data flow examples to help stakeholders understand system impacts
- Execute system, integration, and user acceptance testing for both UI and backend processes
- Prepare test protocols, results documentation, and audit-compliant reports to support final system validation
Required Skills
A minimum of 6 years of experience with the following skill sets:
· Real world delivery experience
· Oracle 9i, 10g, 11g. Sybase 12.5, SQL Server 2000/2012, DB2 UDB
· SQL, PL/SQL, UNIX Shell Scripting.
· MS Visio, Star Schema Modeling, Snow Flake Modeling
· QL*LOADER, SQL Developer, TOAD, SQL*PLUS. DB Artisan, Perforce, PVCS, SSMA, RGS, SSMA, SSIS, SSRS
· Informatica 8, Business Objects X, XI, Oracle Reports, BM Cognos Version 10.2.2
· Linux, UNIX, Windows 2003/2000/NT.
· Curam V7 Certified Developer Experience working in the technical architecture field.
· Cúram V7, Cúram Enterprise Framework Components, Cúram Intelligent Evidence Gathering (IEG2), Cúram Express Rules for Triage (CERT)
· HTML, DHTML, JavaScript, open source Java framework, (Struts/Springs), Ajax (JQuery, Dojo), SOA, and WebServices
· Websphere, ESB or Message Broker, Eclipse, JIRA, Webservice, and Oracle
· Bachelor's Degree or relevant experience in Business, Information Management, or a related field
Good to have NYC-DSS M&O Services for DSS Application Systems experience
Never miss an opportunity! Create an alert based on the job you applied for.