Lead/Senior Oracle Database Administrator
Innovative & Motivated User Experience Architect, Solutions Developer, and Support Leader
Diversified, solution-oriented IT manager with 16 years of relevant experience in architecting complex enterprise corporate systems and providing leadership in managing services, operations, and activities.
●Initiate strategic and tactical planning for enterprise technologies in alignment with business goals.
●16 years of extensive experience in relational database system analysis, design, and implementation in data centers as well as cloud (AWS, Oracle Cloud).
●Install, configure, and upgrade, performance tune and test relational databases per organization’s requirements.
●Identify total solutions for key business issues, evaluate and analyze root causes, and implement solutions in a structured and disciplined manner.
●Leverage virtualization and cloud technologies to serve the needs of the enterprise.
●Strong ability to grasp and debug issues while performing multiple tasks in fast-paced environments.
●Outstanding experience in customer-oriented support and interaction.
CORE COMPETENCIES & CERTIFICATIONS
Client Relationship Management
Cost Benefit Analysis
Department of Health, Washington DC, 2018-Present
●Oracle Cloud Services migration, Oracle backup to Oracle backup services
●Execute overall 12C database architecture strategy, database container and pluggable, standards and practices.
●Work closely with project teams to develop data models that support business processes.
●Work with Application Development team to ensure database changes adhere to best
●Practices and are properly prioritized and scheduled.
●Support all areas of the enterprise, ensuring all databases run at optimal performance.
●Proactively identify and troubleshoot database performance issues.
●Ensure that government and industry security standards are properly implemented.
●Work with development team to design and develop SQL code and reports based on
●Shell Scripting for database health, Storage and all database activityStorage report, database expiration report, Linux filesystem report from both OEM13C and shell and alert scanning for any customized Oracle errors.
●Scale up and down tests and devs database in the Oracle Cloud Services
●Support Oracle Cloud migration activities.
●Perform database backup and support disaster recovery operations.
●Perform data integrity and consistency checks on processed data.
●Daily Health Check Up of the Databases
●Understand written business requirements and translate them into database design.
TARIG HASHIM, PAGE 2
CENTERS FOR MEDICARE AND MEDICAID SERVICES (CMS), 2014-2018
Senior Oracle Database Administrator
Support HealthCare.gov, a highly visible and historic healthcare project, as a part of the Accenture team. Maintain and support a 24/7 operation of the Federally Facilitated Marketplace supporting HealthCare.gov. Responsibilities include:
●Participated in the AWS migration and road map from Oracle servers to AWS, Migrated Oracle databases from Linux to AWS RDS and EC2, part of the migration for large databases is to use snowball to S3 buckets to minimize production downtime.
●Worked on fixing Exadata performance issues, reviewed and advise on changes to optimizer parameters and Tuned SQL queries to take advantage of Exadata smart scans and cell offloading, storage indexes, ESFC, parallelism and partitioning
●Install and configure Oracle databases in Verizon, HPE, and AWS environments
●Upgrade or patch Oracle databases to meet security requirements
●Analyze vulnerability scan reports and resolve findings following DISA’s Security Technical Implementation Guides (STIG) requirements
●Performance tune Oracle databases to support millions of concurrent transactions during peak Open Enrollment periods
●Configure and manage Oracle Real Application Clusters (RAC) databases running in Oracle Exadata Database machine environments.
●Troubleshoot database performance for Alfresco application as well as in-house built java applications on Red Hat JBoss SOA-P/Fuse or Spring Batch Framework
MYTHICS, INC., Virginia Beach, VA, 2014-2014
Data Engineering Lead
Provided technical leadership of a team of 10+ engineers and analysts supporting the Department of State Bureau of Consular Affairs data needs for worldwide operations. Managed the stability and performance of over 800 servers worldwide, which support more than 4,000 customers and external agencies. Architected new databases, interfaces, access methods, system security, system availability, and business process analysis. Developed future database architecture.
Enterprise level database planning, analysis, design, development, and implementation.
Tools: CA Oracle & SQL
Projected long-range requirements for database administration.
Tools: CA Oracle & SQL
Planned and engineered database migration.
Tools: Oracle 11g, Linux, & MS SQL 2008
Researched, evaluated, and recommended new database technology.
Managed structured and unstructured data (Biometrics).
Lead integrated technical team with a number of key stakeholders (including federal employees, contractors, and subcontractors).
Evaluated work and prepared performance reports.
Evaluated and tested upgrades to current database structures and software.
Tools: Oracle 11g,12C
Consulted with and advised users on various databases.
Tools: Oracle 11g,12C
TARIG HASHIM, PAGE 3
VERIZON, Ashburn, VA, 1998-2014
Senior Database Administrator
Promoted efficiency, productivity, and profitability for a major data warehouse project that assembled data from 15 pilot cities and made it available for data analysis and market profiling. Managed a team of off-shore and mid- and junior-level database administrators. Provided management consultation and administered multiple complex databases in numerous applications. Coordinated application and database performance tuning for high throughput database and index reorganization. Lead the installation and upgrade of RDBMS, including creating new instances and table spaces, indexing, applying constraints of the snapshot tables, creating replication strategy for the source databases, creating and maintaining snapshot logs in remote databases, etc. Oversaw design enhancements and upgrades, backup, recovery strategy, patch requirements, and performance tuning.
Optimized performance of existing databases by reorganizing and restricting to meet Optimal Flexible Architecture (OFA) standards
Tools: Oracle RAC
Installed and configured Oracle Grid Control, which allowed central management and administration of all databases on various hosts.
Tools: Oracle Grid Control
Ensured database security by creating and assigning appropriate roles and privileges to users depending on user activity.
Identified resource-intensive SQL statements by illustrating time periods for database activity and high-load SQL statistics.
Tools: Automatic Workload Repository (AWR)
Diagnosed key issues and recommended solutions for problems such as expensive SQL statements, I/O performance issues, locking and concurrency issues, excessive parsing resource bottlenecks, etc.
Tools: Automatic Database Diagnostic Monitor (ADDM)
Installation and configuration of real application clusters (RAC) databases.
Tools: Oracle 11g RAC, Linux, Sun Solaris, & Windows
Managed the installation and configuration of databases for development, testing, and production environments.
Tools: Oracle 11gR2 & Linux Red Hat Platform
Utilized and maintained active Dataguard for standby databases disaster recovery, and HA using GoldenGate.
Tools: Dataguard, GoldenGate
Created and configured new databases using DCBA and applied quarterly patches to non-RAC and RAC configured databases.
Oversaw the performance of backup and recovery.
Tools: RMAN & Oracle Grid Control
Completed data migration
Tools: Export/Import, SQL-loader & Datapump
EDUCATION/ AFFILIATIONS/ TECHNICAL SKILLS
Bachelor of Science: Computer Engineering, King Abdul-Aziz University, Saudi Arabia
Coursework: Enterprise DBA Backup, Recovery, Performance and Tuning; SQL Tuning; & Data Modeling and Database Design
Member: Association of Information Technology Professionals & The Information Technology Society
Technical Skills: Database Management, Management Consultation, Data Warehouse Management, & Data Processing/Database Administration
Clearance: Office of Personnel Management Public Trust