Under minimal supervision, this position is responsible for handling the data architect and development DBA functions. On occasion, light programming and/or generating reports will also be required. Production databases are mission-critical to COMPANY's products; the Dev. DBA/Data Architect must be reachable and available for unexpected major production issues at all times.
Approximately 3 times a year, scheduled weekend work will be required for high risk or major changes. Around 10 times a year, the DBA/Data Architect will be on-call for weekend changes.
At least once a month, a new type of request is needed by our partners and the position requires the DBA/Data Architect to write, test, and document scripts. Actual execution on the production system will be performed by the operational DBA as a check and balance.
The Data Architect responsibilities include maintaining ER diagrams for all systems. The Data Architect is responsible for understanding the interrelationship of systems and data. The position requires taking an active role in designing new systems and in making modifications/enhancements to existing systems.
The Development DBA responsibilities include assisting the development staff in writing efficient SQL and in ensuring new code is well documented to allow for effective future maintenance effort.
Self-managing and able to work on multiple development projects.
Proactively learn about our systems by talking to existing employees and in reviewing in detail the actual code.
Become the subject matter expert on our applications and the interrelationship of multiple application systems and the data.
Strong leadership skills and the demonstrated capability to take a stance and to steer COMPANY staff and groups to use processes adhering to industry best practices
Exhibit excellent teamwork behavior by working well with multiple groups effectively (e.g. QA, Developers, DBA, Linux Systems Engineers, Partner Support)
Strong SQL and PL/SQL language skills
Good data architect skills including a basic understanding of ER.
Must be able to write efficient SQL statements and have the skills and knowledge to debug and tune performance problems. The Dev DBA must understand the use of indexes, interpretation of plan results, and be able to develop new or to revise existing indexes to address performance issues.
Dev DBA/Data Architect is expected to be actively involved in addressing high impact Production problems.
Position requires occasionally developing new reports
Perform other duties as assigned.
Essential Technical Skills
The ideal candidate must be able to thrive in a complex environment and take pride and ownership of the work they produce. A successful Development DBA will be someone who:
Experience working in medium to large company (minimum 20 instances, 5 are production, largest instance least 500 gigabyte in size)
Solid Oracle DBA skills
Fundamental understanding of Relational Database Knowledge, entity relationship, primary keys, foreign keys, normalization
Considerable experience and knowledge of Oracle 'best practices'.
Exceptional troubleshooting and analytical problem-solving skills.
Must have excellent learning abilities and have the ability to use various resources to research issues.
Skilled at writing Oracle DDL, SQL, PL/SQL programs
Good verbal and written communication skills
Highly Preferred Technical Skills
Experience with version control (Perforce, etc.)