US-NJ-Florham Park: Database Administrator

To see other opportunities, please visit http://dba.fyicenter.com/
Date: 30-May-2008

Database Administrator

Core Responsibilities:

1. Coordinates physical changes to databases. Codes, tests and implements physical database. Designs logical and physical databases, or reviews description of changes to database design to understand how changes to be made affect the database. Tunes, configures and maintains operational data and databases using Oracle, and SQL Server.

2. Resolves problems and answers questions related to RDBMS and platform environment. Facilitates application development and end user problem resolution with optimum speed and efficiency.

3. Identifies data consistency and data availability requirements. Establishes physical database parameters. Calculates optimum values for database parameters such as amount of computer memory to be used by database.

4. Modifies database tables and indexes to increase processing performance – ongoing performance tuning and optimization. Assists Development with performance engineering issues.

5. Implements and automates programs to monitor database and database server performance such as distribution of records and amount of available memory. Tests and corrects errors, and refines changes to database.

6. Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data. Specifies which users can access databases and what data can be accessed by user.

QualificationsRequired (Experience, Skills, Academic): Experience/Required Skills:

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.

Education:

BS Computer Science or Engineering.

To apply for this position, please visit this Website.

Thank you,
DBA FYI Center
http://dba.fyicenter.com/