Manager Oracle
Resume:
CHRISTIAN FOTACHWI
***********@*****.***
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