Database Engineer

Job description

**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. Data Modeling and Architecture: • Designing data models that accurately reflect the business processes and data requirements. • 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. • Collaborating with stakeholders to gather and understand business requirements 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. **Requirements** - 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 - Holidays Off - Paid Time Off - Health insurance assistance program - Competitive Pay (USD) - Excellent teamwork and work environment - Training