Job: Senior DBA

Just drop me a note at chet@oraclenerd.com if you are interested. I'll pass you along.

Position:
Sr. Database Administrator, IT 100-110k

Location:
North Dallas/Richardson, TX, USA

Summary:
Conceptualizes, designs, constructs, tests and implements business and technical IT solutions through application of appropriate software development life cycle methodology.

This position is primarily responsible for direction, support and maintenance of the Company’s Oracle e-Business Suite and supporting databases. It requires strong analytical and problem solving skills plus the ability to communicate effectively with a diverse audience which includes senior management, business stakeholders and IT team. An in depth knowledge of Oracle’s Enterprise RDBMS, e-Business technology stack and Oracle Applications is needed.

Duties and Responsibilities:

• Manage and maintain all development, test, and production databases.
• Develop and support standards and physical data storage design, as well as maintenance, access, and security administration; perform backup and recovery on Database Management Systems (DBMS) and configure database parameters and design prototype logical data model.
• Define data repository requirements, data dictionaries, and warehouse requirements; consult with and advise users on access to various databases, as well as, work with users to resolve data conflicts and inappropriate data usage.
• Assist management with the development of database strategies that support the organization’s needs and requirements.
• Possess the ability to optimize database access and allocate/reallocate database resources for optimum configuration, database performance, and cost.
• Manage the maintenance and use of the corporate data dictionary.
• Develop and establish guidelines and processes to manage demand and performance, as well as work with peers across other departments to manage demand, performance, and capacity processes.
• Conceptualizes, designs, constructs, tests and implements business and technical IT solutions through application of appropriate software development life cycle methodology.
• Interacts with Business Delivery Teams to gain an understanding of the business environment and technical contexts.
• Participates in business and technical IT solution implementations, upgrades, enhancements, and conversions.
• Understands and uses appropriate tools to analyze, identify and resolve business and/or technical problems.
• Prepares system documentation establishes and maintains security, integrity, and business continuity controls and documents. Provide leadership and mentoring to jr. level technical teams.
• Contributes to the strategic direction of the function.
• Advises senior management on issues as they pertain to larger organizational issues/business initiatives.
• Performs other duties as assigned.

Requirements:
Applicants must be resident citizens of the United States, who have or who are eligible to possess a U.S. Government personnel security clearance at the level of Top Secret. Applicants selected will be subject to a U.S. Government security investigation and must meet eligibility requirements for access to classified information.

Education:
Four (4) year degree or equivalent experience

Experience:
7+ yrs

• Minimum 7 years experience with Oracle database administration in a business environment including installing, patching, cloning, upgrading and restoring/recovering databases (Oracle 9i, 10g and 11g).
• 5+ years experience as an Oracle e-Business (11i or 12i) Application DBA which encompasses installing, patching, cloning, upgrading, and supporting
• Oracle application software and associated Oracle technology stack in a multi-tier environment including database server, applications server, web server, concurrent processing server, reports server, forms server, admin server and discoverer sever environment. Experience with Oracle’s PeopleSoft application a plus.
• Extensive knowledge of underlying Oracle Application database architectures, file system structures, schemas/products, tables, views, packages, procedures, functions, triggers, sequences, indexes and constraints is a must.
• Knowledge of Oracle’s Mobile field Service (WebToGo), Informatica PowerCenter, Solix EDMS suite and Microsoft SQL Server is a plus.
• Experience using Oracle’s Metalink support environment is a must.

Skills:

• Demonstrates advanced knowledge of principles, concepts, and theories in own discipline, and has extensive knowledge of principles and concepts in other functions.
• Demonstrates advanced business knowledge and analyses the impact of emerging industry trends.
• Demonstrates leading edge knowledge of concepts and theories in own discipline.
• Perceived internally and externally as expert in the function.
• Teaches others the technical and functional knowledge and skills needed to achieve results at the optimum level of performance.
• Applies leading edge knowledge to drive strategic direction of the function and the business in partnership with senior leaders.
• Recognized as a thought-leader.

Competencies:

• Customer Focus
• Drive for Results
• Ethics & Values
• Peer Relationships
• Conflict Managerment
• Continuous Improvement
• Business Acumen
• Functional/Technical Skills
• Decision Quality

Other:
This position is local and does not include relocation. Only candidates who possess the above minimum requirement will be considered.

Kevin Closson: DIY Exadata-level Performance?

Kevin Closson of the Oracle Systems Technology Group is looking for votes for his Oracle OpenWorld session over on Mix.

Title

Do-It-Yourself Exadata-level Performance?

Abstract

Oracle and Sun combined offer a tremendous array of hardware and software technologies. Would it be possible to open the product catalogue and assemble enough gear to offer Exadata-like performance? This is the presentation for the true DIY spirit in all of us. Come listen to Kevin Closson (Performance Architect, Oracle Server Technologies) tackle this notion with more fact than faith.

About Mr. Closson

Kevin is a Performance Architect in Oracle Corporation’s Server Technology Group. His 20 year career has included Engineering, Competitive Benchmarking, Support, and Application Development on high-end SMP and Clustered platforms. His work prior to Oracle at HP/PolyServe, Veritas and IBM/Sequent was focused on scalability and availability of the Oracle server. His Oracle port-level work at Sequent led to his U.S. patents in SMP/NUMA locking and database caching methods. Kevin speaks frequently at Oracle conferences and is a member of The OakTable Network. Kevin is also an Oracle Employee Ace. In addition to book collaborations, his written works have appeared in Oracle Magazine, Oracle Internals Magazine, IBM Redbooks and SELECT.

You can vote for his session here.

OBIEE: Gotcha #3

I received this wonderfully informative error this evening:



Value[nQSError: 36006] Promotion of checkout lock on Value to exclusive failed.

Lacking an Oracle Support login...I ventured to Google. Just like the error, it was wonderfully uninformative.

Log files?

Nothing.

This halted all development for me. Not all, I could make one change, check it in (save) and then I would get that error again. Wonderful.

From what I could piece together, and this is the purest form of speculation, it had something to do with naming.

I had a Physical database named "LOV"
I had a couple of columns (different tables) in another database with the same name.
These were all combined into one subject area.
Therefore that had to be the issue.

Or not. Who knows?

How did I fix it?

Shutdown the BI Server, opened up the RPD in read-only mode, did what I had to do and saved it...no error. Sweet.

Fired up the BI Server, opened up the RPD...you can only open this in read-only mode. WTF?

Let's try this again.

Shutdown.

Start.

Login. Success!

I almost followed the universal Windows rule of rebooting 3 times...almost.

Thank You?

More of a rant than anything.

I once teamed up with a co-worker to collect all the crazy-long email signatures people use. I think the longest we ever collected was around 10 lines, complete with pictures (a logo) and an alphabet soup of titles earned. Email address was included...which I still have a hard time figuring out why. Perhaps someone will print it? I guess those people still exist.

Anyway, the other day I noticed this (not the first time, just the first time I thought to write about it...plus, I have nothing else useful to say so maybe this will clear the bit of block I am having right now).

Thank You,

First Name Last Name
Title
Phone Number(s)

Thank You? Is that just to save time and keystrokes as Sten Vesterli [twitter|blog] notes:



I understand the efficiency part...but what if there is no actual "Thanks" required? Just seems a bit...weird to me.

I will end my email communiques with one of the following:
* Thanks
* Regards (probably a UK influence there)
* Sincerely

With my name, "chet" following a couple of lines below.

It's not that much extra typing, for me. I'm in the 70 WPM range...and maybe that's where the difference is. Who knows?

Just needed to get this off the chest.