Rajagopal G
Charlotte,NC
Summary
Database engineering professional with experience in database design, optimization, and management. Skilled in SQL, NoSQL, and performance tuning. Strong focus on team collaboration and delivering results. Reliable, adaptable, and driven by achieving project goals and efficiency.
Overview
11
11
years of professional experience
Work History
Database Engineer
Ally Financial Inc
07.2022 - Current
- Company Overview: Customer has Finance & Bank applications like Invest, Bacnk, Advantage, Finance applications
- Responsible for design and implement the Database cloud solution AWS RDS, Oracle ExaCC
- Migrated oracle databases from on-premises to Oracle ExaCC using ZDM, export/Import, Dataguard
- Migrate the Databases from On-premise to cloud platforms AWS RDS PostgreSQL and Oracle ExaCC
- Design and implement the Database High Availability solution EDB PostgreSQL PGD cluster for Platform automation application like Red hat Ansible tower and quay applications
- Design, test and implement the Databases to store the end user data on EDB postgres
- Developing APIs to facilitate communication between applications and servers
- Responsible for design, test and implementing the application databases migration from oracle to Postgres/AWS rds postgres/EDB postgres
- Customer has Finance & Bank applications like Invest, Bacnk, Advantage, Finance applications
Database Engineer
Broadcom Inc.
11.2019 - 06.2022
- Company Overview: Customer has application TM and RA applications will allow customers maintain full control over authentication strategy, fraud systems and policies
- Will be responsible for deploying and maintaining Oracle, PostgresSQL database clusters that will enable and enhance software products and systems used every day by large platforms, applications, and groups of users
- Experience in handling Postgresql community and enterprise versions
- Having experience in configuration ETCD based Patroni to manage a Primary and standby PostgreSQL Cluster
- Identifying the slow running queries and fixing them
- Experience in analysing the queries and suggesting changes for query performance improvement
- Having knowledge on Oracle to Postgresql migrations using ora2pg utility
- Generating the badger report using pg_badger and analyse the report
- Review and analyse the db log files for performance issues
- Experience in SQL, PL/pgSQL, including stored procedures, functions, triggers, and views
- Knowledge of JSON and PostgreSQL support for JSON
- Configured and implemented Goldengate for database high availability solution and cross platform migrations
- Involved in Configuration and Implementation Oracle Real Application Cluster (RAC) for customer application databases
- Having experience in applying quarterly patching on core and RAC Oracle systems
- Involved in performing full and incremental database backups using RMAN
- Involved in performing restore and recover database using RMAN
- Involved in Postgresql Cluster configurations and implementing high availability solution for database applications
- Involved in analysing and fixing the Performance issues and troubleshooting Oracle wait events
- Generating and analysing AWR report for DB System performance
- Generation and analyse execution plan to optimise the query performance using EXPLAINPLAN
- Successfully designed and implemented an operational database schema design to improve query performance and information lifecycle management functionality of an existing deployed mission essential application
- Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction issues
- Involved in Stopping and starting the Goldengate services for SYSTEM maintenance activities
- Designed and developed the application custom jobs which will generate the weekly and monthly reports
- Involved in configuration and maintain the databases on Cloud platform like GCP and AWS
- Involved in handling the Mongo db on cloud platform
- Performed the Mongo DB backup and restore from prod to non-prod
- Customer has application TM and RA applications will allow customers maintain full control over authentication strategy, fraud systems and policies
- Environment: Oracle 11g, 12c and 18c, RMAN, EXPDP, IMPDP, Oracle Goldengate, Oracle Real Application Cluster, PostgresSQL10/11, Patroni Cluster on Linux machines On-premise and cloud (GCP)
Senior Database Administrator
Broadcom Inc
11.2019 - 06.2022
- Company Overview: Customer has multiple products to support its customer to provide the web security service, Data loss prevention CloudSOC, CASB, secure access cloud Encrypted traffic management and Web isolation
- The database engineering team supports Customer business systems and operations
- As part of Operations and Technology, I assist with defining database engineering practices, standards, and governance at Customer
- The primary focus will be to provide Database and engineering support for Customer's Commercial application
- Created environment consists of Linux servers with replica sets and shards in Dev, Test/Release, Stage, and Production
- Involved in Oracle Goldengate configuration and maintenance activities
- Performing Full and incremental backups using RMAN
- Performing restore and recovery using RMAN
- Performing schema logical backups using expdp and impdp
- Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases
- Develop SQL reports that meet client expectations for the application (used by custom application)
- Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
- Configuration and implementation PostgreSQL DR solution Streaming replication and host standby
- Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases
- Configure and maintain the MYSQL Database systems
- Design and implementation of High availability solution
- Monitoring databases to optimize database performance and diagnosing any issues
- Worked on Database migration activities as part of H/w or machine upgrades
- Developed the ansible scripts to automate routine tasks
- Worked on MS SQL database systems and experience in troubleshooting performance issues
- Experience in code migration, database change management through various stages of development life
- Customer has multiple products to support its customer to provide the web security service, Data loss prevention CloudSOC, CASB, secure access cloud Encrypted traffic management and Web isolation
- Environment: PostgreSQL9/10, Mongo, Cassandra, kubernaties, MYSQL, MS SQLserver, Linux and windows Machines
- On-premised and GCP
- Shell scripting and ansible
- Created and updated database designs and data models.
- Set up and controlled user access levels across databases to protect important data.
- Developed scripts and processes for data integration and maintenance.
- Modified databases to meet needs and goals determined during planning process.
- Reduced downtime during system upgrades by planning and executing seamless migration processes.
- Evaluated emerging technologies in the field of database administration, recommending strategic investments that resulted in improved efficiency and future-proofing capabilities within the organization.
- Developed comprehensive documentation of database systems, facilitating knowledge sharing among team members and improving training initiatives.
- Coordinated with application developers to optimize query performance, ensuring seamless integration between databases and applications used throughout the company.
- Collaborated on cross-functional teams to integrate various databases and optimize overall system performance.
- Optimized database performance by conducting regular maintenance and implementing best practices.
- Implemented robust backup strategies to safeguard essential data against potential loss or corruption incidents.
- Led several successful database consolidation projects, reducing infrastructure costs without compromising performance or security standards.
- Facilitated strong communication between IT departments and business stakeholders through clear reporting on key metrics related to database health and performance indicators.
- Performed root cause analysis on recurring issues, developing long-term solutions to prevent future occurrences.
Database Support Engineer
Kroger
11.2016 - 10.2019
- Company Overview: Customer has multiple applications Digital and MX which are using oracle Database as backend to store their On-line and analytical data
- Involved in upgrade/migration of databases from Oracle 12c to Oracle 12cR2 (13c), 18c and 19c
- Implemented Data Guard on this RAC environment (3-node) with another RAC (2-node) Standby Database
- Involved in Oracle Goldengate configuration and maintenance activities
- Having strong knowledge on Goldengate architecture
- Experience in installation and configuration of oracle GoldenGate 12c
- Experience in Implementation of Initial load, configuring change capture, change delivery and the change synchronization
- Stopping and starting the Goldengate services for SYSTEM maintenance activities
- Monitoring the oracle Goldengate and having knowledge on usage of LOGDUMP utility
- Experience in usage of GGSCI utility
- Familiar with troubleshooting performance issues using Automated Workload Repository (AWR) and Active Session History (ASH) for optimum performance of database
- Experience in planning, installing, configuring, and administering multiple Oracle RAC in Linux and Non RAC databases in Linux/UNIX
- Involved in construction of Disaster Recovery (DR) for all the production databases using Data Guard (Physical Standby)
- Tuned and balanced I/O by monitoring file system and table space I/O statistics
- Used partitions to improve the query performance and manageability
- Experience in Database Programming Oracle PL/SQL
- Involved in writing the shell scripts, created script to automate migration tasks of production database schema and user data from Oracle 12c to 18c
- Installed and configure extract, pump, replicate, manager parameter file of Goldengate
- Configured job schedule to automate routine administrative tasks in Crontab
- Created RMAN repository and configured RMAN full/incremental backups
- Having involved in Configuration of PostgreSQL Database
- Performed the backup and restore using pg_dump, pg_dumpall, pg_basebackup and pg_restore utilities
- Having involved in identifying the long running queries and fixing them
- Customer has multiple applications Digital and MX which are using oracle Database as backend to store their On-line and analytical data
- Environment: Oracle, RAC, DATAGUARD, OEM12c and 13c, Goldengate12c, AIX, SUSE Linux, Postgres 9
- Worked closely with software developers during application deployments to ensure smooth transitions without compromising existing data integrity.
- Reduced downtime during system maintenance by automating routine tasks with scripting languages.
- Maintained up-to-date documentation on database processes, policies, and guidelines for consistent adherence across the organization.
- Contributed to long-term capacity planning efforts by monitoring resource usage trends and anticipating future infrastructure needs.
- Handled escalated support cases requiring advanced expertise, resolving complex issues in a timely manner to minimize customer impact.
- Assisted in the successful migration of legacy databases to modern platforms with minimal disruptions to business operations.
Database Engineer
Uniper (E.ON)
06.2014 - 10.2016
- Company Overview: Enterprise Manager (EM) - Team has to Configure and manage the Databases
- Designed/Developed/Modified database objects like Tables, Indexes, Views, Materialized Views, Stored Procedures, Functions, Packages, and Triggers
- Worked on various tables to create indexes to improve query performance
- Also, worked on partitioning large Tables using Hash Partitioning, creating Index Organized Table (IOT), Cluster Tables
- Unix Shell Scripting and PL/SQL programming to resolve business problems of various natures
- Tuned database SQL statements and procedures by monitoring run times and system
- Installation and Configuration of Oracle 11g on HP UNIX and Suse Linux
- Managing data file objects including table space and data files, object sizing as well as monitoring database usage and growth
- Managing table spaces, user profiles, indexes
- Responsible for creating user logons and managing user accounts
- Monitor the instance and plan for future availability of storage on user’s table spaces
- Suggesting tuning solutions for SQL queries and Database
- Performance Monitoring the Server for Better performance
- Adding space to the data files according to tablespace growth
- Backup and Recovery strategies for Oracle database using expdp/impdp
- Taking an export backup of tables for future database recovery
- Modifying Oracle parameter (init.ora) for Oracle performance and growth
- Enterprise Manager (EM) - Team has to Configure and manage the Databases
- Environment: Endure application (EM), Oracle Server 11g, 12c and Microsoft SQL server 2016, SUSE Linux and AIX machines
Education
Master of Science - Computer Applications Development
Kakatiya University
Skills
- Database troubleshooting
- Database security management
- Backup and recovery strategies
- SQL query optimization
- Data migration techniques
- High availability solutions
- Cloud database management
- NoSQL database administration
- Disaster recovery planning
- Indexing and partitioning
Timeline
Database Engineer
Ally Financial Inc
07.2022 - Current
Senior Database Administrator
Broadcom Inc
11.2019 - 06.2022
Database Engineer
Broadcom Inc.
11.2019 - 06.2022
Database Support Engineer
Kroger
11.2016 - 10.2019
Database Engineer
Uniper (E.ON)
06.2014 - 10.2016
Master of Science - Computer Applications Development
Kakatiya University
Similar Profiles
Brian IngramBrian Ingram
Collections Operations Manager at Ally Financial IncCollections Operations Manager at Ally Financial Inc
Karl SaxeKarl Saxe
Lead Director, Digital Product at Ally Financial, Inc - Ally Credit Card (formerly Fair Square Financial, LLC)Lead Director, Digital Product at Ally Financial, Inc - Ally Credit Card (formerly Fair Square Financial, LLC)
Glenn BrunkerGlenn Brunker
Executive Director - Enterprise Transformation at Ally Financial Inc.Executive Director - Enterprise Transformation at Ally Financial Inc.
Samantha CottonSamantha Cotton
Manager at Mellow MushroomManager at Mellow Mushroom
Kevin DoughertyKevin Dougherty
Hospitality Manager, Guest Servies, Bayhost at TopGolfHospitality Manager, Guest Servies, Bayhost at TopGolf