• Own the day-to-day administration, support, and scheduled release of the Microsoft SQL Server environment. • Install, configure, upgrade, and patch SQL Server instances across production, testing, and development environments. • Monitor database health, capacity, and performance; proactively tune queries, indexes, and configurations. • Implement and maintain backup, recovery, and high-availability strategies. • Administer database security, access controls, and user management. • Serve as the point of contact for incoming database requests from internal teams. • Execute ad-hoc queries against production and non-production databases. • Plan and execute recurring production data releases across multiple product lines and database servers. • Collaborate with development, infrastructure, and operations teams to resolve database issues and support a smooth end-user experience.

• Operate and evolve multi-region CockroachDB clusters and PostgreSQL instances across production, staging, and development. • Investigate contention, serialization retries (SQLSTATE 40001), and range hotspots in the transaction paths behind bets, wagers, settlements, and payouts. • Diagnose leaseholder placement, monotonic-key write pressure, and cross-region latency that turn one query into several network round trips. • Trace a slow query to its execution plan, the plan to optimizer behavior, and the behavior to the schema or application call path that caused it. • Catch plan regressions after statistics changes, schema changes, data growth, or releases, then turn the fix into a safer rollout pattern. • Assess schema-change and backfill risk before it reaches large tables: lock behavior, retry pressure, capacity impact, and rollback path. • Plan capacity, scaling events, and version upgrades that customers don't feel. • Build database observability with Prometheus, Grafana, Mimir, Loki, and Snowflake: dashboards backed by real queries, alerting on leading indicators, and SLO tracking. • Connect database symptoms to application behavior and business events so alerts point at causes. • Join the on-call rota for the data layer, lead incident analysis when the database is part of the failure, and drive blameless postmortems toward durable fixes. • Instrument the system to surface degradation before it becomes an incident. • Build Go and Python tools that make incidents easier to understand: log collectors, explain-plan analyzers, migration checks, capacity models, and runbook generators. • Automate provisioning, configuration, backup, and recovery with Terraform and other infrastructure-as-code tools. • Work with platform engineering on CI/CD, deployment safety, and change management for database-touching services. • Use Claude Code, Codex, and similar harnesses in daily work to investigate incidents, generate probes, draft runbooks, and write tooling. • Keep the harness grounded in logs, traces, metrics, and source code, and verify its output against production facts before you ship it. • Implement and audit access controls, authentication, authorization, and encryption in transit and at rest. • Support data-protection, audit-logging, and retention requirements for a regulated gaming platform. • Build a database center of excellence: documentation, standards, and reusable patterns that other teams build against. • Mentor engineers on database fundamentals, distributed-systems behavior, and operational discipline. • Read CockroachDB and PostgreSQL internals when a problem needs a code-level answer, and bring what you learn back to the team.

• Designs and executes database upgrades from Oracle 19c to Oracle 23ai. • Maintains multiple database environments supporting ETL activities. • Sets up and maintains Grid Infrastructure, including ASM and Clusterware. • Implements high-availability solutions using GoldenGate and Active Data Guard. • Performs performance tuning to improve database processing efficiency. • Monitors database performance and recommends efficiency improvements. • Performs logical and physical data modeling and creates physical data models from logical data models. • Maintains data dictionary standards to ensure uniformity of definitions. • Executes backup, recovery, and disaster recovery procedures for hardware and software failures. • Ensures compliance with security vulnerability requirements and database security standards. • Assists in the installation, analysis, design, and implementation of databases. • Ensures database administration interfaces comply with EIR Accessibility standards.

Role Description The primary responsibility is to design and execute database upgrades from Oracle 19c to Oracle 23ai, and to maintain multiple environments that support ETL activities. - Enters codes to create production database. - Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. - Directs programmers and analysts to make changes to database management system. - Reviews and corrects programs. - Answers user questions. - Confers with coworkers to determine impact of database changes on other systems and staff cost for making changes to database. - Modifies database programs to increase processing performance (performance tuning). - Specializes in one or more types of database management systems. - Provides assistance in the planning, development, maintenance, and monitoring of integrated database systems. - Ensures that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment. - Evaluates users' requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance. - Coordinates the use of data to ensure data integrity and control redundancy. - Loads databases and reorganizes as needed. - Performs data modeling and prototyping. - Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models. - Performs security recovery procedures. - Determines and implements database search strategies and storage requirements. - Maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary. - Monitors database performance and recommends efficiency improvements. - Creates test database environment for applications section, including the creation of necessary libraries and procedures. - Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures. - Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems. - Assists with the installation of database software and with analyzing, designing, and implementing databases. - Assists in benchmarking and threshold testing of databases and with establishing and controlling necessary database security. - Assists in the selection of database management software. - Experience in computer systems analysis or computer programming work. - Knowledge of the principles, practices, and techniques of computer programming and systems design. - Knowledge of computer operations, systems, and procedures. - Knowledge of project control and cost estimating techniques. - Knowledge of computer programming languages, data processing flowcharting techniques, database structures and theories, and current database technologies. - Has working knowledge of EIR Accessibility standards and assistive technologies. - Ensures that user interfaces for database administration and inputting, viewing, outputting data (via reports) are compliant with accessibility standards. - Provides support to users in obtaining data/information when EIR Accessibility issues arise. Qualifications - 8 years of experience in infrastructure management with Oracle 19c version or higher. - 8 years of experience in Grid infrastructure (ASM, Clusterware). - 8 years of experience in high-availability (GoldenGate, Active Data Guard). - 8 years of experience in advanced scripting (Linux, SQL). - 4 years of preferred experience working with a public sector organization (Federal, State, or Local Government). - 2 years of preferred experience working with a hosting vendor. - 2 years of preferred experience working with Oracle PeopleSoft products. Requirements - Must have hands-on experience with Grid Infrastructure setup and maintenance. - Must have experience with security vulnerability compliance and performance tuning. - This position requires working outside standard business hours, depending on project activities. - This is a remote position; if it should become hybrid, in-office schedule will be negotiated. - Candidates for this position will be subject to a pre-employment security review to determine employment eligibility. Company Description