Description
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.
- 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
- Resolve technical problems.
SKILLS:
- Bachelors degree or equivalent training or work experience
- 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.
- Advanced Oracle 10g, Oracle 11g, SQL Server 2008 DBMS Skills.
- Experience with Oracle RAC, Dataguard, Oracle Database Appliance, Oracle Identity Management, replication, log shipping a plus.