SESHADHRI SRINIVASAN
Ilford,UNITED KINGDOM
Summary
Successful database professional equipped with in-depth understanding of database development and design. Highly knowledgeable about database structures and tools.
12+ years of professional experience with database administration for Oracle, SQL & IBM DB2 with proficiency in PHYTHON programming.
9+ years of professional experience in United Kingdom with Top multinational Finance, Wealth Management & Banking Sectors.
Currently working with Lloyds Banking Group.
Overview
13
13
years of professional experience
Work History
Domain consultant - Database Administration
Wipro Technologies UK , Lloyds Banking Group
London, United Kingdom
09.2022 - Current
- Developing technical solutions in specific to Database management to diverse operational problems in the payments platform within the Lloyds Banking Group.
- Providing 24/7 database administration consultation and support for High availability database solutions Oracle Data guard, Oracle RAC, IBM DB2 & Oracle Exadata.
- Researched and integrated new database management tools such as tools not limited to Splunk, Dynatrace & Oracle Enterprise manager to meet the Bank's needs from deployment and monitoring perspective.
- Responsible for writing, refactoring and debugging SQLs and understands the best ways to incorporate database requests into application programs.
- Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
- Supporting and documenting the implementation of approved changes to system configurations, software, and infrastructure within the approved testing schedule .
- Technical expertise in Oracle DB implementations, performance tuning, Database maintenance and trouble shooting.
- Worked successfully under Agile methodologies with various Stake holders to deliver on-time projects in terms of solutioning and delivery.
- Designed Gateway hosting Database solutions, Implemented the Multi Dimensional clustering across the platform in IBM - DB2 estate.
- Executed tests at different stages of design and production to validate, debug and improve code in the faster payments Banking platform.
- Resolved key performance issues quickly through accurate root cause identification and have expertise in Database availability and security.
Oracle Database Lead
HCL Technologies UK, Quilter Financial services
Southampton
11.2015 - 08.2022
- Works collaboratively with other teams including Project Managers, Developers, and Architects to ensure project delivery
- Providing 24/7 database administration support for High availability database solutions Oracle Data guard,Oracle Fail-safe and Oracle RAC
- Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning
- Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security
- Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Servers
- Leading the platform migration, On premise to Oracle cloud Infrastructure
- Actively working on the OCI interface, supporting design and data migration
- Develop and improve procedures for monitoring (Enterprise Manager) and proactive intervention, preventing customer impact
- Technically leading my team and responsible for end to end process flow
- Migrating Databases from legacy versions such as 10G/11G/12c to latest 19c&21c
- Providing ongoing progress to leadership, system owners, and peers regarding health of the environment and status of testing
- Supporting and documenting the implementation of approved changes to system configurations, software, and infrastructure within the approved testing schedule
- Technical expertise in Oracle DB implementations, maintenance, and trouble shooting
- Refreshing development databases from PROD using RMAN and exp/imp/Data Pump
- Performing Backup/Recovery with RMAN and automate the backup using crontab
- Cloning Databases Using RMAN, Hot backup
- Managing Database Performance using (Stats pack, AWR,ADDM,ASH,TRACE FILE, TKPROF, EXPLAIN PLAN.)
- Applying Oracle Critical Patch Updates (CPU Patches) and O Patch
- Resolving complex issues involving: database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology
- Technically helping infrastructure Teams for any infrastructure migrations and technical implementations
- Recovering high availability databases via Rman, restore point and Netbackup
- Technical lead for infrastructure Tech-upgrade, Migrating datacentres and upgrading databases from 11G to 12C via FTTS
- Strong hands-on in Managing databases via Oracle enterprise manager for performance monitoring and defining rules for alerts in high availability enterprise databases
- Oversees capacity planning including CPU utilization and space management
- Makes recommendations to improve processes.
Oracle Database Administrator
HCL Technologies
Chennai
10.2012 - 10.2015
- Installation, configuration and up gradation of oracle server
- Managing complete DR testing using high availability in the oracle data guard and Oracle failsafe
- Taking full / differential database backups of all system and production databases
- Database patching on Production and Non-Production Instances using Opatch utility
- Reorganizing Table-space, Tables or Indexes
- Table-space management, resizing and adding data files as and when necessary
- Performing DB refresh for test and development purpose,creating users and Granting specific privileges
- Regular Backup, Monitoring & Maintenance of production, model and development databases
- Automated all the routine manual tasks which includes backups, growth monitor and health checks
- Data pump - EXP/EXPDP - IMP/IMPDP utility (full database backup and schema level backup)
- Configured DR databases and restored using RMAN backups in (2013/14) and managing the entire oracle inventory across the Oracle estate
- Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment
- Configured and Maintained Fail-Over Clustering using SQL Server 2012 Experience in AlwaysOn environment Maintained server and database security including database encryption (TDE) Installed and Configured SQL Server Reporting Services (SSRS) Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
- Core Qualifications
Education
Oracle Certified Professional -
Oracle Cloud Infrastructure Foundations - undefined
2021
Oracle Autonomous Database Cloud - undefined
2021
Bachelor's - Computer Science Engineering
Tagore College of Engineering
2012
Skills
PROFESSIONAL SKILLS :
- Strong troubleshooting and issue resolution skills & Excellent communication & customer interaction skills
- Excellent communication skills and proven documentation skills
- Experienced performance/development DBA who can demonstrate strong technical skills and understanding Proven
- Analytical skills, strong judgment and works effectively with others
- Effective English written and oral communication skills, excellent problem resolution skills
- Experience with Strong Oracle Performance Tuning skills Problem solving skills and the skills to manage projects creatively
- Pursuing Generative AI- ML/LLM/ARAG
TOOLS :
- MKS, JIRA, Confluence, Splunk, Dynatrace, HP-ALM, ServiceNow & Assyst Oracle Enterprise Manager(OEM)
TECHNICAL SKILLS :
- Databases : Oracle 21c,19c,12c,11g, 10g, SQL Server 2012,2014 & 2016,IBM DB2 - 105,111 & 115
- Tuning/Monitoring/Tools/Utilities: RAC 12cR1/R2,11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g/12c,19c,21c
- DB Cloning, Physical Standby Databases, RMAN 9i/10g/11g/12c/19c,21c, TKPROF, EXPLAIN PLAN, STATSPACK, OEM, Oracle Management Server
- Operating System Linux, Unix, Aix, Windows & Solaris
- Knowledge in Exadata & OCI
- SQL Loader, SQL Server, SQL Developer, Export/Import, TOAD, Data pump, Query builder, Net Backup
Timeline
Domain consultant - Database Administration
Wipro Technologies UK , Lloyds Banking Group
09.2022 - Current
Oracle Database Lead
HCL Technologies UK, Quilter Financial services
11.2015 - 08.2022
Oracle Database Administrator
HCL Technologies
10.2012 - 10.2015
Oracle Cloud Infrastructure Foundations - undefined
Oracle Autonomous Database Cloud - undefined
Oracle Certified Professional -
Bachelor's - Computer Science Engineering
Tagore College of Engineering
Similar Profiles
ASIFA MARZIAASIFA MARZIA
Senior software engineer at Lloyds Banking Group via WIPRO TechnologiesSenior software engineer at Lloyds Banking Group via WIPRO Technologies
Varun JayaramanVarun Jayaraman
Senior Release Engineer at Wipro Technologies @Lloyds Banking GroupSenior Release Engineer at Wipro Technologies @Lloyds Banking Group
Bharath Kumar Manvi GollaBharath Kumar Manvi Golla
Performance Test Engineer for Internet Banking at Wipro Technologies, Client Lloyds Banking Group (LBG)Performance Test Engineer for Internet Banking at Wipro Technologies, Client Lloyds Banking Group (LBG)
Sanura GamalathgeSanura Gamalathge
Housekeeper at THE OCEAN COLOMBOHousekeeper at THE OCEAN COLOMBO
Mangesh YadavMangesh Yadav
Senior data engineer at Tata Consultancy ServicesSenior data engineer at Tata Consultancy Services