PostgreSQL Admin- Lead with AWS
Hello Everyone, Hope this mail finds you in the best of spirits!!! My name is Pavan and I work with SPAR Information System., I have a great opportunity for you, please find the job details below, if you are interested in applying please send me your updated resume and best time for you to discuss about this opportunity in details. Role: Lead DBA with PostgreSQL Location: Frisco ,TX or Alpharetta , GA Duration: Long term contract Required Skills & Qualifications • 5+ years of experience in PostgreSQL database administration, including performance tuning and troubleshooting. • 3+ years of hands-on experience with AWS RDS and related services (CloudWatch, IAM, S3, Lambda). • Strong understanding of SQL, PL/pgSQL, and query optimization techniques. • Experience with database monitoring tools (e.g., pgAdmin, Datadog, AWS CloudWatch). • Familiarity with Linux-based systems and shell scripting. • Knowledge of disaster recovery planning, high availability, and replication strategies. • Excellent problem-solving skills and ability to work under pressure in production environments. Preferred Qualifications • Experience with data migration from on-prem to AWS RDS. • Exposure to Terraform, CloudFormation, or other IaC tools. • Familiarity with DevOps practices and CI/CD integration. • Knowledge of PostgreSQL extensions (e.g., PostGIS, pg_stat_statements). Key Responsibilities • Design, configure, and maintain AWS RDS PostgreSQL instances for production and non-production environments. • Monitor database performance, identify bottlenecks, and optimize queries and indexing strategies. • Implement backup and recovery strategies, including automated snapshots and point-in-time recovery. • Manage database security, including user roles, access controls, and encryption. • Support operations teams with incident resolution, root cause analysis, and on-call troubleshooting. • Perform database upgrades, patching, and schema changes with minimal downtime. • Automate routine tasks using scripts and AWS tools (e.g., Lambda, CloudWatch, Systems Manager). • Collaborate with DevOps and development teams to support CI/CD pipelines and infrastructure as code. • Document database configurations, procedures, and operational runbooks. Thanks & Regards, Pavan Raikhelkar LEAD TALENT ACQUISITION SPECIALIST Direct Number:- Fax : Email: Website: (An E-verify Company) NOTE: We respect your online privacy. This is not an unsolicited mail. Under bill 1618 title III passed by the 105th us congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails, please reply with a "REMOVE" in the subject line. We apologize for any inconvenience caused by this mail. Apply tot his job