Add office photos
Engaged Employer
i
This company page is being actively managed by
Experion Technologies Team. If you also belong to the team, you
can get access from
here
Experion Technologies
Compare
All Filters
21 Experion Technologies Jobs
Software Product Engineering Services
Experion Technologies
posted 4mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
An Oracle/PostgreSQL back-end Database Lead Developer is responsible for designing and managing the Oracle/PostgreSQL database systems that form the foundation of an organization s data infrastructure. To excel in this role, they need a robust set of technical skills. Here are the key technical skills and knowledge areas that an Oracle back-end architect should possess:
Technical Skills
- In-depth knowledge of Oracle/PostgreSQL Database architecture and components.
- Strong SQL and PL/SQL or PL/pgSQL programming skills for querying, data manipulation, and stored procedure development.
- Proficiency in writing and maintaining PL/SQL or PL/pgSQL code, including procedures, functions, packages, and triggers.
- Strong understanding of PL/SQL or PL/pgSQL syntax, data types, and control structures.
- Mastery of SQL for querying and manipulating data in Oracle databases.
- Knowledge of complex SQL queries, joins, and subqueries.
- Familiarity with database design principles and data modeling.
- Expertise in optimizing PL/SQL or PL/pgSQL code and SQL queries for performance.
- Knowledge of query optimization techniques, indexing, and execution plan analysis.
- Ability to work with database designers to implement efficient schema structures.
- Proficiency in data migration and ETL processes using Oracle tools like Oracle Data Pump and Oracle Data Integrator (ODI).
- Familiarity with scripting languages (e.g., Shell, Python) for automating routine database tasks and monitoring.
- Understanding of the operating systems that Oracle/PostgreSQL databases run on, such as Linux, Unix, or Windows
- Mastery of Oracle Database tools like SQL*Plus, SQL Developer, and Oracle Enterprise Manager.
- Hands on Experience in Python is a plus
- Experience with AWS Cloud Infrastructure and or other cloud providers, specifically exposure in AWS services (Lambda, Step functions, Kenesis, Kafka etc.)
- Familiarity with monitoring tools like Prometheus, Grafana, and pg_stat_statements.
- Effective communication skills for collaborating with cross-functional teams and conveying technical concepts to non-technical stakeholders.
- Exposure in addressing with production issues in a timely manner with sound analytical and problem-solving skills.
- Expertise in diagnosing and resolving complex database issues
- A Database Lead Developer is responsible for designing, implementing, and managing Oracle/Postgres database systems to ensure data integrity, availability, and performance. They collaborate with cross-functional teams to understand business requirements and translate them into efficient database solutions. This role involves strategic planning, architecture design, performance tuning, and database security management.
- Collaborate with stakeholders to gather and analyze business requirements for database systems.
- Design and architect Oracle/PostgreSQL database solutions to meet scalability, security, and performance needs.
- Define data models, schema structures, and database configurations.
- Create, modify, and manage database objects (tables, indexes, views, etc.).
- Perform data migration, data transformation, and data loading task.
- Monitor database performance and identify and resolve bottlenecks.
- Optimize SQL queries and database queries for improved efficiency.
- Implement indexing and partitioning strategies to enhance performance.
- Generate documentation showcasing the team s capabilities in winning new opportunities.
- To adhere to the Information Security Management policies and procedures.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Software Product Engineer roles with real interview advice
People are getting interviews at Experion Technologies through
People are getting interviews through
(based on 11 Experion Technologies interviews)
Campus Placement
Job Portal
Referral
46%
45%
9%
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
What people at Experion Technologies are saying
What Experion Technologies employees are saying about work life
based on 125 employees
Flexible timing
Monday to Friday
No travel
Day Shift
Experion Technologies Benefits
Submitted by Company
Cafeteria 
Work From Home Team Outings Soft Skill Training Job Training Health Insurance
Submitted by Employees
View more benefits 
Compare Experion Technologies with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
LTIMindtree
Compare
Mphasis
Compare
Persistent Systems
Compare
Cyient
Compare
Sify Technologies
Compare
NeoSOFT
Compare
Microland
Compare
Newgen Software Technologies
Compare
Clover Infotech
Compare
Sonata Software
Compare
Happiest Minds Technologies
Compare
Prodapt
Compare
Test Yantra Software Solutions
Compare
Mastek
Compare
Lumina Datamatics
Compare
Similar Jobs for you
Experion Technologies Kochi Office Location
Kochi Office
Experion Technologies (India) Private Limited,
4th Floor, Athulya Building, Infopark SEZ,
Kakkanad
Kochi
682042
682042
Business System Analyst
4-9 Yrs
Kochi, Bangalore / Bengaluru, Thiruvananthapuram
Share an Interview