Ruby Developer
Posted Updated 9
views
Description
Job Description
Role Purpose
We are looking for an experienced Senior Database & Ruby Developer with strong expertise in, SQL, PostgreSQL, Ruby, YAML, Linux, and scripting.
The ideal candidate will have 4+ years of IT experience with a strong foundation in relational databases, database programming, data modeling, query optimization, and application or automation scripting. The role requires hands-on experience working with Oracle and PostgreSQL databases, along with Ruby development in Linux-based environments.
͏
Key Responsibilities
Database Development and Management
- Design, develop, enhance, and maintain complex SQL code.
- Work extensively with Oracle Database environments.
- Design and maintain database objects such as tables, views, indexes, sequences, constraints, and stored procedures.
- Participate in database and data-model design activities.
- Analyze existing data models and recommend improvements based on application and business requirements.
- Develop efficient database scripts for data processing, migration, validation, and maintenance.
- Troubleshoot database-related production and application issues.
Performance Optimization
- Analyze complex SQL queries and identify performance bottlenecks.
- Apply appropriate indexing and query optimization techniques.
- Review execution plans and optimize database access patterns.
- Identify database performance issues and provide suitable technical solutions.
- Follow database development best practices to improve application reliability, maintainability, and performance.
Ruby and YAML Development
- Develop, enhance, and maintain applications, utilities, and automation scripts using Ruby.
- Work with YAML for application configuration and related development activities.
- Troubleshoot Ruby scripts and application components.
- Integrate Ruby-based components with relational databases and Linux-based systems where required.
Linux and Scripting
- Work effectively within Linux/Unix environments.
- Develop and maintain Shell scripts and/or Perl scripts for automation and operational requirements.
- Perform troubleshooting using standard Linux commands, utilities, logs, and process-management tools.
- Automate repetitive database, application, deployment, or operational activities through scripting.