CodeRoad

Database Engineer

CodeRoad
Apply
8 months ago
Lima, PeruSenior

Responsibilities

  • Design database schemas, tables, relationships, indexes, data models, and database architectures
  • Develop and implement databases that support business requirements, data integrity, and efficient organization
  • Write and optimize complex SQL queries and manage indexes for database performance
  • Install, configure, maintain, monitor, and update database management systems
  • Implement data security measures including encryption, access controls, and auditing
  • Diagnose and resolve performance bottlenecks, data inconsistencies, connectivity problems, and other database issues
  • Develop and execute backup, restore, and disaster recovery strategies
  • Ensure database systems comply with relevant laws and regulations such as GDPR and HIPAA
  • Collaborate with developers, system administrators, IT professionals, and stakeholders on database projects and integrations
  • Write scripts and use automation tools for deployment, monitoring, maintenance, and routine database tasks
  • Provide database support, documentation, and training to developers and other users
  • Stay current with database technologies and implement improvements to database systems and processes

Requirements

  • 5+ years of experience as a database administrator
  • Bachelor's degree in computer science or data science, or equivalent experience
  • Fluent spoken and written English
  • Experience with databases and data warehousing, including OLTP, ETL, and multiple relational database management systems
  • Experience with big data processing, monitoring, and maintenance
  • Proficiency in SQL and Python, including Pandas, NumPy, and Pydantic
  • R is a plus
  • Experience with data analysis and serverless data solutions
  • Experience with BigQuery or an equivalent cloud data warehouse
  • Knowledge of operating systems
  • Knowledge of enterprise security and IT fundamentals
  • Basic understanding of machine learning
  • Strong analytical, problem-solving, organizational, planning, time-management, communication, teamwork, and interpersonal skills
  • Ability to manage multiple priorities and projects

Benefits

  • 100% remote work
  • Holidays off
  • Paid time off
  • Health insurance assistance program
  • Competitive pay in USD
  • Training

Tech Stack

Google BigQueryMicrosoft SQL ServerMySQLNumPyPandasPostgreSQLPythonRSQL

Categories

Data Engineering
CodeRoad

About CodeRoad

1-10 employees

CodeRoad is a privately held software services firm that delivers end-to-end development and infrastructure solutions for businesses. It offers nearshore staff augmentation, dedicated engineering teams, and general software engineering to help companies scale products and systems. The company operates on a services and consulting model, supporting clients that prefer flexible team extensions and managed delivery rather than building in-house capacity.

Contact me