Database Administrator (DBA)
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
• Security – Defining and/or implementing access controls to the data
• Availability – Ensuring maximum uptime
• Performance – Ensuring maximum performance
• Development and testing support – Helping engineers and business teams to efficiently utilize the database
Skills and experience:
• Total experience: 7-12 years
• 2 -3 years IT operation with strong understanding of database structures, theories, principles, and practices
• 5-6 years of experience in Vertica, Vertica Eon, Postgres.
• Experience in working on AWS technologies
• 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.
• Must have strong knowledge and working experiences as Database Administrator
• Assist in all phases of the configuration process required on the servers
• Database Administration, Tuning, Management and Security.
• any scripting language is a plus.
• Knowledge on Data governance is a plus.