Oracle Dba Resume
SUMMARY:
- Oracle DBA / Designer Developer / Technical Systems Analyst / Team Lead +15yr experience creating reliable systems in large scale data centers, with a focus toward making both servers and People more effective.
- National Lead Oracle DBA for Confidential Develop and Deploy to 33 districts across US, 4yrs.
- Server Design team: Confidential national flight shipping hub. Oracle server cluster DBMS + Control Logic
- Confidential: Oracle design & development DBA, analyze ATPCO price/ticket data of Confidential (3xDaily)
- Confidential: Advanced Architecture Group, working for top - tier and custom Database +App development.
- Confidential: DBA on data center server migration projects & promoted to DB-Architecture group.
- DBA on large scale servers with Fortune-100 companies, plus Federal & State government, and Banking.
TECHNICAL SKILLS:
LANGUAGES/ TOOLS & SOFTWARE: Oracle 12c/11g & prior versions: RDBMS & SQL, SQL*Plus, PL/SQL, OEM, RMAN, RAC, ASMwith related database tools/apps. "C", Perl, Pro-C, Solaris (v10), HP/UX (11.31), AIX, AT&T Unix,Linux (many versions), BSD, Unix tools & scripting: ksh, bourne, bash, sh, csh, Perl, awk, sed,SAP, MS-SQL-Server (multi-versions), ER/Win, MySQL, Spotlight, Toad, FogLight.
HARDWARE & SYSTEMS: HP 9000 to HP Superdome ( HP/UX 11.31 ), IBM AIX, Linux ( RHEL, SUSE, OEL, Debian, Centos ) including large SMP clusters or blade servers, Sun SPARC 10/20/2000/ E3000/ V880/ E4800/ E10000 (Solaris), MIPS R4000 series 4360/4460/4680 (EP/IX Unix), DEC:VAX/VMS 8650, Win2008R2 server, Win2012 server, Win2003, Win7, Win10 as required.
PROFESSIONAL EXPERIENCE:
Confidential
Oracle DBA
Responsibilities:
- f all USA production systems, with multi-TB storage for multinational company while maintaining active business transactions during migration, and complex data flow between inter-dependent systems. Server configurations used both single node and RAC cluster systems, also supported many external data feeds plus customer facing sites. Apps processed high security data, and exchanged information with third-party data sources - integrated via secure API interfaces, using both ETL-Loads replication and Golden Gate to link data warehouse with multiple facilities & web interfaces. My DBA Work also included Oracle performance tuning, capacity planning, replication, scripting, job / task scheduling, and monitoring routines written with Linux shell, Oracle SQL, and OEM framework.
Confidential
Sr. Oracle DBA
Responsibilities:
- Oracle DBA supporting automobile manufacturer, with national scope systems including vehicle orders, distribution, tracking & inventory, dealer systems, financial SAP servers, app migration and design enhancements. Support for 11g and 12c databases in 4x RAC configuration, including design, tuning, diagnostics
- OEM, scripting, migrations, re-structuring, and job control automation. Oracle DBA for multiple 2TB-15TB databases, mostly on Linux clusters, plus AIX, and Sun systems. I was promoted to DBA Engineering/Architecture team, which was responsible for setting deployment policies & DBA admin standards for thousands of GM servers. Personal DBA responsibility included security, performance, capacity planning, OEM, reporting, migrations, tuning, development, and verify/audit of database policy compliance. I also mentored other DBAs on both Oracle DBA and Unix/Linux topics.
Confidential
Oracle DBA
Responsibilities:
- DBA with Fortune-50 Company, supporting multi-TB Oracle databases on Unix/AIX/Linux/Solaris production servers for SAP & corp-level applications. Confidential is major health-care, medical supply, pharmaceutical, software & equipment provider to hospitals & doctors throughout North America.
- My primary focus: reliability, tuning, diagnostics, Data Guard, high availability, and capacity planning so database servers, giving related applications sold performance & efficiently for both the Georgia and California data centers. Related business processes range from internal applications, SAP accounting systems, and Data Warehousing to external facing corporate sites.
Confidential
Oracle DBA
Responsibilities:
- Oracle DBA supporting manufacturing and distribution company: Cooper is a Fortune 500 corporation, with 38,000 employees, acquired by Confidential Corp in 2012. Lead role in migration of Oracle/SAP from hosted data center to servers in new location, with live replication and no uptime interruption. DB servers were running Oracle 10g+11g on HP/UX 11.31 Superdome servers with 50TB+ of HP-XP24K SAN storage.
- Supported production dev & test servers, significant tuning & performance analysis, storage and capacity management, data analyst support, upgrades, security, migrations, multi-tiered backups, advanced scripting, load balancing. Mentor several team members for Unix and Oracle. Operations Support DBA for core MS SQL Server 2003/2008R2 clustered databases, and legacy DB2.
- Linux systems used multiple O/S distros, including Red Hat (RHEL), Debian, and SUSE machines with replication and high availability redundant configuration across two data centers.
Confidential
Oracle DBA
Responsibilities:
- DB servers primarily Oracle 9i, 10g, 11g, plus DB2 on IBM AIX 5.3 using EMC +Clariion SAN storage.The databases supported business units for both internal and customer facing such as online banking data warehousing, fund & customer analysis, CRM, PeopleSoft, and stock & shareholder processing.
- My roles included support of production and testing servers, tuning, storage/capacity management data analyst & developer support, upgrades, security, migrations, mentoring, backups, scripting, load balancing, DB recoverability & HA with Veritas NetBackup +RMAN, /w SAN level mirrors at DR site.
Confidential
Oracle DBA
Responsibilities:
- Oracle 9i & 10g Database Administrator for large data center (ie: Co-Location facility) operated by Confidential and IBM which supported over 800 Oracle databases & servers for client companies across the USA. These servers were primarily running Oracle on AIX 5.3, using enterprise grade SAN storage, with some HP/UX systems as well. My DBA role included database installation, migration, upgrades, and patches, plus Unix level shell scripts, cron jobs, reporting, monitoring and configuration.
Confidential
Oracle DBA
Responsibilities:
- Oracle Database Administrator for several state-wide applications used by Georgia employees, vendors, and residents. Database systems were largely Sun/Solaris servers, running primarily Oracle version 9i and 10g. Applications included state purchasing & vendor registration, equipment inventory, risk management & claim processing, with both 2-tier client/server, and web-based systems.
- My DBA role included database design, performance tuning, application configurations, backup and recovery, patch and upgrades, reporting, user management & support, scalability, capacity planning, and Oracle mentoring. I also had significant Unix admin duties on Solaris, with server tuning, task automation, Perl + shell scripting, troubleshooting, job control, monitoring, etc.
Confidential
Database Administrator / Systems Support
Responsibilities:
- System administration of computer apps, operating systems, and databases, for in-house servers and systems designed, installed, and maintained for multiple client sites. This included DBA work, applications configuration, and network management on multiple platforms.
Confidential
Database Consultants
- Systems Consultant/Architect for a multiple client companies, primarily in telecommunications and banking. Performed DBA and Sys-Admin work using Oracle 8i and 9i, including full system install, configuration, tuning, design, parallel server config, data migrations and application development.Majority of Oracle DBA work was done in Unix environments, including Sun Solaris, IBM AIX, HP/UX, and Linux. Unix admin work included O/S install, user administration, security, disaster recovery (DR) planning, network support and custom scripting with tools such as ksh, bourne, bash, awk and Perl.
Confidential
Advanced Architecture Group
Responsibilities:
- DBA on design and development team to create automated package handling system for new Confidential national air freight hub. Custom system was organized around a triple Sun E-10000 cluster running Oracle 8i as parallel servers for support redundancy. These servers handled tracking information for every overnight package shipped through the Confidential national hub, and integrated with a multi layered control system, to handle and route the physical packages through the Confidential facility, and direct them to correct flight containers. Worked as design/development DBA in the Advanced Architecture group for project.
- Also involved in design & logic for control flow, as well as portions of the networking analysis. Solaris cluster was configuration of 120 CPUs /w 96 Gig RAM, (nearly largest avail in 1999) with Oracle databases using 3.2 TB of EMC/RAID storage, designed for high availability/performance/uptime.
Confidential
Responsibilities:
- Systems Analyst and Oracle DBA for client data centers, with development focus on Oracle database architecture in Unix / Posix environments. Servers included Solaris and HP Unix boxes, generally using Oracle 7.3 RDBMS and “C” based applications in a variety of configurations. With eight years of DBA experience and ten years of application development in “C”, my duties included database design, installs, configuration, and tuning, as well as design of application modules.
- As necessary, I also determined requirements of the hardware platform for database servers, and established the operating, control, and management/deployment policies for DBMS system in production.
Confidential
Oracle DBA+Designer
Responsibilities:
- Design and development functions for revenue management and pricing division of Confidential . System performed competitive analysis of ATPCO pricing data based on ticket fares changed from every airline in the United States. Market Analysis was performed on ALL ticket routes and pricing data multiple times daily as updates were released to airline travel/ticketing agents. My personal DBA responsibility included design/implementation of Oracle databases and code to support large capacity and rapid throughput of a system with over half a million update transactions received per day.
- As development DBA for project, I was central to design factors ranging from data flow analysis and hardware systems planning, to internal application structure. Development system & tools: Sun 2000E, with 14 CPUs, Solaris, Oracle 7.3, Rational Rose, Rogue Wave, dbTools, C++, ER/Win.
Confidential
Engineer
Responsibilities:
- Systems Analyst for Confidential, provided Unix/Oracle expertise to allow the port/upgrade of systems, and was National Lead DBA for Confidential staff at all server locations. Applications included a nationwide real estate management system which I ported from an Intel platform to distributed Unix CDC/MIPS servers deployed to over 30 cities/districts. This application was also migrated from Oracle's SQL*Forms 2.3 to 3.0 +later to ver4.5. DBA duties involved full support for Oracle 6x and 7x, with upgrades, migration, version control, deployments, schema changes, and associated utilities. Support roles extended to Unix admin, Oracle developer, teaching DBA classes in DC, and "C" development.