i
Careernet
22 Careernet Jobs
Senior Database Administrator - PostgreSQL (5-9 yrs)
Careernet
posted 1d ago
Fixed timing
Key skills for the job
Responsibilities :
- Design, configure, and manage Data Warehouse Database Systems.
- Monitor and report on performance metrics, system health, and logging compliance.
- Postgres performance monitoring and troubleshooting.
- 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.
- 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.
- 4+ years of Postgres database experience.
- The candidate should have high-functioning knowledge of Linux Postgres Database Installation.
- Experience with Postgres Data Loading.
- Experience in working with Support.
- Experience with Production Support and working on shifts/on-call rotation.
- Proficiency in Unix OS and shell/perl/python scripting.
- 5- 8 years of experience in general database administration.
- At least 4 years of experience managing and maintaining relational database technologies, such as Postgres, is required.
- Working experience with the PostgreSQL database and its Functions usage.
- Hands-on experience with PostgreSQL installation, configuration, and administration, starting and stopping database instances.
- Hands-on experience with PostgreSQL database backup and recovery and archived Wal log management, crash instance recovery.
- Good understanding and experience of PostgreSQL High Availability solutions like PostgreSQL replication and OS cluster active-passive setup installation and configuration.
- Must know what database users and roles, permissions in PostgreSQL, and their management.
- Hands-on experience with PostgreSQL database Version upgrades 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 the 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.
- B. E/ B. Tech/ M. Tech/ MCA/BCA. in Computer Science or related discipline or equivalent work experience required.
Functional Areas: Software/Testing/Networking
Read full job descriptionPrepare for Senior Database Administrator roles with real interview advice