Clara Tjhang’s Post

Hello Network, Happy Monday! ☀ 📢 I am referring to the following positions. If you are interested, please feel free to contact me and I will share the job description. #costarica #jobs #referral #FPA #BusinessConsultant #Oracle #Engineer #Financial #ITSupport #CyberRiskDefense #DataCompliance #DocumentManagement #ContentProducer

Position- Senior Software Engineer / Associate Tech Specialist Mode of employment- TPC Experience- 6 to 8 Years Job Description for Oracle DBA: •Proven experience as an Oracle DBA, including database installation, configuration, and administration. •In-depth knowledge of Oracle database architecture, features, and best practices. •Candidate must have good understanding on oracle Architecture and experience on database Performance Tuning. •Experience installing, configuring, modifying, and maintaining Oracle Relational Database Management Systems •Ability to perform Linux shell script programming and debugging. •Knowledge of Database queries/Optimization and partitioning techniques •Knowledge of how to create and maintain indexes. •Managing Database redundancies. •Candidate must have good communication skills. Responsibilities: •Hands on for installation/configuration and maintenance/performance of Oracle database servers. •They need to be very good at all things Linux as well. •Good to have knowledge of Oracle development/coding work. •Develop maintenance scripts for routine data import/exports (from production to development), flashback scripts (for QA testers), and monitoring scripts to send various health information. •Ability to Implement Security Best Practices to meet compliance requirements. •Planning, implementing and execution of database backups and disaster recovery scenarios. •Participate in service preparation call and demonstrate Service Delivery Process and Clarify Technical/Functional Queries •Conduct technical assessments, understand customer requirements and work collaboratively with multiple subject matter experts to support project success. •Proactively monitor database health and take preventive actions. •Perform upgrades of database and software. •Provide detailed technical documentation and troubleshooting steps for all engagements. •Advise and offer recommended practices for technical standards, guidelines, and quality control measures for enabling and implementing software systems. •Define technical task lists that align implementation efforts and tactical activities to the overall project goals and roadmap. •Developing maintenance scripts for routine data import/exports (from production to development), flashback scripts (for QA testers), and monitoring scripts to send various health information

***Hiring*** - Looking for Database Migration Specialist... Please see the below questionnaire, if you have relevant experience of 5-8 years, reach out to Joel - Jawahar Thangavel Large-Scale Migration Experience: Do you have experience with large-scale application and database migrations for DB2 and Oracle? (Yes/No) DB2 and Oracle Expertise: Are you proficient in working with DB2 and Oracle databases, especially in migration scenarios? (Yes/No) Dependency Mapping: Are you skilled in identifying and managing dependencies between applications and databases during migrations? (Yes/No) Data Validation and Integrity: Do you have experience implementing data validation and integrity checks as part of the migration process? (Yes/No) Downtime Management: Are you experienced in planning and executing migrations with strategies to minimize downtime? (Yes/No) Automation Tools: Have you used automation tools to streamline migration processes? If yes, which tools have you used? (e.g., Ansible, etc.) Post-Migration Optimization: Are you familiar with performance tuning and optimization of applications and databases following a migration? (Yes/No) Compliance and Security: Do you have experience ensuring compliance and managing security requirements during migration projects, particularly with sensitive or regulated data? (Yes/No) Troubleshooting and Issue Resolution: Are you skilled in identifying and resolving unexpected issues during migrations, especially for DB2 and Oracle? (Yes/No) Documentation and User Guides: Have you created documentation or user guides to assist team members with the migration process and ensure continuity? (Yes/No)

Do you know what a typical working day is in the life of a Database Administrator? How much of their day is spent on system health checks, monitoring performance metrics, and how much on meetings and successful backups? All these questions are answered by a DBA from Banca Intesa Beograd, who explained his workday and what it takes to be a successful DBA. Read more at the link below.

