Source description
About the role
We are seeking an experienced Database Administrator (DBA) with strong hands-on expertise in PostgreSQL (80%) and Microsoft SQL (20%), along with solid working experience in AWS cloud settings. 46 years hands-on DBA experience. Robust expertise in PostgreSQL (must) and MS SQL Server (must). Experience working with AWS RDS, EC2, S3, IAM. Proficiency in SQL scripting, stored procedures, triggers, and performance tuning. Experience with database monitoring tools (CloudWatch, pgAdmin, SQL Profiler, Grafana, etc.). Familiarity with replication, clustering, and disaster recovery solutions. Understanding of networking concepts and cloud security best practices. Robust analytical, communication, and documentation skills. Key Responsibilities: Database Administration Install, configure, upgrade, and manage PostgreSQL and MS SQL Server databases. Perform database performance tuning, index optimization, query optimization, and resource management. Manage backup & restore strategies, log shipping, replication, clustering, and failover configurations. AWS Cloud Database Management Deploy, maintain, and optimize databases on AWS RDS / EC2. Manage parameter groups, monitoring, snapshots, backups, and cross-region replication. Ensure database high availability, scalability, and cost optimization in AWS. Monitoring & Troubleshooting Monitor system performance using AWS CloudWatch and other DB monitoring tools. Perform root-cause analysis for performance bottlenecks and production issues. Ensure proactive resource planning and capacity management. Security & Compliance Implement and maintain DB security, roles, permissions, and encryption. Ensure data compliance (GDPR, ISO, SOC, or client-specific standards where applicable). Maintain audit logs, vulnerability checks, and security patching. Collaboration Work closely with developers for schema design, query improvements, and deployment best practices. Support DevOps pipelines where necessary (CI/CD database migrations, automated deployments). Prepare technical documentation and database architecture diagrams. Location: Remote- Bengaluru,Hyderabad,Delhi / NCR,Chennai,Pune,Kolkata,Ahmedabad,Mumbai .