Oracle Database Administrator / Reports Developer

American CyberSystems
Gold River, United States of America
11 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 121K

Job location

Gold River, United States of America

Tech stack

Amazon Web Services (AWS)
Databases
Relational Databases
Database Security
Disaster Recovery
PostgreSQL
MySQL
Oracle
Oracle Applications
Performance Tuning
Systems Development Life Cycle
Query Optimization
Release Management
Software Engineering
PL-SQL
SQL Databases
Virtualization Technology
Sql Optimization
Amazon Web Services (AWS)
Database Rules and Triggers
Sql Tuning

Job description

  • Collaborate actively with developers, architects, and business analysts.
  • Database Knowledge: Knowledge on Delphix
  • Masking process Knowledge on Delphix Virtualization
  • Proficiency in one or more RDBMS platforms: Oracle, PostgreSQL, MySQL (AWS Aurora).
  • Understanding of database architecture, schema design, and data modeling. Advanced SQL, including query optimization and performance tuning.
  • Experience with PL/SQL, PG-PSQL, or appropriate procedural languages. Knowledge of indexes, partitions, triggers, and database constraints.
  • Monitoring & Troubleshooting Using OEM, AWS Cloud watch, performance insights monitoring tools to track performance and availability.
  • Execution and tuning of database backup/restore and disaster recovery strategies.
  • Maintain and tune application databases for optimal performance.
  • Support software development lifecycle (SDLC) with schema, scripts, and release management.
  • Troubleshoot and resolve application-data related issues. Ensure database reliability, backup, and security.
  • Diagnostics and resolution of database-related incidents in production or development environments.
  • Security and Compliance Managing database security (user roles, access control, encryption).
  • Supporting audits, compliance checks, and adhering to regulatory standards.

Requirements

  • Minimum 5 years' experience as an Oracle DBA.
  • Designing and maintaining schemas based on business and application requirements.
  • Supporting application releases: managing schema changes, data migrations
  • Experience in Performance Tuning, Aurora Postgres, Aurora MySQL, Delphix Masking, Delphix Virtualization
  • Troubleshooting SQL performance issues related to application code.
  • Collaborating with developers to optimize SQL queries and procedures. Ensuring application/database compatibility during upgrades or new releases
  • Experience with CI/CD pipelines for database deployments.

Benefits & conditions

Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).

About the company

ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields. Recent Recognitions: * Named One of America's Best Employers for New Grads by Forbes (2024 * Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024-2025) * One of the Largest IT Staffing Firms in the US - Ranked #3 by Staffing Industry Analysts (SIA, 2024) * One of the Largest Staffing Firms in the US - Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics) * Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023) * One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024) * AWS Advanced Tier Services Partner with 100+ certifications, employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b. The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Innova Solutions and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - innovasolutions.

Apply for this position