Oracle DBA

RESPONSIBILITIES

- Ensures the database environment is highly reliable, provides the required functionality, is efficient, and cost effective.
- Accountable for the creation of the logical and physical data models.
- Troubleshoots daily program problems to assist program users in accessing and manipulating computerized data.
- Analyzes and creates programs to streamline production jobs.
- Establishes and maintains data bases for user testing purposes and production
- Consults with business analysts, data modelers and designers on procedures pertaining to new and existing files
- Provides input to the data models (functionality, efficiency and usability)
- Responsible for the technical aspects of one or more databases including availability/reliability
- Assists in the definition of the database requirements
- Analyzes existing databases and their interfaces looking for opportunities to improve their efficiency
- Resolves technical problems
- Designs, tests, implements and administrates systems using Oracle RDBMS.
- PL/SQL programming.

SKILLS

The following are required: B.S. Degree with minimum 4 years experience as an Oracle DBA in the design, testing, implementation and administration of systems using Oracle RDBMS. PL/SQL programming. Oracle utilities: RMAN, export/import, data pump, SQLLoader, SQLPlus. Oracle backup and recovery methodologies including RMAN. Database performance and tuning (AWR, Statspack, SQL trace). Shell Scripting: Linux and Windows. Ability to manage multiple production, validation and development Oracle environments. Operating System experience on Linux and Windows. Candidates must be willing and able to participate in off-hours support when needed. Experience working in an environment governed by a formal software development methodology is strongly desired. The following are also required: excellent interpersonal and communication skills, teamwork skills, problem solving skills, detail orientation, troubleshooting skills, as well as being a self-starter and self-motivator.
Synectics is an Equal Opportunity Employer.