Capgemini

As a Senior Manager Solution Architect at Capgemini, I lead a Platform Operations team responsible for Database Operations, Middleware Services, DevOps, and Cloud practices for diverse clients. I also serve as a Technical Account Manager, conducting workshops and maturity assessments to address clients' pain points and drive transformation.

Key accomplishments include:

Designed and implemented robust cloud architectures on Google Cloud Platform (GCP) and AWS, ensuring scalability, security, and performance. Led seamless migrations from on-premises environments to cloud platforms aligned with client strategies.
Helped clients optimize cloud elasticity, ensuring both cost savings and performance improvements for jobs and workloads.
Conducted reviews of service disruptions and defined key performance metrics to ensure system reliability and high availability.
Developed and implemented strategic branch strategies for version control, enhancing team collaboration and promoting continuous improvement.
Led and mentored a team of engineers, fostering their growth in cloud technologies and DevOps practices, while equipping them with cutting-edge tools and techniques.
Drove automation initiatives, minimizing technical debt for clients and improving operational efficiency.
Enhanced customer capabilities through workshops, brown bag sessions, ensuring they adopt best practices in cloud and DevOps.
Played a pivotal role in identifying new business opportunities, leading RFIs/RFPs, and working with clients on staffing estimation and bid qualifications. Contributed to technical sales efforts.

Notably, I led two successful POCs on Generative AI, helping a public sector client with AI adoption, and saving €40K per month for a retail client by optimizing their AI-driven processes. I have been actively involved in shaping technical solutions that address business challenges while driving innovation and measurable results for our clients.

Sr. Manager I&D

Avaloq

In this role, I have been responsible for Database and Middleware Operations, providing on-site consulting for licensed clients and PaaS services for SAAS clients. This role required direct interactions with clients and stakeholders, involving me in end-to-end integration, client meetings for requirement analysis, escalations, and solutions. I have also managed BAU, supporting application teams for various requirements. Here are the highlights from my current role:
•	Engaged with customers onsite for product support and new technical requirement analysis.
•	Designed resilient databases for business-critical applications.
•	Supported the Pre-Sales team for technical issues and presentations for new clients with database-specific requirements.
•	Led Database and Middleware operations for multiple clients and in-house developments.
•	Managed environment migration from one DC to another, from client’s infrastructure to ours, and to cloud platforms.
•	Took direct responsibility for any technical issue/new implementation for any requirement.
•	Performed yearly DR activities in DR drills for client satisfaction for HA solutions.
•	Worked closely with architects (Application and Network) for any new setup/solution for new/existing client.
•	Integrated the product [ACP (Avaloq Core platform) and AFP (Avaloq Front platform)] which required Oracle database installation, patching, application packages rollout, and deployments based on product requirement.
•	Integrated Middleware which involved JBoss and MQ installation and setup at the application layer for AFP (Avaloq Front Platform) and several adapters (i.e., VDF, NICE, OMGEO, FIX bridge etc.) used in wealth management in banking.
•	Worked on Confluent Kafka for Event Driven Architecture.
•	Integrated WAF and IAM (Ergon) for mobile and web application for wealth management.
•	Conducted performance tuning at the database end for any performance issue with the product causing deploy in batch jobs or in routine operation.

Sr. System Manager Database And Middleware Operations

Database And Middleware Specialist

Citi

During this period, I worked onsite at Citi Bank through various consultants and supported multiple projects. Here are the project details:

Cloud Integration Project   [Nov 2016 – March 2018]
While deployed on the payroll of Encora Technologies Pvt. Ltd, I represented Wipro Technologies. My roles and responsibilities included:
•	Managed database migration from existing infrastructure to Oracle private cloud environment, ensuring seamless transition and minimal downtime.
•	Designed load balancing and service management for various applications to maintain high availability of databases.
•	Conducted requirement analyses for application migration from existing infrastructure to cloud services. This involved coordinating with Application owners to collect application requirements, understanding application nature and criticality before migration, and offering solutions.
•	Collaborated with different regions on testing new/beta versions of enhancements to existing releases before releasing them to customers.
•	Prepared and presented demos for application owners to highlight the benefits of database migration from existing infrastructure to cloud environment, including enhanced performance, high availability, and reduced operation cost.

