HR Service Delivery New Associate
Bengaluru
| Full time
| Experience: 0-2 years
Infra Tech Support Practitioner
Infra Managed Service Senior Analyst
|
Full time
|
Experience: 2-5 years
Job No. ATCI-5321363-S1947878
|
Gurugram
|
Required Skill: PostgreSQL Administration
Project Role : Infra Tech Support Practitioner
Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting.
Must have skills : PostgreSQL Administration
Good to have skills : Database Management, Microsoft SQL Server Administration
Minimum 3 year(s) of experience is required
Educational Qualification : 15 years full time education
Summary: We are looking for an experienced Azure PostgreSQL Flexible Server Database Administrator with strong expertise in managing and optimizing PostgreSQL workloads on Azure Database for PostgreSQL Flexible Server. The ideal candidate should have solid experience in BAU operations, performance tuning, vacuum/autovacuum management, HA/DR failover-failback procedures, and Azure-specific operational tasks. Proficiency in SQL along with Postgres SQL Roles & Responsibilities: - Manage Azure Database for PostgreSQL – Flexible Server deployments including provisioning, configuration, scaling, and upgrades. - Proficiency in SQL along with Postgres SQL. - Perform BAU activities such as: Regular health monitoring, Backup / restore validations, User & role management, Query performance checks and Storage and compute monitoring. - Configure and tune PostgreSQL server parameters via Azure portal, CLI, or ARM templates. - Perform deep-dive performance analysis using: pg_stat_statements, Query execution plans, Slow query logs and Waits, locks, and contention analysis. - Optimize: Query execution, Indexing strategies, Table partitioning and Memory settings (work_mem, shared_buffers, autovacuum memory tuning) - Identify and resolve performance bottlenecks across CPU, storage IOPS, latency, and networking. - Monitor and tune Autovacuum worker processes, thresholds, and scaling policies. - Perform manual vacuum/vacuum full/reindex to reduce bloat when necessary. - Maintain optimal health of tables and indexes to support performance. - Configure and manage Flexible Server built-in HA (zone-redundant HA). - Perform planned and unplanned failover operations, verifying: Data consistency, Application connectivity and Latency and performance post failover. - Plan and execute failback procedures ensuring minimal downtime. - Support cross-region disaster recovery via: Geo-restore, PITR and Automated backup strategy. - Validate automated daily backups, retention periods, and PITR. - Conduct on-demand and periodic restore testing for compliance and DR readiness. - Troubleshoot backup failures and I/O constraints during backup windows. - Implement RBAC and least-privilege access model. - Monitor audit logs and ensure adherence to internal and external compliance standards. - Provide L2/L3 support for PostgreSQL incidents - Work closely with application teams for performance issues and schema improvements. - Configurations, SOPs/Runbooks, Failover procedures and Environment diagrams - Participate in on-call rotation and planned maintenance windows. - Required active participation/contribution in team discussions. Professional & Technical Skills: - Must To Have Skills: Proficiency in PostgreSQL Administration. - Strong understanding of database management and optimization techniques. - Expertise in Query tuning & execution plan analysis; Autovacuum tuning & bloat management. - Failover/failback on Flexible Server HA; PITR & backup restore operations. - Strong Linux fundamentals or pgAdmin Tool. - Experience with backup and recovery strategies for PostgreSQL databases. - Familiarity with performance tuning and monitoring tools for PostgreSQL. - Good to Have: Experience with Azure cloud services like Azure Monitor, Azure Automation. - Experience automating database operations using Python, Bash, PowerShell. - Experience deploying PostgreSQL via ARM templates, Bicep, or Terraform. Additional Information: - The candidate should have minimum 3 years of experience in PostgreSQL Administration. - This position is based at our Gurugram office. - Must be willing to participate in 24x7 rotational support and cross skilling with other DBMS Technologies. - A 15 years full time education is required.
Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting.
Must have skills : PostgreSQL Administration
Good to have skills : Database Management, Microsoft SQL Server Administration
Minimum 3 year(s) of experience is required
Educational Qualification : 15 years full time education
Summary: We are looking for an experienced Azure PostgreSQL Flexible Server Database Administrator with strong expertise in managing and optimizing PostgreSQL workloads on Azure Database for PostgreSQL Flexible Server. The ideal candidate should have solid experience in BAU operations, performance tuning, vacuum/autovacuum management, HA/DR failover-failback procedures, and Azure-specific operational tasks. Proficiency in SQL along with Postgres SQL Roles & Responsibilities: - Manage Azure Database for PostgreSQL – Flexible Server deployments including provisioning, configuration, scaling, and upgrades. - Proficiency in SQL along with Postgres SQL. - Perform BAU activities such as: Regular health monitoring, Backup / restore validations, User & role management, Query performance checks and Storage and compute monitoring. - Configure and tune PostgreSQL server parameters via Azure portal, CLI, or ARM templates. - Perform deep-dive performance analysis using: pg_stat_statements, Query execution plans, Slow query logs and Waits, locks, and contention analysis. - Optimize: Query execution, Indexing strategies, Table partitioning and Memory settings (work_mem, shared_buffers, autovacuum memory tuning) - Identify and resolve performance bottlenecks across CPU, storage IOPS, latency, and networking. - Monitor and tune Autovacuum worker processes, thresholds, and scaling policies. - Perform manual vacuum/vacuum full/reindex to reduce bloat when necessary. - Maintain optimal health of tables and indexes to support performance. - Configure and manage Flexible Server built-in HA (zone-redundant HA). - Perform planned and unplanned failover operations, verifying: Data consistency, Application connectivity and Latency and performance post failover. - Plan and execute failback procedures ensuring minimal downtime. - Support cross-region disaster recovery via: Geo-restore, PITR and Automated backup strategy. - Validate automated daily backups, retention periods, and PITR. - Conduct on-demand and periodic restore testing for compliance and DR readiness. - Troubleshoot backup failures and I/O constraints during backup windows. - Implement RBAC and least-privilege access model. - Monitor audit logs and ensure adherence to internal and external compliance standards. - Provide L2/L3 support for PostgreSQL incidents - Work closely with application teams for performance issues and schema improvements. - Configurations, SOPs/Runbooks, Failover procedures and Environment diagrams - Participate in on-call rotation and planned maintenance windows. - Required active participation/contribution in team discussions. Professional & Technical Skills: - Must To Have Skills: Proficiency in PostgreSQL Administration. - Strong understanding of database management and optimization techniques. - Expertise in Query tuning & execution plan analysis; Autovacuum tuning & bloat management. - Failover/failback on Flexible Server HA; PITR & backup restore operations. - Strong Linux fundamentals or pgAdmin Tool. - Experience with backup and recovery strategies for PostgreSQL databases. - Familiarity with performance tuning and monitoring tools for PostgreSQL. - Good to Have: Experience with Azure cloud services like Azure Monitor, Azure Automation. - Experience automating database operations using Python, Bash, PowerShell. - Experience deploying PostgreSQL via ARM templates, Bicep, or Terraform. Additional Information: - The candidate should have minimum 3 years of experience in PostgreSQL Administration. - This position is based at our Gurugram office. - Must be willing to participate in 24x7 rotational support and cross skilling with other DBMS Technologies. - A 15 years full time education is required.
15 years full time education
Gurugram
Equal Employment Opportunity Statement
All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.
Please read Accenture’s Recruiting and Hiring Statement for more information on how we process your data during the Recruiting and Hiring process.
We work with one shared purpose: to deliver on the promise of technology and human ingenuity. Every day, more than 775,000 of us help our stakeholders continuously reinvent. Together, we drive positive change and deliver value to our clients, partners, shareholders, communities, and each other.
We believe that delivering value requires innovation, and innovation thrives in an inclusive and diverse environment. We actively foster a workplace free from bias, where everyone feels a sense of belonging and is respected and empowered to do their best work.
At Accenture, we see well-being holistically, supporting our people’s physical, mental, and financial health. We also provide opportunities to keep skills relevant through certifications, learning, and diverse work experiences. We’re proud to be consistently recognized as one of the World’s Best Workplaces™.
Join Accenture to work at the heart of change. Visit us at www.accenture.com.
We have been alerted to the existence of fraudulent messages asking job seekers to set up payment to cover various costs associated with establishing employment at Accenture. No one is ever required to pay for employment at Accenture. If you are contacted by someone asking for payment, please do not respond, and contact us at india.fc.check@accenture.com immediately.