Database Administrator

FASIKA WUBET TEKA

Phone: +1-412-***-****

Email: *********@*****.***

SUMMARY

Database Administrator over 7 years with extensive knowledge and proficiency in Oracle and MS SQL Server database technologies. Installs and configures modern databases software for Linux, Unix, Windows, and Oracle infrastructure. Excellent hands on experience in Oracle 10g, 11g, 12c, 13c OEM, 18c, 19c as well as MS SQL Server 2008, 2012, 2014, 2016 Database Versions; executes day-to-day database administrative tasks such as cross-platform data migrations between Oracle, AWS Cloud, MS SQL Server. Expertise on High Availability, Disaster Recovery solutions such as Goldengate, Dataguard, RAC, Alwayson Availiablity, Clustering, Upgrades databases and software to new release levels, manages capacity planning and database’s storage structures, users and security infrastructure, audits and compliance reporting, backups, and recovery. Generates and monitors Schema objects, such as tables, indexes, and views, ensures database’s health, accuracy, and optimal performance by implementing preventing actions and tuning databases parameters.

PROFESSIONAL SUMMARY

Manage production, development, and QA Databases including Installation, Configuration, design, trouble shooting, performance and backup & recovery, Upgrade & Patching, Migration, in heterogeneous environment including Solaris, UNIX, and Windows.

Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.

Implementation of high availability solutions with Oracle 11g, Physical and Logical Standby database (DataGuard), Materialized views, Golden Gate, RAC.

Implemented Oracle Enterprise Manager Grid Control (11g) and Cloud Control (12c) For database monitoring/performance/diagnostics.

Experience in Oracle Golden Gate installation, configuration, and troubleshooting Golden Gate issues.

Applied various database / applications PSU / CPU patches as required.

Drive end to end availability, performance monitoring, and capacity planning using different tools

Experienced in performance tuning databases with respect to all aspects of IT infrastructure such as Network, OS, Storage, and Application.

Exposure to cross platform migrations from oracle databases to PostgreSQL database in AWS cloud.

Proficient in SQL, PL/SQL, Stores procedures, functions, cursors, and triggers.

Experienced in working with database security tools TDE, Data Masking/Data Redaction.

worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, SQL, Trace, AWR, ADDM, OEM and Tuning of SGA.

Designed and implemented different backup strategies like Incremental/Full, Cold, Hot using RMAN with flash recovery area and Logical Backups EXPDP/IMPDP.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11g, & 12C environment for the Production databases.

Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

Team player with excellent interpersonal, analytical and communications skills

Worked with development and operations staff in resolving problems quickly and efficiently

functionality to create script to automate routine tasks being done in Service Now

EXPERIENCE

DATABASE ADMINISTRATOR FEB 2017 TO CURRENT

US STEEL – PITTSBURGH, PA

Administration of RDBMS databases throughout the development and production lifecycles.

24 X 7 Production & Development database support and administration.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g environments.

Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re- organizing Databases/Schemas/Tables to improve the performance.

SQL tuning, triggers, stored procedures, third-party tools, and transaction monitoring

Extensive Experience with Change Board Meetings and Change Control Management for all database changes.

Implemented DB Vault to enhance security and audit access to wallet contents.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Implemented oracle 12c active standby database for test database environment.

Involved in L4 Support to resolve all the Performance Issues which cannot be resolved by L1, L2&L3.

Worked extensively on several performance issues that act as a bottleneck for Application Teams.

Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning and SQL query tuning using tools like Explain Plan, SQL Trace, TKPROF and Statspack.

Proactive performance monitoring, and capacity planning for future database and server growth using OEM.

Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.

Monitor Database Performance, CPU Utilization and Memory Resource Utilization.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Utilized RMAN recover table functionality and created proof of concepts for our pre- prod environment.

Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

Implemented initial data load, batch/online replication, security in Goldengate.

Performing ongoing database maintenance, patching, and upgrading for 11g and 12c databases.

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.

Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.

Performed installation, configuration, and maintenance of oracle 11g/12c, 11g RAC databases.

Configured oracle 10g, 11g Real application cluster (RAC) (2 nodes) using cluster ware and automatic storage management (ASM).

