Job Description
Must have expertise with Open Source Databases (like PostgreSQL, EDB) (Mandatory)
Total experience of 6-10 years with at least 3-4 years of experience in administration of Postgres/PPAS databases (Mandatory)
Experience with PostgreSQL technologies including Streaming Replication, High Availability, Backup and Recovery, Monitoring Tools and Maintenance Utilities such as Vacuum, Reindex (Mandatory)
Hands on with database performance tuning, sql tuning (Mandatory)
Have experience with upgrading databases (Mandatory)
Experience in setting up PostgreSQL High Availability solutions (Mandatory)
Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels (Mandatory)
Proactively monitor database performance, capacity, and security issues (Mandatory)
Propose recommendations for database optimization and improvements (Mandatory)
Participate in design reviews of architecture patterns for database deployments (Mandatory)
Diagnose and resolve production database issues (Mandatory)
Expert Level SQL, PL/pgsql, including stored procedures, functions, triggers, and views. (Mandatory)
Monitor and optimize SQL query performance (Good to have)
Evaluate emerging data & database technologies and recommend solutions (Good to have)
Knowledge of GIT, Gradle, Jenkins (Good to have)
Exposure to Agile/SCRUM methodology (Good to have)
Experience working in Cloud Environment (GCP/AWS) (Good to have)
Qualifications MCA/BTech/MTech with 5 - 8 years of experience
Employement Category:
Employement Type: Full time
Industry: Full time
Functional Area: IT
Role Category: Product Management
Role/Responsibilies: Database Administrator III
Contact Details:
Company: Kronos Incorporated
Location(s): Noida, Gurugram