The Role
Designs, develops, administers, and optimizes databases and data warehouse systems. Responsibilities include schema and data model design, SQL performance tuning, backups and disaster recovery, security and compliance, troubleshooting, automation, cloud and serverless data solutions, and support for developers and stakeholders. The role also involves ETL, big data processing, monitoring, documentation, and continuous improvement across multiple relational database platforms.
Summary Generated by Built In
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 ResponsibilitiesDatabase 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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
- 100% Remote
- Holidays Off
- Paid Time Off
- Health insurance assistance program
- Competitive Pay (USD)
- Excellent teamwork and work environment
- Training
Skills Required
- 5+ years of experience as a Database Administrator
- Bachelor's degree in Computer Science, Data Science, or equivalent experience
- Fluent spoken and written English
- Experience with databases and data warehousing, including OLTP, ETL, and multiple RDBMS platforms
- Experience with big data processing, monitoring, and maintenance
- Proficiency with SQL and Python, including Pandas, NumPy, and Pydantic
- Experience with data analysis
- Experience with 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
- R programming experience
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
CodeRoad is a nearshore software development and technology-execution partner that helps organizations modernize applications, migrate to the cloud, build digital products, and implement enterprise AI. Its services span the full software development lifecycle, including dedicated engineering teams, platform engineering, data and AI infrastructure, legacy modernization, cloud architecture, quality automation, and DevOps. The company serves startups, enterprises, and private-equity portfolio businesses.
