FCamara Consulting & Training

DBA Database Administrator, Oracle, PostgreSQL, MongoDB

FCamara Consulting & Training

full-time

Posted on:

Location Type: Remote

Location: Remote • Brasil

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

MongoDBOpen SourceOraclePostgresSQL

About the role

  • Ensure that the databases supporting our client's applications operate securely, continuously and with high performance.
  • Implement operational processes and proactively recommend improvements aligned with best practices;
  • Capacity planning: monitor disk space, memory and CPU usage, planning future hardware/cloud resource needs (e.g., tablespace management, storage sizing);
  • Configure and maintain backup and data recovery processes (including drills/simulations);
  • Application-level security: manage database user accounts, roles, privileges and access control for application-specific components;
  • Query analysis: use tools such as Explain Plan, AWR or database-specific analyzers to diagnose slow queries and propose code fixes;
  • Deployment and change management: manage deployment of database schema changes and code updates alongside application releases, typically through CI/CD pipelines;
  • System-level security: manage operating system and network security for database servers, and handle access and authentication of users/instances at the system level;
  • Collaborate with developers and architects on the logical and physical design of schemas, tables, indexes and views to meet application requirements;
  • Improve monitoring and error-prevention methods (e.g., diagnostic or corrective automation);
  • Participate in and carry out project activities related to this scope.

Requirements

  • At least 3 years of experience in similar roles.
  • Hands-on experience with enterprise databases such as Oracle and/or SQL (on-premises, cloud);
  • Hands-on experience with open-source engines like PostgreSQL and MongoDB (on-premises, cloud);
  • Management of the software lifecycle for database engines and related components;
  • Backup and Recovery (DR/HA): design, implement and test backup and recovery strategies (RTO/RPO), and configure high-availability/disaster-recovery solutions (e.g., Data Guard, Always On, replication);
  • Experience working with software development teams to specify relational models, database structures, views and queries;
  • Troubleshoot operational issues and perform root cause analysis;
  • Availability to participate in a 24x7 on-call rota;
  • Degree in Information Systems, Computer Science or a related field.
Benefits
  • Not specified. 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score

Applicant Tracking System Keywords

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

Hard skills
database managementcapacity planningbackup and recoveryquery analysisdeployment and change managementsystem-level securitydisaster recoveryroot cause analysishigh availabilityrelational models
Soft skills
collaborationproactive improvementtroubleshootingcommunicationproject management