Senior Database Analyst

Role Overview: You will be part of the Enterprise Database Management Team, supporting Oracle database systems and contributing to modernization projects. Required 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 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 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 KSA’s: • 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