IN_Senior Associate_Database Developer_One Consulting_AppTech_Jaipur

Job Description & Summary: We are seeking an experienced Database Developer to join our team. The ideal candidate will have a strong background in database management systems, including RDBMS and NoSQL databases, with a deep understanding of PostgreSQL, MySQL, MariaDB, and SQL Server. This role requires a detail-oriented professional who can design, tune, and maintain databases to support our high-performance applications. You will work closely with application developers, providing guidance and support to enhance our data-driven projects.

Responsibilities:

Design and implement database schemas, ensuring their stability, reliability, and performance.

Develop and optimize SQL queries and stored procedures, improving system efficiency and data retrieval.

Provide technical guidance and support to application developers on database design, query tuning, and best practices.

Conduct code reviews and SQL query tuning to enhance application performance.

Manage RDBMS and NoSQL databases including PostgreSQL, MySQL, MariaDB, and SQL Server, ensuring optimal performance.

Install, configure, and maintain database systems; apply upgrades and patches to maintain system integrity.

Develop and implement SQL patches and oversee data migrations to ensure data accuracy and availability.

Proactively recommend system improvements to increase database performance and reliability.

Prepare and present reports on database health and performance statistics to both internal and external stakeholders.

Assist with large-scale data migration activities, ensuring minimal downtime and maximum efficiency.

Mandatory skill sets:

Working knowledge of RDBMS and NoSQL DB

Strong experience in PostgreSQL, MySQL, Maria DB, SQL Server etc.

Provide guidance and support to Application Developers

Assist with schema design, code review, SQL query tuning

Install, tune, implement and upgrade DBMS installations

Write and deploy SQL patches

Upgrade and improve application schema and data upgrades

Proactively and regularly make recommendations for system improvements

Collate, prepare and present statistical information and reports for internal and external use

Strong knowledge in Stored Procedure, Trigger, View, Cursor, large scale Data migration activities and performance tunning

Preferred skill sets:

Proficiency in JavaScript (ES6+), HTML5, and CSS3.

Familiarity with CI/CD pipelines and development best practices.

Years of experience required:

5-6 years

Education qualification:

BE/BTech/MCA/MTech

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Bachelor of Technology, Bachelor of Engineering

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

NoSQL

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Reasoning, Analytical Thinking, Application Software, Business Data Analytics, Business Management, Business Technology, Business Transformation, Communication, Creativity, Documentation Development, Embracing Change, Emotional Regulation, Empathy, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Assessment, Performance Management Software {+ 16 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date

Industries: Consumer Services, Information Services, Management Consulting