AWS-RDS/EDB Postgres Engineer
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Job Description
Location: LAS VEGAS, Nevada (Day1 Onsite)
FTE Only
Position Summary
The AWS RDS/Postgres EDB Database Engineer performs independently or as a critical multi-functional team member in identifying, planning, developing, and deploying database applications and other technology solutions that can involve multiple physical locations and business units. The engineer also acts as the single point of contact for Postgres database administration and escalations for the Banking Industry project.
Summary Of Essential Job Functions
10-12 years of experience in managing Postgres databases (EDB Eco system) . 5 years of experience should be on the cloud version, preferably AWS, with expertise in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS.
- Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS.
- Hands on experience with managing EDB, and AWS Day to Day operations including S3, EC2, etc
Should be able to implement effective and maintainable database coding practices that form an architectural foundation.
Experience in Postgres SQL performance improvement, indexing/other approaches
Good experience in partitioning database
Experience with message queuing, full-text indexing, and other high-performance data concepts.
Experience in AWS environment management and knowledge of different tools for the same.
Experience in Postgres SQL migration approach from on-prem to AWS and vice versa, estimating it, and technically managing it.
Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys
Ability to efficiently write database code without compromising data quality, privacy, or security.
Hands-on Experience in Jira, GitHub, Ansible & Terraform.
Good understanding of CI/CD using GitLab
Good understanding of the Batch process and Job scheduling automation
Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels
Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds 1 Strong analytical, and interpersonal communication skills
Must possess good communication skills, both in verbal and in written form, and be Proficient in identifying, analyzing, and solving problems for Client facing experience
Proficient in identifying, analyzing, and solving problems and Client facing experience
Position Requirements
- AWS RDS hands-on experience
- Capacity planning, performance assessment of AWS RDSs
- Strong Postgres/SQL Server DB administration experience in production environments
- Configuration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global Database
- Experience in managing multiple RDS, database versions on large systems
- Practical experience in monitoring
- Knowledge of reporting and query tools and practices
- Experience in using Performance Insights, RDS KPI design and management.
- Working knowledge of Lambda, Python
- Strong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool and other related binaries.
Physical Requirements
- Sitting for extended periods of time
- Dexterity of hands and fingers to operate a computer keyboard and mouse
- Physically able to participate and lead training sessions, presentations and/or meetings.
- Reasoning and analyzing complex information
- Regularly required to talk and hear
- Overtime may be required to meet deadlines
Educational background: Grad from CS/ EE or Eng. Equivalent
Skill
Relevant years of exp
AWS RDS
5
On-Prem Postgres (EDB)
12
PL/pgSQL
8
Ansible
2
Linux
10
Shell Scripting
12
"Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at [email protected]."
Tech Mahindra represents the connected world, offering innovative and customer-centric information technology experiences, enabling Enterprises, Associates and the Society to Rise . We are a USD 4.9 billion company with 121,840+ professionals across 90 countries, helping over 935 global customers including Fortune 500 companies. Our convergent, digital, design experiences, innovation platforms and reusable assets connect across a number of technologies to deliver tangible business value and experiences to our stakeholders. Tech Mahindra is the highest ranked Non-U.S. company in the Forbes Global Digital 100 list (2018) and in the Forbes Fab 50 companies in Asia (2018).