[Hiring] Senior Database Engineer @CESIT

Role Description

We are seeking a highly skilled Database Reliability Engineer (DBRE) to join our Database Management team. This role is critical to ensuring the reliability, security, and performance of our PostgreSQL and cloud-based database environments. You will work across AWS platforms, optimize database operations, and contribute to long-term reliability engineering initiatives.

Key Responsibilities

Within the First 3 Months:

• Validate backup and recovery plans to meet RPO/RTO objectives for PostgreSQL and other DBMS environments.
• Support high availability and reliability across PostgreSQL AWS RDS/Aurora environments.
• Maintain database security through AWS IAM integration, parameter groups, and encryption standards.
• Monitor workloads and query performance for optimal system behavior.
• Confidently support operational needs of PostgreSQL environments on AWS.
• Participate in Database On-Call Rotation.
• Diagnose database issues at SQL and engine layers; collaborate with development teams for solutions.
• Identify automation opportunities using scripting, cloud-native tooling, or observability platforms.
• Perform performance tuning using EXPLAIN/EXPLAIN ANALYZE and monitoring tools.
• Learn and share knowledge of Kondragunta’s diverse application data landscapes (SaaS, OLTP, reporting, warehousing).

After 6 Months and Ongoing:

• Streamline procedures and develop robust documentation.
• Cross-train team members on PostgreSQL and cloud DBMS technologies.
• Mentor new DBREs/DBAs in best practices.
• Expand coverage to additional DBMS technologies: MySQL, SQL Server, DB2, MongoDB, Amazon Redshift, Neptune, DynamoDB, MemoryDB, ElastiCache/Redis, Snowflake.
• Develop cross-platform DBMS competency.
• Leverage AI-assisted analysis tools for root cause identification and observability.
• Contribute to reliability engineering initiatives improving resiliency, automation, and operational efficiency.

Technical Responsibilities & Competencies

• Manage and monitor PostgreSQL in production (on-premise and AWS-hosted).
• Operate AWS RDS/Aurora PostgreSQL (parameter groups, clusters, failover, backups).
• Perform audits on configuration, security, and resource utilization.
• Design and tune PostgreSQL schemas, queries, indexes.
• Maintain performance metrics (CloudWatch, Performance Insights, pg_stat views).
• Strong proficiency in SQL, PL/pgSQL.
• Implement security measures (IAM, KMS, SSL/TLS, role-based access).
• Automate tasks using Python, Bash, PowerShell, or AWS tools.
• Support backup/recovery strategies (PITR, snapshots, Aurora recovery).
• Understand availability/scalability concepts (replication, partitioning, PgBouncer).

Mandatory Skills

• PostgreSQL Administration in production (6+ years).
• Strong experience with AWS RDS/Aurora PostgreSQL.
• AWS RDS Certified Professional is preferred.
• Strong SQL and PL/pgSQL skills.
• Backup/recovery strategies and HA/DR concepts.
• AWS security practices (IAM, KMS, encryption).
• Performance tuning and query optimization.
• Scripting for automation (Python/Bash).
• Troubleshooting and root cause analysis.

Nice-to-Have Skills

• Experience with other AWS DBMS: MySQL, SQL Server, MongoDB, Redshift, DynamoDB, ElastiCache, MemoryDB, Neptune, Snowflake.
• Linux OS and shell scripting.
• Data warehousing and OLTP/OLAP patterns.
• Observability tools (pgBadger, Performance Insights).
• CI/CD, Infrastructure-as-Code (CloudFormation, Terraform, CDK).
• Familiarity with AI/ML-driven monitoring and automation.
• Agile/DevOps/SRE practices.

Minimum Qualifications

• Bachelor’s degree in a technical discipline or equivalent experience.
• 6+ years of PostgreSQL DBA/DBRE experience in 24×7 production environments.
• AWS RDS/Aurora PostgreSQL experience preferred.

Primary Skills

• AWS RDS/Aurora PostgreSQL
• PostgreSQL DBA/DBRE experience in 24×7 production environments
• Strong PL/SQL