About Apexon:
Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.Apexon brings together distinct core competencies in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents.
We enable #HumanFirstDIGITAL
Job Description Summary
Overview
- Provide world-class support and expertise for Mastercards Postgres database environments.
- Mastercards Database Architects set the direction for enterprise leadership by designing and building highly available, scalable, and efficient solutions that adhere to standards and security policies.
- Represent Mastercards Database Engineering team as a subject matter expert in EDB Postgres, Postgres Distributed (PGD), and AWS relational database services.
- Continuously seek opportunities to improve efficiency and integrate technologies and platforms within the Postgres and related domains.
- Provide leadership and contribute to technology roadmaps supporting Mastercards vision for Postgres and other relational database technologies.
- Possess experience with data migration and integration across multiple systems.
Roles and Responsibilities
- Excellent interpersonal and communication skills.
- Strong collaboration skills to work effectively across cross-functional teams.
- Forward-thinking approach to infrastructure automation and scripting.
- Ability to work with global teams across multiple time zones.
- Self-motivated with the ability to work independently and seek guidance when needed.
- Ability to understand application data requirements and recommend appropriate database solutions.
- Responsible for designing, deploying, and maintaining EDB Postgres, PGD and AWS RDS database clusters to support large-scale platforms and applications.
- Create and manage fully functional database clusters across development, QA, and production environments, with experience in performance tuning.
- Review existing configurations and recommend improvements.
- Assist with planning and executing Postgres database upgrades and migrations.
- Provide day-to-day administrative support and maintenance for Postgres and AWS Aurora databases.
- Participate in production support and on-call rotations as needed.
- Collaborate with Postgres and cloud vendors and utilize their support channels.
- Develop and implement backup strategies, perform upgrades, and apply patches.
- Identify inefficiencies and implement optimized solutions.
- Design and execute data and database migrations to new hardware or platforms.
- Lead best practices and database solution strategies at Mastercard.
- Work with management to plan and implement new tools and data services.
- Represent Database Engineering in strategic planning and long-term direction.
- Support both internal and future cloud-managed Postgres systems, define best practices, and drive automation and innovation.
- Collaborate with multiple application teams and developers.
- Assist in defining long-term strategic goals for database development in alignment with stakeholders.
Education (Preferred)
- Bachelors degree in computer science, Information Systems, or equivalent experience.
About You
- Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS.
- Deep understanding of EDB Postgres architecture and internals.
- Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced Server and Postgres Distributed from EnterpriseDB.
- Skilled in PostgreSQL monitoring and alerting tools, particularly PEM. Familiarity with observability tools like Splunk and Dynatrace is a plus.
- Experienced in setting up, configuring, and monitoring PostgreSQL binary and logical replication (e.g., Binary Streaming, Bi-Directional Replication - BDR).
- Strong skills in collecting diagnostics and tuning PostgreSQL and SQL performance.
- Proficient in PostgreSQL procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL.
- Excellent troubleshooting and debugging skills.
- Experience in performance tuning and automation for Postgres and AWS platforms.
- Proficient in Linux, especially Oracle Linux Enterprise.
- Familiarity with scripting languages such as Bash, KSH, and Perl.
Our Commitment to Diversity & Inclusion:
Did you know that Apexon has been Certified by Great Place To Work, the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com)
Our Commitment to Environment:
Actively contribute to Apexon's commitment to environmental responsibility by following sustainable practices and supporting ESG initiatives.
Our Perks and Benefits:
Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.
We also offer:
o Health Insurance with Dental & Vision
o 401K Plan
o Life Insurance, STD & LTD
o Paid Vacations & Holidays
o Paid Parental Leave
o FSA Dependent & Limited Purpose care