• Designs, installs, configures, and maintains Oracle database management systems • Optimizes the data environment by keeping databases finely tuned • Troubleshoots data access problems • Establishes and maintains security and integrity controls

• 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