Consultant Technical Lead - PostgreSQL
Societe Generale
This job is no longer accepting applications
See open jobs at Societe Generale.See open jobs similar to "Consultant Technical Lead - PostgreSQL" Getro.org.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
This job is no longer accepting applications
See open jobs at Societe Generale.See open jobs similar to "Consultant Technical Lead - PostgreSQL" Getro.org.