آگهی‌های استخدامی

استخدام Senior Database Administrator (Application)

شرح موقعیت شغلی

As a Senior Database Administrator at Asan Pardakht, you will be responsible for designing, implementing, optimizing, and supporting Oracle and PostgreSQL database environments that power high‑volume, mission‑critical payment systems. This role focuses on Reliability, Availability, Scalability, and Maintainability in a 24/7 production environment.

Key Responsibilities:

- Configure, optimize, and support Oracle and Postgres relational databases with a focus on Reliability, Availability, Scalability, and Maintainability.

- Design, develop and implement complex database systems, programs, and applications.

- Designs, develops, and maintains transactional databases and data warehouses.

- Create and Maintain SQL Stored Procedures

- Create and Maintain User Defined Functions

- Job Management of Automation Tasks

- Manages and maintains the databases, performs troubleshooting and tuning when necessary.

- Participates in the design/planning of new databases and related technology.

- Implements ODI/OGG/jobs/scripts to support the applications and interfaces between them.

- Work closely with Business and analytical staff to define new project requirements.

- Work with users to identify and develop system requirements taking into account security best practices, desired  results, hardware limitations and operating requirements.

Requirements:

- 5-7 years’ experience in Oracle Database Administrator and has held a Senior DBA level position.

- 3+ years in SQL scripting and tuning.

- 2+ years in Linux Bash scripting.

- Expert experience administering, monitoring and maintaining Oracle Rac Clusters including backup and restore.

- Experience with enterprise performance and HA monitoring.

- Experience with database backup and restore.

- Able to design database tables. Need to be familiar with first, second, and third normal forms. Understand data integrity, referential integrity, primary key, and foreign key.

- Familiar with Oracle and Postgres development. Familiar with PL/SQL and PL/pgSQL. Being able to create stored procedure, functions, synonyms, views, tables, constraints, and indexes.

مهارت‌های مورد نیاز

  • SQL
  • Linux

حداقل سابقه کار

  • بیش از شش سال

جنسیت

  • مهم نیست

وضعیت نظام وظیفه

  • مهم‌ نیست

نوع همکاری:

تمام وقت

تاریخ انتشار آگهی:

۱۴۰۴/۱۰/۱۵ (منقضی‌شده)
مشاهده آگهی‌های استخدام مشابه