Primary skill - AWS RDS, Postgres,Terraform with migration experience.
Location – ONLY CHENNAI
Shift details – 2nd Shift(Shift may end at either 10 : 30 PM IST or 11 : 30 PM IST.)
Client interview (Yes / NO) – Yes
- Name
- Contact No
- Email ID
- Total Experience
- Relevant Experience
- Current location
- Pref Location
- Current company
- CTC
- ECTC
- Notice Period
DBA : Activities :
AWS RDS Database Disaster Recovery SimulationPerform DB tests twice in a year using aws cliPeriodically Data restore testsDatabase engine upgrade (major / minor) - Heroku Postgres, AWS RDS Postgres, AWS Aurora PostgresCSDB / RODB manual feed extractionDBA Ops manually fetch data and provide information for RODB / CSDB data feeds for all AWS RDS databases routinely (this task will be automated)Monitoring / Performance tuningSequences monitor for AITs - quarterlyExtract and prepare Control Center users information from LLE for Authhub data feed - monthlyImplement ARM new / revoke access requests - frequentlyMonitor the databases and propose solutions for queries performance improvements - periodicallySupport / Troubleshooting / Resolve RDS DB production incidentsSupport for Application / QA teams - running queries in LLE to help them testing / validating / debugging - very frequentCompliance AuditProvide various database related evidence requested by AIT’s owners (required for RIMS-GRM, Trident survey, etc)Coding, debugging and maintenance for existing DB related controls (AWS lambda code (python))Infrastructure build of RDS in AWSCloudwatch alertsVarious lambda functionsRDS instancesGuardium / GIS DB Activity monitoring (we are working with various teams involved to implement and test GIS Guardium solution)Migration of databases from legacy AWS accounts to new AWS accounts. Support for creation of new RDS instances , initial setup (roles / users / schema), and data migration (using Postgres utilities (pg_dump / pg_restore) or AWS DMS)Migration of legacy code from Ruby to Java, involving data transformation and migration. DBA team is supporting application team with code reviews, queries tunning recommendations for data migration / validation, etc.Exago BI tool upgrade with transition from legacy metadata storage (files) to RDS DB storage. We are supporting new database initial setup and metadata migration.DBA Support during the releasesTools :
CircleCI ( CI / C pipeline)Terraform (for Infrastructure build)Jira ( ticket tracking)Git / GithubITSM - Remedy (incident tracking system)Confluence ( for documentation)Python / Bash ( for AWS scripts and task automation)AWS cloud servicespgAdminAWS CLIHeroku CLISplunk