Remote job
Full time
Available now
Designing logical and physical model for both OLTP and Data Warehouse databases.
Performance tuning. Optimize poorly written sql, reading explain plans, indexing, partitioning, changing database model. Reading Oracle AWR reports, tkprof, snapper. Reading trace files (oracle wait interface).
Writing, debugging, profiling stored procedures in Oracle PL/SQL and Postgres plpgsql languages.
Conducting interviews for requirements gathering. Translate requirements into working solutions.
Provide Data Warehouse and ETL architecture for online fundraising platform.
Development of analytic reporting subsystem.
Oracle Database development of gaming software.
Providing database architecture solutions.
Resolving performance issues and providing SQL optimization.
Consulting architects across Oracle solutions.
Providing a data model from requirements and translates the model into a working relational database and/or other data-driven system.
Developing new solutions in PL/SQL according to business requirements.
Resolving performance issues and providing SQL optimization.
Developing templates for fast prototype creation for potential clients. Usually business problem oriented projects with extensive reporting system.
Developing new functionality for existing product.
Working close with costumers, providing requirement analysis, development and
Develop GUI applications with Oracle Forms and Oracle Reports services working under Oracle Application Server 10g; porting legacy code from Oracle Forms 3 to Forms 10g;
Develop procedures and packages with PL/SQL;
Develop database table structure for new modules;
Support and rewrite of legacy code, mainly in C;
Integration and support of newly developed programs
Master's degree, Automation and Computer Integrated systems