Shyamendra Bhadauria

Software Engineer

Noida, Uttar Pradesh, India5 yrs experience

Highly Stable

Key Highlights

Over 4 years of PL/SQL development experience.
Proven track record in SQL optimization and performance tuning.
Strong expertise in cloud database integration.

Stackforce AI infers this person is a Backend-focused Database Developer in the Fintech industry.

Contact

Skills

Core Skills

Database DevelopmentPerformance TuningSql OptimizationCloud PlatformsReportingDatabase Management

Other Skills

AWS Command Line Interface (CLI)AWS Elastic BeanstalkAWS Identity and Access Management (AWS IAM)AWS LambdaAWS SecurityAmazon DynamodbAmazon EC2Amazon Relational Database Service (RDS)Amazon S3Amazon VPCAmazon Web Services (AWS)AwsAzure Cosmos DBAzure Data FactoryAzure Data Lake

About

Experienced PL/SQL Developer with over 4+years of expertise in database development, performance tuning, and optimization. Proven track record in delivering efficient SQL solutions, working on complex database systems, and integrating with cloud environments. Strong background in Oracle, SQL Server, and Linux with hands-on experience in SSRS and REST APIs. Highly proficient in database management, scripting, and automation. A fast learner with excellent problem-solving skills, eager to contribute to innovative projects. Key Skills: Databases: Oracle PL/SQL, SQL Server, MySQL, PostgreSQL Development: SQL, PL/SQL, Database Design, Triggers, Stored Procedures Performance: Query Optimization, Performance Tuning, Indexing, Data Migration Tools & Technologies: Oracle SQL Developer, TOAD, SQL*Plus, SSRS, REST APIs Programming: Java, C++, Python (for scripting and automation) Cloud Platforms: Oracle Cloud, AWS RDS, Associate Cloud Engineer certified Operating Systems: Linux (RedHat, Ubuntu), Windows Version Control: Git, GitHub Other Skills: Problem-solving, teamwork, Agile Methodologies, Public Speaking

Experience

Priority

Engineer

Dec 2024 – Present · 1 yr 3 mos · Chandigarh, India · Hybrid

Working on scalable backend systems across SMB, B2B & Enterprise Payments. Focused on Oracle PL/SQL development, SQL optimization, data migration, and performance tuning #FinTech#Product

Oracle PL/SQLSQL optimizationdata migrationperformance tuningDatabase DevelopmentPerformance Tuning

Accenture

2 roles

Associate Software Engineer

Mar 2021 – Dec 2024 · 3 yrs 9 mos

Designed, developed, and maintained PL/SQL procedures, functions, and packages.
Optimized SQL queries and scripts, improving system performance by 20%.
Led the migration of database systems to Oracle Cloud, ensuring seamless data integration.
Collaborated with cross-functional teams for the development of REST APIs for database interactions.
Implemented database security and backup solutions using SQL Server and Oracle.
Worked on SSRS to generate customized reports for internal stakeholders.
Actively contributed to Agile sprints, ensuring timely delivery of database components.

PL/SQL proceduresSQL query optimizationREST APIsdatabase securitySSRSDatabase Development+1

Software Engineering Analyst

Mar 2021 – Dec 2024 · 3 yrs 9 mos

Application Design and Development: Writing SQL Stored Procedures, Functions, Triggers,
Cursors, Joins, Constraints, Sub-Queries, Error Handling, and complex DDL/DML/TCL queries to
meet business needs.
Optimizing existing SQL scripts for enhanced performance.
Creating and modifying existing Index, views, triggers, cursors etc. as per requirement.
Coordinating with the BA/Onshore team to understand and implement business logic.
Developing SQL scripts for data deployment from one server to another.
Preparing Functional and Technical Documentation.
Quality Assurance and Testing:
o Unit Testing & Debugging: Conducted thorough unit testing and debugging of PL/SQL code,
ensuring a 99% defect-free rate in production.
o Troubleshooting: Efficiently troubleshot and resolved production issues, significantly reducing
application downtime by 30%.
Developed and maintained database design documents and Data Dictionary
Performed in-depth data analysis of production issues
Troubleshooted and resolved database-related issues
Writing complex SQL queries for data retrieval and manipulation
Participated in data migration from source to destination databases
Prepared database object scripts (DML, DDL) for production deployment
Coordinated with production support for performance tuning and query optimization
Implemented and maintained database archival and data purging activities
Managed database table partitioning
Optimized SQL queries and scripts, improving system performance by 20%.
Supported the implementation of Oracle databases and provided post-deployment troubleshooting.
Worked on performance tuning, reducing query execution time by up to 30%.
Actively contributed to Agile sprints, ensuring timely delivery of database components.