TTECH

Database Analyst, Mid-level

TTECH

full-time

Posted on:

Location Type: Hybrid

Location: Barueri • 🇧🇷 Brazil

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

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
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