TATA Consulting Services-posted about 1 month ago
$90,000 - $115,000/Yr
Full-time • Mid Level
Bellevue, WA
5,001-10,000 employees
Professional, Scientific, and Technical Services

Must have 10+ years' experience in administration of older and latest versions of Oracle Databases. Experience in managing RDBMS(es) databases such Microsoft SQL Server, PostgreSQL etc… added advantage. Experience in managing Large transactional systems replication, clustering, partitioning, indexing strategies, execution plans and lock management. Cloud DB migration of (RDS/Aurora/Managed Oracle, DMS / GoldenGate or equivalent) hybrid replication patterns. SQL performance tuning, query profiling and capacity planning. Production troubleshooting in recovery situations. Automation-: scripting (Python, Bash), IaC for DB infra (Terraform modules for RDS), CI for DB migrations Draft clear documentation, runbook creation restoration communication Security-: data encryption, masking, audit/logging considerations. Good Knowledge of Agile framework.

  • Maintain Inventory all databases, baseline health, and produce an enterprise-level DB map.
  • Define and implement backup, recovery, point-in-time recovery (PITR), high-availability and disaster-recovery (DR) strategies; run and document restore drills.
  • Diagnose and resolve query performance issues, tune indexes, refactor problematic stored procedures and queries, and remove blocking/locking hotspots.
  • Plan and execute data migration strategies to cloud-managed DBs or hybrid patterns; produce migration runbooks and cutover plans.
  • Manage monitoring and alerting (query latency, replication lag, slow queries, deadlocks) and retention/archival strategies.
  • Define data access patterns, instrumentation requirements and help developers implement safe data access layers.
  • Own schema-change process and coordinate migrations with release windows, ensuring transactional integrity.
  • Produce runbooks, DR playbooks, and participate in on-call rotations for DB incidents.
  • Must have 10+ years' experience in administration of older and latest versions of Oracle Databases.
  • Experience in managing Large transactional systems replication, clustering, partitioning, indexing strategies, execution plans and lock management.
  • Cloud DB migration of (RDS/Aurora/Managed Oracle, DMS / GoldenGate or equivalent) hybrid replication patterns.
  • SQL performance tuning, query profiling and capacity planning.
  • Production troubleshooting in recovery situations.
  • Automation-: scripting (Python, Bash), IaC for DB infra (Terraform modules for RDS), CI for DB migrations
  • Draft clear documentation, runbook creation restoration communication
  • Security-: data encryption, masking, audit/logging considerations.
  • Good Knowledge of Agile framework.
  • Experience in managing RDBMS(es) databases such Microsoft SQL Server, PostgreSQL etc… added advantage.
  • Discretionary Annual Incentive.
  • Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
  • Family Support: Maternal & Parental Leaves.
  • Insurance Options: Auto & Home Insurance, Identity Theft Protection.
  • Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
  • Time Off: Vacation, Time Off, Sick Leave & Holidays.
  • Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service