Job Summary
Job description
Overview of job
- Propose/Implement schema changes/architect new schemas for projects using Liquibase CICD process.
- Analyze queries in new and existing application code and tune for performance where necessary
- Has the ability to know when to suggest breaking complex queries out from application code and into stored procedures or views where necessary
- Develop stored procedures and views on databases for consumption by the applications
- Monitor database server health of production system using DPA, MySQL Workbench, slow query logs, etc.
- Database Administration skills for maintaining MySQL RDS instances; index optimization, optimal server configuration settings, table optimization, database backup methodologies
- Strong understanding of T-SQL principles to write queries joining many tables and mining data as necessary for the development teams
- Ability to analyze common queries and add the necessary indexes to table(s)
- Strong understanding of relational database concepts (foreign key relationships, unique constraints, compound keys) and their application in all table designs/implementations
- Staging test data for development teams in the DEV/SIT environments where necessary
- Maintain database access for users in DEV/SIT environments per standards and secure protocols
- Participate in the Production release process for database deployments during maintenance windows
Why You'll Love Working Here
As one of the leading IT companies in Vietnam, we value our people and always want to support our staff with all the best conditions that we can. Here come some of the featured benefits, if you want to learn more about what we are offering, let's join us today!
- Many training opportunities in Vietnam and Overseas (230+ courses in TMA Training Center and 40% have overseas experience)
- Competitive benefit package (bonus, total health insurance, loan fund, team building fund ...)
- Friendly environment, open culture and many outdoor activities
Job Requirement
Your Skills and Experience
- Year of experiences: 4+ YoE
- Ability to communicate effectively with the US customer both written and verbally
- Ability to follow database standards/naming conventions set forth by the Corporate Data team
- Keen attention to detail and strong data analytical and troubleshooting skills
- Possesses a strong intuition to protect the integrity of the data within the databases
- Ability to work with US team overseas on data tasks and projects
- Completes assigned tasks within the sprint cadence within the required timeframes
- Ability to report the status of tasks regularly to US team on a daily/weekly basis
- Ability to work independently from the development teams to ensure proper checks and balances between the applications and database infrastructure; protect the data
- Ability to escalate emergency issues and bugs through the proper channels to the US teams in a timely manner
Languages
-
English
Speaking: Intermediate - Reading: Intermediate - Writing: Intermediate
Technical Skill
- MySQL
- CI
- CD
- T-SQL
COMPETENCES
- Detail oriented
- Analytic Skills
- Working Independently
BUSINESS PROFILE
TMA Solutions is the leading software outsourcing company in Vietnam with more than 1600+ engineers.
TMA is the leading software outsourcing company in Vietnam with more than 1600+ engineers. With more than 16 years of experience in providing software services for many world leading companies. We have built a strong technical and management team that can handle large and complex projects. Our people were selected from top Universities in Vietnam and overseas, and 40% of them have overseas experience.
Join us today to help us building a Vietnamese brand name in the world software outsourcing industry!
Why should you join us?
As one of the leading IT companies in Vietnam, we value our people and always support our staff with the best conditions available.
If you want to learn more about what we are offering, check out our website, http://www.tmasolutions.com/careers.aspx
Here some featured benefits:
- Many training opportunities in Vietnam and Oversea (230+ courses in TMA Training Center and 40% have overseas experience)
- Competitive benefit package (bonus, total health insurance, loan fund, team building fund ...)
- Friendly environment, open culture and many outdoor activitie
Don't hesitate to contact us for your dreamjob at TMA Solutions.