Lokesh Jajoo — Associate Consultant

SUMMARY: • Renowned database expert with 16+ years of experience spearheading the design, management, and migration of mission-critical databases across on-premises and cloud environments. • Proven track record of ensuring high availability, scalability, and robust data protection for enterprise-grade database systems. • Adept in a diverse database landscape, from RDBMS (Oracle, MySQL, PostgreSQL) to NoSQL (MongoDB, DynamoDB) and AWS's cloud-native solutions (RDS, Aurora, DocumentDB). CORE EXPERTISE: • Database Design & Architecture: Design and optimize efficient, scalable database structures aligned with business objectives and performance requirements. • Performance Optimization & Monitoring: Continuously monitor, troubleshoot, and fine-tune databases for peak performance and resource utilization. • Migration & Modernization: Lead successful migrations from on-premises to cloud platforms, minimizing downtime and preserving data integrity. Utilize automation tools and advanced schema transformation techniques for exceptional accuracy. • Data Security & Disaster Recovery: Craft robust backup and disaster recovery plans adhering to RTO/RPO guidelines, guaranteeing data resilience and operational continuity. • Collaboration & Automation: Fosters a collaborative environment for database engineers, championing best practices and boosting developer productivity through automated processes and runbooks. IMPACT: • Successfully spearheaded 100+ database migrations (20TB+) across diverse platforms, achieving 99.99% data integrity and minimal downtime. • Developed and implemented automation tools, streamlining routine tasks and enhancing operational efficiency. • Provided invaluable expertise to Engineering teams, streamlining design reviews, security assessments, and performance optimization initiatives.

Stackforce AI infers this person is a Database Architect specializing in cloud solutions for enterprise environments.

Location: Austin, Texas, United States

Experience: 17 yrs 10 mos

Skills

Cloud Architecture
Database Management
Database Design
Cloud Migration
Database Administration
Team Management
Performance Optimization

Career Highlights

16+ years of database expertise across cloud and on-premises.
Led 100+ database migrations with 99.99% data integrity.
Championed automation to enhance operational efficiency.

Work Experience

Visa

Database Engineer, Senior Consultant/Senior Manager – Cloud Platform (1 yr 9 mos)

Qualtrics

Senior Database Engineer (4 yrs 8 mos)

Accenture

Associate Manager, Database Administration (4 yrs 6 mos)

Senior Database Administrator (6 yrs 10 mos)

Education

Bachelor of Engineering (B.E.) at University of Rajasthan

Lokesh Jajoo

Associate Consultant

Austin, Texas, United States17 yrs 10 mos experience

Highly Stable

Key Highlights

16+ years of database expertise across cloud and on-premises.
Led 100+ database migrations with 99.99% data integrity.
Championed automation to enhance operational efficiency.

Stackforce AI infers this person is a Database Architect specializing in cloud solutions for enterprise environments.

Contact

Skills

Core Skills

Cloud ArchitectureDatabase ManagementDatabase DesignCloud MigrationDatabase AdministrationTeam ManagementPerformance Optimization

Other Skills

AWSAWS Cloud MigrationAWS RDSAmazon AuroraAmazon DynamoDBAmazon ElastiCacheAmazon Relational Database Service (RDS)Amazon Web Services (AWS)Analytical SkillsAuroraAutomationAzureBackup & Recovery SystemsCapacity PlanningCloud Database Service

About

Experience

Visa

Database Engineer, Senior Consultant/Senior Manager – Cloud Platform

Jun 2024 – Present · 1 yr 9 mos · Austin, Texas Metropolitan Area · Hybrid

As a Database Engineer, Senior Consultant/Senior Manager – Cloud Platform Architecture, I provide architecture guidance and technical expertise for various platform components like database and middleware products in public cloud environments. My role focuses on developing and maintaining cloud architecture frameworks, including cloud-native solutions leveraging the latest cloud technologies and best practices, with a specific emphasis on AWS, Azure, and GCP.
Responsibilities:
Provide architecture guidance for cloud platforms such as AWS, Azure, and GCP.
Develop and maintain cloud architecture frameworks and cloud-native solutions.
Prototype solutions and convert proofs-of-concept to production deployments.
Collaborate with diverse teams (Infrastructure, Platform, Cyber Security, Product Development) to establish public and hybrid cloud solutions.
Address technology, regulatory, security, and competitive challenges using cloud infrastructure.
Lead workload migration from private to public cloud environments.

AWSAzureGCPCloud ArchitectureMiddleware ProductsDatabase Management

