CHRISTIAN FOTACHWI

acycrf@r.postjobfree.com

240-***-****

Position

Oracle Database Administrator

Professional Summary

Amazon RDS for Oracle Database - Amazon Web Services (AWS)

Transparent data Encryption (TDE)

Oracle data redaction

Proficient with Oracle PL/SQL

Normalization

Installation, configuration, migration, upgrades

Foglight Performance Analysis for Oracle

SAP BusinessObjects Web Intelligence 4.1

Cross Platform Data Migration and Upgrade

Stored procedures, functions, triggers and packages

Extensive experience in Database logical design (ERD) and physical implementation

Industry best practices

RMAN

Oracle Enterprise Manager (OEM)

Root Cause Analysis

Performance Tuning and Troubleshooting

Experienced in managing Oracle RDBMS on Windows and NIX-based OS

Ensure that all aspects of database environment(s) are OFA compliant

Capacity Planning

Oracle DB System Development Life Cycle (SDLC) planning

Well versed with JSON and XML documents

Working Knowledge of HTML, CSS and JavaScript

Proficient with MongoDB 3.2 (Enterprise Edition)

MongoDB Atlas – Cloud Service to run Database as a Service (DaaS)

CRUD Operations

Replication, High Availability and Disaster Recovery Solutions in MongoDB

Sharding

Security (Authentication, Authorization, Auditing, Encryption) in MongoDB

Professional Certifications:

Oracle 11g Database Administrator Certified Associate (OCA)

Oracle 12c Database Administrator Certified Associate (OCA)

Professional Experience

PL/SQL Developer – Oracle DBA

Carnegie Mellon University June 2013 - Present

Pittsburgh - PA

Responsibilities:

Deployed Oracle 12c Enterprise Edition Databases using the Amazon Web Services (AWS) console

Configured various settings on Amazon RDS for Oracle Database such as backup retention policy, backup window, security groups etc... all based on Service Level Agreements (SLAs)

Configuring Oracle Client tools to connect to Oracle Databases on AWS

Gathering and analyzing exact requirements.

Configured Oracle wallet with keys to encrypt sensitive data

Generated CRS and installed various certs for Applications

Build several forms using PerfectForms

Wrote several Encrypt/Decrypt functions with different encryption algorithms along with other Oracle supplied packages

Translates business requirements into structured systems design

Identify, design and develop Oracle PL/SQL stored packages, Procedures, functions, database triggers, PL/SQL Tables and Nested tables

Co-ordination with Client on issues and clarifications

Documentation of various activities in the process of Development, Enhancement and Issue Resolving

Successfully migrated the production environment from Windows server 2008 to RHEL 7

Performs production support activity on identified incidents

Wrote scripts to create tables, views, indexes and synonyms required to meet with developers’ needs

Working with Java J2EE developers to develop and formulate capacity planning for 11g and 12c databases

Loaded the data into database tables using SQL*loader from text and excel files

Created several tasks in Automate (A .NET Application used to automate task)

Configure ACLs to send emails from database procedures

Loaded data from XML files into Oracle database tables using JDBC Connections and XML SQL UTILITY (XSU)

Applied quarterly patches to all Production, Development and Test environments

Upgraded Oracle 11g to 12c using Oracle’s recommended best practices such as Transportable Tablespaces (TTs), DBUA, RMAN etc.

Created steps to refresh Dev databases on a nightly basis with data from production

Used Foglight Performance Analysis for Oracle to diagnose performance related issues along with other Oracle supplied utilities like AWR, ASH, ADDM, Explain Plain etc.,

Worked so closely with J2EE Developers to coordinate business rules and requirements

Wrote several procedures based on the business logic (Requirements)

Created various reports using SAP web intelligence module with pre-configured universe

Provide documentation and Root Cause Analysis for Issues

Extensive experience in deploying, managing and developing MongoDB clusters. Creation, configuration and monitoring Shards sets.

Analysis of the data to be shared, choosing a shard Key to distribute data evenly.

Architecture and Capacity planning for MongoDB clusters. Implementing on premise MMS monitoring and backup solution

Used third party tools such as ROBOMONGO and other MongoDB tools like Atlas to monitor and analyze the performance of MongoDB

Configuring high availability using geographical MongoDB replica sets across multiple data centers

Worked on creating various types of indexes on different collections to get good performance in Mongo database

Implemented read preferences in MongoDB replica set

Configured delayed secondaries to avoid human failures in coding and development.

Strong experience in analyzing chunk migrations, splitting and balancing across the sharded cluster

Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability in various crash scenarios.

Familiar with MongoDB write concern to avoid loss of data during system failures

Installation of MongoDB on physical machines, Virtual machines as well as AWS. Backup & Recovery, Database optimization and Security maintenance.

