Loading jobs…
Loading jobs…
Codec — Latin America
The Team At Coderoad, we're more than just a software development company—we're your gateway to the global tech world. Whether you're looking to skill up or level up your career, we offer the challenges you’ve been searching for. We provide end-to-end software development services and give you the opportunity to work on exciting, real-world projects in a supportive environment.
Whether it's staff augmentation, dedicated IT teams, or general software engineering, we have opportunities for everyone to challenge themselves and take their career to the next level!
Key Responsibilities
Database Design and Development: • Creating database schemas that support business
Requirements
and ensure data integrity. • Developing and implementing databases, including defining tables, relationships, and indexes. • Ensuring data is organized efficiently and eliminating redundancy.
Performance Optimization: • Writing and optimizing complex SQL queries to ensure efficient data retrieval and manipulation. • Creating and managing indexes to improve database performance. • Continuously monitoring database performance and making adjustments to enhance speed and efficiency.
Database Management and Administration: • Installing and configuring database management systems (DBMS) such as MySQL, PostgreSQL, Oracle, or SQL Server. • Performing regular maintenance tasks, such as backups, restores, and updates. • Implementing security measures to protect data, including encryption, access controls, and auditing.
• Planning and implementing the overall database architecture, including cloud-based solutions and distributed databases. Troubleshooting and Support: • Diagnosing and resolving database-related issues, such as performance bottlenecks, data inconsistencies, and connectivity problems. • Providing support to developers and other users who interact with the database, including writing documentation and providing training.
• Backup and Recovery: • Developing and implementing backup strategies to ensure data can be restored in case of corruption or loss. • Planning and executing disaster recovery procedures to ensure business continuity. Compliance and Standards: • Ensuring that database systems comply with relevant laws and regulations, such as GDPR or HIPAA.
• Following and promoting best practices for database design, implementation, and management. Collaboration and Communication: • Working closely with software developers, system administrators, and other IT professionals to integrate databases with applications and systems.
for database projects. Automation and Scripting: • Writing scripts to automate routine database tasks and improve efficiency. • Utilizing tools and technologies for automated deployment, monitoring, and maintenance.
Continuous Improvement: • Keeping up-to-date with the latest database technologies, trends, and best practices. • Identifying and implementing innovative solutions to improve database systems and processes.
5+ years of experience as a DBA, Bachelor’s degree in CS / Data Science or equivalent experience Fluent English (spoken written) Databases data warehousing (OLTP, ETL, multiple RDBMS) Big data processing, monitoring maintenance SQL + Python (Pandas, NumPy, Pydantic); R is a plus Data analysis Serverless data solutions BigQuery or equivalent cloud data warehouse Knowledge of operating systems Enterprise security IT fundamentals Basic understanding of machine learning Competencies Strong analytical problem-solving skills High organization, planning time management Ability to manage multiple priorities/projects Hands-on, ownership accountability mindset Good communication, teamwork interpersonal skills Detail-oriented, process-driven, continuous improvement focus What you’ll love: 100% Remote Ho