Total-TECH Co.
” The Job Description”
- 8+ Years programming experience as an OracleSQL/ PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
- Evaluate Oracle features and Oracle related products by using Oracle 9i, 10g, 11g , 12c upto 19c.
- PL/SQL coding for standard database maintenance tasks.
- Knowledge on Oracle Administration in various Operating Systems (W2K, UNIX, SUN, AIX, Linux).
- Experience monitoring database management systems evaluating database performance to maximize efficiency.
- Expertise in Client-Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL *PLUS, SQL NAVIGATOR and SQL*LOADER.
- Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Views and Transportable table spaces. Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
- Data loading into Oracle Tables using SQL Loader, External tables, Partitioned large Tables using range partition technique.
- Experience with Oracle Supplied Packages.
- Knowledge on databases tuning for efficiency, and manage scalability demands as required.
- Should be able to develop and Fine tuning all database objects like SQL, functions, triggers, procedures and packages etc.
- Supports transition of current applications from one environment to higher environment.
- Assists with application migration/upgrades to the Oracle 10g environment and other data loads(ETL) in support of research projects.
- Experience on migrating Stored Procedure to Business Logic layer.
- Provides support for projects like designing and maintaining metadata models and complicated ETL packages or OLAP cubes. Experience on converting customers’ requests into technical details and further to be used for reporting purpose.
Soft Skills:
- Manage the day to day operations of the RDBMS environment and High availability systems.
- Perform technical trouble shooting and consulting to various development teams.
- Ability to work and engage with database administrators.
- Assists in system operational support to maintain the stability of live systems, which may include being on-call evenings or weekends to handle emergencies.