Position: Oracle DBA, PL/SQL Developer, T-SQL Developer
Category: SQL
English level: pre
Years of experience: 8

1). Oracle Database SQL Certified Expert

2). Oracle Database 11g Administrator Certified Associate

3). Oracle PL/SQL Developer Certified Associate
Senior Oracle DBA, PL/SQL Developer

Involving in the full development cycle of planning, analysis, design, development, testing, and implementation. Designing logical and physical data models.
Created and modified PL/SQL and SQL Loader scripts for data conversions.
Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs. Wrote SQL, PL/SQL, SQL PLus programs required to retrieve data using cursors and exception handling. Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries. Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Used Explain Plan and Oracle monitoring, optimise hints to enhance performance of SQL statements. PL/SQL programming (Procedure, Function, Package... ). Performed the user requirements, troubleshooting activities and resolved connectivity issues. Implemented, administrated, and maintained daily backup and archived data on tape. Created user accounts, system-level and user-level database objects. Linux , Unix bash/shell scripting at the database administrator level. Oracle Grid (ASM , RAC) , Data Guard Physical Standby , Replicate database Golden Gate, install, manage, configuration, Zabbix DB monitoring and so .

T-SQL Developer

Create reports in a range of Microsoft, Oracle data analysis and reporting tools (Excel, T-SQL, and SSRS, SSIS, SSAS). Manage accounting systems, finance, data integrity using SSRS and SSIS and T24 (Temenos) systems. Interacted with the users for understanding and gathering business requirements.Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.
Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL. Used indexes to enhance the performance of individual queries and enhance the Stored Procedures. Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
Tuned SQL queries using execution plans and so.