Senior Database Engineer - #3190 (Remote)

CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs & Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and Investment Banks. These are long-term relationships of more than 10 years and are nurtured by not only our commitment to timely delivery of quality services but also due to our investments and innovations in their technology roadmap. As an organization, we are in an exponential growth phase with a consistent focus on continuous improvement, process-oriented culture, and a true partnership mindset with our customers. We are looking for the right qualified and committed individuals to play an exceptional role as well as to support our accelerated growth. You can learn more about us at: http://www.cesltd.com/ About the Role 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: o 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 Secondary Skills: - Experience with other AWS DBMS: MySQL, SQL Server, MongoDB, Redshift, DynamoDB, ElastiCache, MemoryDB, Neptune, Snowflake. Linux environments