1

Temporary Oracle Performance Tuning Jobs in Arizona

... Oracle, Amazon Aurora PostgreSQL, and Amazon RDS for SQL Server. You will own provisioning ... Performance Monitoring and Tuning: Use CloudWatch, Performance Insights, and Enhanced Monitoring to ...

... Oracle, Amazon Aurora PostgreSQL, and Amazon RDS for SQL Server. You will own provisioning ... Performance Monitoring and Tuning: Use CloudWatch, Performance Insights, and Enhanced Monitoring to ...

SQL Database Admin

Scottsdale, AZ

$50.25 - $63/hr

Oracle (12c or higher), or MySQL or other RDBMS (Required) Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals Database architectural ...

SQL Database Admin

Scottsdale, AZ · On-site

$50.25 - $63/hr

Oracle (12c or higher), or MySQL or other RDBMS (Required) Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals Database architectural ...

SQL Database Admin

Scottsdale, AZ · On-site

$50.25 - $63/hr

Oracle (12c or higher), or MySQL or other RDBMS (Required) • Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals • Database ...

Company Description Exp - 7+ Yrs Candidate must have detailed knowledge of Oracle products OIM with ... with performance tuning. • Strong knowledgeable working on connectors and developing connectors ...

Data Architect

Phoenix, AZ · On-site

$62 - $79.75/hr

Databases: SQL, Oracle , Oracle Fusion etc * Collaboration & Communication: Act as a liaison ... Hands-on experience with data architecture, performance tuning, and SQL scripting. * Strong ...

next page

Showing results 1-20

Temporary Oracle Performance Tuning information

What is the difference between Temporary Oracle Performance Tuning vs Oracle Database Administrator?

AspectTemporary Oracle Performance TuningOracle Database Administrator
CertificationsOracle Certified Associate (OCA), Performance Tuning certificationsOracle Certified Professional (OCP), Database Administration certifications
Work EnvironmentProject-based, focused on performance optimization tasksOngoing management of database systems, including backups, security, and maintenance
ResponsibilitiesAnalyzing and improving database performance temporarilyFull lifecycle database management and troubleshooting

Temporary Oracle Performance Tuning focuses on short-term performance improvements, while an Oracle Database Administrator handles comprehensive, ongoing database management. Both roles require similar certifications but differ in scope and duration of tasks.

Is Oracle DBA a stressful job?

Oracle DBA roles can be stressful due to the responsibility of maintaining database performance, security, and uptime, especially during critical updates or troubleshooting. The job often requires working under tight deadlines, handling urgent issues, and staying current with evolving technologies, which can contribute to stress levels.

What is P1, P2, P3 in Oracle?

In Oracle performance tuning, P1, P2, and P3 refer to the priority levels assigned to wait events or sessions, with P1 being the highest priority and P3 the lowest. These levels help database administrators identify and address critical performance issues efficiently. Understanding these priorities is essential for effective performance troubleshooting and tuning in Oracle environments.

Is Oracle DBA still in demand?

Oracle Database Administrators (DBAs) remain in demand due to the continued reliance on Oracle databases in enterprise environments. Skills in performance tuning, backup and recovery, and familiarity with tools like Oracle Enterprise Manager are valuable, and certifications such as Oracle Certified Professional can enhance job prospects.

Is Oracle 12c still supported?

Oracle 12c mainstream support ended in July 2018, with extended support available until July 2023. As a Temporary Oracle Performance Tuning professional, staying current with supported Oracle versions and certifications is important for optimal performance tuning and security compliance.
What are popular job titles related to Temporary Oracle Performance Tuning jobs in Arizona? For Temporary Oracle Performance Tuning jobs in Arizona, the most frequently searched job titles are:
What job categories do people searching Temporary Oracle Performance Tuning jobs in Arizona look for? The top searched job categories for Temporary Oracle Performance Tuning jobs in Arizona are:
What cities in Arizona are hiring for Temporary Oracle Performance Tuning jobs? Cities in Arizona with the most Temporary Oracle Performance Tuning job openings:

Senior Oracle DBA

Ryde Technologies, LLC

Phoenix, AZ

Full-time

Posted 24 days ago


Job description

About the Role

As a Senior DBA, you will play a key role in administering and optimizing relational databases in AWS, with primary focus on Amazon RDS for Oracle, Amazon Aurora PostgreSQL, and Amazon RDS for SQL Server. You will own provisioning, configuration, upgrades, performance, backup and recovery, security, and day-to-day operations. You will also provide leadership and guidance to a team of DBAs and developers, establish cloud database standards and runbooks, and automate health checks and reporting to ensure high performance, availability, and reliability.

