DevOps & Site Reliability Engineer •  MyCase (SAN DIEGO - USA)

August 2019 - Present

Responsible for implementing and supporting the CI/CD pipeline processes and database infrastructure of about 20 production servers running MySQL instances & managing Linux servers Centos, Redhat, Ubuntu.
➢ Develop and create stored procedures, advanced queries, triggers, views, indexes, and functions for databases.
➢ Using tools like Jenkins, Sonarqube, JFrog, ECR and GitHub to automate a continuous integration process.
➢ Working with software developers and software engineers to ensure that development follows established processes and works as intended.
➢Resolving daily basis Jira stories, Provisioning different infrastructures using IAC (TERRAFORM)
➢ Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
➢ Integrating MySQL plugins to datadog to start monitoring slow running queries.
➢ Granting and Revoking access to different software (datadog, new relic, github, awes, etc...).
➢ Optimized system and application performance using techniques like shutdown, reboot, start and stop services and tools to identify performance issues and solutions
➢ Expertise in using DBCC trace flags, handling blocking and deadlock situations.
➢ Examine the capability of the software to expand as users save data to it
➢ Provides trend analysis to the service management team to enable them make informed decisions regarding resource management.
➢ Creating a new Jira ticketing system especially for various requests of Ops team.
➢ Planning out projects and being involved in project management decisions.
➢ Keeping all code changes into a single system so that it can be modified and tested
➢ Setup the yum repository in the server, upgrade the repository by appropriate patching and installing software packages and services using yum and rpm as required.
➢ Extensively worked on troubleshooting and fine-tuning of databases for performance.
➢ Responsible for security and non-security patches based on company approved maintenance schedules.
➢ Query optimization and improving overall performance, deploy updates and fixes
➢ Performed day to day Linux administration tasks such as user account management, directory services, file system sharing and permissions.
➢ Develop and maintain cooperative and collaborative relationships with networking, storage, software development, and project management teams
➢ Work with software developers and Quality Assurance to seamlessly migrate applications from development to QA and production.

AWS System Administrator & Database Administrator  •  ALLIED UNIVERSAL (Houston - USA)

June 2017 - July 2019

Providing production support to a leading computer and tech support company for multiple clients across the country.
➢ Helping the client with creating and deploying a stable database infrastructure, carefully learning metrics and monitoring the health or use of AWS resources on a full scale by leveraging Amazon CloudWatch.

➢ Provisioning various AWS environments (dev, staging, prod...) according to business needs.

➢ Keeping sensitive information like user logins and API keys in Secrets manager.
➢ Create and implement the best backup and recovery strategies based on business requirements.
➢ Improve the Server performance and SQL server optimization. Creation and management of VPC, C2S access points, Bastion Hosts, and URL proxies
➢ Troubleshoot performance-tuning issues by running SQL server Profiler, creating traces and running these traces in SQL Server Database Engine Tuning Advisor and analyzing the reports.
➢ Analyze poor performing queries and tune the same to using the execution plan to optimize application and database performance, Approve Images For Use As Catalog Items
➢ Implemented smart index maintenance process; re-organizing and rebuilding indexes based on volume of fragmentation, configuration and fine-tuning of cloud infrastructure systems
➢ Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance tests.
➢ Planning & Implementing High Availability & Disaster Recovery with minimal downtime.
➢ Designing process flows & creating templates for each and every service used and provided.

Database Assistant  •  ICT (Liverpool - England)

February 2014 - May 2016

Provide support for the entire database environment: PROD, UAT, QA, TEST, and DEV .
➢ Create new database logins and users as required.
➢ Applying necessary SQL Server database patches and installing service packs.
➢ Worked as part of a 24x7 on-call support for Production Databases.
➢ Troubleshoot disk, network, memory, and CPU related performance issues on high volume OLTP servers.
➢ Set up Always On Availability Groups for SQL Server 2014 databases.
➢ Designed the backup and recovery strategies for SQL Server databases to meet our customer SLA requirements. Responsible for driving the consolidation and upgrade efforts of all database systems into SQL Server2014.
➢ Performing frequent health checks for all backups and mission-critical production databases
➢ Creating and analyzing daily reports for mission-critical databases.
➢ Monitoring of servers using SQL Sentry third party tools that extends across all platforms and data centers.
➢ Revise and improve current monitoring strategies for the entire database enterprise.
➢ Standardize processes for the DB team by creating documentation for
installations, migrations, upgrades, backups, restores, index maintenance.
➢ Revise current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure.
➢ Ensured availability of instance and databases via clustering and mirroring.
➢ Create reports that run daily for jobs running in SQL Server Agent