Senior Oracle DBA Resume Samples

Description :

1. Create and configure data security realm, configure rule sets, and secure application roles with database vault, and audit the data changes for enterprise databases.
2. Provided Oracle DBA supports for company mission-critical OLTP database including production database backup restore/refresh, troubleshooting, run time event investigation.
3. Provided on-call support for mission-critical production databases including database performance monitoring, application-related run-time monitoring.
4. Provided daily backup and recovery services and data pump for company production databases and customer databases.
5. Worked on the implementation of partitioning for PeopleSoft tables had various extensive testing for different partitions.
6. Provided Oracle security Mechanism to enterprise databases including Oracle VPD, database TDE, Database Vault including install, configuration, and administration.
7. Performed Hot/Cold backup Clone from production to staging, moved production databases from one server to another.

Experience

0-2 Years

Level

Entry Level

Education

ME

Description :

1. Worked with operations, development, and incident management teams to troubleshoot to ensure the availability and reliability of deployed software and databases.
2. Worked with the internal development team to provide the necessary SQL, PL/SQL, and other database management scripts to enhance, tune, related development activities.
3. Working with management, developers and end-users participated in the design and implementation of databases to support the commercial side of the business.
4. Implemented test databases to support concurrent development of the s Barge Tracking III system.
5. Installation, tuning, DBA support, interaction with development, business analysts, consultants, and Oracle support.
6. Collaborated with managed service providers, internal development teams, consultants and Oracle Support,  and design database systems and its supporting applications.
7. Wrote several scripts associated with monitoring, database backups, tuning, and cloning.

Experience

5-7 Years

Level

Executive

Education

MBA

Description :

1. Working with management, developers and end-users participated in the design and implementation of databases to support the commercial side of the business.
2. Implemented and enforced a set of procedures to facilitate and control releases of new database objects and code into test and production databases.
3. Communication more problems were detected prior to production releases and fewer bugs were encountered after implementation.
4. Provided mentoring and coaching to the development staff on an ongoing basis and write better queries system response time improved as did the load on the databases.
5. Constant monitoring of the functionality of the environment to provide seamless availability of the systems and databases.
6. Testing database support for the production databases was enhanced, configuration issues were eliminated and response to problems and customer requests were improved.
7. Monitored production, test, and development database for performance-enhancing opportunities.

Experience

2-5 Years

Level

Junior

Education

BCA

Description :

1. Administrate all Oracle database platforms, installations, management procedures, database backups/recovery, database security, and performance monitoring procedures.
2. Responsible for integration of IQ Solutions Order and disparate sources into a centralized information repository on a large government agency contract.
3. Successfully designed a database to handle the orders and information transaction, warehouse inventory tracking, warehouse item location and receiving, etc.
4. Plan and install oracle databases in the development, test, and production of UNIX environments.
5. Plan, design, and implementation of database backup and recovery system for our oracle database.
6. Successfully migrated data from several SQL Server databases to the oracle database by using PL/SQL, SQL.
7. Developed the interface between the shipping system and the Oracle database.

Experience

10+ Years

Level

Senior

Education

Certification

Description :

1. Performed DBA daily/routine tasks on administration Oracle environments for capacity planning,  securing, troubleshooting, performance tuning, and developer support.
2. Plan and install oracle databases in the development, test, and production of UNIX environments.
3. Provided updates of the installation guide to the team document of the "Oracle DB installation manual."
4. Performed database backup; cloned and refreshed production databases to other environments.
5. Wrote the As-Built document of installation/configuration Oracle Express Edition on the Linux.
6. Participated in peer reviewer for team document review and developer code review.
7. Maintained database access security, networking all the database servers into respective departments using Oracle Name Server.

Experience

7-10 Years

Level

Management

Education

CS

Description :

1. Responsible for database availability, gathering trend analysis, database performance statistics on intervals and providing feedback to the relevant test and development teams.
2. Provided updates of the installation guide to the team document of the "Oracle DB installation manual."
3. Performed database backup, cloned and refreshed production databases to other environments
4. Maintained the process populating the data warehouse with transaction data on a continuous basis.
5. Worked with developers in writing efficient database SQL and PLSQL code to make use of Oracle's best practices without compromising accuracy.
6. Maintained database access security, networking all the database servers into respective departments using Oracle Name Server.
7. Worked with the test team to prepare functional and performance test strategies and indicators;

