Uploaded File
add photo
MO
m_yasin84@yahoo.com
Leesburg, VA 20175
Oracle DBA
11 years experience W2
0
Recommendations
Average rating
33
Profile views
Summary

Oracle Certified Database administrator, with more than 16 Years of IT working Experience, Solid 14 Years' Experience in Oracle Database administration OLTP and OLAP, ETL/Data Warehouse And SQL Server 2008 - 2017, Strong experience on Oracle Real Application Cluster (RAC), ASM, Data Guard/Standby, 11G Snapshot Standby Database, Oracle Application Server 10g, Oracle Fusion Middleware 11g, Oracle Database Appliances (ODA), Oracle Data Integrator (ODI) SQL, PL/SQL functions, procedures, triggers and Packages, Oracle Flashback, Shell Scripting, Oracle 6i, 10g and 11g forms and reports Weblogic Configuration, Oracle Advanced Replication (OHTTP) Oracle web tier, LogMiner, OEM, Grid Control BI (Business Intelligence) Publisher, Oracle Access manager (OAM), Oracle Identity Management (OIM), Oracle Internet directory (OID) Import & Export, Data Pump, RMAN (backup and recovery), Sql*Loader, Database Performance tuning Applying patches, Partitioning and troubleshooting Excellent knowledge of Various operating systems and System Administration on Unix OS including AIX, Sun Solaris, 8, 9, 10, 11, Linux RHEL 3, 4, 5, 6, 7, 8 Windows server 2003,2008,2012,2016,2019, Xp on Oracle 9i, 10g, 11g, 12c, 18c, 19c. Very technical and best practice oriented, good communications skills, Able to work as a team Player, team leader or independent

Experience
Oracle DBA
Information Technology
Sep 2016 - present
Rockville, MD
  • Carry out all major service delivery and support areas including: Installation, Configuration, Migration, Upgrade, Patching, Cloning, Tuning, RMAN, MAA and Data Guard for Database and application servers primarily on Solaris and Linux Servers platform.
  • Support 40+ Terabyte Production RAC, Non-RAC Databases, ASM and applications plus Standby servers.
  • Installed, configured, Upgraded and managed Oracle 11G, 12C, 18C and 19C databases.
  • Applied Quarterly CPU (CRITICAL PATCH UPDATES) Patches on all the Databases.
  • Installed, Configured, Upgraded and Managed OEM 12C (12.1.0.5), OEM 13C (13.3.0.0) and Agents.
  • Troubleshoot Performance and apply solutions using SQL TRACE, TKPROF, EXPLAIN PLAN utilities.
  • Install, configure and Support Active, Non-Active and Snapshot Data Guard databases.
  • Created/updated Shell Scripts and Oracle SQL, PL/SQL Scripts to monitor databases and other related activities.
  • Enforced database Password complexity measures for higher level of security.
  • Create Wallets, Configure SSL for client authentication and manage VERITAS Clustering.
  • Working on AWS Amazon Cloud Create and manage Oracle and PostgreSQL DBs on RDS
  • Create and manage EC2 instances.
  • Perform backups and tested crash recoveries using Cold, Hot backups with RMAN and also tested various recovery procedures.
  • Creating tables, views, indexes, database links, views, materialized views, stored procedures, and other database objects as needed.
  • Installed Configured JDK, Weblogic, Forms and Reports (12c) on all the environments.
  • Creating and assigning database roles and privileges and Performing Oracle and SQL performance tuning tasks using AWR, ADDM and TOAD.
  • Provide mentorship to mid and junior level staff.
DBA Oracle FINRA Database Backups Performance Tuning PostgreSQL Shell Scripts SQL Stored Procedure Linux BEA WebLogic AWS EC2 AWS SSL Oracle 11i
Remove Skill
(Contractor at Westat)
Information Technology
Sep 2016 - Sep 2016
Rockville, MD
No skills were added
Remove Skill
(Contractor at U.S Census Bureau)
Information Technology
May 2015 - May 2015
Herndon, VA
No skills were added
Remove Skill
(Contractor at SBA)
Information Technology
Jan 2014 - Jan 2014
Herndon, VA
No skills were added
Remove Skill
Oracle Principal Consultant
Information Technology
Mar 2010 - May 2012
Reston, VA
Roles and Responsibilities:
  • Production DBA responsible for responding to problems on over 100 databases for over 7 clients with different environments in Oracle 9i, 10g and 11g {Standard & Enterprise Edition} plus the Data Guard databases.
  • Fulfill DBA daily activities including user management (*creating users, synonyms, privileges, roles, quotas, table, index, sequence
  • etc.), space management (table space, undo segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
  • Responsible for all levels of Support, troubleshooting, customer consultation and performance tuning in a 24 x 7 x 365 environment for Oracle 9i, 10g, and 11g on different platforms (UNIX, Linux and Windows)
  • worked with large clients such as:
  • Travelx USA
  • Travelx UK
  • Securenet
  • NaviNet
  • Webs
  • Europ assistance USA
  • OmniComm
  • Fedbid
  • EOriginal
  • Installed Linux Enterprise 4 & 5.
  • Excelling experience in Installing and configuring Oracle Real Application Cluster (RAC) cluster on Oracle 10g and 11g R2 with ASM and Raw Devices and 11g CRS providing high availability to the Oracle production environment.
  • Manage and Supported Oracle RAC (Real Application Cluster) on Oracle 9i, 10g and 11g.
  • Excelling experience in Installing and configuring Oracle Database Appliances (ODA).
  • Excelling experience in Installing and configuring OHTTP (Web tier).
  • Excelling experience in Installing and configuring Web Logic.
  • Excelling experience in Installing and Troubleshooting Oracle 6i, 10g and 11g Forms.
  • Excelling experience in Installing and configuring and Managed (OEM) Oracle Enterprise Manager Database and Grid Control 10g and 11g.
  • Configured UTL_SMTP to send Emails from the server.
  • Successfully completed 6 projects on Oracle RAC
  • Configure, implement, and support
  • Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
  • Monitor and Tune the databases through command line (pro active scripts) or OEM to insure satisfactory performance.
  • Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
  • Created database users, table spaces, tables, and indexes, constraints, Function, stored procedures, Packages and triggers, profile, roles and allocating default table space for users.
  • Resolve lock issues, space management issues, security, user management, privileges, roles and auditing.
  • Worked with archive and no archive log mode.
  • Implement disaster recovery sites using standby Oracle Data guard/Active Data Guard Modes Maximum (Performance/Availability/Protection) and configure it with DG broker.
  • Manage, support and maintain Oracle Data Guard 10g providing high availability and disaster recovery for Oracle production environment.
  • Upgrade and migrate Oracle databases from 10g to 11g R2.
  • Applied Oracle patches and troubleshooting.
  • Detect and correct any performance issues.
  • Successfully changed the Database Name.
  • Successfully converted the database character set from single byte to multi-byte (UTF8).
  • Reconfigured production SAN environment, created new logical volumes for Oracle files (control files, data files, flashback logs, redo and archive log files) based on the best suited RAID levels and RAW devices for ASM.
  • Configured and Performed backups and tested crash recoveries using Cold, Hot backups with RMAN and also tested various recovery procedures.
  • Setup RMAN Catalog for all the Oracle databases.
  • Using Export, Import and Data Pump.
  • Schedule and create scripts to refresh the DEV databases from Production.
  • Experience in writing Shell Scripts for automating backups and restoration.
  • Monitored and tuned SQL and PL/SQL code using Quest TOAD for maximum efficiency and performance reducing execution times.
  • Compile /Migrate Oracle Forms & Menus & Reports from 6i to 10g to 11g.
  • Rewrote sections of PL/SQL code to improve performance.
  • Responsible for disaster recovery planning.
  • Performed Switchover and Failover from production to standby and vice versa.
  • Monitored and followed up Tar's service requests raised with Oracle Support.
  • Write and Fine-tune UNIX scripts and setup Crontab jobs, schedule tasks, Oracle and UNIX alerts system to facilitate Weekly /Monthly/Daily updates/jobs.
  • Modified Oracle initialization parameters. Analyze Redo Log Files Using LogMiner.
  • Create SSH keys between the Database servers (production and standby).
  • Add LUNS to the ASM and monitor the database and do capacity planning.
  • Partitioned (Hash, Range, List) large tables to increase performance.
  • Ran a (Stats pack, EXPLAIN PLAN, AWR) reports to evaluate the performance activity.
  • Wrote Oracle scripts to update and modify policies in the databases.
  • Create SQL trace files and used the TKProf tool to analyze them in as needed basis.
  • Ran a (trace plan, ADDM, and OEM tuning advisor in order to make tuning recommendations for slow running queries.
  • Excelling experience in Installing SQL Server 2008/2012.
  • Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and Database Engine Tuning Advisor. Created new databases and objects like Tables, Procedures, Functions, Indexes and Views using T-SQL and SQL Server Management Studio in Development and Production environment for SQL Server 2008. Define and implement ETL development standards and procedures for Data Warehouse environment. Managed data warehouse projects improvement and growths.
  • Wrote Shell Scripts to monitor slow running queries table space and extent growth.
  • Configured network configuration using TNS, LISTENER, Net Configuration Assistant.
  • Customized Oracle 10g Grid to send email alert when thresholds are out of given range. Infocus Management Information System. Reston, VA Oracle Database administrator.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
High Institute of Information Systems and Computer Science 2006
Certifications
Oracle Certified Database administrator
Oracle Database Administrator Certified Associate (OCA)
Oracle Database Administrator Certified Professional (OCP)
Skills
AWS
2021
3
AWS EC2
2021
3
BEA WebLogic
2021
3
Database Backups
2021
3
DBA
2021
3
FINRA
2021
3
Linux
2021
3
Oracle
2021
3
Oracle 11i
2021
3
Performance Tuning
2021
3
PostgreSQL
2021
3
Shell Scripts
2021
3
SQL
2021
3
SSL
2021
3
Stored Procedure
2021
3
AIX
0
1
Audit
2012
1
Biostatistics
2016
1
C
2015
1
Capacity Planning
2014
1
Clustering
2020
1
DCL
2015
1
Disaster Recovery
2012
1
Documentation
2016
1
Email Campaign
2012
1
EMS
0
1
ERP
2012
1
JDK
2020
1
jQuery
2014
1
Microsoft SMS Server
2016
1
Middleware
2015
1
OLAP
0
1
OLTP
0
1
Oracle Application Server
2010
1
Oracle Forms
2012
1
Oracle J Developer
2010
1
Oracle RAC
2012
1
Quality Assurance
2016
1
RAID
2012
1
Scripting
0
1
Solaris
2014
1
System Administration
0
1
T-SQL
2015
1
TOAD
2020
1
Triggers
2014
1
Troubleshooting
2012
1
Ultra Sparc
2014
1
UNIX
2015
1
Veritas
2020
1
Warehouse
2015
1
Windows
2016
1