Oracle Performance Engineer

Greater Boston area, Massachusetts

Posted: 01/26/20 Category: Database/Data Warehousing Job Number: 8219

Job Description

Position Title: Oracle Performance Engineer
Job Location: Greater Boston area
Interview Expectations: onsite
Local Candidate: preferred
Required Skill Sets: performance tuning


Responsible for administration, maintenance and support of existing enterprise production database environments supporting mission critical systems. Protect integrity and access to Corporate data.    Provide technical leadership to peer and junior personnel.

  • Work on a large-scale enterprise data warehouse running on Exadata
  • Use OEM/SQL Monitor to identify system bottlenecks and SQL tuning opportunities
  • Work with database developers on performance and tuning of SQL
  • Interpret execution plans – cardinality estimates and join methods
  • Understand optimizer choices, and how to influence it
  • Implement plan stability using SQL Profiles and SPM
  • Understand how to leverage Smart Scans, HCC, partitioning, RAC, Resource Governor

  • Troubleshoot SQL performance issues, identify bottlenecks, and recommend solutions at the server level, database level, and SQL level.
  • Responsible for administration, maintenance and availability of Oracle databases.
  • Ensure backup and recoverability of all databases.
  • Define and configure appropriate level of monitoring and alerting.
  • Work with database vendor as needed, to drive solutions to various bugs, performance issues, outages
  • Work collaboratively with architects to identify, troubleshoot, review and resolve performance issues
  • Manage security by configuring users, groups and permissions
  • Ensure data security.  Define and implement database access control policies and procedures, complying with SOX and HIPAA requirements.
  • Works with Data Architect on long term strategy to ensure integrated database systems.  Advise on physical data model and implement changes. 
  • Responsible for capacity planning, working closely with Infrastructure group to allocate appropriate database resources on servers.
  • Contribute to the ongoing development of technology and production processes company-wide.  Keep abreast of new design tools, hardware, software, and technology and make recommendations for future deployment.
  • Provide technical leadership.  Mentor junior DBA’ s on the team on database technical details.  Provide technical assistance to developers.
  • Create and maintain quality control and auditing of databases.
  • Develop and adhere to common database standards and procedures within a production operations unit.  Maintain documentation related to database platforms, guidelines, methods and standards. 
  • Coordinate with technical project managers, developers and other team members to coordinate database requirements across projects.
  • Triage/track outstanding issues, providing solutions to resolve defects and issues.
  • Develop and adhere to common database standards and procedures within a production operations unit.  Maintain documentation related to database platforms, guidelines, methods and standards. 
  • Interact with business users verifying or helping to verify data integrity.
  • Administer, maintain and support QA and development environments.
  • Responsible for administration, analysis, design, and creation of new databases.
  • Document and improve existing processes related to operations and daily work.
  • Other duties as assigned



Bachelor’ s degree in MIS, Computer Science or related field required or equivalent experience in lieu of.
  • 8+ years of experience in IT
  • 6+ years of DBA experience including 3+ years with Oracle
  • Strong problem solving skills in virtualized database environments
  • Ability to be proactive and work well under pressure, multi-task
  • Must have shell scripting experience


  Oracle DBA skills:
  • Experience working in a large data warehouse environment
  • Must know how to influence optimizer to make sure large complex query joins run optimally
  • Demonstrated ability using OEM, ADDM, AWR, SQL Monitor, SQL Tuning advisor
  • Experienced with Data Pump, SQL Loader, RMAN, PL/SQL, and Unix shell scripting
  • Installation, configuration, maintenance and performance tuning of Oracle database
  • Oracle certification is highly desired

Meet Your Recruiter

Nick DelSole
Technical Recruiter

Contact Nick today to learn more about this great opportunity!

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.