Vertica DBA
Philips Lighting
Bangalore, Karnataka, India
1d ago

Job Description

You are responsible for

Installation, configuration, maintain and upgrading database server

Modifications to any existing databases with appropriate impact analysis

Establish and maintain sound backup and recovery policies and procedures

Maintenance of Databases, regular maintenance and data cleanups

Define and apply authorized checks & validation procedures

Implement and maintain database security (create and maintain users and roles, assign privileges)

DBAs must monitor the database performance and evaluate complex information coming from a variety of sources

Suggest and implement service improvements for enhancing monitoring and alerting

Review & deployment of Database end artifacts

Integrity Verifying or helping to verify data integrity

Security Defining and / or implementing access controls to the data

Availability Ensuring maximum uptime

Performance Ensuring maximum performance

Development and testing support Helping programmers and engineers to efficiently utilize the database

Installation support of Postgres and Redshift

You are a part of

PS I2M focuses on serviceability engineering and provides SW solutions in the space of Serviceability Platform, Analytics Solutions Platform and Remote optimization.

We develop software to install, diagnose, service and monitor medical devices. We also offer tools and methods for the creation and sharing of device diagnostic knowledge using latest technologies.

We work with BIU R&D groups, Service Innovation groups, Philips Research, Field and Remote Service Engineers & Specialists to develop the right tools, applications and mechanisms for serviceability .

To succeed in this role, you should have the following skills and experience

Total experience : 6-7 years

2 -3 years IT operation with strong understanding of database structures, theories, principles, and practices

2-3 years of experience in Vertica, Vertica Eon, Postgres

Good to have - Knowledge on Redshift and Sql Server

Experience in working on AWS technologies, Cloud foundry

Experience with data management and data processing flowcharting techniques

Knowledge of reporting and query tools and practices

Good understanding of the organizations goals and objectives

Good interpersonal, written, and oral communication skills

Self-motivated and directed, with keen attention to detail

Able to prioritize and execute tasks in a high-pressure environment

Experience working in a team-oriented, collaborative environment

Analytical skills and good problem solving skills

Technical Skills

Must have knowledge of monitoring, troubleshooting and configuring Vertica, Postgres and Redshift

Must have strong knowledge and working experiences as Database Administrator Redshift, Postgres 9.5 and 9.6

Assist in all phases of the configuration process required on the servers

Database Administration, Tuning, Management and Security

RDBMS

Python scripting or any scripting language

Redshift & Postgres will be an advantage

Knowledge on Data governance

Report this job
checkmark

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.

Apply
My Email
By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
Continue
Application form