Jack Douglas

Maidenhead, United Kingdom

douglastechnology.co.uk

Age: 38

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.

I'm happy to consider offers of part-time or short-term work either in the London/M4 area or working remotely.

You can view my CV online

top accounts reputation activity favorites subscriptions

Can we add 'asked', 'answered', 'edited' text to each question featured on the front page?

feature-request user-interface bump active asked Aug 27 '12 at 11:11

meta.stackoverflow.com

39 votes

Can we exempt downvoted accepted answers from getting the top spot?

feature-request down-votes accepted-answer asked Apr 30 at 7:37

meta.stackoverflow.com

34 votes

Files - in the database or not?

database-design blob asked Apr 29 '11 at 12:02

dba.stackexchange.com

31 votes

How could DBAs be more 'programmer friendly'?

database-design best-practices database-administration asked May 2 '11 at 11:05

dba.stackexchange.com

19 votes

How to implement a 'default' flag that can only be set on a single row

constraint database-agnostic referential-integrity asked Aug 19 '11 at 12:41

dba.stackexchange.com

17 votes

What kind of database/DBA questions does the SO community want to keep?

discussion migration asked Aug 1 '11 at 9:58

meta.stackoverflow.com

15 votes

Should 'favorite' stars migrate with a question?

feature-request migration favorites asked Aug 28 '12 at 16:07

meta.stackoverflow.com

14 votes

Should every table have a single-field surrogate/artificial primary key?

database-design primary-key asked Sep 23 '11 at 21:25

dba.stackexchange.com

13 votes

Does Gen 1:1 refer to day 1 or the entire 6 days of creation?

genesis hebrew creation asked Feb 16 '12 at 18:19

hermeneutics.stackexchange.com

11 votes

Does NULL have a type?

datatypes null asked Aug 6 '11 at 10:58

dba.stackexchange.com

Top Answers

How to insert values into a table from a select query in PostgreSQL?

dba.stackexchange.com

Remove all migration targets except Meta Stack Overflow

meta.stackoverflow.com

The Eye of the Needle

hermeneutics.stackexchange.com

What storage engines work with Oracle?

dba.stackexchange.com

What is the 'cock's crow'?

hermeneutics.stackexchange.com

Why is Database Administration so hard?

dba.stackexchange.com

How to implement a 'default' flag that can only be set on a single row

dba.stackexchange.com

What are the arguments against or for putting application logic in the database layer?

dba.stackexchange.com

Row numbering in PostgreSQL

stackoverflow.com

How do I get the current unix timestamp from PostgreSQL?

dba.stackexchange.com

Can spatial index help a “range - order by - limit” query

dba.stackexchange.com

Sqlite convert string to date

stackoverflow.com

What features of Oracle make it an attractive choice for small projects?

dba.stackexchange.com

Concept of Schema in PostgreSQL

dba.stackexchange.com

What formatting example should replace “his suicide note” in the Markdown help?

meta.stackoverflow.com

how to use Blob datatype in Postgres

stackoverflow.com

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

dba.stackexchange.com

Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?

dba.stackexchange.com

How can I use a default value in a Select query in PostgreSQL?

dba.stackexchange.com

Oracle Shutdown Method

dba.stackexchange.com

What does Jesus mean by generation when talking about the end times?

hermeneutics.stackexchange.com

Is inner join the same as equi-join?

stackoverflow.com

Fast lookup for 100gb of data

stackoverflow.com

What is the difference between select count(*) and select count(any_non_null_column)?

dba.stackexchange.com

How to implement a 'default' flag that can only be set on a single row

dba.stackexchange.com

Why doesn't INSERT AFTER Trigger add all results?

dba.stackexchange.com

If an 'after' DDL trigger causes an error, is the DDL rolled back?

dba.stackexchange.com

Does the order of fields in SELECT query matter when using composite indexing?

dba.stackexchange.com

What does “meek” mean in Matthew 5:5?

hermeneutics.stackexchange.com

Did Adam and Eve not have sex in the Garden of Eden?

hermeneutics.stackexchange.com