07 Nov
|
loanDNA
|
Chennai
Job Overview: We are seeking an experienced and highly skilled Database Engineer to join our dynamic team. The ideal candidate will have over 3 years of hands-on experience in database development, management, architecture, migration, and optimization. Proficiency in SQL Server is mandatory, with additional expertise in NoSQL databases, Snowflake, and Cloud technologies considered a plus.
Key Responsibilities
• Database Development and Management:
•
• Design, develop, and maintain SQL Server and Other databases (MySQL, PostgreSQL).
• Write efficient, complex queries, stored procedures, and functions.
• Collaborate with application developers to design and optimize database structures.
• Implement and manage database security, backup, and recovery plans.
• Monitor and optimize the performance of the database systems.
• Database Architecture and Design:
•
• Design and implement database systems based on business requirements.
• Ensure database architecture aligns with enterprise standards and best practices.
• Create and maintain data models and database diagrams.
• Database Migration and Optimization:
•
• Plan and execute data migrations between systems, ensuring data integrity and minimal downtime.
• Optimize database performance through indexing, query tuning, and hardware/software configuration.
• Implement and maintain data replication and clustering solutions.
• Security and Compliance:
•
• Implement database security measures to protect sensitive data.
• Ensure compliance with relevant data protection regulations and policies.
• Conduct regular security audits and vulnerability assessments.
• Support and Troubleshooting:
•
• Provide technical support and troubleshooting assistance for database-related issues.
• Respond to and resolve database access and performance issues.
• Collaborate with development teams to assist with database-related application issues.
Qualifications:
•
Education:
•
• Bachelor’s degree in Computer Science, Information Technology, or a related field.
•
Experience:
•
• Minimum of 3 years of hands-on experience in database development, management, architecture, migration, and optimization.
• Proven experience with SQL Server is mandatory. MySQL, PostgreSQL are preferable.
• Technical
Skills:
•
• Robust knowledge of SQL and T-SQL scripting.
• Experience with NoSQL databases (e.g., MongoDB, Cassandra) is preferred.
• Familiarity with Snowflake data warehousing solutions.
• Experience with cloud platforms (e.g., AWS, Azure, GCP) and cloud-based database services.
• Knowledge of database security, backup and recovery, and disaster recovery procedures.
• Understanding of database replication, clustering, and high availability solutions.
• Soft
Skills:
•
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Detail-oriented with a focus on accuracy and quality. Preferred Certifications:
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Data Analyst Associate
• Snowflake SnowPro Certification
• AWS Certified Database
- Specialty
📌 Data Engineer (Chennai)
🏢 loanDNA
📍 Chennai