Database Administrator - Oracle DB/PostgreSQL (4-13 yrs)

Job Description :

The role involves designing and developing solutions to support the business needs. Optimizing and tuning existing programs and developing new routines will be an integral part of the profile.

Roles and Responsibilities :

- Architect, Design and Develop solutions to support business requirements.

- Use skill sets to Analyze and manage a variety of database environments such as Oracle, Postgres, Cassandra, MySql, Graph DB, etc

- Provide optimal database environment design, analyze complex distributed production deployments, and make recommendations to optimize performance.

- Work closely with programming teams to deliver high quality software.

- Provide innovative solutions to complex business and technology problems.

- Propose best solution in Logical and Physical Data Modelling.

- Perform Administration tasks including DB resource planning and DB tuning.

- Mentor and train junior developers, lead & manage teams.

- Experience in a Data Engineering role.

- Bachelor's degree in Computer Science or related experience.

Skills :

- PostgreSQL & SQL or Oracle mandatory min 3-4 years they should have exp

- Any cloud experience, Data Warehousing, Big Data (6month- 1year will also do) - Mandatory

Key Skills Required :

- Experience of designing/architect database solutions

- Experience with multiple RDBMS and NoSql databases of TB data size preferably Oracle, PostgreSQL, Cassandra and Graph DB.

- Must be well versed in Oracle/ PL/SQL & PostgreSQL and Strong Query Optimization skills.

- Expert knowledge in DB installation, configuration, replication, upgradation, security and HADR set up.

- Experience in database deployment, performance and / troubleshooting issues.

- Knowledge of scripting languages (such as Unix, shell, PHP).

- Advanced knowledge of PostgreSQL will be preferred.

- Experience working with Cloud Platforms and Services

- Experience with migrating database environments from one platform to another

- Ability to work well under pressure

- Experience with big data technologies and DWH is a plus