Tata Consultancy Services
Role
Oracle Database Administrator
Location Bellevue, WA
Employment Type Full Time
Base Pay Range $90,000 - $115,000 per annum
Job Description
Must have 10+ years’ experience in administration of older and latest versions of Oracle Databases.
Experience in managing RDBMS 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.
Good knowledge of Agile framework.
Maintain inventory of 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.
Benefits Summary (TCS)
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.
Seniority Level Mid-Senior level
Job Function Information Technology
Industries IT Services and IT Consulting
Referrals increase your chances of interviewing at Tata Consultancy Services by 2x #J-18808-Ljbffr
Location Bellevue, WA
Employment Type Full Time
Base Pay Range $90,000 - $115,000 per annum
Job Description
Must have 10+ years’ experience in administration of older and latest versions of Oracle Databases.
Experience in managing RDBMS 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.
Good knowledge of Agile framework.
Maintain inventory of 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.
Benefits Summary (TCS)
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.
Seniority Level Mid-Senior level
Job Function Information Technology
Industries IT Services and IT Consulting
Referrals increase your chances of interviewing at Tata Consultancy Services by 2x #J-18808-Ljbffr