Open to opportunities

Ajay Appam

@ajayappam

Message

Experienced Database Developer with expertise in Oracle , SQL and PLSQL.

United States

Message

What I'm looking for

I am looking for a role that challenges my skills in database development and offers opportunities for growth in a collaborative environment.

I am a Database Developer with around 7 years of experience specializing in Oracle SQL and PL/SQL. My journey in the tech industry has equipped me with a robust understanding of the Software Development Life Cycle (SDLC), allowing me to contribute effectively in various phases, from analysis to documentation. I have a proven track record in performance tuning and query optimization, consistently enhancing execution times and resource efficiency.

Throughout my career, I have worked extensively with Oracle databases, including versions 10g, 11g, 12c, and 19c, and have been recognized for my strong analytical and problem-solving skills. My experience includes developing complex PL/SQL stored procedures, functions, and triggers, as well as migrating data from flat files to Oracle databases. I thrive in collaborative environments, effectively communicating technical details to stakeholders and cross-functional teams.

Experience

Work history, roles, and key accomplishments

Current

Oracle PL SQL Developer

Current

S. BCBS

Dec 2024 - Present (6 months)

Responsible for data validation testing using SQL and executing testing on data Warehousing projects. Extracted, transformed, and loaded data from multiple sources into Elastic Search and Redshift, extensively working on performance tuning of programs and ETL procedures. Worked in an agile environment, testing iteratively against newly developed code, and utilized Cassandra for database and Redis

SQL ETL Performance Tuning Agile Cassandra Redis MySQL Chef PostgreSQL Redshift Shell Scripting TFS

Sr. SQL Developer

S.P Soft Pvt. Ltd

Jun 2020 - Dec 2022 (2 years 6 months)

Simplified HR processes by developing back-end logic for the HR System using Oracle SQL and PL/SQL. Designed and implemented a Call-Support System using PHP, MySQL, and JavaScript, and developed Shell Scripts for data loading and DDL Scripts. Performed data conversion using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL Server to Oracle, alongside performance tuni

Oracle Pl SQL PHP MySQL JavaScript Shell Scripting Data Conversion Performance Tuning HTML

Database Developer

HDFC Bank

Jun 2018 - May 2020 (1 year 11 months)

Coordinated with clients for requirement gathering, clarification, and providing solutions for various problems, ensuring consultative analysis and functional requirements were met. Involved in query optimization and performance tuning, and participated in analysis, coding, and code review of team members. Created Perl Scripts and Autosys jobs to automate monthly report generation, and developed P

SQL Pl SQL Query Optimization Performance Tuning Perl Autosys Explain Plan SQL Trace TKPROF TFS

Education

Degrees, certifications, and relevant coursework

JNTUH

Bachelor's, Unknown

Completed a Bachelor's degree at JNTUH in 2015, focusing on foundational studies relevant to a career in database development. This education provided a strong base for understanding core concepts.

Webster University

Master's, Unknown

Pursued a Master's degree at Webster University, completing the program in 2024. This advanced study enhanced specialized knowledge and skills pertinent to database development and related technologies.