FCamara Consulting & Training

Senior 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

Senior

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, and plan future hardware/cloud resource needs (e.g., tablespace management, storage sizing).
  • Configure and maintain backup and data recovery processes (including simulations).
  • Application-Level Security: Manage database user accounts, roles, privileges, and access control for application-specific components.
  • Query Analysis: Use specialized tools (such as Explain Plan, AWR, or vendor-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 via CI/CD pipelines.
  • System-Level Security: Manage operating system and network security for database servers, and handle user/instance access and authentication at the system level.
  • Collaborate with developers and architects on 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 develop project activities related to this scope.

Requirements

  • Minimum 5 years of experience in similar roles.
  • Hands-on experience with enterprise databases such as Oracle and/or commercial SQL systems (on-premises and cloud).
  • Hands-on experience with open-source engines such as PostgreSQL and MongoDB (on-premises and cloud).
  • Lifecycle management experience 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 and 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 rotation.
  • Degree in Information Systems, Computer Science, or a related field.
Benefits
  • Position also open to candidates with disabilities

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 securityhigh availabilitydisaster recoveryroot cause analysislifecycle management
Soft skills
collaborationproblem-solvingcommunicationproactive improvementproject management