Teradata/Oracle DBA
Location: Remote (San Francisco, CA; Arlington, VA; Denver, CO; Chicago, IL; Boston, MA; New York, NY; Houston, TX; Miami, FL; Los Angeles, CA; Seattle, WA; Dallas, TX; Minneapolis, MN; Birmingham, MI; Atlanta, GA; or Irvine, CA)
Duration: 6 10 months
Interview: In-person
Note:
Required Skills:
Strong Teradata DBA experience (Vantage, utilities, workload/performance tuning).
Strong Oracle DBA experience with Exadata and Oracle RAC administration.
Expertise in SQL tuning, indexing/partitioning, stats management, and large-volume DW optimization.
Hands-on backup/recovery, HA/DR architecture, and enterprise compliance support.
Scripting/automation proficiency (Shell, Python, SQL).
Strong Linux/Unix platform administration exposure.
Responsibilities:
Install, configure, patch, and upgrade Teradata, Oracle Exadata, and Oracle RAC across DEV/QA/UAT/PROD.
Administer and optimize large-scale data warehouse schemas (3NF, star/snowflake) for BI and analytics workloads.
Tune SQL and system performance using EXPLAIN plans, AWR/ASH, DBQL, stats strategy, indexing, and partitioning.
Manage Teradata workload governance (TASM/Viewpoint), spool/perm/temp, AMP skew, locking, and concurrency.
Manage Oracle RAC services, Clusterware, ASM, instance balancing, and high-availability failover operations.
Operate Exadata-specific features: Smart Scan, Storage Indexes, HCC, IORM, and cell/server performance tuning.
Build and maintain robust ETL/load frameworks (TPT/FastLoad/TPump, SQL*Loader, external tables) with strict load-window SLAs.
Own backup, recovery, and DR strategy (RTO/RPO), including restore drills, failover testing, and runbook validation.
Implement security controls: RBAC, profiles, encryption, LDAP/SSO integration, audit policies, and least-privilege access.
Automate DBA tasks (health checks, stats jobs, user provisioning, housekeeping) via Shell/Python/SQL scripting.
Support release/change management with pre/post deployment validation, rollback plans, and zero/low outage execution.
Provide L2/L3 production support, incident RCA, trend reporting, and preventive action planning.
Create operational documentation (SOPs, architecture, recovery guides) and train junior DBAs/engineers.
Partner with ETL, BI, infra, and security teams to resolve integration/performance issues and maintain SLA compliance.
...breach response engagements following incident containment and forensic investigation. Conduct assessment and analysis of impacted... ...role, you must have ~ A bachelors or masters degree in computer science, information systems, Engineering, cybersecurity or a...
...affordable, convenient way so you can do all the things you love. Job description: NuSpine is currently seeking an associate chiropractor Scottsdale, AZ. In our modern facility, chiropractors will provide professional chiropractic oversight and direct patient care....
...Serving as a trusted financial advisor to the CEO and executive leadership team, the full-time Strategic Financial Analyst will provide analytical rigor and strategic insight to drive corporate strategy, M&A, pricing, and R&D investment initiatives in a dynamic, private...
...Nachhilfeunterricht is seeking enthusiastic individuals for the role of Online Primary School Tutor. This part-time position allows you to work from home, providing private lessons that contribute to the academic achievements of primary-level students. No prior experience...
...undergraduate and postgraduate training is essential for this role. Experience with EPIC electronic medical records is preferred. Cytotechnologists will be required to wear designated scrubs. Relevant skills include expertise in various specimen types and procedures such...