Database Administration on AWS Aurora Mysql 5.6-5.7: • Production database upgrade deploys. • Performance monitoring and troubleshooting. • Automation using Bash + Python + AWS CLI. Database Administration on Snowflake data-warehouse: • Management of data-pipelines and data-load tasks. • Views and stored procedures development. • Environment monitoring lambda functions connected with Slack channels.
No-SQL Database administration: • Elastic search, Cluster setup and migrations (versions 5.6 - 6.8 - 7.6) • MongoDB, cluster administration and automation (version 4.0) • Bash scripting for automation and alerting Database Administration on MS SQL Server 2012, 2014 & 2016: • High Availability Cluster setup and monitoring (Always On Availability Groups) • SSIS packages development and maintenance • Data issues troubleshooting • Manage database backup and data retention strategy • Query performance optimization
Cloud Administration in Amazon Web Services: • EC2 Installations, Configurations • SQL Server, Mysql and Postgres RDS sizing provisioning and configuration Database Administration on SQL Server 2008, 2012 & 2014: • High Availability setups (MS Clusters, Always On Availability Groups) • Monitor databases in a high-volume production environment • Manage database backup and data retention strategy • Troubleshooting • Integration Services (ETL) Database Administration on PostgreSQL (9.2-9.6) in Linux environments: • Backup & Restore strategies • Installations, Configurations • Shell scripting, Automation tasks • High Availability setup with Linux HA resource agents Database Administration on MySQL (5.6-5.7) in Linux environments: • Installations, Configurations • High Availavility setup with Percona XtraDB Cluster + ProxySQL + Keepalived
Database Administration on SQL Server 2005, 2008, 2012 & 2014: • High Availability setups (Replication + MS Clusters) • Monitor databases in a high-volume production environment • Install, patch and upgrade SQL server • Maintain database security policy, permissioning, and user accounts • Manage database backup and data retention strategy • Troubleshooting • Performance Tests • Integration Services (ETL) • PowerShell & T-SQL scripting Database Administration on Sybase ASE & SQL Anywhere in UNIX/Linux environments: • Mirroring setup • Backup & Restore strategies • Installations, Configurations • Python & Shell scripting • Automation tasks.