Frame Migration (P7 to P8) and BAU for Global Consumer Group   (Nov 2015- Nov 2016)
While deployed on the payroll of Mind Craft Singapore Pvt Ltd, I represented IBM and handled P7 to P8 frame migration for more than 400 RAC and standalone database servers where the network configuration was changed completely. My roles and responsibilities included:
•	Managed BAU activities and resolved performance issues after migration.
•	Coordinated with Application teams for change control activities, including downtime planning, activity steps, and documentation.
•	Performed database and Grid upgrades.
•	Applied PSU/CPU/one-off patches on GRID and RDBMS software in a rolling/non-rolling manner.

BAU project [March 2015– Oct 2015]

Sr. Technical Consultant Oracle

Cognizant

As a DBA-Lead, I was responsible for the day-to-day operations of a team providing front-line support and maintenance of database systems across the globe (US, UK, India). This included incident, problem, change, and configuration management. I established processes to provide solutions for database-related issues and support requests for Oracle & MSSQL technology. 
Role and Responsibilities: 
• Managed multiple databases for Production/UAT/Dev environments in business-critical requirements for multiple clients across the entire US data center. Production database sizes ranged from 500GB to 10TB, with most databases catering to real-time applications. 
• Analyzed AWR, ASH reports for any bottlenecks. Performed backup and recovery testing; Assisted with database recovery in disaster situations. Gained experience working on OEM and Grid control to proactively prevent disaster situations. Provided support on AWS databases (which includes RDS and EC2).

• Build Physical Standby database for multiple clients based on the requirement documents provided by the client and implemented the standby adhering to strict guidelines.

• Performed Refresh/Clones for several databases for most of the clients on weekly basis from RAC to Non RAC environments and also on standalone systems versions ranging from Oracle 10g & 11g using hot backup, RMAN duplicate and Active RMAN Duplicate techniques based on client Infrastructure.

• Evaluated, Installed, Upgraded & Prepared the documentation on upgrade procedures from Oracle 10g to 11g Version successfully.

• Worked on the in-house implementation of the automation scripts to monitor standby databases.

• Implemented backup scripts for most of the databases using crontab entries for purging archive logs and full backup scripts on scheduled basis for Hosted clients.

• Restored and recovered the databases as and when there is a need depending on the situation for the clone activities.

Sr. DBA

Tech Mahindra

Performed Database Activities for development, testing and production databases running on multiple platforms such as Linux, UNIX. 
 Administered the existing product software deployments and managed development, test and production environments. Responsible for setting up user accounts, profiles, and database space management, managing redo logs, control files, data files and rollback or undo segments. Monitor error log(s), database and log space, user activity and resource utilization of development and production environment. 
 Documentation - includes UNIX kernel changes, backup and restoration strategies, database layout and reorg. of database.
 Implemented nightly backup routines which include database exports, tape backup and copying database files to the development server for precautionary measures. Training for developers and Unix admin in Database concepts, DBA areas and Unix areas.
 Create test environments from production export dumps. Cloning of database for other test related activities.
 Optimized various INIT.ORA parameters based on new server changes and tuning of the database for better performance. Comparison of Databases at schema level using TOAD. Solving the problems of developers and recovering tables using flashback query.
 Experience in Oracle 8.x, 9.x, 10g Server. Client-Server Good Knowledge in Data Guard and RMAN concepts.
 Usages of performance monitoring tools like Oracle DBA Studio, 9i & 10g Enterprise Manager Console.
 Restoration & Recreation of DB's for client support. Moving DB from one server to another server. Responsibilities also included upgrading Oracle database, tools on different platforms, security and backups.
 Testing of the SQL Scripts for the standards maintained by the company. Working closely with System administrator in applying Oracle patch sets on servers while upgrading.

wipro infotech ltd

Worked on DIAL (Delhi International Airport Pvt. Ltd) T-3 New Delhi, project. The project is a joint venture project between WIPRO and GMR.
We were in this project since the implementation phase, where we were running our databases on Oracle RAC clustering on HP-UX 11i servers. We were running 7 critical Oracle 10g databases on RAC with Middle-layer in the three-layer architecture. RAC Databases are running in abstracted layer. Currently we are managing T-3 airport in 24*7 supports.

Implementation Phase:

