PostgreSQL DBA

PostgreSQL DBALocation: Durham, NC.Duration: 12+ month long termThe Expertise You HaveDatabase lead with in-depth knowledge of Oracle, PostgreSQL including experience in system performance Tuning, SQL query analysis and strong scripting experience.Build, Deliver, Configure and maintain Oracle databases in AWS and Azure using industry standard deployment tools.Standardize and implement Cloud user management, security, capacity, monitoring and configuring application toolsDeploy, configure and maintain database on Azure and AWS Cloud using standard automation framework and observability tools.Experience working on various Cloud Options (AWS/Azure - both flavors - fully managed/IAAS including practical expertise in migrating databases from on-premises to public cloud.Expertise in Database Design, HA, Data Migration option, DR site strategy options keeping RPO and RTO requirements.Expertise in Golden Gate replication on Oracle Real Application Clusters (RAC) & ExadataSignificant background in solving complex technology challenges including solid troubleshooting skills with advanced performance SQL tuning expertise.Proven expertise in Realtime Application Testing, Oracle and PostgreSQL diagnostic tools.Experience in configuring Monitoring tools like Data Dog, OEM and proactive detection.Aurora PostgreSQL, Cosmos DB, Cockroach DB and other cloud native database skills preferredProvides technical leadership for Oracle Databases and other enterprise technologies.Participate in design reviews and unit testing. Work with the systems analysts to define requirementsExperience in shell scripting and keen eye to identify opportunities to automate operational tasks.Knowledge of Agile methodology including Scrum and Kanban. Ability to prioritize work and parallel tasking.Strong experience in production support and maintenance of high availability database systems with ability to manage large scale database projects.The Skills You BringYour ability to perform as team memberPassion for technology and do not limit yourself to a set of languages or frameworks.Proven track record of critical thinking and able to translate business needs into technology solutions.Ability to learn and support Oracle, SQL databases in cloudYour experience in proven delivery and proposing solutions, roadmaps and collaboratively defining solutions and the needed architecture to enable itYour ability to build support among key partners across business units for proposed strategies and solutions Samprasoft