AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Engaged Employer
i
This company page is being actively managed by
Sun Dew Solutions Team. If you also belong to the team, you
can get access from
here
Sun Dew Solutions
Compare
All Filters
53 Sun Dew Solutions Jobs
Database Architect
Sun Dew Solutions
posted 3mon ago
Job Role Insights
Fixed timing
Key skills for the job
Job Description
Required Skill Set (Must Have)
- Understanding of various relational and non-relational database technologies along with their benefits, downsides, and best use-case.
- In-depth experience in configuring database replication on multiple versions.
- Strong experience in Monitoring, DB Performance Tuning, DB Availability, DR, Security, Storage
- Analyzing and providing recommendations to optimize database
for improved performance, manageability, and scalability. - Expertise in enterprise backups, recovery, and performing point in-time recovery
- Experience in deploying and integrating PMM tools
- Experience in data partitioning and encryption.
- Knowledge of de-facto standards and best practices Relational and No-SQL DBs
- Understanding storage of Structured and Non Structured Data.
- Ability to plan resource requirements from high level specifications
- Design and implement effective mission-critical database solutions
- Conceptual, logical data models and physical database design using tools like Erwin, PGAdmin, Visio, UML
- Hands on experience and Proficient in SQL and procedural languages (i.e. PL/SQL, T-Sql, PL/PgSql)
- Understanding of Data warehousing, ETL processes, and Report Functions
- Database security, database hardening, data encryption at rest and at motion
- Implementing normalized and deformalized star and snowflake schema
Desired Skill Set (Good to Have)
- Data migration knowledge- Homogenous and heterogeneous e.g. MongoDB to PostgreSQL with tools like Goldendale, Ora2PG.
- Database backup knowledge (physical and logical) and recovery strategies.
- High availability and disaster recovery principle i.e. physical and logical standby databases, server clustering, mirroring, replication, sharding
- Performance tuning i.e. database initialization parameter tuning, database tuning, query and Pl/Sql tuning
- Good understanding of code versioning tools such as Git / Mercurial / SVN
View Job in :
Get a feel for work-life at Sundew
Wherever you work from, office or remote location, its our goal to make everyone feel at home.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Database Architect roles with real interview advice
Top Sun Dew Solutions Database Architect Interview Questions
Q1. How to handle the huge number of concurrent HTTP requests of orders for the same item? What if there is only one item left in the stock?
Q2. What can we do to reduce the size of an application developed using Flutter?
Q3. What are the different types of Widgets in Flutter?
What people at Sun Dew Solutions are saying
What Sun Dew Solutions employees are saying about work life
based on 43 employees
Strict timing
Monday to Friday
No travel
Day Shift
Sun Dew Solutions Benefits
Submitted by Company
Team Outings Health Insurance Job Training 
Cafeteria
Submitted by Employees
View more benefits 
Compare Sun Dew Solutions with
Accel Frontline
Compare
Northcorp Software
Compare
Elentec Power India (EPI) Pvt. Ltd.
Compare
HyScaler
Compare
Pitney Bowes
Compare
Apmosys Technologies
Compare
DynPro
Compare
Apex CoVantage
Compare
VHS Consulting
Compare
IVTL Infoview Technologies
Compare
Appsierra
Compare
Yashi Consulting Services
Compare
Avontix
Compare
GlobusSoft
Compare
Dataflow Group
Compare
Knoldus Inc
Compare
Prologic Web Solutions
Compare
Starmark Software
Compare
Mol Information Processing Services India
Compare
ICT Service Management Solutions
Compare
Share an Interview