회사에서 Oracle DBA에게 요구하는 기술들

아래 내용은 오라클 관련 Blog에서 DBA를 구한다고 올라온 Post 입니다. 

요즘 가끔 네이버지식에 들어가서 질문에 답을 달고 있는데요, 

DBA라는 직업에 대한 이야기들이 많이 나오더군요. 

그래서 도움이 되지 않을까 해서 한번 올려봅니다. 

DBA를 꿈꾸시는 분들은 참고하세요 ~

(사실 이정도 하시는 분들 찾긴 힘들죠. 저도 마찬가지지만.. ^^;) 

혹시 아래 글 보고 여기 취직해보고 싶으신 분은 아래 링크로.. 

http://www.oraclenerd.com/2010/04/job-dba-in-philadelphia.html

Job Summary: Oracle Database Administrator (DBA)

The Oracle DBA will be supporting multiple environments from Development, Quality Assurance (QA) and Production databases running Oracle 10g in a clustered environment. Experience working in a production UNIX/Linux environment is required for this position. Experience in performance tuning, change implementation, backup and recovery, monitoring and installation are key requirements. Candidate will also be expected to provide application-level support for our in house J2EE applications running on Tomcat and OC4J. Ideal candidate will be a self-starter and a team player with a strong organization, process and communication skills. This is a permanent position, not a contract. No 3rd parties please. No H1's or L1's.

Job Description

Installation and patching of Oracle RDBMS on Linux – adhering to standard operating procedures

Performance tuning and administrative functions on Oracle production databases

Enforce best practices in all areas of database administration and architecture including

Review and implement database changes

Participate in 24x7 on-call rotation for production databases

Ensure backup and recovery of all Oracle data using RMAN, Standby Database and import/export

Develop scripts for reporting, data manipulation and automation of daily tasks

Provide support to Development and QA teams on applications/database issues

Engage and support Software Developers during the SDLC

Administration and support of Oracle’s Business Intelligence, Informatica, Tomcat and OC4J applications

Develop and document formal processes and procedures

Job Requirements

Computer Science, or related science/Engineering degree (B.S. or equivalent).

At least 3 to 5 years production Oracle DBA experience in a Linux/UNIX environment

At least 2 years of experience with Oracle Real Time Application Clusters 10g or 11g with ASM or NFS.

UNIX/Linux system knowledge sufficient to configure, maintain and monitor Oracle instance(s)

Experience with OLTP, OLAP, DW, and ETL concepts

Experience with indexing strategies and reading explain plans

Experience with parallel processing, and partitioning

Experience with Oracle Data Guard

Experience with Oracle Grid Control, especially monitoring and alerting and managing multiple databases

Database performance tuning ability is required

Familiarity with the Full Software Development Lifecycle (SDLC)

Demonstrated knowledge of Oracle and Oracle tools to support database environments

Demonstrated knowledge of shell environments (C, Korn, KSH, Bourne)

Demonstrated proficiency of SQL and PL/SQL

Familiarity with HTML/ JAVA /Java scripts / JSP / PERL is a plus

Familiarity with Oracle’s Business Intelligence suite, Informatica and J2EE administration is a plus.

Will require after-hours or occasional weekend work to make changes during outage windows.

Excellent oral and written skills

* 여기저기서 좋다는 책 몇권 추천합니다. 고수가 되는 그날까지.. 파이팅!!