ESSENTIAL PURPOSE OF THIS POSITION:
The incumbent is responsible for database design and implementation, including the development of complex procedures, and triggers as well as storage management, performance tuning, data feeding, and scheduling.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Responsibilities include the ability to design and architect databases for in-house custom-built applications. Leads and consults on the design, development, and implementation of logical database structures and classification schemas as well as physical database structures, archiving, and conversion for complex and distributed physical databases:
- Lead the analysis of database requirements, including configuration, system, and scope of the database.
- Design, review, and model across platforms.
- Architect and design databases for Manufacturing applications.
- Build database schemas, write trigger procedures and determine where the logic will lie. Create database views if required.
- Evaluate business and product requirements and translate these into a good database design
- Use database replication/synchronization techniques
- Data Modeling and implementation
- Work with technical infrastructure professionals to identify database server hardware and storage recommendations, and a webserver to database architecture
- Make changes as needed by developers including procedures, triggers, design changes, and improvements.
- Devise database concurrency solutions
- Design distributed data tier to optimize machines, servers, and database configuration.
- Maintain development, test, and production regions of programs.
- Perform backup and recovery of databases, as needed.
- All other assigned duties.
EDUCATION AND EXPERIENCE REQUIREMENTS:
- Four-year degree in the field of computer science
- 5+ years of experience in PROGRESS 4GL/OpenEdge 9/10/11/11.7 development
- 5+ years of knowledge in Application and Database Design
- 3+ years of experience implementing Webservices, XML parsing, ProDataSets, etc.
SKILLS AND ABILITIES REQUIRED
- Thorough understanding of Progress database internals.
- Broad understanding of XML.
- Tuning and enhancing the database.
- Basic UNIX/Linux administration including scripting and print management.
- ABL programming/Unix scripting
- Conceptual understanding of overall hardware, software, and network infrastructure.
- Familiar with performance monitoring tools for various platforms and the ability to set up transaction metrics.
- Experience in database design (logical and physical levels) to support complex transaction systems.
- Ability to multitask (i.e., perform multiple architecture/design tasks concurrently.
- Basic knowledge of ERP preferred.
- Ability to work in a fast-paced environment and meet tight project schedules with minimal supervision.
- Good verbal and written communication skills required.
- Knowledge in English (verbal and written)-B2 level as a minimum
COMPUTER EQUIPMENT AND SOFTWARE REQUIREMENTS
- Technical knowledge of network and server operating systems.
- Technical knowledge of current network hardware, protocols and standards
- Strong proficiency in an Enterprise Database management system to include: Progress & Microsoft SQL Server
Please send your CVs in English.
