Upwork home
Sign up
Secondary
Muhammad A.
Cambridge, United Kingdom
100% Job Success
Top Rated

Database Admin

Experienced DBA and have expertise in 1. MySQL Administration 2. SQL Server Administration 3. MongoDB Administration 4. Postgres Administration 5. Oracle Administration My focus areas are 1. Designing 2. Deployment, 3. optimization of database system performance (Engine Tuning, Queries Indexing, read/write splitting ) 5. Scalability using HA/Replication tool & Techniques (MySQL master-master & master-slave, Group Replication, InnoDB & Galera cluster solutions, SQL Server Always on Availability Group & Always-on Clustering, transactional replication, log shipping & Oracle Data Guard) 5. Security of the Database System 6. Data Modelling (ERD, Schema Designing, Relationship Defining between Entities) 7. Logic creation using SQL queries, T-SQL & PL-SQL 8. Migration & Upgrade Support (on-premise to Cloud, Cloud to Cloud, Database version upgrade) 9. Monitoring (Nagios, Percona Managment & Monitoring (PMM2) and prometheus & grafana). 10. Troubleshooting I have optimized and provided HA/Replication of backend databases for products like CRM, wooCommerce, WordPress, retails, bank, bioinformatics research, and so on. I have experience with monitoring tools. I have experience managing databases both on-premise and cloud, such as AWS, Digital Ocean. We also provide monthly support to the customers freeing you from managing your Database Infrastructure. I have intermediate experience in DevOps tools such as Docker & Kubernetes, CI/CD such as Jenkin, Ansible, Git, Gerrit. I also have experience in AWS VPC, EC2, ELB, Route53, RDS, Subnetting.
Muhammad A. has more jobs. Create an account to review them

Skills

  • MongoDB
  • Database Administration
  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • Database Design
  • Kubernetes
  • Docker
  • Git
  • Database Programming

Browse similar freelancers