Job Description
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