Responsibilities

  • As a Senior DBA, you will be responsible for administering Amazon RDS databases in AWS. You will drive automation, operational excellence, and proactive monitoring through repeatable runbooks and health check reporting.
  • AWS RDS and Aurora Provisioning: Design, deploy, and configure RDS DB instances and Aurora clusters, including instance and storage sizing, subnet and parameter groups, option groups, maintenance windows, Multi-AZ, and read replicas.
  • High Availability and Disaster Recovery: Implement and validate HA and DR strategies, including Multi-AZ, failover configuration, cross-region replication where applicable, and disaster recovery runbooks with defined RTO and RPO.
  • Backup, Restore, and Environment Refresh: Manage automated backups, manual snapshots, retention policies, and cross-region snapshot copies. Perform and document regular restore tests and support Dev, QA, and UAT refreshes using approved methods.
  • Performance Monitoring and Tuning: Use CloudWatch, Performance Insights, and Enhanced Monitoring to diagnose performance issues, analyze wait events and query behavior, and implement tuning actions across Oracle, PostgreSQL, and SQL Server.
  • Security and Compliance: Enforce least-privilege access using IAM and database roles, network isolation using VPC and security groups, encryption at rest using KMS and encryption in transit using TLS. Configure and retain audit and engine logs in CloudWatch Logs as needed.
  • Patching and Upgrades: Plan and execute minor and major engine upgrades with minimal downtime. Coordinate testing, apply patching within defined maintenance windows, and use blue/green or staged deployment patterns where supported.
  • Automation and Infrastructure as Code: Automate routine tasks using scripting and AWS CLI or SDKs. Partner with DevOps to manage RDS and Aurora changes using infrastructure as code (for example, Terraform or CloudFormation) and integrate database checks into CI/CD pipelines.
  • Migration and Data Movement: Support database migrations and upgrades using AWS DMS and AWS Schema Conversion Tool when applicable, plus native utilities such as Oracle Data Pump, pg_dump and pg_restore, and SQL Server native backup and restore to S3.
  • Engine-Specific Administration: Implement maintenance routines appropriate for each engine, such as Oracle statistics and maintenance windows, Aurora PostgreSQL vacuum and extension management, and SQL Server index and statistics maintenance and SQL Agent job scheduling, within the capabilities of RDS and Aurora.
  • Team Oversight: Provide technical leadership to the DBA team, planning and delegating tasks effectively.
  • Mentorship: Guide and mentor mid-level DBAs, fostering their professional development and enhancing team capabilities.
  • Collaboration: Be the liaison between the database team and other technical and business units, ensuring alignment of database services with organizational goals.
  • Collaboration and Support: Work closely with developers, platform teams, and system administrators to optimize database design, resolve issues, and ensure database systems meet business needs.
  • Documentation and Best Practices: Document all database procedures in internal Wiki, including health check reporting, automation scripts, RDS and Aurora deployment standards, and operational runbooks, to ensure consistency and adherence to best practices.

Qualifications

  • Bachelor's degree in computer science, Information Technology, or a related field
  • AWS Certified Database - Specialty, Oracle Certified Professional (OCP), and Microsoft SQL Server certification or equivalent experience

Required Skills

  • 5+ years of hands-on database administration experience in AWS, including Amazon RDS and Amazon Aurora.
  • Strong experience administering Oracle on Amazon RDS, including backup and recovery workflows, parameter and option group management, and performance troubleshooting.
  • Strong experience administering Aurora PostgreSQL, including cluster design, failover behavior, reader scaling, parameter tuning, vacuum strategy, and extension management.
  • Strong experience administering SQL Server on Amazon RDS, including index and statistics maintenance, SQL Agent scheduling, and native backup and restore workflows.
  • Deep understanding of AWS networking and security for databases, including VPC design, security groups, IAM, KMS encryption, and TLS connectivity.
  • Proficiency with monitoring and diagnostics tools such as CloudWatch, Performance Insights, and engine logs for root cause analysis.
  • Scripting and automation skills using AWS CLI or SDKs plus languages such as Python, PowerShell, or Bash.
  • Experience with database migrations and modernization using AWS DMS and AWS Schema Conversion Tool, plus native engine utilities.
  • Demonstrated ability to lead a team, mentor junior staff, and collaborate across departments.
  • Excellent communication, documentation, and problem-solving skills.

Preferred Skills

  • Results - Consistently delivers required business results; sets and achieves achievable, yet aggressive, goals; consistently complies with quality, service and productivity standards and meets deadlines; maintains focus on company goals.
  • Technical/Functional Expertise - Demonstrates and effectively applies depth and breadth of knowledge and skill in a technical or functional area.
  • Professional Development - Demonstrates a commitment to professional development by proactively seeking opportunities to develop new capabilities, skills, and knowledge; acquires the skills needed to continually enhance his/her contribution to the company and to his/her respective profession.
  • Communication - Respectfully listens to others to gain a full understanding of issues; comprehends written material; presents information in a clear and concise manner orally and in writing to ensure others understand his/her ideas; appropriately adapts his/her message, style, and tone to accommodate a variety of audiences.
  • Problem Solving - Analyzes problems by evaluating available information and resources; develops effective, viable solutions to problems.

EEO Compliance:

Ryde is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Ryde will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.