Monitor, troubleshoot and configure the SQL and Oracle databases and infrastructure work with Oracle 12c environment, oracle 12c features PL/SQL.

Implemented oracle standby database server deployments, architecture, configuration, implementation, operations, and management.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.

Created, Managed, Monitored and Troubleshoot Databases using MS SQL Server Management Studio (SSMS).

Performed MS SQL Server Performance Tuning, Query Optimization, Client/Server. Extensive use of DMV's, Profilers, Database Tuning Advisors to improve performance.

Performed maintenance task like Reorganize/Rebuild index, Update statistics on the indexes, Backup database and transaction log using SSMS.

Knowledge of High Availability and Disaster Recovery options available for SQL Server.

Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth, and file system space, in adherence to the Optimal Flex Architecture.

Attend bi-weekly/monthly meeting to understand business needs and provide suggestions for enhancement.

Solid discipline in providing end-users timely updates on their problems.

DATABASE ADMINISTRATOR March 2014 to January 2017

CENTURYLINK INC – MONROE, LA

Installing Oracle Golden gate and setup table level replication as well as DDL replication too.

Experience in Multitenant Databases (Oracle 12c Container and pluggable databases).

Worked New Features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c Databases.

Implemented fast start failover on databases and configuring disaster recovery site using Data guard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database.

Data transferring using Export/Import utilities and SQL*Loader.

Assess and evaluate existing Oracle environments for documenting and recommending Life Cycle Replacement options.

Expertise in Active Data Guard, Snapshot using Data guard Broker (DGMGRL) and RMAN.

Performance Tuning of Oracle database using OEM, SQL analyzer, Stats pack, AWR, ADDM, ASH, RDA, Explain plan, TKPROF, SQL TRACE.

Applied PSU patches on Oracle Container and Pluggable Database Cluster environments.

Provided technical domain expertise and leadership required to effectively deliver high quality, timely solutions and services that meet business needs with a focus on the line of business.

Participated in cross platform migrations such as Oracle to PostgreSQL.

Documented and assisted in Data migration from Oracle Databases to PostgreSQL database on premises and in AWS Cloud.

Performing basic tasks such as objects such as, creating roles, granting privileges, creating tables.

Implementing the use of indexes, and primary & foreign key constraints as required

Providing PRODUCTION SUPPORT based on a ticketing system.

Assisted in defining and implementing MAINTAINANCE PLAN for the database systems.

Using Customized scripts, to monitor database growth, TABLE growth, automated backups using Cronjobs.

Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.

Implement Oracle standby database server deployments, architecture, configuration, implementation, operations, and management.

Creation of technical documents, transportable tablespace, and user managed backup and concept of database system and security.

Database backup using crontab and shell scripting, restore and recovery using RMAN, RTO/RPO and optimization.

Create and configure Oracle advance security and policies using Oracle Cloud Control Enterprise Manager.

Experience in creating users, tables, views, stored procedures functions in SQL database.

Data guard and Broker configuration for physical and standby databases.

EDUCATION

Addis Ababa Science and Technology University Bachelor of Science

CERTIFICATION

CompTIA Security+

SQL Fundamentals

Oracle Certified Associate 12c (OCA)

Oracle Cloud Infrastructure 2019 Architect Associate (OCI)

Oracle Autonomous Database Cloud 2019 Specialist

AZURE CLOUD

TECHNICAL SUMMARY

Databases: PostgreSQL 9.5, 9.6, 10, 11, 12 Oracle 10g, 11g, 12c AWS RDS MS SQL Server 2008, 2012, 2014, 2016

Database Tools: PgAdmin, PgBadger, PgHero, PgAgent, PEM, Peoplesoft, ServiceNow, OEM, Exp/Imp/Data Pump, Toad, RMAN, SQL*Plus, SQL Loader, DBCA, log miner, Stats pack, Awr, Addm, DBUA, Remedy

Operating System: LINUX/UNIX, WINDOWA, SOLARIS

Languages: SQL, PG/PLSQL, T-SQL, Ansible, Python

Contact this candidate