Oracle/SQL DBA McHenry 1-10

Company: Yoh IT
Location: McHenry, IL
Status: contract to perm
Salary: Market
Close Date: Permanent
Job Description:

JOB TITLE: Database Administrator – Oracle/SQL

LOCATION: McHenry, IL

EXPERIENCE:

  1. Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle.

  2. SQLPlus and PL/SQL in an Oracle environment experience.

  3. SQL language in a SQL Server environment experience.

  4. Experience with Oracle applications including EBS R12.

  5. Linux/Unix operating experience.

KNOWLEDGE:

1. Knowledge of Oracle E Business Suite R12

2. Knowledge of the Linux/Unix operating system(s)

3. Knowledge of physical database design

4. Excellent knowledge of Oracle backup and recovery scenarios utilizing both RMAN and other methods.

5. Knowledge of Oracle security management.

  1. Knowledge of transaction logging, backup and restoring of a SQL Server. Database including cloning to another environment.

7. Knowledge of how Oracle acquires and manages resources.

8. Knowledge of the way Oracle enforces data integrity.

9. Knowledge of both database and program code performance tuning.

10. A DBA should possess a sound understanding of the business.

SKILLS:

1. Must have a good working skill set of using SQL, PL/SQL in an Oracle

environment.

2. Good skills in all Oracle tools.

3. Sound communication skills with management, development teams, vendors, systems administrators and other related service providers.

4. Good hands on skill set of SQLPlus and PL/SQL in an Oracle environment.

  1. Good working skill set for SQL language in a SQL Server environment.

ABILITY:

1. Ability to perform both Oracle and also operating system performance monitoring and the necessary adjustments utilizing.

2. Ability to provide a strategic database direction for the organization.

  1. Ability to create and maintain DTS packages for in house applications.

  2. Ability to schedule jobs in SQL Server for system or application related functions.

  3. Must be able to exhibit tact and diplomacy and maintain professional relationships with supervisors, fellow employees, customers, etc.

 

 

 

 

 

 

 

 

 

RESPONSIBILITIES:

1. Creates and maintains all databases required for development, testing, education and production usage.

2. Performs the capacity planning required to create and maintain the

databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.

3. Performs ongoing tuning of the database instances.

4. Install new versions and or security patches of the Oracle RDBMS and its tools and any other tools that access the Oracle database.

5. Plans and implements backup and recovery of the Oracle database.

6. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.

7. Implements and enforces security for all of the Oracle Databases.

8. Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.

9. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.

10. Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.

11. Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.

12. Enforces and maintains database constraints to ensure integrity of the database.

13. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

14. Assists with impact analysis of any changes made to the database objects.

15. Troubleshoots with problems regarding the databases, applications and development tools.

16. Create new database users as required.

17. Manage sharing of resources amongst applications.

18. The DBA has ultimate responsibility for the physical database design.

  1. Creates and maintains all databases required for development, testing, education and production usage.

  2. Create and maintain all stored procedures required for application support.
Contact Information:
Job Code: Oracle DBA McHenry
E-mail: jim.jennings@yoh.com
Website: http://www.YOH.com

Your Company Name


<< Back