Sr Database Reliability Engineer

Job Description

Senior PostgreSQL/Enterprise DB PPAS Database Administrator is responsible for overseeing the database administration functions of the Cloud services department. This position is responsible for database planning, design, and implementation, as well as the maintenance and optimization of PostgreSQL/Enterprise DB PPAS database supporting our Cloud application. This role will work closely with the DBAs, development, architecture and infrastructure teams to design and administer databases to provide and enforce contractual SLAs. Responsibilities Must to have Expert in Installation / configuration/ maintenance and Administration of PostgreSQL with an emphasis on EnterpriseDB versions. Disaster Recovery Planning and Implementation. Expert in developing scripts for a range of maintenance activities. Experience with Enterprise Failover Manager for HA is required. Must be able to patch/upgrade PostgreSQL in a HA architecture. Experience with EDB Replication preferred. Knowledge of connection poolers like pgPool and pgBouncer ideal. Thorough knowledge of database security best practices. Communicates effectively to both technical and non-technical individuals at various levels of customer and internal organizations. Working knowledge on EFM. Experience with Implementation in a Cloud Environment ideal. Expert in performance analysis and resolution. Works as a member of a 24 x 7 team. Knowledge of Planning and Implementing (scripting) backup strategies. Good To have Cloud SaaS (multi-tenant) environment experience preferred. Linux Administration (RHEL) experience preferred. Knowledge of Integration with 3rd party Monitoring Systems. Familiarity with Virtual Machine (or Docker) technology a plus. Excellent written and verbal skills. Expert in problem solving, planning, organization, and documentation. Ability to excel in a cohesive team environment. Experience with JDBC connection pools preferred. Uses consultative techniques and skills in their services delivery. Exposure to Cassandra or Astra will be an added advantage. Familiarity with Virtual Machine (or Docker) technology a plus. Configure and modify alert at SPLUNK. Create dashboards at Grafana. Qualifications The successful applicant will demonstrate good judgment in selecting methods and techniques for obtaining solutions. They will possess strong consultative abilities and communication skills which they will leverage to tie their technical recommendations to business benefits and process change. After initial training they normally require little instruction on their day-to-day work. BE/ B.Tech/ MCA or equivalent experience in Computer Science. PPAS Database, Enterprise DB Database Administrator Certified Associate or Professional Preferred. Above 3-5 years of experience working as an PostgreSQL/EDB PPAS DBA