
At Technoidentity, we’re a Data + AI product engineering company delivering scalable, modern enterprise solutions.
We are seeking a seasoned Senior Database Developer & PostgreSQL Expert with 8–10 years of experience across multiple database systems, with deep hands-on expertise in PostgreSQL internals, performance tuning, advanced indexing, and enterprise data architecture.
With a strong preference for Oracle to AlloyDB (PostgreSQL) migration expertise, this role blends modernization, advanced PostgreSQL engineering, and cloud-native architecture on Google Cloud Platform (GCP). If you thrive in transforming complex data logic, optimizing performance, and architecting enterprise-grade PostgreSQL systems, this opportunity is built for you.
Requirements
Key Responsibilities
Database Migration & Development
- Lead database migrations from Oracle to PostgreSQL-based platforms like AlloyDB, applying both manual and automated strategies.
- Re-engineer stored procedures, triggers, and packages from PL/SQL to PL/pgSQL.
- Recreate and optimize DB objects (schemas, constraints, views, indexes) across target platforms.
- Design PostgreSQL-specific architecture including partitioning strategies, indexing plans (GIN, GiST, BRIN), and query optimization paths.
- Leverage PostgreSQL internals such as vacuum tuning, WAL configuration, and connection management for optimal system performance.
Performance Optimization
- Implement indexing strategies, query plans, and table partitioning to enhance database performance.
- Use tools like EXPLAIN ANALYZE, pg_stat_statements, and GCP-native monitoring dashboards for tuning.
- Collaborate with DevOps for deployment pipelines and infrastructure-as-code (IaC) best practices.
- Perform deep-dive PostgreSQL performance fine-tuning including buffer cache analysis, autovacuum configuration, and planner optimization.
- Optimize PostgreSQL workloads for high concurrency and large datasets, ensuring stable and predictable performance.
Data Integrity & Validation
- Build and execute validation scripts for source-to-target comparison.
- Ensure row-level data accuracy, transformation logic fidelity, and zero data loss post-migration.
- Manage large-scale datasets for archival and bulk processing tasks.
- Implement PostgreSQL-native data integrity strategies like constraint management, row-level security (RLS), and trigger-based validations.
Collaboration & Documentation
- Work with cross-functional teams to translate business logic and legacy workflows to scalable, modern database systems.
- Maintain clear documentation on schema conversions, validation methods, rollback strategies, and change history.
- Create PostgreSQL architecture documents, optimization playbooks, and database best-practice guidelines for engineering teams.
Ideal Candidate Profile
Experience & Skills
- 4–10 years of database development experience across Oracle, PostgreSQL, and similar RDBMS platforms.
- Strong expertise in PL/SQL and PL/pgSQL for procedural logic, error handling, and performance tuning.
- Proven track record of large-scale database migration projects (Oracle to PostgreSQL/AlloyDB preferred).
- Proficient in query optimization, indexing, partitioning, and schema normalization.

