110712-03 TWSS - Oracle DBA - Development Support @ Pleasanton, CA PDF  ICON_SEP Print ICON_SEP  Email
Written by   

Dear partner,

Please go through the below requirement and send me the suitable profiles with best rate and contact details to -- CLOAKING

Submit Resume
First Name (*)
Invalid Input
Last Name
Invalid Input
Email (*)
Invalid Input
Job Position (*)
Invalid Input
Contact Number (*)
Invalid Input
Submit Resume (*)
Invalid Input

Job Title: Oracle DBA - Development Support


Location: Pleasanton, CA 

Duration: 6 – 12 Months

Rate: Open

Required Skills:

  •  Expert hand-on experience in data modeling with focus on developing database logical and physical models for large scale, highly available and mission critical application systems.
  •  Experience designing and implementing the database components of software applications, and understanding of entire application development life cycle.
  •  Experience with complex SQL and PL/SQL programming and optimization.
  •  Experience in database administration with Oracle including capacity planning, load balancing, performance tuning, high availability and multi-sites Disaster Recovery deployment on complex database environments; Oracle 11G and RAC implementation experience is desired.
  •  Experience in data modeling tools such as ERwin.
  •  Proficiency with UNIX (HP-UX) and Linux, shell scripting and crons are desired.
  •  Experience with Java or .NET development is plus.
  •  Good writing skills to provide documentation for DBA and other teams.
  •  Communicate and prepare management reports to IT management and end users.

Roles & Responsibilities:

  •  Provide database engineering support to the entire system development lifecycle of all IT projects, including review/approval of database schema changes, stored procedures, SQLs/PL/SQL and other database related objects.
  •  Work with development team to develop, troubleshoot and optimize SQLs and PL/SQL stored procedures and packages.
  •  Work with data modelers to design and develop conceptual data models, logical data models and implement them in physical database schemas using ERwin data modeling tool.
  •  Establish database design conventions in best practice, and assure that design conventions and standards are complied and documented fully.
  •  Support database change management and deployment processes.
  •  Support the Oracle non-production and production databases administration as needed, including daily operations, backup and recovery, performance tuning, and after hours on-call support.
  •  Work with Oracle Support to resolve issues on the Oracle databases and Oracle tools used by the development teams.
  •  Develop and implement ORACLE Stored Procedure verification tools that assist developers in troubleshooting and performance improvement
  •  Develop and implement procedures for the synchronization between different database environments.
  •  Develop and implement proactive tools for ORACLE environments (such as lock escalation report).
  •  Provide advice/recommendations on database architecture, design and implementation.
  •  Provide training, documentation for knowledge transfer to other database team members, and communicate both to non-technical users and to technical personnel on Database team and Applications teams.
  •  Provide Internet Web and Document Support.
  •  Provide technical coverage for all ORACLE databases when the primary DBA unavailable including after hours support on weekends.


Mike Smith | Director - Resources 

Thoughtwave Software & Solutions, Inc.

E-mail | Web URL| Linked-in 

Ph: 630-448-6681 Ext # 112 | Fax: 630-689-5746