Database Administrator - NYC- DSS

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