PostgreSQLYou'll own heterogeneous database migrations end to end for enterprise customers moving off Oracle and SQL Server onto PostgreSQL and Aurora PostgreSQL. That means running the AWS DMS and SCT toolchain, then doing the part the tools can't: rebuilding procedural business logic in PL/pgSQL when SCT flags a gap it can't close on its own. You ship the runbook, you run the cutover, you validate the result.
What you'll do?
- Lead end-to-end database migration initiatives, including assessment, planning, schema conversion, execution, and post-migration validation.
- Design, configure, and manage AWS DMS and SCT environments while ensuring migration quality, performance, and reliability.
- Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
- Perform database migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.
- Collaborate with infrastructure, application, security, and platform teams to ensure successful migration outcomes.
- Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
- Provide technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
- Lead conversion and refactoring of procedural database code — Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) — into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT.
What we're looking for?
- 8–12 years of professional experience in database architecture and migration delivery
- Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migrations
- Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments, including migration planning, execution, and optimization
- Proven background in delivering heterogeneous database migrations across on-premises, cloud, and AWS environments
- Knowledge of production database operations, including backup and restore strategies, parameter tuning, performance optimization, and failover testing
- Skills in authoring and executing migration runbooks, validation plans, cutover procedures, rollback strategies, and post-migration stabilization activities
- Strong understanding of AWS database services, migration best practices, and integration with broader cloud migration programs
- Experience engaging directly with enterprise customers, architecture teams, and migration stakeholders to drive successful delivery outcomes
- Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions with no native PostgreSQL equivalent
- Ability to identify and remediate SCT action items and manual conversion gaps in procedural code (e.g., DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, and nested/recursive procedure calls) and validate converted logic through functional and regression testing.
You'll be preferred if you
- Have tuned production database performance, backup and restore strategy, and failover testing in high-stakes environments.
- Have led migration teams or mentored engineers through complex conversions.
- Bring experience with broader AWS cloud migration programs beyond the database layer.
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 (10)
About GIGL
With over 7 million viewers and counting, GIGL is a leading YouTube channel network on the rise. Our platform is dedicated to bringing financial, scientific, rational thinking, business, and political knowledge to our audience through engaging video content. But we don't just stop there - we also have a popular audio summary application and video courses that have been downloaded over 3 million times and rated 4.8 out of 5 stars by 1 lakh 40 thousand users. If you're passionate about education and making a positive impact on the world, join us at GIGL and be a part of something special!
Researcher and Content Writer
Are you a self-starter with a passion for research and writing? Are you looking for a flexible, remote role that allows you to make a good income while doing something you love? If so, we have the perfect opportunity for you!
As a researcher and content writer for our YouTube channel, you'll have the chance to develop and share your ideas with the public, helping to shape the conversation around important topics and issues. You'll be a part of something bigger than yourself, making a positive impact on the world and finding meaningful fulfilment in your work. Plus, you'll have the opportunity to earn a good monetary reward for your efforts.
If you're ready to take your career to the next level and make a difference in the world, don't miss this chance to join our team as a researcher and content writer for our YouTube channel. It could be the perfect fit for you!
People having expertise in one or many of the following fields:
- Science and Technology
- Indian History
- Current Affairs, Indian politics, and world politics
- Finance
Requirements:
To join our team, you'll need to have:
- A curious and creative mindset, with a love for learning and developing new ideas
- Expertise in researching scientific papers, books, and other sources
- Flexibility to work remotely and set your own hours
- A strong understanding and interest in your field
- Excellent English and Hindi language skills
- Strong critical thinking and scientific temperament
- A workload of between 10-80 hours per month, depending on your circumstances and area of expertise
If you meet these requirements and are excited to work with us, we want to hear from you!
Important: Include your CV containing past experience and examples of your best work.
Salary & Probation:
Duration: 1 month
Salary during probation: 15,000 - 35,000 /month
After probation:
Annual CTC: 2 - 3 LPA (All fixed).
Python
React.js
Amazon Web Services (AWS)Role: Senior Software Developer (Full Stack) - Python
Location: Coimbatore
YOE: 6+ years
Mandatory Skills: Python, AWS
Good to have: React, SQL, React Native, Knowledge in Flutter/Android Native Benefits: Learn more about our perks below
Compensation: Competitive compensation as per industry standards.
About the Role:
We aspire to build high-quality, innovative & robust software. If you are a hands-on platform builder with significant experience in developing scalable data platforms, look no further. Click on Apply and we will reach out to you soon.
Responsibilities:
● Determines operational feasibility by evaluating analysis, problem definition, requirements, solution development, and proposed solutions.
● Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
● Prepares and installs solutions by determining and designing system specifications, standards, and programming.
● Improves operations by conducting systems analysis; recommending changes in policies and procedures.
● Obtains and licenses software by obtaining required information from vendors; recommending purchases; testing and approving products.
● Updates job knowledge by studying state-of-the-art development tools, programming techniques, and computing equipment
● Participate in educational opportunities & read professional publications;
● Protects operations by keeping information confidential.
● Provides information by collecting, analyzing, and summarizing development and service issues.
● Accomplishes engineering and organization mission by completing related results as needed.
● Develops software solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; following the software development lifecycle.
Requirements:
● Proven work experience as a Full Stack Engineer or Senior Software Developer
● Strong experience designing and developing scalable and interactive applications
● Hands-on expertise in React or similar UI technologies for frontend development and Python or other modern backend languages
● Experience in mobile app development (e.g., React Native, Flutter, or Native Android/iOS)
● Deep understanding of relational databases (e.g., PostgreSQL/MySQL) with strong proficiency in SQL
● Experience with ORM frameworks (e.g., TypeORM, SQLAlchemy or similar)
● Familiarity with NoSQL databases (e.g., MongoDB) and caching systems like Redis is a plus
● Test-driven development and automated testing experience is a plus ● Proficiency with modern software engineering tools, Git-based workflows, and CI/CD pipelines
● Strong ownership mindset with ability to lead teams, mentor developers, and drive end-to-end delivery
● Excellent communication and collaboration skills with cross-functional stakeholders
● Working knowledge of AWS or other cloud platforms is an added advantage
• Analyze complex data sets to identify trends, patterns, and insights to drive business decisions.
• Collaborate with cross-functional teams in an Agile environment to define and implement data-driven solutions.
• Create and maintain detailed reports and dashboards to track key performance indicators (KPIs).
• Work closely with product owners, developers, and stakeholders to ensure data requirements are met effectively.
• Utilize Jira for task management, sprint planning, and tracking project progress.
• Provide guidance and mentorship to junior team members in data analysis techniques and best practices.
PythonMerito is a curated talent platform where we identify, assess, and connect candidates for matching job opportunities. We are working with the mission to change the way hiring is done. The company is founded by a team of alumni from IIM Ahmedabad, McKinsey with more than 2 decades of experience in recruitment, training, and coaching.
About our client :
Our client is a global data and measurement-driven media agency whose mission is to make brands more valuable to the world. Clients include Google, Flipkart, NBCUniversal, L’Oréal and the Financial Times. The agency is more than 2,000 people strong, manages $4.5B in annualized media spend, and deploys campaigns in 121 markets via 22 offices in APAC, EMEA and the Americas.
About the role :-
Accountable for quantifying and measuring the success of our executions and for delivering insights that enable us to innovate the work we deliver. Leading and supporting multi project, be involved in external reviews if needed, developing new analytical tools.
Some of the things we’d like you to do:
● Support the leadership of the Analytics team
● Build a deep understanding of marketing plans and their objectives to help account teams build comprehensive measurement, and test & learn plans
● Assist clients with objective setting for marketing plans
● Play an instrumental role in evolving and designing new, innovative measurement tools. Managing the process through to delivery and take ownership of global roll out
● Oversee junior members of the team in the delivery of their responsibilities, ensuring quality and that deadlines are met
● Oversee the creation of clear and robust campaign reporting with valuable and actionable insights
● Recruit, manage, and mentor resource ensuring workflow is efficient throughout the team, as well as a high quality output is delivered.
A bit about yourself:
● At least 10 years of relevant experience
● Degree from a top-tier College
● Proficiency with systems such as SQL, Python, and R
● Expose to marketing campaign measurement (both Direct Response and Brand Awareness campaigns)
● Strong understanding of what data points can be collected and analyzed in a digital campaign, and how each data point should be analyzed
● Excellent at presenting data in a visually engaging and insightful manner that cuts through the noise
● Strong organizational and project management skills
● Ability to delegate effectively
● Established and professional communication, presentation, and motivational skills.
RESPONSIBILITIES:-
As a Business Development Manager working under FMCG segments, an ideal candidate must perform the following responsibilities:
· Approaching potential leads a close them within a stipulated time frame.
· Create exclusive distributors, exclusive super stockist and business associated for the company towards business growth.
· Finding and developing new markets and improving sales.
REQUIREMENTS:
· Bachelor’s degree in business, marketing or related field.
· Experience in sales, marketing or related field.
· Strong communication skills.
· Excellent organisational skills.
Python
Django
JavascriptPython
SQL
HTML
Linux
AJAX/ JSSkills
Excellent Communication Skills
Have to be a quick learner
Complete project on time
Responsibilities include:
1. Assisting with the growth of the sales pipeline through lead generation and inside sales activities
2. Engage with prospects at all levels and using different channels and techniques - Email, Phone, LinkedIn and other lead generation tools.
3. Conducting targeted email campaigns to reach key decision-makers in target companies.
4. Analyzing customer needs in terms of current business obstacles, identifying projects and scoping potential solutions for Fabrik.
5. Contributing individually to the team targets, achieving a high level of client
satisfaction and quality lead generation.
6. Research accounts and identifies the right contacts in every account.
Skill(s) required:
1. Excellent communication and articulation skills.
2. Self-motivated and results-driven; passionate to learn and grow.
Other requirements:
1. Experience with Augmented Reality/Virtual Reality
2. Out-of-the-box thinking
3. Proactive executioner
4. Loves building great products
5. Smart worker
Perks:
1. Great team
2. Cutting edge technologies
3. Certificates/Letter of recommendations
4. Informal dress code
5. Free snacks & beverages
6. Job offer (On successful conversion to a permanent employee)
React.jsJavascript
Ruby on Rails (ROR)
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon