Janardhana Sunkara is a seasoned Database Engineer with over 10 years of experience across diverse domains, including Pharmacy, Retail, Manufacturing, and Entertainment. With extensive expertise in Oracle database administration and cutting-edge technologies, he has consistently delivered robust and scalable database solutions. Janardhana’s commitment to innovation, automation, and performance optimization sets him apart as a leader in the field.
Key Skills and Expertise
- Database Administration: Oracle (19c, 12c, 11g, 10g), RAC, ASM, Dataguard, Exadata (X9, X6)
- Cloud Technologies: AWS RDS, Terraform, AWS CLI, Liquibase, GitHub
- Programming and Scripting: SQL, PL/SQL, Shell Scripting, Python, Ansible, Terraform
- Performance Tuning: AWR, ASH, ADDM, SQL Tuning Advisor, Segment Advisor
- Replication and Migration: GoldenGate, AWS DMS, Data Pump, Log Miner
- Monitoring and Automation: DataDog, CloudWatch, Jenkins, GIT
- ETL and Reporting Tools: Informatica, SSRS
Current Role: Database Engineer at AXS Group LLC
At AXS Group LLC, Janardhana plays a pivotal role in managing the ticketing platform’s OLTP databases, supporting over 500 premier venues and clients globally. His responsibilities include:
- Managing Oracle Databases in AWS Cloud and provisioning new RDS Databases using Terraform and AWS CLI.
- Administering 250+ DMS Tasks to ensure seamless data replication from OLTP Databases to Kafka Cluster.
- Automating database release deployments using Liquibase and GitHub Tools.
- Integrating and customizing alerts for RDS Oracle Databases with DataDog and CloudWatch.
- Conducting performance tuning for SQL queries, enhancing execution plans, and optimizing database performance.
- Exploring Oracle 23c AI features and conducting POCs to integrate innovative solutions.
- Supporting global SQL deployments in Redshift and Postgres Databases.
Achievements and Innovations
- Successfully migrated a 30 TB Tier-1 Database from AIX to RHEL platforms.
- Implemented and maintained Oracle GoldenGate Unidirectional and Bi-Directional replication.
- Developed Python scripts to reduce onboarding time for new clients, enhancing operational efficiency.
- Automated routine DBA tasks using Ansible Playbooks, streamlining workflows and reducing manual errors.
- Led POCs for Oracle 23c AI features, showcasing innovative approaches to database management.
Closing Thoughts
Janardhana Sunkara is a testament to excellence in database engineering, combining deep technical expertise with a passion for innovation. His ability to manage complex database environments and drive automation ensures reliable and efficient systems. Whether optimizing performance, implementing cutting-edge solutions, or mentoring peers, Janardhana continues to set benchmarks in the field of database engineering.