Previous Job
Previous
PostgreSQL DBA
Ref No.: 21-00200
Location: Plano, Texas
  • In-depth knowledge of the PostgreSQL architecture
  • Experienced in installing, configuring, and upgrading Enterprise DB/Postgres databases and clusters.
  • Experience in configuring and supporting Enterprise Manager.
  • Setting up users' tools for administration. 
  • Experience in deploying Enterprise DB in Linux on Power environment and a good understanding of operating system concepts of Linux (RHEL).
  • Good knowledge of capacity planning and architecture design for database server deployment.
  • Proven experience in working in a mission-critical environment in a multi-terabyte database platform.
  • Working knowledge of architecting, configuring, setting up Enterprise Failover manager for HA solution.
  • Experience in setting up Enterprise DB Replication.
  • Working Knowledge of connection poolers (pgPool and pgBouncer)
  • Perform routine maintenance on several database environments including the application of updates, patches, and hotfixes
  • Installation/configuration and implementation of PEM, BART, xDB/EFM, Performance Dashboard.
  • Creating databases, migrating database objects from non-production to production environment.
  • Designing and building data models, schemas, views, and tables to support application requirements
  • Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium.
  • Extensive experience designing and executing backup and recovery concepts and procedures
  • Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning/
  • Experience in using Splunk, Nimsoft for Availability and performance.
  • Good understanding of licensing options and optimization.
  • Experience in scripting languages (shell or python or Perl) for automating DBA administrative tasks.
  • Experience with automation tools such as Control-M.
  • Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation.
  • In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
  • Provide 24 x 7 Support to Critical production systems.
  • Knowledge of Project Management Methodologies
  • Experience in working closely with the application development teams to resolve any performance-related issues and provide application support.

For any queries contact Kalyan at 760 463 9309