TTECH

Database Analyst, Mid-level

TTECH

full-time

Posted on:

Location Type: Hybrid

Location: Barueri • Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

CloudMongoDBMySQLOracleSQL

About the role

  • 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...
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
OracleSQL ServerMySQLMongoDBData GuardOracle GoldenGateRMANquery tuningReal Application Clusterscapacity planning
Soft Skills
incident managementproblem managementchange managementcommunicationcollaborationanalytical skillsattention to detailorganizational skillscritical thinkingclient support
Certifications
degree certificateITIL v2ITIL v3