Job Description

We're Hiring for

PL/SQL or T-SQL Developer

Experience :

3 to 5 years

Position Overview

We are seeking a highly skilled PL/SQL or T-SQL Developer with expertise in database design, data modeling, and the development of stored procedures. This role is ideal for a database professional who can contribute to the architecture and optimization of relational databases in enterprise environments.

Role & responsibilities

Database Design and Modeling:

Design and implement robust database schemas, including normalization, indexing strategies, and entity-relationship modeling using tools like ER/Studio, Visio, or SQL Server Management Studio (SSMS)/Oracle SQL Developer. Ensure designs align with business requirements, data integrity, and performance best practices.

Stored Procedure Development:

Develop, optimize, and maintain complex stored procedures, functions, triggers, and views in PL/SQL (Oracle) or T-SQL (SQL Server). Focus on efficient query execution, error handling, and transaction management to support high-volume data operations.

Performance Tuning and Optimization:

Analyze and tune SQL queries for performance, utilizing execution plans, indexing, and partitioning. Identify bottlenecks in database operations and implement solutions to enhance scalability.

Data Integration and ETL Processes:

Build and maintain ETL (Extract, Transform, Load) pipelines using SSIS (for SQL Server) or Oracle Data Integrator/Data Pump (for Oracle), ensuring seamless data flow between systems.

Collaboration and Documentation:

Work closely with Solution Architects, developers, and QA teams to integrate database components into applications. Maintain comprehensive documentation of database designs, models, and code.

Troubleshooting and Maintenance:

Debug and resolve database-related issues in production environments, including data migration, backups, and recovery strategies.

Best Practices Implementation:

Adhere to security standards (e.g., role-based access, encryption), version control (e.g., Git for scripts), and CI/CD pipelines for database deployments.

Required Qualifications

3+ years of professional experience as a Database Developer, with proven expertise in PL/SQL (Oracle) or T-SQL (SQL Server).
Strong background in relational database management systems (RDBMS), preferably with hands-on experience in Oracle Database or Microsoft SQL Server.
Proficiency in database design principles, including logical and physical data modeling.
Experience developing and optimizing stored procedures, with a focus on modular, reusable code.

Essential Skills

Advanced SQL querying and scripting in PL/SQL or T-SQL.
Familiarity with database tools such as SSMS, or Azure Data Studio Or Toad or PL/SQL Developer, .
Understanding of data warehousing concepts, including star/snowflake schemas.
Knowledge of performance monitoring tools like SQL Server Profiler or Oracle Enterprise Manager.
Ability to work in agile environments, with experience in version control and automated testing for database code.
Strong problem-solving skills, with the ability to translate business needs into technical database solutions.
Exposure to NoSQL databases (e.g., MongoDB) or cloud-based databases (e.g., Azure SQL, Oracle Cloud.
Interested and suitable candidates can contact / WhatsApp your Resume to HR :

9042051861

Job Types: Full-time, Permanent

Pay: ₹500,000.00 - ₹1,000,000.00 per year

Benefits:

Provident Fund Work from home
Application Question(s):

How many years do you have experience in Database Design and Modeling? How many years do you have experience in Data Integration and ETL Processes? How many years do you have experience in Stored Procedure Development? How many years do you have experience in Troubleshooting and Maintenance: Debug and resolve database-related issues in production environments, including data migration, backups, and recovery strategies? Do you have strong background in relational database management systems (RDBMS), preferably with hands-on experience in Oracle Database or Microsoft SQL Server? Are you familiar with database tools such as SSMS, or Azure Data Studio Or Toad or PL/SQL Developer? Do you have exposure in NoSQL databases (e.g., MongoDB) or cloud-based databases (e.g., Azure SQL, Oracle Cloud? Do you have Knowledge of performance monitoring tools like SQL Server Profiler or Oracle Enterprise Manager? It is mandatory to work from the office for 1 or 2 months to understand the project. After that, you can choose to work from home. Would you be willing to relocate to Coimbatore? (Mandatory) What is your current location? What is your current CTC? What is your expected CTC? (Is it negotiable) Are you in Serving Notice period? Are you a Immediate joinee? How soon you can join? (Mention days here) Why should we hire you? Have you gone through the job description, and does it exactly match your skill set?
Experience:

PL/SQL or T-SQL Developer: 3 years (Required)
Work Location: Remote