- Featured in:
-
More Senior Oracle Dba Resumes
Use these Senior Oracle Dba samples as a guideline or visit our extensive library of customizable resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Senior Oracle Dba Resume Samples
No results found
0-5 years of experience
Participated in designing, implementing and maintaining the data replication (multi-master and simple snapshot) between Post and Washington DC servers for the Department of State, Bureau of Consular Affairs.
- Administered the replicated environments and deployed to new replication sites.
- Involved in the Year 200 projects to assure the applications are Y2K compliant.
- Participated in the database upgrade from Oracle 7 to Oracle 8, and provided support for Oracle upgrade, application installation and operation, and database implementation at the Post.
- Installed Oracle software and implemented database and applications on the server. Responsible for monitoring and troubleshooting the database environment.
- Analyze the database performance and performed database performance tuning.
- Document database procedures and responsible for organizing and instructing trainings for installer to perform upgrade oracle database and application from Oracle 7 to 8.
6-10 years of experience
Member of GDBA 24×7 support team; monitored alerts and supported RAC, non-RAC, Data Guard databases on Unix and Linux servers using Oracle OEM; analyzed, created solutions for challenging performance-tuning situations; recovered databases; proactively patched and upgraded databases to latest release; performed database change requests; worked closely with Oracle support to debug issues and applied solution.
- This support model has resulted in 99.9% up time for company critical databases.
- Provided on-going performance monitoring and debugging, resulting in a major reduction in downtime due to these issues.
- Upgraded to latest Oracle release enhanced availability and introduced new features for on going support of these databases.
- Created disaster recovery environment for company critical and essential databases.
- Trained team members and acted as DBA adviser for major HA projects has resulted in 95% successful implementations.
- The project has reduced downtime for databases by allowing switchover, fail over and recovering databases due to hardware or network failures.
- Documented lessons learned, standards and presented training on Data Guard for DBA team, saving team members many hours and improving efficiency in debugging related issues.
6-10 years of experience
Supported over 5,000 enterprise databases remotely using Oracle Grid Control
- One of three global specialists on Oracle’s memory architecture and spfile/init.ora parameter best practices
- Team leader of 30 DBA’s, increasing customer service and job satisfaction by 60% my first year
- Managed “Advanced Resolutions Team”, specializing in Fortune 100 service
- Published author of multiple while papers on memory tuning Oracle 9i, 10 and 11g
- Developed and delivered Oracle 10g and 11g training around the world
- Increased customer service rating for my department by over 40%
0-5 years of experience
Managed production and development Oracle databases (7.x, 8.x and 9i) that support the web based 401k funds trading/management system.
- Provided architecture design and implemented the all production database replication, backup and contingency recovery strategies for all OLTP Data Warehouse databases in the company.
- Designed and implemented disaster recovery plan using standby databases with dataguard.
- Created scripts for database backup, recovery, monitoring.
- Installed all Oracle databases and OEM tools on Solaris and Win2K environments.
- Participated in the full SLDC of the company’s web sites for 401k plan management. Developed JDBC modules and JSP/Servlet programs.
0-5 years of experience
Provided upper-tier escalation support to 70+ member services team for Oracle database and performance issues related to ARRA Meaningful Use and overall application concerns.
- Created 100+ defect change requests reflected in code patches and hotfixes
- Reduced database escalations 75% by resolving issues prior to development involvement
- Reduced object analysis time 50% by developing database audit tool used to check code versions
0-5 years of experience
Managed installation, maintenance, tuning, troubleshooting, backup and recovery of Oracle databases; assisted Linux systems administrator with aspects related to database hosting; contacted vendors and recommended equipment purchases.
- Migrated databases of enterprise to Oracle Real Application Clusters version 10g release 2 to provide high availability and better performance.
- Monitored and tuned systems and databases to optimum levels of performance; performed system upgrades in support of business processing requirements.
- Installed and configured “Big Brother” monitoring system on all production systems, which notified administrators of any issues with email and SMS protocols.
- Assisted developers with writing and tuning SQL queries; performed on-call support and problem resolution 24/7.
0-5 years of experience
Led management and support of Oracle databases on multiple platforms and designed and implemented Production and Development databases.
- Created scripts and scheduled backups in cron for RMAN database backups and recoveries.
- Monitored DR (Data Guard) implementations regarding connectivity issues and “log shipping” to failover site.
- Performed data loads using Data Pump and export/import utility.
- Analyzed database performance utilizing Oracle ADDM, OEM and Ignite.
- Diagnosed and troubleshot database problems such as errors and bugs, performance problems, runaway processes, connectivity problems, poor SQL statements, etc.
0-5 years of experience
Managed technical projects for database upgrades, resource capacity planning, platform migrations, application consolidation, and data center rationalization. Worked with MS Project.
- Responsible for major Oracle database and server consolidation effort comprised of high-end UNIX servers which was completed ahead of schedule and led to 5 million in annual savings
- Transitioned enterprise wide application rationalization and consolidation project to outsourcing service provider (CIO initiative)
- Led strategy efforts that included asset management tracking and total cost of ownership (TCO) analysis
- Managed RMAN backups, conducted performance tuning analysis and modification, and developed standard operating procedures
- Proactively provided technical infrastructure solutions to meet strategic business goals including application integration, database design, system consolidation, and database training
- Administered and supported 200+ global development and production Oracle 8, Oracle 8i, and MS SQL Server databases including Oracle ERP systems
- Provided High Availability (HA) and Disaster Recovery (DR) solutions to maintain business data integrity
- Responsible for implementing and overseeing enterprise database security standards and ensuring compliancy with the corporate IT change management process
0-5 years of experience
Responsible for a dba team for overall availability, reliability and accessibility of Environmental Protection Agency’s several Oracle production servers in Washington D.C and remote Oracle Standby servers in Research Triangle Park in North Carolina
- Proactively assisted developers in maintaining 40 + applications being accessed nationwide by EPA employees and customers.
- Implemented database security using Oracle’s Transparent Data Encryption based on Database Security Technical Implementation Guide (STIG) developed by Defense Information Systems Agency (DISA)
- Maintained Data Guard environment, able to manage many schemas, create DDLs when needed, optimize and develop complex queries and execute weekly deployments to various environments.
- Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
- Designed, developed, tested, deployed and maintained database security and audit solutions
- Took ownership of complex database incidents and problems and provided resolutions in a speedy and timely manner.
- Engaged subject matter experts and information owners to provide assistance to resolve more complex incidents as required.for maximum availability of Oracle applications.
0-5 years of experience
Responsible for development and administration of Oracle systems supporting Beverly facilities.
- Oracle 7.3 Certified DBA
- Designed, maintained and optimized multiple databases in distributed NT environment
- Prepared and implemented backup verification and recovery procedures
- Performed database upgrades
- Created and maintained Oracle Developer client-server applications
- Responsible for system/process analysis
- Provided technical assistance and instruction
0-5 years of experience
Oracle software 9.2.0.1/10.1.0.5/10.2.0.1 installed on Solaris and Redhat Linux platform. Oracle Patches applied. Oracle kernel and init parameters are set as per requirement. Activities supported for 24X7.
- OLTP Oracle databases are monitored using shell scripts and OEM. Automated UNIX shell scripts to load data into Fact and Dimension tables. Logical backups taken for schemas and database using expdump and impdump utility
- Generating data movement code, compiles code, execute the code and troubleshoot data movement problems. Data is loaded into staging tables using flat files. Created and maintained Materialized replication.
- Creating users and granting permissions for OLTP databases. Map flat files, data, and Meta data management
- Created tables, indexes, users and granted permissions.
- UNIX shell scripts are created. Dynamic SQL is used to facilitate the automatic generation and execution of program statements. Statspack are installed and perfstat user is created. Statistics gathered automatically by using DBMS_JOB
- Providing 24X7 Production support
0-5 years of experience
Served as Oracle 8/8i DBA.
- Database project management.
- Loaded data with SQL-loader along with utilizing export/import utilities, set up and managed multi-master replication, monitored database for tracking and predicting problems with the database.
- Tuned database parameters, performed backup/recovery, set up test databases, managed user maintenance/security.
- Developed and Tested SQL & PL/SQL
0-5 years of experience
Managed team of 5 DBAs as Team Leader and Sr. DBA for development and production applications.
- Hands on application architect and DBA
- Designed and implemented company’s highly available and load balanced 14 node Oracle 10g RAC and 40 node web-application farm infrastructure.
- Architect and Technical lead for Disaster Recovery site planning and implementation for the Portal applications.
0-5 years of experience
Perform DBA responsibilities for production, test and development Oracle database systems. All databases reside on Windows 2003 platforms
- Upgraded 9i databases to 10G.The 10g database use SANS technology for datafile storage.
- Applied all databases with the latest patches in accordance with Defense Information Systems Agency (DISA) security regulations
- Successfully completed a database Security Readiness Review (SRR) performed by DISA personnel
- Perform Oracle installations, upgrades and apply oracle quarterly critical patches
- Performance tune databases
- Assist developers in query tuning and problem resolution.
6-10 years of experience
Worked with operations, development and incident management teams to troubleshoot and take pro-active steps to ensure the availability and reliability of deployed software and databases.
- Worked with the internal development team to provide the necessary SQL, PL/SQL and other database management scripts to enhance, tune, optimize and implement database related development activities.
- Installed and supported 2-node 10gR2 and 11gR2 RAC databases, running on Red Hat Linux 5.
- Successfully deployed 3 business critical applications within a month involving database installation, tuning, DBA support, interaction with development, business analysts, consultants, and Oracle support.
- Collaborated with managed service providers, internal development team, consultants and Oracle Support, to plan, optimize, and design database systems and its supporting applications.
- Wrote several scripts (shell, SQL) associated with monitoring, database backups, tuning, and cloning.
- Deployed and implemented Oracle Grid Control (10g, 11g, and 12c) to monitor all databases.
- Tuned and improved daily purge process using partitioning and parallel processing by 400%.
- Contributed to Data Center migration project involving database upgrades; 9i to11g, 10g to 11g.
- Improved code deployment techniques by enhancing shell and SQL scripts and processes.
- Coached DBAs to improve efficiency, quality and productivity whilst working on multiple projects.
6-10 years of experience
Worked with operations, development and incident management teams to troubleshoot and take pro-active steps to ensure the availability and reliability of deployed software and databases.
- Worked with the internal development team to provide the necessary SQL, PL/SQL and other database management scripts to enhance, tune, optimize and implement database related development activities.
- Installed and supported 2-node 10gR2 and 11gR2 RAC databases, running on RedHat Linux 5.
- Successfully deployed 3 business critical applications within a month involving database installation, tuning, DBA support, interaction with development, business analysts, consultants, and Oracle support.
- Collaborated with managed service providers, internal development team, consultants and Oracle Support, to plan, optimize, and design database systems and its supporting applications.
- Wrote several scripts (shell, SQL) associated with monitoring, database backups, tuning, and cloning.
- Deployed and implemented Oracle Grid Control (10g, 11g, and 12c) to monitor all databases.
- Tuned and improved daily purge process using partitioning and parallel processing by 400%.
- Contributed to Data Center migration project involving database upgrades; 9i to11g, 10g to 11g.
- Improved code deployment techniques by enhancing shell and SQL scripts and processes.
- Coached DBAs to improve efficiency, quality and productivity whilst working on multiple projects.
0-5 years of experience
Provide Production Database Support to various client accounts including RAC on windows
- Created and Implemented Oracle RMAN backups
- Performed Network Metrics for Baseline Analysis
- Created Backup and Recovery Manager documentation for New D
- Documented Oracle Database Environment
- Created Oracle DBA Manual for company to manage the databases in their environment.
0-5 years of experience
Performed advance SQL query tuning in Oracle8i data warehouse environments on a rapidly growing AIX platform.
- Responsible for maintaining data integrity, security, rapid updates and queries of sensitive patient medial records.
- Created triggers, stored procedures, materialized views for enhanced remote data replication and synchronization.
- Created new instances and refreshed data to support development efforts.
- Maintained database security via unique database roles and object permissions.
0-5 years of experience
Performed advance SQL query tuning in Oracle8i data warehouse environments on a rapidly growing AIX platform.
- Responsible for maintaining data integrity, security, rapid updates and queries of sensitive patient medial records.
- Created triggers, stored procedures, materialized views for enhanced remote data replication and synchronization.
- Created new instances and refreshed data to support development efforts.
- Maintained database security via unique database roles and object permissions.
0-5 years of experience
- Provided ORC stability and enhanced database operations, reporting and management.
- Successfully trained and mentored junior DBA staff in developing PL/SQL packages to load and transform research data for effective online reporting.
- Developed and managed the IT database/reporting group budget and staffing requirements along with performing annual staff performance reviews.
0-5 years of experience
Contracted to initially install and configure the Oracle Workgroup Server software in a Windows NT 3.51/4.0 environment. Setup multiple databases to support development, web development, and marketing in the NT 3.51 environment and setup a production database in the NT 4.0 environment.
- Lead the collection of data requirements for the Executive Loan System (EXL) and translated those requirements to a logical/physical database design.
- Installed and setup Designer 2000 and its repository, which is to be used to design the EXL Oracle Forms system.
- Assisted in the installation of a purchased marketing system which uses Oracle as its database, and redesigned the underlying database structures for better efficiency.
- Provides general database support, including product install/upgrades, basic backup/recovery, and resolving all Oracle related issues.
0-5 years of experience
Completed migration project of Noble’s Portal, BPEL, Identity Management, Content Management test and production databases on various Red hat Linux servers from Clustered / RAC / ASM to non-RAC/ non-ASM / non-Clustered. This included documenting, testing, and implementing the process in production with limited downtime.
- Provided performance tuning of the FileNet databases which included using OEM to help identify bottlenecks and adding indexes to increase performance on some reports by over 75%.
- Supported various application teams by providing SQL Reports as to eliminate the need to manually use LDAP. Search method of getting Noble’s employee/non-employee groups with credentials. This process changed the retrieval of data from 16 hrs to less than 30 seconds.
- Provided other database support (cloning, scripts) and worked with Oracle as needed.
- Provided database documentation by working to document important functions that several database applications use.
0-5 years of experience
Completed migration project of Noble’s Portal, BPEL, Identity Management, Content Management test and production databases on various Red hat Linux servers from Clustered / RAC / ASM to non-RAC/ non-ASM / non-Clustered. This included documenting, testing, and implementing the process in production with limited downtime.
- Provided performance tuning of the FileNet databases which included using OEM to help identify bottlenecks and adding indexes to increase performance on some reports by over 75%.
- Supported various application teams by providing SQL Reports as to eliminate the need to manually use LDAP. Search method of getting Noble’s employee/non-employee groups with credentials. This process changed the retrieval of data from 16 hrs to less than 30 seconds.
- Provided other database support (cloning, scripts) and worked with Oracle as needed.
- Provided database documentation by working to document important functions that several database applications use.
10+ years of experience
Named as team lead in a 4-person sub DBA group, supporting Verizon’s mission critical repair ticketing system (vRepair, VZOT and CAD). Managed the team to work proactively in identifying and resolving potential database issues before they became business impacting. Worked closely with development team in testing each application release thoroughly and implement the release flawlessly on production environment.
- Performed Oracle RAC/GI, ASM and database installation and deployment in over 30 environments; performed Oracle 10g/11g RAC/database patching and upgrades in over 100 occasions.
- Performed Oracle database performance tuning on numerous company Crisis Management calls, working with dev team in quickly identifying the issue and implement root cause fix or workaround to minimize application down time
- Designed and implemented database backup and recovery strategy for numerous Verizon database applications, utilizing Oracle RMAN and enterprise netbackup. Successfully restored and recovered over 10 corrupted enterprise Oracle databases(due to hardware failure, incorrect user data manipulation or bad data loading) with 0 data loss, thanks to sound Oracle backup design and implementation
- Implemented Oracle physical standby database infrastructure, including Data Guard as well as GoldenGate replication for numerous Oracle applications, providing another layer of stability and availability to customer, in additional to Oracle RAC
- Wrote and implemented numerous Unix shell scripts and SQL scripts to proactively monitor Oracle database health. The scripts will page or email the team, depending on severity, to alert for critical database events. This proactive monitoring helped the team to find out and correct database issues before they became visible to application and customers.
- Attended requirements gathering sessions in new application design or migration projects. Recommended appropriate Oracle high availability and high stability configuration to customers based on their business needs and budget.
0-5 years of experience
Managed databases ranging from a few GB to 650 GB which included OLTP, Data Warehouse, Vantive (7 and 8) and Oracle Applications (10.7, 11i) databases.
- Administered multiple Oracle 7.3, 8.0 and 8i (8.1) databases.
- Performed backup and recovery of OLTP, Data Warehouse, Vantive (7 and 8) and Oracle Applications (10.7, 11i) databases.
- Tasked with startup and shutdown of Oracle Applications processes when needed.
- Utilized various tools and technologies on Sun Sparc 4000 and 6000 Servers.
- Duties included database optimization and performance tuning, developing and implementing backup and recovery procedures, database installation, upgrades and migration, monitoring and maintaining the databases and resolve locking issues.
- Tasks performed using Quest DBA tools (I Watch and Spotlight), SQL-BackTrack, SQL* Plus, Enterprise Manager, Sever Manager, Oracle Performance Pack, EXP, IMP, Developer/2000, RMAN, EBU, Netbackup, Veritas and custom designed scripts written in SQL and PL/SQL for monitoring and optimization.
- Directed DBA team activities and helped mentor junior members.
- Utilized Solaris operating system.
0-5 years of experience
Served as DBA Subject Matter Expert (SME) for Trading Domain databases
- Supported multiple production and pre-prod instances running Oracle 10g and 11g standalone and RAC. Database sizes range from 400GB to 10TB.
- Successfully migrated databases from physical Solaris environments to virtualized Linux environments
- Created project requirements for efforts to be completed by BACS (offshore team).
- Responsibilities also included database security remediation and mentoring of junior level DBAs.
0-5 years of experience
Managed daily support for HR operational mission critical application, including monitoring standby database availability, monitoring replication snapshots performance, maintaining schema referential integrity, and cloning databases.
- Managed HR Data Warehouse application support, including monitoring storage availability, tables’ growth statistics and SQL statements performance, moving production statistics data to testing database, reorganizing table’s partitions.
- Installed and configured a Data Guard standby database for high availability.
- Proficient with multiple backup tools including BMC Sqlbacktrack and Oracle Rman.
6-10 years of experience
Worked with clients and development teams to design, develop, and document database architectures including logical and physical data models, transaction and sizing estimates, capacity planning, fault tolerance and recovery specs, archiving strategies, replication mechanisms and external systems interfaces.
- Developed data migration scripts
- Developed tool to assist developers in data generation and loading
- Supported design and production databases, including On-Call responsibilities
- Mentored developers on PL/SQL and relational database concepts
0-5 years of experience
Senior DBA for RAC 10gR2 Terabyte Production, Dev and Test Database.
- Planned for Storage and forecasting of growth.
- Implemented protection database with backup plan using unix scripts/Rman.
- Managed schemas, objects & Partitioning of the tables & indexes.
- Experienced with the automating of the process of Installation, Deployment and Patching of Oracle binaries and databases.
- Oracle ASM (Automatic Storage Management) installation, configuration & administration.
0-5 years of experience
- Completed Oracle migration from SQL Server to Linux using SQL Developer and Export/Import.
- Performed numerous patches, backups, and SQL coding. Upgraded Oracle 10 to Oracle 11.2.0.3.
- Replicated three RAC nodes: one production system, one logical standby as data warehouse and test system, and one physical standby for disaster recovery and high availability.
- Improved performance with segregated reporting, tuning PL/SQL code, and scheduling changes.
- Migrated data across server platforms with zero downtime: Linux to IBM AIX 7.1.
0-5 years of experience
Provided support to Database system of Feds Markets Group, support systems of Treasury securities trading and Feds open market operations, support cash payment and security lending, overnight repo, discount window between Central Bank and commerical banks, supports accounting and portfolio management activities for accounts held by domestic banks and foreign foreign central banks and international agencies.
- Provided production supports for very high profile Feds Markets Oracle Databases ( Each system has multi-billion dollars transactions per day ). Implement various high availablility technologies including RAC, DataGuard, Veritas Cluster, RMAN, grid control on production and its contingency sites to ensure maximum availability of databases.
- Upgrade Oracle Databases from 9i to 10g. Implemented 10g new features and advanced RMAN backup/recovery features, optimized RMAN backup scripts & process
- Designed database architecture, Data Modeling, performed physical/logical capacity planning, developed SQL scripts and PL/SQL packages / procedures, monitored and tuned application performance.
- Built Feds Treasury securities online trading system in Oracle 9i/10g RAC database. Work with application development teams to roll out new projects deployment from development, QA to production environment.
- In financial crisis, rollout Primary Dealer Credit Facility program (PDCF) and Term Securities Lending Facility (TSLF) application, new loan program offered to primary dealers to promote liquidity in financial market.
- Built VLDBs that contains historical economical data for business report and analysis purpose, created partition and data loading process, tuned application performance.
0-5 years of experience
- Researched IPV4 and IPV6 DNS structures.
- Configured SSL for APEX use using customer network.
- In the Linux environment, developed Master-Detail reports using Oracle 11g R2 APEX (v4.1). Total environment developed in Bash.
- Configured, pulled data and loaded data using IRPT product.
- Using OEM, managed backups (rman) and tablespace (storage) requirements; no ASO.
- Attended several meetings on source/destination mappings, data flows, and how IRPT is utilized.
- Assisted with proofing technical documentation and red-lining docs for punctuation/grammar errors.
0-5 years of experience
Provided primary DBA support for Point-of-Sale, Reporting, QA, Training, Lab and Development databases — Approximately 25 Oracle 8 distributed databases including Oracle Advanced Replication (all on HP-UX 10.2/11.0)
- Built/upgraded application testing environments
- Monitored and tuned databases
- Built databases, performed Oracle installs and migrations (7.2/7.3 to 8.0.5)
- Provided 24×7 DBA support for wireless billing application (Telegence):14 Oracle 8 distributed databases (60Gb – 800Gb each)
- Backup DBA for data warehouse (Oracle 7.3.4 w/Oracle Parallel Server on Pyramid/Siemans RM1000 w/Reliant Unix)
- Coordinated implementation of supplemental database changes for wireless billing application
- Wrote various performance monitoring and operational scripts (SQL, PL/SQL, Perl, Korn Shell)
- Assisted in development of wireless billing application database upgrades
6-10 years of experience
Provide Oracle DBA support to a variety of HP accounts.
- Supported databases on single-server and Real Application Clusters (RAC), using OEM Grid for support.
- Performed Oracle database migration from HP hosted to client hosted data centers.
- Oracle DBA on Security and Compliance Team. Performed security compliance and remediation for over 700 oracle databases (9i, 10g, and 11g).
- Oracle Database Technical Security Standard Subject Matter Expert, in-depth knowledge of security standards for Oracle databases including Sarbanes-Oxley (SOX) requirements.
0-5 years of experience
Reported to Director: Network Security. Direct staff of 1 Junior Oracle DBA, 1 HTML/Web developer.
- Installed and tested Oracle 10g on AIX, Solaris and Windows 2000 server platforms. Tested intranet support on Windows 2000 server before migrating to production at a future date (not yet determined).
- Production support for Oracle 9i instance on IBM AIX (4.3.3) supporting a 2 Terabyte database (including a data warehouse application).
- Develop and support Intranet thin client (Apache) and client-server applications for WCOM/MCI network security group.
- Migrated/upgraded database from V7.3.4 to V8.1.6. Upgraded IBM platform from AIX 4.3.2 on model F50 to AIX 4.3.3 on model S80. Installed and configured 1.2 Terabyte IBM Shark disk array.
- Support multiple authentication methods under Oracle Advanced Security.
0-5 years of experience
Configured a few multi-node 11GR2 RAC cluster Configuration (Grid infrastructure)
- 11GR2 clusterware upgrade from 10GR2.
- Work with an On-call team of oracle DBA’s
- Stood up DR environments on TEST through to Production environment using oracle data guard technology.
- Implemented Streams alternative – log mining from real apply standby database to logminer database and then populates data on warehouse
- Support and implemented standby databases on stand alone and clustered database environments.
0-5 years of experience
Designed and developed Mortgage Intermediary (TPI) application, allowing up to 15,000 mortgage brokers to quote RBS mortgage products online simultaneously.
- ETL for TPI developed and employed using unix arrays and Oracle Index Organized Tables to achieve efficient staged and re runable load process from larger General Mortgage system.
- Performance tuning and 24/7/365 support of 6 x 1Tb Oracle 8.1.7.4.0 GMC mortgage databases hosted on Sun Solaris F15 servers using EMC, SRDF linked SAN environment. Large team of 30 DBAs delivered the Summit General Mortgage Compliance system.
- Management of Design, development and Deployment of Web based mortgage broker database. Defined capacity plan, build documents. Development of schemas, PL/SQL, DDL, shell scripts for database system. ETL feeds from mainframe and main Mortgage 1TB database environment developed. Performance issues for ETL overcome using Index Organized Tables.
- Long running queries and locked objects identified and data/SQL corrected. Many performance bottlenecks resolved through improved stats collection, tuning of SQL joins, improved function usage, tuning Oracle Multi threaded server.
- RMAN implemented for online backups of 1 TB production environments.
- Implementation of 9i RAC database environment hosted on Sun Solaris environment. Problems with node failover resolved.
- Design and installation of 10G RAC database environment with Dataguard hosted on Sun Solaris environment for GMC mortgage.
0-5 years of experience
Create and support multiple Oracle 8i database instances for 11i Financials and OFSA.
- Refresh QA databases from production backup files.
- Optimize rollback segments, archive log files and rebuild indexes.
- Monitor database performance using Oracle Alert, DB Artisan, OEM and UNIX scripts.
- Perform Schema data migration using import/export and storage space management.
- Perform daily hot backup of data files and archive files. Recover database or table data.
- Apply Oracle Financials patches. Write PL/SQL procedures and triggers.
0-5 years of experience
Provide database and system management for multiple HP-UX/NT servers running Oracle 9i RAC and Oracle Advanced Replication, and several Oracle 8i databases ranging in size from 500Gb to 1.5Tb+.
- Installation, upgrades, migrations, performance tuning, backup and recovery, schema management, SQL tuning, proactive monitoring and troubleshooting Oracle databases in a 7×24 environment.
- Primary DBA support for HP’s primary E-commerce site, several related customer facing OLTP and data warehouse systems. Databases were responsible for single sign on and profile information to over 3000 internal HP websites.
- Provide engineering, implementation, strategy and support plans to development teams for database related issues, including designing HA and redundant database systems and implementing advanced Oracle options for mission critical environments.
- Designed, implemented and supported highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.
- Provided Oracle RAC consulting and engineering to internal HP-IT organizations for planned implementations and migrations. Consulting included designing backup solutions (using RMAN), disaster recovery plans, and performance tuning advice for RAC implementations.
- Design, implement and support Oracle advanced replication and Oracle streams to provide a replicated database environment to support internal HP business sites.
6-10 years of experience
- As a Senior Oracle Database Administrator and Applications System Administrator upgraded the E-Business Suite 11.5.10.2 to 12.1.4. Supported the E-Business Suite 11.5.10.2 and 12.1.4 on production, testing, and development servers. Applied applications and database patches. Configured Parallel Concurrent Processing. Migrated and tuned Oracle databases. Cloned Oracle Applications. Resized database files to decrease cloning, backup, and restoring time. Implemented logical and physical database design.
- Supported the Deliberate Crisis Action Planning and Execution System (DCAPES) for the U.S. Department of Defense (DoD) Air Force (USAF) as a Senior Database Management Specialist. Monitored Oracle 11g DCAPES databases, resized database files to decrease significantly backup and restoring time of the databases. Developed packages to archive and delete the DCAPES data. Used Oracle Streams Advanced Queuing (AQ) as mechanism to transmit data from the database to the application server.
- As a Senior Oracle Application DBA at the U.S. Department of Homeland Security analyzed the Oracle 10g R2 database, performance, and referential integrity of the existing system on Unix platform. Migrated data from Oracle 10g R2 database on UNIX to Oracle 11g on a Linux platform. Developed Oracle triggers, functions, and procedures on Oracle 11g. Implemented security of a new system using the Oracle 11g auditing capability.
- Supported the Defense Agencies Initiative (DAI) project for the U.S. Department of Defense (DoD) Business Transformation Agency (BTA) as a Senior Oracle Database Administrator and Applications System Administrator of the E-Business Suite 11.5.10.2. Installed, upgraded, and migrated EBS 11.5.10.2 on Unix OS for production, testing, and development servers. Upgraded Oracle engines; migrated and tuned Oracle databases. Cloned Oracle Applications. Implemented logical and physical database design. Configured Parallel Concurrent Processing. Applied many patches to DAI instances, including such complicated ones, like HR Legislative Data Load, Diagnostics Tools, and HRMS Family Pack K Rollup
- Installed and supported the Oracle Business Intelligence EE (OBIEE) on Linux and Windows servers; adjustment development repository of OBIEE to configuration and production environments.
- Installed and upgraded the Oracle Service Oriented Architecture (SOA) Suite; monitored and supported SOA.
- Installed the Oracle Governance, Risk, and Compliance Manager (GRCM) with Content Server on Windows platform.
0-5 years of experience
Tuning & Maintaining SAP R/3, Oracle Financials (Three Tier Application), Tivoli, Remedy applications with Oracle as Database Engine.
- Built Warehouse Database/DataMart Model with Erwin 3.0 based on star schema
- Helped in upgrading PeopleSoft (HR) 5.0 to 7.0.
- Tuning, Backup and Restore of Databases
- Conversion from 7.x to 8.0
- Tuning Lawson Financials, upgraded Oracle versions for Lawson, sorted application problems
0-5 years of experience
Oracle DBA Team Lead in implementing and administering financial, Risk, DW and OIM databases.
- Configure and administer multiple Maximum & High Availability 11g RAC database architecture comprising 2, 3 and 6 Linux nodes and standby DR RAC using Data Guard.
- Configure 10g Oracle Grid with custom monitoring metrics for all servers and databases.
- Design, configure and implement backup & recovery strategies using RMAN, ASM, and OMF to backup large financial OLTP and DSS (Data mart and Data Warehouse) multi-terabyte databases.
- Configure Hitachi ShadowImage for cloning production databases and install and configure Oracle Golden Gate for replication.
- Perform database tuning by reviewing AWR & ADDM reports, implementing SQL profiles and baselines, designing table and index partitioning and coalescing of database objects for faster query performance.
0-5 years of experience
As a Senior Oracle DBA responsible for all backend architecture including database creations, patching, monitor, maintenance and support of large databases for pharma clients
- Worked extensively in maintenance, support and new database creation and data migrations using shell/perl scripts, exp/imp, SQL*loader, replication. Implement PL/SQL application.
- Use OEM for DBA work including SQL/XML tuning and database performance tuning with statspack, glance. Supported Weblogic Webserver and application server on Linux/Unix environment.
- Use TOAD/ Erwin CASE tools for database design work. Developed standard operating Procedure docs for implementation of daily activities on Unix servers. Used Informatica for ETL processes.
- Guide and direct off-shore technical team and provide backend database and server support and troubleshooting database and application issues. Setup backup/recovery with RMAN
- Worked on 9i/10g databases , application migration. Worked with 10g RAC install on Linux in dev/test.
- Setup backup/recovery. Responsible for applying all server side database patch sets.
- Setup Backup and recovery and coordinate with system admin team. Maintained release control.
- Used Oracle Warehouse builder to refresh target reporting database from Production environment.
- Created training documentations with all detail database tasks for database off-shore support teams.
6-10 years of experience
Support current CBS main business units running on Oracle Financials 11.5.10.2 & 12.1.3 Business units include: CBS Network, CBS TV & Radio, CBS Outdoors and Paramount Studios.
- In charge of cloning, patching, performance, and security patches.
- Perform System Administrator (SYSADMIN) duties on the application side.
- Installed and implemented OEM 11GR1/AMP 4.0 for the E-Business Suite.
- Installed and configured OEM12c for non-ERP Oracle databases.
- Charge of maintaining the Data Ware House and application for Simon & Schuster Publications.
- Supporting the transactional system for daily operations for Showtime Cable – Vendor Sintec/Pilat Media.
- Part of the 24×7 on-call monthly schedule for Oracle DBA support.
0-5 years of experience
One of a small team of Oracle DBAs handling 14 Oracle databases on Linux, on RAC and standalone configurations, as well as Grid Control and RMAN catalog repository
- This includes all of the Ingram Content “iPage” Oracle Text searches, Sterling EDI transaction system, Oracle Financials, VoiceCollect application, and TIBCO.
- Migrated all Oracle monitoring and cron jobs to Grid Control (OEM) without issues
- Expert in troubleshooting and refinement of shell and SQL/PLSQL scripts
- Primary Oracle DBA on RMAN configurations and setup
- Managed IBM InfoSphere (and old DataJoiner) Replication server on DB2 Linux and Windows for replication processes between DB2/UDB, MS-SQL, and Oracle databases
- Handled Ingram’s Disaster Recovery for Oracle Databases
0-5 years of experience
Supported BPA Critical Business Systems database systems.
- Databases included Oracle, SQL Server, Postgres and Sybase.
- Operating systems included Redhat Linux and Windows 2005.
- Installed Oracle 11gR2 on new windows servers for upgrading of existing Oracle 10.2 databases.
- Installed Oracle Grid control for new environment.
- Worked on call every 5 weeks supporting all CBS databases.
0-5 years of experience
Production support for both ORACLE and Sybase
- Utilized Control-M to monitor ORACLE and Sybase backups in a NetBackup/SQLBackTrack environment
- Resolved backup failure issues as well as Sybase and ORACLE database issues
- Provided support for advanced replication in both environments
- Conducted ORACLE performance tuning to include memory, I/O, contention, and SQL statements
- Perform ORACLE installs, upgrades, and patches
- Monitor database performance
- Mentored SYBASE DBAs in ORACLE database administration
6-10 years of experience
Managing custom healthcare web application projects from start to finish. Assisting clients in the selection, design, development, implementation, and support of application customized and packaged solutions.
- Management for in house application, Electronic Public Health Records System.
- Experienced in guiding project teams within HIPAA regulations and the transmission of sensitive data as well as SNOMED RT, SNOMED CT, LOINC, ICD 9, and ICD 10 codes.
- Managed web app project for reporting Communicable Diseases to CDC from hospitals and health departments.
- Database Administration of Oracle 8i, 9i, 10g, and 11i, SQL Server 6.5, 7, and 2000 databases. Application Server Administration of Oracle OAS, 9i and 10g.
0-5 years of experience
- Support production and test Oracle 10g databases in HP-UX based RAC utilizing ASM disk groups and non RAC environments.
- Apply mandatory critical patches to Oracle database systems.
- Install Oracle and Oracle components, such as Oracle Warehouse Builder.
- Perform media recovery from RMAN backups as required by circumstances.
- Export and Import schemas and tables as required for recovery, cloning or refreshing of Test or Development from Production.
0-5 years of experience
- Implemented Oracle Purchasing, Archiving and Purging
- Logical Volumes layouts, Disk layouts and Capacity planning
- Oracle E-Business Suite 11i and Peoplesoft database Cloning, Patching, Upgrades and troubleshooting, Performance Tuning, Space Management, Security, Reorganization
- Workflow configurations, Concurrent manager configuration and troubleshooting
- Backup and recovery of Databases using RMAN, SQL Backtrack and manual scripts
- Disaster Recovery using BCV ( EMC ) Process
Data Systems Administration Cover Letter Examples
Rate This Article
[Senior Oracle Dba]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
