Oracle Database Admin and IT Solutions Architect(Team Lead)
Saudi Telecom Company - STC (VIVA)
مجموع سنوات الخبرة :22 years, 2 أشهر
Senior Database Administrator (2009 onwards), Huawei Technologies, Kuwait
Client: STC Telecommunication Company
Key Responsibilities:
Team Lead of database administrators / Fusion middleware administrators.
Covering up below old and emerging technologies as per organizational requirements.
Super cluster M7, Exadata X6 and X4, Solaris T5-4, T4-4, M series, Redhat Linux and Oracle Linux.
Databases 10g/11g/12c with RAC architecture
Fusion middleware11g/12c, Oracle WebLogic server, Oracle SOA suite, Oracle identity management, Oracle portal, forms, reports and discoverer, Oracle BI, Oracle JVM and HTTP servers.
Application servers of Managed Services department in STC (Kuwait) . Critical databases are TABS, Mediation, Provisioning, Calls History, Interconnect, Selfcare, E-payment, Nokia provisioning, SOA and digital.
Installed database 12C on Super cluster M7, ZFS storage and Upgraded 11gR2 grid infrastructure.
Applied patches on Oracle 12C/11g/10g Cluster ware and RAC databases.
Extensive experience with rolling patches on 12C/11g/10g grid/RAC.
Applied numerous PSU, CPU, Patch set and one off patches to RAC, ASM and databases.
Installed, setup and configured Oracle Enterprise Manager Cloud Control 12C/13C as a tool of administration, performance tuning, monitoring and alerts.
Added and deleted RAC nodes using Oracle OEM Provisioning Pack.
Resolve performance tuning related issues, reports, and queries.
Configured, tested and supported Oracle data guard RAC standby for RAC primary and standalone standby for RAC primary.
Migrated OS file system storage to ASM with minimal downtime and administered ASM disk groups and instance.
Server side and Client-side fault tolerance achieved by configuring SERVICES and TAF (Transparent Application Failover).
Proactively monitored and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success of production servers.
SQL Tuning, End-user tuning and troubleshooting using various tools like EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, v$ performance views.
Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
Experience in architecture, design, development, and production support for legacy applications leveraging the Oracle Fusion Middleware 11g technology stack.
Possess a strong working knowledge of SOA 12c and web services technologies and infrastructure engineering of Service Oriented Middleware deployments that support complex and essential web services across the enterprise, including shared and dedicated, production and non-production environments.
Having hands-on design, build, deployment, and support for Oracle Fusion Middleware including SOA, OSB, BPM, ODI, ADF applications, including the WebLogic application server.
Experience in installation, implementation, maintenance, and operations of middleware and related infrastructure components.
Oracle SOA suite and BI upgraded and integrated.
Oracle internet directory (OID) upgraded, configured and integrated.
Oracle Applications Backup & Recovery Best Practices
Oracle Applications Performance Best Practices
Oracle Applications Security Best Practices
Oracle Applications Concurrent Managers Best Practices
Oracle Applications Purging Strategy Best Practices
Integrate Oracle Applications with Custom Application
Create and Follow up Service Requests with Oracle Support for Technical Support
Working with the Development Team to fix the problems in Applications
Monitoring Health Check of servers by background process and by using OEM
Maintaining Application Security and Database Security
Managing Users, Responsibilities and Profile options
Backup and Recovery Processes (RMAN)
Major activities include advanced performance tuning, database design, capacity planning and establishing standards for Oracle installations, maintenance, tuning, and coding standards.
▪ Performed analysis of current optimization model and provided recommendations to move to Oracle’s cost-based optimization. Lead the stress test initiative to evaluate the success of this approach.
▪ Established and wrote the Performance Tuning guidelines for the Engineering Department to enhance the quality of our product for all current and future code development. This document includes hints for SQL and JDBC performance tuning, application tuning methodologies, determining instance and I/O efficiency, and using tools like STATSPACK, Precise/In depth and TKPROF.
▪ Worked for a Large Scaled Database projects (Roaming, Credit control, Rating, Billing and Provisioning etc), and providing assistance in the Daily, weekly and monthly databases health checks, as well as performing the various day- to-day maintenance routines like Report optimizations. Index rebuilds. Creating Range/Hash/Composite/List Partitioned Tables.
▪ Managing partitions of partitioned tables (Adding/splitting/dropping). Creating and managing Materialized views and Mview logs. Space Management for Large Production Database (3 TB and 11 TB). Working with Raw files. Configuring backups using RMAN.Writing/Editing Sql loader control files for data loads.
▪ Installation of Oracle software on Sun Solaris (SPARC) 5.10 and NT platforms. Created multiple database instances on Sun and Windows Operating Systems. Entirely responsible for maintaining the Production, Test and Development databases of the company.
▪ Managingfilesofdatabases.
Senior Databases Machine Admin (2007 -2009), Digital Processing Systems, Kuwait Client: ZAIN Telecommunication Company
▪ Creation of tablespaces and add data files.
▪ Settingstorageparametersfortablespaces.
▪ Managingschemaobjects.
▪ Estimatingstorageparametersfortables, indexes.
▪ Gathering table growth statistics and preparing scripts for reorganizing them.
▪ Managing rollback segments.
▪ Creation and setting storage parameters of rollback segments.
▪ Altering rollback segments and assigning large batch transactions explicitly to bigger rollback segments. Monitoring
rollback segment growth.
▪ Managing users by assigning them privileges through roles, and quotas.
▪ Creating profiles for resource management.
▪ Configuring datafiles and monitoring their growth.
▪ Reorganizing Datafiles and Tables.
▪ Performing daily HOT backups and export backups through shell scripts run by cron jobs.
▪ Securing database access through Privilege, Role and Resource Management.
▪ Assigning System and Object Privileges to users and roles.
▪ Creating and assigning roles.
▪ Managing system resources through profiles.
▪ Tuning the INIT.ORA parameters from time to time for performance enhancement and other necessary operations.
▪ Monitoring the performance of the database and tuning the database when required.
▪ Tuning SQL statements.
▪ Tuning Memory.
▪ Monitoring locks and latches on system resources.
▪ Experienced in Partitioning large tables across physical disks to increase throughput for heavy transactional
applications.
▪ Extensively using V$ views for performance monitoring.
Responsible for the design, configuration and installation of all major production, development and test Oracle database environments on Sun Solaris platforms and windows. Major activities include logical and physical database design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance with a special emphasis on web based server administration automation. Other activities include evaluating and selecting Oracle database tools responsible for database and application tuning, capacity planning and database stability.
▪ Developing reports and screens in OLTP environment for management decisions (Zain Iraq Telecommunication Company).
Key Responsivities:
▪ Worked in Ministry of Health (MOH) as Databases Machine Admin for primary care health and health insurance servers. Administering high transactional production databases in Tru64 UNIX environment. Gained expertise in performance tuning, defining backup/recovery strategies.
▪ Creating Databases, Managing Datafiles, Redo log files, Backups (Hot & Cold Backup), Import Export, Tablespaces, Index creation and Index management, Size sharing tool, Buffer cache, Tuning Rollback segments, Network connectivity, SQL Loader, User management, Privileges management
▪ Excellentexperienceofapplicationtuning, oraclenetservicesclientsideconfigurationandconfigurationoftheoracle shared server.
/