Database Engineer

<div> <p><strong>The Team</strong></p> <p>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.</p> <p>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!</p> </div> <div> <h4><strong>Key Responsibilities</strong></h4> Database Design and Development:<br>• Creating database schemas that support business requirements and ensure data integrity.<br>• Developing and implementing databases, including defining tables, relationships, and indexes.<br>• Ensuring data is organized efficiently and eliminating redundancy.</div> <div>&nbsp;</div> <div>Performance Optimization:<br>• Writing and optimizing complex SQL queries to ensure efficient data retrieval and manipulation.<br>• Creating and managing indexes to improve database performance.<br>• Continuously monitoring database performance and making adjustments to enhance speed and efficiency.</div> <div>&nbsp;</div> <div>Database Management and Administration:<br>• Installing and configuring database management systems (DBMS) such as MySQL, PostgreSQL, Oracle, or SQL Server.<br>• Performing regular maintenance tasks, such as backups, restores, and updates.<br>• Implementing security measures to protect data, including encryption, access controls, and auditing.</div> <div>&nbsp;</div> <div>Data Modeling and Architecture:<br>• Designing data models that accurately reflect the business processes and data requirements.<br>• Planning and implementing the overall database architecture, including cloud-based solutions and distributed databases.</div> <div>&nbsp;</div> <div>Troubleshooting and Support:<br>• Diagnosing and resolving database-related issues, such as performance bottlenecks, data inconsistencies, and connectivity problems.<br>• Providing support to developers and other users who interact with the database, including writing documentation and providing training.<br>• Backup and Recovery:<br>• Developing and implementing backup strategies to ensure data can be restored in case of corruption or loss.<br>• Planning and executing disaster recovery procedures to ensure business continuity.</div> <div>&nbsp;</div> <div>Compliance and Standards:<br>• Ensuring that database systems comply with relevant laws and regulations, such as GDPR or HIPAA.<br>• Following and promoting best practices for database design, implementation, and management.</div> <div>&nbsp;</div> <div>Collaboration and Communication:<br>• Working closely with software developers, system administrators, and other IT professionals to integrate databases with applications and systems.<br>• Collaborating with stakeholders to gather and understand business requirements for database projects.</div> <div>&nbsp;</div> <div>Automation and Scripting:<br>• Writing scripts to automate routine database tasks and improve efficiency.<br>• Utilizing tools and technologies for automated deployment, monitoring, and maintenance.</div> <div>&nbsp;</div> <div>Continuous Improvement:<br>• Keeping up-to-date with the latest database technologies, trends, and best practices.<br>• Identifying and implementing innovative solutions to improve database systems and processes.</div> <div>&nbsp;</div> <div><strong>Requirements</strong></div> <ul> <li>5+ years of experience as a DBA, Bachelor’s degree in CS / Data Science or equivalent experience</li> <li>Fluent English (spoken &amp; written)</li> <li>Databases &amp; data warehousing (OLTP, ETL, multiple RDBMS)</li> <li>Big data processing, monitoring &amp; maintenance</li> <li>SQL + Python (Pandas, NumPy, Pydantic); R is a plus</li> <li>Data analysis</li> <li>Serverless data solutions</li> <li>BigQuery or equivalent cloud data warehouse</li> <li>Knowledge of operating systems</li> <li>Enterprise security &amp; IT fundamentals</li> <li>Basic understanding of machine learning</li> </ul> <p><strong>Competencies</strong></p> <ul data-start="865" data-end="1183"> <li data-start="865" data-end="911">Strong analytical &amp; problem-solving skills</li> <li data-start="912" data-end="961">High organization, planning &amp; time management</li> <li data-start="962" data-end="1012">Ability to manage multiple priorities/projects</li> <li data-start="1013" data-end="1061">Hands-on, ownership &amp; accountability mindset</li> <li data-start="1062" data-end="1117">Good communication, teamwork &amp; interpersonal skills</li> <li data-start="1118" data-end="1183">Detail-oriented, process-driven, continuous improvement focus</li> </ul> <h4>​​​​​​​<strong>What you’ll love:</strong></h4> <ul> <li>100% Remote</li> <li>Holidays Off</li> <li>Paid Time Off</li> <li>Health insurance assistance program</li> <li>&nbsp;Competitive Pay (USD)</li> <li>Excellent teamwork and work environment</li> <li>Training</li> </ul> <p>&nbsp;</p>