Nasir Z.

I am experienced System Administrator, AWS expert, Windows server , LAMP stack, troubleshooting and performance tuning expert. I have excellent DevOps skills on AWS and Azure. I am also a Certified Database Administrator, Certified Database Developer and DB architect. I have extensively worked in MS SQL Server, AWS RDS, MySQL, MariaDB, Postgre SQL, Azure CosmosDB, and Oracle. My Technology Consulting and Services focuses on delivering solutions across the following critical business areas: • E-commerce (B2B /B2C Systems) • Web/Application Development • ERPs/ CRMs Development and Integration • Quality Assurance Services • Client Server Applications • Enterprise Application Integration • Database Administration and Performance Tuning • System Administration and Troubleshooting • Cloud services and DevOps • CI/CD and Deployment Automation Having overall 15+ year experience, I possess great expertise in RDBMS administration, monitoring, clustering, replication, high availability and disaster recovery. I have experience of DB server and database performance tuning and completed multiple performance tuning jobs. I possess exceptional skills in SQL, ETL, backup & recovery, indexing, partitioning, writing complex queries/ Stored Procedures, rewriting queries which are creating deadlocks/ bottlenecks to ensure optimal performance. I have great skills in performance tuning and optimization. I have performed database audit to find out root cause of performance bottlenecks. I provide my recommendations and implement them to achieve optimal performance. I have experience of optimizing DB performance on huge data and tables containing billion+ records. I have 12+ year experience as system admin. I have done Windows environments administration, handled installations, configurations, deployments, DevOps, establishing CI/CD pipelines and management of mission critical Live production servers (AWS, Azure, On-premise), Ecommerce websites, huge databases on Windows, Ubuntu, Linux, Debian, CentOS and macOS. I am good in containerization using Docker, K8 and ECR. I am also hands-on on virtualization and cloud services. I also possess expertise in bash and shell scripting for both Windows and Linux along with command line. I have expertise to setup and configure DNS, DHCP, SMB, SNMP, SMTP, POP3 and IMAP. I have setup firewalls and VPN configurations and possess excellent understanding of server security and best practices. I have more than 5+ year experience with AWS/ Azure DevOps. I have excellent expertise and skills in establishing CI/CD pipeline to automate deployments from different GIT branches to AWS. I have expertise on establishing CI/CD using GitHub Actions and AWS services i.e. CodeCommit, CodeBuild and CodeDeploy.