Ataurrahman Hashmi

• Accomplished Database Architect and Engineer with over 14 years of expertise in designing, managing, and optimizing database systems for Oracle, Cassandra, MongoDB, and cloud environments (AWS RDS, ExaCC & GCP).
• Adept at collaborating across teams and delivering scalable, cost-effective solutions to meet business needs.
• Cloud Transformations: Worked on Cloud DB configuration and effective implementation of AWS RDS: Oracle/PostgreSQL/Aurora DB engine's and troubleshooting related issues for AWS Enterprise & Business Customers, supporting enterprise-level applications with 99.9% availability.
• Project transitions: Handled and led project transitions for database teams, standardizing and streamlining database operations by implementing ITIL and Agile methodologies.
• Database Project DBA & Consultation: Collaborated on multiple projects from inception through all phases, including Requirement Gathering, Solution Designing, Implementation, and Go-Live, ensuring seamless database integration with application workflows.
• Database Upgrade: Led Oracle, Cassandra, and MongoDB upgrade and cloud migration projects, ensuring minimal downtime and seamless transitions.
• OGG COE: Established Oracle Golden Gate as a Service (GGaaS) across multiple operational units, standardizing data replication processes.
• Database Insights: Worked on self-initiated projects to enhance customer centric SQL's performance, Storage Optimization (gained 100+ TB's), Database Security hardening and GDPR compliances policy implementation on databases with a strong focus on secure architecture and automation.
• Automation Initiatives: Designed tools for database refreshes, monitoring, and performance checks using Ansible, Python, and Shell, cutting manual efforts by 50%.
• DBA Administration: Performed day-to-day DBA tasks including monitoring database health, optimizing performance, managing backups and recovery, ensuring security, troubleshooting issues, and collaborating with teams to support operational and project needs.

• AWS Solution Architect Associate (AWS SAA)
• DataStax Cassandra Admin
• Oracle Autonomous DB Specialist
• ITIL & Safe 5.0 Agile Practitioner
• DB Google Cloud Engineer (Internal)
• DB Google Cloud Data Engineer (Internal)

• Cloud Technology - Database & Infra
• Datawarehouse /OLTP/OLAP
• Telecom (OSS/BSS)
• Ecommerce

Key Accomplishments

• Received Excellence Award for playing an instrumental role in the successful migration of one of the world’s largest data warehouse environments (~4.5 petabytes), ensuring minimal downtime and zero data loss.
• Achieved tenure across AWS RDS (Oracle, PostgreSQL, Aurora) and AWS DMS (Database Migration Service) within just 3 months, accelerating cloud adoption and capability building.
• Led self-driven storage optimization initiatives, resulting in significant OPEX savings by reducing redundant data and improving storage efficiency across enterprise systems.
• Strategically collaborated with cross-functional CIO leadership teams to design and implement an optimal data replication solution using Oracle GoldenGate, enhancing real-time data availability and disaster recovery capabilities.

Oracle 11g/12c/19c 

• Binaries Installation & configuration
• Patching,Upgrade & DB Migrations
• Storage & space management
• Users - Security & Role management.
• Backup & Recovery,DR, Cloning using Standard tools & practices
• E2E RAC/Non-RAC DB Administration
• OEM, Data Guard & RMAN
• DB Performance troubleshooting
• Formal SQL Tuning & Optimizing
• OLTP/OLAP DB schema design & DB creation

Cassandra 

• Installed Cassandra multi-node cluster.
• Cassandra Data Modelling & Application Schema designing.
• Keyspaces, Column families & DC replication strategy implementation.
• Cluster management using Opscentre, Jconsole & nodetool utility.
• Node Commissioning, Decommissioning & Read repair Ops management
• Cassandra Snapshot/ Backup & recovery
• Cluster Performance troubleshooting, read/write latency & CQL tuning.
• User authentication and authorization
• SSTable Utility Usage

MongoDB 

• Installed MongoDB
• Monitoring at Server, Database, Collection level using scripts, OpsManager & MongoCompass
• MongoDB User creation, authentication & authorization.
• MongoDB Data Modelling & managing CRUD ops.
• Setting up replica set adding, removing nodes and MongoDB Sharding.
• Export and Import of data into MongoDB.
• Backup & restore using mongodump , mongorestore utility
• Performing DB & query tuning.

PostgreSQL

• User & Role Management for PostgreSQL
• Database Creation & Management
• Table and Schema Management Create schemas and tables, modify structures
• Backup & Restore using pg_dump, pg_restore
• Performance Monitoring & Tuning slow queries using pg_stat_activity, pg_stat_statements
• Routine Maintenance VACUUM / AUTOVACUUM to clean up dead tuples
• Replication & High Availability (basic), Configure streaming replication and monitor replication lag
• Oracle Golden Gate
• Installed OGG for several topologies & real time data replication.
• Troubleshooting OGG issues using params, Logdump utility.
• Implemented Veridata tool for datasynch.
• OGG monitoring & alerts configurations via OEM & manual Scripts.
• OGG Patching, Upgrades & project implementation
• OGG implementation for Kafka, Cassandra & Bigdata systems
• OGG Performance troubleshooting