Key duties will include the analysis of the existing databases in terms of design, deployment and optimization.

 

  • Design, development and administration of Oracle databases.
  • Reviewing and tuning SQL and PL/SQL code.
  • Designing database packages and procedures.
  • Provide assistance to development team in the design, development, testing, tuning and implementation of database applications
  • Create and maintain SQL queries and routines.
  • Write ad-hoc queries based on schema knowledge for object relational database mapping and various reporting requirements.
  • Should be able to identify and plan trainings for different development teams for database related best practices in terms of coding.
  • Design, build and maintain high-volume relational databases for company’s applications and systems
  • Design and support Database backup solutions which can include hot/cold backups, exports, imports and RMAN
  • Control and review all security standards employed on the databases
  • Performance tuning and write code for database access, modifications, and constructions including stored procedures, views and triggers
  • Support database platforms and help define strategies for data acquisition, recovery, migration and archiving
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
  • Experience in Performance Tuning, Query Optimization, using native monitoring and troubleshooting tools.
  • Ability to detect and troubleshoot the issues.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, and Replication.
  • Expert experience in implementing operational automation.
  • Strong knowledge of indexes, index management, and integrity checks, configuration, statistics.

Skills Required:

  • Complete knowledge of Oracle database with production support experience in a multi-project environment. 
  • In-depth knowledge of SQL and PL/SQL including tuning. 
  • Good working knowledge of job scheduling and monitoring tools. 
  • Experience of working with multiple projects/tasks and the ability to deliver quality work. 
  • Familiarity with Oracle specific tools and utilities.
  • 2+ years of experience as a database administrator.
  • Very strong communication (written and verbal)
  • Good knowledge of Oracle database installation, maintenance and recovery.
  • Excellent problem solving and analytical skills, and outstanding oral and written communication skills.
  • Good experience with Oracle9i, Oracle10g databases and utilities on Solaris, Linux and Windows Servers.

نوکری کی تفصیلات

کل عہدے:
1 اشاعت
نوکری کی شفٹ:
پہلا پہر
نوکری کی قسم:
نوکری کا مقام:
جنس:
کوئی ترجیح نہیں
کم از کم تعلیم:
بیچلرز
کیریئر کی سطح:
تجربہ کار پیشہ ور
کم از کم تجربہ:
2 سال
اس سے پہلے درخواست دیجیۓ:
اکتوبر ۲٦, ۲۰۱۷
تاریخِ اِشاعت:
ستمبر ۲٦, ۲۰۱۷

SoftConsults

انفارمیشن ٹیکنالوجی · 11-50 ملازمین - لاہور

SoftConsults, is providing ERP solutions since 1998. We provide time-saving innovative solutions resulting improving the staff efficiency, minimizing data processing time and reducing the payroll cost. We have the largest ERP deployed client list covering RIAZ MSB Limited, Minerva Payment Services Limited, Aitchison College, The University of Lahore, Mainland Husnain Pakistan Limited (Royal Palm Golf Club), Lahore Gymkhana Club, ZARCO Exchange Company (Private) Limited, FairDeal Exchange Company (Private) Limited, Habib Currency Exchange (Private) Limited, AL Hameed International Money Exchange (Private) Limited, Ravi Exchange Company (Private) Limited, Dynasel Limited, Punjab Irrigation and Drainage Authority (PIDA), Chand Bagh Foundation, Lahore Grammar School, Kinnaird College for Women, Jamal Rugs Weaver (Private) Limited, A.M. Corporation, Bostan Carpets, Bilal Carpets, and so on. We also have foreign clients in United Kingdom, UAE, Canada and USA.

آپ کو کس حوالے سے برتری حاصل ہے؟

اپنے بارے میں ہماری پیشہ ورانہ رائے اور تقابلی جائزہ حاصل کیجیۓ
اپنی سی وی کو موءثر بنانے کیلئے ہماری ماہرانہ مشاورتی ٹیم سے رابطہ کریں
روزی پریمیئم کو آزمائیں

ملتی جلتی نوکریاں

Oracle PL / SQL Developer

Synergy MSP, لاہور, پاکستان
مارچ ۰۷, ۲۰۲۴ شائع ہوئی

Oracle APEX Developer

Synergy MSP, ایک سے زیادہ شہر, پاکستان
مارچ ۲٦, ۲۰۲۴ شائع ہوئی

Assistant Manager Database Administration

BankIslami Pakistan Limited, کراچی, پاکستان
مارچ ۲٦, ۲۰۲۴ شائع ہوئی
I found a job on Rozee!