Job Description
PostgreSQL Database Admin
Location: O Fallon, MO
- Requires related experience in the design, maintenance, and administration of Postgres (Open Source, EDB and AWS Aurora).
- Highly knowledgeable of Postgres architecture and Internals for all Postgres flavours (EBD and AWS Auroara).
- Proficient with Postgresql installation and configuration, particularly Postgresql Plus Advanced Server from EnterpriseDB
- Observability and Monitoring - Proficient with Postgresql monitoring and alerting tools/processes specifically PEM from EnterpriseDB. Knowledge of Splunk, Dynatrace and similar tools.
- Experience in Postgres replication technologies. Proficient in setup, configuration and monitoring of Postgresql binary and logical data replication solutions (Binary Streaming, XDB and Bi-Directional Replication – BDR,..)
- Proficient with collecting diagnostics and tuning Postgresql as well as SQL tuning
- Proficient with Postgresql procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL
- Working knowledge of AWS Aurora. Install and configure Amazon Aurora instances.
- Perform debugging, tuning and performance enhancement as well as automation of operational and continuous integration aspect of the Postgres platforms. Can run EXPLAIN and do access path optimization.
- Proficient with collecting diagnostics and tuning Postgres as well as SQL tuning
- Implement and manage database version control using tools like Flyway.
- Use AWS services like CloudFormation, Lambda, and CloudWatch for orchestration.
Experience: 5-8 Years .
The expected compensation for this role ranges from $60,000 to $135,000 .
Final compensation will depend on various factors, including your geographical location, minimum wage obligations, skills, and relevant experience. Based on the position, the role is also eligible for Wipro's standard benefits including a full range of medical and dental benefits options, disability insurance, paid time off (inclusive of sick leave), other paid and unpaid leave options.
Applicants are advised that employment in some roles may be conditioned on successful completion of a post-offer drug screening, subject to applicable state law.
Wipro provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Applications from veterans and people with disabilities are explicitly welcome.
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.