MS SQL Server Developer

Job Title : Perl Developer

Experience : 6+ Years

Engagement Type : C2C (Contract)

Location : Remote

Shift Timing : General Shift

Job Summary :

We are seeking an experienced Perl Developer with strong scripting and database expertise to support an application modernization initiative.

The role involves code conversion for compatibility between Sybase and MS SQL, ensuring performance, reliability, and maintainability of mission-critical systems.

You will work closely with the engineering team to enhance, migrate, and optimize codebases written primarily in Perl, with partial transitions toward Python for long-term sustainability.

Mandatory Skills :

Perl, Python, T-SQL, SQL Server, ADO, Git, Release Management, Monitoring Tools, Automation Tools, CI/CD, Sybase-to-MSSQL Code Conversion

Key Responsibilities :

• Analyze and convert existing application code from Sybase to MS SQL for compatibility and optimization.
• Maintain and enhance existing Perl scripts and applications.
• Where feasible, refactor or rewrite legacy components into Python for improved scalability.
• Collaborate with development and release teams to ensure seamless integration and deployment.
• Follow established Git/ADO version control and release management practices.
• (Optional) Contribute to monitoring, alerting, and automation improvements.

Required Skills :

• Strong Perl development experience (primary requirement).
• Proficiency in Python for code conversion and sustainability initiatives.
• Hands-on experience with T-SQL / SQL Server for database interaction and optimization.
• Familiarity with ADO/Git and standard release management workflows.

Nice to Have :

• Experience with monitoring and alerting tools.
• Familiarity with automation tools and CI/CD pipelines.

Primary Skills: Database Systems (SQL), Python Flask/Fast API/Django frameworks specifically
Requirements:

• Highly proficient in fundamentals of Python web development frameworks like Flask, Django and Fast API
• Demonstrated experience in developing APIs using Python frameworks
• Should have deep knowledge in PostgreSQL, MS SQL Server and other SQL based Databases
• Knowledge and proficiency in NoSQL is a bonus

Must Have Skills

• WPF Performance Suite

• .Net Framework

• C++

Good To Have Skills

• C# Studio

• C#. Net Logger

• MS SQL Server

• .Net Programming-C# .Net

Technical Lead - .NET

Responsibilities:

• Develop and deliver technical systems
• Maintain adherence to architectural standards/principles, global product-specific guidelines, usability design standards, etc.
• Participate in the development and review of documents to comply with SDLC methodologies [e.g., Engineering Work Breakdown Structure (WBS), estimation, Solution Design Document (SDD) and Software Architecture Documents (SAD)]
• Provide support and documentation to assist in sustaining the project during the transition to production where necessary
• Adhere to Application Engineering methodologies, standards, code reviews
• Provide feedback regarding application engineering methodologies, standards, and leading practices when appropriate
• Identify potential points of contention for missed activities and notify project leadership of situation and remediation plan
• Minimize technical exposure and risk on projects
• Provide technical guidance to development team members
• Technical deliverables (i.e., code and documentation) on projects assigned
• Translate detailed Requirements and Design and Solution Architecture deliverables into detailed design specifications
• Maintain effective and consistent communication within the team, with peers, the leadership team, and the peers in other IT groups
• Proactively raise issues to Technical and Group Leads when necessary
• Produce high-quality application engineering deliverables in accordance with the project timeline
• Build and unit test a project to detailed design specifications
• Provide thought leadership and technical guidance to engineering staff
• Review of code completed
• Review performance of developers
• Proactively anticipate project issues before they occur; define the problem; identify possible causes; work with the team to identify solutions; select and implement the most appropriate solution
• Apply judgment in implementing Application Engineering methodologies, processes, and practices to specific requirements of projects/programs which may include product design engineering, information security, code maintainability and reliability

Requirements:

Must Have:

