Job Description

Job Requirements

Applies subject matter expertise to solve a variety of common business issues. Works on problems of various complexities: easy to hard. Acts as an informed team member providing analysis of information and project direction input. Exercises independent judgment within defined practices and procedures to determine appropriate action. Follows established guidelines and interprets policies. Evaluates unique circumstances and makes recommendations.

•Responsibilities: •

• Maintaining database, deploying modifications of database structure to development and production environments
• Monitoring database performance, and providing support
• Troubleshooting any database issues on behalf of the users or engineering teams
• Involving in the planning and development of the database
• Providing the developers the database information that they need to do their work
• Optimizing application and end-user queries
• Generating needed ad hoc reports by querying from the database
• Maintaining database, deploying modifications of database structure to development and production environments
• Monitoring database performance, and providing support
• Troubleshooting any database issues on behalf of the users or engineering teams
• Involving in the planning and development of the database
• Providing the developers the database information that they need to do their work
• Optimizing application and end-user queries
• Generating needed ad hoc reports by querying from the database

•Education and Experience Required: •

• Bachelor's or Master's degree in Computer Science, Information Systems, or equivalent.
• Minimum 4 years of experience in DBA role.

•Knowledge and Skills: •

• Be able to create an efficient physical database design from a logical data model and application specifications
• Must possess in-depth SQL knowledge, understand SQL code and host language programs (Java, Python, C#, etc.)
• Proficient in tuning SQL queries to improve the database performance and availability
• Familiar with NoSQL database such as MongoDB or AWS DocumentDB
• Have experience with Linux operating system and MySQL
• Have experience in AWS services like AWS EC2, RDS, Redshift, Athena, Cloudwatch, etc.
• Have expertise in managing AWS Redshift access privileges and creating roles, users, groups
• Have expertise in loading/unloading data from Amazon Redshift
• Proficient in maintaining and tuning AWS Redshift data warehouse to improve the cluster performance and availability
• Good experience in writing Spark applications
• Ability to use PowerBI and create basic dashboards
• Familiarity with database version control tools such as Flyway is a plus