RDS (PostgreSQL) Lead

Job Title : RDS (PostgreSQL) LeadJob Location : Los Angeles, CA(Hybrid)Job Duration :Long-term Contract(12+ months)Pay rate : $50/hr on W2 & $60/hr on C2CJob Description:Key Responsibilities:RDS PostgreSQL AdministrationManage Amazon RDS and Aurora PostgreSQL databases in productionPerform installation configuration upgrades patching and migrationsConfigure and manage MultiAZ deployments read replicas and failover strategiesMonitor database health using AWS CloudWatch Performance InsightsPerformance Tuning OptimizationAnalyze and optimize slow queries and execution plansTune PostgreSQL parameters sharedbuffers workmem autovacuum etcImplement indexing partitioning and query optimization strategiesHandle largescale highvolume transactional systemsBackup Recovery High AvailabilityImplement automated backups and PointinTime Recovery PITRDesign and test disaster recovery strategiesConduct periodic DR drills and failover testingCloud ArchitectureDesign scalable and reliable database architectures on AWSImplement InfrastructureasCode Terraform CloudFormationWork with VPC IAM S3 EC2 and networking componentsCollaborate with DevOps for CICD integrationSecurity ComplianceImplement database security best practices IAM roles encryptionManage encryption at rest and in transitEnsure compliance with enterprise security standardsConduct audits and vulnerability assessmentsTroubleshooting Production SupportProvide L2L3 support for critical production systemsPerform root cause analysis RCA for incidentsEnsure system uptime and SLA adherenceLeadership MentorshipLead a team of DBAs and engineersMentor team members and drive knowledge sharingEstablish standard processes and automation practicesRequired Skills QualificationsCore Database SkillsStrong expertise in PostgreSQL 8 yearsHandson experience with AWS RDS Aurora PostgreSQL 3 yearsDeep understanding ofQuery optimization execution plansWAL replication vacuum indexingHigh availability and failoverAWS Cloud SkillsStrong knowledge of AWS servicesRDS EC2 S3 IAM VPCExperience with monitoring tools CloudWatch Performance InsightsFamiliarity with cost optimization FinOpsAutomation ScriptingProficiency in Python Shell scriptingExperience with Infrastructure as Code toolsData IntegrationExperience withData migration tools AWS DMS pgdumprestoreETLELT pipelinesUnderstanding of data warehousing conceptsSoft SkillsStrong problemsolving skillsExcellent communication and stakeholder managementAbility to work in highpressure environmentsPreferred QualificationsAWS Certification Database Solutions ArchitectExperience with Aurora Global Database ServerlessExposure to Docker KubernetesKnowledge of Kafka or streaming platformsKey CompetenciesOwnership and accountabilityPerformance optimization mindsetLeadership and mentoringContinuous improvement and automationKPIs Success MetricsDatabase uptime and performanceReduction of incidents and MTTRSuccessful DR testing and recovery readinessEfficiency improvements in query performanceTeam productivity and deliveryNice to HaveExperience with Redshift SnowflakeKnowledge of eventdriven architecturesExposure to multicloud environments"Regards,Vishwajeet Verma