Database Designer

Job Summary :

We are looking for an experienced Database Designer to design, implement, and maintain robust, scalable, and secure database solutions. You will work closely with software developers, data engineers, and business stakeholders to understand requirements and translate them into optimized database architectures.

Key Responsibilities :

- Develop and maintain ER diagrams, data dictionaries, and schema documentation.

- Create normalized and denormalized structures as needed to support application performance and reporting.

- Collaborate with development teams to integrate databases with applications and APIs.

- Optimize database performance through indexing, partitioning, and query tuning.

- Define and enforce data integrity, consistency, and security standards.

- Work with DBAs and DevOps on backups, monitoring, high availability, and disaster recovery planning.

- Maintain and evolve existing data models to meet evolving business needs.

- Ensure compliance with data privacy, security regulations, and governance standards.

Required Skills & Qualifications :

- Strong expertise in relational databases such as PostgreSQL, MySQL, SQL Server, or Oracle.

- Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB) is a plus.

- Solid knowledge of data modeling tools (e.g., ERwin, dbForge, Lucidchart, or MySQL Workbench).

- Proficiency in SQL, stored procedures, functions, triggers, and performance tuning.

- Understanding of data warehousing, ETL pipelines, and reporting systems.

- Familiarity with cloud databases (AWS RDS, Azure SQL, Google Cloud SQL).

- Excellent analytical, problem-solving, and communication skills.