Postgres SQL DBA
Postgres SQL DBA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Title : Postgres SQL DBA
Location : Las Vegas NV Onsite
Full time position
Role Description:
Skills : Postgres AWS RDS DBA SQL Jira GitHub Ansible & Terraform.
Essential Job Functions
1012 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version preferably AWS experience 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 Opensource Database platforms Databases like PostgreSQL and AWS RDS
Working Knowledge of EDB Oracle SQL Server and AWS Day to Day operation on 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 on partitioning database
Experience with message queuing fulltext indexing and other highperformance data concepts
Experience in AWS environment management and knowledge of different tools for the same
Experience in Postgres SQL migration approach 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.
Handson 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
Position Requirements
AWS RDS handson 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.
Thanks
Pawan Singh
Sr. Technical Recruiter
Synchrony Cory Inc.
Employment Type
Full Time
