Sr. Database Developer (SQL, No-SQL, and Data Warehousing)

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.