Lead Administrator - L1

Role Purpose :Postgres SQL DBA ;Location :Pune

Exp :6+yrs relevant

Primary skill: PostgreSQL/Oracle/SQL DBA with extensive end-to-end administration knowledge, Python coding experience.

Secondary Skills: Azure DevOps hands-on experience.

Key Responsibilities:

1. Application DBA Expertise: Demonstrate deep expertise in application DBA, including managing complex business logic and migrations.

2. Technical Skills: Proficiency in PostgreSQL, Python, and DevOps, specifically for supporting migrations and release pipelines.

3. Migration Support: Provide support for the migration of business logic from the database to Databricks, collaborating with Databricks engineers and BAs.

4. Team Collaboration: Work closely with the existing team to ensure seamless integration and support for ongoing database work and migration processes.

5. Location Requirement: The position is primarily based in Pune, with Hyderabad as a secondary option, and requires five days a week in the office.

Qualifications:

- Proven experience as an Azure Database Engineer or similar role

- Strong expertise in application DBA, particularly with PostgreSQL

- Proficiency in Python programming and DevOps

- Ability to handle complex business logic and migrations

- Effective collaboration and communication skills

Do

• Provide adequate support in architecture planning, migration & installation for new projects in own tower (platform/dbase/ middleware/ backup)
  • Lead the structural/ architectural design of a platform/ middleware/ database/ back up etc. according to various system requirements to ensure a highly scalable and extensible solution
  • Conduct technology capacity planning by reviewing the current and future requirements
  • Utilize and leverage the new features of all underlying technologies to ensure smooth functioning of the installed databases and applications/ platforms, as applicable
  • Strategize & implement disaster recovery plans and create and implement backup and recovery plans
• Manage the day-to-day operations of the tower
  • Manage day-to-day operations by troubleshooting any issues, conducting root cause analysis (RCA) and developing fixes to avoid similar issues.
  • Plan for and manage upgradations, migration, maintenance, backup, installation and configuration functions for own tower
  • Review the technical performance of own tower and deploy ways to improve efficiency, fine tune performance and reduce performance challenges
  • Develop shift roster for the team to ensure no disruption in the tower
  • Create and update SOPs, Data Responsibility Matrices, operations manuals, daily test plans, data architecture guidance etc.
  • Provide weekly status reports to the client leadership team, internal stakeholders on database activities w.r.t. progress, updates, status, and next steps
  • Leverage technology to develop Service Improvement Plan (SIP) through automation and other initiatives for higher efficiency and effectiveness

Team Management

• Resourcing
  • Forecast talent requirements as per the current and future business needs
  • Hire adequate and right resources for the team
  • Train direct reportees to make right recruitment and selection decisions
• Talent Management
  • Ensure 100% compliance to Wipros standards of adequate onboarding and training for team members to enhance capability & effectiveness
  • Build an internal talent pool of HiPos and ensure their career progression within the organization
  • Promote diversity in leadership positions
• Performance Management
  • Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports.
  • Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below
• Employee Satisfaction and Engagement
  • Lead and drive engagement initiatives for the team
  • Track team satisfaction scores and identify initiatives to build engagement within the team
  • Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team
  • Exercise employee recognition and appreciation
    Mandatory Skills: PostgreSQL Database Admin .

    Experience: 5-8 Years .