• Install, maintain, and troubleshoot RHEL/OEL OS supporting Oracle databases in physical and virtualized environments. • Provide DBA services to application development, professional services, and support teams, including database design, query validation/execution, and performance tuning. • Troubleshoot database alerts, logs, jobs, disk groups, tablespaces, and resolve performance-related issues. • Automate database tasks and develop scripts to improve efficiency and reduce manual intervention. • Lead the design and implementation of database infrastructure solutions to meet business requirements. • Manage the implementation of technical controls to enforce security policies. • Ensure compliance with SOC2/ISO27001 audits and adhere to all audited controls. • Design, implement, and maintain DR methodologies, ensuring documentation is up to date. • Periodically validate Oracle 19c backup/recovery operations using RMAN. • Assume responsibility for documenting and maintaining disaster recovery plans for each supported system. • Research, evaluate, design, test, and recommend new database software versions and related tools. • Act as a mentor for junior DBAs and provide technical guidance. • Assist development teams in improving database design and PL/SQL best practices. • Provide 24/7 on-call rotational support, including occasional weekend coverage. • Familiarity with monitoring tools like DataDog, Solarwinds, site24/7 or OEM.

• Own the end-to-end product roadmap for Ditto's cloud database • Own the data flow story for Ditto Cloud • Define and maintain customer-facing database SLAs • Own the data migration story • Engage directly with enterprise customers to understand workload patterns • Serve as the go-to voice on the customer data layer inside engineering • Collaborate with GTM and field teams to build enablement assets • Define success metrics for database reliability and drive accountability against them

Role Description We are seeking a highly experienced Senior Oracle Developer & Database Administrator (DBA) to support mission-critical applications and databases. The ideal candidate will possess strong expertise in Oracle database administration, PL/SQL development, production support, performance tuning, database migration, and cloud migration initiatives involving AWS and Red Hat Linux environments. Key Responsibilities - Develop and maintain Oracle PL/SQL packages, procedures, functions, triggers, and database objects. - Provide Level 2/Level 3 production support and resolve critical database issues. - Perform data analysis, troubleshooting, and data correction activities. - Administer Oracle databases including installation, configuration, upgrades, patching, backup, and recovery. - Design, implement, and maintain materialized views and database performance optimization strategies. - Support database migration projects across on-premises, AWS, and Red Hat Linux (RHEL) environments. - Monitor database performance and proactively resolve bottlenecks. - Perform database security, user management, and access control administration. - Execute database deployment, release management, and post-deployment validation. - Collaborate with development, infrastructure, and DevOps teams to ensure system reliability and availability. Qualifications - Strong Oracle Database Administration (DBA) experience. - Advanced PL/SQL development expertise. - Experience with production support and incident management. - Strong SQL performance tuning and query optimization skills. - Experience with materialized views, partitioning, and database performance monitoring. - Hands-on experience with Oracle database migration and upgrade projects. - Experience working with AWS services (RDS, EC2, DMS, S3, CloudWatch). - Experience supporting Oracle databases on Red Hat Enterprise Linux (RHEL). - Knowledge of backup/recovery strategies, RMAN, Data Pump, and disaster recovery. - Strong analytical and troubleshooting skills. Preferred Skills - Oracle RAC and Data Guard. - Shell scripting (Linux/Unix). - DevOps and CI/CD exposure. - Experience in large-scale enterprise production environments. Key Competencies - Oracle DBA - Data Architecture & Engineer - Database Migration - AWS Cloud Migration - Red Hat Linux Administration - Production Support - Data Fixes & Troubleshooting - Materialized Views - Performance Tuning - Backup & Recovery - Root Cause Analysis

Role Description The Connecticut Criminal Justice Information System (CJIS-CT) is expanding its CISS Analytics platform, designed to improve data sharing and analytics across criminal justice agencies. The system supports policy and legislative decisions related to crime and public safety. CJIS is seeking a SQL Database Developer/Administrator to support database development, performance optimization, and data transformation efforts while collaborating with business teams, infrastructure teams, and analytics stakeholders. Key Responsibilities - Design and review database schemas for application releases - Perform database maintenance (index rebuilds, table reorganization) - Support day-to-day database operations and troubleshooting - Optimize database performance and query efficiency - Assist with database upgrades and migration strategies - Administer multiple SQL Server databases across environments - Develop views, stored procedures, triggers, and functions - Work with Microsoft BI stack (SSRS, SSIS, SSAS) - Develop dashboards and reports using Power BI - Support ETL processes and data transformation - Participate in unit testing and assist with system/UAT testing - Ensure compliance with CJIS architecture standards including JRA, NIEM, NCSC, and GFIPM Qualifications - 5+ years experience with: - Microsoft SQL Server 2019/2022 (Development & Administration) - SSRS, SSIS, SSAS - ETL processes - Power BI dashboards - Writing Views, Triggers, Stored Procedures, Functions - Database performance tuning (indexes, constraints, keys) - Windows Server 2019/2022 - PowerShell or Windows shell scripting Nice to Have - Database design tools such as ERWIN or Embarcadero - RUP / structured development methodology - CONNX ETL tool - Disaster Recovery / Business Continuity Planning Additional Requirements - Ability to work in a 24x7 on-call support environment if required - Must pass background investigation - Work collaboratively with criminal justice agencies and state partners