DBA/ DB Engineer

Experience: 5+yrs

Job Location: Chennai (Candidates in and nearby Chennai can only apply)

Notice Period: Immediate Joiner to 30 days only

Candidate should be interested to take a Face to Face interview in Chennai

BE / B Tech / MCA / MSc / ME / M Tech in Computer

PostgreSQLver 11.X/10.X and later

MongoDBver 4.X and later

Database Design Principles

My SqlVer 8.X/5.X

Postgresql PL/pgSQL — SQL Procedural Language Scripting

Write and optimize queries, have enough experience in using various tools to monitor performance, security and fix them

Has experience in data migrations, ETL Processes, Reporting, Archival and Backup processes Identify bottlenecks and improve performance in SQL operations and corrections Monitor production logs, systems usage & operations of the production and staging environments databases

Ability to technically troubleshoot, diagnose, isolate and correct data, long running queries, debug dead lock scenarios and database issues Liaise with developers to improve applications and derive and establish best practices

Gather user requirements and identify new features

Develop technical and training manuals Provide data management support to users Research and suggest usage of new feature's in the application

Code Ability to do Data Modelling Physical Schema design for given Database Writing optimized SQL queries for integration with other applications Creating database triggers for use in automation

Maintaining data quality and overseeing database security

Fix any issues related to SQL /complex Query performance and provide corrective measures.

Create complex functions, mat.views/views, functions , stored procedures and triggers to support application development.