Oracle DBA

Greater Boston area, Massachusetts

Posted: 09/22/19 Category: Database/Data Warehousing Job Number: 8219

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


PURPOSE AND SCOPE:

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.

 

PRINCIPAL RESPONSIBILITIES AND DUTIES:
  • 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

 

EDUCATION:

Bachelor’ s degree in MIS, Computer Science or related field required or equivalent experience in lieu of.
  EXPERIENCE AND REQUIRED SKILLS:
  • 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

Tiffany Louie
Technical Recruiter

Contact Tiffany today to discuss this opportunity.

Send an email reminder to:

Share This Job:

Related Jobs:

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