ROLE: Oracle DBA
Location: Vienna, VA
Duration: 3+ months
Strong experience in Sneakernet process in Oracle DB environment (i.e. transfer data from source DB to target DB by using a physical removable media such as CDs/DvDs)
In-depth knowledge of Oracle 11g
In-depth knowledge of SQL and PL/SQL including tuning.
Experience with Linux including basic commands and shell scripting.
Good work! ing knowledge of job scheduling and monitoring tools.
Experience of supporting multiple teams within a business.
Experience of Data warehousing
Experience of working with Developers
PREFERRED SKILLS: Oracle Streams and Advanced Replication administration.
Hard working but easy-going manner.
Familiarity with Oracle specific tools and utilities.
Knowledge of XML and HTML
Knowledge of open source web development
Design, development and creation of custom reports based on business requirements.
- Performance monitoring, reporting, and tuning of Oracle reporting databases.
- Reviewing and tuning SQL and PL/SQL code.
- Designing database packages and procedures.
- Provision of support and assistance to development team in the design, development,
testing, tuning a! nd implementation of database applications
- Creation and maintenan ce of SQL queries and routines
- Writing ad-hoc queries based on schema knowledge for various reporting
requirements. Writing / Tuning data ingestion procedures from external suppliers and
partners using PL/SQL, sql loader, 3rd party tools eg. Toad etc.
- Required to deal with complex data models and object relational database mapping,
while producing complex reports
- Ensures that data warehouse design is scalable and maintainable
- Ensures that all deliverables are thoroughly documented
Year degree and active secret clearance required.