Sr. Database Developer (SQL, No-SQL, and Data Warehousing)
Join us in forging a path to greatness. ESDS is a crucible of innovation.
Job Summary:
We are seeking a skilled and detail-oriented Sr. Database Developer with 4 to 7 years of experience in designing, developing, and optimizing databases to meet business requirements. The ideal candidate will have strong expertise in PostgreSQL, MS-SQL, SQL Development, Stored Procedures (SP), Data Warehousing (DWH), and No-SQL systems. This role requires a proven ability to deliver performant, scalable, and secure database solutions while ensuring data integrity and accuracy.
Responsibilities:
Database Design and Development:
Design, develop, and optimize relational and No-SQL databases to support application and reporting requirements.
Develop complex SQL queries, stored procedures, functions, and triggers for efficient data retrieval and processing.
Build and maintain Data Warehousing (DWH) solutions for analytics and reporting.
Performance Optimization:
Analyze and optimize SQL statements, indexes, and database structures for performance tuning.
Troubleshoot and resolve performance bottlenecks in database systems.
Data Integrity and Security:
Ensure data accuracy, consistency, and security across systems.
Implement backup, recovery, and failover strategies for database reliability.
Collaboration and Support:
Work closely with application developers, business analysts, and data engineers to understand business requirements and deliver database solutions.
Support ongoing database administration tasks, including monitoring, maintenance, and documentation.
Required Skills and Qualifications:
Experience: 4-7 years of experience in database development and optimization.
Technical Expertise:
Proficiency in PostgreSQL, MS-SQL, and SQL.
Hands-on experience with Stored Procedures (SP), Functions, and Triggers.
Knowledge of Data Warehousing (DWH) concepts and development.
Familiarity with No-SQL databases like MongoDB or Cassandra.
Performance Tuning: Strong skills in query optimization and database performance analysis.
Tools: Proficiency with database management tools and scripting.
Soft Skills:
Excellent analytical and problem-solving abilities.
Strong collaboration and communication skills to work effectively with cross-functional teams.
Detail-oriented with a focus on data quality and performance.
Education:
Bachelor’s degree in Computer Science, Information Systems, or a related field.