Role Description:
We are looking for a qualified Database developer to design stable and reliable databases as per our company's need. You will be responsible for developing, testing, improving, and
maintaining new and existing databases to help retrieve data effectively.
As part of our team, you will work closely with developers to ensure system consistency.
Responsibilities:
- Set up, configure, manage & monitor database clusters with master, slave configurations, and failover.
- Cost optimization of Amazon instances using databases.
- Optimize database queries and ensure to table locking/deadlocks do not happen in production.
- Create and maintain database tables, views, indexes and triggers.
- Develop and maintain stored procedures.
- Knowledge of database design principles, query optimization, index management, and integrity checks, statistics and isolation levels.
- Experience in migration from SQL Server to Postgres.
- Work with all levels of development from analysis through implementation and support.
- Interact with business analysts and UI developers to establish/clarify their requirements
- Skilled at optimizing large complicated SQL statements & Stored Procedures.
- Measure database performance and troubleshoot complex database issues, IO bottlenecks.
- Good attitude towards work and flexibility are desired
Required Skills:
- 4-10yrs of experience in the Database Development
- Experience and Knowledge of multiple database like (SQL Server/Postgres/Mysql)
- Experience and Knowledge of installation, deployment and maintenance of DB's.
- Experience working on AWS
- Excellent verbal and written communication skills.
Education Qualifications:
Bachelor of Computer Science or equivalent
