Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.
JOB DESCRIPTION
PostgreSQL Database admin requirement
Contract JC 51719
Location: O Fallon, Missouri
Max Bill Rate - 59 USD\H
Location flexibility: No
Shift Timing Regular
Top 2 Skills (Must have)
1 PostgreSQL
2 Oracle DBA
Good to have skills
1 Any other DBA Skills
Detail JD:-
when sharing profiles for PostgreSQL DBA, please specifically check for EDB Postgres Distributed knowledge and experience, this is must needed experience expected by customer.
PostgreSQL:-
Must gave have relevant experience and in-depth knowledge in any PostgreSQL administration task
A database administrator’s responsibilities can include the following tasks:
- Perform installations and upgrades of PostgreSQL (Preferably PPAS 9.4+)
- Plan and perform DB Patching.
- Knowledge of Database backups / Troubleshoot failures, query execution plans, performance tuning techniques
- Define maintenance plans.
- Configure / Troubleshoot Replication (BSR / xDB SMR / xDB MMR)
- Set up disaster recovery
- Perform Fail-over and Fail-backs
- Hands-on knowledge in Oracle to Postgres DB Migration
- Monitor servers through PEM
- Capacity planning
- Script database changes
- Knowledge of NOSQL databases
- Experience with latest versions PostgreSQL EDB versions
- User Administration and Security
͏
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
͏
Linked-in
Google