Oracle Sql
Resume:
Armstrong Simbo
***** ****** ****** **, *****, MD 20721
********@*****.***
PROFESSIONAL PROFILE
Database Administrator with over 6 years of working experience and over 10 years of IT
exposure. Possesses extensive experience in Administration, Application, Installation,
Configuration, Performance tuning, Proactive Monitoring, Troubleshooting, documentation in
Oracle and MS SQL servers with Good Verbal, Written and Interpretation-communication skills.
Provided support for Full Product Lifecycle environments, comfortable in both
Development, Testing, UAT and Production environments with strong problem analysis and resolution
skills from O/S to database perspectives with OLTP, OLAP, DSS & DW with database sizes ranging
from 20G to 80G OLTP and over 2TB Data
Have Extensive experience in administration, management of oracle 9i, 10g, 11gR2, RMAN,
Datapump, ASM, RAC, Dataguard, Oracle Goldengate, Stream, OEM Grid Control 12c, OBIEE, T-
SQL, SQL, PL/SQL, Perl on AIX, HPUX, Linux (Red Hat), FreeBSD, Solaris, Tru64, MS Windows
2003, 2005, 2008R2, 2010, 2012, NT.4
PROFESSIONAL EXPERIENCE
Bereans Technology LLC - Silver Spring, MD (Sept 2011 –Present)
Title: Oracle & SQL Database Administrator
Responsible for provided technical support direction to developers for database system enhancements
in Development, Testing, Production and maintenance to improve database and O/S performance.
Performed database migration & Upgrades from Oracle & databases from 9i, 10g to 11g databases
Installed, configured Oracle Software 10g, 11g on various O/S and environments.
Upgraded and Patched Oracle 9 to10g to 11g & applied Oracle CPU recommended by Oracle.
Responsibilities also included daily Backups, Monitoring, Performance Tuning, Troubleshooting,
Configuration, Installation, Administration, routine checking of Alerts, alertlogs, trace files,
space/system utilization, application of small to multi-terabyte databases.
Planned for growth of database objects for annual budget capacity planning.
Provided On Call Services and support to team during off hours & system maintenance.
Designed & supported Conceptual, Logical & Physical Models. Created ERDs via Forward &
Reverse Engineering using Erwin, Oracle Data modeler & TOAD.
Installed and configured Oracle Software on New Builds, 10g, 11g, OEM Grid and
Created databases, Schema objects, tables, views, synonyms, functions, procedures.
Setup, Configured, monitored, managed Unidirectional and Bidirectional Golden Gate Replication in
Oracle and MS SQL servers
Setup and managed Golden Gate pump, manager, extract and replicat components
Configured Golden Gate checkpoint table for data recovery & moved data using Oracle Parallel
technology, configured Macros for Exception to prevent process termination
Configured Workload Distribution client & server sides in RAC, Cluster Interconnect, Network
Interface, Oracle Agents and managed RAC installations using OUI, DBCA, NETCA, Server
Control, Cluster Control, Oracle Parallel technology
Administered and managed physical, logical and primary standby databases on remote sites
Monitored system access & memory by performing routine checks on the SGA, CPU, logical and
physical I/Os, Alerts, free space, lock contention, disk utilization using Oracle Cloud Control 12c
and OEM Grid control & vmstat top command to monitor O/S performance issues
Installed, Created, managed MS SQL server 2005, 2008, 2010 and created databases (T_SQL),
Functions, Schemas objects, tables, Designed Diagrams and Recovered, Restored, Backup
databases using Full and Differential backups. Scheduled Backup Jobs using maintenance Plan
Wizard on Microsoft SQL Servers
Installed OEM Cloud Control 12c, OMS host and agents on additional nodes. Used the two-
system approach to upgrade from EM10g or 11g to EM12c and deployed databases from OMS
host and target
Used Unplug and PDB to Migrate databases to new platform, new hardware, new DB releases and
different systems enhancing High Availability of databases moving between systems
Configured and Managed Split Data Dictionary using CDB Administrator to find out current
container logged in.
Gathered database & O/S statistics using Remote Diagnostic Agent to troubleshoot and document
systems performance and Auditing users activity
Compiled PL/SQL blocks, Packages, Procedures, Functions, Triggers and used WRAP to
encrypt PL/SQL application with extensive experience in data management using Oracle utilities
Used SQLCODE & SQLERRM in exception to handle reports and store errors in log table with code
Generated PL/SQL Debugging output using the SHOW Error command, DBMS_OUTPUT package
Configured Metric Thresholds, ADDM, SQL Tuning/Access Advisors and ran ADDM, AWR,
ASH Analytics Alerts for Automatic diagnoses, notifications and prompt resolutions
Gathered and Analyzed Tables, Indexes and Clusters against fragmentation using dbms_stats,
analyzed statement, EXPLAIN PLAN and TKPROF and documented database performance
Tuned, managed, Diagnosed databases, O/S using RDA, Server-Generated Alerts, ADDM,
AWR, Advisors, Statspack, ADDR, Toad Captured, ADRCI, ASH, PL/SQL scripts, Autotrace,
DBMS SQL Tune package, Shrink command to reclaim free space and improve performance
Configured, installed OBIEE and Worked with user base to provide analytical (OLAP) and
operational tools used in market operation.
Created and managed database User Accounts, Profiles, Granted, Revokes Roles, Privileges to
enable Data Dictionary protection, limited and restricted users from accessing O/S, databases
and components via vendor using Standard Database Audits (Triggers)
Encrypted sensitive data, backup media using Transparent(TDE), Password, Dual encryptions
Authenticate clients string, passwords and system resources to meet companies SLAs and corporate
password expiration policy standards ensuring Principle of Least Privilege.
Configured ODBC, SQL*Net/Net8 utilities, Oracle Shared (MTS) and Dedicated Servers
Self Troubleshoot, resolved Oracle & system errors with Oracle support via Metalink, MOSC
Configured Backup and Recovery for new Oracle databases upon creation for 10g and 11g
environments using RMAN, Flash Recovery, Block change Tracking and Datapump.
Provided DBA support for clients from Development, Testing, UAT to Production. Task coordinator
for educational project, new users via various phases: Installation, Database Creation, Upgrades,
Migration, Replication, Monitoring, Turning.
Automated daily tasks at database level with Crontab, AT command & SCHEDULER at O/S
Reorganized and restructured existing Databases to meet OFA standards for Continuity
Reorganized database using backup controlfiles to trace to restructured databases
Resized, relocated and duplexed redo logs to reduced log switching in DSS
Resized, cloned, moved, Partitioned and stripped Tablespaces for availability
Analyzed Tables, Indexes and Clusters against Chained and Migrated Rows/blocks for performance.
Installed, configured and administered ASM, Migrated file systems from Local File Systems to ASM
Configured CSS, ASM Disk group attributes, voting Disks & Monitored ASM running operations
Created database from scripts, export dumps, for used in development and test projects from
production needed by developers
Performed database Refresh to update data in Development & production environments.
Planed software release, upgrades, changes in development, test and production.
Participated in Change Control meetings, reviews and suggestions to database changes.
Planed and implemented Oracle patch update as recommended by Oracle .
Maintained database backup and recovery infrastructure and perform backup tasks using RMAN.
Configured RAID, Stripped & Mirrored Disks for local file systems to improve disk performance
Performed routine administration, system and database health checks, disk usage, user access.
Installed, configured Oracle Grid control, agents, middle tier application web servers
for Remedy 2 tier standard and Agile methodologies of Refactoring.
Cloned databases from one server to the other for testing and database refreshment in
requested in development using Export /import, RMAN, transportable tablespaces and Data
copying
Provided weekend support during sensitive projects, worked under pressure and stayed
up late at night to delivered to the customer.
Participated in conversions, cut-over steps, checklists and procedures on new sites
requested by the Clients. Provided general technical support to team members and Programmers, IT
Support Staff
Assisted with database engineering efforts, deployment, application, Database production Support
to implement & transit newer product versions, on ongoing full product development lifecycle
VakifBank
C/o Bene Corporative Ltd (BCL)
Gemikonagi, Cyprus Northern (Sept 2007 - May 2011)
Title: Oracle & SQL DBA
Worked as Data Architect with other Data Architects to improve Oracle designs, implementations
and application to improved cost and ensure maximum performance and availability
Planed software changes, upgrades and implemented new Releases as requested on systems
for Optimal performance, maximum Availability and Protection.
Refreshed databases using the moved, shrink command, datapump, and Data copying
Proactively monitored, Tuned, Troubleshoot database errors, O/S & user problems to minimized
DB_time, to enhance & ensured Quality and Performance of all production & test databases
Upgraded Oracle 9 to 10g to 11g on various servers and platforms: AIX, HPUX, Unix, Sun,
Installed SSMS, created databases, schema objects, tables, Functions and Designed Diagrams,
Backup databases in T-SQL using Full & Differential backups and Scheduled Backup Jobs using
Maintenance Plan Wizard on MS 2000, 2005 and 2008
Installed, configured & managed Oracle, Oracle software, databases, from scripts, export dumps
and cloned for use in development, test and UAT environments
Performed shell Scripting, Korn, Bash shell, Perl, sed and awk in various environments
Extensive experience with Oracle SQL, SQL*Plus, PL/SQL and Datatypes
Wrote scripts and implemented databases moves from 8i, 9i to 10g and 11g environments.
Compiled PL/SQL Packages, Procedures, Functions and Triggers for database auditing and
generated Debugging output from PL/SQL with SHOW Error command
Coordinated, supported and managed DBA tasks on various Projects needed in development,
Testing, UAT and production of new & existing applications
Gathered and Analyzed Tables, Indexes and Clusters against Chained and Migrated Rows using
dbms_stats, analyzed statement, Cost Base Optimizer with an Explain Plan and TKProf
Automated, managed, Diagnosed databases and O/S using RDA, Server-Generated Alerts,
ADDM, AWR, Advisors, Toad Captured, Statspack, ASH, Autotrace, DBMS SQL Tune package
and Shrink command to reclaim free space and improve O/S and database performances
Configured, Analyzed O/S and workload with RDA, BI outputs to provide analytical &
operational tools used in market operations in both development and production environment
Implemented RAID levels for local file systems management for availability
Analyzed and Contributed to both product development and process improvement using BI and
RDA outputs to reduced problem diagnostic time, worked with direct clients on Agile Data Modeling
to provide analytical and operational tools used in market and business operations
Reorganized and restructured existing Databases using backup controlfile to trace
Resized, relocated and duplexed redo logs to reduced log switching in DSS and D W
Resized, cloned, moved, Partitioned and stripped Tablespaces for high availability and
performance
Prepared, compiled, assisted and maintained Documentation procedures, standards and guidelines
Implemented change requests, or necessary modifications to the database structure and/or data
changes through the use of coordinated Change Request meetings from supported Team Leads.
Investigated, designed, tested, implemented database security procedures recommended by
Oracle.
Maintained database backup and recovery infrastructure with RMAN, Datapump and Veritas
Backup.
Created and Supported Oracle 9, 10g and 11g databases on Veritas Clusters.
Created database Objects, Tablespaces, Application Users, Database schemas, profiles, granting
privileges and roles, and created Database links, configured Oracle STREAMS for replication
Configured and moved data between databases using Oracle streams, replication and data pump
Extensive knowledge of clustering, materialized views, b-tree, and bitmap indexes.
Designed, constructed conceptual, logical and physical modes from/to ERDs with Erwin,
TOAD
Reviewed Capacity Planning, Storage needs, parsing and O/S & database security from
vendors.
Installed Oracle Security and Daylight savings patches released by Oracle Corporation
Goodman Institute of Technology
Buea, Cameroon (June 2003 to Sept 2007)
Network Administrator
Supported IT infrastructure as Jr. Network Engineer. Used Acronis for systems backup
support tasks, Windows Active Directory and general user support roles.
Proficient in Microsoft Office word, Access, Excel, PowerPoint.
Experienced working with multi-tenant architecture, implementation on virtual private
databases, Oracle VM VirtualBox, Vmware
Configured TCP/IP (ipv4), Gateway, subnet mask & troubleshoot connectivity, computer
issues using ping, ipconfig, netstat, tracert & telnet
Built MS virtual PC 3/7/8 using VMware player and Oracle VirtualBox, created multiple
hard drives within Guest machines and stripped RAID
Installed Active Directory servers using VMware player & added features, Roles, sites,
managed policy, routers, switches
HARDWARE/SOFTWARE includes but not limited:
Operating Systems:
Sun Sparc– Oracle Solaris 2.6, 2.9, Sun Fire, Dell Power Edge, AIX, HPUX 11.0, Tru64 UNIX 4.0 Alpha,
Windows 2003, 2005, 2008R2, 2010, 2012, XP/NT4.0
Databases:
Oracle 9i, 10g, 11gR2 Enterprise editions, OLTP, OLAP, DSS, Data Warehouse, MS SQL Servers 5.x, Oracle
SOA suite 11.x
Other Software & Tools include but not limited:
Oracle Applications – Forms and Reports 6i, Oracle Designer, Remedy Application Management systems,
(BMC), Stargate, Oracle developer, Share point, Spotlight by Quest, MS SQL Server, MS-Excel, Data
modeler, PVCS Tracker, Tivoli Desktop, OEM Grid Control, Oracle Expert, RMAN, SQL Developer, IBM
ClearQuest, CDC, Tuning and Diagnostics Pack, SQL Loader, External Tables, OBIEE, RAC, ASM, Oracle
12c, TOAD, Veritas Backup, VNC, Oracle Data Modeler, ERWIN, TOAD
EDUCATION
Associate in Civil Engineering
European University of Lefke (EUL), Northern Cyprus. June 2010
100% open to Relocation & Travel Extensive within US & the World. Speaks, read and write
French, Turkish (multilingual)
Contact this candidate