Manager | DBA - Hybrid Cloud | Bengaluru | Engineering | Hybrid Cloud Engineering
• Job requisition ID : 113981
• Location: Bengaluru
• Entity: Deloitte Touche Tohmatsu India LLP
Key Responsibilities
- Providing round-the-clock database support, including handling incidents, requests, and changes.
- Automating regular patch deployments, installations, and other routine tasks.
- Designing and developing scalable database architectures to meet business requirements, along with recommending hardware and network solutions.
- Optimizing data storage, retrieval, and indexing for improved performance efficiency.
- Ensuring data integrity, security, and compliance with industry standards.
- Collaboration with application developers, system administrators and other teams to enhance database operations and support.
- Use of Performance Monitor, optimizing queries, and tracing long-running queries, blockages, and deadlocks.
- Contribution towards automation of recurrent tasks.
- Ticket reduction through problem management.
- Hands-on experience of using tools/extensions
- Account management tasks include creating, deleting, and modifying profiles, as well as managing security and audit control parameters.
- Knowledgeable in index defragmentation, re-indexing, updating index statistics and query tuning.
- Proficient to manage DR and Resiliency strategies and underlying infrastructure architecture knowledge.
- Proficient in troubleshooting & solving complex performance problems.
- Proficient in managing Patching, Upgrades & Migrations.
- Proficient in monitoring & performance analysis through open source tools
- Working closely with application developers to optimize database interactions.
- Strong background to conduct proof of concepts (POCs) for new features and enhancements to reduce costs.
- Research and recommend new database technologies through POCs.
- Proficient in documenting database structures, policies, and procedures.
- Awareness to any of 2 public cloud platforms and responsible to integration designs from Tradi environments
- Responsible for design implementation and manage cloud-based database solutions.
- Manage projects and ensure technical solutions meet business needs. Provide guidance and mentor the team members.
- Proficient in managing migration other databases like MSSQL/Sybase/Oracle to PostgreSQL.
Key Skills Required
- Hands-on experience with database standards and end user applications.
- Experience on PG version – PG 12, PG 13, PG 14 & PG 15
- Excellent knowledge of PG RDBMS (all versions) architecture & design.
- Excellent knowledge of Architecture, Backup, Recovery (PITTR), Replication & Performance Tuning concepts.
- Experience in Backup and Recovery using PG_DUMP and PG_DUMPALL
- Experience in setting up WAL archiving, Point in Time Recovery
- Hands-on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer,
- Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf (with knowledge on Parameter values)
- Scripting knowledge using Ansibel and SHELL
- Proficient in troubleshooting & solving complex performance problems.
- Proficient in managing Patching, Upgrades & Migrations.
- Proficient in monitoring & performance analysis through open source tools
- Experience in handling Disaster Recovery tests & exercises.
- Certifications and experience of managing RDS for PostgreSQL on AWS
- Experience in working on a large-scale environment (at least 1000 + databases with bigger sizes).
- Working experience in banking domain (preferred).
- Expert knowledge of ITIL processes around Incident, Problem, Change, Quality Management and CSI.
- Exceptional coordination, communication and interpersonal skills to work across global teams and clients.
- Demonstrated ability to analyze, diagnose and assess problems; work with global stakeholders to derive tactical and long-term solutions as appropriate.
- Demonstrable crisis management skills in a large, globally distributed environment.
- Experience working with or in an automated operation environment
- Experience managing operations on core & cloud-based infra environments – ‘AaS platform’ experience ideal.
- Certifications and experience of managing RDS for PostgreSQL on AWS
- Hands-on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer
- Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf.
- Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
- Experience in Ansible, Shell / Perl / Python Scripting
- Proficient in managing Patching, Upgrades & Migrations.
- Proficient in monitoring & performance analysis through open source tools
- Education: Any Bachelors Degree