Jaikiran Keerthi Email & Phone Number

Cirencester, Gloucestershire, Gb

Seattle, Washington, Us

Essen, North Rhine-Westphalia, De

Designed and implemented high-resilient, mission-critical database infrastructures on AWS and on-premise for RWE Group. Expertise in AWS services including RDS, S3, EC2, Lambda, and Redshift. Developed Infrastructure-as-Code solutions using CloudFormation, integrating with AWS Config and Azure DevOps. Led complex database migrations to AWS RDS Aurora and PostgreSQL, while implementing data governance and security standards across multi-account environments.

London, Gb

San Diego, Ca, Us

Atlanta, Georgia, Us

On-site @Tesco, Cheshunt

Atlanta, Ga, Us

London, Gb

Worldwide, Gb

Led a 6-week project integrating Conflict Management and New Business Intake systems into a consolidated Automated Workflow system. Designed and developed ETL packages using SSIS for process automation. Upgraded SQL Server from 2005 to 2008R2 Enterprise Edition, migrating data from legacy systems to a new schema. Implemented index partitioning and data compression for high-volume tables. Established maintenance plans, DR strategies, and robust backup solutions for business-critical databases.

Essen, North Rhine-Westphalia, De

Oversaw implementation and daily operations of critical database systems, leading major data center migration projects. Designed and implemented SQL infrastructure, focusing on migrating trading systems from UK to Germany with minimal business disruption. Managed diverse responsibilities including physical database design, security configuration, performance optimization, and maintenance of SQL Server instances across versions 2000 to 2008R2. Implemented high availability solutions such as geo-failover clustering and synchronous mirroring. Established Central Management Server for SQL estate configuration and utilized SQL Utility for performance monitoring. Collaborated with IT teams on hardware planning, SAN issues, and backup strategies. Provided 24/7 support and installed SharePoint 2010 Farm for team CMS and trading applications.

Lk

Working for short term contracts and freelancing for private clients.Responsibilities:Created and maintained various databases for Production, Development and Testing environments using SQL Server 2005/2008.Provided day-to-day support for development and test environment databases.Consolidation, Cleansing, Integration, ETL, and customization of data.Created and designed databases, application tables, indexes, triggers, stored procedures and views. Provided maintenance, tuning replication, troubleshooting and managing user logins.Troubleshoot performance issues and provided recommendations for optimizations.Optimized Query Performance, Session Performance and Reliability.Maintained relationships and data models of existing database and its new version.Created complex procedures.Wrote complex SQL queries for data retrieval.Extensively working on Report Designing for Management Reports using SSRS.Handling all the Report errors and supporting Reporting Servers.Configured Subscriptions and Security for all critical reports. Environment: MS SQL Server 2005/2008, SSRS, VS 2005, SQLProfiler, Litespeed, Windows 2003 servers, DBArtisan.

Houston, Texas, Us

Worked on short term project to solve all the existing Production issues in Reports and Packages and also involved in some critical Report designing.Responsibilities:Extensively worked on Report Designing for New Market Implementations.Created stored procedures to use as the datasets for the Report Design.Design and Build Forms based NGSA reports for Gas and Electric Contracts.Develop metadata models, schemas and views to support user-defined reports.Design and Development of SSIS Packages to load data to Datamarts for Accounting Database to generate critical reports.Extensively handled all Report production issues like Pagination, Report Logic, Formatting issues, Report Visibility, Duplicate data, Filtering, Sorting, Grouping issues etc.Extensively worked on Report coding to behave according to the front end CRM Application.Configured Subscriptions and Security for all critical reports.Handled the database components (Code migration, Change control) for application releases.Environment: MS SQL Server 2000/2005, SQL Server Reporting Services, SQL Server Integration Services, Windows 2003 servers, CVS, Microsoft

Installed and Configured SQL server 2005/2008 servers across the company.Created and maintained various databases for Production, Development and Testing environments using SQL Server 2005/2008Have Migration experience from SQL server 2000 to 2005 using both Inplace Upgrade and Rebuild methodologiesCreated various database objects like table, stored procedures, functions, and triggers. Involved in scheduling and maintaining batch jobs thru SQL Server Agent and thru various VB script, and .bat files.Performed daily backups and developed recovery procedures.Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server.Creation of new database, planning the location of data, index, and transaction log files on the disks of various RAID LevelsSetup/Implement Backup/Recovery methodologies for the databases and integration and automation of jobs through Maintenance plans and 3rd party schedulers.Worked on linked servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.Handled 24/7 production issues. Environment: MS SQL Server 2005/2008, SQLProfiler, Perfmon, Litespeed, Windows 2003 servers, VSS 6.0

Bangalore, Karnataka, In

Involved in Onshore Recruitment for USA based IT Industry

North Royalton, Ohio, Us

Responsible for In-house recruitment.

Entrepreneurship/Entrepreneurial Studies

Bachelor Of Science, Life Sciences