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
38 Experion Technologies Jobs
Database Architect
Experion Technologies
posted 7hr ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Experience
6+ years.
Mandatory skill - PostgreSQL / Oracle-Architect / Lead Amazon Aurora PostgreSQL
- An Oracle/PostgreSQL back-end architect is responsible for designing and managing the Oracle 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:
- 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, database backup and recovery strategy on cloud.
- Expertise in optimizing PL/SQL or PL/pgSQL code and SQL queries for performance.
- Knowledge of query optimization techniques, indexing, table partitioning, 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.
- Experience with AWS Cloud Infrastructure and or other cloud providers, specifically exposure in AWS amplify.
- 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.
- Expertise in diagnosing and resolving complex database issues.
- Good understanding on AWS services such as API Gateway, Lambda, Bath jobs, Apache Kafka and S3.
- Knowledge in Implementing authentication and authorization mechanisms using AWS Cognito and other relevant services.
- Exposure to any programming languages such as Java, Python and understanding of Web API, REST, SOAP, JSON.
- Understanding on any of the source/version control system (Git/Bitbucket).
- Good understanding on CI/CD implementation using terraform/serverless.
- An Oracle Database Architect 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.
- To adhere to the Information Security Management policies and procedures.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Database Architect 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
Rating based on 1 Database Architect
review
Anonymous · Data and Analytics
in Kochi
Likes
Work culture, management, and policies are very nice
Read 1 reviewDatabase Architect salary at Experion Technologies
reported by
4
employees
with 12-15
years exp.
₹14.2
L/yr - ₹17.5
L/yr
36%
less
than the average Database Architect Salary in India
View more details
What Experion Technologies employees are saying about work life
based on 128 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
3i Infotech
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
Similar Jobs for you
Experion Technologies Thiruvananthapuram Office Locations
Thiruvananthapuram Office
Headquarter
Experion Technologies (India) Private Limited,
407, Thejaswini, Technopark Campus
Thiruvananthapuram
695581
695581
Thiruvananthapuram, Kerala Office
Experion Technologies (India) Private Limited,
B-5, Second Floor, Gayatri Building, Technopark Campus, Thiruvananthapuram, Kerala 695 581
Thiruvananthapuram, Kerala
695581
695581
Share an Interview