Data Manager
Resume:
QALI ADEN
Oracle Database Administrator
PROFILE
Accomplished and seasoned professional Oracle Database Administrator with 9 years IT experience in Data Engineer and Database Administration, Modeler, Analysis, Design, Development, Testing and Implementation of various database, data warehouse, software applications and developing and managing automate scripts. Worked on exceptionally large production databases, performing various DBA roles, across a multitude of platforms (LINUX, Solaris, and UNIX) in production, development, and test environments.
CONTACT
PHONE:
EMAIL:
**********@*****.***
HOBBIES
Reading
Swimming
Volleyball
Movies
OBJECTIVE
Enthusiastic DBA, eager to contribute to a team’s success through hard-work, attention to detail, and excellent organizational skills. Proven leader with motivational management style, a solid reputation for building and retaining initiative-taking teams and development of innovative solutions. Resolute collaborator who listens, thrives on collaborating with diversely talented team members, & integrates their divergent thoughts opinions and perspectives into meaningful actions.
Technical Skills:
Database Performance
Database Design
Database Security & Transparent Database Encryption
Client Relations Management
Backup & Recovery using RMAN
Export/Import using Data Pump
Unix & Linux OS
Data Guard
Oracle Database Performance Tuning
AWR Report Analysis
ADDM
Oracle OEM
Database Refresh
SQL Tuning
DDL, DML, Select Statements
Microsoft – Word, Excel PowerPoint, & Outlook
Professional Experience:
US State Department Falls Church, VA May 2018 – Present
Sr. Database Administrator
(Contractor)
Responsibilities:
Maintained database availability at 100% by monitoring 12c Oracle Enterprise Manager for alerts and resolving them by priority
Increased annual profits by 15% (1.5M) through teamwork and collaboration, by meeting SLAs, improving database performance, and providing efficient resolutions to assigned tasks
Administered, supported, and monitored databases by proactively resolving database issues
Performed SQL Tuning and provided consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, and using hints wherever possible
Prevented data loss through automated backups, capacity planning, and troubleshooting issues resulting in improved data security and database functionality
Implemented backup and recovery procedures using RMAN and Data Pump utility for Oracle databases and test regularly in conjunction with Operations
Administered and supported the development of Oracle databases by installing and configuring the Oracle Server
Worked, closely with other team members in such tasks as troubleshooting and debugging
Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization
Experience with development and execution of database security policies and hardening (DISA STIGS)
MITRE Corporation, Tyson’s VA May 2015 – May 2017
SQL Database Administrator (DBA)
Responsibilities:
Provided database administration, configuration and maintenance for the databases including OLTP/OLAP (Data Warehouse) of PROD, DEV
Provided support in database design/architect, data analysis, data modeling (logical & physical)
Provided support for Oracle Database (database object management, User/Access
Developed, evaluated, optimized, implemented, and supported queries: SQL, PL/SQL
Providing Performance & Query Optimization and troubleshooting for databases: Oracle & SQL server
assisting with lifecycle management and marketing business intelligence.
Created automated script to connect to all databases from a central server using ssh connections hence reducing human effort 75%
Migrated data during data centre migration using data pump process
Performed numerous performance tuning activity improvising long running jobs using AWR report and oracle enterprise management
Improved efficiency of numerous queries using SQL, gathering stats, table partitioning hence reducing query running time from 5hr to 30 min (avg.)
Rolls Royce Holdings – Herndon VA Oct 2014 - May 2015
Oracle Database Administrator
Responsibilities:
Performed data migration to higher versions to endure data security
Reduced SLA breaches by ensuring timely completion of assigned tasks
Experienced in RMAN concepts, backup and recovery policies and user management
Maintained database availability and performance at 100% by implementing timely fixes and continuous monitoring
Identified the root cause of Oracle errors and provided solutions to resolve them. Implemented initiative-taking database monitoring using Tuning Pack, Diagnostics Pack, SQL Trace, Explain Plan
Monitored bugs from the alert log and trace files and used DDL statements to CREATE and ALTER within a dynamic SQL script, created schemas, synonyms, and roles. Used the Select statement extensively for reporting
Provided support in Analyzing, designing, developing, data modeling and database design, data profiling
Provided support in Working with development team to perform database tasks related to application enhancements such as creating new tables and/or columns
Database performance tuning through database configuration
Planning, defining, and implementing backup, recovery and restores
Reviewing database and server level violations and fixing the violations as per company standards.
Bank of America, Falls Church, VA May 2013 – Oct 2014
Oracle Database Administrator
Responsibilities:
Guided teams in the development of relational database management systems (RDBMS) for the client, which improved consistency, recoverability, and accessibility of data
Upgraded the platform from SQL DB & Windows OS, to Oracle DB & Aix OS in 3 months
Planned and executed database backup and recovery daily to achieve a 0% data loss strategy in 3 months
Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime
Provided support in Installation, configuration, troubleshoot Oracle Application/Web services and databases such as Oracle DB 11gR2 and 12c, SQL Server
Interviewed internal clients and collected user requirements for business analysis and application development
Troubleshoots oracle databases issues and optimization issues using Explain Plans, AWR, ADDM, OEM 12C and other performance metrics and analysis and providing solutions.
Working with Network/UNIX team for any network / server level needs and issues
Reviewing database and server level violations and fixing the violations as per company standards.
Wells Fargo, Vienna, VA Aug 2011 – May 2013
Oracle Database Administrator
Responsibilities:
Provided performance tuning/SQL tuning support for PROD and NON-PROD environment
Generated performance metrics such as EXPLAIN PLAN, AWR, ADDM. Real-time performance monitoring using SQL*Monitor and GRID CONTROL (OEM)
Database performance and SQL tuning includes table analysis, index analysis for schema tuning. Performed stats gather (Histograms), extended stats on column level. Used SQL Tuning Advisor, SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Set, and other advisors to generate tuning recommendations, reviewing, analyzing, and providing solutions.
Worked with Production DBA to co-ordinate the production deploys.
Administered and supported development of Oracle databases by installing and configuring the Oracle Server Performed health
Created and managed database objects such as user/passwords, schemas, tablespaces, tables, indexes, views, columns, synonyms, sequences, database links, & constraints
Data move/migration from source to target server’s native tools such as data-pump, SQL*Loader, External Tables.
EDUCATION
University of Phoenix
Associates of Science in Information Technology (Present – Bachelor’s)
Associates of Science in Health Administration
(3.9 GPA)
Contact this candidate