Database Developer For Japanese Mnc Client

Job Description

Job description for Database developers having Postgres or MySQL Database expertise/database development ( Core SQL) These both are mandatory skills to be checked

 

Exp 2-4Yrs max

Location Noida

 

Major Responsibility/ Job Responsibility:          

 

* Create Stored Procedures, Functions, Triggers, etc.

* Process data migration to Postgres, SQL Server, and Oracle from various sources

* Verify and execute scripts developed by teams in Staging and Production environments

* Diagnose and resolve production issues

* Design, test and deploy database schemas

* Database performance tuning includes identifying bottlenecks with suitable workarounds

* Create & Implement custom SQL scripts to automate various database operations including data migration

* Create and maintain database documentation

* Create performance benchmark conformance report for newly developed and altered functions.

* Assist software developers in achieving performance benchmarks.

* Optimization of exiting database & business logic source code.

 

 

Key Result Areas:

 

Exposure to database design methodologies

Good problem-solving abilities

Good written and verbal communication skills

Ability to work in a team and individually

Good team Player

 

 

Necessary Qualification/ Technical Skills:

 

* 2-4 years of strong proficiency with SQL and its variation among popular databases like Postgres, MySQL

* Strong experience in Indexing, Functions & Stored Procedures

* Ability to write SQL scripts for data migration from sources like excel, MS Access, CSV/text file, etc.

* Should be able to troubleshoot SQL queries for performance tuning

* Skilled at optimizing significant complicated SQL statements

 

Desirable:

 

* Experience in short release cycles & complete software life cycle.

* Entire SDLC knowledge

* Demonstrated problem-solving, analytic, and troubleshooting skills.

* Familiar with tools that can aid with profiling server resource usage and optimizing it



Good to have:

Hive queries for data analysis



Most Prefered: only immediate or 1-week notice Period candidates.

Additional Benefits

• wifi/internet