Previous
PostgreSQL DBA
Next
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
|