DB Developer
Apply NowCompany: Tata Consultancy Services
Location: Mississauga, ON L4T 4M6
Description:
Inclusion without Exception:
Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.
About TCS:
TCS is an IT services, consulting, and business solutions organization that has been partnering with many of the worlds largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is delivered through its unique Location Independent Agile delivery model, recognized as a benchmark of excellence in software development. A part of the Tata group, India's largest multinational business group, TCS employs over 612,000 of the worlds best-trained consultants in 55 countries. The company generated consolidated revenues of US $29 billion in the fiscal year ended March 31, 2024,and is listed on the BSE and the NSE in India. TCS' proactive stance on climate change and award-winning work with communities across the world have earned it a place in leading sustainability indices such as the MSCI Global Sustainability Index and the FTSE4Good Emerging Index.
Role Description:
Must be an excellent senior resource with an ability to solve problems Co-ordinate with team and share the status.
Required Skill Set:
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
Proficient in development and troubleshooting SQL/PL-SQL queries, functions, stored procedures, packages et al
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 conn ectivity
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.
Desired Skill Set:
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 et al.
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.
Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodations during the recruitment and selection process, please inform Human Resources.
Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.
Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.
About TCS:
TCS is an IT services, consulting, and business solutions organization that has been partnering with many of the worlds largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is delivered through its unique Location Independent Agile delivery model, recognized as a benchmark of excellence in software development. A part of the Tata group, India's largest multinational business group, TCS employs over 612,000 of the worlds best-trained consultants in 55 countries. The company generated consolidated revenues of US $29 billion in the fiscal year ended March 31, 2024,and is listed on the BSE and the NSE in India. TCS' proactive stance on climate change and award-winning work with communities across the world have earned it a place in leading sustainability indices such as the MSCI Global Sustainability Index and the FTSE4Good Emerging Index.
Role Description:
Must be an excellent senior resource with an ability to solve problems Co-ordinate with team and share the status.
Required Skill Set:
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
Proficient in development and troubleshooting SQL/PL-SQL queries, functions, stored procedures, packages et al
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 conn ectivity
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.
Desired Skill Set:
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 et al.
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.
Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodations during the recruitment and selection process, please inform Human Resources.
Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.