Specialist, Service Delivery Engineer-Systems...

Specialist, Service Delivery Engineer-Systems Admin/Engineering(Lead - Postgres)-(WD39621) Technology and Operations (T&O) enables and empowers the bank with an efficient, nimble and resilient infrastructure through a strategic focus on productivity, quality & control, technology, people capability and innovation. In Group T&O, we manage the majority of the Bank's operational processes and inspire to delight our business partners through our multiple banking delivery channels Job Duties responsibilities • Experienced with PostgreSQL & PostgreSQL Architecture • Managing PostgreSQL schema, tables, tablespaces and users, roles & groups. • PostgreSQL Index Management, Partitioning and System Catalogs • Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery. • Experience working with complex data warehouse projects • Experience designing custom ETL processes to populate the data warehouse • High-level knowledge of various industry-leading data warehouse components (databases,ETL tools, BI/reporting tools) • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime. • Participate in application development projects and be responsible for the database architecture and design • Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release. • Knowledge on PGAdmin and other PostgreSQL tools and utilities. • Knowledge on High Availability, streaming replication, Replication Failover, repmgr, barman, pgbouncer and pg_pathman. • Knowledge in maintenance activities such as vacuum, vacuum full, and analyze the database. • Understanding of basic database fundamentals: multi-version control, concurrency, transactions, indexing, locking. • Analyse, recommend, and implement configuration for Optimized Performance. • Ability to plan hardware capacity requirements for storage, memory, and CPU Cycles. • Expert with setting and trouble shoot replication issues. • Understanding of UNIX environment with shell scripting. • Familiarity with Linux administration • 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 • Excellent communication and problem-solving skills Required Experience • 10 to 15 years' experience in managing enterprise operations team • Experienced people leader with relevant technical skills to lead the team • Proven ability to mentor and grow the skill set of team members • Excellent communication, customer service, organizational, project and personnel management skills • Independent thinking and ability to demonstrate good judgment required Education / Preferred Qualifications • A degree in Computer Science or related subject is preferred Technical Competencies • Strong knowledge in Postgres database, backup/recovery of database, Disaster recovery plan. Personal skills • Strong matrix management skills including influence, conflict resolution and negotiation • Small to Medium team people management • Excellent relationship building and networking skills Additional skills • Team leadership, collaboration, decisiveness, energy and drive • 24 x 7 x 365 work culture