Send me more jobs like this

Senior Software Engg - Systems

4 - 6 years
Posted: 2019-09-12

Industry
IT/Computers - Software
Function
IT
Role
Software Engineer/ Programmer
Posted On
12th Sep 2019
Job Ref code
07740287
Job Description

Sybase T-SQL developer

Location: Mumbai

Who are we looking for?
Looking for an Sybase T-SQL developer
Technical Skills:
Need strong Sybase Unix guys with min 6+ years of exp.

1. Enhance the existing application to rectify various data issues and data processes using UNIX shell scripts, Java, SYBASE TSQL and Power Builder.

2. Optimize store procedure performance, Shell scripts and Java code for Intra Day, Daily, Weekly and Monthly Production process for Business data transfer.

3. Maintain Code versions for Store procedure, shell script using software configuration tool like Bitbucket/Git.

4. Extensive involvement in design document relating to creation of tables, Procedures, Cursors and triggers for fixes/change requests.

5.Create various reports using TSQL, requested by the FO & MO Users.

6. Debug the Sybase SQL code to find the bottle neck and optimize them accordingly.

7. Achieve the performance issue in Sybase by optimising the Store procedures, converted the locking schema of the tables and created additional indexes.

8. Use shell scripts for parallel processes for creation of tables , indexes and triggers .

9. Doing Vertical / horizontal normalisation of data to gain performance.

10. Enhancement from FTP to SFTP in Unix, encrypting files using GPG keys, skip bad email while mailing.

11. Writing Unix shell scripts to upload data in Upstream Systems.

12. Create Control-M Job in Unix to email reports, and also create Control-M XML file in Unix to trigger the Control-M jobs.

13. Developed web base design to sync data between Sybase and Mainframe (AS400) .

14. Write shell script in Unix to connect to Sybase, and fetch report and control the change item list.

Process Skills:
  • Having knowledge of Agile methodology.
    Participates as a team member and fosters teamwork by inter-group coordination within the modules of the project.
    Effectively collaborates and communicates with the stakeholders and ensure client satisfaction


Behavioral Skills:
  • Resolve technical issues of projects and Explore alternate designs
  • Participates as a team member and fosters teamwork by inter-group coordination within the modules of the project.
  • Effectively collaborates and communicates with the stakeholders and ensure client satisfaction
  • Train and coach members of project groups to ensure effective knowledge management activity.


Qualification:
Education qualification: B.Tech, BE, BCA, MCA, M. Tech or equivalent technical degree from a reputed college.
APPS NICHE SKILLS - DATA ENGINEERING-SYBASE T-SQL DEVELOPER

About Company

Mphasis is a leading IT solutions provider, offering Applications, Business Process Outsourcing (BPO) and Infrastructure services globally through a combination of technology knowhow, domain and process expertise. The accolades we have been garnering can be attributed to our undeterred focus in delivering quality solutions across verticals that meet the challenging requirements of our esteemed customers. We have been recently felicitated by the economic times as the most distinguished digital company 2015. We have also been ranked 29 of 100 largest financial technology vendors by American Banker and BAI in the FinTech Forward Top 100 rankings.
Similar Jobs
View All Similar Jobs


Walkin for you