Senior Database Developer (Oracle to PostgreSQL)
Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.
We are seeking an experienced Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post–go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration.
What you will do?
- Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
- Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
- Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
- Identify, troubleshoot, and fix database-related application bugs.
- Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
- Support and monitor AWS DMS during full load and CDC phases.
- Diagnose and resolve DMS data and performance issues.
- Perform data validation and reconciliation between Oracle and PostgreSQL.
- Collaborate with application teams to align SQL behavior and performance expectations.
What are we looking for?
- Bachelor's degree in Computer Science or a related field.
- 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
- Strong experience with Oracle Database and PostgreSQL / Aurora PostgreSQL.
- Hands-on expertise in Oracle to PostgreSQL migration.
- Advanced SQL and query performance tuning skills.
- Experience with AWS SCT and AWS DMS.
- Knowledge of Flyway/Liquibase or similar schema migration tools.
- PostgreSQL internals: indexing, statistics, execution plans.
- AWS services: RDS/Aurora, CloudWatch, IAM (preferred).
You will be preferred if:
- Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet.
- Familiarity with IAAC tools such as Terraform, CloudFormation.
- Familiarity with CI/CD implementation tools like Liquibase/Flyway.
- AWS Certified Database – Specialty.
- AWS Certified Solutions Architect.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Mactores Cognition Private Limited
About
Mactores is a global technology consulting and product company with focus on delivering solutions on Cloud, Big Data, Deep Analytics, DevOps, IoT & AI
Company social profiles
Similar jobs
Job Description
You will lead the journey of growth by analysing, solving the problems and executing new projects on ground!
- Create processes and methods to gather business data and create business reports
- Analyze data to identify problematic areas and suggest improvements
- Responsible for goal setting, planning, and execution of projects at farms
- Develop requirements and operational standards - SOP’s
- Conduct continuous reviews of metrics & drive or assist on improvements
Job Requirement
- Expert in SQL, Excel, other scripting languages (R, Python, etc.)
- 1-2 years of experience as business analyst
- Hands on experience on BI tools - Power BI, Tableau, Qlikview, Data Studio, Excel etc
- Self-driven, energetic, lives and breathes data with a problem-solving mindset.
- Should be enthusiastic for travelling on ground, lead teams and execute projects.
You are a perfect fit if you are:
- A self-starter and a quick learner. Result oriented with execution excellence. A problem solver with a go-getter attitude. Passionate about travelling, executing developing and lead teams.
Responsibilities:
- Contacting potential clients to establish rapport and arrange meetings.
- Planning and overseeing new marketing initiatives.
- Researching organizations and individuals to find new opportunities.
- Increasing the value of current customers while attracting new ones.
- Finding and developing new markets and improving sales.
- Attending conferences, meetings, and industry events.
- Developing quotes and proposals for clients.
- Developing goals for the development team and business growth and ensuring they are met.
- Training personnel and helping team members develop their skills.
Business Development Manager Requirements:
- Bachelor’s degree in business, marketing or related field.
- Experience in sales, marketing or related field.
- Strong communication skills and IT fluency.
- Ability to manage complex projects and multi-task.
- Excellent organizational skills.
- Ability to flourish with minimal guidance, be proactive, and handle uncertainty.
- Proficient in Word, Excel, Outlook, and PowerPoint.
- Comfortable using a computer for various tasks.
Kubernetes
Docker
PostgreSQLAbout Hive
Hive is the leading provider of cloud-based AI solutions for content understanding,
trusted by the world’s largest, fastest growing, and most innovative organizations. The
company empowers developers with a portfolio of best-in-class, pre-trained AI models, serving billions of customer API requests every month. Hive also offers turnkey software applications powered by proprietary AI models and datasets, enabling breakthrough use cases across industries. Together, Hive’s solutions are transforming content moderation, brand protection, sponsorship measurement, context-based ad targeting, and more.
Hive has raised over $120M in capital from leading investors, including General Catalyst, 8VC, Glynn Capital, Bain & Company, Visa Ventures, and others. We have over 250 employees globally in our San Francisco, Seattle, and Delhi offices. Please reach out if you are interested in joining the future of AI!
About Role
Our unique machine learning needs led us to open our own data centers, with an
emphasis on distributed high performance computing integrating GPUs. Even with these data centers, we maintain a hybrid infrastructure with public clouds when the right fit. As we continue to commercialize our machine learning models, we also need to grow our DevOps and Site Reliability team to maintain the reliability of our enterprise SaaS offering for our customers. Our ideal candidate is someone who is
able to thrive in an unstructured environment and takes automation seriously. You believe there is no task that can’t be automated and no server scale too large. You take pride in optimizing performance at scale in every part of the stack and never manually performing the same task twice.
Responsibilities
● Create tools and processes for deploying and managing hardware for Private Cloud Infrastructure.
● Improve workflows of developer, data, and machine learning teams
● Manage integration and deployment tooling
● Create and maintain monitoring and alerting tools and dashboards for various services, and audit infrastructure
● Manage a diverse array of technology platforms, following best practices and
procedures
● Participate in on-call rotation and root cause analysis
Requirements
● Minimum 5 - 10 years of previous experience working directly with Software
Engineering teams as a developer, DevOps Engineer, or Site Reliability
Engineer.
● Experience with infrastructure as a service, distributed systems, and software design at a high-level.
● Comfortable working on Linux infrastructures (Debian) via the CLIAble to learn quickly in a fast-paced environment.
● Able to debug, optimize, and automate routine tasks
● Able to multitask, prioritize, and manage time efficiently independently
● Can communicate effectively across teams and management levels
● Degree in computer science, or similar, is an added plus!
Technology Stack
● Operating Systems - Linux/Debian Family/Ubuntu
● Configuration Management - Chef
● Containerization - Docker
● Container Orchestrators - Mesosphere/Kubernetes
● Scripting Languages - Python/Ruby/Node/Bash
● CI/CD Tools - Jenkins
● Network hardware - Arista/Cisco/Fortinet
● Hardware - HP/SuperMicro
● Storage - Ceph, S3
● Database - Scylla, Postgres, Pivotal GreenPlum
● Message Brokers: RabbitMQ
● Logging/Search - ELK Stack
● AWS: VPC/EC2/IAM/S3
● Networking: TCP / IP, ICMP, SSH, DNS, HTTP, SSL / TLS, Storage systems,
RAID, distributed file systems, NFS / iSCSI / CIFS
Who we are
We are a group of ambitious individuals who are passionate about creating a revolutionary AI company. At Hive, you will have a steep learning curve and an opportunity to contribute to one of the fastest growing AI start-ups in San Francisco. The work you do here will have a noticeable and direct impact on the
development of the company.
Thank you for your interest in Hive and we hope to meet you soon
We Aggressively hiring for freshers with good communications skills for our US IT, US Sales domain at our Vadodara Gujrat locations.
Fresh Passed out Graduates, Post Graduates can apply.
No pursuing candidates are required. days per week fixed Saturday and Sunday off. US shift.
.NET- Must have 3+ years’ experience in ASP .NET with C# and VB.NET
- Must have at least 2 years’ experience in SQL Server
- Must have experience working with SOAP and REST Web Services
- Must have experience with SSRS and SSIS
- Must have some experience with MVC framework and Angular JS
- Must be able to work with basic CSS and HTML
- Must be able to work with jQuery and JavaScript
- Experience with Reporting Services, WCF, etc. would be a strong positive
Position Responsibilities:
• Responsible for developing customised solutions within the Salesforce platform using LWC
• Designing , coding and implementing Salesforce applications.
• Testing the stability and functionality of the application.
• Troubleshooting and fixing bugs.
• Writing technical documentation for Salesforce applications
Minimum Qualifications :
• 2 - 10 yrs solid experience as a Salesforce Developer using Apex, SOQL, Lighting Web Component plus Hands-On experience with integration using REST API
• Experience with multiple full lifecycles from Design & Architecture through Development, Testing, Deployment and Debugging production issues.
• Strong experience in front-end technologies including Javascript, HTML5, CSS3.
• In-depth and strong experience in at least one Object-Oriented Programming language such as JAVA, APEX, Python.
• Excellent verbal and written communication
Key Responsibilities
The Candidiate is responsible for driving the success of LoyaltyXpert’s Services & brand promise in the Indian Market. This person will:
- Assist in the formulation of strategies to build a lasting digital connection with consumers
- Plan and monitor the ongoing company presence on social media (LinekdIn, Twitter, Facebook etc.)
- Launch optimized online adverts through Google Adwords, Facebook etc. to increase company and brand awareness
- Be actively involved in SEO efforts (keyword, image optimization etc.)
- Prepare online newsletters and promotional emails and organize their distribution through various channels
- Provide creative ideas for content marketing and update website
- Collaborate with designers to improve user experience
- Measure performance of digital marketing efforts using a variety of Web analytics tools (Google Analytics, WebTrends etc.)
- Acquire insight in online marketing trends and keep strategies up-to-date
- Maintain partnerships with media agencies and vendors
Angular (2+)
AngularJS (1.x)Exp-3-8Yrs
Job Location: Bangalore/Udupi/Mumbai
About Company
Robosoft is a full-service digital transformation company, with a vision to Simplify Lives. We offer end-to-end solutions in Product Advisory, Design, Engineering, and Analytics. The delightful, intuitive digital experiences we craft help enterprises offer great customer experiences and drive brand preference. In 1996, our first customer was Apple Inc. Since then, with 25 years of experience in software development, we have played an active role in the ever-changing world of digital experiences - from mobile app development to emerging technologies in digital experiences.1000+ employees based in Udupi, Bangalore, and Mumbai.
The acquisition of Robosoft with TechnoPro in Aug-21 is giving us more value and scalability to grow at a faster pace. We have partnered with several prestigious brands across the globe including Discovery, ESPN, AAA, HP, McDonald’s India, Paytm, NDTV, Viacom18, Disney, BSI and more. We have crafted over 2000 digital experiences and our apps have garnered over a billion downloads. Our clients are spread across diverse domains - Banking & Financial Services, E-commerce & Retail, Media & Entertainment, Healthcare & Pharma to name a few.
Voted ‘Mobile App Development Company of the Year’ at the Amazon Mobility Awards, our other prestigious awards include Top Wearable App Developers, Best UX Design Agency 2020, ‘Products, Upgrades, and Innovation of the Year' at CEO World Awards, Best of App Store, Apple Design Award, BAFTA, Stevie Gold Winner at American Business Awards to name a few.
Mission: Simplifying lives through delightful digital experiences
Amazon Web Services (AWS)- Deliver high-quality virtual and in-person technical training in line with industry-recognized best practices on utilizing Public Cloud services over AWS & Azure
- Excellent knowledge about digital transformation strategies using public cloud, various architectures, benefits and case studies.
- Hands on knowledge in implementing multi-tier applications over multiple cloud services and in a multi-cloud / Hybrid cloud environment.
- Design high quality self-paced recorded training sessions for varied target segments - students, working professionals, and corporates.
- Continuously improve on teaching methodology to suit online model to lead to high student satisfaction.
- Develop and retain an up-to-date knowledge of current working practices.
- Carry out course monitoring and evaluation collating participants' training, assessment report at every fortnight.
- Create high quality training materials for the candidates
- Mentor other instructors/team leaders/Subject Matter Experts in the content and course delivery techniques for assigned technical courses.
- Continuously improve knowledge with necessary certifications and actively contribute in community forums
Skills & Experience
- Minimum 4 years experience on AWS or Azure as a solution architect or similar at the associate level.
- AWS certified solutions architect associate or higher
- Microsoft certified Azure administrator associate or higher
- Excellent verbal and written communication skills.
- Excellent organizational and time-management abilities.
- Experience in building and delivering educational resources, including designing virtualized network training lab environments, administrating LMS systems for reporting, and authoring exams and self-assessment surveys.
- Experience in eLearning video development using Articulate, Camtasia, or Captivate software.
2) Fix appointments and conduct Online demo sessions on daily basis including follow up session
3) Understand Customer profile & problems
4) Create the need for Smart Learning and advise student-parent to enrol into SP Robotic Works
courses as solution
5) Handle Objections and Price Negotiation to generate Sales Revenue
6) Learn/ Upgrade ones own Product Knowledge and Sales Skills to achieve and exceed growing Sales
target (s)
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon