Description

Key Responsibilities

Database Design & Architecture: Design and implement scalable database schemas, tables, views, indexes, foreign keys, and constraints.

Advanced Query Writing: Develop, test, and optimize complex stored procedures, triggers, and functions using T-SQL, PL/SQL, or standard SQL.

Performance Tuning & Optimization (PTO): Analyze execution plans, resolve memory and CPU bottlenecks, manage index fragmentation, and tune slow-running queries.

Data Management & ETL: Build and support Extract, Transform, Load (ETL) workflows, data migrations, and data integration pipelines.

Code Reviews & Mentorship: Conduct peer code reviews for stored procedures and schema changes, ensuring adherence to coding and security standards.

Maintenance & Troubleshooting: Monitor server and database health, review error logs, troubleshoot agent jobs, and assist with backup and recovery processes.

Required Skills & Qualifications

Technical Stack: Deep expertise in relational database management systems (RDBMS) such as Microsoft SQL Server (T-SQL), PostgreSQL, Oracle (PL/SQL), or MySQL.

Proficiency in data modeling concepts, including Star Schema, Snowflake Schema, normalization, and denormalization.

Experience with native database performance monitoring and troubleshooting tools.

Version Control & CI/CD:



Familiarity with Git or equivalent version control systems and database deployment automation.

Soft Skills: Solid analytical and problem-solving abilities, capability to work independently, and effective cross-functional communication skills.

Education: Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 584386
- Project Location 1 : KRNK | BANGALORE
- Project Location 2 : Pan India
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : [email protected]
- Relevant Experience : 5 to 10+
- Mandatory skills : SQL, Oracle SQL, SQL Server, PostgreSQL, Stored Procedures, Query Optimization, Performance Tuning, ETL, Data Modeling, SAP S/4HANA, P2P, O2C, R2R, SAP Analytics.
- Desired skills : SAP Signavio - SQL Sr. Developer
- Domain (Industry) : IT
- BGC (Before onboarding / After onboarding) : PostOB
- Total Experience (Ex. 5-7 Years) : 5 to 10+ years of total IT experience
- BGC Details : NA
- BGC Vendor : NA
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : 09:00 AM TO 06:15PM
- Shift Timings : General

📌 ECMSRQ# 584386_SAP_ SQL Sr. Developer_ India
🏢 Trigent Software
📍 India