Software Development Senior Analyst

NTT DATA North America; Brampton; On-site; CAD 60,000 - 90,000; Full time

Benefits offered by this job

Employee Assistance Program (EAP)

Discount Perks

Job summary

NTT DATA North America is seeking a skilled database engineer to assess IPT/AMP databases, design automated purge/archive frameworks, and ensure compliant data retention and retrieval. You will collaborate across IT, application support, and business teams to implement robust logging, monitoring, and audit controls while validating performance and driving successful production deployments.

The role emphasizes end-to-end ownership from assessment through handoff, with a focus on high-volume

Qualifications

• Strong SQL and database development experience.
• 5+ yrs Experience working with large transactional databases.
• 5+ yrs Experience designing or implementing data archival and purge solutions.
• 5+ yrs Experience with scripting or application development.
• 5+ yrs Experience with database performance optimization and production deployment.
• Ability to independently take a solution through technical assessment, design, development, testing, deployment, and handoff.

Responsibilities

• Assess the existing IPT and AMP databases, including data structures, volumes, and dependencies.
• Define appropriate data retention, archive, and purge rules in collaboration with IT and business teams.
• Design and develop an automated data purge and archive framework for IPT and AMP applications.
• Ensure archived information is retained and retrievable for business, operational, and audit purposes.
• Implement logging, monitoring, error handling, reconciliation, and audit controls.
• Test the solution to ensure data integrity and confirm no impact to active application functionality.
• Support performance testing and validate database performance improvements.
• Develop deployment, rollback, and operational support procedures.
• Deploy the solution into production and support stabilization activities.
• Prepare technical documentation and provide knowledge transfer to the internal support team.

Skills

SQL

Large transactional databases

Data archival and purge

Scripting / application development

Database performance optimization

End-to-end solution delivery

Tools

SQL Server

Oracle

Job description

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.

Job Description:

• Assess the existing IPT and AMP databases, including data structures, volumes, and dependencies.
• Work with IT, application support, database, infrastructure, and business teams to define appropriate data retention, archive, and purge rules.
• Design and develop an automated data purge and archive framework for IPT and AMP applications.
• Ensure archived information is retained and can be retrieved when required for business, operational, and audit purposes.
• Implement appropriate logging, monitoring, error handling, reconciliation, and audit controls.
• Test the solution to ensure data integrity and confirm there is no impact to active application functionality.
• Support performance testing and validate expected database performance improvements.
• Develop deployment, rollback, and operational support procedures.
• Deploy the solution into production and support stabilization activities after implementation.
• Prepare technical documentation and provide knowledge transfer to the internal support team.

Basic Qualifications:

• Strong SQL and database development experience.
• 5+ yrs Experience working with large transactional databases.
• 5 + yrs Experience designing or implementing data archival and purge solutions.
• 5 + yrs Experience with scripting or application development.
• 5 + yrs Experience with database performance optimization and production deployment.
• Ability to independently take a solution through technical assessment, design, development, testing, deployment, and handoff.

Nice to Have:

• Experience with SQL Server and/or Oracle.
• Experience working with enterprise applications.
• Experience in high-volume supply chain or transportation environments.

This posting relates to an existing vacancy within our organization. NTT DATA provides a reasonable range of compensation for Canada-based positions. The starting pay range for this role is [60 $ CAD range]. Actual compensation will depend on a number of factors, including the candidate's relevant experience, technical skills, and other qualifications. This position is eligible for NTT DATA's Employee Assistance Program (EAP) and Discount Perks.

We do not use artificial intelligence tools to screen, assess, or select applicants.

About NTT DATA:

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.