Diverse Lynx
Software Database Engineer - PostgreSQL
Diverse Lynx, Vega, Texas, United States, 79092
Software Database Engineer - PostgreSQL (Looking for Postgre Engineer)Onsite Position @ Las Vegas, Nevad
Project Scope:
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 RequirementsWS RDS hands-on experienceCapacity planning, performance assessment of AWS RDSsStrong Postgres/SQL Server DB administration experience in production environmentsConfiguration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global DatabaseExperience in managing multiple RDS, database versions on large systemsPractical experience in monitoringKnowledge of reporting and query tools and practicesExperience in using Performance Insights, RDS KPI design and management.Working knowledge of Lambda, PythonStrong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool and other related binaries.Physical Requirements
Sitting for extended periods of timeDexterity of hands and fingers to operate a computer keyboard and mousePhysically able to participate and lead training sessions, presentations and/or meetings.Reasoning and analyzing complex informationRegularly required to talk and hearOvertime may be required to meet deadlines
Educational background: Grad from CS/ EE or Eng. Equivalent
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Project Scope:
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 RequirementsWS RDS hands-on experienceCapacity planning, performance assessment of AWS RDSsStrong Postgres/SQL Server DB administration experience in production environmentsConfiguration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global DatabaseExperience in managing multiple RDS, database versions on large systemsPractical experience in monitoringKnowledge of reporting and query tools and practicesExperience in using Performance Insights, RDS KPI design and management.Working knowledge of Lambda, PythonStrong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool and other related binaries.Physical Requirements
Sitting for extended periods of timeDexterity of hands and fingers to operate a computer keyboard and mousePhysically able to participate and lead training sessions, presentations and/or meetings.Reasoning and analyzing complex informationRegularly required to talk and hearOvertime may be required to meet deadlines
Educational background: Grad from CS/ EE or Eng. Equivalent
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.