App DBA is more around the DB design/modelling, scripting, automation with little mix of core dba
ØDesign, implementation and support of database on AWS
ØLead data modelling, performance tuning, database security,
ØCollaborate with engineers and product owner to design and implement database changes
ØConfiguring the parameter group
ØManaging IP traffic using a security group
ØAuditing the database log files
ØMaintenance and management activities
ØPlanning backup and recovery strategies
ØMonitoring the database
Ø10 + years of DBA experience in designing and supporting databases on the cloud platform - AWS prefered.
ØGood analytical and communication skills
ØExtensive experience in designing and supporting multi tenant data base on cloud.
ØAdvanced knowledge of data modelling, database security, backup/recovery, and performance monitoring/tuning skills
ØSignificant experience in data analysis
ØStrong experience in SQL, stored procedure and triggers.
ØExtensive experience with database technologies in MySQL and open source db’s like prometheus, elastic search, etc
ØExperience modelling Timeseries data
ØHands on experience with scripting, sql tuning, change management tools like liquibase, GitHub and Jenkins
ØSignificant experience in data migration strategy and execution of migration
ØExperience in data aggregation and metrics for business analytics purpose along with analytics tools
ØCreate and maintain optimal data pipeline architecture
ØUnderstanding of Financial domain is desirable skill