Experience

7-10 Years

Level

Management

Education

MIS

Description :

1. Managed the databases and new functionality planning for the Laboratory Information Management Systems.
2. Implemented a new backup/recovery system and automated various system monitoring tasks including space management and error log monitoring and archival.
3. Assisted with database related aspects of the deployment of a new online time card system and a new Plant and Facilities Maintenance Planning and tracking System.
4. Customized Oracle Forms and Reports based Financial and Materials Management System originally purchased.
5. Participated in peer reviewer for team document review and developer code review.
6. Maintained database access security, networking all the database servers into respective departments using Oracle Name Server.
7. Loaded data from flat files to oracle databases and migrated from older oracle versions.

Experience

5-7 Years

Level

Executive

Education

DO

Description :

1. Provide on-call support for production database environments to ensure the highest level of availability.
2. Maintain Development, Test and QA environments and test application release upgrades and database patch releases on a monthly schedule or as required.
3. Monitor RDBMS and examine performance bottlenecks and take corrective measures to maximize performance.
4. Assisted with database related aspects of the deployment of a new online time card system and a new Plant and Facilities Maintenance Planning and tracking System.
5. Customized Oracle Forms and Reports based Financial and Materials Management System originally purchased.
6. Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
7. Performed database tuning at all levels by optimizing server, storage, database, and SQL.

Experience

7-10 Years

Level

Management

Education

BS

Description :

1. Perform daily database administration tasks like user management, space monitoring and management, performance monitoring and tuning.
2. Test and implement Oracle security patches and monitor and optimize the performance of the database.
3. Implements and enforces security for all of the Oracle Databases using roles and privileges.
4. Perform database analysis and setup database maintenance, monitoring scripts and implement backups.
5. Write SQL/Unix Shell Scripts for database/Application monitoring and to automate routine tasks like Table Partition maintenance, Tablespace space Usage, etc.
6. Troubleshooting, analyzing reports/explain plan/SQL Trace for performance analysis.
7. Monitor RDBMS and examine performance bottlenecks and take corrective measures to maximize performance.

Experience

2-5 Years

Level

Junior

Education

BE

Description :

1. Perform backup and recovery, performance tuning and monitoring using enterprise manager.
2. Implements and enforces security for all of the Oracle Databases using roles and privileges.
3. Perform database analysis and setup database maintenance, monitoring scripts and implement backups.
4. Write SQL/Unix Shell Scripts for database/Application monitoring and to automate routine tasks like Table Partition maintenance, Tablespace space Usage, etc.
5. Maintain partitioned tables, including adding new partitions, exchanging partitions, archiving partitions, and dropping or truncating partitions.
6. Manage database environment where materialized views are used on a reporting server to generate reports and to shift the load off the production server.
7. Test and implement Oracle security patches and monitor and optimize the performance of the database.

Experience

10+ Years

Level

Senior

Education

MS

Description :

1. Configured with Veritas clustering in an active/active configuration and built out an environment where the servers maintain separate versions of Oracle.
2. File systems are configured to allow each database the ability to failover individually with their own set of binaries and file systems.
3. It provides a shared environment minimizing the cost to clients and providing independence across the application.
4. Manage database environment where materialized views are used on a reporting server to generate reports and to shift the load off the production server.
5. Review performance metrics, identify performance bottlenecks and recommend changes to resolve.
6. Support activities include performance tuning exercises, backup, and recovery, patching, replication, and disaster recovery, scripting, data loading
7. Implemented partitioned tables and indexes including PL/SQL programs to age data off and prepare for new data to be loaded.

Experience

7-10 Years

Level

Management

Education

Associates

Description :

1. Structure and restructure the database as necessary to meet business objectives for performance and availability.
2. Review performance metrics, identify performance bottlenecks and recommend changes to resolve.
3. Manage database environment where materialized views are used on a reporting server to generate reports and to shift the load off the production server.
   
4. Review performance metrics, identify performance bottlenecks and recommend changes to resolve.
5. Review and implement security measures for Oracle database auditing, password management,  and data encryption using Transparent Data Encryption.
6. Review backup and recovery procedures, recommend changes and document various recovery scenarios.
7. Rebuild the QA and Test Databases to restructure the schemas and storage and develop and document strategy for monitoring and maintaining the databases.

Experience

7-10 Years

Level

Management

Education

BE