Data Analyst at Telefónica Tech involving relational database analysis and improvements on Oracle and SQL Server. Responsibilities include installation, configuration, monitoring, and performance tuning of databases.
Responsibilities
Responsible for performing preventive and corrective analyses of relational databases, especially Oracle and SQL Server;
Plan and design the database to ensure optimal architecture, data integrity, and access security, identifying opportunities for improvement in design and usage;
Handle incidents, change requests and service requests;
Install, configure, upgrade and migrate database versions;
Apply patches to databases;
Monitor databases, perform analysis and performance tuning;
Administer replicas via Data Guard and Oracle GoldenGate;
Assist with contention points or excessive resource consumption;
Support and improve backup/restore routines;
Analyze infrastructure and perform capacity planning;
Skilled in query tuning;
Work in high-availability environments;
Create and automate technical reports to share with our clients;
Participate in War Rooms for resolution of critical incidents;
Analyze and update BI tool (Power BI – Microsoft)
Requirements
Completed higher education - degree certificate
Knowledge of ITIL v2 and v3 practices (Incident / Problem / Change Management)
Experience administering Oracle databases (Multitenant, In-Memory, Data Warehouse, Cloud, etc.)
Knowledge of other database technologies (SQL Server, MySQL, MongoDB, etc.)
Knowledge of Oracle GoldenGate
Experience with installation, configuration and maintenance
RMAN (backup/recovery strategies)
Export/Import - expdp/impdp
Real Application Clusters (RAC)
Data Guard (physical and logical)
Oracle Enterprise Manager
Benefits
Meal and food vouchers (VR, VA), medical and dental assistance, and life insurance;
An exclusive offer from Vivo, with special discounts on landline, broadband, TV and apps;
Eligible to receive an annual bonus or PPR (profit-sharing);
Plan your future through a private pension plan;
Have children? You will be entitled to a subsidy to help with school, daycare or nanny expenses;
Work in an environment that respects your personality, dress style and who you are, allowing you to be authentic. #VemdeVocê
Work remotely up to 3 times per week. #Mobility
Flexible working hours;
Enjoy a day off to celebrate your birthday (Day off);
Participate in one of the largest corporate volunteering programs to help you make a difference in the world;
Benefit from our Educational Development Program offering partnerships with educational institutions at discounted rates; certifications and online courses;
Boost your career through our Internal Recruitment Program, in Brazil or abroad—we are present in over 17 countries! #MinhaCarreira
And there’s much more! But you have to apply to find out...
Supply Chain Costing Analyst ensuring accurate costing processes and compliance with financial reporting for corporate accounting. Collaborating with internal teams and preparing for year - end audits.
Margin and Profitability Analyst at Abbott providing critical support to drive margin goals in the CRM division. Collaborating across teams to lead initiatives for productivity and cost improvements.
QA Analyst in hybrid role at EXFO, focusing on strategy and automation for testing solutions. Collaborating with development teams to ensure product quality and reliability.
Analista Portfolio II working on data treatment, dashboard generation using SQL, Phyton, and Power BI for Zurich. Aiming at analyzing KPIs and tracking results across digital channels.
Performance Analyst at Severn Trent Water improving river health through analyzing performance data. Collaborating with teams to enhance compliance and drive continuous improvements in water management processes.
Analyst ensuring data quality and reporting consistency in the bank’s financial operations. Responsible for data analysis and visualization supporting management decisions.
Senior Performance Analyst leading organic search initiatives and collaborating on paid search efforts at TELUS Santé. Optimizing digital footprint for traditional and AI - driven search landscapes.
Analyste en Approvisionnement au sein de MHIRJ, axé sur la performance des fournisseurs et la gestion des contrats. Développer des stratégies d'approvisionnement et maintenir des relations avec les fournisseurs.