About Technoidentity
About
Founded a decade ago, a group of seasoned professionals came together to ask ‘How might we use technology to bring the world closer to social justice?’ A small team was put together to create incredible solutions for organisations working towards delivering large scale impact. Today, we’re a global organisation providing disruptive software solutions to our customers who are solving important problems in their industry and also the world we live in. At TechnoIdentity, we challenge our team of passionate technologists to create forward-looking solutions for our customers that improve operational efficiency and bolster their bottom line. We empower them with the tools, methodologies and decision-making to make real impact, fast. We invite creative minds and businesses to TechnoIdentity, let’s collaborate to transform lives through technology.
Life at TechnoIdentity is shaped by the belief that everyone deserves to bring their authentic self to work and as responsible adults, you will choose to spend your time wisely on things matters the most to you.
Tech stack
Similar jobs
We are a Delhi NCR-based Applied AI and consumer Tech company tackling one of the largest unsolved consumer internet problems of our time. We are a motley crew of smart, passionate, and nice people who believe you can build a high-performing company with a culture of respect aka a sports team with a heart aka a caring meritocracy. Our illustrious angels include unicorn founders, serial entrepreneurs with exits, tech & consumer industry stalwarts and investment professionals/bankers
Responsibilities:
- Own end-to-end design of the consumer app as we try to reinvent an exciting category from first principles, working closely with the Founders and Engineers
- Additional opportunity to work on brand & marketing design across the product lifecycle
Requirements:
- 2-4 years of UI/UX design experience for a consumer app (academic projects not counted).
- Strong communication and interpersonal skills. Degree in Design a bonus.
Job Description:
- This is BPO Night shift job (US Voice process) in Nagercoil.
- This is purely night shift with fix saturday sunday off .
- This is not sales or tele marketing, it is to help the US citizens .
- It is work from office only. with salary range 15000 to 25000 per month along with unlimited incentives based on leads that you generate.(per lead you get Rs 500)
Responsibilities:
- Handle outbound calls to international customers.
- This is US Government project that you will be working on where you get the details of customers and complete the further process.
- Maintain accurate and detailed records of customer interactions and transactions.
- Collaborate with team members to achieve individual and team goals.
- Strive to achieve customer satisfaction and ensure positive feedback.
Requirements:
- Freshers and Experienced both can apply.
- Excellent communication skills / Fluency in English.
- Ensure Timely& Professional Responses to all queries.
- Strong ability to multitask and take fast decisions independently.
- Night shift only.(7.30 PM to 4.30 AM.)
Benefits:
- Competitive salary + incentives.
- After shift Drop facility for females only.
- ESI, PF, and insurance benefits
Sales Officer Responsibilities:
- Calling potential customers to explain company products and encourage purchases.
- Answering customers' questions and escalating complex issues to the relevant departments as needed.
- Developing in-depth knowledge of company products.
- Maintaining an accurate record of all sales, scheduled customer appointments, and customer complaints.
- Collaborating with the marketing department to ensure that the company is reaching its target audience.
- Informing product developers of possible product improvements and changes to ensure that company products meet current market needs.
- Preparing cost-benefit analyses for prospective and existing customers to determine the most suitable purchase options.
- Analyzing competitors' products to determine product features, benefits, shortfalls, and market success.
Zupee is India’s fastest growing innovator in online gaming with a focus on skill-based games on the mobile platforms. Started by 2 IIT-K alumni in 2018, we are backed by marquee global investors such as WestCap Group, Tomales Bay Capital, Matrix Partners, Falcon Edge, Orios Ventures & Smile Group with an aspiration to become the most trusted and responsible entertainment company in the world.
To know more about our recent funding coverage: https://bit.ly/3AHmSL3
Our focus has been on innovating in the board, strategy, and casual games sub-genres. We innovate to ensure our games provide an intersection between skill and entertainment, enabling our users to earn while they play.
- Role:- SDET 2
- A Software Engineer Test (SDET) at Zupee is a master of all. It combines the "building" aspect of software engineering with the "breaking" aspect of software test engineering. You’ll be writing code that automatically verifies the quality of the product.
- Reporting Managers:- SDET Lead
- Location:- Agnostic/Work from anywhere
- Experience in Manual Testing & Automation - UI and Functionality.
- Experience in Database using any ETL tool.
- Good knowledge in writing SQL Queries and understanding of Complex SQL Queries.
- Experience in Functionality, Compatibility, Integration and Regression Testing.
- Experience in preparing Test scenarios and writing Test cases for UI, Functionality, API and Database testing.
- Hands Experience in ,white box testing, Test Case execution, result generation, status reporting and Defect reporting, Regression Testing, JIRA
- Experience in API testing using POSTMAN or any REST API testing tool.
- Good knowledge on any automation tool and Framework
- Technical Documentation - Test case, Test Plan, Matrixes and Reporting.
- Has the ability to think clearly, analyse quantitatively, communicate coherently, organize effectively, prioritize and ideate.
- They have metric-driven, fast paced, attentive to detail, data-driven and
- self-motivated.
- Has analytical, creative, curious, a problem solver and can influence stakeholders
- Good analytical, reasoning and problem-solving skills required
- Good communication skills - both verbal and written
Qualifications and Skills
- Experience in Java/Python programming (testing area)
- 1-4.5 Years of experience with acumen for Automation Testing
- Experience in back end testing (ETL, API, Services, Data Center Automation etc)
- Experience in Frontend and/or RPA testing (Selenium, Robot Framework)
- Experience in designing and managing test suites for aforementioned use cases
- Experience in testing Android/iOS apps and performing ui automation for either is a plus
- Prior experience in using tools like Testrail, jira and confluence is a plus
- Good analytical, reasoning and problem solving skills required.
- Work well in a collaborative, team based environment (both work autonomously and as part of a team)
- Create and maintain optimal data pipeline architecture
- Assemble large, complex data sets that meet functional / non-functional business requirements.
- Author data services using a variety of programming languages
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Snowflake Cloud Datawarehouse as well as SQL and Azure ‘big data’ technologies
- Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
- Keep our data separated and secure across national boundaries through multiple data centers and Azure regions.
- Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
- Work with data and analytics experts to strive for greater functionality in our data systems.
- Work in an Agile environment with Scrum teams.
- Ensure data quality and help in achieving data governance.
Basic Qualifications
- 3+ years of experience in a Data Engineer or Software Engineer role
- Undergraduate degree required (Graduate degree preferred) in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
- Experience using the following software/tools:
- Experience with “Snowflake Cloud Datawarehouse”
- Experience with Azure cloud services: ADLS, ADF, ADLA, AAS
- Experience with data pipeline and workflow management tools
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
- Understanding of Datawarehouse (DWH) systems, and migration from DWH to data lakes/Snowflake
- Understanding of ELT and ETL patterns and when to use each. Understanding of data models and transforming data into the models
- Strong analytic skills related to working with unstructured datasets
- Build processes supporting data transformation, data structures, metadata, dependency and workload management
- Experience supporting and working with cross-functional teams in a dynamic environment.
1. Be a visible leader to drive and own the architecture and design of some of the most advanced & complex software systems / products in the industry to create company wide impact
2. Design systems that can scale to billions of data records in micro service architecture
3. Design and develop full stack product features based on customer and business requirements
4. Be an operational and technical leader with a passion for distributed systems, cloud service development, deployment and delivery
5. Technically Hands-on with scalable Architecture managing team of (30+) Sr. Engineers / Engineers, and coaching mentoring while maintaining a hands-on role with code development
6. Drive code and design reviews of components / systems / products in scope and drives the architectural governance for them
7. Set directional paths for the teams/department for adoption of new technology stacks for solving business problems
8. Be a very visible representative of multiple technology domains and represent Salesken in external technical forums
9. Teamwork skills, flexibility, and ability to handle multiple tasks
10. Bring in software engineering life cycle best practice
11. Analytical and problem-solving skills
Desired Candidate Profile
1. Strong Java, Java 8 including OOAD design patterns
2. A solid engineer with must have knowledge and experience of Micro services design, security designs, and best practices
3. Excellent knowledge and skills in the areas of Java, Spring Boot, JSP/Servlet, J2EE design patterns, App server & Web servers
4. Strong hands-on technology experience building and running large scale systems handling multi-million sessions/transactions per day
5. Excellent knowledge of RDBMS, NoSQL databases like MySQL and Cassandra
6. Strong design/development experience in building massively large scale distributed internet systems and products
7. Excellent programming skills in Java and expertise in multi-threading and performance oriented programming
8. Sound knowledge of cloud platforms like GCP, AWS, Azure, etc
9. Solid experience in Distributed systems, highly scalable products, performance & reliability
10. Excellent understanding of processing platforms and queues
11. Excellent understanding of standard protocols such as HTTP/HTTPS, DNS, SSL, etc
12. Experience and knowledge of open source software, frameworks and broader cutting edge technologies around server side development in Java
Digital Marketing Job Responsibilities:
- Plans and executes all web, SEO/SEM, database marketing, email, social media, and display advertising campaigns.
- Designs, builds, and maintains our social media presence.
- Measures and reports performance of all digital marketing campaigns and assesses against goals (ROI and KPIs).
- Identifies trends and insights and optimizes spend and performance based on the insights.
- Brainstorms new and creative growth strategies through digital marketing.
- Plans, executes, and measures experiments and conversion tests.
- Collaborates with internal teams to create landing pages and optimize user experience.
- Utilizes strong analytical ability to evaluate end-to-end customer experience across multiple channels and customer touch points.
- Identifies critical conversion points and drop off points and optimizes user funnels.
- Collaborates with agencies and other vendor partners.
- Evaluates emerging technologies.
- Provides thought leadership and perspective for adoption where appropriate.
Digital Marketing Qualifications / Skills:
- Creating and maintaining client relationships
- Self-motivated yet customer-focused
- Proficient in marketing research and statistical analysis
- Highly creative with experience in identifying target audiences and devising digital campaigns that engage, inform, and motivate
Education, Experience, and Licensing Requirements:
- Bachelor’s or master’s degree in marketing or a related field
- Proven working experience in digital marketing, particularly within the industry
- Demonstrable experience leading and managing SEO/SEM, marketing database, email, social media and/or display advertising campaigns
- Experience in optimizing landing pages and user funnels
- Experience with A/B and multivariate experiments
- Solid knowledge of website and marketing analytics tools (e.g., Google Analytics, NetInsight, Omniture, WebTrends, SEMRush, etc.)
- Working knowledge of ad serving tools
- Experience in setting up and optimizing PPC campaigns on all major search engines
- Working knowledge of HTML, CSS, and JavaScript development and constraints
Qualification -
a. Minimum Bachelor's Degree
b. Minimum 3 yr experience
c. Basic English Proficiency
d. International Clients
Location: Jaipur
Interview will be online on Skype/Zoom.
Design themes using HTML, CSS/SASS, Bootstrap, and WordPress.
Maintain existing WordPress client sites.
QA sites during staging and after deployment.
Create clean, DRY, and reusable code.
Keep yourself and the team up to date with JIRA kanban flow work boards.
Work with Lead and junior developers as a team from start to finish.
Responsibilities and Duties
Fluency with WordPress, PHP, MySQL, HTML5, CSS/SASS, and Frameworks with Responsive design.
PHP frameworks knowledge and MVC understanding
Skilled working with vanilla JavaScript, jQuery, and other JavaScript libraries (Angular or React)
Knowledge of version control (GIT).
Attend meetings with in-house account managers and project leads to discuss technical requirements, timeframes, mockups/wireframes and scope of work.
Working both independently and with other developers.
Ability to work on multiple projects at the same time.
Adhering to best practices, comments in code, and documentation.
2+ year of experience with WordPress and PHP.
Willingness to learn Advance WP CMS and Liquid templating for custom theme development.
Experience building custom themes, plugins, and widgets.
Experience working with third-party APIs - SOAP, REST and other (Facebook and Twitter).
Required Experience and Qualifications
Key Skills
Strong knowledge of web performance optimization, caching. Experience working with WP Engine Server Environment. Benefits Additional Notes We are offering amazing career growth opportunities, great compensation, and benefits. This begins with: - weekly lunches, alternate weekends-off, annual medical checkups, social engagement, financial assistance and more.
Required Experience and Qualifications
3 to 4 Years of working experience in WordPress is required.
Benefits
Perks, Benefits & Culture:
We are offering amazing career growth opportunities, great compensation, and benefits. This begins with -
- weekly lunches
- alternate weekends-off
- Half-day working Saturdays
- annual medical checkups
- Social engagement
- financial assistance
- Diwali Bonuses
- and more...







