Job Title:
Associate Technical Leader - Database
Experience:
7 - 9 Years
Job Type:
Full-Time
Shift:
1:
00 PM – 10:
00 PM
Job Location:
On-site, Gandhinagar, Gujarat .
We are seeking a highly skilled Technical Leader to join our team. The ideal candidate will have a strong background in SQL Server, PostgreSQL, SSIS packages. This role involves architecting and designing database solutions, guiding the team in complex scenarios, and ensuring best practices are followed in database management.
Key Responsibilities:
- Lead the architecture and design of scalable and robust database solutions.
- Provide technical guidance and mentorship to the database team.
- 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 and Manage SQL server, PostgreSQL, SSDT, and proficiency in automation, batch, and PowerShell scripting.
- Experience with spatial data -POST GIS.
- Plan and execute database backups, 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.
- Occasional extended shift hours may be required for emergency client support and after-hours
technical assistance, which could include working on Saturdays and/or Sundays.
Required Skills and Qualifications:
- Bachelor’s degree in computer science, Information Technology, or a related field.
- 7+ years of experience working with SQL Server and PostgreSQL.
- Knowledge of ETL Process
- knowledge of SISS packages
- Excellent problem-solving and analytical skills.
- Proven experience in leading technical teams.
- Strong English communication and collaboration skills.
Preferred Qualifications:
- Certification in SQL Server or PostgreSQL.
- Experience with cloud-based database solutions.
- Knowledge of DevOps practices related to database management.