Responsibilities What you will do:
- 5+ Years of Postgres database experience Candidate should have high functioning knowledge of Linux Postgres Database Installation Design, configure, and manage Data Warehouse Database Systems Monitor and report on performance metrics, system health, and logging compliance
- Postgres performance monitoring and troubleshooting Experience with Postgres Data Loading Experience in working with Support Experience with Production Support and working on shifts/on-call rotation
- Perform database administration tasks including backup and recovery, troubleshooting, performance tuning and SQL optimization Design database schema, and tune data types and data distribution for performance optimization
- Configure, implement and tune workload management for resource allocation and query event handling Support users, and troubleshoot data access applications and ad hoc queries
- Proficiency in Unix OS and shell/perl/python scripting Evaluate new database technologies and products and recommend to technical management
- Contribute to document company database standards, guidelines and operational procedures
- Perform a variety of tasks relying on experience and judgment to manage time, plan and accomplish goals on several client engagements
- Provide 24 x 7 x 365 support through on-call rotation
Qualifications What you ll need:
- 5-8 years of experience in general database administration At least 4 years of experience managing and maintaining relational database technologies, such as Postgres required
- Working experience PostgreSQL database and its Functions usage
- Hands-on experience with PostgreSQL installation, configuration, and administration, starting and stopping database instance
- Hands-on experience with PostgreSQL database backup and recovery and archived Wal log management, crash instance recovery Good understanding and experience on PostgreSQL High Availability solutions like PostgreSQL replication and OS cluster active-passive setup installation & configuration
- Must know what database users and roles, permissions in PostgreSQL and their management
- Hands-on experience with PostgreSQL database Version upgrade and migrations
- Good Troubleshooting experience Familiarity with Greenplum database Knowledge of Hadoop is a plus Interact with vendor support to ensure open issues are resolved within defined SLA Understanding of Data Warehousing MPP architecture, technologies and concepts Ability to write and analyze complex SQL queries for performance Competence to read and interpret query plans, database statistics and database performance measurements and optimize SQL Proficiency in backup and recovery methodologies and techniques Ability to diagnose problems and resolve issues across various tiers (application, database , network and appliance) Adherence to SDLC, Change Management, troubleshooting and development methodologies Strong Unix/Linux and shell scripting Ability to perform work with minimal supervisory direction Excellent written and verbal communication skills Education/Certification: BS in Computer Science or related discipline or equivalent work experience required
