A.C. Coy

Oracle PL/SQL DBA

US-PA-Canonsburg
2 weeks ago
Job ID
2017-17420
# of Openings
1
Category
Information Technology

Overview

Our client is hiring a Database Administrator. This is a full-time direct hire position located in the South Hills area of Pittsburgh.  This position will design, install, monitor, maintain, and performance tune databases while ensuring high levels of data availability. This position ensures that data recovery, data integrity, and database performance, availability, and maintenance are met through applying best practices and monitoring of policies, standards, and system processes relating to database management. 

Responsibilities

  • Provide first-level application support:  Resolve problems and answer questions related to the database and layered products; contact vendor support when necessary; facilitate application development and customer problem resolution with optimum speed and efficiency.
  • Database performance monitoring and tuning:  Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
  • Maintain database backup/recovery environment:  Respond quickly to refresh data; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error.
  • Install and upgrade databases and related products:  Keep databases at current release and maintenance levels, install supporting products; provide current, stable database environments.
  • Provide database design:  Research and recommend optimal table and index design criteria balancing scalability, data integrity and maintainability; publish entity relationship and data flow diagrams, design standards and work with development staff; standardize environment and improve efficiency.

Qualifications

Experience/Minimum Requirements

  • At least three (3) years experience in the design, administration, programming, and support of Oracle databases in a distributed Unix (Solaris preferred) computing environment

Other Skills/Abilities

  • Experience administering Microsoft SQLServer databases is desirable
  • Thorough understanding of the Oracle database architecture and solid theoretical knowledge of relational database techniques
  • Thorough understanding of Oracle database performance tuning, design, security, scalability and industry best practices for administration
  • Experience in data extract, migration, queuing, and replication facilities
  • Proficient Oracle PL/SQL and SQL coding skills with particular attention given to detail and accuracy
  • Proficient Oracle SQL performance tuning and optimization skills
  • Experience with Unix scripting languages (e.g., Korn shell, Perl)

Education/Certifications

  • Bachelor’s degree in Computer Science, Engineering, or related discipline preferred; equivalent experience is acceptable
  • Oracle Professional Database Administrator certification is preferred

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed