Kourosh Ashkon
Sr Oracle Database Administrator @Confidential Careers
Signup · Get unlimited contacts
WORK HISTORY
Sr Oracle Database Administrator @Confidential Careers
Orange County, CA, US
Migrated pre-Oracle 19c databases to Oracle 19c. Applied Oracle critical patch updates.• Migrated on-prem databases to OCI and Exadata on RAC• Configured Data Safe in OCI databases.• Refreshed UAT environments from production. • Ensured availability, security, and integrity of assigned databases.• Resolved database performance, capacity, replication, and other distributed data issues.• Installed and configured database management software (DBMS) and applicable service packs and/or patches.• Developed and implemented database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization.• Established regular backups (RMAN, snapshot, etc.) of databases and archive logs.• Managed logins and user accounts, including assigning database object permissions and ancillary privileges.• Scheduled and managed jobs for data transfers and sundry procedures and monitors performance and impact on operations.• Analyzed long-term database performance trends to optimize database and application performance.• Developed PL/SQL code • Wrote Linux OS shell scripts.• Performed extensive performance tuning and analysis using AWR, ASH, workload, SQL Tuning Advisor, etc.• Sometimes worked non-standard shifts including nights and/or weekends including on-call responsibilities.• Interfaced with all levels of employees.• Worked both independently with little supervision and in a team environmentHardware/Platform: HP Prolient Operating Systems: Red Hat Enterprise Linux x86-46 8.6, 7.8, 6, and 5 version.Database: Oracle 19c EE OCI/RAC, Exadata, 12c, 11g Tools: Oracle 13c Cloud Control, Toad 14,2 Spotlight on Oracle, SQL*Plus, Cron, vi, PL/SQL (Stored Procedures, Functions, Packages, Triggers, Etc.)
EDUCATION
Boston University
BSCS, Computer Science
Oracle University
Master, Oracle DBA Master
SKILLS
ABOUT KOUROSH ASHKON
SKILLS• Oracle RAC 12c Engineering, Installation and Administration (Since 2015)• Oracle Golden Gate 12c active/active bi-directional Replication between a 2-node RAC cluster and a single remote node.• Oracle Archive log method replication from a production database to a remote server. • MySQL 8 one-way replication from a Source MySQL database to a Target MySQL database• Oracle Data Integrator (ODI)• Oracle Data Warehouse Builder (OWB)• Oracle DBA (8, 8i, 9i, 10g, 10g AS, 11g, 12c, 12c RAC, and 19c): Since MySQL Database Administration• ETL: 10+ years on the job using Shell, SQL-Loader, Oracle Data Warehouse builder, ODI, etc.• ERWIN data modeling tool: More than nine years• Oracle SQL, DDL, DML: 15 years• PL/SQL (Stored Procedures, Functions, Packages, Etc.):15 years• Oracle 10g Portal and Discoverer: 4 years• Pro*C/ESQL (Embedded SQL): Several years• C programming: 20 years of C programming• Share-Plex: 2 ½ years• RMAN backup and restore: 15 years• Oracle Forms & Reports 4.5 and 10g: 2 years• UNIX: 25 years of UNIX including Solaris, HP-UX, AIX, and Linux• UNIX/Linux Shell Scripting: 25 years of UNIX/Linux Shell programming• Windows Server 2003, Windows XP, NT, and Vista: Over 17 years• SQL: More than 19 years on variety of databases including Oracle, SQL Server, All-Base, and DB-Vista• Relational Database Analysis and Design• Physical and Logical Database Design• Database Design for Readiness Decision Support System (RDSS)• Oracle Database Administration• MySQL Database Administration• Database Duplication/Cloning and Standby (Data Guard)• Database Replication including Golden Gate• Reporting Systems• Database upgrade from Oracle 12c to Oracle 19c• Database Migration from Oracle to MySQL 8.0• Database Migration from MySQL 8 to Oracle.• Data Warehousing (OWB, ODI)• PL/SQL, Packages, Stored Procedures, Functions, and Triggers• Business Intelligence• Disaster Recovery Planning and Management• Oracle Application Server (OAS), SSO, OID, OVD, LDAP, ASO, Kerberos, Database authentication, Roles, and Privileges• Oracle Real Application Clusters (RAC) 9i and10g• Automatic Storage Management (ASM)• RMAN Recovery Manager• UNIX/Linux Systems Administration (Kernel-configuration, package installations, etc)
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.