Qualtrics

Senior Database Engineer

Sep 2019 – May 2024 · 4 yrs 8 mos · Seattle, Washington · Hybrid

Spearheaded the design, deployment, and optimization of a high-performing, multi-cloud database ecosystem for Qualtrics, encompassing diverse technologies like MySQL, MongoDB, PostgreSQL, DynamoDB, AWS RDS, Aurora, and DocumentDB. Championed automation, Infrastructure as Code (IaC), and best practices to enhance developer productivity and operational efficiency.
Key Achievements:
Migrated mission-critical databases to the AWS cloud, leveraging Lift & Shift strategies and AWS Database Migration Service (DMS) to achieve scalability and performance gains. Developed comprehensive runbooks to enable seamless future migrations for engineering teams.
Reduced AWS database costs by 20% through comprehensive audits and strategic optimizations, identifying over-provisioned instances and implementing cost-effective instance classes and lifecycle policies.
Streamlined database provisioning and deployments using Terraform automation,
enabling swift creation of AWS resources with integrated CloudWatch monitoring.
Engineered and standardized database configurations using Puppet manifests, incorporating best practices and boosting engineering team efficiency by 30% through rapid and uniform
deployments.
Implemented automated backups, monitoring, and alert systems, ensuring optimal
database health and proactive issue resolution.
Conducted performance optimizations for multiple MongoDB deployments, resolving
bottlenecks by tuning parameters, scaling hardware, implementing strategic resharding, and creating indexes.
Led the standardization and streamlining of database deployments with Docker
containerization, ensuring consistency and reducing deployment times by 50%
across all engineering teams.
Developed and maintained an extensive wiki of database process documentation,
including best practices, detailed runbooks, and troubleshooting manuals, serving as
an essential resource for the engineering team.

MySQLMongoDBPostgreSQLDynamoDBAWS RDSAurora+6

Accenture

2 roles

Associate Manager, Database Administration

Promoted

Mar 2015 – Sep 2019 · 4 yrs 6 mos

Spearheaded a high-performing team of 20 distributed DBAs, ensuring 24/7 uptime and
optimal performance for mission-critical databases across Oracle, MySQL, PostgreSQL, and
MongoDB. Championed strategic planning, cross-functional collaboration, and automation to
maximize team efficiency and system reliability.
Key Achievements:
Led strategic roadmap development, aligning database initiatives with business goals
and prioritizing key projects for maximum impact.
Orchestrated complex cross-platform and heterogenous migrations of 100+
databases.
Boosted database performance and resource utilization through proactive capacity
planning, performance optimization, SQL tuning, and sophisticated storage
management strategies.
Strengthened database security by implementing automated monitoring tools and
scripting.
Deployed bi-directional Golden Gate replication with effective conflict resolutions.
Enhanced developer collaboration, providing expert guidance on schema design,
optimizing database code deployment workflows, and facilitating rigorous
performance testing, leading to a 30% reduction in development cycle time.
Optimized MongoDB deployments by establishing efficient replica sets and sharded
clusters, implementing automated backups and recovery procedures, and deploying
advanced monitoring solutions.

OracleMySQLPostgreSQLMongoDBSQL TuningPerformance Optimization+3

Senior Database Administrator

May 2008 – Mar 2015 · 6 yrs 10 mos

Delivered high-performance, highly available Oracle & MySQL database solutions for leading
e-commerce, banking, and telecommunication clients across the globe. Successfully
architected, deployed, and maintained mission-critical databases that supported vital business operations and ensured data integrity.
Key Achievements:
Scalability & Availability: Designed and implemented robust Oracle standalone databases and Real Application Clusters (RAC) to handle demanding workloads and ensure continuous uptime for clients like AT&T, NAB, and RBS.
Data Protection & Recovery: Architected and implemented comprehensive backup and recovery strategies using RMAN, guaranteeing data preservation and swift restoration capabilities in case of outages.
High Availability & Replication: Established bi-directional replication for Oracle databases with Golden Gate and configured high availability systems using Oracle Data Guard, minimizing downtime and maximizing data accessibility.
Performance Optimization: Optimized database performance through proactive monitoring, AWR/ADDM analysis, and targeted tuning initiatives. Reduced bottlenecks by implementing automated alerts, SQL tuning, and creating optimal indexes.
Database Maintenance: Managed schema changes, implemented data archiving processes, applied security patches, and led disaster recovery drills to ensure database health and system resilience.