• Bachelor’s OR master’s degree in a technical field and/or equivalent work experience
• At least 3 years acting a senior architecture / technical lead role in a comparable organization
• Significant experience of deploying large, enterprise-wide implementations to significant user volumes
• At least 5 years of hands-on experience leading a team of developers - defining work breakdown structures/tasks, assigning the teamwork items, monitoring, and ensuring quality and adherence to standards etc.
• At least 8 years of relevant hands-on work experience building, integrating, and delivering enterprise-wide web and windows applications using Microsoft and other technologies for large organizations on complex projects
• 8+ years of ASP.Net MVC, ASP.Net experience
• 8+ years of experience of working with applications that have a SQL Server backend
• 5+ years of experience with Object-Relational Mappers such as Entity Framework, ADO.NET, Dapper
• Expert level knowledge of .NET Web API is required. .NET Core knowledge is preferred, but Web API experience with legacy .NET is ok
• 5+ years of experience with GIT
• 3+ years of experience of Azure Devops
• In-depth knowledge of object-oriented analysis and design (OOAD) principles, and familiarity with many design patterns for Software applications.
• Demonstrated expertise in application design and construction, work breakdown structure of items, design and code reviews, unit test and build activities, deployment and performance related activities, documentation, support, and training/mentoring
• Excellent communication skills, verbal and written

Nice to have:

• Ideally experience working with SSRS, SSIS
• Experience with MongoDB or another document database would be a plus
• Knowledge and experience with working on N-Tier applications.
• Demonstrated ability to build strong working relationships
• Experience working on projects following Agile methodologies would be ideal
• Experience working with Azure or other cloud providers would be ideal
• Ability to work within diverse, global, virtual teams.
• Proven ability to thrive under pressure
• Some experience with design and prototyping tools and diagramming is desired

• Designs, develops, modifies, debugs, and evaluates programs for functional areas
• Analyzes existing programs or formulates logic for new systems
• Devises logic procedures
• Prepare Flowcharting
• Performs coding and tests/debugs programs.
• Develops Conversion and System implementation plans
• Prepares and obtains approval of system and programming of documentation
• Recommends changes in development, maintenance, and system standards
• Train users in conversion and implementation of system
• Communicate with end users and understands the requirements in clearly.

• Bachelor’s or master’s degree in engineering / MCA with 5+ years of solid software development experience using .Net environment using C#, VB.NET, ASP.NET, ADO.NET.
• Experience working with Manufacturing Execution System (Camstar) is a plus.
• Experience working with Web services and XML/ XSLT.
• In Depth knowledge of MS-SQL 2005/2008 including coding of SPs.
• Has a Solid background of Object-Oriented Analysis and Design and the use of UML views and diagrams.
• Has the ability to design and document software applications with minimal supervision.
• Experience in multi-platform software Development (DOS, Windows).
• Experience in developing software applications in a multi-tier architecture.
• Experience in presentation layer development using JavaScript, HTML, DHTML, Ajax and CSS.
• Experience in WCF / MVC is a plus.
• Experience is in Source Controls like SVN / TFS.
• Able to handle all phases of SDLC.

• Strong knowledge of .NET web frameworkwith .Net 3.5/4.0 Version.
• Experience on web-based projects using NET, C# and MS-SQL Server, JavaScript.
• Strong understanding of object-oriented programming.
• Skill for writing reusable libraries.
• Familiar with various design and architectural patterns.
• Knowledge of concurrency patterns.
• Familiarity with Microsoft SQL Server.
• Experience with popular web application frameworks.
• Familiarity with Windows Presentation Framework.
• Knack for writing clean, readable, and easily maintainable code.
• Understanding of fundamental design principles for building a scalable application
• Experience creating database schemas that represent and support business processes.

- 2+ years experience in application support on Asp.Net and SQL

- Should be able to debug production issues and bug fixes

- Should be able to write queries for extracting data using joins

- Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator

- Provide daily status updates and time-sheets to on-site and offshore project

- Ready to work in shifts

- Knowledge Transfer / Training to stakeholders

- Good communication skills

- Highly committed and able to work independently and as a team

- Positive attitude towards learning

- Deadline orientated and escalate in advance in case of delays 

- Contribute towards improving quality, standardization and documentation for all 

changes & Support activity

- Ability to remain calm in a fast-paced and highly pressure environment