•	We had configured Shared Server Architecture on one of our main database to handle 2000 concurrent connection coming from T1 and T2.
•	We had successfully implemented Oracle 10g Data Guard for RAC databases in Maximum Availability Architecture (MAA) with OBSERVER.
•	Tuned the entire Oracle Cluster ware, RAC databases, Grid control, character set, ONS, VIP, mount point and Services failover issues.
•	Voting Disk and OCR files moved on shared location.
•	Cluster interface failure test cases for Public or Private LAN/VIP.
•	Implemented and configured the whole backup solution using RMAN on HP Data Protector on Tape library HP MSL 4048.
•	Coordinating with application team for the rest of development phase.
•	Extensive testing has been carried out on RAC load balancing, TAF, services, FCF for JDBC connections to database and VIP failover.
•	Backup failure issues.
•	Commands on RAC, CRS and clusterware administration.
•	Comfortable on UNIX environment as well as its vendor cluster ware        HP-SGeRAC.
•	Got the Outstanding Rating in appraisal based on the project implementation and also appreciation letter from DIAL staff for Data Guard implementation.

Engineer Database Operations

RAMTeCH Software Solutions Pvt. Ltd.

Setup new database servers including the following tasks. 
Evaluated the database server hardware, designed table space layout based on Optimal Flexible Architecture, installed Oracle, created Oracle database, and migrated data from current server to the new server for various projects which include Healthcare Modules using Universal Installer and EXP /IMP utility respectively.
 Proficient in installing, upgrading, configuring, cloning, migrating oracle databases. Installed and configured the oracle databases on several platforms like Windows 2003, Windows 2008, Linux, UNIX.
 Installed and Configured report server 9i and database 10g for my current organization based on project requirements. 
Trouble shooting issues while having multiple versions of databases on one server. Creating public database links between two databases and migrating databases to higher versions using the export/import utility.
 Installing, configuring and Troubleshooting OS related issues specific to clients. Oracle related upgrades and maintenance of database and application tuning. Managing the physical and logical database structures. Control access to the database using Operating system network. Regular maintenance of user passwords.
Implement backup and recovery procedures using for Oracle databases and test regularly in conjunction with Operations.

Oracle DBA

I am a dynamic Solution Architect with 16+ years of experience in the IT industry, specializing in designing and delivering scalable, efficient solutions that solve complex business problems. My expertise spans cloud architecture, databases, performance optimization, and messaging systems. I am passionate about collaborating with cross-functional teams to ensure seamless project delivery and successful implementation.

Recently, I led two highly successful Proof of Concepts (POCs) on Generative AI, one for the public sector and another for a retail client. My work helped the retail client achieve a cost savings of €40K per month, showcasing the impact of AI-driven innovation on real-world business challenges.

🔹 Certifications:
TOGAF Certified
Certified Kubernetes Administrator (CKA)
Google Cloud Professional Architect (GCP)
Amazon Web Services (AWS)
Oracle Cloud Infrastructure (OCI)

🔹 Database Expertise:
Oracle (Standalone, RAC, Dataguard/Active Dataguard, GoldenGate)
SQL Server, Aerospike, Cassandra, AWS RDS, Cloud Spanner
Deep understanding of the CAP theorem

🔹 Messaging Systems:
Kafka
IBM MQ

🔹 Performance Optimization:
SQL Query Optimization, Indexing Strategies, Caching Mechanisms
Partitioning and Compression Techniques for scalability
Resource Tuning, Database Sharding, Monitoring, and Profiling

🔹 Additional Expertise:
Unix (All Flavors), JBoss EAP, WAF
CI/CD and DevOps with Jenkins and Google Cloud Build
GitHub for version control and collaboration
Infrastructure as Code (IAC) using Terraform
Shell scripting for automation and system administration

With a commitment to continuous learning and innovation, I enjoy leveraging cutting-edge technologies like Generative AI to create impactful solutions that drive measurable business success.

Taplio

Amit Bhatnagar's Linkedin Analytics

Amit Bhatnagar

🚀 Unlock the Analytics Magic!

Ready to grow your LinkedIn presence?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Amit Bhatnagar's Linkedin Analytics

Amit Bhatnagar

🚀 Unlock the Analytics Magic!

Ready to grow your LinkedIn presence?

Amit Bhatnagar's Linkedin Analytics