Configured various alerts and monitoring settings in the MongoDB Atlas Console such as Two-Factor Authentication, Disk space used, Disk I/O utilization

Environment: Educational System.

RDBMS: Oracle 11g and 12c.

NoSQL DB: MongoDB 3.2

MongoDB Tools: RoboMongo

Operating Systems: Windows and Linux

Tools: SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash and Perl Scripting, Wallet and keystores

ETL Tools: SQL Loader

Version Control Utility: Apache Subversion (SVN)

Task Scheduler: Automate 9, Crontab

IDE: PL/SQL Developer, SQL Developer

BI Tools: SAP BusinessObjects Web Intelligence 4.1, Crystal reports

Oracle DBA

CHAVERAN INC. - April 2011 to June 2013

Bowie, Maryland

•Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases on Linux, Solaris and Windows OS

•Installation and configuration of Oracle 12c databases for testing purposes

•Performing database design and development for instances used in test, development and production environments.

•Establish and maintain sound backup and recovery policies and procedures based on Service Level Agreements (SLA)

•Ensuring compliance with clients Oracle license agreement

•Implementing Oracle ASM and resolving ASM related issues

•Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.

Ensure that all aspects of database environment(s) are OFA compliant

Database logical design via Entity Relations Diagram

Backup / Recovery methodology specification for mission critical databases

Performed hot and cold Backups.

Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs

Identified and recovered corrupted db blocks using Block recover option in RMAN utility

Extensively using DATAPUMP and Export /Import utilities for logical backups

Develop scripts (batch and shell) to automate frequent administration tasks

Refreshed Development and Test databases from Production data set

Participate in development and delivering of technology-based systems for a

wide range of applications for different customer groups

Writing technical steps for junior DBAs to execute on instances during off-peak hours to

provide on-call technical directions over the phone during system downtime

Monitor and troubleshooting databases that are part of highly visible

real time transaction, data warehouse and OLTP applications

Worked beyond regular hours based on business demands. Provided 24x7 on-call production supports

Provided remote technical support using SSH and terminal services

Create and configure Oracle databases using DBCA

•Perform Daily Monitoring of Oracle instances and various alerts using Oracle Enterprise Manager, Scripts and TOAD

•Serving as Oracle RDBMS SME for clients

•Used explain plan, AWR, ASH, ADDM and various Oracle Advisors to tune the database

•Modify database structures as required by developers due to business or application requirements

•Monitor user sessions and take appropriate action to kill the inactive session

•Troubleshoot and resolved log gap issues in Data Guard Configuration

Performed proactive and reactive tuning/managing database space utilization and growth

Managing database security by creating and assigning appropriate roles and privileges to users depending on the user activity. In addition to using Oracle Advanced Security option.

Configure Flashback database setting the necessary parameters and Flash Recovery Area, then using RMAN to issue Flash Recovery Commands

Set up and configured SQL*Net and on servers and client machines

Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster

Performing routine database health checks in order to forecast possible issues

Handle database server tuning, application tuning and maintaining documentation

Involved with proactive capacity planning in terms of memory and storage usage and establishing benchmarks for performance

Perform database maintenance by applying required patches and software updates

Cloning of production databases as needed for testing, development using RMAN or scripts

Maintain up-to-date documentation to comply with C&A requirements

Junior Oracle DBA

Comcast, Houston, TX February 2010 – April 2011

Responsibilities

Managed Oracle Databases on Windows and Linux platforms.

Performed activities like monitoring the database and provide maximum uptime.

Created and granted users the privileges and roles and resizing the datafiles to manage database growth.

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

Created primary database objects (tables, views, indexes) once application developers have designed an application

Granting and Revoking Privileges as required by the Lead Database Administrator

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

Monitored the alert logs and troubleshot the errors.

Worked with very little supervision

Document all security practices and create daily management reports

Scheduled the backup jobs such as export through cron job in UNIX environment.

Rebuilt indexes and analyzed tables to ensure good performance of database.

Installed Oracle 9i and 10g on multiple platforms.

Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.

Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.

Installed and managed Oracle Enterprise Manager

Troubleshoot and resolve various Oracle connectivity problems

Perform bulk load into the database using SQL Loader

Maintain documentation and standards.

Education and Training

BS Information Systems Management, University of Maryland University College (Expected Grad 2017)

ADDITIONAL INFORMATION

Technical Skills

SOFTWARE/ APPLICATIONS/ TOOLS:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control 12c, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp, impdp), SRVCTL,SQL*Plus, SQL Developer

Operating Systems:

Unix, Linux, Sun Solaris, Windows 2008/2012 Servers

Tuning tools:

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

RDBMS:

Oracle 10g and 11g

WEB TOOLS:

HTML, CSS, JAVASCRIPT, XML

Telnet Tool: Putty

References.

Available upon request

Contact this candidate