Novato, CA
|
Database Administrator (DBA)
|
Contract
|
$52 - $65 (hourly estimate)
{"JobID":412278,"JobType":["Contract"],"EmployerID":null,"Location":{"Latitude":-122.513909090909,"Longitude":38.0778181818182,"Distance":null},"State":"California","Zip":"94949","ReferenceID":"SFR-777229","PostedDate":"\/Date(1745000154000)\/","Description":"1. Database Design, Tuning \u0026 Scaling Architect and optimize complex PostgreSQL and MySQL database clusters to handlehigh-velocity OLTP workloads. Implement horizontal scaling strategies (e.g., sharding, logical partitioning) to supportincreased load. Tune vertical scaling parameters such as connection pools, caching layers, buffer sizes,and memory allocation. Continuously improve schema design and normalization strategies for performance andflexibility.2. Query Optimization \u0026 Workload Profiling Analyze query patterns, slow query logs, and application metrics. Identify long-running or inefficient queries and collaborate with developers to refactorthem. Implement advanced indexing strategies (partial indexes, BRIN, GIN, etc.) to reducequery latency. Conduct proactive workload profiling to prevent performance degradation at scale. Thisincludes regularly benchmarking representative workloads, identifying emerging hotspotsor contention areas, analyzing I/O and CPU usage under various load patterns, andforecasting capacity requirements. The consultant will develop profiling automationscripts, simulate growth scenarios, and implement preemptive optimizations to safeguardagainst latency spikes and throughput bottlenecks as the player base or featurecomplexity grows.3. Infrastructure \u0026 Platform Engineering Manage and optimize databases on AWS (RDS, Aurora) Google Cloud Platform(CloudSQL) and MySQL/Postgres on Data center platforms Design multi-region, fault-tolerant, and geo-replicated systems to support global gameavailability. Support both cloud-native and hybrid infrastructure environments, includingKubernetes-based deployments. Contribute to IaC tooling (Terraform, Ansible) to automate DB provisioning, scaling, andconfiguration.4. High Availability, Replication, and DR Design and implement high availability (HA) setups using streaming replication, GTID,failover nodes, etc. Ensure low-latency and durable replication strategies across regions and cloudproviders. Define and test comprehensive backup/recovery and disaster recovery (DR)procedures. Minimize RTO/RPO for game-critical workloads.5. Monitoring, Observability \u0026 Incident Response Build and maintain observability dashboards using Datadog, Grafana, CloudWatch,and native DB tools. Set up and fine-tune alerts for key metrics (e.g., replication lag, query timeouts, cache hitratios). Participate in 24/7 on-call rotations, triaging incidents and driving resolution. Perform root cause analysis (RCA) and contribute to post-mortems for high-impactissues.6. Team Collaboration \u0026 CI/CD Integration Work closely with DevOps, backend engineering, and SRE teams to ensure seamlessintegration into CI/CD pipelines. Provide tooling and standards for DB migrations, version control, and rollback safety. Mentor engineers on DB best practices, data modeling, and query tuningWe are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com. The EEOC \"Know Your Rights\" Poster is available here. To learn more about how we collect, keep, and process your private information, please review Insight Global\u0027s Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .","Title":"EU - Lead DBA","City":"Novato","ExpirationDate":null,"PriorityOrder":0,"Requirements":"Required Skills \u0026 Experience 7+ years managing PostgreSQL and MySQL in production-grade environments. Hands-on experience supporting OLTP systems with millions of concurrent requests. Mastery in schema design, performance tuning, and deep query analysis. Proficiency with AWS (RDS, Aurora), GCP (CloudSQL), and hybrid deployments. Solid scripting knowledge (Bash, Python) for DB automation and incident tooling. Experience with observability platforms and instrumentation. Ability to handle incidents calmly under pressure and provide rapid resolution. Knowledge of multi-region replication, HA, and DR strategies.","Skills":"Prior experience in gaming infrastructure or other latency-sensitive, high-throughputdomains. This includes working on systems such as online multiplayer games, financialtrading engines, streaming media platforms, or real-time logistics and telemetry services.Such environments require exceptional response times, resilience under concurrentload, strict consistency models, and advanced troubleshooting practices to meetdemanding SLAs. Familiarity with Kubernetes, containers, and DB orchestration in microservicesenvironments. Exposure to infrastructure-as-code tools (Terraform, Ansible, Pulumi, Puppet). Understanding of security, RBAC, AD, and compliance in cloud-hosted DBs","Industry":"Database Administrator (DBA)","Country":"US","Division":"IT","Office":null,"IsRemoteJob":true,"IsInternalJob":false,"ExtraValues":null,"__RecordIndex":0,"__OrdinalPosition":0,"__Timestamp":0,"Status":null,"ApplicantCount":0,"SubmittalCount":0,"ApplicationToHireRatio":0,"JobDuration":null,"SalaryHigh":65.0000,"SalaryLow":52.0000,"PayRateOvertime":0,"PayRateStraight":0,"Filled":0,"RemainingOpenings":0,"TotalOpenings":0,"Visa":null,"ClearanceType":null,"IsClearanceRequired":false,"IsHealthcare":false,"IsRemote":false,"EndClient":null,"JobCreatedDate":"\/Date(-62135578800000)\/","JobModifiedDate":"\/Date(-62135578800000)\/"}
1. Database Design, Tuning & Scaling Architect and optimize complex PostgreSQL and MySQL database clusters to handlehigh-velocity OLTP workloads. Implement horizontal scaling strategies (e.g.,... sharding, logical partitioning) to supportincreased load. Tune vertical scaling parameters such as connection pools, caching layers, buffer sizes,and memory allocation. Continuously improve schema design and normalization strategies for performance andflexibility.2. Query Optimization & Workload Profiling Analyze query patterns, slow query logs, and application metrics. Identify long-running or inefficient queries and collaborate with developers to refactorthem. Implement advanced indexing strategies (partial indexes, BRIN, GIN, etc.) to reducequery latency. Conduct proactive workload profiling to prevent performance degradation at scale. Thisincludes regularly benchmarking representative workloads, identifying emerging hotspotsor contention areas, analyzing I/O and CPU usage under various load patterns, andforecasting capacity requirements. The consultant will develop profiling automationscripts, simulate growth scenarios, and implement preemptive optimizations to safeguardagainst latency spikes and throughput bottlenecks as the player base or featurecomplexity grows.3. Infrastructure & Platform Engineering Manage and optimize databases on AWS (RDS, Aurora) Google Cloud Platform(CloudSQL) and MySQL/Postgres on Data center platforms Design multi-region, fault-tolerant, and geo-replicated systems to support global gameavailability. Support both cloud-native and hybrid infrastructure environments, includingKubernetes-based deployments. Contribute to IaC tooling (Terraform, Ansible) to automate DB provisioning, scaling, andconfiguration.4. High Availability, Replication, and DR Design and implement high availability (HA) setups using streaming replication, GTID,failover nodes, etc. Ensure low-latency and durable replication strategies across regions and cloudproviders. Define and test comprehensive backup/recovery and disaster recovery (DR)procedures. Minimize RTO/RPO for game-critical workloads.5. Monitoring, Observability & Incident Response Build and maintain observability dashboards using Datadog, Grafana, CloudWatch,and native DB tools. Set up and fine-tune alerts for key metrics (e.g., replication lag, query timeouts, cache hitratios). Participate in 24/7 on-call rotations, triaging incidents and driving resolution. Perform root cause analysis (RCA) and contribute to post-mortems for high-impactissues.6. Team Collaboration & CI/CD Integration Work closely with DevOps, backend engineering, and SRE teams to ensure seamlessintegration into CI/CD pipelines. Provide tooling and standards for DB migrations, version control, and rollback safety. Mentor engineers on DB best practices, data modeling, and query tuningWe are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com. The EEOC "Know Your Rights" Poster is available here. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .