SQL Developer

1. Overall at least 8 years of experience working as a SQL Developer working various RDBMS. Must have exposure to basic database administrative activities.
2. Must have hands on experience working as a SQL developer proficient in PostgreSQL database for at least 3 years. Good to have exposure in other RDBMS/ NoSQL databases like Oracle, MySQL, MongoDb.
3. Extensive exposure working with database programmable objects like stored procedures, functions, triggers, views etc.
4. Collaborate with data engineers, developers and client team to design databases that can scale horizontally and vertically to accommodate increasing data volumes and user loads
5. Support Extract, Transform, Load (ETL) processes, ensuring that data is correctly ingested, transformed, and stored in a manner suitable for analytics and reporting.
6. Perform regular and on demand database maintenance, including backups, indexing, defragmentation, and optimizing storage and retrieval processes.
7. Optimize the performance of database systems through query tuning, database indexing, partitioning, and storage optimization to ensure fast and reliable access to data.
8. Identify and resolve database performance bottlenecks, troubleshoot slow queries, and improve data retrieval times for the dashboards.
9. Monitor database performance metrics, such as response time, query efficiency, and system resource usage, using appropriate database monitoring tools.
10. Data Access Control and Permissions
11. Implement role-based access control (RBAC) to manage and restrict data access based on user roles and responsibilities.
12. Good to have exposure working on High availability scenarios using PostgreSQL and/or other databases