Oracle Database Administrator

o Experience: 8 - 15 years

o Location: Pune, Remote (India)

o Key skills: Oracle 11g/12c/1+c, Exadata, PL/SQL, Unix/Linux

o Shift: Night Shift

Job description:

· Must have extensive knowledge of key factors impacting performance of Oracle database and its tuning parameters.

· Experience in Oracle 1+c and Exadata is a must. Must be updated about new roll outs on Oracle versions and upgrade methodologies.

· Hands on knowledge of installation, configuration & managing database server and applying security patches & other Patches for upgrading versions of oracle database on different platforms.

· Upgrading the container databases over multiple versions retaining customer data.

· Hands on experience of working with Unix/Linux operating system.

· Own all performance tuning activities including PL/SQL, SQL query tuning.

· Hands-on knowledge of various partitioning techniques and implementation strategies.

· Write extensive multi-threaded PL/SQL scripts to implement partitioning.

· Devise and implement ILM scripts and data archival strategies such as compression, partitioning and tablespace movements.

· Analyse AWR reports, providing suggestions for performance improvement of SQL queries.

· Write PL SQL procedures to scale up the data in order to do performance testing with a larger data set.

· Extensive knowledge and troubleshooting experience in the following areas RAC, ASM, Exadata, Performance tuning (AWR, SQL Monitor, OEM), Data Guard (Physical and Logical) including active dataguard and DG broker, RMAN - Experience in handling complex installation/patching, database recovery scenarios is desired

· Manage database objects like tablespace, user, table, Index, roles, privileges, profiles, DB Links, materialized views, partitioning, synonyms, sequences, views and indexes and other database objects etc

· Create physical/logical standby database and performing switch-over and fail-over

· Expertise in debugging and analytical skills with solid grasp of system development methodologies, techniques, and tools

· Nice to have: OCI & AWS experience

· Nice to have: PostGres, MongoDB and other databases, Docker.

Personal Skills:

· Must have excellent verbal and written communication as this role is expected to interact with US/UK based clients on regular basis.

· Good analytical/interpretative and problem-solving skills

· Willingness to take up complex tasks on Adhoc basis across projects

· Should have detail-oriented approach towards performance tuning when designing solution for high volume data.

· Should be able to pick any new technology, research it and implement it in short time frame.

· Should have Flexible, Professional Approach.

· Demonstrated team player with a results-oriented track record.

About RIA Advisory:

RIA Advisory (RIA) is a US based organization, with presence in multiple countries which focuses on ORMB product implementation for its enterprise fortune 500 clients. RIA is a product implementation partner in Banking, Payments, Capital Markets, Exchanges, Utilities, Healthcare, and Insurance industry verticals