Overview
We are seeking a skilled Data Engineer / Database Administrator with strong experience in PostgreSQL and Microsoft SQL Server. The ideal candidate will have hands-on expertise in Dynamic DDL and DML, managing complex database operations, and working with JSON data structures in PostgreSQL. This role involves ensuring database performance, reliability, and scalability while supporting development and data-driven initiatives across the organization.
Responsibilities
Design, implement, and manage PostgreSQL and MS SQL Server databases.
Develop and optimize Dynamic DDL and DML scripts for flexible schema and data operations.
Work extensively with JSON data in PostgreSQL (storage, indexing, querying, transformation).
Ensure data integrity, security, and high availability across environments.
Monitor, troubleshoot, and optimize database performance (queries, indexes, execution plans).
Collaborate with developers and analysts to support ETL processes, data pipelines, and reporting needs.
Maintain backup, recovery, and disaster recovery strategies.
Document processes, configurations, and database standards.
Requirements
Proven experience with PostgreSQL and MS SQL Server administration and development.
Strong knowledge of Dynamic DDL and DML scripting.
Hands-on experience working with JSON data structures in PostgreSQL.
Solid understanding of SQL query optimization and performance tuning.
Experience in database security, roles, and permissions management.
Familiarity with ETL processes, data pipelines, and integration with applications.
Strong troubleshooting and problem-solving skills.
Nice to Have
Experience with cloud-hosted databases (AWS RDS, Azure SQL, GCP Cloud SQL).
Knowledge of NoSQL or hybrid databases.
Familiarity with containerization and orchestration tools (Docker, Kubernetes).
Exposure to automation scripts for database operations (Python, Bash, PowerShell).
Job Type: Full-time