Job Description
Role Purpose
͏
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.
͏
͏
͏
Mandatory Skills: OLTP Databases .
Experience: 3-5 Years .
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.