Database Analyst

V2Soft

$90K — $120K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 10+ years as an Oracle Database Administrator with expertise in PL/SQL.
  • 2+ years with Oracle 19c Multi-Tenant architecture and RAC databases.
  • Proficient in CDB/PDB environments and data masking standards.
  • Experience in Red Hat and Oracle Linux OS.
  • Strong skills in database performance tuning and automation scripting.

Responsibilities

  • Develop and maintain data masking standards for Oracle databases.
  • Define and configure masking rules in compliance with business needs.
  • Ensure data integrity across schemas during masking processes.
  • Create reusable templates and automation pipelines for data masking workflow.
  • Monitor and tune databases to ensure high availability and performance.

Benefits

  • Opportunity to work with advanced Oracle Exadata technology.
  • Participation in critical production support after hours.
  • Access to training and development for skills advancement.
  • Collaboration with cross-functional teams on data infrastructure projects.
Full Job Description
Experience:
  • 10+ years of experience as a Database Administrator with Oracle, PL/SQL.
  • 2+ years of experience with Oracle 19c Multi-Tenant. Architecture and database infrastructure design on RAC Databases.
  • Experience working with CDB/PDB environments.
  • Experience in Red Hat Linux & Oracle Linux Operating Systems.
  • Experience in following processes and procedures to standardize Database installations and configuration.
  • Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools.
  • Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c.
  • Comprehensive understanding of Oracle backup methodologies.
  • Monitor alert logs, OEM and system alerts, and acting on the Results.
  • Willingness to participate in after-hours Production support.
  • Proficiency in Linux, Unix, Java, and DBA.
  • Understanding of production environments, technical support, and troubleshooting.
  • Knowledge of Automatic Storage Management (ASM).
  • Experience with Oracle Exadata.
  • Experience working in UNIX operating system.
  • Ability to write simple to complex Linux/Unix shell scripts and Perl scripts.
  • Strong knowledge in Unix/Linux System administration.
  • Ability to work independently and to resolve complex Oracle Issues.
  • Experience with data pump and working knowledge to use expdp and impdp.
  • Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
  • Ability to write, SQL, PL/SQL, Oracle Stored Procedures functions, Packages and Database Triggers.
  • Ability to Tune Oracle SQL and PL/SQL performance.
  • Experience in logical database design and data models.
  • Understanding of the software development lifecycle process.
  • Practical experience in monitoring and tuning a database to provide a high availability service.
  • Experience with Oracle Enterprise Manager (OEM).
  • Knowledge of data privacy and protection initiatives.
  • Strong communication and collaborative skills.
  • Excellent verbal and written communication skills.
  • Knowledge of data masking using Test Data Management Tool to
  • Develop and maintain enterprise-wide data masking standards for Oracle databases
  • Define masking rules, algorithms, and transformation logic aligned with business and compliance requirements
  • Ensure masked data remains referentially intact across schemas and applications
  • Configure and execute masking workflows using the
  • organization's Test Data Management tool
  • Build reusable masking templates, rule sets, and automation pipelines
Preferred Skills:
  • Excellent working skills with Oracle Exadata and
  • 5+ years' experience with SQL performance tuning and database architecture.
  • Experience in converting traditional databases to Container Model - Oracle Multitenant architecture.
  • Experience working with Test Data Management Tool.

Similar Jobs

More Jobs at V2Soft

More Information Technology Jobs

Find similar Database Analyst jobs: