Developer (tsc)

tsc United States 2025-03-12

Job posting number: #210887 (Ref:tsc-352163)

Apply Now Save this Job

Job Description

DB developer (SQL/PL-SQL)

• Strong understanding of structured and unstructured data and Oracle relational DB

• Experience in data handling and analysis to support building new reports and modifying existing ones

• Experience in reviewing Database (DB) migration requirements and analyzing source data models and legacy database platforms

• Experience in development, validation and maintenance of large, enterprise class applications leveraging Oracle SQL and PL/SQL

• Experience in authoring DB schemas, creation of entity relationship models, creation of optimized DML and DDL scripts, data loading

•

View Orignal JOB on: italents.net

Proficient in development and troubleshooting SQL/PL-SQL queries, functions, stored procedures, packages

• Experience in fine tuning and optimizing DB SQL and PL SQL queries & procedures to address data load and data quality issues

• Experience in development and enhancements of DataMart in OLAP schemas

• Experience in integration of enterprise applications (Java, .NET, HTML, Angular) and Servers with DB, JDBC/JNDI connectivity

• Exposure to Data warehousing concepts, SSIS, SSRS, ETL/reporting tools integrations, banking are good to have

• Exposure to Agile development and bug tracking tools like JIRA.

• Good communication and update the status to Senior management

Roles & Responsibilities

• Design and development of SQL/PL-SQL queries, functions, stored procedures, packages

• Implementation and Roll-out of on DB migration programs

• Setup and configure new Oracle DB schemas and perform data load; create and implement ER models

• Perform optimization and tuning of SQL/PL-SQL queries, packages, stored procedures, functions etc.

• Create DML/DDL scripts for data load, issue fixes etc

• Profile DB server usage, optimize and implement improvements wherever applicable

• Support application development teams to create and maintain enterprise applications

• Mentoring junior developers in the team and identify opportunities for product improvements, implementation of best practices.

• Work on application troubleshooting, perform root cause analysis as well as address identified issues

• Track the project status, issues, risks and updates timely with senior leadership.

Salary Range- $120,000-$130,000 a year

#LI-CO1

#LI-SN1

Apply Now Save this Job