Hire the Best Oracle PL/SQL Developers
in Romania

1) - - Troubleshoot complex database performance issues across enterprise environments - Analyze SQL query performance, execution plans, and optimizer behavior - Perform root cause analysis for critical production incidents (locks, deadlocks, hangs) - Work extensively with AWR, ASH, ADDM and other Tools for performance diagnostics - Investigate data inconsistencies and “wrong results” scenarios - Support multitenant architectures and high-load systems - Collaborate with global teams and business stakeholders to resolve critical issues - Provide technical solutions and action plans for performance optimization ➢ Performance assessments and tuning for query slow performance which used to run good. ➢ Diagnosing Query plan change and providing solution to fix the plan. ➢ Analyzing System State Dump, 10053 Optimizer Trace, 10046 Sql Trace, and Hang Analyze reports. ➢ Preparing KM documents related to any major Issues, doing root cause analysis in case of any failures. ➢Identify, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems. ➢ Performance tuning for complex databases and optimizing the application utilization for end users ➢ Troubleshooting Wrong Result Issues ➢ Database and Applications Performance Tuning ➢ Troubleshooting using AWR and ASH reports ➢ Troubleshooting Baseline issues ➢ Troubleshooting Sysaux Space issue ➢ Filling Quality Bug ➢ Processing the Patch request. ➢ Simulating test case in Oracle Development box. TECHNICAL SKILLS: - SQL (advanced: performance tuning, execution plans, data analysis) - Oracle Database (AWR, ASH, ADDM, optimizer) - PL/SQL, data processing, query optimization - Data analysis & troubleshooting - Python (basic) - Data Warehousing concepts - Multitenant architecture 2) Technologies: Oracle PL/SQL, Microsoft SQL Server 2012, PostgreSQL, SQL Server Reporting Services (SSRS) - Developed and maintained database solutions using Oracle PL/SQL and Microsoft SQL Server, including stored procedures, functions, triggers, and packages. - Designed, implemented, and optimized complex SQL queries and database objects to support business applications and reporting requirements. - Migrated business logic and database components between Oracle and SQL Server environments. - Analyzed business requirements and translated functional specifications into technical solutions. -Improved database performance through query optimization, SQL tuning, execution plan analysis, and profiling tools. - Developed and maintained reporting solutions using SQL Server Reporting Services (SSRS). - Supported data integration, migration, and reconciliation processes across multiple systems. - Collaborated with business analysts, developers, and stakeholders to deliver high-quality database solutions. - Participated in Agile (Scrum) development teams, contributing to sprint planning, daily stand-ups, reviews, and retrospectives. - Provided production support, troubleshooting, and performance monitoring for critical business applications. 3) Provide technical expertise in the areas of database administration on Oracle, SQL Server • Manage standard DBA tasks, managing space, monitoring performance, installing patches. • Provide client consulting and planning guidance as applicable for moderate to complex projects • Participate in and provides consulting to project teams on architectural, design development, integration opportunities, planning of complex systems.

With more than 15 years of experience in the Data Governance and Business Intelligence field I am confident that there is no sql or data related task or project I cannot deliver successfully. I have extensive working knowledge and expertise with a vast range of BI related technologies ranging from Power BI, Crystal Reports , Tableau, Cognos ( that I used to build dashboards and complex multi SQL procedure feeds and reports) to Transact SQL and SSIS ( I have used for data migration, data analysis and developing and scheduling ETL jobs ). I have working experience with most database environments ( MS-SQL,BigQuery, AWS, Oracle) and a good understanding of data governance methodologies. I would love to help you with your data related project and make sure you get the real insights into your data.

I'm a software engineer with 10 years experience in IT domain and I'm searching to start my freelancer career. As a beginner, I'm looking for copywriting projects for now and I will be glad to help you with my experience in Office Tools (Word, Excel or Power Point). I am able also to format your documents, make sure you will get high quality of work from me. Projects that I'm looking for are: - Images Data to Word - PDF to Word - Retype Scanned pages in Word Also, I'm working for almost 10 years with Unix or SQL programs and I am able to offer my skills on these domains for finishing with success your projects.