Postgre SQL DBA

  • Cognizant
  • Santa Ana, CA, USA
  • Nov 09, 2020
[Information Technology]

Job Description

Cognizant is hiring for PostgreSql DBA. Job description: Development and support activities for AWS PostgreSQL and on-premise PostgreSQL v9. Promote development changes from multiple test instances to production environments Establish, document, and implement database standards and procedures such as Processes/automation that ensures regular backups and recovery of databases Procedures to migrate DB from one environment to another Database security and policy guidelines Operating system and execution environment configuration to support DB operations. Support databases in accordance with established operational procedures including installation, Configuration, deploy DB in production environment, automated monitoring; troubleshoot, tune, optimize, and improve DB performance. Respond to security audit requests Support application development team's database needs (design, development, optimize queries, etc.) Provide database support as required for upgrades and development team support Support and maintain reporting websites and coordinate with web development team on website updates, enhancements. Qualifications and Experience Must Haves 5 years total professional experience as database administrator 3 years working with PostgreSQL version 9 hosted on Linux or Windows platforms. 2 years as a PostgreSQL database administrator designing and deploying PostgreSQL databases on Cloud platforms such as AWS and Azure. 3 years using instrumentation tools such as: pgAdmin, pgAudit, pgBadger, Nagios, OpenNMS, or vScout. 2 years performing database performance analysis, system and statement SQL tuning. 2 years as a senior database administrator supporting major configurations of highly available environments. Nice to Have Hands-on experience supporting Oracle v12C database Experience with automation deployment methods Experience with supporting DB development activities related to Microsoft .Net application development. Deploying databases in containers such as Docker. Experience in migrating non-PostgreSQL databases to PostgreSQL, such as MS SQL Server, Oracle, or MySQL.
Associated topics: data administrator, data analyst, data analytic, data center, data integration, data integrity, data quality, data warehouse, etl, erp