Shanawaz Ahamed Basheer Ahamed
Cloud Database Administrator/ Architect
Jönköping
Summary
Experienced and responsive database professional with expertise in architecting, monitoring, and optimizing database performance. Skilled in troubleshooting issues and possessing a deep understanding of database technologies and systems. Strong analytical skills and excellent problem-solving abilities enable effective resolution of complex challenges. Equally comfortable working independently or collaboratively, utilizing excellent communication skills to ensure seamless collaboration with cross-functional teams.
Overview
12
12
years of professional experience
5
5
years of post-secondary education
13
13
Certifications
Work History
Senior Database Engineer
Circles.Life
10.2022 - 08.2024
- Did R&D, POC and Worked on setting up DevOps CI/CD pipelines for Database Deployment using GitLab and Liquibase
- Closely worked with Platform Engineering team to set up ephemeral DB environments for Developers and Testing use cases using GitLab, Docker and Kubernetes
- Architectural DB design for a new country launch for MariaDB, MySQL, MongoDB, Redis (Upstream Stack)
- Improved query efficiency by 40% by setting archiving strategy, optimal indexing and tuning DB parameters
- Reduced cost by more than 40% by database modernization, changing DR strategy, moving to Managed and cloud native database wherever possible and changing to the cost-efficient instance types
- Improved Database monitoring and observability stack by using New Relic, Grafana and Oracle Enterprise Manager.
- Designed robust disaster recovery plans that ensured minimal impact on business operations during unforeseen events affecting the company''s data infrastructure.
- Performed comprehensive database health checks, identifying areas of improvement for optimal performance.
- Evaluated emerging technologies to ensure continued growth of the organization's databases, incorporating cutting-edge advancements as appropriate.
Senior Database Consultant
Nityo Infotech (Contract)
04.2021 - 10.2022
- Worked on setting up a new Country launch on AWS environment with respect to managing MariaDB/MySQL and MongoDB
- Designing Database architecture, clustering for High Availability and setting up DR site based in business requirements
- Installation, configuration and management of MariaDB Galera cluster, MongoDB replica set and AWS RDS MySQL
- Did R&D, POC and implemented Cluster Control tool for optimized DB management, observability and monitoring for the MySQL, MariaDB, MongoDB, Redis stack.
- Promoted knowledge-sharing within team through regular presentations on advanced topics such as query optimization techniques or new features in popular databases.
- Conducted regular reviews of existing systems to identify areas for improvement, leading to continuous enhancement of database functionality.
AWS Database Admin
Computer World S.P.C (Bahrain)
10.2018 - 04.2021
- Deputed at Bahrain's IT governance and contribute as a team member for Ministry Infrastructure Migration Program
- Installation and configuration of RISC RN150 in VMWare and Hyper-V machines in the ministry’s infrastructure
- Asset discovery and generation of application dependency report
- Requirement gathering, solution design, and implementation
- Migration of legacy and physical servers using Cloud Endure
- Creation of EC2 Windows instances, setting up Windows Failover Clustering and migration of SQL Server 2016 Production databases from On-premise to AWS with minimum downtime, and setting up SQL Server Always on availability groups in the AWS cloud
- Creation and configuration of AWS VPC, EC2 Windows instances, Application load balancer, AWS certificates, AWS WAF, SNS, Cloud Watch Alarms.
- Automated infrastructure provisioning using Cloud Formation templates, enhancing scalability and maintainability of the system.
- Optimized database performance by migrating legacy systems to AWS RDS instances, enabling efficient querying and reporting capabilities.
- Evaluated third-party tools and services for potential integration with AWS-based systems, identifying opportunities for enhanced functionality or cost savings.
Technical Lead / Lead DBA Offshore Operations
Cognizant Technology Solutions
11.2016 - 09.2018
- Client: Sotheby’s
- Domain: Information Media & Entertainment
- Database Environment: OLTP and partly OLAP
- Migrating On-Premise Oracle Databases to AWS cloud RDS Instances
- Offloading Oracle schemas to AWS Aurora & MySql
- Upgrading Oracle 11g to Oracle 12c
- Identifying regressed queries using SQL Performance Analyzer and moving the explain plan to the upgraded database
- Setting up OEM 13c OMS and agents and adding AWS database targets
- Optimizing Cost and performance in the AWS cloud infrastructure
- Setting up Oracle TDE adhering to security standards
- Creating and modeling the MongoDB project from scratch
- This involves data modeling, data migration from RDBMS
- Installing and administering MongoDB clusters on AWS EC2 instances
- Sharding planning and estimating overall sharding strategy
- Implementation of MongoDB security cluster authentication using key file
- Setting up Data Archival standards and automating it
- Database scaling / auto scaling, redundancy and high availability for Oracle and AWS Aurora instances
- Schema and index optimization
- Automating database deployments through shell script
- Automating few DBA tasks through shell scripts and Cloud Watch monitoring such as DB connections, disk space, tablespace, CPU and Memory utilization
- Administration and management of all environments such as DEV/QA/STG/PRD.
Information Technology Analyst / Oracle DBA
Tata Consultancy Services
04.2014 - 10.2016
- Client: Staples Inc
- Domain: Retail
- Database environment: OLAP, ODS (Data warehousing)
- Responsible for general maintenance of database, including adding storage as necessary, troubleshooting problems, backup and recovery
- Applying Quarterly Oracle PSU and Hot fix patches
- Administration of Oracle Goldengate replication
- Upgrade Oracle database from 11.2.0.1 to 11.2.0.4
- Setting up FGA Auditing with respect to security standards
- (PCI)
- Consultation of Data Archiving process and automation of yearly archival using partitions and scripting
- Installation of OS Watcher and rectified hardware level performance issues with analysis report
- Managing Users and Server Roles
- Automation of Materialized view snapshots using PL/SQL and Shell scripts
- Installation and testing features using Oracle Real Application Testing (RAT)
- Installation and configuration of OEM agents and adding resources
- Setting up of Oracle Resource manager
- Database refresh using RMAN Cloning
- Database Performance Tuning
- Schedule and Monitoring Jobs
- Optimizing and Trouble Shooting
- Take care of the Database design and implementation (LLD to PLD)
- Setup and maintain documentation and standards
- Work as part of a team and provide 7x24 support when required
- Perform general technical troubleshooting and give consultation to development teams.
Systems Engineer / Oracle DBA
Tata Consultancy Services
07.2012 - 04.2014
- Client: American Express
- Domain: Banking and Financial Services
- Database environment: OLTP
- Worked as a full-time DBA for Non-Production environment (QA/DEV)
- Implementation DBA for Production environment
- Worked as part of a six-member team and setting up a Non-production environment in Oracle Maximum Availability Architecture
- The administration environment follows Oracle RAC, Oracle ASM, Oracle GoldenGate, and Oracle Data Guard
- Migration of Oracle Database from HP UNIX to Red Hat Linux using TTS method
- DB support during Data Centre migration
- Creation and decommission of databases
- Installation and administration of Oracle Goldengate
- Generating and analyzing AWR reports
- Application-level patching with respect to the database (DB code deploy)
- Creating QA Databases from Production backup using Data pump and masking PII data
- Managing Users and Server Roles
- Co-ordination with Offshore and Onsite teams and resources.
Education
Post Graduate Diploma in Business Administration -
ANNAMALAI UNIVERSITY
INDIA 06.2020 - 06.2021
Bachelor of Technology - Computer Science Engineering
SASTRA UNIVERSITY
INDIA 06.2008 - 06.2012
Skills
Oracle
SQL Server
MySQL
MongoDB
MS SQL
AWS RDS/Aurora
GCP CloudSQL
Amazon Web Services (AWS)
Google Cloud Platform (GCP)
Microsoft Azure
Database Troubleshooting
Database monitoring
Certification
AWS Certified Database Specialty
Citizenship
India
Validation
https://www.credly.com/users/shanawaz-ahamed/
Timeline
Senior Database Engineer
Circles.Life
10.2022 - 08.2024
Senior Database Consultant
Nityo Infotech (Contract)
04.2021 - 10.2022
Post Graduate Diploma in Business Administration -
ANNAMALAI UNIVERSITY
06.2020 - 06.2021
AWS Database Admin
Computer World S.P.C (Bahrain)
10.2018 - 04.2021
Technical Lead / Lead DBA Offshore Operations
Cognizant Technology Solutions
11.2016 - 09.2018
Information Technology Analyst / Oracle DBA
Tata Consultancy Services
04.2014 - 10.2016
Systems Engineer / Oracle DBA
Tata Consultancy Services
07.2012 - 04.2014
Bachelor of Technology - Computer Science Engineering
SASTRA UNIVERSITY
06.2008 - 06.2012
Similar Profiles
Karl Josef ModestoKarl Josef Modesto
Customer Happiness Expert - Level II at Circles.LifeCustomer Happiness Expert - Level II at Circles.Life
Janith GunasekaraJanith Gunasekara
Head of Quality Engineering at Circles.LifeHead of Quality Engineering at Circles.Life
Jynnette ChanJynnette Chan
Strategy Implementation Lead at Circles.LifeStrategy Implementation Lead at Circles.Life