Data Base Administrator (Oracle, Mongo)

Asan Pardakht Persian Tehran

Posted Over a month ago

Job Description

● 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. ● Design, develop and maintain transactional databases and data warehouses. ● Create and maintain SQL stored procedures. ● Create and maintain user-defined functions. ● Job management of automation tasks. ● Manage and maintain the databases, perform troubleshooting and tuning when necessary. ● Participate in the design or planning of new databases and related technology. ● Implement ODI, OGG, jobs, or 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 of experience as 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 restoration. ● 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 procedures, functions, synonyms, views, tables, constraints, and indexes.

Employment Type

  • Full Time

Details

To see more jobs that fit your career