- Job Responsibilities
- Design, implement, and maintain database schemas in PostgreSQL; perform data modeling to ensure efficiency, reliability, and scalability.
- Optimize and tune SQL queries for improved performance; identify and resolve performance bottlenecks in database systems.
- Manage data migration and integration processes between different systems; ensure data consistency and integrity during migration.
- Develop and maintain stored procedures, functions, and triggers to support application requirements and implement business logic within the database layer.
- Implement and maintain database security policies; manage user roles, permissions, and access control within the database.
- Implement and oversee database backup and recovery processes; ensure data availability and reliability.
- Collaborate with cross-functional teams—including application developers, system administrators, and business analysts—to understand database requirements.
- Create and maintain documentation related to database design, processes, and best practices.
- Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a Database Developer with a focus on PostgreSQL.
- In-depth knowledge of database design principles, normalization, and data modeling.
- Strong proficiency in writing and optimizing SQL queries.
- Experience with performance tuning and query optimization techniques.
- Familiarity with database security best practices and access control.
- Hands-on experience with data migration, integration, and ETL processes.
- Proficiency in scripting languages (e.g., Python, Bash) for automation tasks.
- Knowledge of backup and recovery processes.
- Excellent communication and collaboration skills.
- Ability to work independently and as part of a team.
- Preferred Skills
- Experience with PostgreSQL replication and clustering.
- Familiarity with NoSQL databases.
- Knowledge of cloud database solutions (e.g., AWS RDS, Azure Database for PostgreSQL).
- Understanding of DevOps practices and tools.
Skills Required
Devops, Aws Rds, Azure, Postgresql, Python