Database Reliability Engineer Pleno | Vaga Afirmativa para Pessoas Mulheres

As a Database Reliability Engineer Pleno at Creditas, you will be responsible for ensuring best practices in database utilization, particularly with SQLServer. This includes supporting our systems development team, troubleshooting performance issues, and monitoring database performance. You will also engage in automating tasks related to database management and assist in planning disaster recovery procedures, all aimed at optimizing the performance and reliability of our databases.

To qualify for the Database Reliability Engineer Pleno role at Creditas, candidates should have a strong background in UNIX/Linux environments, SQLServer, and performance troubleshooting of databases and applications. Additionally, familiarity with cloud environments, especially AWS, and intermediate SQLServer skills are essential. Experience with monitoring tools and possibly PostgreSQL, Apache Kafka, and MongoDB is highly regarded.

Yes, the Database Reliability Engineer Pleno position at Creditas requires availability to travel to our São Paulo office once every quarter. When required, candidates will need to be present during the first week for four consecutive days, referred to as Creditas in Person.

Creditas offers a range of attractive benefits for the Database Reliability Engineer Pleno role, including flexible meal benefits, collective life insurance, health and dental plans, access to corporate training, well-being sessions with psychologists, gym memberships, and generous parental leave policies. We also support work-life balance by providing options for remote or hybrid work models.

The selection process for the Database Reliability Engineer Pleno position at Creditas involves several stages: an initial conversation with our Talent Acquisition team, a technical assessment with our developers, and finally, a meeting with your potential leader. Our process is flexible, and we prioritize offering feedback at every stage to ensure a smooth candidate experience.

When addressing performance issues in databases, it's essential to start with identifying the specific problem areas using monitoring tools. I would evaluate query performance, analyze execution plans, and check for any locking issues. Additionally, I would also consider the database configuration and indexing strategies, making adjustments as necessary to optimize performance.

In managing database reliability, I prioritize tasks based on impact and urgency. I focus on critical production issues first, followed by routine maintenance tasks such as updates and monitoring. Regular communication with the development team helps ensure that I align my priorities with their needs, optimizing performance while minimizing downtime.

Certainly! My experience with SQLServer tuning includes optimizing query performance, adjusting indexes, and reviewing execution plans for efficiency. I also utilize SQL Server Profiler to identify bottlenecks and explore options for workload management to ensure that database resources are used effectively.

I prefer using tools like SQL Server Management Studio for real-time monitoring, alongside third-party solutions like SolarWinds Database Performance Analyzer for in-depth analysis. These tools provide comprehensive insights into database health, enabling proactive issue resolution and ensuring optimal performance.

Handling disaster recovery planning requires a structured approach. I begin by developing a clear recovery plan, identifying critical databases, and determining acceptable recovery time and point objectives (RTO/RPO). Regular testing of backup and restore procedures is crucial to ensure readiness in case of an actual failure.

One challenge I faced was dealing with unexpected spikes in database load that led to performance degradation. To overcome this, I implemented monitoring alert thresholds to proactively address load increases. Additionally, I advocated for scaling the infrastructure to better handle peak loads, which improved overall system performance.

I actively pursue continued education through online courses and webinars, and I regularly contribute to forums and communities where database professionals share insights. Furthermore, I stay updated on new features and best practices by reviewing documentation and engaging with vendor resources.

I have worked extensively with cloud databases, particularly AWS RDS for managing SQLServer and PostgreSQL instances. My experience includes setting up scalable environments, monitoring performance, and managing data backups in the cloud while ensuring security and compliance.

Automation is pivotal in my work as it allows me to reduce manual efforts and minimize human error. I use scripting languages, such as Python, to automate routine maintenance tasks, monitoring alerts, and backups. This not only enhances efficiency but also ensures consistency in database management practices.

My passion for database reliability stems from its critical role in an organization's success. Ensuring that data is efficiently stored, easily accessible, and secure drives me to constantly improve systems. I thrive on problem-solving and the satisfaction of impacting users' experiences positively through robust database management.