···
Log in / Register
DBA
Indeed
Full-time
Onsite
No experience limit
No degree limit
Praça do Patriarca, 62 - Centro Histórico de São Paulo, São Paulo - SP, 01002-010, Brazil
Favourites
Share
Some content was automatically translatedView Original
Description

2clix is a young software development company with over 10 years of market experience, located in the northern zone of São Paulo. We are looking for motivated individuals to join the team responsible for evolving our flagship product. If you enjoy working with people, have a good sense of humor, and are responsible, we want to meet you! **About the position:** We are seeking a hands-on DBA with strong expertise in SQL Server and knowledge of PostgreSQL and MongoDB. You will be responsible for analyzing and optimizing database performance, performing basic tuning, reviewing/validating stored procedures prior to execution, and ensuring data integrity and governance. We seek an autonomous, reliable individual with a strong sense of urgency—someone who can start acting and organizing the environment without waiting for detailed instructions. Minimum 2 years of experience with SQL Server. **Key responsibilities** * Continuous performance analysis (primarily SQL Server; also PostgreSQL and MongoDB). * Basic tuning: indexes, statistics, execution plans, instance and database configuration parameters. * Validation and review of stored procedures, views, and queries before deployment to production. * Organization of primary keys (PKs) and foreign keys (FKs); identification of tables lacking indexes or having underutilized/redundant indexes. * Monitoring environment health (jobs, backups, disk space, alerts, blocking, deadlocks). * Creation/adjustment of backup, restore, and recovery testing routines (RPO/RTO). * Support for developers in writing high-performance queries and applying best practices. * Basic security: permissions, roles, essential auditing, and minimum compliance. * Documentation of the environment and applied changes. * Oversight of deployments and maintenance windows with a strong sense of urgency. **Mandatory requirements** * Practical experience as a DBA (mid-level), especially with Microsoft SQL Server. * Strong command of T-SQL, execution plan analysis, indexes (clustered/nonclustered), statistics, and performance troubleshooting. * Applied knowledge of PostgreSQL (Postgres): indexes, EXPLAIN/ANALYZE, VACUUM/ANALYZE/AUTOVACUUM. * Familiarity with MongoDB: document-oriented modeling, indexes, basic profiling, performance metrics. * Experience with backup/restore routines, jobs (SQL Agent), and basic monitoring. * Ability to work autonomously, prioritize tasks, and propose improvements. * Reliable, organized profile with a strong sense of urgency. **Nice-to-have qualifications** * Experience with Always On/replication (SQL Server), partitioning, and large-scale index/statistics maintenance. * Monitoring tools (e.g., SQL Server DMVs, Query Store, pg_stat_statements, Percona/MongoDB Compass). * Automation scripts (PowerShell, Bash) and schema versioning (e.g., Flyway, Liquibase). * Familiarity with cloud platforms (Azure SQL, RDS/Aurora, Atlas) and associated cost/performance considerations. * Observability (Grafana/Prometheus) and dashboard/alert creation. **Soft skills** * Proactivity and autonomy to “open the database and handle issues directly.” * Clear communication and collaboration with Dev/QA/Product teams. * Rigorous documentation habits and adherence to best practices. * Responsible attitude and ownership mindset. Contract type: PJ (individual contractor) Location: Hybrid (São Paulo) or 100% remote (to be agreed upon) Working hours: Business hours, with availability for occasional maintenance windows Benefits: * Birthday leave * Clude Saúde (health plan) * TotalPass (wellness program) * Partnership with higher education institutions

Source:  indeed View original post
João Silva
Indeed · HR

Company

Indeed
João Silva
Indeed · HR
Similar jobs

Cookie
Cookie Settings
Our Apps
Download
Download on the
APP Store
Download
Get it on
Google Play
© 2025 Servanan International Pte. Ltd.