Simform Solutions - Database Developer (3-6 yrs)

Job Description :

Key Responsibilities :

- Database Design & Development : Design, develop, and optimize relational (SQL) and NoSQL databases based on business requirements.

- SQL & Query Optimization : Write complex SQL queries, optimize database performance, and implement indexing, partitioning, and query tuning strategies.

- Database Administration : Monitor and maintain databases to ensure performance, security, and high availability.

- Cloud Database Management : Deploy, manage, and optimize databases on cloud platforms such as AWS, Azure, or GCP.

- Stored Procedures & Triggers : Develop functions, views, procedures, triggers, and manage database security using DDL, DML, DCL, and DQL.

- Data Warehousing : Work with data warehousing solutions (Snowflake, Redshift, BigQuery, Synapse) for analytics and reporting needs.

- Data Migration & ETL : Support ETL processes and data migration strategies for efficient data movement across different systems.

- Backup & Recovery : Implement disaster recovery, replication, and backup strategies to prevent data loss.

- Troubleshooting & Debugging : Perform root cause analysis and troubleshooting of database and application issues.

- Collaboration & Support : Collaborate with development, DevOps, and infrastructure teams to integrate and enhance database solutions.

- Automation & Scripting : Utilize Python or other scripting languages to automate database management and monitoring tasks.

- Security & Compliance : Ensure databases comply with security best practices and industry regulations.

Required Skills & Qualifications :

- Bachelor's/Master's degree in Computer Science, Information Technology, or related field.

- Proven experience in SQL and relational database management systems (MySQL, PostgreSQL, SQL Server, Oracle, etc.).

- Hands-on experience with NoSQL databases (MongoDB, DynamoDB, CosmosDB, etc.).

- Expertise in database performance tuning and query optimization.

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

- Experience with ETL tools and data migration strategies.

- Strong knowledge of data modeling, indexing, partitioning, and replication.

- Understanding of data warehousing and analytics concepts.

- Experience with database monitoring tools and techniques.

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