Saturday, May 3, 2008

Database Administrator / DBA

Administers, configures, plans, installs, tunes and monitors the performance of Oracle databases for large, enterprise Java based applications. Ensures data consistency and data availability. Provides input in designing all new databases for SBS Intranet Development and provides ongoing maintenance for all existing databases in Development, QA, Production, and DR environments. Ensures data recovery, performance monitoring and optimization, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures and standards relating to database management.
5+ years Oracle database experience, as well as other experience in relational DBMS, preferably SQL, UDB/DB2, or iSeries.
• Understanding of physical schema implementation.
• Experience with Oracle 10G/9i databases, with 9i to 10G conversion experience.
• Knowledge of how to install stored procedures in at least one database system. Working knowledge of database server installation of at least one database system on at least one operating system.
• Heavy Unix background, with solid additional experience in Windows and Linux environments. Detailed knowledge of database concepts, properties of transactions, table level data definition language. Working knowledge of at least one major database design methodology such as ERWIN or ER/Studio. Able to read entity-relationship models using a standard modeling language. Able to design at the stored procedure and relational table level. Working knowledge of common stored procedure implementation techniques.
• Programming: Strong SQL background, PL/SQL. Working knowledge of the associated language-specific idioms. Some knowledge of additional languages (e.g., C, C++, Java, Visual Basic) and/or platforms.
• Good working knowledge of configuration identification and control and associated tools, database testing techniques, hardware, networks, firewalls, client and server computers, and stored procedure testing techniques from the application level.
• Good teaming skills – works well within a multi-tiered application development organization.
• Self-directed, self-starting, capable of working independently.
• Good multi-tasking abilities.
• Strong communication and facilitation skill set.

No comments: