Showing posts with label PL/SQL. Show all posts
Showing posts with label PL/SQL. Show all posts

Thursday, 22 October 2015

Job Posting - Database Administrator

Job Title
Database Administrator

Positions Available
2

Company Profile


Education
Bachelor's degree in Computer Science or other related fields required.
An advanced degree preferred.
Relevant Certification in Database Administration preferred.

Job Requirements
Hands on Oracle database administrator with 3 years of experience installing, configuring, managing and troubleshooting oracle 9i, 10g, and 11g database software.
Requires extensive experience with Oracle RAC and multi-application environments. Requires solid understanding of server capacity planning, performance analysis and tuning, and user management. Must work closely with the server and storage engineers to design and implement high-performance and highly available environments.
Must work closely with applications in order to understand their specific requirements and guide them through the application lifecycle.
Applicant must have Architect skills – (i.e., define architecture: concepts, design, build, detailed documentation before, during and after task effort).
Applicant must be able to understand the various technology areas affected and work with those technical SMEs in building robust, stable systems
Applicant must have extensive knowledge of and experience with the span of Oracle products (i.e., Oracle Data Base, OID, Grid Control, Spatial, Partitioning, Application Server, and Data Guard). 
Applicant provides basic technical writing to describe daily operations (template provided) and security controls.
Applicant will be working in a Team environment and must have excellent communication skills, both written and verbal.
Require experience working with servers (Linux/Unix and Windows 2008).
Expert knowledge in shell scripting required.
Ability and willingness to learn new systems required.

Required Documents
Resume 
Cover Letter 

Work Location
Lagos, Nigeria

Work Schedule
Full-Time 

Posting Date
22-10-2015 


Interested applicants should submit resume to kenny_csc@yahoo.com

Wednesday, 21 October 2015

LiveSQL - Write SQL Online

My fellow DBAs, though this will appeal mostly our little brothers - the Database Developers... I think it's still worth sharing because we've all at some point imagined being able to write SQL scripts without having a database on your PC or Server... well Oracle has given us LiveSQL via livesql.oracle.com

The site went live one week ago on 14th October. LiveSQL is a free online tool for you to learn and code SQL on an Oracle Database. If you would like to just code away right away just click "Start Coding Now" below. You will need to login or create a free Oracle account, accept the terms and you are ready to go. 



Features
  • SQL worksheet with access to an Oracle database schema
  • Ability to save and share SQL script
  • Schema browser to view and extend database objects
  • Interactive educational tutorials
  • Customized data access examples for PL/SQL, Java, PHP, C

In the screenshot below, I logged in, clicked on Start Coding Now and wrote my first piece of SQL on LiveSQL



In addition to being able to write and test scripts on the go with LiveSQL, you also have access to various tutorials to learn SQL and other features within the Oracle Database, upload SQL scripts from your computer and share your SQL sessions with other Oracle SQL enthusiasts. 



Visit livesql.oracle.com today to script, test, learn and share SQL.


Hope this helps!

Kehinde.