add photo
Mohammed
mfali3@gmail.com
518-366-2715
Albany, NY 12288
Oracle Database Specialist
27 years experience W2
0
Recommendations
Average rating
167
Profile views
Summary

  • 25 Years of IT experience as Analyst Programmer/System Analyst using Oracle Application Developer (Forms and Reports) and Oracle databases 9i/10g/11g/12c, designing, coding, testing, debugging, performance tuning, database tuning, physical database models and experience with relational database concepts such as indexes, primary and foreign key constraint, Oracle Database Administration, ER-Win, Data warehousing, Business objects, Star Schema Methodology, Relational database design, Physical database design, Backup/recovery, Performance tuning, Security management, Space management, Sql, Pl/Sql, TOAD, Stored Procedures, Packages, Functions, Database Triggers, Pro*C, Korn Shell Scripting.
  • 12 years' experience in System Analysis, System Design using Entity relationship diagrams, Data Analysis, Data Dictionary, Data Flow Diagrams, and designing database objects, Data warehousing, Business objects, Star Schema Methodology, Analyzes, designs, tests, create, implements, maintains, and controls the enterprise's physical databases as they pertain to specific applications or business units, and/or provides the ongoing production support of existing systems of high complexity and scope, multi-platform, cross-functional, utilizing standard procedures and techniques. Implements disaster recovery strategies by designing the appropriate strategy based on application requirements and company standard, Implements High Availability & Scalability architectures on both at OS & DB level for mission critical database applications. Facilitates multi-platform application integration through Database replication and gateways and Implements the Security Standards for the database environment and aligns it with enterprise's security standards and Standardizes database security administration across applications using LDAP, Relational database design, Physical database design, integrating multiple database schemas, Performance tuning, Security management, Space management, Pro*COBOL and Korn Shell Scripting.
  • Proficient in Aggregate Functions, Analytic Functions, Oracle PL/SQL, dynamic SQL, FORALL, BULK COLLECT, RETURING BULKCOLLECT, SYS_REFCURSOR, SYS_CONTEXT and PL/SQL logging, Views, Snapshots, Synonyms, Stored Procedures, Functions, Database Triggers and Packages.
  • Extensive experience in Data Modeling for data marts, Strong Analytical skills, System Analysis, System Design using Entity relationship diagrams using data modeling tool (ErWin), Data Analysis, Data Dictionary, Data Flow Diagrams, and designing database objects, Data warehousing, Business objects, Snowflake Schema, Star Schema Methodology, Relational database design, Physical database design, Performance tuning, Security management, Space management, Pro*COBOL.
  • 5 Years of Experience in UNIX AWK, Korn Shell Programming, Korn Shell Scripts, UNIX Scripting and generating Scripts.
  • EXPERIENCE WITH PVCS VERSION CONTROL MANAGER, PVCS TRACKER AND ADMINISTRATION.

Experience
Education
computer applications MCA
not provided
Certifications
Certified Oracle Database Administrator
Skills
Oracle
2021
17
SQL
2021
8
Stored Procedure
2021
8
Triggers
2021
8
PL/SQL
2023
7
Data Conversion
2021
4
Data Modeling
2021
4
Database Backups
2021
4
Database Design
2021
4
DBA
2021
4
Performance Tuning
2021
4
SQL Developer
2021
4
Unit Testing
2021
4
Data Dictionary
2004
3
Web Forms
2004
2
Application Development
2002
1
Implementations
2001
1
Oracle DBMS
2001
1
Oracle Designer
2001
1
Oracle Reports
2001
1
Shell Scripts
2004
1
System Analysis
2002
1
TOAD
2002
1
Architecture
0
1
Commercial
2004
1
Construction
2004
1
Data Analysis
0
1
Data Marts
0
1
Data Replication
0
1
Data Warehousing
0
1
Disaster Recovery
0
1
Erwin Data Modler
0
1
Korn Shell
2004
1
LDAP
0
1