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
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
Python scripting or any scripting language
Redshift & Postgres will be an advantage
Knowledge on Data governance
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.