• As a Mid-level SQL Server DBA, you will configure and maintain environments with AlwaysOn Availability Groups, Failover Cluster Instances (FCI), Log Shipping and Replication; • Identify I/O, CPU and memory bottlenecks; • Analyze execution plans (Execution Plans), identify unnecessary Index Scans, design efficient indexing strategies and resolve deadlocks and lock escalation issues; • Ensure the backup policy (Full, Differential, Transaction Log) meets the business RTO (Recovery Time Objective) and RPO (Recovery Point Objective), and regularly test and validate restores; • Have a deep understanding of how queries work to help the development team optimize code, stored procedures and triggers; • Troubleshoot quickly using tools such as Extended Events, Query Store, DMVs (Dynamic Management Views) or Profiler; • Analyze data growth trends, plan capacity and recommend infrastructure upgrades or historical data archiving; • Use PowerShell or T-SQL scripts to automate repetitive tasks (such as integrity checks with dbatools/DBCC CHECKDB and reindexing). • Manage SQL Server environments • Plan and execute: • Backup and restore strategies • Index and statistics maintenance plans • Installation and configuration of SQL Server • Administer security: • Object-level permissions • Principle of least privilege • Basic encryption (TDE, encrypted backups) • Perform performance analysis and troubleshooting • Use Query Store to: • Identify plan regressions • Force plans when necessary • Use Profiler and Extended Events for troubleshooting • Replication: • Transactional replication • Snapshot replication • Bi-directional replication • Support database architecture improvements • Work closely with development teams

• Design, install, operate and optimize the Court's Oracle database resources and solutions, ensuring high availability, integrity, security and performance of institutional data • Install, deploy, administer and maintain the set of tools, software and hardware for the organization's Oracle solutions • Handle incidents, problems, requests and level-3 changes related to the database environment • Perform configurations, changes and optimizations (tuning) to ensure optimal application performance • Keep the environment up to date by applying patches and fixes, following change management guidelines • Provide specialized technical support in data techniques and tools for system maintenance projects • Administer the Oracle environment specifically, maintaining the data object library and ensuring an integrated view of information • Specify logical data security criteria and validate logical and physical models with the client • Configure and manage backup and restore routines, supporting the proposal of data protection policies • Perform continuous analysis of performance and utilization of computing resources • Lead the evaluation of new database infrastructure solutions and prepare technical specifications to support institutional analyses • Prepare and keep technical documentation and best-practice articles up to date.

Role Description Your future role at a glance - Architect & Optimize Database Ecosystems: Design, standardize, and implement enterprise-grade database configurations, performance tuning, robust backup/recovery strategies, and proactive alert/monitoring frameworks across multi-platform environments. - Lead High-Availability & Cross-System Integration: Engineer and govern scalable data and application architectures integrating multiple complex systems, leveraging MSSQL AlwaysOn, Oracle RAC, and Data Guard to ensure maximum uptime and minimal latency. - Drive Design, Modeling, & Gap Analysis: Facilitate high-level technical design sessions and execute end-to-end ecosystem gap analyses with cross-functional teams and vendors, translating complex business needs into relational/dimensional data models. - Harden Database Security & Governance: Establish and manage stringent database access governance frameworks and coordinate multi-team vulnerability remediation, providing deep technical guidance on feasibility and risk mitigation. - Direct Multi-Platform Database Administration: Oversee the lifecycle and full-stack administration of diverse database technologies—including MSSQL (SSAS, SSIS, SSRS), Oracle, MySQL, PostgreSQL, and MongoDB—while optimizing highly complex SQL queries. Qualifications - High School diploma equivalency with 2 years of cumulative experience OR Associate's degree/Bachelor's degree OR 4 years of applicable cumulative job specific experience required. Requirements - Advanced proficiency in networking topology and infrastructure design, including deep familiarity with TCP/IP protocols, DNS, and secure load balancing. - Proven track record of managing competing priorities across concurrent enterprise-scale migration or deployment projects within strict timelines. - Experience implementing automated scripting (e.g., PowerShell, Python, or Bash) for database maintenance, orchestration, and continuous monitoring. Benefits - Paid time off (PTO) - Various health insurance options & wellness plans - Retirement benefits including employer match plans - Long-term & short-term disability - Employee assistance programs (EAP) - Parental leave & adoption assistance - Tuition reimbursement - Ways to give back to your community

Role Description The Coordinator, Database Systems Support – Bilingual Spanish (Internal title: Coordinator, Research, Evaluation and Learning) is responsible for supporting the administration and optimization of the case management database system used across the Covenant House federation to collect, manage, and analyze program data. This role plays a critical part in advancing Covenant House International’s commitment to becoming a data-informed Learning Organization that achieves positive outcomes for and with young people experiencing homelessness and human trafficking. In this role, you will report directly to the Manager of Database Administration and Support. You will support CHI and site teams’ efforts to improve their use of the database system, troubleshoot issues, develop standardized data collection practices, and ensure data quality to effectively use data to improve outcomes for youth and contribute to collective impact across the federation. Qualifications - Bilingual in English and Spanish with strong written and verbal communication - Experience providing database user support - Demonstrated ability to explain technical concepts to non-technical users - Strong communication, public speaking, and interpersonal skills; ability to support users with varying levels of technical ability - Detail-oriented, with strong problem-solving and organizational skills - Customer service mindset and ability to collaborate across diverse teams Requirements - At least 1 year of experience with ETO or another case management or homelessness services database system in a nonprofit or human services context Preferred Knowledge, Skills, Abilities and Qualifications - Bachelor’s degree in a related field (e.g., information systems, social sciences, public administration) - Experience working in one of the three countries that we serve in Latin America (Mexico, Guatemala, Honduras) - Proficient in Microsoft Word, Excel, PowerPoint, or the Microsoft 365 Power Platform - Experience with trauma-informed youth-serving programs - Experience supporting system rollouts or transitions in a multi-site organization Travel Requirements - Ability to travel once per year to New York City in early October for our annual in-person traditions and up to four times per year for in-person team meetings - Occasional travel to sites across the Covenant House federation to train staff on the use of ETO touchpoints and program outcome measures - While this position is designed as a remote role, candidates based in the New York City metropolitan area may choose to work from our Midtown Manhattan office on a hybrid or full-time in-office schedule. Our Community Our critical mission demands that we have all voices at the table. A team of diverse people, perspectives, and experiences is smarter, stronger, and more effective for our young people. At Covenant House, every team member is valued, respected, heard, and supported, and we welcome honest and courageous self-reflection on any aspects of our work that are based on biased or outdated viewpoints. We deliberately create opportunities for our staff to grow and thrive. Covenant House International is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind: CHI is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at CHI are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion, belief, sex, sexual orientation, gender identity, national origin, veteran status, family or parental status, disability status, or any other status protected by the laws or regulations in the locations where we operate. CHI will not tolerate discrimination or harassment based on any of these characteristics and encourages all qualified applicants to apply. If you have a disability or medical condition and need a reasonable accommodation, such as an ASL interpreter or a different interview format, or if you have physical accessibility needs, let us know. Contact us at 1-929-502-2521, Monday through Friday, 9 a.m. to 5 p.m., Eastern Time or email us at chipeopleandculture@covenanthouse.org.