Job Title: Senior Database Engineer
Experience: 8+ Years
Location: Remote
Employment Type: Contract
Job Summary
We are looking for an experienced Senior Database Engineer with strong expertise in PostgreSQL, PostGIS, and MongoDB. The candidate will be responsible for database architecture, development, performance tuning, security, backup/recovery, and high availability for enterprise applications.
Key Responsibilities
- Design, develop, and manage PostgreSQL, PostGIS, and MongoDB databases.
- Develop complex SQL, PL/pgSQL, and PL/SQL queries and procedures.
- Work with geospatial data, spatial processing, and spatial indexing.
- Design MongoDB data models and aggregation pipelines.
- Perform query optimization and database performance tuning.
- Manage database backup, recovery, and disaster recovery processes.
- Implement database security, access controls, and compliance standards.
- Support high availability and database reliability.
- Work closely with application and development teams to optimize database solutions.
- Manage cloud databases such as AWS RDS, Azure PostgreSQL, and MongoDB Atlas.
Mandatory Skills
- PostgreSQL
- PostGIS
- MongoDB
- SQL, PL/pgSQL, PL/SQL
- Geospatial processing and spatial indexing
- MongoDB data modeling and aggregation
- Performance tuning and query optimization
- Backup & Recovery
- Database Security
- AWS RDS / Azure PostgreSQL / MongoDB Atlas
Preferred Skills
- Experience with enterprise-scale database environments.
- Knowledge of HA, disaster recovery, and cloud database architecture.
- Strong troubleshooting and problem-solving skills.
