Senior Database Developer - PostgreSQL/NoSQL (4-7 yrs)

About the Job :

We are looking for a highly skilled and experienced Senior Database Developer to join our dynamic team. In this role, you will be responsible for designing, developing, and optimizing robust database solutions that support our critical business applications. You will leverage your expertise in PostgreSQL, NoSQL databases, and cloud platforms to ensure data integrity, security, and performance. We seek a proactive problem-solver with a passion for database technologies and a proven track record of delivering high-quality solutions.

Job Description :

As a Senior Database Developer, you will play a crucial role in the design, development, and maintenance of our database infrastructure. You will work closely with cross-functional teams to understand business requirements and translate them into efficient and scalable database solutions. Your expertise in PostgreSQL, NoSQL, and cloud database technologies will be essential in ensuring the smooth operation of our data-driven applications.

Key Responsibilities :

Database Design & Development :

- Design, develop, and optimize database schemas, tables, views, and stored procedures in PostgreSQL and NoSQL environments.

- Create and maintain data models that align with business requirements and ensure data integrity.

- Develop and implement database solutions that are scalable, reliable, and performant.

Data Pipeline Development :

- Build and enhance data pipelines for seamless data movement, transformation, and integration between various systems.

- Implement ETL (Extract, Transform, Load) processes to ensure data quality and consistency.

- Utilize data integration tools and techniques to connect disparate data sources.

Database Migration & Optimization :

- Develop and execute database migration strategies for smooth transitions across versions, platforms, or cloud services.

- Perform database performance tuning and optimization to ensure optimal query execution and resource utilization.

- Identify and resolve database performance bottlenecks and implement solutions to improve efficiency.

SQL Query Optimization & Troubleshooting :

- Write and optimize complex SQL queries, triggers, and functions for high efficiency and performance.

- Troubleshoot and resolve database-related issues, including query performance problems and data integrity violations.

- Perform code reviews of SQL code.

Data Integrity, Security, & Performance :

- Ensure data integrity, security, and performance tuning for optimal database functionality.

- Implement and enforce data security policies and procedures to protect sensitive information.

- Monitor database performance and implement proactive measures to prevent performance degradation.

Documentation & Collaboration :

- Maintain comprehensive documentation of database designs, processes, and best practices.

- Collaborate with application developers to integrate databases with business applications.

- Participate in code reviews and contribute to knowledge sharing within the team.

Backup, Recovery, & Disaster Recovery :

- Implement and manage backup, recovery, and disaster recovery strategies to ensure data availability and business continuity.

- Test and validate backup and recovery procedures to ensure their effectiveness.

- Automate backup processes.

Skills & Qualifications :

Core Skills :

- Expertise in PostgreSQL databases.

- Strong SQL skills for query optimization, troubleshooting, and database administration.

- Experience with NoSQL databases (e.g., MongoDB, Cassandra, Redis).

- Experience with database migration, performance tuning, and backup/recovery strategies.

- Experience with ETL processes.

Technical Skills :

- Proficiency in writing and optimizing complex SQL queries, stored procedures, triggers, and functions.

- Experience with database modeling and schema design.

- Familiarity with cloud platforms (AWS, Azure, Google Cloud) and cloud-based database services (e.g., Amazon RDS, Azure SQL Database, Google Cloud SQL).

- Experience with database administration tasks, including user management, security configuration, and performance monitoring.

- Knowledge of data warehousing concepts.

- Experience with database monitoring tools.

- Experience with database automation tools.

Soft Skills :

- Strong problem-solving and analytical skills.

- Ability to work effectively in a fast-paced and dynamic environment.

- Excellent communication and collaboration skills.

- Ability to work independently and as part of a team.

- Strong attention to detail.

Experience :

- 4+ years of experience in database development and administration.

Desired Skills :

- Experience with database automation and scripting.

- Knowledge of data warehousing and business intelligence concepts.

- Experience with containerization and orchestration technologies (e.g., Docker, Kubernetes).

- Experience with database security best practices.