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.
...Aesthetic Junior Nurse (RN) Skinfinity Spa Louisville, KY In-Person Role | Independent Contractor (1099)$21$25 per hour (RN) | APRN compensation based on experience Position Overview Skinfinity Spa is expanding our clinical team in Louisville and is looking...
Job Details Job Title: Jr. Java Developer Client: Korean IT consulting company Working Location: Plano, Tx Working style: onsite Employment Type : 1-Year contract/W2 Salary: $70K~72K annually (DOE) Benefit: 401K match and Insurance Visa Support...
...Who We Are Porter Logistics is a fast-growing third-party logistics (3PL) provider redefining modern warehousing and fulfillment.... ...careers, not just fill roles. Many of our leaders started in entry-level positions and grew with us. This is a tight-knit team where...
...Tableau, QlikView, Quality Center, Data Strategies, Data Delivery, Hadoop) in Charlotte, NCData Delivery, data quality, Data Quality... ...in building ETL based testing frameworks with Informatica and developing E2E data strategies-Experience or a high level understanding...
...0 buses and transports over 140,000 students across 30 school districts in Connecticut and Rhode Island. We are proud of our safety first culture, family oriented environment, modern shops, and long standing commitment to promoting from within.We are hiring a full-time...