𝗪𝗵𝘆 𝗱𝗼 𝘆𝗼𝘂 𝗻𝗲𝗲𝗱 𝗱𝗼𝗰𝘂𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻 𝗼𝗳 𝘆𝗼𝘂𝗿 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗰𝗿𝗶𝘁𝗶𝗰𝗮𝗹 𝗮𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻? 📚 #Documentation 𝗼𝗳 𝗮 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀-𝗰𝗿𝗶𝘁𝗶𝗰𝗮𝗹 𝗮𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗶𝘀  crucial for any company seeking long-term stability, operational efficiency, and the ability to innovate. ⚙️ #Documentation - 𝗧𝗵𝗲 𝗸𝗻𝗼𝘄𝗹𝗲𝗱𝗴𝗲 𝗼𝗳 𝗵𝗼𝘄 𝘆𝗼𝘂𝗿 𝘀𝘆𝘀𝘁𝗲𝗺𝘀 𝘄𝗼𝗿𝗸  the nuances of their configurations, and their interdependencies with other software or hardware often fade as employees move on or as development teams shift focus. 🛠️ #Documentation - 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀-𝗰𝗿𝗶𝘁𝗶𝗰𝗮𝗹 𝗮𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗲𝗻𝗱 𝘁𝗼 𝗲𝘃𝗼𝗹𝘃𝗲 𝗼𝘃𝗲𝗿 𝘁𝗶𝗺𝗲 through patches and fixes, creating hidden dependencies and vulnerabilities. 👩💻 #Documentation - 𝗘𝗮𝘀𝗲𝘀 𝘁𝗵𝗲 𝗼𝗻𝗯𝗼𝗮𝗿𝗱𝗶𝗻𝗴 𝗽𝗿𝗼𝗰𝗲𝘀𝘀 for new developers or IT staff, reducing the time they spend learning the system from scratch. 🌐 #Documentation - 𝗜𝗻𝘃𝗮𝗹𝘂𝗮𝗯𝗹𝗲 𝘄𝗵𝗲𝗻 𝗰𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀 𝗰𝗼𝗻𝘀𝗶𝗱𝗲𝗿 𝗺𝗼𝗱𝗲𝗿𝗻𝗶𝘇𝗶𝗻𝗴 𝘁𝗵𝗲𝗶𝗿 𝘀𝘆𝘀𝘁𝗲𝗺𝘀 essential for identifying which parts can be safely retired, re-engineered, or integrated into new solutions. Enhance your Oracle Forms and Reports applications with our Status Assessment for deeper insights and optimization opportunities! 👉 https://shorturl.at/iiUkQ #OracleForms #Digitaltransformation #PITSS #Reports #Oracle

I didn’t know what an Integration Architect (IA) was before I applied to Oracle. The title was intimidating to me, but I still applied. For those who might not know, here’s a condensed version of what I do to support EHR implementation projects as an IA: - Identify project risks and facilitate mitigation plans with key decision makers - Investigate and drive issues to resolution - Develop a strategy and timeline for PROD and nonPROD domains - Ensure code levels are up to date and in alignment with client priorities - Refine change control and governance processes - Manage access to various systems for internal and external project teams Moral of the story: Don’t let an advanced title, job description, or company stop you from going after your next opportunity!

Any Recommendation ?

Quy trình Unified Audit 1)Linking select value from v$option where parameter='Unified Auditing'; Shutdown immediate exit cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME; 2) Tạo policy: BEGIN dbms_fga.add_policy( object_schema  => 'HR', object_name    => 'EMPLOYEES', policy_name    => 'EMP_AUDIT', audit_condition => 'SALARY > 1500', audit_column   => 'COMMISSION_PCT', handler_schema => 'EMP_SCHEMA', handler_module => 'ALERT_HR', enable         => TRUE, statement_types => 'SELECT,UPDATE,DELETE'); END; Kết quả truy vấn: KHÔNG HIỂN THỊ KẾT QUẢ AUDIT khi thực hiện select * from hr.employees;