SUMMARY

• Motivated and driven IT professional, accomplished Oracle certified DBA, with strong financial, analytical and technical expertise in database installation, performance tuning, crisis management and high availability to increase reliability, productivity and relational database solutions for businesses
• 12+ years of IT experiences as an Oracle DBA on a variety of UNIX (AIX 7.1, Tru64 Unix, Linux), Windows server 2003 - 2016 platforms with Oracle 9i/10g/11g/12c
• Database installation and administration, manage user profile, performance tuning, capacity planning, maintaining database security standard, auditing and availability to meet business needs
• Backup, recovery, triggers, stored procedures, troubleshooting and perform root cause analysis
• Familiar with Oracle 12c new features, RAC, Materialized views, OEM, ASM, RMAN, Data Guard, and Golden Gate, OEM Cloud Control 13c and worked extensively in OLTP and OLAP platform
• Proficient in SQL, SQL*Plus, Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, STATSPACK, ADDM and AWR to analyze timing & execution plan for tuning.
• Experienced in data warehouse / data mart, developing and monitoring UNIX Korn and SQL scripts
• Experienced in data / object modeling, data normalization, ETL process, application performance optimization in data discovery, conversion, cleaning, mapping and migration
• Extensive experience in application development using PowerBuilder, PFC libraries, OOP, SOAP, WSDL web service, XML, DLLs, and Socket programming handling XML data packets
• Statistical analysis, modeling, data collection, cleaning, visualization, regression, data mining, decision tree, cluster analysis, random forest, forecasting and reporting using SAS, Python and R
• Working knowledge of Big data technologies, SDLC, QA, Agile and Scrum methodologies
• Familiar with Project management, AML, managing deadlines and applying ITIL key concepts
• Proven skills in System Analysis, Data modeling, Development and technical Documentation
• Highly motivated, excellent team player, ability to plan and multitask in a fast paced environment
• Prioritize tasks with time management to manage deadlines and a quick learner of new technologies
• Detail oriented, strong interpersonal, decision-making, problem solving and communication skills in dealing with directors, stakeholders and co-workers to prepare, present and explain data

TECHNICAL SKILLS

Databases: Oracle 9i,11g,12c, SQL Server, Informix IDS 7.3, MySQL, PostgreSQL

Oracle and other DB related Tools: SQL*Loader, SQL*Net, OEM, TOAD, Data Guard, ASM, Golden Gate 12c, RAC, SQL Developer, OEM, SSIS, ERWin, PowerDesigner

Operating Systems: AIX 7.1, PowerVM, HP Tru64 Unix 5.13, HP-UX and Windows Server 2003-2016, Oracle Virtual Box / Linux, Korn/Bourne/C Shell

Languages: SQL, PL/SQL, SAS, C/C++, PowerBuilder 9-12.5, COBOL,Visual Studio and ASP.Net, R, Java, Python (Numpy, Pandas, SciKit Learn)

Big Data Apps: Hadoop, MapReduce, HDFS, Hive, Pig, Spark, NoSQL, Hbase etc.

Reporting Tools: MS-Office (Excel Macro, VBA), MS-Visio, Tableau 10

PROFESSIONAL EXPERIENCE

Confidential

DBA / IT Admin

Responsibilities:

• Responsible for overall planning and execution of all IT functions and Database administration
• Purchased HP Alpha server systems, 2 node Unix cluster with SAN storage, installed and configured Oracle 9i and RAC, redesigned database structures and migrated older data from Informix IDS server
• Designed, developed and deployed entire Money Exchange applications using Power Builder 9-12.5, a bilingual (English & Arabic) application, designed to serve customers to send money worldwide
• Created and updated Korn Shell Scripts and Oracle SQL, PL/SQL Scripts to monitor database performance, alert logs, and related activities, resolved critical issues with Oracle MetaLink / SLA
• Purchased AIX based IBM Power730 Server, upgraded to Oracle 11g and consolidated 24 branches
• Performed backups using O/S, Hot backups with RMAN recovery catalog, data pump (EXPDP & IMPDP) and Creating & maintaining detailed configuration documentation, and maintenance plans
• Designed and maintained Oracle databases, views, stored procedures, triggers, queries, PL/SQL programming, database links, materialized views and documented data flow diagrams
• Data warehouse administration, migration, Recovery of databases at the times of critical failures
• Worked on Performance tuning with AWR, ADDM, SQL Tuning advisor, SQL Trace and TKProf.
• Experience with project management, budgeting, ITIL procedures, implemented AML regulations
• Attend scheduled and monthly meetings with top executives to understand business need and provide suggestions, cost benefit analysis, budgeting for system expansions and enhancements
• Provided database and network security, installed firewalls, user access control and permissions
• Implemented database failover strategy, on-site and off-site storage, maintained emergency systems
• Proactively monitored multiple production databases, troubleshoot issues, regular health-check
• Provided guidance to team members, reviewed pre-installation checklists and efficient connectivity
• Optimized business process to reduce downtime, cost and contributed to corporate profit by 40%

Environment: IBM Power730, AIX 7.1, Alpha ES45, Tru64 5.1B, Oracle 11g/9i, PowerBuilder 9-12.5

Confidential

Programmer Analyst

Responsibilities:

• Data analysis, discovery and determined entity relationship, populated mapping tables using Informix
• Wrote various summary and detail data conversion programs for GL, AP, AR, store transactions
• Worked on Y2K project, migrated data into Y2K compliant Informix server 7.3 from earlier version using export, import and load utilities