I started this one when I was unemployed last month.
By no means is the list exhaustive, just some of the things I think of when planning out my design.
What kind of data? If you’re going to be storing BLOBs of any sort, you may need a lot of space. Work with your DBA to figure out a plan.
How much data? Are you a telecom doing thousands of transactions per second? A non-profit doing 100 transactions a day? Somewhere in between?
Who are your customers? Will this be public facing? Internal only?
How will you handle security? Database Authentication? Roll your own table based authentication? If it’s a web based application, it’s probably easier to roll your own as it’s a stateless environment. If you’re doing a client/server application, Database Authentication is probably the best way to go as you won’t have to reinvent the wheel.
Can you use VPD or Application Contexts?
What type of keys? Will you stick to one method and use surrogate keys for everything? Natural keys for everything? Or a mix of both?
What version of Oracle?
Encryption?Will you need columnar encryption (SSN, Credit Card Numbers, etc)? Transparent Data Encryption?
Coming from the end-user world, I tend to start with reports. What kind of information do you need to retrieve from your data? I think that is the most important thing actually. For without good information, what's the point?
Anyway, feel free to add your own. What are some of things you consider whilst designing your database?
Monday, September 29, 2008
Friday, September 26, 2008
Job: Oracle DBA in Tampa
Here's another one. If interested, leave a comment (I won't publish) or email me, chet dot justice at the google mail domain (does this spelling out really work?).
The Database Analyst provides database administration support for production, development, and test environments to include day-to-day monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, SQL and database optimization and tuning as well as researching, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
* Provide support for all Oracle database environments to include problem identification, reporting, tracking, analysis, and resolution.
* Research and analyze all assigned anomalies - record, track and log all findings and recommendations.
* Participate in production on-call rotation (one week at a time of 7x24 on-call support for production environments).
* Monitor database performance and space utilization – investigate and resolve reported issues.
* Establish, maintain, and monitor database backups and DRP sites.
* Establish, maintain, and monitor database security, roles, user-role assignments, and individual logins per company security policies and procedures.
* Establish and maintain data replication as required for each application.
* Assist project teams in setting up and testing development, test, and production environments.
* Research, analyze, and recommend patches, tools, and/or database upgrades to resolve issues and add features/functionality.
* Architect, design, and implement replication and/or data synchronization.
* Assist project teams in designing efficient data access methods and procedures, including data structures (physical data modeling), SQL techniques, and use of database tools/utilities.
* Provide technical leadership to the DBA team by assisting junior team members and sharing knowledge and research of tools/techniques, and Oracle features.
* Serve as team liaison to project managers for database administration and system administration services.
* 7 years Oracle database administration experience to include versions 9I and 10G.
* 7 years SQL experience with expert-level skills in the SQL language.
* 3 years near-real time replication experience - any tool (streams, golden gate, etc).
* 1 year RAC or ASM experience.
* RMAN/Legato backup experience.
* 4 year BS or BA degree required in a computer related field or 6 years of directly related work experience in a large-scale IT environment.
* PL/SQL development experience.
* Oracle advanced replication, streams, or Golden Gate replication.
* Oracle Application Server (not Oracle Applications 11i).
* Experience in Oracle RAC (10G).
* Experience in Oracle Advanced Security & Data Encryption.
* Transparent application failover.
DESCRIPTION:
The Database Analyst provides database administration support for production, development, and test environments to include day-to-day monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, SQL and database optimization and tuning as well as researching, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
RESPONSIBILITIES:
* Provide support for all Oracle database environments to include problem identification, reporting, tracking, analysis, and resolution.
* Research and analyze all assigned anomalies - record, track and log all findings and recommendations.
* Participate in production on-call rotation (one week at a time of 7x24 on-call support for production environments).
* Monitor database performance and space utilization – investigate and resolve reported issues.
* Establish, maintain, and monitor database backups and DRP sites.
* Establish, maintain, and monitor database security, roles, user-role assignments, and individual logins per company security policies and procedures.
* Establish and maintain data replication as required for each application.
* Assist project teams in setting up and testing development, test, and production environments.
* Research, analyze, and recommend patches, tools, and/or database upgrades to resolve issues and add features/functionality.
* Architect, design, and implement replication and/or data synchronization.
* Assist project teams in designing efficient data access methods and procedures, including data structures (physical data modeling), SQL techniques, and use of database tools/utilities.
* Provide technical leadership to the DBA team by assisting junior team members and sharing knowledge and research of tools/techniques, and Oracle features.
* Serve as team liaison to project managers for database administration and system administration services.
REQUIREMENTS:
* 7 years Oracle database administration experience to include versions 9I and 10G.
* 7 years SQL experience with expert-level skills in the SQL language.
* 3 years near-real time replication experience - any tool (streams, golden gate, etc).
* 1 year RAC or ASM experience.
* RMAN/Legato backup experience.
* 4 year BS or BA degree required in a computer related field or 6 years of directly related work experience in a large-scale IT environment.
PREFERRED EXPERIENCE:
* PL/SQL development experience.
* Oracle advanced replication, streams, or Golden Gate replication.
* Oracle Application Server (not Oracle Applications 11i).
* Experience in Oracle RAC (10G).
* Experience in Oracle Advanced Security & Data Encryption.
* Transparent application failover.
Wednesday, September 24, 2008
More on Oracle Exadata Storage
I don't know why I'm so excited about this...I guess I'm trying to live up to my name.
See my previous post here full of a few screen shots from Larry's speech.
A great post on most of the stuff I don't understand from Kevin Closson who works more on the datawarehouse side.
Paul Vallee over at the Pythian Group blog ruminates here and here.
Curt Monash talks about it here and here.
Dana Gardner from ZDNet.
Larry Dignan from CNET.com via ZDNet Australia.
Michael Liedtke via AP.
And how could I forget my local Oracle blogger, Mr. Cunningham.
I'm still amazed at how excited I am. It's just a machine right? Hopefully I'll get to use one of those someday...
See my previous post here full of a few screen shots from Larry's speech.
A great post on most of the stuff I don't understand from Kevin Closson who works more on the datawarehouse side.
Paul Vallee over at the Pythian Group blog ruminates here and here.
Curt Monash talks about it here and here.
Dana Gardner from ZDNet.
Larry Dignan from CNET.com via ZDNet Australia.
Michael Liedtke via AP.
And how could I forget my local Oracle blogger, Mr. Cunningham.
I'm still amazed at how excited I am. It's just a machine right? Hopefully I'll get to use one of those someday...
Oracle Exadata Storage
So the big announcement today...Larry created an appliance with HP as the hardware.
Press Release
Exadata
Here's a picture of the new beast:
In comparison to Larry:
Some of the characteristics:
And finally, it runs OLTP too!
Press Release
Exadata
Here's a picture of the new beast:
In comparison to Larry:
Some of the characteristics:
And finally, it runs OLTP too!
Subscribe to:
Posts (Atom)