Description
DESCRIPTIONThe Client Server Database Administrator will ensure the database environment is highly reliable, provides the required functionality, is efficient, and cost effective.
Responsibilities:
- 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.
- Establish and maintain data bases for user testing purposes and production.
- Consult with business analysts, data modelers and designers on procedures pertaining to new and existing files.
- Provide input to the data models (functionality, efficiency and usability).
- Responsible for the technical aspects of one or more databases including availability/reliability.
- Assist in the definition of the database requirements.
- Analyze existing databases and their interfaces looking for opportunities to improve their efficiency; and resolve technical problems.
Qualifications:
- Bachelors degree or equivalent training or work experience required.
- Requires a minimum of two years experience as an Oracle DBA in the design, testing, implementation and administration of systems using Oracle RDBMS, PL/SQL programming.
- Experience with RMAN, export/import, data pump, SQLPlus required.
- Knowledge of Oracle backup and recovery methodologies including RMAN a must.
- Database performance and tuning (AWR, Statspack, SQL trace).
- Shell Scripting: Linux, Windows. Ability to manage multiple production, validation and development Oracle environments.
- Operating System experience on Linux and Windows. SQL Server DBA experience, in addition to Oracle, is desired.
- 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.
- Must have excellent interpersonal and communication skills, teamwork skills, problem solving skills, detail orientation, troubleshooting skills, as well as being a self-starter and self-motivator.
- Understanding of customer's business operations and products produced.
- Knowledge of systems applications delivery tools and techniques.
- Four to six years of applications programming experience or equivalent.
- Three to five years of experience in respective database area; experience in more than one database structure (hierarchical, network or relational).
- Understands the pros and cons of each; experience with tools and utilities for platform; and understand the pros and cons of different designs with respect to storage, system performance and user flexibility.
SKILLS
Oracle RDBMS. PL/SQL programming, Operating System experience on Linux and Windows. SQL Server DBA
Synectics is an Equal Opportunity Employer.