Sql Server Information Systems
Resume:
Tamara Al-Drabkeh
ORLAND PARK, IL, 60462
********@*****.***
SQL Developer with 7+ years of hands-on experience in developing database applications, administering database and information systems. Possesses In-depth knowledge of database development, IT solutions, APEX,MS SQL Server, OCI, Oracle RAC, Data Guard, ASM, Postgre SQL, Python, software development, business analysis, systems administration, process re-engineering, and management information services.
Professional Experience
MINISTRY OF FINANCE, Amman, Jordan
Oracle Developer, June 2016–Present
Drive stability, reliability, and performance by optimizing in-application SQL statements and design user-focused databases, T-SQL programming, Microsoft SQL Server,APEX
Develop an ETL Database Model to carry out new procedures and create various database warehouse dimensions to accept ETL outputs
Gather requirements from business analysts, develop physical data models using Erwin, and create DDL scripts to design database schema and database objects
Perform database defragmentation and optimize SQL queries, improving database performance and loading speed by 70%
Lead the development of 12 database projects for one of the company’s largest clients with on-time delivery and 13% under budget completion
Microsoft SQL Server Reporting Services (SSRS) and Microsoft Power BI
ARAB ISLAMIC BANK, Amman, Jordan
Oracle Developer, August 2013–May 2016
Utilized Joins and sub-Queries to simplify complex queries involving multiple tables while optimizing procedures and triggers to be used in production
Performed SQL, PL/SQL, and application tuning using multiple tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, and AUTOTRACE,APEX
Designed 4+ onsite databases and maintained a group of 25 databases, reducing production costs by 15% and boosting productivity using data modeling techniques
Wrote SQL queries to obtain data from multiple tables to spool into CSV format and provide extracts to business and users
Education
ALHUSSEIN BIN TALAL UNIVERSITY, Ma’an, Jordan
Bachelor of Science in Computer Information Systems, June 2013
ORACLE CERTIFIED ASSOCIATE (OCA), Amman, Jordan
ORACLE CERTIFIED PROFESSIONAL (OCP), Amman, Jordan
Additional Skills
Oracle Development: MS Access, Database, SQL Stored Procedures, Table Scalar Functions, Ad-hoc T-SQL Queries, SQL SSIS packages, SQL Jobs, SSAS Cubes, Snowflake,APEX
Report Development: SQL Server Data Tools, SharePoint 2012 Website, Report Parameters & Datasets, Highly Visual and Graphic Dashboard & Table Report Styles
Contact this candidate