Senior Database Developer

Job Title: Senior Database Developer

Experience: 4 - 6 Years

Job Type: Full-Time

Shift: 1:00 PM 10:00 PM

Job Location: Raysan, Gandhinagar, Gujarat

We are seeking a highly skilled Senior SQL Developer & Database Administrator to join our team. The ideal candidate will have over 5 years of hands-on experience in SQL database development and administration.

Skills Required:

Should have advanced database optimization techniques to improve system efficiency and performance. performance tuning and troubleshooting, resolving complex database issues promptly to minimize downtime.

Maintain database security measures to enhance data protection and compliance with industry standards.

Should have expertise SQL server tools, Always On setup, Linked Servers, tempDB, TSQL scripting, ETL process and data modeling, data recovery, OLAP cube,

Strong understanding of performance tuning and solving of data integrity issues, connectivity issues, and concurrency locking.

Implement database security measures including user management, SQL injection, and encryption.

Ability to install SQL server, PostgreSQL, SSDT, and proficiency in automation, batch, and PowerShell scripting.

SSIS Packages

Experience with spatial data.

Plan and execute database backups, and restore to ensure data integrity and continuity of operations.

Collaborate with cross-functional teams to integrate databases with other systems and applications.

Stay updated on emerging trends and technologies in database development and management to enhance skills and expertise.

MINIMUM QUALIFICATIONS:

Knowledge of Advance SQL Sever

Knowledge of PostgreSQL

Knowledge of ETL Process

knowledge of SISS packages

Roles and Responsibilities:

1.

Technical Leadership:

Provide technical leadership and guidance to the development team.

Make critical technical decisions and establish best practices.

Mentor and coach junior and mid-level developers.

2.

Architecture and Design:

Lead the design and architecture of complex systems.

Evaluate and recommend technology stacks and frameworks.

Ensure that the architecture aligns with business goals and scalability requirements.

Translate business requirements into software development tasks and guide jr. and mid-level software developers.

3.

Code Quality and Standards:

Set and enforce coding standards, quality guidelines and best practices.

Conduct regular code reviews and provide feedback.

Implement strategies to maintain and improve code quality and prevent repetitive issues.

Maintain a defect repository with detailed information on each reported issue.

Conduct audits to verify adherence to quality processes.

Validate that the software meets user requirements.

Verify that each development phase produces the expected outputs.

5.

Project Management and Delivery:

Take responsibility for the successful delivery of projects.

Collaborate with project managers on planning and resource allocation.

Mitigate project risks and troubleshoot issues as they arise.

6.

Collaboration with Stakeholders:

Engage with stakeholders to understand business requirements.

Communicate technical concepts to non-technical stakeholders.

6.

Innovation and Research:

Stay at the forefront of industry trends and emerging technologies.

Lead research and development efforts for new tools and technologies.

Propose and implement innovative solutions to business challenges.

Coordinate with GIS specialists to implement more advanced GIS functions/libraries.

7.

Performance Optimization:

Identify and address performance bottlenecks and optimization opportunities.

Conduct thorough performance testing and analysis.

Optimize code, databases, and system architecture for efficiency.

Perform capacity planning to ensure that cloud resources can handle the anticipated load.

Implement auto-scaling and load balancing solutions to handle varying workloads.

8.

Security and Compliance:

Ensure that the software development process follows security best practices.

Lead efforts to address and remediate security vulnerabilities.

Collaborate with compliance teams to meet industry and regulatory standards.

9.

Team Collaboration:

Foster a collaborative and positive team culture.

Work closely with cross-functional teams, including QA, DevOps, and support.

Encourage knowledge sharing and continuous learning within the team.

10.

Continuous Improvement:

Advocate for continuous integration and continuous deployment (CI/CD) practices.

Identify areas for process improvement and lead initiatives to enhance development workflows.

Drive efficiency improvements and automation in development processes.

Perform root cause analysis for defects and issues.

Identify systemic issues and work with teams to implement corrective actions.

Analyze data related to defects, test results, and process metrics.

Use data to make informed decisions and improve processes.

11.

Technical Documentation:

Ensure comprehensive and up-to-date technical documentation.

Document architectural decisions, design patterns, and system integrations.

Contribute to knowledge-sharing platforms within the organization.

12.

Communication:

Clearly communicate progress and challenges to team members.

Ask questions and seek clarification when needed.

Contribute to a positive and collaborative team culture.