Job DescriptionDatabase Administrator (PostgreSQL & MS SQL)
Experience6 8 yearsEmployment TypeFull-time ,WFO EducationB.E. / B.Tech in Computer Science or Information Science
About the RoleWe are looking for an experienced Database Administrator with robust expertise in PostgreSQL and MS SQL Server to join our Development team. The ideal candidate will take ownership of database development activities — from day-to-day maintenance and performance optimization to supporting application-side enhancements and working collaboratively with developers to deliver robust, scalable data solutions, while partnering with the Tech Services DBA on production-server matters.
Key ResponsibilitiesDatabase Maintenance & Operations•Perform routine database maintenance including indexing, vacuuming (PostgreSQL), and statistics updates to ensure optimal performance.•Monitor and manage database health,
proactively identifying and resolving bottlenecks and idle/long-running queries.•Design and implement data purging strategies to manage storage and maintain performance at scale.•Set up, schedule, and monitor database jobs and automated maintenance tasks.Application-Side Support•Collaborate closely with the development team to support database changes and enhancements aligned with application requirements.•Review and optimize existing stored procedures, indexes, and table structures for performance and correctness.•Write, test, and maintain complex stored procedures, views, and functions across PostgreSQL and MS SQL Server.Standards & Governance•Define and enforce database development standards across the team, including schema design, indexing strategy, key constraints, and naming conventions.•Contribute to the design and validation of any feature that touches the data layer, ensuring data-layer decisions are sound from the outset.Code & Schema