Languages
Jaikiran Keerthi
Cloud Solutions Architect & Database SpecialistPreferred skills to work with
All Skills
About
The uploaded file appears to contain important information or data that may be relevant to various topics. Please provide specific queries or indicate what information you would like to extract or learn about from the document.
Experiences
As the Founder of VoxMind, a London-based startup, I am leading the development of innovative solutions in the realm of cloud and database architecture, focusing on creating scalable and efficient technologies to enhance business operations.
- Conceptualized and launched VoxMind in January 2024, driving the vision for a tech-forward company aimed at revolutionizing business processes.
- Spearheading the development and implementation of cloud solutions, leveraging modern technologies to improve data management and operational efficiency.
- Engaging with stakeholders to establish partnerships and secure funding, working towards achieving SEIS (Seed Enterprise Investment Scheme) status.
- Building and nurturing a talented team of professionals dedicated to advancing the company's mission.
- Responsible for setting strategic goals and overseeing the execution of business operations to ensure meeting performance targets.
St. James’s Place Wealth Management is a leading wealth management company in the UK, known for its client-focused approach and financial planning services. As an AWS Architect / Engineer, I played a pivotal role in enhancing the company's cloud infrastructure and delivering scalable solutions.
- Designed and implemented cloud architecture on AWS, ensuring high availability and disaster recovery capabilities.
- Collaborated with cross-functional teams to migrate on-premise applications to AWS, reducing operational costs by 30%.
- Developed automation scripts for deployment processes, improving deployment speed by 50% and minimizing manual errors.
- Conducted performance tuning and optimization of AWS resources, resulting in a 25% improvement in performance metrics.
- Led technical training sessions for staff on AWS best practices and cloud security, fostering a culture of continuous learning.
At Slalom Build, a renowned consultancy that specializes in building innovative solutions for clients, I held the role of Solution Architect focusing on Cloud, DevOps, and Security. My responsibilities included:
- Leading the design and implementation of cloud-based solutions to enhance operational efficiency and security for enterprise clients.
- Collaborating with cross-functional teams to establish DevOps practices that streamline development and deployment workflows.
- Conducting assessments of security measures and providing recommendations to mitigate risks associated with cloud infrastructures.
- Engaging with clients to understand their unique challenges and tailoring solutions that align with their business objectives.
- Driving initiatives for continuous improvement, resulting in a significant reduction of deployment times and improved software performance.
As a Cloud Consultant at RWE from June 2015 to March 2021, I played a pivotal role in designing and implementing mission-critical database infrastructures across both cloud and on-premises platforms. RWE is a major player in the energy sector, providing innovative solutions and services. In this role, I was responsible for:
- Designing and deploying AWS infrastructure and services for multiple operating companies within the RWE Group, ensuring high resiliency and security.
- Leading the migration of large database estates to new technology platforms, enhancing operational efficiency.
- Collaborating with stakeholders to conduct deep technical architecture discussions, producing high-level and low-level designs that aligned with the IT roadmap.
- Implementing comprehensive cloud security principles and service control policies to safeguard multi-account environments.
- Developing automation scripts using Infrastructure-as-Code (IaC) methodologies, including CloudFormation and Terraform, significantly improving deployment speed and reliability.
- Spearheading the migration of 80 critical Oracle RAC databases to AWS RDS Aurora and PostgreSQL, including a successful schema conversion process.
- Implementing serverless technologies to support mission-critical applications in the trading domain using AWS Lambda and DynamoDB.
- Managing teams of offshore and onshore database architects, ensuring seamless project execution and support for database operations.
These efforts not only optimized database operations but also aligned with RWE's vision for digital transformation and operational excellence.
Dr Foster Intelligence is a healthcare data and analytics company dedicated to improving patient outcomes through actionable insights. In my role as a DevOps DBA, I was responsible for enhancing the deployment and integration processes within the organization.
- Designed and implemented automated build and deployment processes for the data warehouse and complex ETL packages, enabling continuous integration.
- Developed new process flows for deployments across various environments and established effective ETL data processing.
- Created custom templates and PowerShell scripts to streamline the build process for databases and SSIS packages.
- Installed and configured Team Foundation Server (TFS) 2013 build server utilizing SQL Server 2014 and Visual Studio 2013 for improved application lifecycle management.
- Facilitated the synchronization of TFS Work Items with JIRA for comprehensive project tracking and defect management.
- Provided design input for the central data store infrastructure and contributed to the development of industrial standards for ETL processes.
- Developed configuration change templates for SSIS deployments to maintain consistency and control across projects.
- Provided day-to-day production support and ensured effective release management procedures were in place.
Cubic Transportation Systems, based in Redhill, UK, is a global leader in providing technology solutions for the public transport sector. As a Production DBA, I played a crucial role in managing and optimizing the database infrastructure for various transportation systems including London's Oyster Card and national rail ticketing systems.
- Responsible for supporting complex infrastructure involving SQL Server deployments and ensuring availability and performance.
- Implemented SQL Partitioning and data management standards to enhance production environment efficiency.
- Executed daily business-as-usual (BAU) tasks for development, test, and production environments, ensuring smooth operations across the board.
- Managed a complex Service Broker messaging system within a clustered environment, contributing to overall system reliability.
- Installed and configured disaster recovery solutions using SQL Server AlwaysOn technology, enhancing data resilience.
- Developed and implemented SQL Server Integration Services (SSIS) packages for daily operations and reporting, streamlining data workflows.
- Designed and maintained SQL Server Reporting Services (SSRS) reports for management dashboards and analytics.
- Provided 24/7 production support, incident and problem management to minimize downtime and data issues.
PRGX is a leading provider of recovery audit services and analytics for companies around the world. As a SQL/BI Consultant, I played a vital role in enhancing data integration and reporting processes for the Cost-Harmonization project on-site at Tesco.
- Designed and developed SSIS packages specifically for product aggregation, significantly improving data processing efficiency.
- Produced comprehensive reports using SSRS to estimate yearly purchase and sales projections for each global supplier, facilitating better decision-making.
- Engaged in designing a tool for product matching, contributing to improved accuracy and operational workflows.
- Conducted triple-net costing analysis to support financial transparency and operational cost assessments.
- Provided ongoing support for SQL Servers, ensuring optimal performance and reliability throughout the project duration.
CCUK Finance Ltd is a financial services company focused on providing innovative loan solutions. As a SQL Architect, I played a pivotal role in the design and implementation of the data infrastructure.
- Designed infrastructure and data models for large financial data warehouse and transactional databases.
- Upgraded legacy SQL Servers to the latest SQL 2014, enhancing performance and reliability.
- Consolidated legacy server farms into modern Windows 2012 clusters, improving resource management and efficiency.
- Developed ETL packages using SSIS to replace existing Informatica workflows, streamlining data loading into the data warehouse.
- Designed and configured SQL Server Reporting Services (SSRS) with high availability options to ensure uninterrupted reporting capabilities.
- Configured the infrastructure and SQL Server in compliance with PCI standards to enhance security by implementing strong data encryption methods.
- Designed a Central Management Server to effectively manage the SQL and server farm.
- Implemented a disaster recovery strategy using SQL AlwaysOn High Availability Disaster Recovery (HADR), drastically reducing downtime.
Sainsbury's is one of the UK's largest supermarket chains, known for its commitment to quality and innovation in retail. As a SQL Server Database Administrator at Sainsbury's from August 2013 to February 2014, I was responsible for ensuring the integrity, performance, and availability of SQL Server databases.
- Managed SQL Server installations, configurations, and upgrades to ensure optimal performance and security.
- Developed and implemented database backup and recovery strategies to maintain data integrity.
- Monitored database performance and tuned SQL queries to enhance efficiency.
- Collaborated with application development teams to create database designs that support new applications and features.
- Conducted troubleshooting and resolved database issues promptly to minimize downtime.
- Played a role in the migration of databases to new platforms, ensuring seamless transitions without loss of data.
As an SQL Consultant at Dentons, a leading global law firm, I led a 6-week project aimed at integrating the Conflict Management and New Business Intake systems into a consolidated Automated Workflow system. My role involved:
- Designing and developing ETL packages using SQL Server Integration Services (SSIS) for process automation.
- Upgrading and installing SQL Server from 2005 to 2008R2 Enterprise Edition, which included migrating data from legacy systems to a newly designed database schema.
- Implementing index partitioning and data compression for high-volume transactional tables to enhance performance.
- Establishing comprehensive maintenance plans and disaster recovery strategies for business-critical databases, ensuring data integrity and availability.
Freelancing as a SQL DBA / SSRS Developer for various private clients and short-term contracts from November 2008 to August 2009. Responsible for the design, implementation, and maintenance of SQL Server databases in Production, Development, and Testing environments. Key responsibilities included:
- Creating and maintaining databases using SQL Server 2005/2008.
- Providing day-to-day database support for development and testing environments.
- Performing data consolidation, cleansing, integration, ETL tasks, and data customization.
- Designing application tables, indexes, triggers, stored procedures, and views to meet project specifications.
- Conducting performance tuning and troubleshooting for optimal database functioning.
- Optimizing query performance and ensuring reliability in data retrieval processes.
- Working extensively with SQL Server Reporting Services (SSRS) for management report design, which involved handling report errors and supporting reporting servers.
- Configuring report subscriptions and managing security for all critical reporting activities.
This role leveraged my SQL Server skills, alongside my experience in ETL and reporting, to deliver quality database solutions.
As an SSIS/SSRS Developer at Spark Energy, I worked on a short-term project aimed at resolving existing production issues in reports and packages, while also taking part in critical report design initiatives.
- Extensively involved in Report Designing for New Market Implementations, contributing effectively to new services and offerings.
- Created stored procedures that served as datasets for customized report designs, ensuring accuracy and relevance of data presented.
- Designed and built forms-based NGSA reports for both Gas and Electric Contracts, directly enhancing the reporting capabilities of the finance team.
- Developed metadata models, schemas, and views to support user-defined reports, facilitating better data management and accessibility.
- Designed and developed SSIS packages to load data into Data marts for the Accounting Database, helping generate critical business reports effectively.
- Addressed all report production issues including pagination, report logic, formatting problems, visibility settings, and data integrity concerns such as duplicate data, filtering, sorting, and grouping issues.
- Ensured that report coding was congruent with front-end CRM applications, contributing to seamless user experiences.
- Configured subscriptions and security for all critical reports, safeguarding sensitive information and improving security protocols.
- Managed database components including code migration and change control during application releases to ensure integrity across environments.
Environment: MS SQL Server 2000/2005, SQL Server Reporting Services, SQL Server Integration Services, Windows 2003 servers.
At NACE Technologies Ltd, I served as a SQL Server Database Administrator from January 2008 to May 2008. NACE Technologies is a firm known for its innovative solutions in the technology sector.
Key Responsibilities and Achievements:
- Installed and configured SQL Server 2005/2008 servers across the company, ensuring a robust database environment.
- Created and maintained various databases for production, development, and testing environments, supporting the company's operational needs.
- Conducted migration from SQL Server 2000 to 2005 using both in-place upgrade and rebuild methodologies, facilitating a smooth transition and enhanced system performance.
- Developed various database objects such as tables, stored procedures, functions, and triggers, contributing to efficient data handling and business processes.
- Scheduled and maintained batch jobs through SQL Server Agent and scripts in VB and .bat files, optimizing automation processes.
- Performed daily backups and established recovery procedures, enhancing the data protection strategy.
- Implemented performance tuning using Windows Performance Monitor and SQL Profiler, significantly improving database efficiency.
- Planned and executed the location of data, index, and transaction log files on disks configured with various RAID levels, ensuring optimal data storage solutions.
- Set up and executed backup and recovery methodologies for databases, integrating automation jobs through maintenance plans and third-party schedulers.
- Facilitated linked servers for running distributed queries between SQL Server and other data sources like Excel via ODBC and OLE DB drivers, broadening data accessibility.
- Provided 24/7 support for production issues, demonstrating a commitment to high availability and reliability.
At Arctern, a prominent player in the IT recruitment industry, I held the role of Recruiter from January 2006 to December 2007. My responsibilities encompassed a comprehensive approach to onshore recruitment for the USA-based IT sector.
- Managed the end-to-end recruitment process, ensuring all phases from sourcing to placement were executed efficiently.
- Developed key relationships with candidates and clients, facilitating a better understanding of their needs and aligning opportunities accordingly.
- Utilized various sourcing techniques and recruitment tools to attract top talent within the IT industry.
- Collaborated with hiring managers to clarify job requirements, ensuring a comprehensive understanding of the roles to be filled.
- Achieved a notable increase in successful placements through the development of targeted recruitment strategies.
Vertex Computer Systems is a leading technology service provider specializing in innovative IT solutions. As a Junior Recruiter, I played a pivotal role in supporting the recruitment process for various technical positions within the organization.
- Assisted in the full-cycle recruitment process, from sourcing candidates to onboarding new hires.
- Collaborated with hiring managers to identify job requirements and develop effective job descriptions.
- Utilized online job boards, social media, and networking to source potential candidates.
- Conducted initial phone screenings and coordinated interviews between candidates and managers.
- Implemented various recruitment strategies to improve candidate attraction and engagement.
- Maintained detailed records of candidates and recruitment activities, ensuring accurate tracking of progress.
- Successfully contributed to reducing the time-to-fill positions by streamlining the recruitment process.
Education
Completed the Entrepreneurship Edge Programme at the London Business School, an intensive 12-week venture development journey. This program provided a rigorous environment for developing entrepreneurial skills through hands-on projects, mentorship, and networking opportunities with industry leaders. Participants engaged in practical exercises designed to strengthen their business acumen and innovative thinking. The experience culminated in the presentation of a viable startup concept, demonstrating practical application of learned principles.
As a participant in the AWS Data Lab program, I actively engaged in collaborative workshops designed to accelerate cloud-based innovation through hands-on projects with AWS experts. This experience honed my skills in designing and implementing advanced data solutions, allowing for real-world application of AWS services. Notably, I contributed to various data-driven projects that emphasized the utilization of AWS technologies to create scalable and efficient data architectures. My participation reinforced industry best practices in cloud adoption and significantly enhanced my expertise in leveraging AWS for data analytics and architecture. For more details on my certification, please visit my AWS Data Lab Badge.
Attained the AWS Certified DevOps Engineer – Professional certification from Amazon Web Services (AWS), validating advanced technical expertise in deploying and managing applications on the AWS platform. The certification demonstrates proficiency in continuous integration and continuous deployment (CI/CD) methodologies, automation of manual processes, and implementation of monitoring systems to ensure high availability and performance of applications. The certification is valid until June 2024, with license number 94SQGHNDLMB111WX. To view my certification, please visit: AWS Credly Profile.
Achieved AWS Certified Database – Specialty certification from Amazon Web Services (AWS), validating expertise in database services on the AWS platform. The certification demonstrates proficiency in database management, implementation, and design, along with advanced knowledge of AWS database services and best practices. License number: T24M4JPJD1F41DGL. Detailed documentation of the certification can be found at this link.
Achieved the AWS Certified Security – Specialty credential, demonstrating a comprehensive understanding of securing data and applications within the AWS cloud environment. This certification validates expertise in AWS security best practices, compliance frameworks, and identity and access management strategies. The certification license number is S7ZS9YXDGJEE1Y5W, and further details can be found at the provided URL. This credential is effective from November 2021 to November 2024, indicating a commitment to maintaining current knowledge in AWS security trends and practices.
Achieved the AWS Certified Solutions Architect – Professional certification, demonstrating advanced expertise in designing distributed systems on Amazon Web Services. This certification equips professionals with the skills to create scalable, fault-tolerant architectures, and effectively migrate complex solutions to the AWS platform. The certification license number is B9B90S5LKJB4QPSN, valid until December 31, 2023. This credential showcases a commitment to mastering cloud solutions and best practices, further enhancing professional qualifications in the cloud computing domain.
Completed a Bachelor of Science from Osmania University, where I gained foundational knowledge and skills in Life Sciences. This educational experience provided me with analytical and research skills, which I applied in various practical projects throughout my study period from 2001 to 2004.