- Featured in:
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Oracle Database Administrator Resume Samples
No results found
0-5 years of experience
Administered 102 Oracle 8i servers running on NT, nationwide for a large postal service organization.
- Monitored and tuned database performance.
- Automated and implemented backup and recovery procedures
- Provided troubleshooting support
- Supported development staff..
- Documented routine procedures, such as backups, monitoring, and architecture layouts.
0-5 years of experience
Managed all aspects of Oracle database administration, physical and logical database design, documentation, maintenance and backups.
- Installed Oracle software, created databases on NT and Sun Solaris.
- Designed database architecture and application schema.
- Participated in all phases of the system development life cycle from requirements analysis through system implementation.
- Collaborated with development team to tackle database/application issues.
- Designed and implemented Oracle database backup/recovery scheme and setup security and storage management strategies.
0-5 years of experience
Performed various DBA monitoring and maintenance activities on Sun Solaris 2.5 including, but not limited to, UNIX and database level performance tuning on three existing databases.
- Installed Oracle 7.3.4 and performed data migration from various databases to new systems, as well as managed user accounts and privileges.
- Performed testing of backup and recovery procedures for newly installed databases.
- Provided technical support to the development team, and performed application performance tuning using the TKPROF utility.
0-5 years of experience
Responsible for DBA support for [company name]’s Integrated Clinical Database (ICDB) system.
- Installed Oracle 9i database and Oracle 9iAS Application Server software, and created database instances in several environments to support the ICDB project.
- Designed and created tables with indexes, triggers, sequences, and foreign keys to support ICDB interfaces. Created and ran seed data loads for static table population. Created stored packages and procedures for data inserts and updates to the ICDB database.
- Provided database and SQL programming support for the TOL Oracle 9i database, also utilizing export/import and SQL script creation to support TOL data conversion processes.
- Lead database administrator and database PL/SQL programmer for the Joint Medical Work Station (JMeWS) healthcare project for the Navy, utilizing Oracle Advanced Replication for a distributed architecture. Configured Oracle Advance Security for data encryption over the internet.
0-5 years of experience
Oracle database administrator and data modeler responsible for the construction of a newly modernized system to replace an existing IRS legacy mainframe DB2 system built to monitor fraudulent banking activity.
- One of the principle data modelers that constructed the conceptual data model for the existing IRS legacy system to identify all internal and external data stores and system interfaces.
- Designed and built the staging database to load and profile the data from the legacy system to fully understand the relationships amongst the data and the current systems functionality.
- Designed and build the new conceptual and logical data model to depict a new streamlined approach that removed redundant data sources and system interfaces. Also, to show how the modernized system will provide additional functionality and a significant cost savings not available in the current legacy mainframe system.
- Conducted presentations using the new conceptual and logical data model to multiple government agencies showing them the advanced querying capabilities, pattern recognition, and data mining functionality the modernized system will provide.
- Designed and built the physical data model using the Erwin data modeling tool, Oracle 11g on an HP UNIX platform. Partitioned all large tables and implemented table and query parallelism for rapid load and extraction techniques for 3 terabytes of data.
- Worked with the security team to remove vulnerabilities on the database discovered during the security scans.
0-5 years of experience
Managed the Oracle software and hardware configuration implementation of Business Systems applications employed on Oracle Parallel Servers
- Provided support interface to the company’s internal business unit’s community, implemented backup and recovery procedures for on and off site disaster recovery strategy
- Facilitated database and application tuning, interface for application testing and code walk through respective to integrating new or changed applications into the production environment.
- Analyzed and offloaded company data from ASK/MANMAN hierarchical database to an Oracle relational database from the parent company legacy systems
- Migrated the given Business unit’s data (manufacturing, order management, accounts payable, and general ledger) to a relational architecture structures to provide client-server application interface
0-5 years of experience
Responsible for DBA support for [company name]’s Integrated Clinical Database (ICDB) system.
- Installed Oracle 9i database and Oracle 9iAS Application Server software, and created database instances in several environments to support the ICDB project.
- Designed and created tables with indexes, triggers, sequences, and foreign keys to support ICDB interfaces. Created and ran seed data loads for static table population. Created stored packages and procedures for data inserts and updates to the ICDB database.
- Provided database and SQL programming support for the TOL Oracle 9i database, also utilizing export/import and SQL script creation to support TOL data conversion processes.
- Lead database administrator and database PL/SQL programmer for the Joint Medical Work Station (JMeWS) healthcare project for the Navy, utilizing Oracle Advanced Replication for a distributed architecture. Configured Oracle Advance Security for data encryption over the internet.
6-10 years of experience
Provided excellent database administration in support of special programs employing HP-UX and Linux operating systems. Earned several Individual Achievement and Team Achievement Awards including Employee of the Month 2009.
- Created and supported critical database systems for multiple sites using both Oracle RAC 11g and singleton databases.
- Created scripts which performed database updates and modifications in support of government production systems
- Database security and hardening to exacting military standards (DOD-7877)
0-5 years of experience
Primary administrator of Oracle databases hosted on IBM zLinux supporting OKDHS Child Welfare application (KIDS) and various data warehouse and data mart reporting tools. Administration included troubleshooting, problem ticket initiation and resolution, database patching, backup scheduling, performance monitoring/tuning, training of junior DBAs and other tasks as necessary.
- Planned and implemented system-wide upgrade of all Oracle databases from 10g to 11g
- Upgraded Oracle Grid Control server to Oracle Cloud Control (12c) in support of all Oracle installations
- Provided primary Oracle documentation and support for successful Enterprise-wide Disaster Recovery exercise
0-5 years of experience
Worked with all site System Administrators, System Operational Support Capability, and Product Data System Modernization (PDSM) in the accomplishment of Air Force specific database needs, managed the JCALS Databases, coordinated with the local POC, led site specific database modification or tuning efforts.
- Performed various data extractions, and ensured data integrity, wrote and maintained SQL scripts to generate database reports, to monitor database usage and security, performed user administration, performance tuning and database maintenance,
- Restored database from backups and archive logs, performed trouble shooting of database.
- Installed Oracle 9i for a development database, configured Listener and TNSNAMES functions, imported JCALS database, created users, granted/revoked quota, privileges, and roles to users.
0-5 years of experience
Upgraded & maintained the production, training, test, & development application OLTP databases (sizes 5GB).
- Tested RMAN scripts for several backup & recovery scenarios.
- Installed & configured Oracle 8.x & 8i on various platforms such as HP & NT.
- Monitored & troubleshoot all database for performance tuning purposes.
- Tuned the databases for optimal performance using Oracle Expert.
- Upgraded Oracle 8.0.5 databases to Oracle 8.1.7 databases.
10+ years of experience
- Maintained 14 production and development databases, 8 UAT databases, and 8 SYSTEST databases as well as 6 regional horizon databases that processed commissions for sales personnel.
- Perform backups and loaded data into development, UAT, and SYSTEST databases, resolving any performance issues that arise as well as blocking issues, snapshots failures, and replication problems.
- Instrumental in upgrading from Oracle 8i to 9i, creating conversion scripts to move data to the new format and databases files large enough to handle a one tier byte of data.
- Converted data from six 8i Oracle databases into one Oracle 10g database that ran a Solaris 10 UNIX OS.
- Used Oracle Advanced Replication to ensure data availability, table maintenance, and performance tuning.
0-5 years of experience
Prepared project plans for implementing an Oracle RAC installation in an IBM AIX environment.
- Installed and implemented Oracle 10g Grid Control
- Installed and created Oracle 10gR2 databases in several Microsoft Windows environments
- Established a backup strategy for uninterrupted database availability using Oracle Recovery Manager with Grid Control scheduling
- Implemented database monitoring alerts for 100+ Oracle databases via the Grid Control
- Created stored procedures for capturing audit information and reporting changes by firecall ID usage
- Installed and implemented Oracle’s Automatic Storage Management services utilizing Oracle Managed Files
- Implemented an Oracle RAC environment for migrating a production database from mainframe DB2 to an IBM AIX server environment. This project will include Oracle Data Guard and Advance Partitioning
- Upgraded 50+ Oracle 9i databases to Oracle 10g. Maintained and supported Oracle 9i and 10g databases
0-5 years of experience
Performed daily database administration on production/development environments to ensure availability.
- Provided strong system administration in Linux/Unix application for database design/modeling
- Performed Physical and Logical Design of the database which included Database creation, tables-spaces creation, table and index partitioning and also mapping of different objects with disks.
- Performed ongoing capacity planning and expansion to meet requirements of database growth.
- Maintained database for troubleshooting and problem solving to ensure that the system met requirements.
- Maintained multiple databases which supported production team to ensure consistency and stability.
- Provided root cause analysis to identify remediation of database issues trends such as contention and abnormal application locks.
- Cloned databases as needed for testing purposes.
- Performed backups using RMAN for complete and valid restore and recovery purpose
0-5 years of experience
Responsible for the administration of the Oracle Application Server 10g environment
- Responsible for the administration of the Oracle Applications 11i environment
- Specialized in administering Oracle Portal environments and Oracle Applications 11.5.9 environments
- Provided Oracle database related support for developers in portal and Oracle Applications 11.5.9 environments
- Performed database refreshes and database cloning
- Experienced in administering Oracle 8i/9i/10g databases
- Implemented UNIX shell scripts for HP_UX 11.11 and Linux Red HAT 2.1
- Experience with using SUN Solaris UNIX and RMAN
- Implemented SQL scripts for ORACLE 8i/9i/ environments
0-5 years of experience
Consulting for Fanniemae L1 support, monitoring 24/7 database servers and systems, and provide console and support of database systems.
- Using Remedy and BMC service incident ticketing system for supporting the databases and users
- Worked on creating, upgrading, and administrating Oracle database servers
- Implementing and maintaining Oracle databases in a multi tenant environment
- Responsible for seeing issues through to resolution
- Respond quickly and effectively to production issues within a giving time period
- Execute change request by executing sql scripts
- Maintaining users accounts which include dropping and unlocking account per requests to maintain user access compliances
- Working extensively with team mates and L2 DBAs to maintain and troubleshoot any situation that may occur with the databases
- Implementing and maintaining Oracle databases in a multi tenant environment
0-5 years of experience
Consulting for Fanniemae L1 support, monitoring 24/7 database servers and systems, and provide console and support of database systems.
- Using Remedy and BMC service incident ticketing system for supporting the databases and users
- Worked on creating, upgrading, and administrating Oracle database servers
- Implementing and maintaining Oracle databases in a multi tenant environment
- Responsible for seeing issues through to resolution
- Respond quickly and effectively to production issues within a giving time period
- Execute change request by executing sql scripts
- Maintaining users accounts which include dropping and unlocking account per requests to maintain user access compliances
- Working extensively with team mates and L2 DBAs to maintain and troubleshoot any situation that may occur with the databases
- Implementing and maintaining Oracle databases in a multi tenant environment
0-5 years of experience
Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the databases, evaluate requirements and recommend available DBMS products. Perform disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data.
- Creating and installing databases for various application implementation while tuning and designing reliability standards in stand-alone and distributed environments.
- Set up database users, manage database permissions and setup database roles, and enable database auditing for database security.
- Managing Oracle file systems using apps; ASM to increase efficiency while reducing overhead cost with standardized processes for shared services. Using E-Business suite to provide information-driven customer service that enables team members to meet customer expectations.
- Apply Oracle Patches and software upgrades (quarterly) using My Oracle Support (MOS)/Metalink to ensure database availability, reliability, accessibility, scalability and security. Migrating and upgrading databases from Oracle 10g to 11g.
- Responsible for minimizing downtimes on applications by ensuring the daily backups/ exports of database, archive logs to disk/tape systems. Set up and maintained backup procedures for database using RMAN.
- Participate in team building and certification projects impacting database platform with goal of delivering and implementing a reliable solution to support or enhance infrastructure.
- Collaborate with the Linux Systems Admin in O/S Configuration, patch application, users/disk space management, tape back-ups, documentation and day-to-day operations.
0-5 years of experience
Installed and configured Oracle 11g software on Sun Solaris version 5.10 and Oracle Linux version 5.4 operating system
- Implement and maintain Oracle Dataguard Physical and Logical standby databases for disaster recovery. Ensure that standby database is always in Sync with production database by checking archivelogs and copying missing ones over to the standby database when required.
- Installed and configured Oracle 11g RAC databases for development, test and production environments on multiple environments.
- Using Oracle Advanced Security option such Lightweight Directory Access Protocol (LDAP) -based directory service, such as Oracle Internet Directory (OID) to perform authentication
- Utilize Automatic Database Diagnostic Monitor (ADDM) to reduce DB time by diagnosing key problems such as Expensive SQL statements, I/O performance issues, locking and concurrency issues, Excessive parsing, Resource bottlenecks (including memory and CPU bottlenecks) and recommending a solution.
0-5 years of experience
Provided IT consulting and solutions for small businesses and non-profits
- Actively seek and solve complex IT issues
- Enabling clients to gain the most from there IT investments while staying within their budget
- Responsible to guide each project from inception to successful completion
0-5 years of experience
Installing and configuring new Oracle 10g and 11g databases
- Configuring Dataguard and RMAN backup policies
- Performing daily DBA routines
- Teaching and training coworkers in system procedures