Gnanesh Chandra
Krakow
Summary
Cloud Database Administrator with over 11 years of experience managing and optimizing enterprise-level databases, including PostgreSQL and Oracle, in cloud environments. Proficient in AWS and GCP services, with hands-on expertise in Kubernetes and Docker for containerization and orchestration. Adept at ensuring database performance, availability, and security while driving infrastructure automation and cloud migrations. Skilled in collaborating with cross-functional teams to design, implement, and maintain scalable and resilient cloud-based solutions. Currently seeking to transition into a Cloud Engineering role, where a strong background in database management and cloud technologies can support innovative infrastructure development and automation.
Overview
12
12
years of professional experience
Work History
Principal Database Engineer
Pegasystems Worldwide Private Ltd
12.2016 - Current
- Enhanced database performance by optimizing stored procedures and indexes, significantly reducing query response times.
- Boosted data retrieval speeds with introduction of efficient querying techniques, supporting timely decision-making.
- Maintained up-to-date documentation on existing databases, enabling smooth transitions during personnel changes or system upgrades.
- Conducted regular audits to identify areas of improvement in database management practices, leading to increased efficiency.
- Optimized resource allocation, carefully planning hardware upgrades to meet increasing data storage demands.
- Streamlined data processes for faster retrieval and analysis through the design of well-structured databases.
- Streamlined report generation, automating routine tasks to free up time for more complex analysis.
- Resolved critical production issues by troubleshooting complex problems quickly and efficiently under tight deadlines.
- Enhanced user experience by devising intuitive interfaces for database interaction, enabling easier access to information.
- Adapted rapidly to changing requirements by designing flexible schemas that accommodated evolving business needs.
- Implemented proactive monitoring tools for early detection and resolution of potential database issues.
- Developed custom scripts to automate routine tasks, resulting in significant time savings for the team.
- Improved database performance by optimizing queries and implementing efficient indexing strategies.
- Contributed significantly to the organization''s productivity by maintaining high availability and reliability of critical database systems.
- Boosted team productivity by introducing collaborative tools for database development and maintenance tasks.
- Enhanced scalability of database systems to accommodate business growth, planning for future expansion needs.
- Collaborated with cross-functional teams to develop scalable, high-performance database solutions.
- Identified opportunities for cost savings through effective capacity planning and resource allocation decisions in large-scale database environments.
- Streamlined data migration processes, enabling seamless integration of new systems without data loss.
- Led successful migration projects from legacy systems to modern database platforms while minimizing downtime risks.
- Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
Senior system Engineer
ICICI Bank (3I Infotech )
08.2014 - 10.2016
- Installation of Oracle 11g,10g database binaries as well as Client binaries on different platforms like Windows, Solaris, and AIX
- Installation and configuration of Grid Infrastructure for Oracle RAC Cluster
- Conversion of single node RAC to Two Node RAC
- Installing and Configuring Grid for Standalone and Clusterware
- Manual creation of database and using DBCA
- Creation of Application users and non-application users and providing appropriate privileges and roles to the user as per LAM request
- Monitoring the Alert log files, Archive and Data Partitions and Tablespace Growth
- Addition of datafiles to the tablespaces if any tablespace is in critical state
- Monitoring the Top sessions and Top SQL queries in the Database through OEM 12c
- Performing Switchover and Switchback using Dataguard broker tool
- Performing Table RE-ORG activities
- Gathering Schema level and Table level Statistics on regular Intervals
- Applying PSU and one-off patches on RAC and Standalone Databases
- Upgrading the Database from 11g to 12c
- Configuring Dataguard broker for RAC and Standalone Databases
- Performing RMAN Restorations
- Changing Charecterset using CSSCAN and CSALTER.
Senior Infra Engineer
Mphasis
04.2013 - 08.2014
- Providing continuous support to database related activities like monitoring, administration and troubleshooting of multiple standalone databases of different versions on different platforms
- Installation of Oracle 10g & 11g database Software as well as Clients using GUI & silent mode in Windows, Aix and Solaris
- Installation of Grid for Standalone and RAC Environments
- OEM12c Administration and Maintenance
- Addition of datafiles to the production and standby database if any of the tablespaces in critical state
- Upgraded the database from 11.2.0.1 to 11.2.0.3
- Resolving Database connectivity issues & Resolve application to database connectivity issues by modifying TNSNAMES.ORA file as required
- Cloning of oracle home and database
- Implementation of active dataguard
- Transporting & Loading data between Oracle Databases using Import/Export & Datapump Utility
- Shell scripting for easier database Maintenance (Housekeeping): Clearing Listener log file, Alert log file, trace files, etc
- Managing database security
- Creating users and roles and assigning different roles to users
- Creation & Rebuilding of Indexes on tables as maintenance activities
- Performed the Table Re-org and Eliminating the Row chaining
- Performed the RAC Restorations
- Performed the Switchover and Switchback for RAC Critical databases
- Identify the locking on database objects and resolve them appropriately by identifying and killing the blocking sessions
- Analyzing DB level & Schema level statistics at regular intervals
- Refreshing UAT/development databases from production databases using export and import & data pump
- Data Guard configuration, switchover &Failover
- Perform SCN Incremental backups to sync the DR database with production DB.
Education
B. Tech Electrics And Communication Engineering -
JNTU University
Hyderabad07.2010
Skills
- Cloud: AWS, GCP
- Container and Orchestration tools: Docker, Kubernetes
- Databases: Postgresql, Oracle Administration
- Operating systems: Linux, CentOS, AWS Linux, Ubuntu, Windows
- SQL Programming
- Data Analysis
- Programming language: Python, Shell scripting
- Web Applications: Tomcat
Timeline
Principal Database Engineer
Pegasystems Worldwide Private Ltd
12.2016 - Current
Senior system Engineer
ICICI Bank (3I Infotech )
08.2014 - 10.2016
Senior Infra Engineer
Mphasis
04.2013 - 08.2014
B. Tech Electrics And Communication Engineering -
JNTU University
Similar Profiles
Neha RathiNeha Rathi
Senior Solutions Engineer at Pegasystems Worldwide India Private LimitedSenior Solutions Engineer at Pegasystems Worldwide India Private Limited
Anisha DasAnisha Das
Senior Site Reliability Engineer at Pegasystems Worldwide India Pvt LtdSenior Site Reliability Engineer at Pegasystems Worldwide India Pvt Ltd
Shariga ShyamShariga Shyam
AR - Supervisor- Billing Coordinator at Hogarth Worldwide Private Ltd & Finance plus WPP SSCAR - Supervisor- Billing Coordinator at Hogarth Worldwide Private Ltd & Finance plus WPP SSC