Oracle PL/SQL developer resume sample
Key oracle pl/sql developer resume points, tips to make your oracle pl/sql developer resume outstanding, oracle developer cv example, pl/sql developer resume example, get a resume template for oracle pl/sql developers, apply for remote oracle developer jobs at epam anywhere.
![oracle sample resume for 3 years experience hands holding a sheet of paper with an icon, on a purple background](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltd799b6154b37c6cb/6475b6c6d668f87bf9d7d4d2/Oracle_developer_resume_XL.jpg?format=webply&quality=1)
As Chief Editor, Darya works with our top technical and career experts at EPAM Anywhere to share their insights with our global audience. With 12+ years in digital communications, she’s happy to help job seekers make the best of remote work opportunities and build a fulfilling career in tech.
![oracle sample resume for 3 years experience free_CV_template_side_banner.png](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt091fa23c9059be01/6407160474527c102927a7fa/free_CV_template_side_banner.png?format=webply&quality=1)
Looking to land your dream job as an Oracle PL/SQL developer? Crafting an impressive Oracle PL/SQL developer resume is the key to opening doors to exciting career opportunities.
In this article, we will guide you on how to create an outstanding Oracle PL/SQL developer resume that effectively showcase s your skills and expertise in Oracle PL/SQL development. From highlighting your relevant experience to emphasizing your technical prowess, we will provide valuable insights and tips to optimize your resume. Get ready to stand out from the competition and increase your chances of securing your desired SQL developer salary with your new job.
Here are some key SQL resume points that can help you create an impressive resume for your desired job.
![](http://nandemo.space/777/templates/cheerup1/res/banner1.gif)
Oracle PL/SQL developer resume headline and summary
The headline and summary section of your Oracle developer CV plays a crucial role in grabbing the attention of hiring managers. This is the first impression they have of your skills and qualifications, so be sure to craft a concise and impactful headline highlighting your expertise as an Oracle PL/SQL developer — for example, "Experienced Oracle PL/SQL Developer with Strong Database Management Skills."
In your resume summary, briefly create an overview of your professional experience and key qualifications. Mention the number of years of experience you have in SQL programming and Oracle PL/SQL development in particular, and highlight any of your notable achievements in the field. Use action words to showcase your proficiency in database management, query optimization, and data modeling.
Skills to put in a resume for a PL/SQL developer
When creating a resume for a PL/SQL developer position, it's essential to include relevant skills that demonstrate your expertise in Oracle database development. Here are some key skills to consider:
- Oracle PL/SQL: Showcase your proficiency in writing complex queries, PL/SQL stored procedures, PL/SQL packages, functions, and triggers, and managing Oracle reports.
- Database management: Highlight your ability to design, implement, and optimize relational database structures, create database objects, and in data loading and ensuring data integrity and performance.
- Query optimization: Emphasize your expertise in optimizing SQL queries and writing SQL scripts to enhance database performance and efficiency.
- Data modeling: Demonstrate your skills in creating data models to support application development and database design.
- Performance tuning: Highlight your experience in identifying and resolving performance issues, such as indexing, partitioning, and caching strategies.
- Debugging and troubleshooting: Showcase your ability to identify and resolve errors and issues in the PL/SQL back-end and database processes.
- Version control: Mention your familiarity with version control systems like Git or SVN for managing database scripts and changes.
Including these skills in your resume will help the hiring managers assess your proficiency as an Oracle PL/SQL developer and understand your suitability for the role during the software developer interview .
Your Oracle PL/SQL developer roles and responsibilities
This section outlines your specific roles and responsibilities as an Oracle PL/SQL developer. Provide a comprehensive overview of the projects you have worked on and the tasks you have undertaken. Some key responsibilities to include are:
- Designing and implementing database structures, including tables, indexes, and views
- Developing and optimizing PL/SQL code for data manipulation, validation, and reporting
- Collaborating with cross-functional development teams to gather business requirements and translate them into efficient business intelligence solutions
- Performance tuning and query optimization to enhance database performance
- Troubleshooting and resolving database-related issues and errors
- Conducting unit testing and debugging to ensure the functionality and accuracy of PL/SQL code
- Participating in database design reviews and providing recommendations for enhancements
- Documenting technical specifications, data models, and processes
Highlighting your roles and responsibilities will give hiring managers a clear understanding of your contributions as an Oracle PL/SQL developer and your ability to handle diverse tasks effectively.
![oracle sample resume for 3 years experience SQL_resume_preview.jpg](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltab652757729ae4a7/646db5ead152f8e563429e3a/SQL_resume_preview.jpg)
Read full story
Crafting an outstanding Oracle PL/SQL developer resume requires careful attention to detail and a strategic approach. Follow these tips to ensure your resume stands out from the competition.
Show your problem-solving abilities
Oracle PL/SQL developers are expected to possess strong problem-solving and analytical skills. Highlight specific examples of how you have tackled complex challenges and provided innovative solutions. Whether optimizing a database query or troubleshooting a performance issue, demonstrating your problem-solving abilities will impress hiring managers.
Keep your Oracle resume concise and easy to read
Recruiters and hiring managers often spend only a few seconds scanning a resume. Ensure that your PL SQL developer resume is visually appealing and easy to read. Use bullet points to organize information, and keep paragraphs short and concise. Use a professional font and maintain consistent formatting throughout the document. You can use popular resume builders to help you format your CV, or scroll down for some real PL/SQL sample resumes and format yours likewise.
Use keywords from the job description
Many companies use applicant tracking systems (ATS) to scan resumes for specific keywords. Tailor your resume to include relevant keywords from the job description. This increases your chances of getting past the initial screening process and being considered for an interview. Incorporate keywords such as Oracle PL/SQL, database management, query optimization, software development life cycle (SDLC), and any other specific skills mentioned in the job posting.
Include relevant technologies and tools
Mention the technologies and tools you have experience with that are relevant to Oracle PL/SQL development. This could include Oracle Database, SQL Developer, TOAD, and other software tools commonly used in Oracle environments. Highlighting your familiarity with these tools showcases your technical expertise and increases your appeal as a candidate.
Highlight relevant projects
If you have worked on any notable Oracle PL/SQL projects, make sure to showcase them in your resume. Provide a brief description of each project, outlining your role and responsibilities, the problem you solved, and the outcome or impact of your work. This demonstrates your practical experience and gives employers an insight into your abilities.
Attach a cover letter
A well-written cover letter complements your resume and allows you to express your passion and interest in the role. Customize your cover letter to align with the specific job requirements and company culture. Highlight your relevant experience, skills, and achievements and explain why you are the ideal candidate for the position.
By incorporating these tips into your Oracle PL/SQL resume, you can effectively showcase your developer skills, expertise, and suitability for the position. Remember to customize your resume for each job application, tailoring it to match the specific requirements of the role. With a standout resume, you'll be one step closer to landing your desired Oracle PL/SQL developer position.
![oracle sample resume for 3 years experience Data_engineer_resume_preview.jpg](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt38af6e9227eed67b/6433b5eed79cb6107ab1b222/Data_engineer_resume_preview.jpg)
This PL/SQL developer resume sample provides an impactful and comprehensive Oracle developer CV example. It showcases the candidate's extensive experience in IT, including leadership roles and proficiency in Oracle technologies. The resume emphasizes technical skills, such as data integration and database management, along with important interpersonal skills like communication and teamwork. With a concise project description in the work experience section, this sample resume demonstrates the candidate's problem-solving abilities and past contributions. It serves as a valuable resource for Oracle developers aiming to create a standout resume in a competitive job market.
Oracle Developer Financial Services 6-8 members
Oracle RDBMS Oracle SQL Developer, Tortoise SVN, Jenkins, Jira, Maven PL/SQL
Master in Computer Sciences, Electronics, and Electrical Engineering, 2007
Oracle OCA Certification
English C1 Hungarian Native |
![oracle sample resume for 3 years experience big_data_developer_resume_preview.jpg](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt2d0aefea85e83fbd/644a1da4cdd29b4b852cd386/big_data_developer_resume_preview.jpg)
This PL/SQL sample resume provides job seekers with a clear and effective example to guide them in crafting their resumes. This sample showcases the candidate's solid experience in Oracle SQL and PL/SQL and proficiency in other technologies like UNIX shell scripting, Python, Docker, and Kubernetes. It emphasizes their technical skills in database architecture, data modeling, and cloud technologies. The work experience section highlights their involvement in designing and developing self-service portals, implementing solutions for test data issues, and conducting proof-of-concept projects on real-time data processing and workflow orchestration. This sample resume aims to assist Oracle developers in creating a compelling resume that effectively demonstrates their expertise and increases their chances of landing their desired roles.
Database Solutions Architect Business Information and Media 5-7 members
Oracle Python, Apache Kafka, Oracle, Docker, MySQL, GenRocket, StreamSets, Apache Nifi.
Masters in Intelligence Systems of Decision Making, 2007
Docker-Certified Associate (DCA) Certified Kubernetes Application Developer (CKAD) OCP Advanced PL/SQL
English C1 Spanish Native |
![oracle sample resume for 3 years experience web_developer_resume_preview.jpg](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltd53ba13780b28120/655dee6ae41dd0040a634434/web_developer_resume_preview.jpg)
Looking for a professional resume template to elevate your job application? Download our Oracle PL/SQL developer resume template now and get one step closer to your dream job.
![oracle sample resume for 3 years experience free_CV_template_main_banner.jpg](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt02218b0e72d09a3c/64071604bd118e121669f4ed/free_CV_template_main_banner.jpg?format=webply&quality=1)
Are you an experienced Oracle developer seeking remote job opportunities? Look no further! EPAM Anywhere is thrilled to link you up with our remote Oracle developer jobs . Join us and take advantage of the flexibility to work remotely full-time and enjoy continuous career growth.
Explore our Editorial Policy to learn more about our standards for content creation.
![oracle sample resume for 3 years experience SQL portfolio projects for all levels](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt0c421543c068d4af/657afb948bfa48040a019646/SQL_portfolio_projects_preview.jpg)
SQL portfolio projects for all levels
![oracle sample resume for 3 years experience 20 SQL interview questions and answers](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt70e5b7b63e641b83/64b7c74c6d9d0a1df676b5b6/SQL_interview_questions_preview.jpg)
20 SQL interview questions and answers
![oracle sample resume for 3 years experience SQL developer resume example](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltab652757729ae4a7/646db5ead152f8e563429e3a/SQL_resume_preview.jpg)
SQL developer resume example
![oracle sample resume for 3 years experience web developer cover letter examples](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt041d9716e7a52788/62e272eb82c1fc5c9715c230/web_developer_cover_letter.jpg)
web developer cover letter examples
![oracle sample resume for 3 years experience 11 remote interview tips for tech job seekers](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blte0286dffa9a5fe1e/636c9e32cf4d0c0ef2847734/remote_interview_tips_preview.jpg)
11 remote interview tips for tech job seekers
![oracle sample resume for 3 years experience how to write your best QA engineer cover letter](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt3e4d12042c0a01ac/62e8f9f4e49d4a6983cc4061/QA_engineer_cover_letter_preview.jpg)
how to write your best QA engineer cover letter
![oracle sample resume for 3 years experience front end developer cover letter examples](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt361282c2c270a933/62e2728a48cc366ab5408b96/front_end_developer_cover_letter.jpg)
front end developer cover letter examples
![oracle sample resume for 3 years experience new job anxiety: 5 tips to boost your confidence](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt5b3fc0d5f794c2af/62e235d36b0f32698945f373/New_job_anxiety.jpg)
new job anxiety: 5 tips to boost your confidence
![oracle sample resume for 3 years experience how to become a senior software engineer: a guide](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltfdca2c0024c4fdd7/662f4f33736efca77a860319/how_to_become_a_senior_software_engineer_preview.jpg)
how to become a senior software engineer: a guide
![oracle sample resume for 3 years experience creative Salesforce portfolio project ideas](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt4f148b05a2c1448e/662b66d7acc83c25f856d179/Salesforce_portfolio_project_examples_preview.jpg)
creative Salesforce portfolio project ideas
![oracle sample resume for 3 years experience rebase vs. merge: a comprehensive guide](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt280adc8450327d92/662a5c61736efc9c4a85ff96/Git_merge_vs_rebase_preview.jpg)
rebase vs. merge: a comprehensive guide
![oracle sample resume for 3 years experience the future of Agile: what to expect in 2024 and beyond](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt01cbb9b26eb7dea4/662a05c5857d564bd8f90e76/Agile_trends_preview.jpg)
the future of Agile: what to expect in 2024 and beyond
![oracle sample resume for 3 years experience best React projects for a portfolio: from ideas to standout examples](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltaf1ff1fa6a153f33/6628b18ee9a4eebd8d1b8817/React_projects_for_portfolio_preview.jpg)
best React projects for a portfolio: from ideas to standout examples
![oracle sample resume for 3 years experience Z-test vs T-test: the differences and when to use each](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/bltc6d345fdfc235cd5/662781e6acc83c4e4856d062/Z-test_vs_T-test_preview.jpg)
Z-test vs T-test: the differences and when to use each
![oracle sample resume for 3 years experience Ruby on Rails interview questions](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt7723f6c389fb0d33/6626287cbf2c95904c224022/Ruby_on_Rails_interview_questions_preview.jpg)
Ruby on Rails interview questions
![oracle sample resume for 3 years experience data scientist interview questions and answers](https://eu-images.contentstack.com/v3/assets/blt892f41c9788ae399/blt65e66877446ce569/6617a883b0ecdb8f63b7572b/preview_data_scientist_interview_questions.jpg)
data scientist interview questions and answers
- Resume Builder
- Resume Templates
- Resume Formats
- Resume Examples
- Cover Letter Builder
- Cover Letter Templates
- Cover Letter Formats
- Cover Letter Examples
- Career Advice
- Interview Questions
- Resume Skills
- Resume Objectives
- Job Description
- Job Responsibilities
- FAQ’s
ORACLE Developer Resume Examples
Writing a strong resume as an Oracle developer is essential for gaining the attention of potential employers. Knowing what to include and how to format it can be a challenge. This guide will cover the basics of writing a successful Oracle developer resume, including what to include, what to highlight, and examples that you can follow. With the right information and an eye for detail, you can create a resume that is sure to catch the attention of potential employers.
If you didn’t find what you were looking for, be sure to check out our complete library of resume examples .
![oracle sample resume for 3 years experience resume-template-sample](https://maxresumes.com/wp-content/uploads/2022/12/resume-template-sample.png)
Start building your dream career today!
Create your professional resume in just 5 minutes with our easy-to-use resume builder!
ORACLE Developer
123 Main Street | Anytown, USA 99999 | Phone: (123) 456-7890 | Email: [email protected]
A highly- skilled Oracle developer with experience in Oracle databases, PL/SQL programming, development and implementation of databases, and application development. Possesses a passion for problem- solving and innovative approaches to software solutions. Adept at working on tight deadlines and adjusting to changing requirements.
Core Skills :
- Oracle Databases (11g & 12c)
- PL/SQL Programming
- Database Design
- Database Administration
- Software Development
- Application Development
- Troubleshooting & Debugging
- Database Performance Tuning
Professional Experience :
- Developed and implemented several Oracle databases for clients across multiple industries.
- Designed databases according to customer requirements and constructed database objects like tables and views
- Wrote and debugged stored procedures, functions and packages in PL/SQL
- Developed applications in JAVA, .NET and Oracle Forms
- Developed and implemented various database solutions and software solutions.
- Improved database performance and troubleshot database- related issues.
- Developed test plans and run unit tests on database objects to ensure quality.
Education :
- Bachelor of Science in Computer Science, University of California, Berkeley, CA (2019)
Create My Resume
Build a professional resume in just minutes for free.
ORACLE Developer Resume with No Experience
Recent college graduate with a Bachelor’s degree in Computer Science and a solid understanding of Oracle database concepts. Seeking an Oracle Developer position to learn and develop my skills.
- Experience with Oracle databases and SQL
- Knowledge of database design, development and management
- Proficient in troubleshooting and resolving database issues
- Strong communication and problem- solving skills
- Ability to work independently and in teams
- Familiarity with basic software development principles
Responsibilities
- Develop and maintain applications with Oracle databases
- Create, review and modify database structures
- Monitor database performance and troubleshoot any issues
- Ensure security by creating and maintaining user accounts
- Perform data backup and recovery operations
- Create and execute test plans to ensure quality control
- Implement and document database changes to ensure data integrity
Experience 0 Years
Level Junior
Education Bachelor’s
ORACLE Developer Resume with 2 Years of Experience
I am an Oracle Developer with over two years of professional experience. My experience has included roles in development and database engineering. I have expertise in PL/SQL and have also utilized Oracle Forms and Reports. I am knowledgeable in database structures, as well as database replication, patching, and tuning. My strong problem- solving skills, technical knowledge, and programming experience enable me to develop tailored solutions to complex issues.
- Oracle Forms and Reports
- Database Structures
- Database Replication
- Database Patching
- Database Tuning
Responsibilities :
- Analyzed and designed database architecture for new applications and identify areas of improvement for existing database systems
- Developed and tested database applications using PL/SQL, Oracle Forms and Reports and other database tools
- Designed, implemented and maintained database objects including tables, views, packages and stored procedures
- Performed database administration tasks including setting up users, managing privileges, and monitoring database performance
- Provided technical support to teams and coordinated with other departments to ensure the smooth functioning of databases
- Monitored database replication and ensured data integrity and accuracy
Experience 2+ Years
ORACLE Developer Resume with 5 Years of Experience
A highly skilled Oracle Developer with 5 years of experience in developing and maintaining Oracle databases. Expertise in data analysis and ETL processes with experience in PL/SQL programming and database design. Demonstrated success in writing stored procedures and functions, creating triggers, developing and testing extensive SQL queries, creating ER diagrams and normalizing data. Proven track record of providing improvements to existing software applications and databases, ensuring data accuracy and integrity, analyzing user requirements and providing technical support.
- Oracle Database Design
- ETL Processes
- Data Analysis
- Database Security
- Data Warehousing
- SQL Queries
- Database Documentation
- Developed and enhanced Oracle databases to meet user requirements
- Developed stored procedures and functions for reporting and data analysis
- Designed and implemented triggers for user authentication and authorization
- Developed and tested extensive SQL queries for loading and manipulating data
- Created ER diagrams to visualize data models
- Normalized data to improve data quality and integrity
- Improved existing software applications and databases
- Ensured data accuracy and integrity
- Analyzed user requirements and provided technical support
- Monitored and tuned databases for improved performance
- Implemented database security measures to protect data
- Developed data warehousing solutions and data cubes
Experience 5+ Years
Level Senior
ORACLE Developer Resume with 7 Years of Experience
I am an experienced Oracle Developer with 7+ years of professional experience developing and managing databases. I have extensive knowledge in Oracle technologies and have worked on multiple projects building and maintaining Oracle databases. I have a strong background in database design, query optimization, data security, and troubleshooting. My extensive technical knowledge and passion for finding creative solutions to complex problems has enabled me to successfully deliver projects on time and within budget.
- Database design and development
- Oracle 11g, 12c, 19c
- SQL, PL/SQL
- Data security and troubleshooting
- Query optimization
- Database administration
- Developed Oracle databases to support applications, tools and services
- Built and optimized SQL queries to improve performance and reliability
- Implemented data security protocols to protect sensitive information
- Evaluated existing databases and identified areas of improvement
- Developed logical and physical data models
- Developed stored procedures and functions for application development
- Monitored and managed database performance and availability
- Created test plans and performed unit, system, integration and acceptance testing
- Troubleshooted Oracle database issues and provided solutions
- Worked with stakeholders to ensure timely delivery of projects
Experience 7+ Years
ORACLE Developer Resume with 10 Years of Experience
A highly experienced and certified Oracle developer with over 10 years of experience in developing, managing and integrating Oracle solutions across multiple industries and technologies. Proven expertise in designing, developing, and maintaining Oracle databases and applications, and providing technical expertise to support business objectives and growth. Possesses advanced knowledge in Oracle products and tools, and experienced in working with Oracle and non- Oracle products.
- Oracle Database Design and Development
- Oracle SQL and PL/SQL
- Oracle Applications
- Database Backup and Recovery
- Oracle Data Warehouse
- Oracle Streams
- Oracle GoldenGate
- Oracle 11g & 12c
- Designed, developed and maintained Oracle databases, applications and reports
- Developed and implemented Oracle database solutions in support of business initiatives
- Created, tested and maintained databases in compliance with corporate standards and best practices
- Performed data modeling, data analysis, and database performance tuning
- Developed and maintained Oracle Forms and Reports
- Developed and maintained Oracle databases for reporting and data warehousing
- Created and maintained database objects such as tables, views, indexes, triggers and stored procedures
- Developed and maintained Oracle Streams, GoldenGate and RAC solutions
- Implemented database security policies to protect confidential information
- Developed and maintained backup and recovery procedures and scripts
Experience 10+ Years
Level Senior Manager
Education Master’s
ORACLE Developer Resume with 15 Years of Experience
An Oracle Developer with 15 years of experience in developing, supporting and installing Oracle databases. Highly experienced in designing, developing and maintaining Oracle based applications, and experienced in the development of new applications. Possesses a deep knowledge of Oracle database architecture, performance tuning, security and integrity. Skilled in the use of multiple programming languages and development tools, including Oracle SQL*Plus, PL/SQL, Oracle Forms, Oracle Reports and Oracle SQL Developer.
- Oracle Database Architecture
- SQL*Plus, PL/SQL, Oracle Forms & Reports
- Oracle Security & Integrity
- Development & Maintenance of Oracle Applications
- Use of Different Programming Languages
- Troubleshooting & Problem- Solving
- Documentation & Reporting
- Installation, configuration, upgrade and migration of Oracle databases
- Designing and developing new Oracle applications
- Developing scripts and stored procedures to support Oracle databases
- Implementing appropriate security measures to maintain database integrity
- Performance tuning of Oracle databases to improve performance
- Developing and testing backup and recovery strategies
- Troubleshooting and resolving database issues
- Writing and maintaining Oracle documentation
- Developing reports, queries and data extracts using Oracle tools and technologies
- Providing support and maintenance of existing Oracle applications
Experience 15+ Years
Level Director
In addition to this, be sure to check out our resume templates , resume formats , cover letter examples , job description , and career advice pages for more helpful tips and advice.
What should be included in a ORACLE Developer resume?
A Oracle Developer resume should be tailored to reflect your skills and experience that are relevant to the position you are applying for. Here are some important components to include in your Oracle Developer resume:
- Summarization of relevant Oracle Developer experience: Summarize your experience developing applications and databases using Oracle products and technologies, such as Oracle Database, Oracle Application Server, PL/SQL, Oracle Forms, and Oracle Reports.
- Demonstration of technical skills: Showcase your experience with Oracle tools and technologies by highlighting technical projects you have completed.
- Database optimization and troubleshooting: Demonstrate your ability to work within an Oracle environment by listing any database optimization and troubleshooting experience you have.
- Communication and collaboration experience: Detail any experience in working with stakeholders, users, and peers to develop databases and applications.
- Professional certifications: List any Oracle certifications or credentials you have earned.
- Ability to work independently or in a team environment: Highlight any experience working independently or in a team environment, and any collaborations you have been involved in.
- Meticulous attention to detail: Demonstrate any experience in developing robust and reliable databases and applications by highlighting your attention to detail.
What is a good summary for a ORACLE Developer resume?
A good resume summary for an Oracle Developer should highlight the candidate’s ability to develop, design, and maintain Oracle databases. It should emphasize the candidate’s experience with Oracle applications and their expertise with Oracle SQL, PL/SQL, and Oracle tools. The summary should also demonstrate the candidate’s knowledge of database security, disaster recovery, and other related topics. Finally, the summary should show the candidate’s commitment to staying current with Oracle technologies and industry trends.
What is a good objective for a ORACLE Developer resume?
A Oracle Developer resume should always be tailored to the position you’re applying for. A good objective should succinctly demonstrate that you have the necessary skills and experience to excel in the role. Here are a few examples of objectives for Oracle Developer resumes:
- To leverage 6 years of Oracle development experience to secure a challenging and fulfilling position as an Oracle Developer in a leading organization.
- Seeking an Oracle Development position in a reputed organization where I can apply my expertise in designing and developing database solutions, as well as maintain and facilitate database performance and scalability.
- To utilize my expertise in Oracle development to support the company in developing database solutions and helping to maintain the database performance and scalability.
- Experienced Oracle Developer with a demonstrated history of working in the information technology and services industry and a commitment to delivering high-quality work. Seeking an opportunity to apply my knowledge and skills to enhance the performance and scalability of a database.
- Aiming to obtain an Oracle Developer role where I can use my knowledge of database design and development to create solutions and ensure database performance and scalability.
How do you list ORACLE Developer skills on a resume?
When applying for a job as an Oracle Developer, employers are looking for specific skills and qualifications. A resume should clearly communicate your skills and qualifications in order to stand out from the competition. Here are some tips for how to list Oracle Developer skills on your resume:
- Describe your experience in database design and development, including working knowledge of Oracle Database, SQL, PL/SQL, and other database programming languages.
- Demonstrate your knowledge of Oracle application development tools such as Oracle Forms, Oracle Reports, and Oracle Reports Builder.
- Highlight your ability to implement database objects and structures such as tables, views, triggers, procedures, and functions.
- Showcase your experience in debugging and troubleshooting Oracle applications.
- Highlight your knowledge of Oracle database security, performance tuning, and software development principles.
- Demonstrate your ability to write complex queries and stored procedures.
- Describe your experience in developing and automating database procedures.
By listing your Oracle development skills, you show employers that you have the knowledge and experience to be an Oracle Developer. Make sure to include the most relevant qualifications and skills to demonstrate your expertise and make your resume stand out from the competition.
What skills should I put on my resume for ORACLE Developer?
Your resume is a key tool in your job search, so it is important to showcase the skills you have that make you a great fit for an Oracle Developer role. When listing your skills on your resume, make sure to include those related to Oracle and other general skills that you possess. Here are some essential skills for an Oracle Developer resume:
- Oracle Database Administration: Possessing a solid understanding of Oracle Database Administration, including how to install and configure Oracle databases, how to back up and restore databases, and how to apply patches and upgrades.
- SQL Programming: Demonstrating the ability to write, debug, and maintain SQL stored procedures, functions, packages, triggers, and views.
- PL/SQL Programming: Having the knowledge and experience to create, debug, and maintain complex PL/SQL stored procedures, functions, packages, and triggers.
- Performance Tuning: Showing the capability to identify and resolve performance issues in Oracle databases.
- Data Modeling: Understanding the concepts of relational and dimensional data modeling and the ability to use data modeling tools such as ErWin.
- Linux/Unix: Demonstrating an understanding of Linux/Unix and scripting languages such as Bash and PowerShell.
- Software Development: Proving skills in software development processes, including the ability to design, develop, test, and debug software applications.
- Project Management: Showing the ability to manage and deliver multiple projects on time and on budget.
- Teamwork: Demonstrating the ability to work collaboratively and effectively with others on projects.
By including these skills on your Oracle Developer resume, you will be able to show employers that you have the technical expertise and soft skills necessary to succeed in the role.
Key takeaways for an ORACLE Developer resume
As an ORACLE Developer, the primary purpose of your resume is to showcase your ability to develop, maintain and support ORACLE databases. Your resume should reflect your expertise in the ORACLE platform, your technical skills, and your experience in ORACLE applications development. Here are some key takeaways for an ORACLE Developer resume:
- Demonstrate your working knowledge of ORACLE database systems, development tools, and relational data models.
- Highlight your experience with PL/SQL, database performance tuning and troubleshooting, and database security.
- Make sure to include a list of projects and applications you have developed using ORACLE technologies.
- Mention any additional ORACLE certifications or training you have achieved.
- Describe the technical environment in which you have experience, such as Windows, Unix, or Linux.
- Showcase your ability to work closely with users and stakeholders to understand their requirements and develop solutions that meet their needs.
- Showcase your attention to detail and your ability to find bugs and solve problems.
- Include any experience you have in database architecture and design, as well as database administration.
Lastly, ensure that your resume is free of spelling and grammar errors, is well organized, and is tailored to the specific ORACLE Developer role you are applying for.
Let us help you build your Resume!
Make your resume more organized and attractive with our Resume Builder
![oracle sample resume for 3 years experience Resume template](https://maxresumes.com/wp-content/uploads/2022/12/8.jpg)
PL SQL Developer Resume Sample
The resume builder.
Create a Resume in Minutes with Professional Resume Templates
Work Experience
- Experience in Distributed Multi-tier Application Development, Database Design, Data processing, Data Warehouse and Support mainly with Oracle technology on different platforms
- Strong knowledge in writing SQL Queries that varies from single table simple SQL’s to multiple table complex SQLs
- Proficiency in Relational Database Management Systems (RDBMS)
- Document concise design, development, and testing processes for assigned projects
- Good understanding of data modeling, processing and warehousing techniques
- Exceptional analytical and debugging skills
- Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables
- Proficiency using TOAD or equivalent developer tools
- Experience using source control applications such as Perforce
- Informatica experience
- Deep knowledge of SQL and best practices
- Demonstrate intermediate (to advanced) understanding of data modeling, schema design and ETL processes
- Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions
- Work in a group or team environment.Search Jobs US
- Experience working with Oracle databases, preferably version 11.5.10 or later release
- Demonstrated ability to performance tune queries and reports for maximum performance
- Database design and implementation experience
- Employee is occasionally required to stand for long periods of time
- Perl programming and Microsoft SQL/T-SQL experience
- Receives data from numerous sources using varied file record layouts
- Performs a wide variety of edits and validations
- Accepts high volumes of data
- Retains flexibility to accommodate changes in organizations and accounting standards
- Good Understanding of Oracle Exadata platform and DBMS concepts
- Experience as a Data Modeler/Sr. Oracle database developer role
- Experience with Python
Professional Skills
- This skillset does not require NoSQL, Big Data or Hadoop experience, the ideal skillset would be a hands on PL/SQL experienced with ETL using Oracle RDBMS
- Excellent/good communication skills, co-ordination skills, self-motivated, process oriented
- Eager to learn new skills and improve existing skills
- Excellent communication skills are essential to gather and impart information effectively within the department and also to the wider business
- Leading skills and experience with passing on knowledge to junior developers, mentoring or similar
- Trong web interface development skills using the following technologies. JavaScript, HTML, CSS and XML
- Strong Database programming skills in PL/SQL on Oracle database
How to write PL SQL Developer Resume
PL SQL Developer role is responsible for oracle, sql, pl/sql, analytical, business, technical, database, advanced, software, programming. To write great resume for pl sql developer job, your resume must include:
- Your contact information
- Work experience
- Skill listing
Contact Information For PL SQL Developer Resume
The section contact information is important in your pl sql developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your PL SQL Developer Resume
The section work experience is an essential part of your pl sql developer resume. It’s the one thing the recruiter really cares about and pays the most attention to. This section, however, is not just a list of your previous pl sql developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular pl sql developer position you're applying to. The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative PL SQL Developer resume experience can include:
- Prior experience with Autosys (Scheduling Tool) - Not required, Good to have
- Strong analytical and problem solving skills and ability to work in a fast paced environment
- Good communication skills are required along with excelling at a team-oriented organization structure
- Very good PL/SQL, Dynamic SQL programming skills
- Self-motivated team player with demonstrated problem solving skills
- Solid UNIX Scripting Skills
Education on a PL SQL Developer Resume
Make sure to make education a priority on your pl sql developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your pl sql developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in PL SQL Developer Resume
When listing skills on your pl sql developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical pl sql developer skills:
- Experience with EDI standard formats ANSI X12, EDIFACT, EDI 850, XML, etc. Solid UNIX scripting skills
- Solid oral, written, and presentation as well as strong interpersonal skills
- Solid comprehension of business/operation concepts. Good documentation skills
- Strong analytical and problem-solving skills, including debugging code, Critical and logical thinking
- Good communication (Listening, oral and written)skills A TEAM PLAYER attitude who can work with both business users and other IT members
- Strong collaboration skills, working with multiple teams in various locations in an agile environment
List of Typical Experience For a PL SQL Developer Resume
Experience for pl / sql developer resume.
- Strong PL/SQL and SQL skills
- Good communication, comprehension, and analytical skills
- Excellent organizational and follow-up skills and the ability to meet time sensitive deadlines
- Good experience in writing and modifying SQL LOADER, PL/SQL codes including Packages, Materialize Views, Nested tables, Triggers, and Functions
- Solid experience in writing SQL, stored procedures, proficient in SQL query performance tuning preferably on Oracle 12c
- 4+yrs experience SQL Development experience(using SQL to select information from Oracle DB, SQL for multi-table and multi-view joins
- Good experience in core banking
- PL/SQL- Strong PL/SQL and Oracle Experience (5+ years)
Experience For Oracle PL / SQL Developer Resume
- 24 Months Experience in using the Struts framework 24 Months Experience using JavaScript frameworks
- Communicate effectively with other developers via informal and formal reviews
- Working Experience with Informatica PowerCenter is a huge advantage
- Experience in designing, developing, implementing, and supporting enterprise level IT solutions
- Experience turning design into practice, by detailing a need and detailing the process so it can be improved and automated
- Experience in data preparation, data profiling, data cleansing, and data auditing
- 24 months experience optimizing, performance tuning, and debugging PL/SQL
- Experience optimizing, performance tuning, and debugging PL/SQL
- Experience developing Oracle PL/SQL using advanced PL/SQL programming techniques
Experience For Senior Oracle PL / SQL Developer Resume
- Experience working towards enhancing and maintaining PL/SQL code in Forms and Reports, in Oracle 11g environment
- 4+yrs of Oracle DB(vers. 11.1 11.2 and 12.1) experience to include performance tuning and working with DB objects
- Extensive experience in writing and modifying SQL LOADER and Spooler, PL/SQL Code, Views, Materialize Views, Partitions, Nested tables, External Tables etc
- Support refactoring of existing database schemas to support consolidation roadmap
- Experience developing database applications in PL/SQL using Packages, Functions, Procedures and Complex SQLPL/SQL
- Five (5) or more years experiences in Oracle database development, troubleshooting, and performance tuning of PL/SQL
- Min 3 years of Experience in Creating Packages, Procedures, Functions, Triggers, Cursors using PL/SQL
Experience For Informatica / PL SQL Developer Resume
- Experience in creating and managing Schema
- Experience writing and analyzing detailed designs ??
- Extensive experience as Oracle Database Developer (creating stored procedures, packages, triggers, supporting application development teams) is required
- Comfortable working independently but has experience working in a team environment
- Experience setting up data replication using Attunity, IDR tools
- Experience with creating and optimizing ETL workflows
- Strong debugging and problem solving back end database issues
Experience For Talend, Pl-SQL Developer Resume
- Experience writing and analyzing detailed designs
- Experience in leading a team and liaising with other regions to deliver large global projects
- Unix Experience- manipulating scripts (80%) and writing from scratch (20%)
- Experience working with business/IT users to understand business requirements, analyze existing code, and write functional and technical specifications
- Strong understanding of dimensional modeling / star schemas
- Operates as primary support contact for using Erwin data modeling software
- Support refactoring of existing database schemas to support consolidation roadmapWork with senior architects to understand new designs
Experience For ODI / PL / SQL Developer Resume
- Experience translating requirements into technical specifications to be created using Oracle 12C, SQL Loader, PL/SQL and SQL
- Six years of experience in PL/SQL tuning including knowledge of Explain Plans AWR, ASH and TKPROF
- Experience working with Maven, and Subversion or other versioning tool is desired
- Experience in developing PL/SQL packages, Conducted Unit testing, coordinated the production deployment and resolved Post implementation issues
- Very good Knowledge of Oracle PL/SQL including complex queries and tuning them, DDL/DML and stored procedures
Experience For Oracle PL / SQL Developer, Associate Resume
- Experience in developing UI using Angular JS / Java script
- Experience developing business applications using PL/SQL, Oracle, HTML and UNIX
- Experience with data modelling, system architecture, ETL, writing unit tests
- Experience writing stored procedures, packages, and functions using PL/SQL
- Experience writing PL/SQL packages, procedures, and functions using PL/SQL
- Work in a fast-paced changing environment while balancing multiple priorities
- Hands on coding experience with Oracle PL/SQL and performance tuning of SQL queries
- Experience writing stored procedures, packages and functions using PL/SQL
Experience For Oracel PL / SQL Developer Resume
- Experience integrating systems and doing some back end support of the database
- Extremely good at performance debugging and tuning and oracle internals
- Experience in analysis, design, coding, component and assembly testing of all application code owned by the Application Team
- Experience in Oracle PL/SQL programming or any procedural SQL language
- Development experience in creating stored procedures, PL/SQL Packages, Functions, Cursors, and Triggers
- Experience is developing and work on Autosys
- Good to have knowledge on DBLinks, Hints, Performance Tuning and Database Lock
- Skilled in SQL, PL/SQL, SQL Tuning, Oracle Forms, XML, and Unix commands
- Five (5) + years of experience with Oracle PL/SQL development using tools such as Toad and SQL Developer
Experience For Junior PL / SQL Developer Resume
- Experience with NoSQL document-based data stores like Cassandra (preferably) and designing suitable data models
- Well experienced in developing object relational mappings
- Experience with ETL design, development, administration and data quality testing
- Experience using data replication tools such as Attunity, IDR (Infosphere Data Replication)
- Experience developing Linux/Unix shell scripts
- Experience with data loading into Oracle databases
- Experience and knowledge in the performance design aspects of PL/SQL coding
- Experience developing Java/.Net applications
Experience For PL / SQL Developer, Intern Resume
- Knowledge and development experience using Agile methodologies
- Good - Data modelling & preferably tools like Power Designer
- Experience of complex applications interacting with multiple systems, high volume and VLDB in the financial industry
- Good knowledge of database security, auditing and exposure to PCI-DSS
List of Typical Skills For a PL SQL Developer Resume
Skills for pl / sql developer resume.
- Experience is performance tuning of SQL, analyzing the AWR, trace file output and advanced SQL writing skills
- Knowledge of data validation concepts, and advanced SQL writing skills
- Exercise excellent communication, interpersonal, and analytical skills within a team atmosphere
- Knowledgeable of Oracle Databases 10g/11g/12c with strong SQL skills
- Good communication, comprehension and analytical skills
- Strong data and business analysis skills with attention to detail
Skills For Oracle PL / SQL Developer Resume
- In-Depth knowledge of database concepts and hands-on experience in Oracle. Advanced PL/SQL skills
- Research and trouble-shoot application problems using PL/SQL programming skills
- Strong experience in supporting applications running in Unix/Linux environment
- Good hands on experience of shell-scripting in UNIX environment (Job Scheduling)
- Good experience in PL/SQL programming – Stored Procedures, Functions, Indexes, Packages, SQL tuning, and creation of Oracle Objects
- Prior experience with reporting (XML/BI Reporting, Oracle Reports)
Skills For Senior Oracle PL / SQL Developer Resume
- Prior experience in defining coding standards and best practices for Oracle PL/SQL development
- Professional experience in Oracle database and experience in designing and maintaining applications
- Oracle 11g, SQL, PL/SQL, Performance Tuning, Unix, Autosys, Data Warehouse Experience, Data Modeling. 8 to 12 years of experience
- Good experience with Unix shell scripting
- Able to communicate effectively across varied area including technology, business units and leadership
- Manage reference data stored in Oracle DBsStrong experience in Wealth management or Finance/Banking Domain
- Good experience with PL/SQL, Oracle functions, procedures, triggers, packages & performance tuning
- Beginner to immediate ETL Informatica skills
- Software Skills: PLSQL, 2 - 4 Years
Skills For Informatica / PL SQL Developer Resume
- Software Skills: SQL, 2 - 4 Years
- Technical Skills: Develop/execute test plans, 2 - 4 Years
- Nice to have: Java/J2EE skills
- Good experience on Cursors, Triggers and ability to write complex Stored Procedures
- Exceptional ability to effectively troubleshoot program
- Exceptional ability to effectively troubleshoot program Qualifications
- Responds promptly and effectively to resolve incidents, tasks, and projects
- Experience in PL SQL and Oracle DB experience to work on PowerPlan related projects
Skills For Talend, Pl-SQL Developer Resume
- Proven Database development experience in a financial domain
- Strong experience in Oracle Database
- Experience Relational Database Design experience with Oracle
- Collaborate within the team, across other teams – application development, DBAs, QA, product and project management to effectively follow through on the tasks
- Experience and can demonstrate lead
Skills For ODI / PL / SQL Developer Resume
- Demonstrated experience with Data Extraction on Oracle 11g/10g/9i/8i, Oracle CDC, XML File, SAP R/3, SWIFT, MS SQL Server, Flat files
- Apply technical skills and expertise in providing solutions to technical and business problems
- Problem solving skills and the ability to think outside of traditional role boundaries
- Good data modelling experience
- Have strong SQL, relational database knowledge and hands on experience
- Experience and a strong proficiency with Microsoft and/or Oracle SQL
- Great teamwork and communication skills (local and international teams),
- Experience and solid knowledge of Oracle PL/SQL and ORACLE
Skills For Oracle PL / SQL Developer, Associate Resume
- Strong experience with Oracle Object Design and implementation (Oracle Packages, Procedures, Triggers)
- Proven experience in developing database applications using PL/SQL
- Expert - SQL skills
- Strong experience in Oracle PL/SQL and UNIX Shell Scripting
- Good Hands on experience in Maintenance and Support of ETL activities and Production Support Project
- Solid, proven knowledge in Oracle 11G/12C -PL/SQL, triggers, stored procedures, packages, functions
Skills For Oracel PL / SQL Developer Resume
- Working experience in data mapping for data loading, bulk data loading and External tables
- Commanding knowledge and experience writing advanced SQL queries, PL/SQL Stored procedures,
- Looking for 5+ years of experience in Oracle PL/SQL Development
- Programming experience (Oracle, PL/SQL, Informatica)
- Datawarehousing experience would be ideal
- Working experience with tools: SQL Developer, PL/SQL Developer
- Working experience with data analysis and reconciliation issues
Skills For Junior PL / SQL Developer Resume
- Working with users and application stakeholders to verify and validate requirement
- Experience with using and configuring Kafka topics for message storing/retrieving
- History of troubleshooting and correcting coding issues. Experience using industry-standard Software Development
- Experience translating requirements into technical specifications including the data modelling, designing and data flow diagrams
Skills For PL / SQL Developer, Intern Resume
- Experience in Data Preparation: Data Profiling, Data Cleansing, and Data Auditing
- 84 Months experience developing Oracle PL/SQL using advanced PL/SQL programming techniques
- Experience working in a customer facing role, preferably in the role of consulting
- Strong in debugging and understanding existing code for modifications
- Experienced with Stored procedure creation/debugging/ optimization/tuning
- Experience in application coding and in creating computer applications and/or databases
List of Typical Responsibilities For a PL SQL Developer Resume
Responsibilities for pl / sql developer resume.
- Strong communication skills, self-motivated, detail oriented, and highly responsible
- Excellent communication skills; works well in a team environment
- Five (5) + years of experience in Data Modeling, Data Migration and ETL processing using PL/SQL stored procedures, functions and triggers
- Experience in managing and architecting database
- Experience troubleshooting/testing the databases after development (post production support)
- Experience with designing, coding
- Experience in applying a Software Development Life Cycle
- Experience in Java / Spring / ORM
Responsibilities For Oracle PL / SQL Developer Resume
- Work experience with bulk / batch processing applications
- Perform data analysis and data profiling. Identify data quality issues. [Good to have]
- Good understanding of Relational Data structures
- Experience in Data loading
- Experience making changes to production systems gracefully
- Skilled in SQL, PL/SQL, SQL Tuning, Oracle Forms, XML, and Unix commands?
- Strong knowledge of SQL queries, complex joining, analytical function, etc
- Hands-on experience in developing shell scripts to call PL/SQL programs for automation batch programs
- Experience in software development using Oracle based technologies
Responsibilities For Senior Oracle PL / SQL Developer Resume
- Very good knowledge of software design and programming patterns
- Very good knowledge of SQL queries and PL/SQL code optimization and tuning
- Excellent ability to work in a team, based on partnership and sense of responsibility, focused on achieving the results intended and planned
- Good understanding of ER Diagrams, Data Flows
- Experience in Oracle PL/SQL programming or any procedural SQL language (PSQL, SQL PL, T- SQL)
- Experience in Data Modelling (creation of tables, indexes, foreign keys)
Responsibilities For Informatica / PL SQL Developer Resume
- Progressively more complex programming experience in large scale Information System environments
- Build Tools Maven, Ant. Have experience using Sonar, and Jenkins
- Extensive hands-on experience with source code management best practices, continuous integration, and automated testing
- Experience with shell scripting, Perl, and Linux
- Experience writing procedures and packages in PL/SQL
- Experience with creating triggers, views, functions, sequences, etc
- Demonstrated history of translating technical concepts for presentation to business or end users
Responsibilities For Talend, Pl-SQL Developer Resume
- Strong understanding of SDLC/Agile concepts
- Experience with procedures, functions, packages, types, and triggers, including reuse
- 48 months experience performing Extract, Transform, and Load (ETL) techniques
- 24 months experience using XML parser for PL/SQL
- Experience in the Agile programming framework
- Seven years of SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc
- Experience with code deployment in development, testing and production environments is desired
- Experience developing in PL/SQL required
Responsibilities For ODI / PL / SQL Developer Resume
- Experience in Schema Modeling
- Good command of the English language, both verbal and in writing,
- Good database design knowledge & modelling basics
- Develop and maintain effective relationships with the IT team and various business units to enable working partnerships across the organization
- Experience with SQL (advance queries, tuning) and PL/SQL
- Experience in building database software architecture
- Software development experience using SQL , PL/SQL 5+
- Strong UNIX knowledge with hell scripting
- Experience writing COMPLEX queries within large data
Responsibilities For Oracle PL / SQL Developer, Associate Resume
- Experience with packaging can be interchangeable with DB2 and/or PostGres SQL
- Experience with a network marketing company or MLM
- Experience with automated PL/SQL testing
- Experience with facilitating meetings and conference calls
- Experience working with Oracle and PL/SQL
- Experience with Oracle data warehousing
- Extensive knowledge and experience in PL/SQL programming to include the use of query tools such as Toad
- Experience with code changes, bug fixes, and unit testing
Responsibilities For Oracel PL / SQL Developer Resume
- Experience writing procedures and packages in PL-SQL
- Experience developing stored procedures, functions, triggers, packages
- Experience of the following tools : Jira and Confluence
- Data replication: Experience with data replication using Oracle Golden Gate
- Strong background using both Windows and Solaris/Unix/Linux
- Experience with federal acquisition and contracting processes
- Experience with star schema/data warehouse data model, multi- dimensional reporting
Responsibilities For Junior PL / SQL Developer Resume
- Experience in one or more of the following technologies: PHP, COBOL, Perl, Angular, C, C++
- Experience of performance tuning of SQL Queries
- Knowledge and experience of development using UC4
- Commercial development and support experience in Oracle 10g based
- Experience in Oracle and PL/SQL. Very familiar with usage of Collections , Transaction Management
- Hands on experience on PL/SQL Development
Responsibilities For PL / SQL Developer, Intern Resume
- Experience in Oracle PLSQL development and oracle database design
- Experience with other ETL tools and Data Replications tools like SSIS, Oracle Golden gate, Data Guard, Data stage, etc
- Work with in-house experienced specialist in order to fix code issues
- 2–5 years of experience with Oracle as a developer
- Experience with Oracle 11g/12c Databases, ability to write efficient and complex Oracle SQL and PL/SQL code
- Experience with other ETL tools and Data Replications tools like Informatica, Data Guard, Data stage, etc
- Java Development experience is preffered
- To be a good active listener and communicator
- Experience in Oracle PL/SQL development
Related to PL SQL Developer Resume Samples
Developer / architect resume sample, sql developer resume sample, sql server database developer resume sample, senior cyber resume sample, consultant crm resume sample, lead sap resume sample, resume builder.
PL SQL Developer Resume Samples
A PL SQL developer takes charge of maintaining and building computer databases using Pl/SQL packages, the various other roles and responsibilities that are normally executed and included in the PL SQL Developer Resume are – developing and providing support to system interfaces, coordinating with other developers and project managers for evaluation of applications, developing various SQL packages, monitoring and recommending changes in PL/SQL packages, developing relational database , testing and troubleshooting databases, ensuring data security and merging database information.
The normal skills that are expected from a PL SQL developer are SQL expertise, working knowledge of various operating systems, programming language skills, familiarity with ETL tools and a good grip of Oracle, Java and D2K forms. While a Bachelor’s degree in the field of IT or computer science is considered ideal for this job role, some employers oversee work experience and skills over formal education.
![oracle sample resume for 3 years experience PL SQL Developer Resume example](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848644-pdf.jpg)
- Resume Samples
- PL SQL Developer
Oracle PL/SQL Developer Resume
Objective : Oracle PL/SQL Developer with over 2 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
Skills : Oracle 10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER DB2, Teradata, MS Access. ETL Tools: Informatica (Power Center AB Initio And SQLLoader.
![oracle sample resume for 3 years experience Oracle PL/SQL Developer Resume Template](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848446-pdf.jpg)
Description :
- Involving in the full development cycle of PLanning, analysis, design, development, testing, and implementation.
- Designing logical and physical data models for star and snowflake schemas using Erwin.
- Created and modified SQL PLus, PL/SQL and SQL Loader scripts for data conversions.
- Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
- Wrote SQL, PL/SQL, SQL PLus programs required to retrieve data using cursors and exception handling.
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
- Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
- Wrote Unix shell scripts to process the files on a daily basis like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
Headline : About 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Data Modeling (Logical and Physical). Development of client/server, multi-tiered applications using the Oracle Relational Database Management System (RDBMS), SQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX, and Linux. Well experienced working with Waterfall &Agile Methodologies. Experienced in Tuning Queries for better performance with a large volume of data.
Skills : SQL LOADER, SQL Developer, SQL Plus, SQL Developer, Data Modeler, Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Reports, ETL,SSIS
![oracle sample resume for 3 years experience Oracle PL/SQL Developer Resume Format](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848461-pdf.jpg)
- Created technical design for the back end PL/SQL based on business requirement documents and the functional system design.
- Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Involved in updating procedures, functions, triggers, and packages based on the change request.
- Built complex queries using SQL and wrote stored procedures using PL/SQL.
- Used ref cursors and collections for accessing comPLex data resulted from joining of a large number of tables.
- Involved in moving the data from flat files to staging area tables using SQL loader.
- Extensively used for all and bulk collect to fetch large volumes of data from the table.
- Performed SQL and PL/SQL tuning and application tuning using various tools like tkprof, autotrace and dbms_SQLtune.
Summary : Oracle PL/SQL Developer having 10 years of programming experience, as a Sr. Oracle SQL, PL/SQL and ETL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Experience in Data Migration across various databases as well as within the same database across different systems. Well-versed in different stages of the Software Development Life Cycle (SDLC).
Skills : Oracle 11G, Oracle PL/ SQL, UNIX Shell Script, SQL Developer, Toad, Oracle Developer, IBM Rational, Agile & Waterfall, PowerBuilder
![oracle sample resume for 3 years experience Oracle PL/SQL Developer Resume Example](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848498-pdf.jpg)
- Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL PLus, SQL developer, and toad.
- Enforced data integrity using integrity constraint and database triggers.
- Proficient in advance features of Oracle 11g for PL/SQL programming like using records and collections, bulk bind, ref. Cursors, nested tables, and dynamic SQL.
- Created partitioned tables and partitioned indexes to improve the performance of the applications.
- Experience with performance tuning for Oracle RDBMS using explain plan and hints.
- Interacted with web development team to develop in tandem back-end solutions with front-end web executions.
- Executed Quality Control checks of source code created by other developers.
- Monitored incoming/outgoing data. Troubleshoot errors as they occur.
Oracle PL/SQL Developer (Unix) Resume
Objective : Over 4+years of professional experience in IT industry as Oracle SQL/PLSQL developer, Analysis, Design, and Modeling. Strong knowledge of Oracle architecture and database design. Excellent skills in designing and development of applications using Oracle, SQL, PL/SQL Good knowledge on Oracle tools like SQL PLUS, PL/SQL, SQL and used TOAD in many development projects. Oracle Forms and Reports Experienced in all phases of Software Development Life Cycle (SDLC).
Skills : Informatica, ETL. Basic Knowledge Of SAS Programming: SQL, PL/SQL, T-SQL, UNIX Scripting. Operating Systems: Windows UNIX.
![oracle sample resume for 3 years experience Oracle PL/SQL Developer (Unix) Resume Example](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848511-pdf.jpg)
- Participating in database design within an existing Oracle database structure.
- Helping application development team in preparing technical designs and perform construction activities.
- Working with developers to design and write complex packages to support their needs.
- Writing complex functions and procedures for new packages and update existing packages in an established Oracle database using pre-defined business rules.
- Working with database administrators to implement design changes and new packages.
- Performance testing and rewriting of production Code/SQL statements & procedures performing badly, identified by database administrators.
- Provided database support to developers who write code using WCF, WPF and. Net.
- Supporting the application through the testing and implementation phases, including product test, stress/load test etc.
Headline : Oracle PL/SQL Developer with around 6 years of total IT experience in Business Requirements Analysis, Application Design, data modeling, Datawarehousing, Coding, Development, Tuning, Testing, Oracle EBS and implementation of business applications with RDBMS,SQL,PL/SQL,Oracle Reports, UNIX Shell scripting, Java and J2EE. 8 years of working experience in Oracle SQL and PL/SQL procedures, functions, packages, triggers, cursors, view etc.
Skills : MS-VISIO, Visual Source Safe (VSS), CVS, Crystal Reports 8.0/XI, Forms 5.0, Forms 6i, Reports 6i, Forms 9i, Reports 9i, Oracle Reports 10G, Oracle Forms
![oracle sample resume for 3 years experience Oracle PL/SQL Developer Resume Sample](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848554-pdf.jpg)
- Maintaining customer information and ensuring efficient data retrieval as required for core decision making.
- Writing stored procedures, triggers and monitoring performance to ensure efficient data retrieval.
- Understanding of clients functional requirements and participate in writing functional specs.
- Coordinating with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Working on SQL Loader to load data from flat files obtained from various facilities every day.
- Creating and modifying several Unix Shell scripts according to the changing needs of the project and client requirements.
- Writing Unix shell scripts to process the files on a daily basis like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
- Involving in the continuous enhancements and fixing of production problems.
Junior Oracle PL/SQL Developer Resume
Objective : Junior Oracle PL/SQL Developer with over 3 years of experience in Design, Development, and Implementation of enterprise Oracle databases applications in both OLTP and Decision Support systems. Extensive experience using IDE Tools like Eclipse, NetBeans, and IDEA IntelliJ for Java/J2EE application development and web technologies like HTML, and XML as required for database management. Good knowledge and understanding of Data Modeling concepts, UML diagrams using MS Visio.
Skills : SQL Plus, SQL Loader, WinSCP, SharePoint, MS Project, Putty, EditPlus, Putty, Confluence, TextPad, Build (ANT, MAVEN), SVN, Log4J, PAC2000, JQuery
![oracle sample resume for 3 years experience Junior Oracle PL/SQL Developer Resume Example](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848573-pdf.jpg)
- Wrote PL/SQL programs required to retrieve data from the data repository using cursors, UTL file i/o and exception handling sync up with confluence for project related information.
- Used SQL Loader/Korn shell script to load data from various sources into an Oracle database.
- Wrote complex SQL using joins, sub-queries and correlated sub-queries.
- Used clear case for maintaining the component and for release and version management.
- Maintained scripts using Korn shell scripting (extension-. Ksh) and Perl to support development.
- Developed Unix shell scripts to automate repetitive database processes.
- Tracked all the releases and updating the information on to a centralized location (wiki).
- Developed Korn shell scripts for job scheduling, batch processing, and database transactions.
Senior Oracle PL/SQL Developer Resume
Summary : Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Good knowledge of logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index (B Tree, Bitmap, and Function Based). Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
Skills : SQL, PL/SQL, Unix Shell Scripts, Java, XML, C And C++ Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange
![oracle sample resume for 3 years experience Senior Oracle PL/SQL Developer Resume Template](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848592-pdf.jpg)
- Worked on SQL loader to load data from flat files obtained from various facilities every day.
- Involved in the continuous enhancements and fixing of production problems.
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions, and packages for moving the data from the staging area to the data mart.
Summary : Oracle PL/SQL Developer with 7+ years of experience on various phases of SDLC such as Project Requirement Study, high-level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning. Expertise in data modeling for large data warehouses supporting business intelligence applications (OLAP) and also online transaction processing systems (OLTP).
Skills : Oracle, MS SQL Server, IBM DB2 UDB 8.0/7.0. Environment Windows XP, Red Hat Linux, Unix, Sun Solaris. Programming Languages PL/SQL, SQL, TSQL
![oracle sample resume for 3 years experience Oracle PL/SQL Developer Resume Format](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848608-pdf.jpg)
- Responsible for gathering requirements from users for reports development and interface program customizations and in analyzing the business process.
- Created and maintained Oracle database objects like tables, views, materialized views, indexes, constraints, sequence, synonyms and database link using SQL.
- Created numerous complex queries involving joins, correlated sub-queries diverse business requirements.
- Partitioned tables by determining the suitable methodology to improve performance and manageability.
- Planned, designed, and implemented the application database code objects, such as stored procedures and views, indexes.
- Worked on advanced PL/SQL constructs like Oracle-supplied packages, nested tables, varrays, records, types, dynamic SQL and analytical functions.
- Created temporary tables, packages and procedures using SQL developer.
- Involved in writing the database triggers to furnish the audit details.
PL/SQL Developer Resume
Summary : Oracle PL/SQL Developer with over 8 years of experience in the field of software development. Experience in Perl, Oracle and Unix Expertise in financial industries based applications including trading systems. Excellent database knowledge on RDBMS like Oracle, SQL, PL/SQL Solid experience in Perl programming using with JavaScript and Html. Experience in Oracle SQL queries and PL/SQL scripts, procedures, functions, triggers and packages and query optimization.
Skills : Microsoft Project, MS Excel, MS Access, T-SQL, SSIS, SSRS, MS Visio, Unix Shell/Perl Script
![oracle sample resume for 3 years experience PL/SQL Developer Resume Format](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848626-pdf.jpg)
- Involving in database development by creating Oracle PL/SQL functions, procedures, triggers, packages, records, and collections.
- Creating database objects like SQL queries, tables, joins stored procedures using Oracle utilities like PL/SQL, SQL plus, SQL server.
- Involving in performance tuning for complex SQL queries using explain plan tables, collections, and table partitions to optimize performance.
- Generating SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants, and synonyms.
- Involving in application enhancements according to user requirements.
- Building physical data structures like tables, views, constraints & indexes.
- Working with SQL loader and control files to load the data in different schema tables.
- Implementing features including materialized views for better performance of summary tables, autonomous transactions, coding dynamic SQL statements.
Objective : PL/SQL Developer with 4+ years of extensive experience as an Oracle, PL/SQL Developer with ETL experience. Expertise in Software Development Life Cycle(SDLC) of client implementations including requirements gathering, business analysis, system configuration, design, development, testing, technical documentation, and support. Strong experience in providing technical documentation and status reports of the applications as per the requirement.
Skills : SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl Programming Oracle Tools/GUI Forms
![oracle sample resume for 3 years experience PL/SQL Developer Resume Template](https://assets.qwikresume.com/resume-samples/pdf/screenshots/pl-sql-developer-1548848644-pdf.jpg)
- Developing complex database processes with PL/SQL containing batch or ETL functionality.
- Developing and enhancing an existing DataMart in an OLAP schema.
- Requirements gathering, design, development, testing, and documentation.
- Designing logical and physical ERD diagrams, process flow diagrams, or related data processing documentation.
- Leveraging Oracle 10g/11g features to their fullest on a large-scale multi-terabyte system.
- Assisting the Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements.
- Providing production deployment and production support as needed.
- Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions
- Participating in performance tuning activities.
Table of Contents
Recent posts, download this pdf template., creating an account is free and takes five seconds. you'll get access to the pdf version of this resume template., choose an option., unlock the power of over 10,000 resume samples., take your job search to the next level with our extensive collection of 10,000+ resume samples. find inspiration for your own resume and gain a competitive edge in your job search., get hired faster with resume assistant., make your resume shine with our resume assistant. you'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want., get noticed with resume templates that beat the ats., get past the resume screeners with ease using our optimized templates. our professional designs are tailored to beat the ats and help you land your dream job..
- • Spearheaded the management of Oracle database systems, streamlining operations and reducing server response times by 35%.
- • Coordinated with a global IT team to ensure database availability across continents, directly supporting business continuity initiatives.
- • Led a critical database patching process, aligning with functional owners and service providers, thus enhancing system security and compliance.
- • Successfully managed the cloud-based Oracle Exadata service, improving operational efficiency by integrating automation techniques.
- • Conceptualized and executed a comprehensive disaster recovery plan which reduced potential data loss risk by over 50%.
- • Drove the development of a robust database performance monitoring strategy that increased system reliability and user satisfaction.
- • Administered multiple Oracle databases, achieving a significant 20% improvement in processing speed and efficiency.
- • Developed and maintained a high-availability database architecture that supported enterprise-level applications.
- • Executed strategic planning for database upgrades and infrastructure enhancements, leading to a 15% cost reduction.
- • Authored and revised database environment standards and protocols, ensuring alignment with industry best practices.
- • Managed cross-functional teams to deliver key database projects on time, improving overall productivity by 25%.
- • Implemented cloud-based database solutions that supported scalability, resulting in a 30% growth in database capacity.
- • Monitored and optimized the performance of databases, achieving a 20% reduction in maintenance downtime.
- • Collaborated effectively with managed service providers to ensure continuous improvement of database services.
- • Authored extensive documentation to guide future implementations and upgrades, benefiting ongoing IT operations.
5 Oracle Database Administrator Resume Examples & Guide for 2024
Your Oracle database administrator resume must clearly highlight your experience with database design and performance tuning. Be specific about the Oracle database versions you've worked with. Demonstrate your expertise in backup and recovery procedures, as well as your understanding of Oracle security management. Employers look for proven ability to ensure data integrity and high availability.
All resume examples in this guide
![oracle sample resume for 3 years experience](https://cdn.enhancv.com/images/1098/i/aHR0cHM6Ly9jZG4uZW5oYW5jdi5jb20vcHJlZGVmaW5lZC1leGFtcGxlcy8wSWFLT0M2MEFqY3dDR2l2SzFpOXRSWHZzNG5nR1VpSmVSMUZmakdpL2ltYWdlLnBuZw~~..png)
Traditional
![oracle sample resume for 3 years experience](https://cdn.enhancv.com/images/1098/i/aHR0cHM6Ly9jZG4uZW5oYW5jdi5jb20vcHJlZGVmaW5lZC1leGFtcGxlcy9yVkxoVGNVc25udHQ5TFV3ZmFWVXB2MHhTRk4xYVMyYTlBa3BMMWg4L2ltYWdlLnBuZw~~..png)
Resume Guide
Resume Format Tips
Resume Experience
Skills on Resume
Education & Certifications
Resume Summary Tips
Additional Resume Sections
Key Takeaways
![oracle sample resume for 3 years experience Oracle Database Administrator resume example](https://cdn.enhancv.com/predefined-examples/TqdbubGekfzQvq6VEQsivUp1KqjWFLW6PLKmtTF2/image.png)
As an Oracle Database Administrator, articulating the depth of your technical expertise without overwhelming non-technical recruiters can be a significant resume challenge. Our guide provides tailored strategies to help you balance complex jargon with clear and impactful achievements, ensuring your resume resonates with all hiring stakeholders.
- Defining the highlights of your oracle database administrator career through your resume summary, objective, and experience.
- Real-world oracle database administrator resume samples with best practices on how to stand out amongst the endless pile of candidate resumes.
- Most in-demand oracle database administrator resume skills and certifications across the industry.
- Standardizing your resume layout, while maintaining your creativity and individuality.
If the oracle database administrator resume isn't the right one for you, take a look at other related guides we have:
- Database Assistant Resume Example
- Marketing Data Analyst Resume Example
- Excel Data Analyst Resume Example
- Data Specialist Resume Example
- GCP Data Engineer Resume Example
- Clinical Data Analyst Resume Example
- Data Entry Clerk Resume Example
- Enterprise Data Architect Resume Example
- Data Manager Resume Example
- Data Center Engineer Resume Example
Is there a correct way to format your oracle database administrator resume?
This is a tricky question. While skimming over your resume, recruiters will be looking at your experience and the message your profile conveys. That's why your resume format needs to be clear and concise, serving to supplement and organize your experience. Professional best practices point that the best oracle database administrator resumes:
- Follow the reverse chronological order, where the most recent experience items are presented first . This is to keep your expertise succinct and to show recruiters your career growth over the years;
- Have a clearly defined header that includes all relevant contact information and a portfolio or a LinkedIn link. In some countries, it is acceptable to include a professional photo , so that your application is more memorable;
- Feature the most important oracle database administrator resume sections towards the top, e.g. summary, skills, and experience. That way, recruiters can immediately find information that is relevant to the role;
- Take up no more than two pages - and two pages are the exception for more experienced professionals. Keep your expertise to the point and use your oracle database administrator resume real estate wisely .
- Selecting modern, yet simple fonts, e.g. Rubik, Lato, etc., would help your application stand out;
- Many candidates stick with the tried-and-tested Arial or Times New Roman, but you'd want your oracle database administrator resume to be a bit more unique;
- The ATS can read all serif and sans-serif fonts, so you should avoid fancy, formal script (or cursive) fonts.
Upload & Check Your Resume
Drop your resume here or choose a file . PDF & DOCX only. Max 2MB file size.
Highlight any significant extracurricular activities that demonstrate valuable skills or leadership.
Ensure your oracle database administrator resume stands out with these mandatory sections:
- Header - the section recruiters look to find your contact details, portfolio, and potentially, your current role
- Summary or objective - where your achievements could meet your career goals
- Experience - showcasing you have the technical (and personal) know-how for the role
- Skills - further highlighting capabilities that matter most to the oracle database administrator advert and your application
- Certifications/Education - staying up-to-date with industry trends
What recruiters want to see on your resume:
- Experience in Oracle database management, including version upgrades, patch management, and troubleshooting.
- Understanding of Oracle RAC (Real Application Clusters), Data Guard, and ASM (Automatic Storage Management).
- Proficiency in PL/SQL scripting and tuning for performance optimization.
- Knowledge of Oracle database security measures, backup procedures, and recovery strategies.
- Familiarity with Oracle-specific tools and utilities like Oracle Enterprise Manager (OEM) and RMAN (Recovery Manager).
The experience section or the essence of your professional oracle database administrator resume
Recruiters always have and always will appreciate well-written oracle database administrator resume experience sections.
The experience section is perhaps the most crucial element of your professional presentation, as it needs to answer job requirements while showcasing your technical expertise and personality.
Create your best resume experience section yet by:
- Selecting only relevant experience items to the role you're applying for;
- Always ensure you've listed a metric to quantify your success alongside each experience item;
- Create a narrative that showcases your oracle database administrator career succession: this goes to show the time and effort you've invested in the field to build your experience from the ground up;
- Within each experience bullet, consider a problem you've solved, the skills you've used, and the bigger impact this has made in the organization.
Take a look at how other real-life professionals have curated their experience with the oracle database administrator samples below:
- Implemented robust database architecture for critical application processing over 5TB financial data, greatly enhancing data retrieval speed by 40%.
- Conducted comprehensive performance tuning and optimization, achieving a reduction in report generation time from 6 hours to 1 hour for finance stakeholders.
- Led a successful data migration project from legacy systems to Oracle 12c, ensuring a seamless transition with zero downtime.
- Spearheaded the integration of Oracle RAC and Data Guard solutions that improved database availability and disaster recovery capabilities for large-scale e-commerce operations.
- Oversaw the management of over 200 Oracle databases, enhancing system security and reducing unauthorized data access incidents by 50%.
- Developed and enforced database administration policies that standardized processes across multiple teams, leading to a 30% improvement in deployment efficiency.
- Optimized SQL queries across multiple business applications, resulting in a 35% decrease in average query execution time.
- Introduced Automated Storage Management (ASM) for improved disk performance, leading to an annual cost savings of $200,000 in hardware upgrades.
- Pioneered the implementation of Oracle Exadata Database Machine, significantly boosting performance for high-volume transaction processing.
- Developed and maintained a custom Oracle backup solution that reduced data recovery times from 8 hours to 2 hours for critical databases.
- Coordinated with cross-functional teams to support application development lifecycles, improving time-to-market for new software features by 25%.
- Implemented Oracle Flashback technology, drastically reducing the time needed to recover from human errors in data entry.
- Played a key role in designing a data warehousing solution that supported analysis of customer behavior patterns, driving a 15% increase in targeted marketing success.
- Trained and mentored a team of junior DBAs, leading to a 20% increase in department efficiency and a reduction in critical incidents.
- Conducted periodic security audits that led to the identification and patching of 90% of potential database vulnerabilities within a year.
- Initiated and supervised the transition to Oracle Multitenant architecture, which facilitated a 30% reduction in resource usage for database services.
- Architected and delivered a comprehensive data encryption strategy that matched industry best practices, boosting client trust and compliance with regulations.
- Performed database cloning and patch management that resulted in smoother and more reliable application development cycles.
- Managed Oracle ERP databases, supporting critical business operations and maintaining 99.9% uptime for a globally distributed workforce.
- Designed and executed performance tuning strategies for Oracle 11g that doubled the efficiency of end-user database interactions.
- Negotiated with vendors to integrate third-party database monitoring tools, which decreased the mean time to resolution for database incidents by 40%.
- Collaborated with the development team to streamline the database development process, which improved deployment speeds by 30% for new application features.
- Enhanced database replication and logging mechanisms to ensure real-time data synchronization across distributed systems, mitigating data loss risks.
- Introduced proactive performance metrics monitoring, enabling the identification of bottlenecks before they impacted end-user experience.
Quantifying impact on your resume
- Managed and optimized a 10TB Oracle database, reducing query response times by 30%.
- Designed and implemented a backup and recovery strategy that improved data recovery time by 50%.
- Automated database maintenance tasks, which resulted in a 20% reduction in downtime.
- Led a database migration project that successfully transferred 5TB of data with zero data loss.
- Configured Oracle Real Application Clusters (RAC) which boosted database availability to 99.99%.
- Developed and tracked database performance metrics, leading to a 25% improvement in overall system efficiency.
- Trained a team of 8 junior DBAs, enhancing the team's skillset and productivity by 40%.
- Implemented security measures that decreased unauthorized access incidents by 95%.
Action verbs for your oracle database administrator resume
![oracle sample resume for 3 years experience Target Illustration](https://cdn.enhancv.com/images/1142/i/L19uZXh0L3N0YXRpYy9pbWFnZXMvYmFja2dyb3VuZC02ZmRiNjljY2RiYmZmMTNmNzI0ZjFhMDU5ZDA4NDI4Mi53ZWJw..webp)
What to do if you don't have any experience
It's quite often that candidates without relevant work experience apply for a more entry-level role - and they end up getting hired.
Candidate resumes without experience have these four elements in common:
- Instead of listing their experience in reverse-chronological format (starting with the latest), they've selected a functional-skill-based format. In that way, oracle database administrator resumes become more focused on strengths and skills
- Transferrable skills - or ones obtained thanks to work and life experience - have become the core of the resume
- Within the objective, you'd find career achievements, the reason behind the application, and the unique value the candidate brings about to the specific role
- Candidate skills are selected to cover basic requirements, but also show any niche expertise.
Recommended reads:
- When Should You Include Your High School on Your Resume?
- How To Include Your Relevant Coursework On A Resume
List all your relevant higher education degrees within your resume in reverse chronological order (starting with the latest). There are cases when your PhD in a particular field could help you stand apart from other candidates.
![](http://nandemo.space/777/templates/cheerup1/res/banner1.gif)
In-demand hard skills and soft skills for your oracle database administrator resume
A vital element for any oracle database administrator resume is the presentation of your skill set.
Recruiters always take the time to assess your:
- Technological proficiency or hard skills - which software and technologies can you use and at what level?
- People/personal or soft skills - how apt are you at communicating your ideas across effectively? Are you resilient to change?
The ideal candidate presents the perfect balance of hard skills and soft skills all through the resume, but more particular within a dedicated skills section.
Building your oracle database administrator skills section, you should:
- List up to six skills that answer the requirements and are unique to your expertise.
- Include a soft skill (or two) that defines you as a person and professional - perhaps looking back on feedback you've received from previous managers, etc.
- Create up to two skills sections that are organized based on the types of skills you list (e.g. "technical skills", "soft skills", "oracle database administrator skills", etc.).
- If you happen to have technical certifications that are vital to the industry and really impressive, include their names within your skills section.
At times, it really is frustrating to think back on all the skills you possess and discover the best way to communicate them across.
We understand this challenge - that's why we've prepared two lists (of hard skills and soft skills) to help you build your next resume, quicker and more efficiently:
Top skills for your oracle database administrator resume:
Oracle Database Administration
SQL and PL/SQL Programming
Database Backup and Recovery
Performance Tuning and Optimization
Oracle Real Application Clusters (RAC)
Database Security Management
Oracle Enterprise Manager (OEM)
Oracle Automatic Storage Management (ASM)
Oracle Database Upgrades and Migration
Problem-Solving
Critical Thinking
Communication
Attention to Detail
Time Management
Adaptability
Proactivity
Stress Management
Continuous Learning
Listing your relevant degrees or certificates on your oracle database administrator resume is a win-win situation. Not only does it hint at your technical capabilities in the industry, but an array of soft skills, like perseverance, adaptability, and motivation.
The importance of your certifications and education on your oracle database administrator resume
Pay attention to the resume education section . It can offer clues about your skills and experiences that align with the job.
- List only tertiary education details, including the institution and dates.
- Mention your expected graduation date if you're currently studying.
- Exclude degrees unrelated to the job or field.
- Describe your education if it allows you to highlight your achievements further.
Your professional qualifications: certificates and education play a crucial role in your oracle database administrator application. They showcase your dedication to gaining the best expertise and know-how in the field. Include any diplomas and certificates that are:
- Listed within the job requirements or could make your application stand out
- Niche to your industry and require plenty of effort to obtain
- Helping you prepare for professional growth with forward-facing know-how
- Relevant to the oracle database administrator job - make sure to include the name of the certificate, institution you've obtained it at, and dates
Both your certificates and education section need to add further value to your application. That's why we've dedicated this next list just for you - check out some of the most popular oracle database administrator certificates to include on your resume:
The top 5 certifications for your oracle database administrator resume:
- Oracle Certified Professional, Oracle Database Administrator (OCP DBA) - Oracle
- Oracle Certified Expert, Oracle Real Application Clusters (RAC) and Grid Infrastructure Administrator (OCE RAC) - Oracle
- Oracle Certified Master, Database Cloud Administrator (OCM) - Oracle
- Oracle Database 12c Administrator Certified Professional (12c OCP) - Oracle
- Oracle Certified Expert, Oracle Database 12c: Data Guard Administration (OCE Data Guard) - Oracle
If you happen to have plenty of certificates, select the ones that are most applicable and sought-after across the industry. Organize them by relevance to the role you're applying for.
- How To List Certifications On A Resume (Examples Included)
- How to List Expected Graduation Date on Your Resume
Professional summary or objective for your oracle database administrator resume
oracle database administrator candidates sometimes get confused between the difference of a resume summary and a resume objective.
Which one should you be using?
Remember that the:
- Resume objective has more to do with your dreams and goals for your career. Within it, you have the opportunity to showcase to recruiters why your application is an important one and, at the same time, help them imagine what your impact on the role, team, and company would be.
- Resume summary should recount key achievements, tailored for the role, through your career. Allowing recruiters to quickly scan and understand the breadth of your oracle database administrator expertise.
The resume objectives are always an excellent choice for candidates starting off their career, while the resume summary is more fitting for experienced candidates.
No matter if you chose a summary or objective, get some extra inspiration from real-world professional oracle database administrator resumes:
Resume summaries for a oracle database administrator job
- With over 12 years of intensive experience in managing Oracle databases, I have successfully scaled and optimized high-transaction financial systems, reducing downtime by 30%. I bring a deep understanding of Advanced Replication, Oracle RAC, and Data Guard, and have a proven track record in disaster recovery planning and execution.
- As a software engineer with 8 years of experience, now specialized in Oracle Database Administration for the past 4 years, I have transitioned smoothly into the realm of database management. Expertise in PL/SQL scripting and performance tuning has enabled me to enhance database efficiency for a global logistics company by 25%.
- Coming from a cybersecurity background with 5 years of experience, I have developed a strong foundation in data protection and risk management which I've leveraged to successfully pivot into Oracle Database Administration. Acutely aware of security best practices, I pursue seamless integration of data security within database management functions.
- Eager to apply my 6 years of IT support experience to a new challenge as an Oracle Database Administrator, I possess a robust technical foundation and a keen willingness to deepen my knowledge in SQL and database architecture. Dedicated to maintaining data integrity and operational efficiency through proactive system monitoring.
- As a budding Oracle Database Administrator, I am keen on immersing myself in the intricacies of database management. My objective is to leverage my Bachelor's in Computer Science and recent Oracle certification to ensure robust, efficient, and secure databases, while actively learning from seasoned professionals.
- Looking to launch my career in Oracle Database Administration, I am committed to applying the skills from my Master's in Information Systems and recent internship where I gained hands-on experience with Oracle databases, to excel in optimizing database systems and contributing towards organizational data goals.
Extra sections to include in your oracle database administrator resume
What should you do if you happen to have some space left on your resume, and want to highlight other aspects of your profile that you deem are relevant to the role? Add to your oracle database administrator resume some of these personal and professional sections:
- Passions/Interests - to detail how you spend both your personal and professional time, invested in various hobbies;
- Awards - to present those niche accolades that make your experience unique;
- Publications - an excellent choice for professionals, who have just graduated from university or are used to a more academic setting;
- Volunteering - your footprint within your local (or national/international) community.
Key takeaways
- The layout of your resume should take into consideration your professional background while integrating vital sections and design elements;
- Highlight your most pertinent achievements for the role all through different sections;
- Be very specific when selecting your certifications, hard skills, and soft skills to showcase the best of your talents;
- Include within the top one-third of your oracle database administrator resume a header and summary to help recruiters understand your experience and allocate your contact details. A skills box is optional, but it will help you align your expertise with the role;
- Detail the full extent of your professional experience with specific bullets that focus on tasks, actions, and outcomes.
![oracle sample resume for 3 years experience oracle database administrator resume example](https://cdn.enhancv.com/predefined-examples/TqdbubGekfzQvq6VEQsivUp1KqjWFLW6PLKmtTF2/image.png)
Looking to build your own Oracle Database Administrator resume?
- Resume Examples
Can I Leave a Job I Was Fired From Off My Resume?
+20 useful chatgpt prompts to optimize your linkedin profile for the dream job, typo on your resume here's what to do., 8 persuasion techniques to change anyone’s mind, driver's licence on resume, part-time job on resume: how to include it.
- Create Resume
- Terms of Service
- Privacy Policy
- Cookie Preferences
- Resume Templates
- AI Resume Builder
- Resume Summary Generator
- Resume Formats
- Resume Checker
- Resume Skills
- How to Write a Resume
- Modern Resume Templates
- Simple Resume Templates
- Cover Letter Builder
- Cover Letter Examples
- Cover Letter Templates
- Cover Letter Formats
- How to Write a Cover Letter
- Resume Guides
- Cover Letter Guides
- Job Interview Guides
- Job Interview Questions
- Career Resources
- Meet our customers
- Career resources
- English (UK)
- French (FR)
- German (DE)
- Spanish (ES)
- Swedish (SE)
© 2024 . All rights reserved.
Made with love by people who care.
Resume Builder
- Resume Experts
- Search Jobs
- Search for Talent
- Employer Branding
- Outplacement
- Resume Samples
- Software Architect
Oracle Database Administrator Resume Samples
The guide to resume tailoring.
Guide the recruiter to the conclusion that you are the best candidate for the oracle database administrator job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.
Craft your perfect resume by picking job responsibilities written by professional recruiters
Pick from the thousands of curated job responsibilities used by the leading companies, tailor your resume & cover letter with wording that best fits for each job you apply.
Create a Resume in Minutes with Professional Resume Templates
![oracle sample resume for 3 years experience Resume Builder](https://assets.velvetjobs.com/assets/resume-icon-light.png)
- Provide development and design assistance to development and other application support teams
- Providing support to developers working on SQL, including development of best practices, hands on demos, and knowledge transfer
- Continuously manage performance through trending analysis and work with development teams on identified tuning opportunities
- Create new database systems and makes recommendations to improve the performance and efficiency of existing systems
- Provide database performance tuning, database security, and promote process improvement
- Work with the system DBAs to implement changes and performance improvements
- Analyze and Manage workloads using Workload Designer and TASM for Teradata and using Statspack/AWR reports for Oracle
- Performs database system management functions (e.g., software installs, version upgrades and configuration management)
- Not only provides feedback about the work, but can also coach associates around personnel issues with support of the manager
- Responsible for database backups, design, development, testing, and performance tuning
- Provides direction to team members as assigned by management
- Supports his/her manager with resource management responsibilities
- Provides recommendations to management on behalf of the team
- Provides hands on technical expertise, provides senior level technical guidance to staff, project leaders and other teams as necessary
- Engineering and administration of Oracle standalone and RAC clustered (11g, 12c) database environments
- Assisting with procurement of hardware, software, and services
- Researching and analyzing emerging Oracle database technologies, techniques, and protocols and making recommendations
- Providing ongoing progress to leadership, system owners, and peers regarding health of the environment and status of testing
- Supporting and documenting the implementation of approved changes to system configurations, software, and infrastructure within the approved testing schedule
- Interfacing with C2 system owners during integration testing preparation and execution
- Developing functional process diagrams for Oracle database services
- Strong experience with Oracle partitioning, Transportable table spaces Proficient in SQL. PL/SQL and shell/perl scripting
- Good knowledge of Informatica ETL (Power Center) and data quality, MDM module is
- Very good track record in Oracle database development, i.e good knowledge and practice of Oracle SQL and PL/SQL
- Exhibit strong business knowledge and build strong customer relationships
- Develop, design and maintain highly available and scalable databases
- Good knowledge on logical and physical Data Modeling using normalizing Techniques
- Database performance tuning,Trouble shooting database issues, Basic SQL and PL/SQL knowledge
- Strong customer facing technical presence with the ability to solve complex problems
- Oracle Database 11g Administrator Certified Professional certification strongly desired
- Good knowledge on all incident, change, problem management process & compliance process
15 Oracle Database Administrator resume templates
![Oracle Database Administrator Resume Sample Oracle Database Administrator Resume Sample](https://asset.velvetjobs.com/resume-sample-examples/images/oracle-database-administrator-v1.png)
Read our complete resume writing guides
How to tailor your resume, how to make a resume, how to mention achievements, work experience in resume, 50+ skills to put on a resume, how and why put hobbies, top 22 fonts for your resume, 50 best resume tips, 200+ action words to use, internship resume, killer resume summary, write a resume objective, what to put on a resume, how long should a resume be, the best resume format, how to list education, cv vs. resume: the difference, include contact information, resume format pdf vs word, how to write a student resume, senior dbluw & oracle database administrator resume examples & samples.
- Maintenance Services
- Create and maintain DB2LUW/Oracle databases, database objects, including tablespaces, tables, indexes, views, synonyms, triggers, procedures, sequences ... etc in development, test, production and disaster recover environments
- Ensure GroundWork monitoring and TSM is setup properly
- Provide consulting to developers on optimal usage of DB2LUW/Oracle features and facilities
- Provide skilled counsel in the technical design of applications. Ensure optimum use of software facilities and features; walk through critical components
- Perform physical database design; Transform logical data models into physical database structures via standard processes. Provide data modeling assistance as required
- Minimum 10 years of solid DBA experience on DB2LUW/Oracle
- In depth knowledge on database backup and recovery for DB2LUW/Oracle
- In depth knowledge on database tuning and SQL tuning for DB2LUW/Oracle
- Strong knowledge and solid working experience on DB2LUW HADR
- Strong knowledge and solid working experience on Oracle Real Application Cluster (RAC) and Data Guard
- Teamwork and Co-operation
- Excellent Problem Management Skills
Senior Oracle Database Administrator Resume Examples & Samples
- Prepare capacity planning and sizing
- Troubleshoot and resolve database issues in a timely manner
- 5 Years DBA experience in10g, 11g, 11g RAC
- Experience inOracle RACon AIX and Linux environments
- Strong performance tuning skills with 11g & 11g RACenvironments
- Experience with unix scripting
- Work in a 24x7 on-call support environment
- Expert in query, index and Database IO performance tuning
- Expert understanding of Database design principals
- Ability to manage all database maintenance plan activities including backups, indexing,
Oracle Database Administrator Resume Examples & Samples
- Review, test and deploy security best practices for Oracle technologies
- User IDs, passwords, roles and rights troubleshooting and support
- Oracle 11g and above (includes RMAN)
- EMC VMAX hardware / software
- NetApp hardware / software
- Dell OpenManage Software / Array Management software
- Windows Server 2008 or above
- Active Directory
- Microsoft SCOM 2012
- Symantec NetBackup (7.0+)
- SQL Server 2005+
- Intel server hardware (preferably Dell) and related internal and external storage hardware (RAID, SCSI, Fibre Channel, etc)
- 7+ Years production Oracle Database Administration experience
- Must have experience with Dataguard, RMAN
- Must have experience in Performance and Tuning Must have experience in Database problem resolution, dealing with Oracle, creation of SRs
- Database backup and recovery using RMAN
- Oracle database upgrades, patching Working with the client team for problem resolution, performance and tuning Database performance monitoring
- Good verbal and written skills
- Ability to operate in a high pressure, date driven environment
- Oracle database build using ASM on RAC/non-RAC
- Developing and maintaining standards (SOE) and comply with company’s Audit requirements
- 7 Years production Oracle Database Administration experience prior to leadership role
- Must have experience with Dataguard, RMAN Must have experience in Performance and Tuning
- Must have experience in Database problem resolution, dealing with Oracle, creation of SRs
- Unix Shell Scripting Strong SQL skills
- Oracle database upgrades, patching Working with the client team for problem resolution, performance and tuning
- Database performance monitoring
- Smooth verbal and written skills in English
- Strong project management skills
- Ability to operate in a high pressure, date driven environment Oracle database build using ASM on RAC/non-RAC
- LI-MK1* Requirements
- Senior-level knowledge and experience as a Professional DBA (Oracle 10g, 11g) with very good knowledge and experience in some of the following disciplines
- Work experience on Oracle 11g RAC and ASM
- Usage of Dataguard
- Usage of RMAN ( Restore/Backup)
- Usage and understanding of Grid Control / DB Monitoring
- Working experience in Unix/Linux
- Good SQL and basic scripting language (Perl, shell) knowledge
- Ability to interact with projects and application development with strong focus on customer requirements
- Multiyear IT infrastructure operations and/or Engineering background as technical expert, ideally in the field of project, requirements management or application security
- Dedication and passion for operational effectiveness and for managing & continuously improving service quality together with internal partners and suppliers
- High level of flexibility, energy and team spirit
- Fluent written and spoken English (German - optional)
- Installing, deploying and upgrading production and non-production databases
- Testing new RDBMS features for later integration into infrastructure and applications
- Monitoring database availability and performance
- Refreshing Non-production environments with data from production databases
- Recommending system hardware and software configurations for given data processing loads
- Analyzing storage options, recommends storage hardware and configuration for optimal DB performance
- Managing user access rights and user resource quotas
- Participating in weekly DBA on-call rotation, supporting production environment
- Ability to self-initiate, prioritize and execute effectively in a dynamic work environment with multiple concurrent demands
- Partner with product teams to find solutions for projects and operational issues
- 6 years of Oracle DBA experience
- Proven experience maintaining and supporting critical production systems
- Proven experience maintaining Data Warehouse or/and Analytics databases
- Proven experience with Oracle Data Guard physical and logical standby databases
- Proven DBA level knowledge of Unix fundamentals and shell scripting
- 10 years of Oracle DBA experience
- Experience with other RDBMS databases like postgres, vertica, mysql etc
- Experience with performance tuning/query optimization
- Contributes to open source community
- Install, configure and maintain Oracle 11g and 11g RAC databases
- 5+ Years DBA experience in10g, 11g, 11g RAC
- Experience in Oracle RAC on AIX and Linux environments
- Strong performance tuning skills with 11g & 11g RAC environments
- Day to day monitoring and operation of the Oracle RDBMS and certain associated applications
- Some out of hours and weekend working will be required
- Production support and also work closely with development and application support teams so that we build reliable, scalable and compliant RDBMS environments for our customers
- Investigate and address issues
- Participate on call
- Participating in COB tests
- Cooperating with other technology teams; ISA, TCU and Clients
- Troubleshoot and fault fix in complex environment
- Provide overnight and out-of-hours suport
- Database Migration Reviews and Agreements with Tech Business Partners prior to Production cutover, Impact Analysis & Remediation for all Business Impacting Incidents
- Provide expert Client Delivery Support for new DB technologies
- Database Administration for Oracle database server installations
- Analyzing performance and tuning
- Providing overnight and out-of-hours support
- Database Migration Reviews and Agreements with Tech Business Partners prior to Production cutover,
- Impact Analysis & Remediation for all Business Impacting Incidents,
- Provide Client Delivery Support for new DB technologies
- Collaborate with Shared Services, CATE and Product Vendor to improve stability, monitoring & new features in DB products
- 5-7+ years of Database Administration experience in a large enterprise environment
- Requires good communication skills to work closely with Project Managers, System administrators, Solution Architects, Application Development teams, and other teams as necessary to complete the database projects
- Participation in drawing up new standards (where appropriate) to ensure that best practices are applied
- The ability to work independently and on a team
- Ensure that the databases are in line with compliance rules and standards; Investigate and address issues
- Collect evidence for compliance tasks
- Provide on call support
- Set up monitoring tools
- Set up backup jobs
- Participate in COB tests
- Perform VA remediation
- Cooperate with other technology teams
- ISA, TCU and
- Resolve moderate to complex database performance issues, database capacity issues, replication, and other distributed data issues
- Consult with application development teams on database administration considerations
- Building databases
- Be responsible for space management, back-up, monitoring, and maintaining ongoing performance of databases
- Help design technical solutions and prepare implementation methods to be performed
- 5-7 years of verifiable experience administering, 24x7 uptime Oracle databases as a Systems/Infrastructure DBA
- Experience working with Oracle versions 10g, 11g and 12c (preferred) in a UNIX environment a must
- Strong, proven Oracle Database Performance Tuning skills (logical and physical)
- Strong programming experience in PL/SQL and UNIX shell scripting
- Experience with features such as Oracle Real Application Clusters (RAC), ASM, Oracle Data Guard and Oracle Enterprise Manager (OEM) is desired
- Experience with Backup and Recovery using Oracle RMAN and supporting software suites
- Experience with issue resolution via My Oracle Support
- Proven problem solving skills and the ability to work collaboratively with other departments to resolve moderate to complex issues with innovative solutions
- DBA experience with Teradata is a plus
- Oracle Database Certifications as appropriate
- College degree in Engineering, Computer Science, Information Systems, related field, or equivalent work experience
- Implement variety of data models, database designs, data access, and table maintenance codes
- Resolve complex database performance issues, database capacity issues, replication, and other distributed data issues
- Develop updates or modifications according to business needs
- Monitor and review the work of other database administrators to ensure correct practices and procedures
- Design technical solutions and prepare implementation methods to be performed by self or other DBA team members
- Provide support and back-up for management as required
- Assist with work plan development and work distributions for team members
- Provide incident and problem management support, including 24x7 pager support rotation responsibilities
- 5 - 7+ years of verifiable experience administering various multi-Terabyte, 24x7 uptime Oracle databases as a Systems/Infrastructure DBA
- Experience working with Oracle versions 10gR2, 11gR1/2, 12c in a UNIX environment a must
- Experience with features such as Oracle Real Application Clusters (RAC), ASM, Oracle Data Guard and Oracle Enterprise Manager (OEM) is required
- Experience with Backup and Recovery using Oracle RMAN and supporting software suites, particularly EMC Networker, EMC Data Domain and EMC Avamar. Must have a solid understanding of VTL, EDL, Tape Cloning and EMC SAN storage technologies (Symmetrix, Clariion, Celera, Centera and VMax)
- Experience with Database security, access management and monitoring. Experience with Oracle Advanced Security is desirable
- Experience with fulfilling regulatory compliance auditing and evidence collection (Sarbanes Oxley and PCI) and audit/database logging
- Ability to plan and support Oracle database hardware and software upgrades and patching
- Escalate and follow through on issues created with the database vendor
- Demonstrated ability to prioritize a work load and meet project deadlines
- Oracle Database Certifications as appropriate are preferred
- Familiarity with Business Objects ad-hoc workloads (or other B.I. tools such as Cognos/MicroStrategy)
- Familiarity with automated scheduling tools like CA Workload Automation Server, WAS (dSeries/Autosys)
Lead Oracle Database Administrator Resume Examples & Samples
- Implements data models, database structure design, backup and recovery processes
- Installs and maintains development and production databases (e.g., SQL Server databases)
- Designs, enters, audits and maintains small-scale to large-scale databases
- Responsible for verifying all data to be entered into database meets set standards and requirements
- Identifies, tests and resolves complex database issues (e.g., monitoring and tuning)
- Defines, recommends and develops database standards, procedures and architecture
- Designs data models and DW database designs
- Participates in a 24x7 production support on-call rotation
- Performs SQL Code Index Reviews
- Ensures optimal performance and availability of databases
Oracle Database Administrator, Mid Resume Examples & Samples
- 4 years of experience with Oracle Database Administration (DBA) responsibilities, Oracle 10g and above
- Experience with Oracle SQL dialect and optimizing complex SQL queries
- Experience in working with Oracle 10g in a Windows Environment, installation, upgrade and patching
- Experience with presenting technical concepts to technical and non-technical senior audiences
- Develop new or maintain existing programs based on specifications
- Develop, implement and maintain unit tests of programs
- Participate in the design of new or changing programs
- Share knowledge by effectively documenting work
- Work with the team to ensure the quality of the assigned application(s), functional area(s) or project(s)
- Resolve database performance issues, database capacity issues, replication, and other distributed data issues
- Manage security of database structures and corporate data held within databases
- Assist in the definition and implementation of database standards
- Monitor databases for errors and perform problem determination when necessary
- Design and implement highly available production systems using the following technologies: DataGuard, Oracle Streams, Golden Gate, Real Application Cluster (RAC) and Oracle Enterprise Manager
- 5-7 years’ experience in Oracle database technologies
- Strong understanding of Oracle RDBMS architecture
- Prior experience writing PL/SQL triggers and/or procedures
- Experience with the following Oracle technologies a plus: Streams, DataGuard, RAC, Golden Gate, Oracle Enterprise Manager, and Snapshot replication
- Working knowledge of LINUX and shell scripting
- Experience configuring database network connectivity
- Understanding of database backup and recovery techniques using RMAN and Network Appliance filers
- Experience with high volume websites that use multi-tier architectures a significant plus
- Willingness to learn additional database platforms such as Netezza, MySQL, etc, as needed
- Provides feedback to manager regarding associates’ performance; can help support associates with IDP’s and other development objectives; participates in talent review discussions
- Review database design and stored procedures, and recommends opportunities for enhancement
- Defining, documenting and maintaining Oracle DBA team processes
Oracle Database Administrator / Specialist Resume Examples & Samples
- Be a technical expertise for Oracle or DB2 or SQL database server
- Be a consultant in the reviews, planning, testing, and execution of business applications and database upgrades
- Advise management on technical application and database issues as related to corporate business rules, practices, and changes
- Supporting day-to-day operation incident and change
- With pro-active tool, monitor, evaluate (performance, availability and reliability) and suggest for system health status and improvement
- Investigating and coordinating with peers/cross team to perform root cause analysis and provide a good solution for quick win and long term
- Collecting history of performance data to produce and suggesting for performance tuning and capacity planning
- At least 3 years' experience in Oracle database administrator
- Strong technical and analytical, troubleshooting and leadership skills
- Able to deal and handle difficult situations and work under time constraints
- Good team player, Service oriented and Ability to work in fast placed environment
- At least one database certification will be an advantage
- Thai & English speaking is a must
- At least 6 years experience in At least 6 years' experience in Oracle or DB2 or SQL database administrator
Soft Layer Oracle Database Administrator Resume Examples & Samples
- Experience administering Oracle8i -11g and other Relational Database Management System (RDBMS) including MySQL
- Experience in shell scripting
- Knowledge and experience in database security management
- Knowledge and experience in database performance tuning principles
- Ability to handle multiple/conflicting projects and deadlines
- Ability to work on call and provide 24/7 production support
- Proven communication skills with management, development teams, vendors and systems administrators
- At least 5 years experience in Oracle DBA
- At least 3 years experience in Oracle RAC
- Support, administer and maintain production and non-production database environments primarily running on the AIX platform
- Deploy and maintain high availability & failover technologies such as Data Guard and Real Application Clusters to maximize database availability
- Create, clone and upgrade environments to support implementation activities as required
- Define, implement and support Backup and Recovery policies using RMAN and/or storage level replication technologies
- Work with the development and application support teams to identify, triage and resolve performance issues using diagnostic tools such as AWR, ADDM etc.
- Analyze, optimize and tune advanced complex SQL queries and their associated execution plans using command line tools
- Perform database restore and recovery in the event of an outage
- Define, implement, and enforce security standards for the database in compliance with company policies as well as compliance frameworks including SOX and PCI
- Work with the appropriate teams (Security, Compliance, Internal Audit, and External Auditors) to review security policies, participate in annual audits, and implement the appropriate remediation measures
- Contribute to, and update systems documentation as required
- Participate in 24x7 support rotation
Junior Oracle Database Administrator Resume Examples & Samples
- 3 years of experience with Oracle Database Administration (DBA) responsibilities, Oracle 10g and above
- Experience with Oracle PL/SQL and creating and debugging stored procedures
- Experience with performance tuning an Oracle database for medium data sets
- Experience with Oracle features and options, RMAN, Oracle Enterprise Manager, and Oracle Advance Security
- Manage the routine operations for both development and production databases
- Monitor the health of servers and the databases running on them
- Submit service requests to software vendors and drive resolution through to completion
- Ability to perform after-hours, and / or weekend support for key deployments
- Will be responsible for managing and providing solutions to the customer’s Oracle Database/Application/Fusion applications
- The member will require to upgrade Oracle Application 11i, R12
- Upgrade Oracle database to 11g, 12C
- Help to architect, build and support highly-available Oracle EBS R12 environment
- Create R12 clones, Apply patches on Application/Database
- Support Application/Database DR system(ADG/DG)
- Configure DMZ for the external facing customer applications like iSupplier, iReceivable
- DBA will be responsible for implementation of Fusion Applications like HCM/Finance, or standalone fusion applications like Discoverer, BI Publisher, GRC
- Troubleshoot and resolve problems by directly coordinating with third party application vendors
- Provide on-call support as scheduled by monitoring pages, tickets, and notifications
- Ensure appropriate configuration and monitoring are enabled and monitor the health, performance, and capacity of the applications under normal and peak load times
- Implementation and support of large Oracle EBS environments
- Enterprise Manager Grid Control
- Backup and recovery concepts and RMAN
- Data warehousing and OBIEE
- Performance problem identification and remediation
- Ability to provide accurate and realistic effort estimates, commit and deliver accordingly
- Proven analytical and problem solving skills; creative thinking
- IT engineering experience supporting projects and systems of similar size, scope and technical complexity to those supported under this contract
- Oracle DBA and production support experience, including Oracle 10g and 11g
- Oracle Apps DBA with Oracle EBS 11.5.10 and R12 Strong understanding of Oracle RDBMS architecture
- Experienced with Oracle Identity Management product suite
Senior Oracle Database Administrator, VP Resume Examples & Samples
- Work with PMs, Production Support teams on projects and production support related issues in Dev/QA/UAT/Prod/DR environments
- Perform database backups/refreshes
- Participate in Follow-the-Sun support rotation
- Support and troubleshoot GoldenGate replications & Veridata
- Minimum of 10+ years experience administering various multi-Terabyte, 24x7 uptime Oracle databases
- Team player. Should be flexible and willing to work off-hours if needed
- Assisting in planning and implementing Oracle database and application changes
- Working with developers to define and maintain an Oracle environment for application development and testing
- Consulting with the DAs during physical design
- Planning and implementing structure and data changes
- Troubleshooting and tuning performance issues
- Managing security
- Helping application teams understand and use Oracle features
- Maintaining and contributing to internal team-knowledge documents
- Evaluating new Oracle database products and features
- Developing and reviewing adherence to these standards and procedures
- Providing on-call work in rotation and occasional scheduled off-hours work (Will be required to carry cell phone with laptop for after-hours / weekend on-call support.)
- Experience with Microsoft SQL Server is desirable
- 24x7 Production support responsibilities for critical servers
- May be required to work weekends, off hours, holidays and carry a pager
Engineer Oracle Database Administrator Resume Examples & Samples
- Thrive in a DevOps environment working closely with other engineers to deploy multi-terabyte Data Warehousing systems designed for production that create less unplanned work
- Deploy new databases and upgrade existing to 11.2.0.4
- Maintain stability and security by routinely applying Quarterly PSUs
- Troubleshoot performance problems with Oracle EE, RAC, ASM, Data Guard, Golden Gate
- Troubleshoot and maintain performance using SQL Plan Management
- Proactive tablespace management with and without ASM
- Support and troubleshooting of backups via RMAN and Netbackup
- Utilize Continuous Process Improvement / Kaizen methods to reduce waste
- Provide capacity planning of system resources to support database growth
- Investigate and provide thought leadership into leveraging Cloud-based solutions, 12c, Exadata, Connectors to NoSQL or Hadoop
- Bachelor’s degree in Computer Science or related field, or equivalent training and experience
- 5+ Years of Oracle 10g and 11g experience on large Data Warehouses (>5TB)
- 3+ Years of Oracle ASM experience
- Oracle Certified Professional (OCP) on 10g or higher a plus
- Oracle Golden Gate and Data Guard Experience required
- Oracle RMAN Experience
- Solaris/Linux OS Experience
- Strong UNIX scripting and troubleshooting skills
- Oracle GoldenGate a plus
- Ability to troubleshoot and manage Oracle databases outside of Oracle Enterprise Manager
- Chef, Puppet, CF Engine Experience or other automation tool a plus
- Strong communication skills with the ability to transcend the organization with appropriate levels of detail
- Proven record of learning and succeeding with Oracle and non-Oracle databases
Rohq Cti Oracle Database Administrator Resume Examples & Samples
- Ideally a degree in a Computer Science discipline or equivalent work experience
- Strong understanding of architectural concepts and design in Oracle database version 11g and DB2 V9 databases
- Strong understanding of High Availability technologies like Oracle RAC, HACMP and VERITAS
- Experience in patching DB2 databases in AIX/Linux
- Experience in upgrading oracle and DB2 database to different version and migrating to different platforms
- Experience to detect and repair out of sync conditions when necessary
- Perform routine backup and recovery for data protection and integrity for Oracle and DB2 Databases using tools like Net backup, RMAN
- Experience in working Incident management and Change Management tools like Service Now
- Minimum 8 years' work experience in Oracle RAC Database Administration. Oracles EBS support experience is required
- Familiarity of the Data Movement utilities
- Familiarity with Database Appliances such as Exadata
- Good Knowledge of Golden Gate Replication and Unix scripting
- Experience in Informix/SQL server/MySQL Administration is a plus
- Oracle Streams is a plus
- Good understanding of the Linux/UNIX environments. Preferably Redhat Linux and IBM/AIX
- A bachelor’s degree in Engineering or Computer Sciences or related field required
- Support Oracle database - provide 24X7 support for Oracle environment including upgrade, patches, troubleshooting, cloning, and working with application teams and business customers
- DBMS features exploitation and manage database alerting /monitoring and automation process
- Oracle DBMS 10g and up
- Translate complex technical concepts into easily understood explanations and influence decisions to ensure enterprise benefits
- Oracle RDBMS 11g&12c product implementation, upgrades, architecture and performance tuning
- Oracle Grid 11g&12c and ASM product implementation, upgrade, architecture and performance tuning
- Understanding of security concepts
- Minimum of 8 years experience supporting Oracle RDBMS
- Minimum of 1 - 2 years experience supporting replication with GoldenGate
- Experience in using automation tools (i.e. Chef, OEM) a plus
- Understanding of software development methodologies and practices including agile development and continuous integration (CI)
Senior L Oracle Database Administrator Resume Examples & Samples
- Identify and proactively resolve issues that could impact system performance, reliability and usability
- Manage activities ensuring adherence to Information Security Policy, CITMP policy and corporate standards
- Oracle Subject Matter Expert (SME) for specific DB related areas (i.e. Security, HA, etc.)
- Plan contingency concepts
- Knowledge of these technologies preferred
- Re-creation, analysis, troubleshooting, and diagnosis of incidents relating to platforms and/or application environments
- Determination of root cause of platform specific incidents
- Selects appropriately from applicable standards, methods, tools and applications and use accordingly
- Good appreciation of wider field of information systems, its use in relevant employment areas and how it relates to the business activities of the employer or client
- Demonstrable experience administering and supporting Oracle 11gR2/12c
- Experience with Oracle data guard and replication
- Demonstrable knowledge of UNIX shell scripting, PLSQL, and SQL
- Understanding of various application, authentication and encryption protocols i.e. SSL, SOAP, LDAP, etc
- General understanding of networking/LAN/WAN/DMZ concepts
- Experience with clustering technologies
- Experience supporting applications, platforms, and/or services in shared or virtual environments
- At least 5 years experience in Oracle 11g
- At least 3 years experience in Oracle (Grid Infrastructure / Computer Reservations System) aka RAC
- At least 2 years experience in Oracle Cloud Control 12c
- At least 2 years experience in Red Hat Enterprise Linux 5.8 and 6.2
- Oracle RAC highly available databases
- Server Configuration
- Database Resource Management; space, memory, etc
- SAN design and maintenance
- 5 years of technology management in the Financial Services or related industry experience. Background in database technology and architecture. Intermediate knowledge with the following technologies: Oracle databases, ODBC, Linux, SQL, and n-tier application models. Experience with Sybase, SQL and DB2 is a preferred
- Analyze existing database systems and recommend improvements
- Configure and administer Oracle database servers and work with Garmin Connect database
- Provides and must be willing to support Oracle, SQL Server, and MySQL
- Work with IT Manager to establish database security structures, Sox compliance
- Create and maintain database access systems including tables, indexes, views, stored procedures, and triggers
- SQL tuning and optimization
- Provide 24x7 on call support- 6-7 week rotation
- Bachelor’s Degree in Computer Science, Information Technology, Management Information Systems, Business or another technology related field AND 2 years relevant experience OR an equivalent combination of education and relevant experience
- BI-Data Analytics understanding
- MUST be willing to work with/support Oracle, SQL Server, and MySQL
- Outstanding academics
- Demonstrated experience in successful implementation of technology solutions
- Experience with Internet and Intranet database connectivity
- Experience with Oracle database High availability (RAC/ASM/Dataguard)
- 5-7 years of proven experience of support Oracle DB’s in a telecom production environment
- Deploy new versions of the Oracle RDBMS and its tools
- Implements and enforces security for all of the Oracle Databases
- Works with development team to evaluate releases of Oracle and its tools, and third party products to ensure optimal production performance
- Responsible for and serves as the SME for troubleshooting, triage and getting DB’s back online in the event of an outage or impact
- Good Presentation Skills
- Follow strategic technologies, standards and procedures
- Oversee projects (business and technology initiated, from design as well as managing life-cycle), controls and compliance and ensure participation and escalation of relevant issues globally, build business relationships with business, follow global initiatives
- Handle all Client Requests, Work closely with Clients for New Projects from Initiation to Production cutover Identify cost saving opportunities & implement innovative DB solutions for clients (collaborate with Infrastructure Delivery team as needed)
- Constantly monitor architecture of the DB environments (COB, High Availability, Replication, Backup Strategy/Retention) to identify opportunities for improvements
- Work closely with Clients to remediate gaps/exposures identified by Proactive Reports
- Provide guidance to Application teams to remediate Compliance exposures
- Provide Query tuning suggestions to Application teams to improve Application performance (collaborate with Support team as needed)
- Deploy VTM patches and upgrades on DB environments
- Test and Implement new features in non-Production environments as per Client needs/requirements
- Provide overnight and out-of-hours support
Advisory Oracle Database Administrator Resume Examples & Samples
- Identify server hardware, software and configurations necessary for running Oracle in an optimal fashion
- Develop new processes, utilize and refine existing processes for database software installation and configuration
- Enforce and refine database standards
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, preventing customer impact
- Review performance stats, recommend changes for tuning database, server, and storage configurations
- Participate in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up
- Assume ownership of database related problems; pursue problem resolution and root cause analysis
- Coordinate interaction with vendors in critical database problem situations
- Participate in a 24X7 pager rotation
- Maintain current knowledge of industry trends and standards
- Develop a thorough knowledge and understanding of cross system interactions
- Signifiant Oracle DBA experience on Linux/Unix
- 8 year's experience as DBA
- 3 years on Unix platforms - experience with Linux required
- Oracle Linux – OS on Exadata
- At least version 11G, 12C would be ideal – upgrade path
- System Admin. experience required
- Experience with Hardware, OS, Networking
- Patching/Upgrading with minimal downtime
- Experience deploying and supporting Oracle Exadata Database Machine preferred
- Well versed with all advanced features of Oracle including RAC 11g +
- Disaster Recovery (Active Data Guard, Golden Gate)
- Knowledge of DB Tools/Utilities (e.g., Toad, Enterprise Manager 12c, Utilities, SQL Developer )
- Understanding of industry best practices pertaining to Oracle
- Thorough understanding of Oracle connectivity at a logical and physical level
- Must have strong analytical and problem solving skills
- Proven ability to work independently or as an integral member of a team
- Experience and willingness to teach/mentor others in I.S
- Strong ability to prepare and present technical documentation
- Ability to communicate in a professional manner when interacting across staff levels and internal/external customers
- The DBA should be capable of working independently as well as operating in a team environment, with a willingness to follow pre-defined IT policies to satisfy our clients
- Ability to understand clients needs and suggest solutions and help the clients meet their deadlines
- 8+ years core Oracle DBA experience on Oracle 10g, 11g, 12c, and Oracle 11g/12c RAC/ASM
- Strong in AIX and/or RedHat Linux cluster configuration, monitoring and scripting
- Strong experiences in handling large databases (~20TB) and high transactional volume (> 1TB/day) support
- Strong Client Communication skills
- Provide 3rd level technical Database support for database systems and user problems including global data Replications
- Ensure production incidents reporting is done correctly
- Perform database upgrades
- Perform database migrations from one infrastructure host to another
- Installation and setup of oracle RAC / Non-RAC databases
- Participate in major infrastructure events like powerdown , disaster recovery tests etc.
- Provide 24/7 support of production database environment to ensure the highest availability, integrity, security and performance of our Oracle business systems
- Perform database installation and configuration according to best practices and corporate standards
- Manage and maintain access privileges to databases ensuring segregation of duties and management over privileged accounts
- Monitor databases for resource utilization, providing trend analysis and forecasting of resource requirements
- Assist with implementation and testing of database upgrades and 3rd party software
- Monitor and optimize the performance of the databases
- Plan, perform and test backup and recovery methodologies
- Participate in the design, development, testing, implementation and maintenance of database structures
- Assist developers and users in process enhancements and efficiencies of Oracle based business applications
- Create and maintain departmental documentation to ensure maximum cross training and competency across the team
- Requires a Bachelor’s degree in information technology or related field and a minimum of 5 years of related experience
- Experience with Oracle 11g/12c Database Administration and Management on AIX platforms. Proficient with Unix commands and shell scripting
- Experience with backup and recovery procedures using RMA, Flashcopy software a plus
- Oracle Database Tuning and Performance - usage of Statspack, AWR, ADDM, ASH and native Unix commands
- Requires excellent analytical skills and attention to detail. Due to the dynamic nature of the business, self-motivation and the ability to learn quickly are essential
- Proficient in Structured Query Language (SQL)
- Experience in managing partitioned databases, databases over 1 Terabyte, and large number of database simultaneously
- Experience working on cross functional teams, multitasking and managing time independently with little direction
- Excellent communication, organizational and interpersonal skills are required
- Experience with Data Guard, Cloud/Grid Control, Oracle Gateway and Toad are a plus
- Ability to work in both a team environment and independently
- Experience in SQLServer Database Management a plus
- Have SQL and PL/SQL knowledge
- Good hands-on knowledge in Installing and administrating Oracle 10g/11g
- At least 4 years experience in Oracle
- Administer and maintain the security and integrity of the databases. Design database maintenance and upgrade processes and provide incident/problem management support
- Administration, performance monitoring, reporting, and tuning of Oracle databases
- 5-7+ years of Oracle Database Administration experience in a large enterprise environment
- Experience administering various multi-Terabyte, 24x7 uptime Oracle databases as a Systems/Infra DBA required
- Strong programming experience in PL/SQL and UNIX Shell Scripting and/or Perl is preferred
- Must have strong experience and working knowledge of Oracle RAC 11g Golden Gate in Linux/UNIX environments
- Experience upgrade and configuring GoldenGate on Cluster Environment
- Proficient in new Installation and implementation of GoldenGate: Initial load, direct load, exp andimp with SCN
- Proficient in Golden Gate(GGSCI) basic processes validation
- Proficient in troubleshooting: Repcat, Extract, Abend scenarios, data issues with developers and application teams as necessary, check source from Repcat, missing archive files, and etc
- Experience to use of GoldenGate Macros
- Experience to setup or switchover GG process on Disaster Recovery when switched over from Primary site
- Experience in GoldenGate performance tuning like split Repcats, use batch SQL, server load and underlying object partitions
- Nice skills to have - Good experience with one or more scripting platforms: Shell Scripting, Perl/Python, SQL
- Excellent Communication Skill and Customer Interfacing
AM Tech-oracle Database Administrator Resume Examples & Samples
- Server Monitoring
- Product Version Management
- Database Access
- Migration of Oracle databases from one platform to another
- Extensive experience in Oracle database administration in high availability production environments
- Experience in Oracle 11g and 12c administration, Familiar with other DB eg. MySQL SQL scerver, DB2 is a plus
- Expertise in database capacity planning, space management and storage allocation
- Customer service oriented, strong analytical, problem-solving and conceptual skills. A solid understanding of business functions, systems and data management
- Demonstrates solid communication and interpersonal skills
- Above average documentations skills required
- Displays high attention to problem description, detail, and impact
- A high degree of database skills
- 7+ years of database management skills
- Proficiency in all areas of database management
- Ability to resolve difficult production support issues
- Able to work independently on challenging assignments
- Provide high quality deliverables for tasks assigned
- Bachelor's degree or equivalent relevant work experience required
- Database Administration task such as partitioning, performance tuning, space management and change control
- Document and understand ERP and custom developed backend application, data elements and business value associated with backend data elements
- Setup development standards, naming conventions and jobs scheduling
- Adjust to changing business needs, quickly
- Gather statistics related to backend jobs and analyze statistics
- PL/SQL, SQL , UNIX script performance tuning
- Create, refresh and maintain production/QA/development databases
- Off hours support (including weekend) on a rotation basis within the team
- 5-7+ years of working experience in Oracle Database Administration / Engineering
- Extensive experience with performance tuning and change management
- Experience working with multi-terabyte oracle databases with a large transaction volumes
- Minimum of 3+ years of experience with OEM 11g or 12c
- Minimum of 3+ years SQL PL/SQL coding and performance tuning
- Minimum of 3+ years of experience with UNIX scripting (K-shell)
- Experience with database security is preferred
- Team Player with the willingness to collaborate with other technical and non-technical partners
- Ability to understand the impact of problems on overall database infrastructure
- Ideal candidate will be able to design, architect, engineer, set-up and trouble shoot a complex Oracle environment that uses Oracle RAC, ASM, RMAN, Data Guard, OEM and 11g technologies
- Experience in Linux or Red Hat, performance tuning and backup and recovery are also required
- Will perform the role as Master Database Administrator and SME for the customer and function as the team lead for the contractor DBA team
- Monitors database activity and file usage, and ensures necessary resources are present
- Determines data to collect and analyzes information as appropriate. Investigates and resolves technical database issues of significance
- Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes. Limits database accessibility based upon information security level and ensures data spillage from more secure to less secure databases does not occur
- 6 years experience in Oracle Database Administration. 10 years of experience preferred
- Leadership skills to guide work teams
- Senior Oracle DBA experience and mentoring or management experience
- Overseeing daily activities, providing technical guidance to the DBA staff and assisting the project manager with making technical decisions and evaluation of schedules and database designs
- Requires strong Oracle DBA experience with Oracle 11g and OEM, ability to perform and oversee database patching and installs, mentor developers and DBAs on development best practices including performance tuning
- Functions as a technical project leader or provides work leadership for less experienced personnel on a portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies
- Oversee the daily DBA activities to ensure work is completed timely, accurately and according to standards
- Create and maintain performance benchmarks and metrics as well as make recommendations on application specifications for optimal database performance
- Oversees the analysis and determination of database performance characteristics, informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases
- Develops and implements standards and procedures to improve team efficiency and accuracy
- Provide database administration for development environments
- Responsible for all aspects of DB administration such as maintain, monitor and troubleshoot databases
- Provide technical expertise in database area throughout the life cycle of the projects, propose and implement enhancements to improve performance and reliability
- Experience working with computer hardware and software installation/upgrading procedures
- Experience working with computer hardware and software installation/upgrading procedure
- Advanced Procedural Language (PL/SQL) experience and knowledge with Data Management Tools; TOAD and OEM (11g)
- 5+ years of experience writing and tuning Oracle PL/SQL packages and stored procedures
- 2+ years of experience installing and patching Oracle RAC environments
- Oracle knowledge of programming language and working with multi-tiered applications
- Experience in Oracle performance tuning
- 5+ years in administering Oracle databases in large distributed environments supporting and administering databases with millions of rows of data
- 5+ years of experience administering Oracle database using clustering
- 5+ years of related work experience Certified as an Oracle Administrator
- Six or more years of experience in development and design of database strategies; monitoring and improving database performance and capacity; data recovery; planning for future expansion and implementation of database changes as submitted by the development team and general administrator support
- 5+ years of experience analyzing and tuning PL/SQL and SQL scripts for performance
- Proven experience working in Oracle 11g environments
- 2+ years of leadership experience guiding work teams as a Senior DBA or Lead DBA
- System Administrator is to perform both technical and a coordination role in the solution construct, trouble shooting, planning, implementation and managing complex Solaris environment
- Preferred Professional and Technical Expertise
- Good knowledge of Unix and shell scripting , Expertise in administering RAC/ASM OR Dataguard - Handling database Corruption issues
- Experience in Oracle 11g and 12c administration, Familiar with other DB eg. MySQL SQL server, DB2 is a plus
- Expertise in establishing and implementing system backup/recovery policies and procedures
- Extensive experience in database cross-platform migration and integration
- Extensive experience in working with software vendors and resolving licensing issues
- Oracle DB administrator certified
- Exhibits solid problem solving and analytical skills
- Is self-motivated, goal oriented and customer service oriented, a fast learner willing to take the initiative to learn and be a team player
- Training on exadata and ODA
- Investigating database performance and tuning
- Responding to escalations from the L1/L2 team
- Providing backup and recovery
- Oracle advanced administration on Unix and Windows platform, engineering & administration of software, security, releases & fixes, backup & recovery procedures
- Project support and consulting
- Knowledge of other database technologies (SQL Server, Sybase, DB2...)
- Official certification for database technology
- ITIL methodologies knowledge
- You will be involved in RCA preparation, mentoring and up skilling DBAs ,contributing in technical initiatives and Installing, Configuring and troubleshooting RAC, Data guard and replication
- Usage of data dictionary views, Expert in database administration (undo, redo, space, memory management)
- Expert in troubleshooting issues, advanced Backup and recovery using RMAN
- Preparing and reviewing complex change plans, expert in database performance tuning
- Implementing Best practices Performing technical deep derive
- RCA preparation , Mentoring and up skilling DBAs, Contributing in technical initiatives
- Oracle Certification (OCP,OCM, OCE) , Working Knowledge of 11g , Use of problem and change management tools, Installing, Configuring and troubleshooting RAC, Data guard, Replication
- 5 to 15 years.ERBP
Senior Oracle Database Administrator RAC Clustering Resume Examples & Samples
- Maintain optimal database configuration (parameters)
- Backup and restoration
- Disaster recovery design
- Follow strategic technologies, standards and procedures,
- Oversee projects (business and technology initiated, from design as well as managing life-cycle), controls and compliance and ensure participation and escalation of relevant issues globally, build business relationships with business, follow global initiatives,
- Handle all Client Requests, Work closely with Clients for New Projects from Initiation to Production cutover Identify cost saving opportunities & implement innovative DB solutions for clients (collaborate with Infrastructure Delivery team as needed),
- Complete regular Capacity Review and growth across all Applications supported
- Constantly monitor architecture of the DB environments (COB, High Availability, Replication, Backup Strategy/Retention) to identify opportunities for improvements,
- Work closely with Clients to remediate gaps/exposures identified by Proactive Reports,
- Provide guidance to Application teams to remediate Compliance exposures,
- Provide Query tuning suggestions to Application teams to improve Application performance (collaborate with Support team as needed),
- Deploy VTM patches and upgrades on DB environments,
- Test and Implement new features in non-Production environments as per Client needs/requirements,
Oracle Database Administrator, Blizzard China Resume Examples & Samples
- Collaborate with development teams on the design and implementation of database services, data stores, stored procedures, and replication
- Act as an interface for Battle.net development teams with database technology providers and guide use of new database technologies and features
- Administer Oracle standalone, RAC, and ExaData systems
- Manage application and user permissions
- Write and code review DDL and DML
- Continuously identify optimizations to existing database queries, jobs, and processes
- Investigate performance anomalies and perform root cause analysis for databases and their interface
Senior Oracle Database Administrator RAC & Enterprise OEM Resume Examples & Samples
- Demonstrated experience in design/build for OEM environments, with OEM 12c experience preferred
- Experience in Oracle 11 and 12 c. MSSQL 2012 and 2014. MongoDB 2.6 and 3.0
- Manage and maintain Oracle RAC, Oracle OEM, MongoDB and MSSQL database servers across multiple cloud environments
- Experience working with MSSQL Server 2008 R2, 2012 and 2014 with high availability, always on and replication is a plus
- Experience with the operation and maintenance of ESXi servers and virtual machines in a cloud as a service setting is a plus
- Research and resolve oracle, mongodb and mssql software and database problems
- Establish and maintain backup and recovery processes across all DB platforms
- Establish database security procedures
- 3+ years of experience in design/build for OEM environments, with OEM 12c experience preferred
- Oracle Database backup and recovery using RMAN
- Strong background in replication technologies is desirable. Knowledge of additional DBMS’s such as oracle is a plus. Must have strong UNIX/AIX background. Experience with Atlassian on Demand CI using JIRA
- Experience in managing MSSQL Server databases is a plus
- Oracle production support experience for 4 plus years
- Patch Oracle to minimize security vulnerability
- Technical Operating System knowledge on AIX and Linux
Principal Oracle Database Administrator Resume Examples & Samples
- Work closely with software engineers, and other DBAs, to optimize, tune, and scale our Oracle RDBMS infrastructure
- Proactively analyze database metrics and run-time telemetry, to optimize queries, jobs, and processes
- Respond to database related alerts and escalations and work with engineering to troubleshoot
- Help come up with strategic solutions to recurring problems
- Perform research to acquire new knowledge necessary to complete major projects and maintain the technological evolution of current, as well as future, products
- Be an Oracle guru and advisor across all of Blizzard, as necessary, for best practices for environments that will operate under extreme load scenarios. You'll be so awesome that some other teams that use Oracle may want some of your wisdom
- Oracle database build using ASM on RAC
- Must have strong UNIX/AIX background
- Experience with Atlassian on Demand CI using JIRA and must have a strong problem research and resolution skills. The Senior Oracle DBA must have performance monitoring and tuning background and worked in a large, complex OLTP Database environment
- Bachelor's Degree in Computer Engineering
- 7 years’ experience as a Oracle/Sybase/MSSQL Database Administrator in a multi-node UNIX and Windows environment with the ability to diagnose and troubleshoot database and system problems
- Extensive knowledge of Oracle11g database systems and administration practices
- Working knowledge of Microsoft’s SQL Server2008R2 and SQL2012, including replication and mirroring
- Ability to program in Korn Shell, PERL, and SQL languages
- Should be familiar with Solaris, Linux, Notes, Microsoft and CA Technologies products
- Excellent verbal and written presentation skills, to define and present system requirements and analysis
- Knowledge of financial business environments will increase the incumbent’s potential for success
- Ability to work in a team environment and work closely with co-workers on mission critical projects
- Working knowledge of SYBASE ASE15 systems and administration practices, including Replication Server15 and Sybase IQ15
- Knowledge of Autosys and Opswise workload automation software
- Support Oracle database team tasks efforts and perform client database service requests
- Perform database, SQL, and load test tuning reviews
- Assist database team members with current project work
- Perform database clone, restore, and refresh operations
- Participate in an on-call rotation as part of a leveraged level 3 DBA support team
- Represent database administration team in operational as well as project activities
- Assist with the maintenance of the Oracle 11g/12c software
- Oracle 11g/12c Enterprise Database including RAC, ASM, RMAN, Data Guard and OEM
- Production support activities for Oracle Database Infrastructure, problem solving skills including host, database and application analysis
- SQL, PL/SQL and Database performance review and tuning; AWR review, etc
- Database clone and restore operations using RMAN, DataPump, export/import, etc
- Oracle DBMS software maintenance including patchset, CPU/PSU, and base upgrades
- Use of OEM for administrative activities including problem analysis and resolution, monitoring and alerting, backup and recovery
- 3-6 years of experience in
- Oracle Architecture, User Management, and Tablespace, Management
- Experienced in creation of various database objects
- Installation Oracle 10g, 11g & 12c with all release and create customized database
- Good exposure to apply database level patches using opatch on RAC & Non RAC environment
- Good exposure to manage database services using SRVCTL & CRSCTL
- Good exposure to generate & analyze ARW & ADDM report
- Good exposure in setup and configured Oracle 10g/11g (Data guard) physical standby database as DR Solution for production database
- Good exposure to perform RMAN Backup and Recovery with recovery catalog and database Cloning (Cold/Hot)
- Experience in oracle database10g/11g upgradation
- Knowledge of Oracle 10g, 11g Cluster (RAC)
- Knowledge of ASM Installation and configuration
- Creating listener and their services using NETMGR and NETCA utility
- Good exposure in MSSQL Database
- Comprehensive Knowledge of PL/SQL
- Performing weekly Database maintenance activity (Gather Statistics, Rebuild Indexes and Compile invalid objects)
- Taking care of cloning activity & Database refresh
- Applying patches using Opatch utility
- 24x7 support provided and troubleshooting users related issue on-call basis and day-to-day support
- Daily monitoring (using Hobbit Tool) includes checking Server status and all Database services
- Implements enterprise data standards across the portfolio of databases
- Creates and maintains Oracle databases required for development and testing usage (non-production environments)
- Administers database objects, including tables, indexes, views, sequences, packages and procedures
- At least 3 years of experience with the design, installation, and maintenance / support of Oracle RAC / ASM (Oracle 11g RAC experience is preferred)
- Advanced knowledge of SQL and scripting languages
- Experience with adding / deleting nodes in a RAC environment
- Experience with Red Hat Linux
- Installs, implements and supports complex systems within user base; creates and updates database installation instructions and design changes for client use
- Utilizes standard corporate tools to record change and problem activities for tracking purposes
- Experience working with database creation techniques and database management systems (DBMS)
- Provide technical support for database environments
- Monitor the performance of production systems and utilize appropriate tools to identify tuning requirements
- Broad technical knowledge of client/server and web-based environments
- Database software maintenance (upgrades, service packs and patches)
- Expertise in Materialized views and distrusted databases transactions
- Experience isolating, diagnosing and resolving DBMS problems, including root cause analysis
- Understands 24 X 7 database support Essential Skills
- 5 years IT experience
- Programming experience Linux/Unix OS and shell scripting
- Good interpersonal skills Education Required: Bachelor’s degree or equivalent work experience
- Candidates are expected to provide troubleshooting and advice on any issues and be up to dated with new Oracle DB releases
- Oracle DB management, installation & upgrades
- Database performance tuning and optimization skills
- SAP DB Admin experience
Professional Oracle Database Administrator Resume Examples & Samples
- Experience working with file and system maintenance procedures
- Experience with troubleshooting database performance and query tuning Data integrity concepts
- Implement and maintain database security
- Knowledge on Oracle Transparent Encryption
- 5 years’ experience as an Oracle 9i/10g/11g/12c DBA on multiple instances
- 2+ years of DBA Experience
- Proficiency in Oracle versions 10g, 11g and 12c and Oracle Cloud Control. Oracle certification and is a plus
- Strong understanding of Oracle relational databases, data structures, and SQL
- Scripting Experience (Shell, Perl, etc.)
- Experience with Database Monitoring tools
- Experience within a production environment
- Ability to provide off- hour support when required
- 5+ years of experience managing Oracle 11G/12C databases
- Familiar with user management, password policies, roles, grants, privileges
- Familiar with different database refresh methodologies
- Familiar with Oracle backup methods, RMAN and DataPump
- Familiar with basic RAC and Dataguard administration
- Experience with Linux and Shell scripting
- Analyzing performance report using AWR and dictionary views
- Works well as part of a team
- Proven problem resolution skills
- Ability and desire to learn new skills
- Experience adhering to change control processes in all activities
- New features of Oracle 12C
- Understanding or exposure of DNFS feature
- Troubleshooting Oracle RAC /Dataguard issues
- DB2 & Postgres DB support experience
- Grid control knowledge
- Database Auditing
- TDE knowledge
- Scheduler and DBA Job Management
- Shared server configuration
- Working experience with development team
- Generally familiar with programming and analysis specifically Java, XML and web service
- 5+ years of DBA Experience. (Systems DBA) Financial services preferred
- Proficiency in Oracle versions 10g, 11g and 12c and Oracle Cloud Control. Oracle certification preferred
- Oracle optimization experience on VMWare preferred
- Experience with high availability, standby, backup and recovery
- Experience with GoldenGate technologies is a plus
- Proficient with Backup and Recovery (RMAN, Dataguard)
- Ability to provide off- hour support required
- 7+ years production Oracle Database Administration experience
- Experience with Atlassian on Demand CI using JIRAand must have a strong problem research and resolution skills. The Senior Oracle DBA must have performance monitoring and tuning background and worked in a large, complex OLTP Database environment
- Experience in Cloud, IaaS, AWS Public Cloud, Pivotal Cloud Foundry, Chef based automation is a plus
- Expertise in Infrastructure technologies with hands-on experience in high availability cluster solutions using Redhat, UNIX, LINUX, windows Administration experience
- Experience in next generation disk and network solutions and prior experience in managing legacy network or disk based solutions
- Expertise in evaluating new technologies and technical products in the context of business needs, established reference architecture, software packages,
- Strong analytical and problem solving skills; ability to provide “hands-on” technical support and analysis on as needed basis
- Proactively diagnose and work with application developers to resolve application SQL performance issues using available tools
- Develop and POC new database development techniques and communicate to application teams
- Develop and POC new Oracle features to improve application efficiency
- Work with the Operational Database Administrator to plan database capacity to support application growth
- Work with Development team to review code and do deployments
Senior Oracle Database Administrator / Lead Resume Examples & Samples
- Operate Oracle databases ensuring that systems are running optimally ensuring availability, efficiency and recoverability
- Designing, planning and implementation of new Oracle estate
- Consolidation/expansion of existing services
- Design and implement monitoring solutions for Oracle databases
- Develop and maintain automation scripts for daily operations
- Ensure security and privacy policy follows best practices
- Expertise in managing Oracle 10g,11g,12c on Unix platforms
- Expertise in configuring oracle for HA, cluster, RAC, Dataguard
- Expertise on Shell scripting
- Expertise in database performance tuning and security
- Expertise in use of tools like OEM, TOAD
- Strong knowledge of indexes, index management, integrity checks, configuration, patching
- Exposure to Oracle Engineered Systems such as Exadata and Oracle Database Appliance a bonus
- Exposure to monitoring tools like BMC Patrol, NewRelic is highly recommended
- Backup and restore utilities such as RMAN
- Should be able to automate programs using Shell scripting, PL/SQL
- Should be able to troubleshoot using basic Unix commands
- Handled multiple complex recovery scenarios
- Service Management expertise using SNow will be considered a plus, but not required
- Possess a keen interest within Oracle technologies by understanding new current/forthcoming versions (e.g. Oracle 12c R2, OEM 13, etc.)
- Skill in using analytics, logic and reasoning to troubleshoot issues and find the best solutions to overcome challenges
- Must possess organizational proficiencies to multitask and work in a fast-paced environment with minimum supervision
- Oracle certified professional – Added advantage
- 8-10+ years of Oracle Database Administrator experience
- 2+ years hands on experience on RAC with Oracle 11g real application clusters
- 3+ years of experience on OEM – Creation of DBconsole, Running backup jobs
- Proficient in Installation/upgradation of Linux systems
- Expertise in Adding/deleting nodes in RAC cluster
- Expertise in using Backup/Recovery strategy, design and implementation using Cold backup, Hot backup and RMAN methodologies
- 2 year's experience in configuration and tuning of Oracle database
- Good Communication and leadership skills
- 5+ years of experience in understanding of Oracle Internals, Architecture, Data Dictionary, Data Management, Automatic Storage Management (ASM) and System Management
- 4 years experience in System Configurations, planning upgrade for critical production databases, Migrating Databases for Lease Rollover, Patching Databases
- Define and implement Oracle backup and recovery strategies
- Evaluate new database products and features
- 2+ years of experience in Oracle database administration. 10G, 11G and 12C
- 2+ years of experience working in Unix/Linux/Windows environments
- Experience in designing and implementing Oracle database utilities (backup and recovery) and using Oracle diagnostic and monitoring tools
- Experience in managing formal concern resolution process between stakeholders (developers, operations and vendors)
- Experience in supporting critical 24x7 production environment, working on large Oracle database applications
- Familiar with database security and control policies
- Strong written/oral communication skills with ability to communicate effectively
- Define and administer standards for the organization's relational and non-relational databases in on premise and external cloud vendor data centers
- Partner with teams to provide database and technical project leadership for business customer initiatives
- Maintain, tune, monitor and administer development, stage and production databases; including application integration points
- Identify opportunities for automation and implement solutions for common database administration tasks and challenges
- Responsible for the control, integrity, and accessibility of database data structures, including business continuity disaster recovery planning
- Collaborate with other technology teams to align database automation, standards and architecture with overall business technology roadmap
- Identify and report any quality or compliance concerns and take immediate corrective action as required
- Responsible for data integrity of the system inventory, as applicable
- Responsible for the validation of all GxP relevant applications and maintaining the validated state of those applications
- Bachelor's Degree in Information Systems, Information Technology, Computer Science, Engineering or equivalent experience
- Deep experience in the application of information technologies to business solutions primarily focused on database systems
- Deep, demonstrable experience with one or more database technologies; MS-SQL, Oracle, MySQL or PostgreSQL as a professional DBA supporting large business environments
- Strong, demonstrable experience working with Oracle 10g, 11g, and/or 12c
- Strong, demonstrable experience in one or more of the following: SQL performance tuning for Oracle databases, ASM builds, Oracle 10g, 11g, and/or 12c RAC on Linux and/or Solaris
- Demonstrable experience in Unix (Solaris/ Linux) processing environment
- Demonstrable experience with technical project management, system implementation, and integration in a team environment
- Ability to work in a fast-paced team environment
- Excellent project management skills and people management skills in a team environment
- Very effective verbal and written communication skills in both business and technical areas
- Proven ability to maintain leading edge skills in a rapidly changing information systems environment
- Experience with database infrastructure automation leveraging Ruby, Python, Chef or other programming tools
- Proficiency in shell scripting and/or PowerShell, specific to database administration and automation
- Experience with MySQL, PostgreSQL or other open source database technologies
- Expert understanding of current licensing models for one or more database vendor
- Experience with databases in AWS, Azure or other cloud-based service provider
- Green- or Black-Belt certified or statistical data analysis background
- Experience with DevOps culture or methodology
- Design, install, configure, upgrade, and manage Oracle RDBMS 10g, 11g and 12C
- Configure and manage database maintenance, including backups, reorgs, and any additional required maintenance
- Apply Oracle-related patches
- Manage Oracle clusters as well as environments containing replication with Data Guard
- Participate in an on-call rotation as part of a leveraged DBA support team
- Minimum of 5 yeas experience as an Oracle DBA in a Linux/Unix Environment
- Must have expert experience with Automatic Storage Environment (ASM)
- Design, Install and admin/maintain Oracle Real Application Clusters (RAC)
- Expert DBA level knowledge of Unix fundamentals and shell scripting
- Design, Install and admin/maintain Oracle Data Guard
- Install and admin/maintain OEM, Grid Control, Foglight etc
- Backup and Recovery (RMAN, Cloning, Data Guard, Export/Import)
- Resource Monitoring (CPU, memory, I/O, RAC/ASM, etc)
- Oracle patch provisioning
- Must have an understanding of AWR Reports
- Performance tuning ◦Diagnostic evaluation (ADDM, AWR, ASH)
- Tuning (advisors, SQL tuning, indexing, partitions, etc)
- Oracle 11g Certification a big plus
- Administer and maintain multi-terabyte Oracle 10G/11G/12C RAC production databases in an AIX/UNIX environment
- Ensure the availability, performance, recovery and security of the databases
- Design and implement database infrastructure, including performance monitoring, capacity planning, and automation of database related processes
- Develop Oracle scripts, DBMS jobs, stored procedures and functions to replicate data to the backup databases, purge old data from log tables
- Willingness to be on-call in rotation with other staff
- Minimum of 5 years of work experience in any combination of the following: Systems Administration, Network Administration, Relational Database Administration, Software Development, and/or Software Quality Assurance Testing
- Minimum of 3 years of work experience in the administration of Oracle Databases
- Bachelor's degree in Computer Science; Computer Engineering; Computer Software Engineering; Computer and Information Sciences or other Science, Technology, Engineering, and Mathematics disciplines
- Experience creating and maintaining functions, packages, triggers
- Experience in an Oracle Database 10G/11G/12C in a RAC, ASM and Data Guard environment
- Current DHS US-VISIT 6C Clearance status
- Ability to assess and resolve complex technical issues
- Effective facilitation, communication and teaching skills
- Ability to engage and influence the organization
- Ability to multi-task and handle large workloads under time constraints
- Ability to understand and apply analytical and statistics tools
- Extensive understanding of Database architecture principles and practices for Oracle, SQL Server and My SQL
- Extensive working technical experience with installing, configuring, and supporting Database managed systems
- Extensive understanding of Exadata management best practices administration, disaster recovery procedures, back/up recovery best practices, and monitoring setup and procedures
- Extensive experience with database high level availability, optimization and performance of Oracle Exadata, Oracle RAC Cluster and Oracle 12c
- Highly skilled in Windows, UNIX and Linux operating systems
- Database Design - The ability to produce a detailed data model of a database containing all the logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language and in turn to create a database
- Database Tuning - Able to maximize the use of system resources to perform work as efficiently and rapidly as possible
- Troubleshooting - Able to diagnose and problem solve issues with computer hardware or software components with little or no direction. May require ability to install, configure, or disposition of server or client pc infrastructure and application issues
- Must have Oracle database knowledge
- 5 years of Oracle production support would be ideal
- Oracle DB knowledge of version 10G to version 12
- Added bonus would be that they have supported Siebel and/or Hyperion
- Able to multitask and oversee GPV resources
- Designs, implements, and maintains moderately complex SQL and Oracle databases
- Maintains database dictionaries and integration of systems through database design. Works on most phases of database administration
- Optimizes databases and queries to keep systems operating efficiently
- Creates & maintains Oracle table spaces, objects, users & roles
- Writing Oracle stored procedures triggers as required
- Analyzes user processes and recommends automated database solutions to improve workflow
- Develops database backup and restores procedures integrated with file and system backups to ensure data protection and availability
- Works with local originators to create and support databases for software development projects meeting client’s requirements and priorities
- Maintains and supports Government Off-the-Shelf (GOTS) and COTS databases as required
- Develops interfaces as required to support local development or data mining efforts
- Works with Program Management Offices and commercial vendors to integrate their databases into our network environment
- Proactively monitors client database spaces to ensure appropriate allocations as environments grow
- Minimum of five years related experience
- Experience in designing and building databases using DBMS software, including, but not limited to, ORACLE, SQL, and/or Java
- In accordance with DoD 8570.1M, candidate must obtain an IAT-II level baseline certification (Security+) prior to start date
- US Citizenship required. Candidate must obtain and maintain a DoD security clearance
- Knowledge of Solaris Operating Systems
- Proven experience in Oracle 12c
- Experience importing, exporting, scripting, and tuning
- Knowledge of Recovery Manager (RMAN)
- Valid and current Security+ certification
- Valid and current DoD clearance
- 2+ years of experience with working in an Oracle Database environment
- 1 year of experience with working in a UNIX environment with UNIX commands and scripting
- Ability to analyze, evaluate, test, debug, document, and implement custom scripts and programs
- Ability to be a self-starter, jump into a complex environment in need of documentation, and respond quickly to production issues as they unfold
- Oracle Database 11g and Security + CE Certification
- Experience with Oracle Virtual Private Database concepts
- Experience with Tectia, Reflections, or Putty
- Experience with Kerberos
- Ability to be on-call weekends
- Ability to work on weekend during project release
- DoD 8570.01-M CSWF IAT level II Certification
- Provide all activities related to the administration of large scale Oracle databases
- Project long-range requirements for database administration and design in conjunction with other managers in the information systems function
- Design, create and maintain databases in a client/server environment
- Conduct quality control and auditing of databases to ensure accurate and appropriate use of data
- Designs, implements and maintains complex databases, access methods, access time, devise allocation, validation checks, organization, protection and security
- Bachelor's degree in Computer Science or related field preferred and eight or more years of experience
- Experience loading database associated COTS products, and configuring and optimizing Oracle databases
- Possess knowledge of performing detailed performance analysis and resource utilization of the assigned systems
- Possess leadership experience to assure appropriate changes, upgrades, and enhancements are made based on the technical analysis
- Knowledge of Oracle database products and baselines
- Experience with Oracle Real Application Clusters (RAC) is preferred
- Knowledge of the COTS products (like RedHat Linux, HP Operations Manager) for the specified system/service
- Certifications in database systems and other COTS products are desired but not required
Oracle Database Administrator, / Developer Resume Examples & Samples
- May provide technical lead, project leadership or staff supervision in large development, migration, testing, acceptance or product rollout project
- Expert knowledge of Oracle RDBMS, Oracle RAC and active data guard
- 2+ years DBA experience with any other major DBA (like Netezza or MSSQL)
- 3+ years of hands on development using programming language such as JAVA, Python, Perl
- 5+ years scripting experience
- Experiences with replication software such as Oracle Golden Gate is a big plus
- Oracle 11g & 12c Database Administration to include the following
- Must be able to obtain a DoD Secret clearance
- Minimum 8 years Database Administrator experience with Oracle 11g & 12c RDBMS
- Experience with RAC/Grid Control/ASM
- Experience with Data Guard/RMAN
- Strong scripting skills using Linux, Bash, Perl, and Python
- Experience with security requirements for databases, developing, documenting, and implementing backup and recovery procedures
- Experience with database performance tuning, partitioning, blobs, database storage management, data security and protection, performing backups/ restores, and archiving data
- Skills working with Oracle PL/SQL, stored procedures, and SQL queries
- Willingness to share knowledge and mentor team members
- Currently hold an active DoD Secret security clearance
- Experience working with databases in secure environments (familiarity with STIGS, hardening, etc.)
- Experience with data modeling and design using Oracle Designer, SQL Developer
- Experience with Ruby
- Experience with Clearcase
- Experience with Clearquest
- Experience with jitterbit
- Experience with VMware
- Manage, deploy and install Oracle Golden Gate in uni-directional and bi-directional modes
- Monitor database technology stack globally for GCPS using Oracle Grid Control
- Maintain Oracle Grid Control Agents (install & patch)
- Provide support for Grid Control infrastructure
- Oracle database upgrades, patching
- Responsible for the maintenance and health of all IHC data provisioning none prod Database environments
- Write all DB procedures, functions and triggers, and insure the deployment to production is performed successfully and the final result is as per expectations
- Handles the creation of all Database schemas and objects (tables, indexes, etc.)
- Responsible for the implementation of the DB security roles, users, accesses and assigned privileges
- Perform periodic and continues review to the DB loading process, application related jobs, and data replication activates and implement performance improvements
- Responsible for the monitoring and implementation of the application and database tuning
- Work with DWH Core Platform infrastructure team to implement the procedure and data mapping
- Write technical specs related to this implementation
- Work closely with ETL development team and other DB architect and developers to set up interfaces and procedures by following the best practices / conventions within the team (including peer code review)
- Help deploy application to UAT and production environments, and handle bug-fixes and implement possible system redesigns during these periods
- Consult with users, management, and technical personnel to clarify business requirements, identify problems, and suggest changes / best practices
- Write / analyze functional requirements, then propose reporting solutions to them based on BNPP standard systems. Write technical specifications and perform workload and risk analysis related to these solutions
- Maintain and support existing applications, and participate in user training
- Ownership of Oracle RAC clusters, working on a variety of development and maintenance projects in coordination with project and support teams
- Knowledge of all supporting infrastructure components, including operating systems, hardware/storage configurations and networks
- Minimum of 7 years data modeling experience with conducting performance tuning, backup/recovery, and scalability/capacity planning, in addition to SQL, PL/SQL, and UNIX shell scripting
- Excellent SQL and DB performance tuning skills
- Minimum of 7 years troubleshooting and problem-solving experience
- Experience in Oracle Applications, Oracle Dataguard, and PeopleSoft
- Oracle to Redshift automations
- Internal Audit Tool
- One click migrations of databases to RDS
- One click migrations of OFA lower environments to AWS
- Engineer file operations as self service applications
- Engineer code deployments in collaboration with OFA Dev teams
- Familiarity with at least one compiled language (Java, C, C++ )
- Experience in Oracle Applications Manager, Oracle Dataguard, and PeopleSoft
- Design, develop, implement and maintain Oracle database instances
- Fluency in Oracle DB technologies and tools, DB development
- Excellent written and verbal communication skills, with a track record of working effectively with Development Engineering and other functions
- On-call support
- Fast troubleshooting and resolution skills
- 5 or more years of industry experience as an Oracle DBA
- Expert level knowledge and experience with Linux environments
- Expert level knowledge of SQL and performance tuning
- Hands on experience implementing and supporting Oracle FSFO
- Track record of managing large number of databases
- Expert knowledge around scripting in one or more languages (Perl, Python etc)
- PL/SQL experience is good to have
- Provide technical support of database environments/applications, including software installation, database creation, upgrades, patches, problem diagnosis, performance monitoring, database maintenance, process automation, evaluation, and tuning recommendations; develop, implement and support backup/restore, disaster recovery and data replication procedures and exercises
- Participate in all aspects of the lifecycle for database environments; and in the implementation of application requested database code and configuration changes in supported database environments
- Participate in the creation of new policies, procedures, projects and processes
- Evaluate, document, and recommend database-related software products within technical architecture framework
- Interact with various technology teams regarding work requests submitted, participate in the creation of new policies, procedures, projects, processes and participate in all aspects of the lifecycle for database environments
- Provide technical guidance for junior members of the team and create periodic status reports for management. Provide on call 24X7 emergency off-hours support of critical systems for database problem resolution and recovery, as well as production applications
- Three years of experience in administering and managing large databases in complex enterprise environments
- Experience supporting Oracle production database including hands-on senior database administration experience with Oracle 12c, 11g, 10g and 9i; includes strong proficiency skills in both Unix and Windows environment
- Proficiency with Unix and Windows shell scripting, PERL and PL/SQL programming languages, SQL Query tuning, System level monitoring and tuning, RMAN, Advanced Networking and security features, handling BLOB objects, support of Partitioning and Oracle Text, knowledge of Oracle database replication, standby and Data Guard; client connectivity tools, such as ODBC and OLEDB, ONAMES , OID and OEM
- Demonstrated knowledge working with Oracle databases larger than 500 GB and/or user population greater than 15,000 ; experience in 3rd party tools to support the database infrastructure such as BMC Patrol, Remedy, Maestro, NetBackup, CyberArk, ERP application software like Peoplesoft -Financial and HR modules, Security products like Guardium, Optim and Vormetrics
- Strong verbal/written communication, problem solving, analytical and independent judgment skills to support an environment driven by customer service and team work; ability to positively influence, mentor and be a credible source of knowledge to less experienced team members
- Define and administer database organizations, standards, controls, procedures, and documentation in a client/server
- Oracle – must have strong core Oracle Development skills
- PL/SQL skills
- Configuration of Business Connectivity Services for connecting to external databases
- Plan and design improvements to SharePoint performance as directed
- Involve and influence project directions in compliance with PDIT technology standards
- Research new technologies includes but not limited to Database/Storage/Linux/Solaris/Network/Java
- Excellent communication/follow-up skills
- Ability to balance multi-task and multiple priorities while maintaining a high level of customer satisfaction is key
- Be able to work in an interrupt-driven environment (those hindered by change need not apply)
- Team leader experience is definitely a big plus
- 7+ years working experience supporting an enterprise infrastructure environment, 5+ years as an Oracle DBA
- Strong knowledge and Concept on Oracle 10g, 11g, 11g GRID, HA
- Strong Oracle database administration, tuning and trouble shooting skills
- Operational on-call support experience on production, mission critical environment is a must, including hands on experience on regular/routine DBA tasks
- Perform Oracle database support duties on Windows and Linux platforms
- Performs database configuration, software installation and upgrades of high availability Windows and Linux systems
- Strong knowledge of RMAN backup/restore and Oracle Dataguard setup
- Oracle database monitoring and performance tuning
- Provide technical support and help for internal departments and local offices
- Responsible for the day-to-day maintenance and operation of hosted systems
- Provide backend support for the systems to internal Customer Support staff
- Answer phone calls from internal support teams and external partners
- Participation of DBA on-call 24 x 7 rotation and shifts
- Manage support tickets for the data center
- Follow Change management and generic datacenter related policies and procedures
- Degree in Computer Science, Information Systems or equivalent combination of relevant experience
- Relevant work experience in IT as a database engineer in Windows and Linux environments
- Willingness to join on-call 24 x 7 rotation and nightshift after trial period
- Customer focused and team oriented work
- Operating system knowledge (Unix, Linux and/or Windows
- Daily administration activities such as storage layout, RMAN, Data Guard replication, backup/restore, patching, maintenance, upgrades, and access control should be second nature
- Proficient with automation of maintenance tasks using PL/SQL and other scripting and tools
- Superior troubleshooting skills, battle-tested in high-volume production environments including Grid Control Administration
- Programming in Perl, shell script, Python, Java, Puppet, Ruby
- Hands on Experience in Golden Gate, Exadata
- Migrate large databases and small databases to Oracle 11g from lower version. Experienced in configuring dataguard environment for
- Administer, Implement, and maintain Oracle databases on Unix platforms using OEM, DBArtisan, and SQLPlus
- Understand and be able to trouble shoot advanced Unix shell and PL/SQL scripts for automating database builds and other Oracle
- Good oral communication skills. Candidate needs to be able to speak his opinion diplomatically. Must be an active contributor to project
- Collaborate with development teams on the design and implementation of database services, stored procedures, and replication
- Implement a backup strategy according to customer requirements and test recovery
- Upgrade and patch Oracle DBMS
- Plan and execute data migrations
- Enhance, maintain, and troubleshoot database replication
- Maintains database dictionaries and integration of systems through database design
- Develops and applies procedures for periodic database backup
- Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation and statistical methods
- Develops applications to help solve database solutions to business problems, data architectures, database management system facilities and capabilities and the operation and tuning of databases
- Provides technical consulting in the definition, design and creation of a database environment
- Assists, defines and oversees database organizations, standards, controls, procedures and documentation
- Executes processes in SQL and PL/SQL for Oracle databases such as stored procedures/functions/packages, database job, materialized view, view, synonyms and DB link
- Analyzes impact on database before making any changes to database
- Analyzes data source and creates a data load script
- Creates PL/SQL and SQL scripts to apply changes to Oracle database
- Performs primary lead support for the database environment
- Candidates must be US citizens
- Experience managing COTS products
- Experience with database tuning, design backup and recovery process using integrated backup tools like NetApp Snaps for Oracle and SQL Server
- Ability to understand and manage application servers
- Exposure to n-tier architecture
- Experience designing databases to support growth and support on various platforms such as NetApp and EMC
- Experience with platform-independent techniques to support SLAs
- Capable of working at levels, provide white-board sessions to management, provide input management to prepare business case and return on investments and adapt to changes as the business demands
- Specialization in NetApp Storage Arrays including enterprise level deployment and latest versions of NetApp hardware and software
- Bachelor's degree in Computer Science, Information Technology, or equivalent work experience
- Minimum eight years (8) of Oracle database administration of Oracle 12c/11g/10g
- Hands on experience with Oracle RAC
- Must be familiar with Oracle Data Guard, ASM and Backup (RMAN)
- Demonstrated knowledge and experience with performance tuning
- Experience with SAP database administration
- Microsoft SQL Server experience a plus
- Experience with large databases (1+TB)
- Oracle Enterprise Manager (OEM) setup and maintenance
- Maintain and recommend enhancements for the 5th Signal Center’s Remedy ARSs (Version 7.5 and higher) application and Oracle Version 10g database platforms operating on Sun Solaris and RedHat
- Provide technical assistance for systems integration as part of the 5th Signal Command’s 5th Signal center internal system team
- Provide technical assistance in the development, fielding, maintenance, and DR of Oracle databases supporting the present and future development of the 5th Signal Center Remedy-based trouble ticketing system and associated applications.Implements and maintains smooth operation and physical design of databases
- Bachelor of Science/Arts Degree in Engineering or Computer Science or Science or Business Administration or Mathematics with 6 years experience OR 10 years experience in lieu of degree
- Oracle Certified Associate (OCA), Oracle Version 10g is required
- Four (4) years experience using, developing, and maintaining Oracle database software
- Four (4) years maintaining server based database instances
- Two (2) years experience with UNIX or Microsoft server based platforms
- Two (2) years direct experience with U.S. military command and control or commercial LAN/WAN communication systems
- Must have a DoD 8570 IAT-III certification (CISSP, CASP, GCIH)
- Current U.S. Secret clearance (or higher) to be considered
- Perform L4/SME type of activities including complex high availability and disaster recovery design and configuration, advanced performance tuning and troubleshooting, database administration, vendor management, and product readiness for production
- Serve a key role in migration and ongoing support to business critical systems in investment bank as part of database as service (DBaaS) project
- Work during isolation tests, BCM testing, power downs and infrastructure weekends when required
- Support very large database using complex technologies such as clustering, mirroring and replication
- Handle other major responsibilities including advanced performance tuning, high availability/disaster recovery selection and setup, storage and capacity management, security and audit remediation, cost efficiency & service improvement initiatives, Incident management and RCA
- An excellent understanding of Oracle internals and Administration in 10g, 11g, and 12c
- Experience in managing Real Application Clusters (Dataguard is preferable), experience in Recovery Manager and OEM (Oracle Enterprise Manager) is required
- Advanced performance tuning skills to identify the contention at the Database and operating system levels as well as the ability to provide quick solutions to resolve production issues
- Experience in analyzing database health check reports like AWR, ADDM, OEM Diagnostics Packages as well as the experience/ability to interpret performance metrics quickly
- A solid understanding of Unix Operating systems. Experience in Exadata technology is a plus
- Experience in application development support using PL/SQL, SQL and Unix Shell Scripting
- Experience supporting a variety of applications including high transaction volume trading systems as well as capacity planning and designing the database layout
- Professional C++ experience
- Professional Python experience
- Professional experience with automated unit and function tests
- Professional experience troubleshooting problems and testing solutions in an integrated environment
Oracle Database Administrator / Analyst Resume Examples & Samples
- Typically requires bachelor’s degree or equivalent, and five to seven years of database related experience
- Must have experience as an Oracle Database Administrator (DBA)
- Experience working in a Unix environment
- Ability to perform SQL, PL/SQL and Unix scripting assignments
- Must have a current DoD Secret security clearance
- Troubleshoot and resolve incidents in PACCAR’s Oracle environment
- Create, test, and maintain Oracle backup, and recovery using RMAN
- Implement and maintain database security in line with company security policies
- Perform database tuning and monitoring
- Provide 24x7 operational support in an on-call rotation
- Plan and implement Oracle installations, upgrades, and configurations
- Support PACCAR’s SAP Competency Center, Developers, and support staff
- Create and maintain Oracle database procedures and standards
- Proven Oracle administration experience with 10g, 11g and 12c
- Ability to install, configure and administer Automatic Storage Management (ASM) for Oracle databases
- Excellent with SQL, PL/SQL, and shell scripting
- Excellent troubleshooting and problem-solving skills
- Demonstrated experience installing, configuring, and upgrading Oracle servers
- Experience installing, configuring, maintaining and using Oracle Enterprise Manager
- Working knowledge of one scripting language (e.g. Python, Ruby, Perl)
- SQL Server experience is a plus
- Teradata experience is a plus
- Tableau experience is a plus
- Experience with AWS and Azure is a plus
- Bachelor’s Degree in Computer Science, Information Systems or equivalent experience required
- Responsible for the installation, configuration, troubleshooting, support and maintenance of all database systems including Production, QA, and Development server environments
- Monitoring and optimization of database performance, security, resource utilization, memory configuration, sessions, archive logs, and disk space usage
- Share support for mission-critical database instances, including responsibility for after hours on-call support for issue resolution
- Leverage Oracle expertise and knowledge by providing SQL, PL/SQL, and data expertise to developers and users
- The candidate will be expected to identify opportunities for improving system quality and implementing more efficient processes and management of databases
- Participate in DBA team on-call pager rotation and on-call support duties
- 6+ years of oracle DBA experience on mid to large scale database environments
- 2+ years of experience administrating Oracle RAC Environments
- Experience in Oracle Streams or Oracle GoldenGate preferable
- Experience in Oracle 11gR2 preferable
- Proficiency in writing shell s and sql scripts
- Strong knowledge of UNIX/Linux
- Experience in setting up Oracle DataGuard Standby technologies
- Strong knowledge of RDBMS architecture, SQL tuning, PL/SQL troubleshooting
- A good team player, flexible, share knowledge and help others
- Bachelor’s degree in Computer Science or other technology field or equivalent experience
- 1) Oracle Database Versions 9i, 10g, 11g and 12c (experience is necessary because this is a mixed environment) Oracle Applicaiton and Database administration
- 2) UNIX or Linux Environment experience
- 3) Hands on experience with WebLogic or Jboss Middleware technologies
- 10+ years hands-on experience On Oracle (11g, 10g, 9i) databases applications development using Oracle Packages, Stored Procedure, and Functions on Sun Unix or Linux
- 8+ years of PL/SQL development experience
- 8+ years hands-on Experience on large database development on Oracle Database, other RDBMS including MS SQL Server and DB2 experience with tuning and optimizing performance on backend process, complex SQL, PL/SQL packages and Analytic SQL; Strong knowledge on Oracle Database administration issues (i,e schema, user, security)
- Design and support database infrastructure, with consideration for performance, availability, redundancy, disaster recovery, and specific application requirements
- Tune database systems and applications for optimal performance
- Design, implement, maintain capacity planning systems
- Help establish and publish standards for configuring databases. Monitor adherence to the standards
- Design, implement, maintain Security Administration reports as required
- Automate system and DBA processes
- Supervise hardware installs as needed
- When on call: provide 24/7 support. Respond in a timely manner to all alerts. Assist related groups in debugging production issues
- When handling user requests: fulfill user requests in a timely manner. Adhere to Change Control processes; ensure that proper authorization is supplied for changes
- Minimum 4 years’ experience in the following databases and basic knowledge of others: Oracle (including RAC)
- Knowledge of RDBMS architecture
- Strong knowledge of SQL, PL/SQL and T-SQL. Comprehensive knowledge and experience with database performance tuning, installation, configuration, backup & recovery
- Strong knowledge of networking, UNIX, Linux and Windows architecture
- Understanding of and ability to implement internal system standards, procedures and services
- Ability to organize, prioritize, and manage multiple projects and resources
- Excellent communication skills and ability to work in a team environment and communicate with different levels of management and staff
- Other optional skills or qualifications: Unix administration experience or knowledge; technical project management; database certification(s); scripting skills (shell/Perl/Powershell, etc.) to automate admin tasks
- B.S. degree or M.S. degree in Computer Science or Information Systems Management or Equivalent work experience
- Strong foundation in IT Service Management – one of ITIL, CMMI, Six Sigma, MOF, etc…
- Oracle Database Administration for 10g, 11g and 12c environments on Windows, Sun Solaris and Linux servers
- Manage over 300 production databases nationwide including backup and recovery
- Create and maintain replication objects in a Master-Snapshot site environment in 9 geographical regions
- Install and configure standby databases using oracle Data Guard as well as Oracle Management Server (OMS)
- Support RMAN as well as other export and import utilities
- Perform SQL tuning to optimize database performance
- Provide technical support to users and application developers
- Configure Internet Directory to register new databases in Oracle Internet Directory
- Monitoring activities included verifying database operational status including tablespace, alert logs etc
- Install Oracle CRS and ASM
- Support the installation and configuration of SAP Business Objects products
- 20 year of relevant IT experience
- Specialized experience in performing the duties identified above in an environment using the technologies listed above Oracle RAC, RMAN, OMS, CMS, ASM and SAP Business Objects
- Monitor incident ticket queue and resolve database incidents within SLAs
- Restore service of all database related issues
- Maintain and support PeopleSoft databases including application development lifecycles
- Provide daily development support to application teams including database connectivity, configuration (index creation, database layout, schema changes) and Data migration
- Monitor database and server performance and identify current and potential bottlenecks
- Provide performance monitoring during all phases of the Application’s development lifecycle
- Responsible for trouble shooting Database issues including collecting information through traces and other logging facilities
- Provide database and SQL tuning expertise through recommendation to application developers, vendors and other core Application teams
- Provide Database configuration for optimal performance including Database Partitioning
- Update runbook documentation
- Review and support installations of database maintenance and security patches and upgrade to supported release levels
- 5-7 Years of hands-on experience with Oracle database administration experience handling 4- 70+ TB databases
- BS/BA in Computer Science, Business Administration, or related degree
- Experience with database administration of PeopleSoft application
- Experience with a second DBMS especially Informix, Oracle, UDB, or SQL Server is highly desirable
- Experience in database design, SQL tuning, and performance analysis (Candidates must have in-depth understanding of Join methods, data access path and SQL Traces)
- Experience with EDW and OLTP workloads
- Experience in the use of Partitioning and indexing and Data models
- Solid and proven skills in managing database lifecycle – builds, patching, backup and recovery
- Experience with Linux (Redhat or SUSE), Solaris and Unix AIX is desired
- Demonstrated use of scripting, Stored Procedures, Triggers, Cursors, Logins and Views
- Genuine desire to provide superior customer service
- Strong communication and leadership skills with the demonstrated ability to lead and influence technical professionals across the enterprise
- Comfortable with ambiguity as needs change on a regular basis with a high degree of initiative and sense of urgency
- Excellent oral and written skills with the ability to interact with senior management, technical subject matter experts, and business customers are essential in this role
- Strong understanding of ITIL service support and service delivery
- Ability to operate in a support role, assuming on call responsibilities
- 12+ years of experience with a GED/High School Graduate
- 8+ years of experience with Associate Degree
- 4+ years of experience with a Bachelor’s Degree
- 2+ years of experience with a Master’s Degree
- 3-5 years of database administration experience
- Vast knowledge of various Oracle database technologies, such as Oracle 11g, Oracle 12c, Enterprise User Security, etc
- Experience with Linux, Solaris and other UNIX operating systems and strong shell scripting
- Strong skills in Oracle PL/SQL and ETL
- Ability to work in a fast-paced and dynamic environment
- Excellent documentation, communication and interpersonal skills
- Prior experience with SDDC’s Integrated Booking System (IBS)
- Prior work history or collaboration with Military Surface Deployment and Distribution Command (SDDC)
- Technical proficiency with Agile methodology, Serena Business Manager, VersionOne
- Government contracting experience
- Development and management of schemas, tables, packages, triggers, and views to support application requirements, perform application design and tuning
- Be an in-house expert for Oracle data architecture and work with the Operational Database Administrator to plan database capacity to support application growth
- BS in Computer Science or related degree, or equivalent work experience
- Extensive experience with Oracle 11+ (Oracle Certification a plus)
- Previous programming experience in an Object Oriented Programming language in a professional environment
- Evaluate server
- Review back up procedures and highlight gaps and recommendations
- Document overall health of DB
- Determine expansion drives / capabilities
- Work tasks as defined by customer
- Ten year of related work experience
- Experience with Oracle 11g and Win 2008
- Directly, and through subordinate managers, manages the design, development and administration of databases and their supporting infrastructure
- Develops and implements standard practices for administering enterprise databases and monitoring solutions
- Creates and maintains operational and strategic plans that support established business goals
- Establishes controls and procedures that ensure the quality, security and availability of enterprise data
- Experience with Oracle RAC 11g and 12c
- Experience with Oracle ASM, Oracle GRID Controller, Oracle Data Guard
- Experience supporting an enterprise software development environment
- Provides guidance to less experienced database teammates
- Experience working with large-scale distributed analytic cloud based service offerings using
- 10-15 years of related database analysis and/or administration experience
- Install, patch, upgrade, configure, and maintain Oracle binaries (database, crs, OMS, and Grid Control agent) and databases
- Update, maintain, and implement security policies in accordance with DISA STIG requirements
- Implement mitigations of security vulnerabilities
- Tune, administer and maintain Oracle instances according to set standards
- Develop and document procedures for backup and recovery of databases
- Monitor and manage legacy backups using command line interface
- Monitor RMAN backups using EM Grid Control and CLI
- Perform recoveries using RMAN
- Patch and upgrade binaries, databases, and agents
- Work independently and coordinate with various teams in accordance with defined standards and practices
- Communicate with project managers as to the progress of open items and work with other security specialists, the database group, or other infrastructure resources as needed
- Coordinate with the application teams to diagnose and correct issues
- Review and comment on scripts provided by application teams for implementation on databases and run approved scripts to create database objects and stored procedures
- Communicate with project managers as to the progress of open items and work with other developers, contractors, the database group, or other infrastructure resources as needed
- Willing to perform other duties as assigned, as there are often new projects that will arise and this individual must be able to adapt to change in requirements, new projects, and team counterparts
- Individual must be able to provide “after hours” support to include maintenance weekends, as required
- 8-10 years work experience as an Oracle Database Administrator working in varied environments. At least two years experience with Oracle 11g required. Experience with Oracle 12c a plus
- Create tables, views, indexes, database links, views, materialized views, stored procedures, and other database objects as needed
- Create and assign database roles and privileges
- Perform export/import using Data Pump
- Work with developers closely on application development and performance monitoring
- Assist developers and/or users with identifying performance issues and tuning queries and scripts
- Work with developers to implement code changes
- Execute scripts from developers in databases
- Demonstrated ability to design, develop, and maintain Oracle databases
- Knowledge of EMC disk storage preferred
- Willingness to work a flexible schedule and be on call to accommodate project deadlines and business requirements
- Database Certifications as appropriate preferred. Knowledge of extended features of DBMS technology preferred
- Bachelor's degree in Information Systems or related field
- Solid Understanding of, and experience with relational database environments
- May interact with peers and/or management levels at a client and/or within Accenture. Determines methods and procedures on new assignments with guidance. Decisions often impact the team in which they reside. Manages small teams and/or work efforts (if in an individual contributor role) at a client or within Accenture
- Must have at least 6 years of experience Administrating, developing and testing Oracle databases
- Experience performing many relationship database functions across one or more teams
- Experience in Installing database management systems DBMS
- Trouble shooting and performance tuning experience
- Must have experience in designing, implementing and maintaining new databases, backup recovery and configuration management
- End to end knowledge of period end processes
- Minimum 1 year of experience with Database systems support or development
- Oracle Database and SQL knowledge
- Good knowledge of Microsoft Windows Server and UNIX based Operating Systems
- Ensure database efficiency through SQL query design optimization
- Create queries for data migration to external database systems
- Maintain backup strategy for database systems
- Configure database servers to ensure maximum efficiency of 91 NWS operations
- Continue sustainment of the unit's operational database, crew functions (that include CRM processes), and training tools contained in PACRAT. Setup and maintain SAN (Storage Area Network) and NAS (Network Attached Storage) devices
- Active TS/SCI clearance required
- B.S.,Computer Science or a related field with five (5) years of experience or M.S., Computer Science or related scientific/technical field with three (3) years of experience; or equivalent combination of training and experience
- Extensive experience in Oracle 10g and 11g; Oracle 12c desired
- Oracle Database 11g Administrator Certified Associate certification required
- Ownership of Oracle Production, Test and Development instances
- Ownership of RAC clusters, working on a variety of development and maintenance projects in coordination with project and support teams
- Minimum of 3 years Database Administration experience with administering and supporting multiple Oracle databases for performance critical, highly available systems on UNIX/Linux platform
- Minimum of 2 years data modeling experience with conducting performance tuning, backup/recovery, and scalability/capacity planning, in addition to SQL, PL/SQL, and UNIX shell scripting
- Minimum of 3 years troubleshooting and problem-solving experience
- Experience in AWS database technologies
- Oracle 9i, 10g, 11g and 12c
- SQL, PL/SQL, UNIX, and Shell scripting
- RAC, Database Vault and Audit Vault; and
- Web Logic and OID
- Translate a logical data model or user specifications into a physical design
- Ensure detailed physical design of data structures and database compiles with enterprise standards, guidelines, procedures, and processes
- Coordinate with systems engineers to configure servers for DBMS product installation and database creation
- Provide on-site, and on-call 7x24x365 support, as needed
- Implement monitoring procedures to maximize availability and performance of the database, while meeting defined SLA's
- Lead in Identifying, defining and implementing database backup / recovery and security strategies
- Duties may include leading highly complex capacity planning, workload modeling, system maintenance/ administration, and diagnostics
- Teamwork, involves working well in a collaborative setting
- Self-Development
- 5+ years applicable experience in the design/administration/ support of one or more DBMS platforms required
- In depth experience in the design, administration, implementation, and support of a database using Oracle RAC, Data Guard, Oracle 12c and OEM 12c required
Exadata, Oracle Database Administrator Resume Examples & Samples
- Install, configure and support Oracle databases for Business Systems environments
- Proactively monitor databases for optimal performance; monitor space and capacity, estimate sizing and growth requirements
- Database performance tuning, review & tune complex SQL statements
- Plan, coordinate, test and roll-out Oracle patches & upgrades
- Assist in Disaster Recovery documentation, planning, and testing
- Setup, configuration, and management of RMAN backups and restores
- Manage and support Oracle Exadata appliance, Oracle database appliance (ODA), and Oracle APEX.· Document and maintain database standards and operations procedures· Participate in rotational on-call coverage and production releases/conversions· Evaluate new features and technologies, provide recommendations to improve existing environments· Create run-book procedure for repeatability· Participate in planning and testing of disaster recovery process· Work with developers reviewing database schema changes for upcoming projects/releases
- 7 + years working as an Oracle DBA
- 7+ years working Oracle DataGuard, Cloud Control (12C), DB Compression and Partition
- 5 + years working with Oracle on Unix/Linux
- Skilled experience managing Oracle 11gR2 RAC databases and clusters
- Strong experience managing Oracle Exadata appliance, and Oracle Database Appliance
- Strong RMAN backup and recovery skills
- Strong experience with managing Oracle’s XML DB
- Knowledge of Networker database backup tool
- Experience with implementing & administrating Oracle RAC DB on Exadata
- Experience working with various database management systems in database design, testing, implementation, maintenance and administration
- Proven hands on experience in performing database upgrades
- Strong SQL DDL, DML, and PLSQL coding skills
- Strong query tuning and performance problem solving skills
- Experience managing large multi-terabyte databases Experience installing, upgrading, and managing Oracle Enterprise Manager Grid Control
- Self-starter with ability to work in a team environment
- Demonstrated ability to manage multiple competing tasks simultaneously and complete work within allocated time-frames
- Competent in Unix/Linux shell scripting
- Manage the daily operation of enterprise-class Oracle platforms to provide reliable, highly-available and secure data services to the business
- Participate in the design and implementation of new Oracle Database platforms. Install and configure Oracle Database products including Diagnostic and Tuning Packs, Oracle Enterprise Manager (OEM), Partitioning, and Real Application Cluster (RAC)
- Work with development teams to identify and implement new database objects including tables, indices, packages and procedures. Ensure implementation meets application development team requirements
- Deploy objects to production and non-production environments. Troubleshoot issues related to the database platform. Create support tickets and work with Oracle as needed
- Perform tuning activities. Review and tune SQL and PL/SQL code. Identify, recommend, and implement performance improvements
- Work with Security and Compliance teams to ensure appropriate security and access controls are in place
- Maintain documentation related to infrastructure and architecture of database systems. Produce project-related documentation and provide estimates to the Project Lead or Manager for work to be completed
- Practice and promote teamwork at all times. Set a good personal example of attitude and performance
- Expert knowledge of SAP Sybase Adaptive Server Enterprise and SAP Sybase Replication Server
- 7+ years experience administering large high volume geo-redundant database architectures
- Experience leading complex database deployments and projects
- Proficient in Shell scripting and at least one of the following languages are required: Python, Ruby, or Java
- Tenacious troubleshooting skills: you can fix anything
- Willingness to take the initiative to contribute beyond your own responsibilities
- Ability and interest to learn and deploy new technology quickly
- Obsessively detail oriented
- Oracle, Hadoop, SAP Hana, or SAP IQ server administration experience
- Database geek, Passionate and self-motivated
- Desire to not only maintain but improve existing systems
- Strong focus on efficiency, simplicity and maintainability
- Advanced LINUX and UNIX skills and experience
- Familiarity with infrastructure automation using tools like Salt, Chef, and Puppet
- Experience in a "continuous deployment" environments
- Ability to juggle multiple projects and drive them from the ground up in a fast-paced environment
- Adept at using source code revision systems such as Perforce, Subversion or CVS
- Experience with the following technologies – SAP Basis, Net-Cracker, AWS and Big data
- Has proven success in leading a team in providing creative and innovative ideas and solutions to complex business issues
- Can create a communication strategy/plan consistent with line of business/company vision
- Ability to think creatively and come up with compelling programs
- Ability to work independently and handle multiple priorities; develop project timeliness (from start to finish) with capability to see obstacles early and provide solutions
- Excellent leadership skills, interpersonal skills, and able to interact with all levels of staff including peers and senior management
- Action oriented, willingness to take the initiative, and a desire to roll up sleeves and dig into the depths of the business
- Analytically sound with ability to track, process and present financials and key operating metrics unique to business model
- Excellent understanding of budgeting and P&Ls; ability to deliver objectives within budgetary boundaries
- 6+ years of increasingly responsible employee management and operational experience
- Professional demeanor and team player oriented; ability to interface with all levels in the organization and external parties
- Ability to perform duties under minimal supervision while exercising discretion and independent judgment
- Ability to train and motivate personnel in order to balance staffing strengths with growth and operational excellence
- Ability to work on an Agile work environment
- Knowledge of SOX and CPI security compliance policies
- Product knowledge in software technologies such as: AWS migration & private and public cloud solutions, Open source database technology, Knowledge of DaaS / IaaS cloud platform management, Enterprise IT architecture such as cloud computing, virtualization, application design, rating systems, SAP, Net-Cracker, Digital Route, Pega, Oracle DB Vault, RDBMS, NoSQL, PL/SQL development, Cassandra, MongoDB, SAP HANA, SAB Basis knowledge, Shareplex, IBM-cdc, Oracle Data-guard, Oracle 12c, SQL-baseline
- Keeps stability and reliability of databases proactively reacts to data growth /risks/ issues
- Works on the other environments which include
- General database maintenance
- Best practices implementation and improvement of the processes being used
- Install and configure Oracle E-Business Suite 12.2.x and 11.5.10.2
- Upgrade Oracle EBS from 11i to R12.2.x
- Perform Oracle EBS application and database platform migration
- Perform Database upgrade from 11g to 12c
- Patching and cloning Oracle Database and Oracle E-Business Suite (EBS)
- Performance tuning of Oracle Database 10g, 11g ,12c and Oracle E-Business Suite 11i and R12.2.x
- Installation, configuration and support of Oracle Database 11g, 12c
- Installation and configuration of Oracle Application Servers Infrastructure and Middle Tier
- Implementation and Configuration of Oracle forms, reports, OC4J Applications
- Installation, configuration and maintenance of Grid Control 12c to monitor all the hardware, applications and network status
- Maintenance of Oracle Internet Directory, Oracle OAM and synchronization between OID and Microsoft Active Directory
- Monitor and record uptime and performance of Oracle Databases for SLA reports
- Shell scripting and SQL programming to automate day-to-day jobs like storage, system resource monitoring etc
- Demonstrate knowledge of Hyperion, Cognos and Oracle Apex systems
- Bachelor’s degree in Computer Science, Computer Engineering or a technically related field or equivalent experience
- 7+ years of experience in Oracle database development
- Key skill requirements for this role include: Linux, ksh scripting, Oracle, PL/SQL, Oracle Utilities, and database performance concepts with emphasis on transform and load and parallel processing
- Experience in developing, testing, and implementing DDL and database processes and procedures is required
- Experience with Oracle RAC and Exadata platform would be advantageous
- Exposure to Automation tools such as bladelogic would be advantageous
- Experience with Oracle Replication using materialized views would be advantageous
- Experience with IBM CDC (Change Data Capture) and DataStage would be advantageous
- Oracle Backup/Recovery and Performance Tuning would be advantageous
- Experience with non-Oracle database technologies and development tools (i.e. DB2, SQL Server, Postgres, etc…) would advantageous
- Candidate must have current eligibility for DoD clearance at the SECRET level
- Compliance with all company Information Systems security policies and procedures
- Personally responsible for proper classification and marking of all information and materials, in any form, produced by the incumbent
- Shall be assigned specific responsibility for Information Security by immediate supervisor or department management
- Shall not divulge any information, or afford access, to other employees not having a need-to-know
- Shall not divulge information outside company without management approval
- Incumbent shall execute company non-disclosure agreement prior to access to any controlled information
- BS/MS in Computer or Information Science, Software Engineering, or related field
- 8 years of experience in GIS systems design and development with focus on data management
- UNIX (Solaris)
- HPC web/cloud/mobile computing and storage technologies
- Systems/network engineering
- Oracle database administration
- Technical areas of expertise must include: knowledge of current 3D model development methodologies, design tools, assessment techniques, and test and inspection processes
- Related skill areas should include: technical writing and presentation, technical effort estimating, and task performance management
- Ability to effectively present information and respond to questions from senior management, peers, and customers
- Designing, installing, provisioning, configuring, optimizing, performance tuning, integrating, and administering Oracle database solution technologies in a lab environment
- Developing comprehensive test cases to include testing scenarios for both normal and degraded (e.g., disaster recovery, continuity of operations, data recovery/spills, etc.) operations, pass/fail criteria, performance criteria, capacity planning, measurement criteria, results analysis procedures, and results/status reporting criteria
- Supporting the installation of new Oracle database components, if required
- Monitor the performance of production databases, identify areas where performance needs to be improved and provide fixes/solutions for the performance issues
- Develop database tools to automate existing database tasks
- Participate in the ongoing support of developed applications
- Respond appropriately to emergency technical support situations and produce quick and effective solutions to database technical problems under high pressure
- Work with database personnel to design physical and logical databases to support present / future business application
- Participate in an on-call rotation and other duties as defined by Tesla management
- 8+ years of hands-on database design, programming and tuning experience
- In-depth knowledge of various Oracle database technologies, such as Oracle 10g, Oracle 11g, Enterprise User Security, etc
- Strong skills in database and SQL performance tuning and troubleshooting
- Must be a US citizen or Eligible to be cleared with a DoD Security Clearance of SECRET
- Oracle Replication such as Golden Gate
- Knowledge of High Availability Disaster Recovery (HADR) options
- Government contracting experience, preferably with Department of Defense and/or US Army’s Military Surface Deployment & Distribution Command (SDDC)
Linux / Oracle Database Administrator Resume Examples & Samples
- Install, configure and update database hardware and software
- Operate and maintain all integrated systems to support mission operations
- Perform daily application updates and maintenance functions
- Respond to Tier 3 and Tier 4 trouble tickets
- Open trouble tickets and respond to trouble calls
- Respond to management system alerts
- Deploy monthly security patches and updates
- Respond to after-hours trouble calls
- Support annual FISMA and NIST security requirements
- Participate as a member of a small, multi-disciplinary team that works cooperatively to ensure supported applications are available to support the customer mission
- Learn other team responsibilities/technologies to enable acting as backup/augmentation as required
- The person qualified for this position has previously installed, operated and maintained Oracle 11g and 12c databases that are hosted on Linux operating system environments
- Experience working on a modern virtualized network is required
- Experience working in a classified environment is required
- Supporting Oracle, MySQL, and other database systems
- Planning, implementing and managing the physical databases of mission critical OLTP and Decision Support systems
- Strong troubleshooting skills
- Security+ Certification and an active Secret clearance
- Oracle Certified Professional 11g or 12c (or ability to obtain one prior to start date)
- Bachelor's degree or additional work experience in lieu of a degree
- Five (5) or more years in Oracle database administration
- Experience with Oracle 12c Database and RHEL 6 (Red Hat Enterprise Linux)
- Experience with Real Application Clusters (RAC), Opatch, Recovery Manager (RMAN), and Transparent Data Encryption
- Any knowledge or experience with Teradata, Informatica, SAP Business Objects and Cognos is a big plus
- Maintain high level of availability and performance on all production, test and development 12c Real Application Cluster (RAC) databases
- Review systems to maintain an aggressive security stance including applying Oracle quarterly Patch Set Units (PSU)
- Support administrative efforts of the application and third party COTS products, coordinating with Operations Manager, end users and hosting agencies
- Contribute to development efforts based on requirements from government representatives
- MySQL database experience
- Experience supporting Oracle in AWS
- Effective communication and problem-solving abilities
TS / SCI Oracle Database Administrator Resume Examples & Samples
- Ensures that sufficient system resources are in place to support the operations, growth, resiliency, synchronization, and backup/recovery of all production databases. Support database users in meeting mission requirements by managing and updating user access rights, data schemas, integration with applications, and evaluating data warehouse needs
- Monitors and maintains the security of databases and database software on corporate, application, database, role, program, and when applicable, table, view; and column levels in cooperation with security experts and systems programmers
- Conducts database testing when integrating new production releases in support of changes, enhancements, and the integration of new systems/functions
- Provides Database Support Monthly Status Report input to program manager
- Data Translation, Data Integration, Data Reconciliation, Data Administration, Data Storage, Data Warehousing, Data Mining, and Data Analysis and Reporting
- Performs data asset identification and data asset standardization
- Maintains data quality through the translation, integration and reconciliation of enterprise data structures and values, as required
- Supports data utilization (e.g., data mining and data warehousing)
- Supports data management planning, including data administration strategic planning, enterprise data model maintenance, establishing and maintaining enterprise data asset policies and procedures, and publishing data requirement specifications
- Establishes and maintains a data asset inventory to include a dictionary, mapping to logical models, mapping to physical models, and mapping to translations
- Global Command & Control System(GCCS),
- Global Command & Control System-Top Secret(GCCS-T) system
- Status of Resources and Training System (SORTS)Common Operational Picture (COP)
Oracle Database Administrator Technical Specialist Resume Examples & Samples
- Review and analyze database requirements; develop detailed database design specifications to meet identified requirements
- Review and analyze user needs; determine equipment and software requirements for solutions to problems
- Install and maintain database performance by developing tuning methodologies
- Install and maintain Oracle 11G and 12C RAC primary and standby databases with partitioning
- Manage and implement database security and user accounts
- Design and implement backup and recovery strategies
- Assist with the design and development of data models as needed
- Assist with the development and implementation of database/SQL standards and methodologies
- Analyze and report on database metrics; administer and control data resources; monitor and ensure database integrity, security, and performance; and implement tools to improve database performance
- Develop and maintain stored procedures and write complex database queries
- Work with customer to gather data requirements and generate ad-hoc data requests
- Work with customers to establish and maintain excellent working relationships, resolve issues, and promote team services and capabilities
- 10 years relevant experience, at least 3 within the IC
- Bachelors degree in computer science or technology discipline
- Current and active TS/SCI clearance with CI polygraph
- Working knowledge of data modeling; database administration problems and requirements; and database analysis and design procedures, techniques, and implementation
- Experience with Oracle 10g, and 11g in a Unix / Linux environment
- PL/SQL experience which includes creating, loading, debugging, and managing Oracle stored procedures, packages and functions
- 10g RAC / Cluster experience is a must
- Proven ability to handle multiple projects and meet deadlines
- Ability to work independently and as a member of various teams and committees
- Strong organizational, problem-solving, and analytical skills
- Versatility, flexibility, and a willingness to work within constantly changing priorities with enthusiasm
- Knowledge of CFO business processes and their inter-relationships is highly desirable
- Must be able to communicate effectively with various types of customers, employees, managers, and vendors to identify and resolve FMS related issues
- Ability to work effectively in a fast paced changing environment - multi-tasking, prioritization, and ability to meet deadlines in a timely manner
- Ability to solve problems quickly and completely
- Knowledge of Oracle 10 / 11g, Oracle 10 / 11G RAC
- Highly desirable Oracle Dataguard, Oracle GRID Control, ASM, Recovery Manager, Datapump
- 2 years DBA experience, preferably as a Production Support DBA
- Administer Oracle 11 and 12c and Microsoft SQL database servers
- Administer hosted Oracle solutions
- Perform database resource monitoring and performance tuning
- Perform backup and restores of Oracle databases
- Manage Oracle Data Warehouse
- Manage various Oracle tools (Oracle client, Toad, SQL developer and Apex)
- Configure and maintain Oracle database servers for disaster recovery
- Work with Microsoft Windows clustering to support Oracle on windows for high availability
- Maintain and monitor database replication
- Perform data refresh tasks and automate new or manual process
- Troubleshoot, Root Cause Analysis
- Bachelor’s degree or equivalent years of experience (focus in technical field a plus, for example: engineering, mathematics, statistics, computer science or related field) plus at least 15+ years of experience working as a database administrator of Oracle, Microsoft SQL Server
- Administer Oracle 11 and 12c and Microsoft SQL 2008/2012/2014/2016 database servers
- Deploy encryption to all Oracle databases
- RMAN and NetBackup experience
- Architect and migrate on premise databases to hosted solutions
- Experience running Oracle Platform as a Service (PaaS) or Software as a Service (SaaS)
- Ability to architect and maintain database high availability and disaster recovery
- Administer Oracle Database hosted on Microsoft Server Clusters
- Author and Promote Process Improvement
- Provide technical documentation to support internal change control processes
- Adhere to Information Security Policies
- 6+ years of experience as an Oracle Database administrator, including patching databases and clusters
- 5+ years of experience with Oracle Database installations, upgrades and configurations, and administration on Linux OS
- 5+ years of experience with Oracle backups, restores, recovery setup clustering, and database mirroring, including Oracle Data Guard
- 5+ years of experience with tuning and optimizing SQL statements for high performance
- 3+ years of experience with troubleshooting performance and stability issues across various layers of infrastructure
- Experience with troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocks, replication issues, connectivity issues, and security issues
- Experience with creating and executing complex database SQL queries
- Experience with Oracle E–Business Suite Release 12, including 12.0.x, 12.1.x, or 12.2.x
- Experience with Oracle Forms and Reports Server
- Experience in a virtualized environment, including VMware as a UNIX or Linux system administrator, supporting a large Enterprise
- Experience with installing, configuring, and managing applications servers, including Oracle Application Server (OAS), Tomcat Application Server, JBoss, or any other applications servers
- Experience with information assurance technical framework
- Knowledge of the systems engineering process (SEP)
- Knowledge of database parameter tuning and impact analysis from a technical viewpoint
- Knowledge of database filesystems, including ASM, ACFS, and OCFS2
- Knowledge of Microsoft Active Directory
- Ability to quickly adapt to new situations, work in a team environment, work with little supervision, and to learn new technologies
- Ability to develop, plan, and lead segments of a project independently and collaborating as part of larger teams
- BS degree in Engineering or Information Systems preferred
- Oracle Certified Professional or Oracle Certified Associate 11g or 12c Certification preferred
- Responsible for the administration, configuration, installation, monitoring, maintenance and upgrade of databases
- Improving database performance and capacity and for planning future expansion requirements and may also plan, coordinate and implement security measures to safeguard the database
- Administer the data integrity of all databases by controlling and coordinating all changes, updates and deletes to the database configurations
- Control the accuracy, completeness and timeliness of data stored by developing, implementing and enforcing database policies, procedures and guidelines
- Control the efficient use of data access and storage by advising developers and analysts on best practices
- Responsible for analysis, troubleshooting and resolution of database issues, investigation of service interruptions and creation of preventative measures
- Maintains database documentation
- Follows IT policies and procedures and maintains working knowledge of utilized technologies
- 5 years of database administration experience in Oracle
- Oracle 12c experience is an asset
- Ability to work closely with the DBA team members
- RMAN backup
- Experience with WebSphere
- Bachelors and nine (9) years or more experience or 13 years of related experience without the degree
- Active TS/SCI security clearance
- Oracle 11g Database Administrator Certified Associate or equivalent/higher certification for DoD 8570 network/computing environment
- IAT II Compliant: CompTIA Security+ or equivalent
- 5 or more years of demonstrated advanced, hands-on, Oracle database (11g/12c) administration experience supporting the design, installation, configuration, development, integration, implementation, and testing of Oracle database services in a complex environment with multiple classification enclaves and integrated with DoD C2 systems utilizing associated information assurance processes/procedures
- Demonstrated advanced experience supporting and troubleshooting Oracle database, server, and hosted application issues reported through monitoring or customer submittals
- Demonstrated familiarity with Enterprise IT environments (data center, computing, storage, network, security, backup/recovery, policies and procedures)
- Demonstrated experience in the development and refinement of processes and procedures to ensure efficient, repeatable and effective monitoring and troubleshooting of Oracle database systems
- Interpersonal skills including the ability to collaborate effectively, self-awareness, and excellent written and oral communications
- Ability to drive efficient resolution of all incidents through analytical and structured approaches to problem solving
- Experience with ITIL methodology; specifically Incident, Request and Change management principles and tracking systems
- Experience with Operations support within an ITIL Service Operations management framework, including use of Service Now or Remedy service management tools
- Experience with IT service management best practices such as change, problem, incident, configuration and service level management
- Participate in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions
- Perform capacity planning work on Production, UA, QA, DEV and DR environments
- Participate in 24 X 7 Support of production environment and mission-critical applications with the Database Technology team on a rotational schedule
- Communicate and coordinate with Hub IT teams to successfully resolve support and maintenance issues
- B.S. in Computer Science or similar field, M.S. or MBA preferred
- 7+ years’ experience developing, maintaining and administering Oracle 9g/10g/11g/12c databases
- 2+ years developing, maintaining and administering MS SQL Server databases preferred
- 2+ years’ experience of Netezza appliance administration desired
- A clear understanding of Oracle application and database architecture
- Experience with Oracle Transportation Management strongly desired
- Ability to install and configure RDBMS, layered and third party software unassisted
- Proficiency with most database utilities such as RMAN, SQL loader, export, import, data pump, Data Guard etc
- Advanced proficiency with tuning and monitoring tools such as OEM, and other third-party tools
- Advanced SQL and PL/SQL programming skills with ability to write, debug and tune packages, procedures and functions
- Experience with SQL Net and understanding of networking as it applies to database operations
- Thorough knowledge of UNIX operating system and shell scripting
- Install/configure ASM, experience with SAN/NAS storage technologies such as EMC, NetApp, and ZFS
- Experience with server clustering techniques, data replication technologies and RAC
- Knowledge of Internet/Intranet, client/server technologies
- Minimum 1 year of experience as an Oracle Development DBA in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS)
- Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
- Basic knowledge of Oracle Data Dictionary views
- Basic knowledge of UNIX/Linux (from user perspective, not as admin) inclusive of writing and maintaining shell scripts to run data exports/imports, user creations etc. to support day-to-day database operations
- Knowledge of Data Pump, shell scripting, TOAD or SQL Developer, GIT would be a nice to have
- Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
- Good knowledge of data structure
- Experience in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
- Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
- Experience with schema upgrade/rollback/initial install scripts
- Basic knowledge of ITIL best practices and tools (Service Now, BMC Remedy etc.). Knowhow of writing Change, Problem or Incident tickets is a must
- Good organization skills. Ability to handle multiple tasks simultaneously and work with manager to get the appropriate priority level assigned to meet strict deadlines
- Good written and verbal communication & presentation skills - effectively present information and respond to questions from clients, vendors and staff; ability to interpret an extensive variety of technical instructions in an architectural/functional diagram
- Demonstrated technical team leadership
- Demonstrated service level metrics and analysis in a cloud environment
- Participates in operational readiness of new technology releases and updates production environments
- Ensures management is aware of all risks to system availability, performance, reliability and security
- Recommend enterprise-wide standards, guidelines, and procedures for server / equipment
- Experience administering Oracle 11g and 12c Clusterware
- Experience with migrating databases form Oracle 11g to Oracle 12c
- Implementing RAC, ASM and Dataguard in a production environment
- Configure Flash Recovery Area and Flashback database
- Configure and use Oracle Cloud Control for database monitoring
- Knowledge of Oracle RMAN & Datapump utilities
- Experience in Database Reorgs
- Knowledge of Cost-based Optimizer and SQL Tuning
- Knowledge of Database Modeling
- Experience with Oracle Partitioning
- Excellent writing/documentation skills
- Significant experience troubleshooting complicated database problems
- Experience researching and recommending technology solutions
- Experience with Exadata and/or MySQL platforms preferred
- Willingness to learn and support other database technologies
- 10+ years related experience as a database administrator utilizing Oracle 12c and 11g
- Experience managing highly-available databases using RAC, ASM, DataGuard, and/or GoldenGate
- Requires technical knowledge and experience with database environments, tools, utilities, configurations, backup and recovery, job scheduling, release management, change management and compliance
- Knowledge of all key Oracle utilities such as RMAN, OEM, DataPump
- Excellent oral and written communication skills with the ability to communicate technical concepts
- 5+ years SQL, PL\SQL scripting
- 3+ years Unix and Linux operating systems
- 2+ years UNIX shell scripting
- Experience working with Oracle Engineered systems
- Knowledge of Oracle Directory Services, and Database Vault
- Previous experience effectively leading offshore teams
- Operational, service and technical knowledge in multiple Information Technology disciplines
- Bachelor’s degree, preferably in Computer Science/Technology or Engineering, or equivalent relevant work experience
- 8 years of experience in Oracle administration – install, configure, upgrade, performance tuning, monitoring, troubleshooting and resolving issues
- Experience in managing large and mission critical databases on Oracle 12c
- Experience with SQL, PL/SQL
- Hands-on experience in RMAN, Oracle RAC, ASM and Enterprise Manager
- Proficiency in performance and tuning of large database environment
- UNIX Shell scripting experience
- Oracle OCP Certification is a plus
- Review and ensure integrity via standardized support tools. Work on complex problems where analysis of situation or data requires an in-depth evaluation of various factors
- Provide comprehensive productive support of all Oracle databases (10g-12c)
- Act as the Subject Matter Expert (SME) for the database systems entrusted in his/her care
- Bachelor's degree in technology field and 8+ years of related experience. Additional years of DBA experience will be considered in lieu of a Bachelor's degree
- Hands-on experience with: Oracle RAC, Oracle ASM, Oracle 12c and container DBs, SQL Tuning, Linux and PL/SQL scripting, database upgrades / patching / monitoring
- Hands-on experience with: Exadata Administration, In-memory 12c implementation, Data replication techniques, Use of ETL/ELT tools
- 1) Provide technical leadership in analysis, design, building, testing, implementation & support of technologies within the assigned workspace
- 2) Develop and implement processes, procedures and standards that contribute to quality and scale
- 3) Provide technology life cycle management in accordance with company policies
- 4) Contribute to the creation and execution on technical plans for M&A integrations
- Technology Execution
- 1) Plan, design, build, test and support technology components
- 2) Develop and implement plans to transition technology components to IT Operations
- 3) Ensure security and audit compliance
- 4) Ensure both external and internal service levels can be met
- 5) Participate in pre-scheduled 24x7x365 system on-call support
- Partnerships
- 1) Partner with Enterprise Architecture in identifying and evaluating new technologies to support business requirements
- 2) Partner with other IT Organizations to ensure technology is being leveraged to its fullest extent in support of the business
- 3) Partner with external vendors and service providers to learn about offerings that can enhance functionality and scale
- A minimum of 8 years of related experience
- Requires strong technical expertise in multiple areas
- Requires analytical ability, strong judgment, problem solving skills, and effective human relations skills to work cross functionally across the Enterprise with staff and all levels of management in various disciplines
- Ability to function in a complex environment thru multi-tasking and establishing and communicating priorities
- Strong interpersonal and communications skills; capable of writing proposals or papers, acting as a vendor liaison, making presentations to customers or client audiences or professional peers, and working closely with upper management and outsourced service provider
- Strong listening and collaboration skills; must work effectively with application developers, QA, and Data Architects
- Strong Linux shell scripting skills
- Strong relational database analysis and design skills; ability to translate business requirements into designs that perform appropriately
- Strong knowledge of SQL; ability to transfer knowledge to others
- Solid understanding of backup/recovery technologies; ability to specify requirements to the Provider and ensure the requirements are met
- Strong knowledge of Oracle technologies including but not limited to RAC, GoldenGate, RMAN, Standby, SQL Plans, high availability architectures and AWR reporting and analysis
- Working knowledge of SQL Server
- Ability to apply DBMS features/functions to solve a business problem
- Strong knowledge of DBMS replication capabilities between geographically dispersed environments
- Post graduate course work in Computer Science or Business Administration a plus
- Strong background in administering Oracle databases on linux systems using various database technologies and products (e.g. Oracle 12c or 11g or 10g, Oracle RAC, Oracle Data Guard, Rman, ASM storage)
- Broad Technical Knowledge – understanding of various areas of technology outside database administration such as Operating Systems (Linux and Windows), Networking, Storage (SAN, NAS)
- Collaboration -- Strong ability to work with multi-team framework, as an individual and a member of a larger group
- Communications -- strong writing skills, ability to articulate solutions in a concise manner, and presentation skills. Ability to communicate in English with all other database administrators of the Database competency Center
- Sense of responsibility (administration of critical databases for the ADP business)
- Minimum 1.5 years of production linux / oracle databases administration experience
- Working knowledge in scripting (Linux, Shell scriptingBash, Korn, Perl)
- Experience in MsSql database administration
- Customers' satisfaction oriented
- Logical and deductive capabilities (diagnosis oriented)
- CSI attitude (works to understand and improve procedures)
- Flexible mind (ability to work in different cultural environment)
- Be proactive
- Installing Oracle software (Grid Infrastructure and Rdbms) and creating Oracle databases
- Performing upgrades / patches /migration of the database and software to new release levels
- Managing the database storage
- Managing users and security (privileges, access, audit etc ..)
- Managing Schema Objects
- Performing Backup and Recovery operations when necessary
- Monitoring the state of the database and taking preventive or corrective action as required
- Monitoring and tuning database performance (resolving performance problems and tuning sql statements)
- Diagnosing and solving errors, incidents
- Ensuring high availability (Real application Cluster, DataGuard, Disaster Recovery)
- Participate in the rotating 24x7 support environment shifts, which could include technical support
- Documentation, Reporting (production of Key Performance Indicators)
- Participation in database projects (such as Virtualization on Vmware or new oracle features deployment)
- Support of Internal Service owners (migration project for example) and Tier 2 (delegation of current database tasks)
- Support all Jasper Cisco data center databases built and operational, including
- All database systems in the data-center in a 24x7 environment
- All database systems in the development/QA environment(s) in a 24x7 environment
- Define Oracle database architecture and strategies to meet application availability, scalability and performance requirement
- Regularly review the health of the databases and ensure it is operating optimally
- Contribute to improving and creating DBA policies, procedures and standards
- Provide technical guidance for integration, testing, design and planning for new major, large scale production systems/databases
- Support SQL Performance tuning and backup and restore activities
- Troubleshoot all database related problems and resource management
- Provide database support to all Jasper team members
- 5 to 10 years experience with 24x7 Production and development databases
- DBA certification preferred
- RAC experience preferred
- Strong English speaking, writing and communication skills
- Configure and manage multiple Oracle 12c Databases in support of complex Momentum Financials and reporting solution
- A four-year degree in technical field or equivalent experience
- 7-9 years experience with Oracle databases
- Knowledge and experience optimizing database performance
- In depth understanding of the Oracle Query Optimizer and execution plans
- Materialized Views, Global Temp Tables, Compression, and Partitions
- Oracle certification backed by experience strongly desirable
- Typically requires bachelor’s degree or equivalent, and two to four years of related database experience
- Must have experience in Oracle 11g Database
- Three (3) years of demonstrated experience including
- Oracle Certified Associate credentials
Oracle Database Administrator / Developer Resume Examples & Samples
- Development activities in support of clients’ requests
- Database requirements analysis
- Writing effective, complex SQL, and PL/SQL code, Materialize Views, etc
- Database scripts/package deployment
- Database capacity analysis
- Database administration/architectural activities
- Conduct database architecture assessment/review/design
- Perform Oracle database patching/upgrade
- Perform Oracle database cloning/backup/recovery
- Conduct Oracle data migration
- Monitor ADR database performance
- Provide support to configuration/deployment management in deployment process
- Provide technical input to management team during meetings
- Thinking and reasoning with a good analytical ability
- Must be a self-motivated team player
- Must be cooperative in nature
- In depth understanding of Oracle fundamental logical and physical architecture from a database and instance perspective
- Extensive knowledge of database/SQL performance assessment and tuning
- Deep understanding Oracle Maximum Availability Architecture (MAA), Load Balancing, Failover
- Hands-on experience with Oracle 11g+ Technologies including
- Knowledge of Oracle Advanced Security
- Knowledge or experience with Oracle Exadata Platform
- Knowledge or experience of Oracle Cloud Technology, PaaS, DaaS
- Knowledge or experience with Oracle 12c, GoldenGate
- Prior experience with the Department of Veterans Affairs
- Understanding of Object Relational Mapping framework such as Hibernate
- Experience with IBM Jazz RTC
- Knowledge about application server, J2EE, or similar technologies
- Administration of Oracle RAC databases on Linux – adhering to standard operating procedures
- Enforce best practices in all areas of database administration and architecture
- Participate in 24x7 on-call rotation for production databases
- Develop scripts for reporting, data manipulation and automation of administration procedures
- Provide support to Development and QA teams on applications/database issues
- Administration and support of Informatica
- Develop and document formal processes and procedures
- OLAP (Online Analytical Processing),OLTP (online transaction processing), Data Warehouse, and Extract, Transform, Load (ETL), and RMAN (Recovery Manager)
- Computer Science, or related science/Engineering degree (B.S. or equivalent)
- At least 5 years production Oracle DBA experience in a Linux/UNIX environment
- At least 2 years of experience with Oracle Real Time Application Clusters 12c with ASM and dNFS
- Linux system knowledge sufficient to configure, maintain and monitor Oracle instance(s)
- Knowledge of Oracle 12c Cloud Control
- Experience with OLTP, OLAP, DW, and ETL concepts
- Experience with parallel processing, and partitioning
- Experience with Oracle Data Guard and RMAN, TDE, DNFS
- Database and SQL performance tuning experience
- Familiarity with the Full Software Development Lifecycle (SDLC), change control processes and tools (Atlassian Tool Suite )
- Familiarity with the Agile Development Methodology and DevOps
- Knowledge of version control tools (GIT, SVN etc.)
- Knowledge of server configuration management tools is a plus (Puppet, Chef etc)
- Demonstrated knowledge of scripting (BASH,Python,Perl etc.)
- Demonstrated proficiency of SQL/PL SQL
- Familiarity with HTML/ JAVA / XML/ JSON /PHP is desired
- Familiarity with other database technologies (Postgres, MySQL, MS SQL)
- Exposure to NoSQL tools and technologies
- Exposure to Netapp Storage is a plus
- Understanding of cloud technologies
- Will require after-hours or occasional weekend work to make changes during outage windows
- Ability to perform well in a team of Database/System Administrator professionals
- Proficient level scripting ability (perl, ksh, bash, or equivalent common scripting language)
- Proficient level ability using Unix and Windows command syntax
- Proficient level ability creating diagrams and documentation of database architecture
- General understanding of network topologies including both local LAN and WAN architectures
- Proficient level ability using general software and tools including but not limited to Toad, Microsoft Windows based workstations, Microsoft Office suite of applications, and general local or web based software tools
- Expert level of understanding regarding architecture, use, configuration, support and maintenance of Oracle RDBMS including Oracle 11g and 12c
- Expert level of understanding regarding disaster recovery architectures within an Oracle environment, including use, configuration, maintenance and monitoring of both Logical and Physical Standby Databases
- Proficient level understanding regarding architecture, use, configuration, support and maintenance of Oracle related products, including but not limited to
- Perform setup and tuning of system parameters
- Enable the DBMS to work with storage devices and storage management software
- Interface with any other technologies required by database applications
- Plan and implement backups and recovery
- Create new schemas and user accounts with required privileges
- Provide import or export support for datasets
- Experience with database networking security, including PKI certificates, Oracle wallets, Java Keystores, and configuring SSL/TLS
- Schedule Flexibility (preferably works 8 hours between the hours of 9a and 7p)
- Experience supporting MySQL
- Experience with Oracle replication technologies Oracle Streams, Oracle GoldenGate
- Experience installing and configuring Galera Cluster for MySQL
- 5+ years of experience with providing database and database systems administration support
- 5+ years of experience with conducting database system design
- 5+ years of experience with conducting database application development
- Experience with Navy systems and requirements
- Knowledge of shipyard operations and requirements
- BS in computer Science or equivalent with a minimum of 5 years of Oracle DBA experience; experience with Oracle databases hosted on Linux is must
- Candidate must be familiar with Oracle DB version 11g
- Candidates must be familiar with Oracle RAC, ASM/ACFS
- Candidates must be familiar with Oracle's standby / data guard technologies, and partitioning
- Candidates should have good experience with oracle software install, Oracle software patching, and backup/recovery using rman
- Strong hands-on experience with SQL optimization, database bottleneck troubleshooting and database performance tuning
- Excellent interpersonal, written and verbal communication skills and effective problem solving skills
- Passionate about Continuous Improvement
- Experience working with OEM 12c a plus
- Experience working with Open Source databases MySQL and MongoDB a plus
- Experience monitoring and configuring Linux servers a plus
- Provide technical support for the company's production databases and associated technologies, including Oracle 10g, 11g and 12c, MySQL 5.6, and PostgreSQL 9.5
- Work with application owners to support database consolidation, migration and virtualization
- Work with developers and analysts to support development efforts
- Clone oracle databases as needed to support development and testing efforts
- Work with various internal teams such as server, storage, backup & network administration teams to coordinate and troubleshoot infrastructure related issues
- Implement, and maintain disaster recovery plans for critical production databases and applications
- Provide afterhours support as required and be part of on-call rotation
- Create and modify database structure using Data Definition Language (DDL) statements to create tables and appropriate indices for optimal data access, as well as database objects such as store procedures, functions, views, and triggers
- Determine trends and opportunities for improvement based on problem management methodology
- Provide technical leadership for administration, optimal performance, and availability of business systems
- Work with other IT departments to make sure data and systems are available and perform within SLAs
- Follow, enforce, and provide recommendations for improvement on the company change control process in order to implement system and application changes
- Coordinate with system vendors to resolve issues in a timely manner
- Ensure 24/7 systems availability and manage critical incidents by organizing resources; troubleshoot issues to full resolution and provide detailed updates to management
- Lead and mentor team members, enforcing adherence to standards and standard methodologies and architectures
- Implement, document, and adhere to Sarbanes Oxley Controls
- Collaborate with other IT departments to ensure systems are well integrated within release management
- Organize and perform monthly outage weekend and quarterly disaster recovery tests; perform post-mortem analysis in order to evaluate and gain greater procedural efficiency
- Install server-based application software in coordination with server administrators. Install new software, service packs, upgrades, and fixes
- Establish an architectural roadmap for product enhancement implementations
- Plan, prepare, implement, and test backup and recovery procedures for all production databases. Architect optimal business continuity solutions
- Experience working directly with business users to gather requirements
- Very good understanding of Oracle database design, architecture, security & performance tuning
- Expert in Production database/application maintenance support
- Skilled in SQL, PL/SQL, Perl, Linux shell and Windows scripting
- Good Knowledge in Weblogic/OBIEE/Tableau/Informatica applications
- Expert Performance Tuning experience in Warehouse environment with advance AWR/ASH/XPLAN experience
- Expert Partitioning experience in Warehouse environment
Senior Principal Oracle Database Administrator Resume Examples & Samples
- Oracle 11G and 12C database development, architecture, and administration
- Development of new schema, models, and 2nd tier models for 100 TB size databases
- Experience processing data, and a well rounded stable of other technical skills that help solve problems
- Working with a variety of database components or hardware such as ASM, Rack, Grid, RMAN, and Oracle Exadata appliances
- Bachelors degree or equivalent, and ten to twelve years of related experience
- Experience with oracle is required
- Oracle 11G database development on very large data sets
- Experience with distributed database environments such as Exadata
- Experience with other database types SQLServer, DB2, Hadoop
- PL/SQL creation and tuning
- Experience with the creation of data warehousing and 2nd tier data models
- Maintain and administer Oracle 11g and 12c databases in the enterprise environment
- Maintain and improve the various database environments, including installation, upgrades, performance, security, and change management
- Evaluate, Install, Configure and Test new release of database software and perform software patches on Physical and Virtual (VMware) Servers
- Define and maintain standard operating procedures specifically focused on database
- Administer all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures
- Implement and enforce security for all the Databases
- Monitor database growth, estimate growth and sizing requirements to implement changes to support growth
- Perform database administration including tablespace and database reorganization, database copy and migration & performance tuning
- Participate in the System Performance tuning and make recommendations
- Perform backup and recovery of the database, data files and tables using datapump export and import, hot and cold backup using Unix scripting and backup agent such as Veritas Enterprise Netbackup
- Strong understanding of Linux/Windows Administration and External SAN Storage
- Perform some self-training with guidance from lead DBA and administration of MS SQL Server database
- Assist application administrators in some minimal administration
- Work with IT staffs to gather requirements, support and troubleshoot the applications
- Work with Application administrator, developer, UNIX and Windows System Administrator and functional representatives to solve database level issues
- Develop and maintain Unix/Linux Scripts for automation, capacity planning, and monitoring
- Support interfaces to DataWarehouse, SAP, ERP, and CRM systems and to 3rd party tools such as MicroStrategy and Informatica
- Setup and maintain documentation, policies, and standards
- After hours support including weekends is required. Participate in providing 24/7 support on a rotation basis
- Good understanding of Veritas Enterprise Netbackup and Backup Agent
- Experience with EMC Timefinder for Snapshot
- Knowledge of Data Warehouse database such as Teradata
- Knowledge of ETL tools such as Informatica
- Experience with Reporting Tools such as Microstrategy
- Experience in a small, medium or large scale corporate/enterprise environments
- Experience with small, medium or large databases
- Entertainment industry background
- Knowledge of MS SQL Server, MySQL, Sybase Database, Teradata
- Capacity planning, sql analysis, schema revisions, security administration and user account maintenance are also required tasks
- Immediate participation in an active on call rotation required
- Provide off hours support to avoid impacting database availability during normal business hours
- Homogenize the performance of the database and optimize system resources
- Support efforts related to the proper protection from corruption & encryption of sensitive information
- Enhance and Apply Technical Product Knowledge
- Understand a given solution to assess its alignment with business needs, particularly with the new DevOps framework
- Discover mutually beneficial solutions across customers while recognizing different styles
- Maintain Oracle 10g and 12c Oracle databases in an Oracle RAC configuration
- Perform a full in-depth report of existing Oracle Database infrastructure
- Identify and document existing processes and procedures
- Responsible for providing design recommendations for database architecture
- Perform optimization, fine-tuning, and scalability techniques including RAC for mission-critical production systems
- Perform database backups and restores utilizing Oracle Secure Backup, as requested
- Provide level 3 support for Oracle database activities including mission-critical issues and requests
- Manage service and incident requests escalated from other internal teams
- Responsible for incident and problem management around production systems
- Install and perform Oracle upgrades and patches
- Respond to system alert conditions including hardware failures
- Responsible for the monitoring of all Oracle databases
- Plan and design effective database strategies
- 10+ years of strong experience as Oracle DBA
- Strong experience with database administration tasks for Oracle environments
- Experience with cloning databases, exporting, importing and copying data from one environment to another as needed
- Experience installing, configuring, and supporting Oracle environments, specifically 11g and 12c
- Experience doing Oracle database upgrades and patches
- Working knowledge of database performance tuning and configuration tools in Oracle
- Experience with database recoverability including backups, restores, DR and experience working on Oracle Dataguard, Oracle RMAN and GoldenGate
- Strong experience with Oracle RAC
- UNIX shell scripting experience to write UNIX shell scripts to help in database administration tasks
- Experience with Solaris 11
- Experience with Oracle Connection Manager
- Experience with recommending tactical and strategic solutions
- Expertise in troubleshooting all aspects of Oracle Server technologies
- Proficiency in Oracle optimization, fine-tuning, and scalability techniques including RAC for mission-critical production systems
- Proactively monitoring and maintaining production databases
- Perform logical database design review and physical database implementations
- Work with application teams on all aspects of database design including tables, views, stored procedures, packages and manage role based grants
- Document and provide development best practices
- Respond to production and/or mission-critical issues and needs
- Experience upgrading large environments with minimal downtime
- Experience working with Oracle SPAR T5 and Oracle ZS3 and ZS4 preferred
- Oracle certification a plus
- Experience with the Oracle OVM hypervisor a plus
- Excellent troubleshooting, problem-solving, organizational and documentation skills
- Strong written and verbal skills and comfortable preparing documentation of team procedures and guidelines
- Detail orientated, and the ability to record, organize, and communicate in a detail manner
- Ability to work flexible schedules when required
- Ability to multitask and appropriately prioritize duties
- A self-starter who can excel in a team environment of a growing and dynamic enterprise
- A nonpolitical team player who can build immediate credibility with all teams
- Ability to speak a second language a plus
- Ability to perform software installs, upgrades and patch installs. Configure database parameters using database utilities
- Administer databases using system administration tools such as: Tadmin, Viewpoint, Recovery Manager, TSET, Index and Statistics Wizard, Locking Logger, Access logging. In depth knowledge of DBQL, Ferret, and Data Dictionary for Teradata or must be familiar with RMAN, AWR/Statspack/PLSQL/Partitioning in Oracle databases
- Performance optimization by identifying bottlenecks and determining the cause. Must have insight into Resusage, Ampusage, and DBQL for a system running SLES11 for Teradata and Statspack, AWR for Oracle
- Develop database design consistent with specifications and in accordance with accepted database standards
- Proficient with data load and extract: using Bteq, Arcmain, Fastload, Multiload, Tpt, and Tpump for Teradata and sqlload, datapump, SQL, PL/SQL for Oracle
- Capacity management and planning: identify solutions for conserving disk space, capacity shortfalls, and implications of adding compression
- Identify how to protect data and recover using archive utilities
- Proactively analyze database performance data and make recommendations for improved data access methods and other database performance improvements as necessary
- Participate in all aspects of unit, assembly and performance testing in order to ensure that development efforts are consistent with requirements and performance specifications
- Available for off-hour support and project work as needed
- Communicate with Application teams to help them understand the impact of a solution, the timeline and expected functionality
- Develop and continually update knowledge about the technical infrastructure and databases in use
- B.S. degree in Computer Science or Engineering required
- 5+ years’ experience administering Oracle and or Teradata databases. Additionally, experience with other database technologies such as MySql and SQL Server is a plus
- Experience with advanced SQL coding/tuning
- Full life cycle experience in Data Warehousing Data Integration, and Data Management
- Strong interpersonal skills, ability to coordinate, collaborate and work effectively with other team members
- Ability to manage and resolve conflicts
- Strong organizational and communication skills, ability to understand and explain issues to colleagues and users from both a technical and a business functional point of view. Ability to communicate and to write effectively
- Minimum of 4-6 years of experience in database administration using Oracle databases (10g, 11g, 12c a plus) and/or Oracle Exadata; including installation, configuration, tuning, patching, upgrading, troubleshooting
- Experience working with Oracle Recovery Manager and Netbackup
- Experience creating Unix shell scripts
- Experience working with Oracle GRID Control
- Must be able to work off-hours and provide 24x7 support in on-call rotation
- Must be able to lead initiatives in keeping with established standards, with a willingness to identify and drive consensus
- Must have strong ability to multi-task and re-adjust priorities if project requirements change
- Ability to lead and facilitate change across groups
- Minimum of 3 years of experience with large-scale enterprise application suites (i.e. Oracle e-business, SAP, etc)
- Database admin at mission critical web-service company with high availability
- 5 to 10 years of experience with 24x7 Production and development databases
- Experience in RAC, Dataguard preferred
- Shareplex experience preferred
- Five years of professional experience in administering Oracle databases
- A bachelor’s degree in Information Technology, Computer Science or a related field of study
- Oracle certified in Oracle 11g
- Act as escalation point for DBA team members when there are critical problems that requires assistance
- Experience: Established track record of high availability for mission-critical web-based production database in a 24x7 environment
- Technical knowledge: Very good experience on larger Oracle production databases on a 24x7 environments with extensive performance tuning experience
- Self-starter: Must be capable of building and running these systems on his/her own, but work well in team environment as well. Demonstrated initiatives which improve service availability
- Database admin at mission critical web service company with high availability
- At least 10 years experience with 24x7 Production and development databases
- Strong experience with Oracle partitioning, Transportable table spaces Proficient in SQL
- Very strong troubleshooting and performance tuning skills is required
- PL/SQL and shell/perl scripting
- Experience in RAC,Dataguard preferred
- RESPONSIBILITIES include export/imports, patching, backup and recovery, monitoring, and assessment and mitigation of security vulnerabilities
- The qualified candidate will be responsible for the investigation, resolution, and explanation of system and application related issues
- The candidate will also be required to deploy and implement enhancements that will improve the reliability, maintainability, and performance of the databases and infrastructure
- In accordance with customer's security policies and directives, the candidate will deploy, maintain, and enhance the security of databases through administrative, preventive, detective, and reactive controls, such as change, configuration and patch management
- You will lead a small Operations team of Oracle DBAs, Linux, and Oracle Middleware administrators located in the Washington, DC area
- There will be some after hours and weekend RESPONSIBILITIES expected
- Strong operations focus of Oracle 11g RAC databases to include installing, configuring, and tuning
- Ensure database consistency and integrity
- Install, upgrade, and configure database software and database related application packages
- Perform database and SQL tuning as appropriate
- Apply database software patches
- Provide security assessment and mitigation strategies
- Execute and troubleshoot database backup and recovery processes
- Monitor and troubleshoot the performance and availability of databases
- Support application deployments (usually during weekends)
- Minimum of 10 years’ experience as an Oracle DBA
- Proficiency with Oracle 11g and 12c
- Experience with Oracle RMAN
- Strong understanding and use of SQL, PL/SQL, Linux OS, and common scripting languages
- Excellent interpersonal, oral and written communication skills
- Team oriented and able to operate with minimal supervision
- Experience working within a process improvement environment such as CMMI or Six Sigma
- Must be a US Citizen in order to obtain a DOJ MBI
- Experience with Oracle WebLogic and Oracle Access Manager a plus
- Monitor and maintain production applications in a 24x7 environment
- Provide Oracle, Unix, and Windows support and administration
- Act as a liaison between the application development and operations team and low-level infrastructure support services
- Assist in application and database design, optimization, and troubleshooting
- Provide application support to internal end usersSearch Jobs US
- Tune the database for the OS platform of choice
- Install and maintain third-party DBA tools
- Create and maintain replication
- Monitor database health
- Upgrade DBs to most recent stable version
- Setup automated jobs within database for loading, backups or status notification
- Support scheduled database or application outages
- Maintain documentation for Standard Operating Procedures, After Action Reports, configuration setup and installation and patching procedures
- Participates in special projects as required. #CPOST ,#DPOST
- Experience with Oracle Grid Infrastructure, Oracle Enterprise Manager, Oracle Data Guard
- Experience with customer encryption-at-rest products
- Experience with UNIX-based environments
- Familiarity with SQL Developer or SQL Work Bench
- Installation, configuration and use of Oracle advanced features such as, RAC, OEM, Grid control, and Data Guard
- Ability to analyze and tune system performance (i.e. Oracle statspack, SGA, PGA memory allocation, query explain plan, etc.) for optimal efficiency
- Oversee and manage database backup and recovery strategy (RMAN – online/offline backup and recovery)
- Oversee and manage database backup and recovery strategy (online/offline backup and recovery) of the database and application tiers
- Ability to troubleshoot Oracle database and applications
- Advanced proficiency with Oracle database(10g, 11g & 12c)
- Leadership, communication, delegation and mentoring skills
- Hands-on setup and tuning of Oracle database for High Availability and performance objectives
- Candidates must be a US Citizen and hold an active DoD Secret Security Clearance
- Responsible for design, installation, configuration, security and maintenance of highly available enterprise database systems
- Troubleshoot and resolve database access and performance issues
- Creating primary database storage structures (tablespaces) after application developers have designed an application
- Creating primary objects (tables, views, indexes) once application developers have designed an application
- Ensuring compliance with your Oracle license agreement
- Planning for backup and recovery of database information
- Maintaining archived data on tape
- Backing up and restoring the database
- Contacting Oracle Corporation for technical support
- Participate in on-call after-hours support rotation, responding to support calls after- hours/weekends/holidays
- Plan and coordinate data refreshes from one environment to another
- Develop, implement, and maintain change control and testing processes for modifications to databases
- Follow ITIL (Information Technology Infrastructure Library) practices for Change Management
- 7+ years direct experience managing and supporting Oracle Database System solutions
- Excellent knowledge and experience in Database Performance Tuning
- Excellent knowledge with Oracle system tables and using PL-SQL
- Hands on experience with database security, auditing, backup/restore and high availability
- Experience with data partitioning, indexing best practices, resource governor, extended events
- Experience with Oracle Data Integrator (ETL)
- Experience in Microsoft SQL Server is a plus
- Experience in MySQL is a plus
- Experience in Solarwinds Monitoring and DPA (Ignite) a plus
- Knowledge of Incident/Problem Management and is familiar with ITIL processes in a critical production environment
- Experience with basic troubleshooting a Windows Server operating system
- Self-motivated and directed with the ability to effectively prioritize and execute tasks in a high-pressure environment
- Must be a team player, proactive, and possess excellent problem solving, communication, and organizational skills
- Candidates are required to participate in on call duty
- Candidates must be willing and able to work the 4x10 Thursday-Sunday schedule
- One or more industry recognized IT certifications
- One or more Oracle certifications
- Understanding of ITIL practices in service delivery
- Working knowledge of database disaster recovery (i.e., Data Guard
- Working knowledge of database performance tuning (i.e., OEM and TOAD)
- Working knowledge of database backup (i.e., RMAN, Veritas, and other techniques)
- Working knowledge of database migrations (i.e., export/import and cloning)
- Working knowledge of database clustering (i.e., RAC, ASM, and others)
- Working knowledge of scripting (i.e., Shell programming, PL/SQL, and Oracle SQL)
- Working knowledge of database security and encryption
- Working knowledge of various server operating systems (i.e., Linux and UNIX)
- Partners with Sr. DBA's to create physical database structures for small projects based on physical design for development, test, and production environments
- Provides on-call support for assigned databases 24/7 to include investigating and troubleshooting problems
- Configures and maintains DBMS product software on small database and application servers
- Manages conversions of data from legacy/acquired systems as required. Reports escalated issues to Sr. DBA
- Certified Oracle Database Administrator
- Minimum 5-7 years of experience in database administration and structured development methodology
- Self-starter with excellent organization, planning, documentation and time management skills
- Proficiency with meta data, data modeling and data quality tools
- Proficient with materialized views
- Highly proficient with the Oracle optimizer
- Proficiency with Oracle performance and tuning
- Ability to understand business needs, analyze business cases, extract requirements to order develop leading edge data warehouse designs
- Experience with PL/SQL coding
- Multi-platform and multi-system integration experience
- Proficient Unix knowledge including shell scripting
Lead Mgr, Oracle Database Administrator Lead Resume Examples & Samples
- 7+ years of DBA Experience. Financial services preferred
- Experience working as a DBA Team Lead for a staff of 3-4 Oracle DBA’s
- Manage the Oracle Team and staffing schedules for the Team and coordinate the management and scheduling of the SQL Server Team
- Have dotted line reporting relationship with the Enterprise SQL Server Service Manager
- Proficiency in Oracle versions 10g, 11g and 12c and Oracle Cloud Control. Oracle certification required
- Oracle ASM experience preferred
- Scripting Experience (Shell, Perl, etc.) required
- Proven ability to prioritize, plan and organize projects built on Oracle platforms
- 8+ years of experience in all phases of physical and relational database development and management required, experience in the securities or financial services industry is a plus
- Bachelor Degree in Engineering/Computer Science/Information Technology or equivalent
- Minimum 8 years of hands on DBA experience with ORACLE 10g/11g/12c in UNIX/RHEL platform
- Expertise on Oracle RAC, ASM and DataGaurd
- Expertise on Database Performance Tuning and Query Optimization
- Preferable working experience in Manufacturing Execution Supported databases and Oracle E-Business Suite R12/ERP DB environment
- Expertise on Oracle database Backup methodologies and Restore procedures
- Manage and Maintain databases in optimal performance state at all the time
- Able to provide expert level of DBA support to application team
- Preferred working experience with Microsoft SQLServer databases
- Knowledge/experience with MySQL,PostgresSQL, MongoDB etc.,
- Preferred working experience with Oracle GoldenGate
- Preferred skills and working experience with DB2 Database environment
- Good Knowledge with Unix shell scripting
- Good Self-reliance skills
- Oracle 11g/12c Certified Professional-OCP (preferred)
- ITIL v3 Foundation certification (preferred)
- Build database scheme, tables, procedures, permissions
- Analyze, consolidate and tune database for optimal efficiency
- Oversee backup, clustering, replication, and failover
- Restore and recover corrupted databases
- Comply with all NOV Company and HSE policy and procedures
- DB administration for Oracle 11G and 12G
- Suggest/deploys best practices
- Supports multiple Oracle databases
- Primary focus is to support the Data Warehouse, used worldwide 24/7
- Abides with Sarbanes-Oxley compliant audit/procedures
- BS Computer Science or equivalent work experience
- At least 5 years of Oracle DBA experience on Oracle 11g and 12c on various environments
- Knowledgeable of Oracle Active Data Guard
- Experience in Oracle Upgrades and Patching
- Experience in DB monitoring and performance tuning
- Knowledgeable of Oracle DB interfacing with other databases
- Able to provide after-hours/in-call support
- Pro-active worker, a team player
- Security + (required)
- Must have extensive experience with Oracle, Java, UNIX, PL SQL
- Full understanding of the database life cycle: getting requirements from clients, creating analysis document, integration testing, client acceptance testing and documentation of changes made
- Must have at least 4-7 years’ experience
- BS in Computer Science or other IT field preferred
- Degree in Computer Science, Computer Engineering, Electrical Engineering, Information Systems or equivalent experience
- Real production experience and knowledge in at least two of the following Oracle Database versions: 8i, 9i, 10g, 11g, 12c
- Practical experience with: Managing Database Availability, Storage, Data, Memory, Performance
- Installations, Patching, Upgrade, Migration, Advanced Backup and Recovery, Flashback Database, ASM
- Service oriented behavior
- Great opportunity for professional development in the IT field
- Medical insurance
- Creates and maintains all databases required for development, testing, and production usage
- Install new versions and patches of the Oracle RDBMS
- Performs database re-organizations as required to assist performance and ensure maximum uptime of the database
- Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA may perform reviews on the design and code to ensure the site standards are being adhered to
- Provides technical support to application development teams. The DBA is usually the point of contact for Oracle Support
- Assists with impact analysis of any changes made to the database objects
- Troubleshoots problems regarding the databases, applications and development tools that are directly related to Oracle
- A good knowledge of the operating system(s)
- A good knowledge of physical database design
- Must have Oracle Exadata Database Machine knowledge
- Ability to perform both Oracle and Exadata system performance monitoring and the necessary adjustments
- Good skills in all Oracle tools
- A good knowledge of Oracle security management
- Experience and knowledge in migrating code, database changes, and data through the various stages of the development life cycle
- A good knowledge of the way Oracle enforces data integrity
- A sound knowledge of both database and program code performance tuning
- DBA should have sound communication skills with management, development teams, vendors, systems administrators and other related service providers
- Knowledge of Oracle Insurance Rules Palette would be beneficial
- Willingness to work on high pressure, participate in 24x7 and weekend knowledge sharing, deployment & maintenance tasks
- Ensure follow-the-sun support model and on-call support
- Responsible for database health, resiliency, performance tuning and optimization, operational control procedures, support and inventory
- Ensure High Availability of the database systems: Oracle backup & Recovery, clustering, replication, Oracle Data Guard and Oracle RAC
- Ensure Recoverability of Oracle databases: production and non-production. Maintain high standards of backup/recovery, conduct recovery tests
- Support and implement database changes, ensure quality of the changes
- Sound Knowledge on managing Oracle databases including installation, maintenance and Migration/Upgrades and database refreshes
- Sound knowledge on supporting Oracle ASM, Dataguard, RAC and Performance & Tuning on Oracle 12c, 11g, 10g
- Strong architectural knowledge is required
- Sound knowledge in administrating RMAN, OEM12C and GoldenGate
- Strong knowledge of Unix shell scripting languages
- Strong Experience with the Oracle Optimizer plans and hints. Strong experience with optimizing physical data models (table definition, indexes, range and hash partitioning)
- Experience with ETL involving large amount of data, in particular XML parsing and loading into Oracle, Oracle XML packages
- Must be organized, detail-oriented, self-motivated, disciplined, professional, and a team player to multiple tasks at one time, in a fast paced environment handling multiple demands
- Excellent written and verbal communications skills, ability to present and explain technical information
- Large Oracle database experience (> 5 Terabytes)
- MS SQL Server and SQL programming experience
- Extensive shell script programming skill, MS DTS/SSIS knowledge a plus
- Application Support - Weight 40%
- Documentation - Weight 25%
- Asset management and tracking
- Ensure appropriate software licensing
- Work with third parties to implement and support packaged solutions as necessary
- Coordinate activities with more senior specialists on related matters
- Plan, install, configure, test, tune, maintain, monitors and upgrade system configurations
- Monitor local and remote hardware and software performance and ensure that appropriate resources are available on network server equipment
- Plan, install, configure, test, tune, maintain, monitor and upgrade responsible systems
- Ensure that physical and logical security of equipment, software, and networks is maintained
- 3 years’ relevant experience required
- 5 or more years of relevant experience supporting Cerner required
- Experience and thorough understanding of Cerner and its sublicensed components (such as Oracle, UNIX, and IBM Websphere) and associated troubleshooting skills and techniques required
- Experience with, and knowledge of, hospital processes and functions preferred
- Bachelor’s degree in Computer Science, or Technical Certification in Computer Science, in conjunction with 3 years’ relevant experience, required
- Proven ability to perform Cerner domain replications and refreshes
- Capability to diagnose hardware and software problems and implement corrective solutions to problems
- Ability to review, troubleshoot, and create program scripts
- Working knowledge of MS personal productivity software
- Proficient communications and problem-solving skills necessary to effectively communicate with users, management and others in seeking and effecting solutions
- Ability to blend user requirements and interests into satisfactory and acceptable solutions
- Capability to diagnose hardware and software problems and independently determine solutions and implement corrective measures
- Proficient communications and problem-solving skills necessary to effectively communicate with users, management, and others in seeking and effecting solutions
- Thorough knowledge of MS personal productivity software and operating systems
- Daily maintenance including monitoring and database maintenance tasks
- Apply patches and upgrade database versions
- Bachelor Degree and minimum 10 years experience. Four additional years of related experience may be substituted for degree
- MUST be flexible and willing to work overnights and weekends
- Must be able to obtain a Position of Public Trust Clearance – US Citizen or Permanent Resident (Green Card Holder), and must not have traveled outside the US for a combined total of 6 months or more in last 5 years
- 2+ years of experience with Oracle database administration
- Experience with relational database design
- Experience with data analysis
- Experience with TOAD
- Experience with database design documentation
- Experience with geospatial data management
- Experience with geospatial application development or integration
- Oracle Certified Associate Certification
- Oracle RMAN
- Excellent database performance tuning skills and SQL code tuning skills
- Strong troubleshooting skills with an attention to detail and an ability to follow process
- Good team working skills but equally has to be capable of working alone
- Perform various administrative tasks related to Oracle Database: including installation, configuration, system administration, performing tuning, and Implementing Database security best practices
- Perform Data mapping
- Perform large Database migrations and application upgrades using various tools and techniques, such as Oracle Golden Gate, such that maximum availability is maintained
- Develop pl/sql to support several tasks such as data exchanges (using several protocols) and data migrations
- Develop measures to identify potential risks to database availability and performance before they become issues
- Minimum 10 years experience as oracle DBA
- Oracle 12C certified DBA
- Ability to demonstrate experience performing several large scale ETL and database migration efforts
- Ability to demonstrate experience using Oracle Golden Gate to perform Real time production ETL processes a must
- Ability to demonstrate PL/SQL expertise
- Ability to demonstrate experience installing and configuring Oracle on various operating systems including: Oracle Linux and AIX
- Ability to demonstrate knowledge with database best practices for security, performance, etc
- Enthusiasm and passion for building next-gen enterprise apps
- In-depth knowledge and experience with one or more of the following
- Exposure to e-biz architecture, knowledge of iAS or WebLogic Server, Fusion Middleware Architecture, Fusion Apps
- Knowledge and experience with one or more of the following languages: SQL, PL/SQL, Java, J2EE, Shell Scripts
- Communicating confidently with peers and management within technical and business teams
- 7 years of hands on experience in a large scale distributed environment
- Practical exposure to monitoring tools – Oracle, Tivoli UA, etc
- Sybase ASE and IQ is a plus
- Data warehouse, clustering and replication methodologies
- Ability to architect, design and configure large, complex databases with replication and high-availability on the most current MSSQL versions
Mid-level Oracle Database Administrator Resume Examples & Samples
- Maintain Oracle databases
- Plan, implement, support, and maintain the Credit Acceptance enterprise database management system environments
- Manage the migration of database structures from non-production environments into the production environment
- Provide database administration services
- Monitor and tune database processes
- Basic understanding of ETL processes
- Simultaneously support small and large scope projects
- Demonstrate technical knowledge of all phases of the systems analysis activity
- Develop and maintain standards, procedures and methodologies for effective operation, access of all Credit Acceptance databases
- Design, implement and modify physical database structures; evaluate, test and implement database management systems, utilities, and tools
- Provide all support related issues for databases and application servers in CAC
- Coordinate database security requirements including basic education, user guidelines, and access authorizations
- Installation of Oracle databases, with understanding of Grid Infrastructure (GI), Automatic Storage Management (ASM), Real Application Clusters (RAC), and Oracle’s Database Configuration Assistant (ODCA)
- Refresh development and lower environment databases as necessary
- Create storage groups, add datafiles, tables and views, review SQL, develop and enforce database standards
- Prepare time estimates for assigned projects
- Assist in disaster recovery planning, testing and execution as needed
- Evaluate project objectives and scope for feasibility
- Minimum of 2 years of experience on Oracle Databases 9i, 10g and 11g
- Experience in, version control tools, code migration, and working on support tickets
- Experience in a High Availability (HA) environment
- 365x24x7 rotation
- Remain compliant with our policies, processes and legal guidelines
- Insightful : Make timely well-considered decisions, create innovative solutions and continuously learn
- Direct : Communicate clearly and objectively; don’t be afraid of difficult conversations. Raise concerns through the proper channels
- Reviews, evaluates, designs, implements and maintains company database(s)
- Creates database design specifications based on understanding of business transactions
- Creates database objects (tables, etc.)
- Creates and maintains database definitions and tables
- Designs, codes, tests and implements custom database scripts and formal procedures
- Monitors and maintains databases for proper performance tuning
- Designs, implements and maintains data retention and archival; plans for storage needs, retention, backup and recovery
- Designs, implements and maintains database security
- Assists in identifying and resolving database problems
- Designs and writes codes for database access, modifications and constructions, including stored procedures
- Experience with Oracle Database 11g, 12c required
- Dell Foglight experience Desired
- Experience with OEM Cloud Control 12c desired
- Experience with TDE desired
- Ability to handle multiple tasks and projects simultaneously
- Excellent analytical skills, attention to detail, and problem-solving skills
- Ability to develop and leverage strategic business relationships across the organization and externally
- Strong sense of personal accountability
- Passionate about continuously improving organizational practices
Senior Oracle Database Administrator TS Resume Examples & Samples
- Database health and performance
- Database backup
- Data ingest support
- Ensuring accuracy of COOP site RDBMS software and data
- A minimum of 12 years general experience providing administration support for Oracle relational database systems (Version 10g and later)
- Comfort working in a managed / hosted Solaris Unix operating environment
- Experience with Oracle PL/SQL programming (Stored Procedures and Triggers)
- Effective communication skills (verbal and written)
- Oracle Certified Professional (OCP) Certification
- Experience with Apache Solr
- Experience with Confluence
- Experience with manual and automated data ingest
- Experience with Weblogic (development and/or administration)
- Provides primary DBA support for implementing, upgrading and maintaining the DBMS (SQL server and Oracle) environments and mentor less senior staff in DBA support process and procedures
- Automates the creation, maintenance and refreshing of required instances/databases for all environments
- Monitors and resolve application connectivity and DB interface issues; proactively working with application support staff to ensure that application problems do not adversely affect production operations
- Collaborates with application programmers and vendors to report and resolve problems
- Mentors and educates HealthPartners technical staff, vendors and database query users in efficient DB use standards
- Mentors and educates designers and/or data modelers in proper methods to define new objects or modifications to existing schema objects which ensure efficient DB performance
- Ensures compliance of all DB security standards in collaboration with IS&T Security Management
- Ensures consistency and quality of DBA documentation and dependencies between versions of application software, DBMS software and Operating System
- Debugs problematic database issues, provide analysis for future enhancements and development; proactively maintaining effective and efficient database structures and system processing
- Forecasts and analyzes future capacity needs; documenting potential issues, recommending solutions to potential capacity problems, and developing tools and utilities to mitigate future capacity issues
- Strong knowledge of HealthPartners' operating systems (i.e. Windows, AIX, Linux)
- Available to work outside normal business hours, including weekends and be on-call (7 days x 24 hours)
- Effectively use Microsoft tools, including Outlook, Word, Excel, Visio, and PowerPoint
- 4-year college degree in Computer Science, Math, Engineering, or related field OR 3+ years IS&T related experience
- 4+ years experience with database development
- 4+ years experience SQL and PL/SQL or T-SQL programming
- 4+ years experience with Unix shell, Perl or OS scripting language
- 3+ years experience with data performance tuning
- Oracle Certified Professional - OCP DBA Professional
- Epic Clarity database experience
- Develop, document and test DBA policy and procedures
- Manage all levels of database security and data integrity through the development life cycle
- Assist with the development of the DBA Services standards as well as provide training on the supported IT systems, applications and database to other internal DBA and internal customers (end users and programmers)
- Provide primary problem management support by receiving, trouble shooting and solving the daily problems reported by internal customers
- Develop database strategies, tool selection, and internal scripts for support internal customers and overall company needs
- Develop implementation plans, computer system validation and departmental procedure for these strategies
- Research and assist with the implementation and more advanced database modules and features (clustering, replication, partitioning)
- Install, upgrade and patch Oracle databases so that our environments remain current
- Analyze database resource consumption, for problem avoidance and trend forecasting
- On-call requirements to ensure 24 x 7 support of database operations
- 10+ years’ experience as a database administrator in an Oracle environment
- 10+ year experience in PL/SQL, scripting, query and database tuning
- 5-7+ years of Oracle database development
- Expertise in Oracle 11g/12c, Oracle Exadata, RAC, DataGuard, ASM, RMAN, PL/SQL
- Experience of administering OEM
- Ability to work on-call to ensure 24x7 support of database operations
- Experience with Monitoring & Diagnostic tools
- Experience working with Windows and Linux installation, configuration, tuning of Oracle 11g/12c
- Ability to conduct research into database issues, standards and products as required
- Will work with developers to design and build new structures to support application enhancements and promote database changes throughout the Dev, UAT and Prod databases
- Responsible for quarterly patch applications (PSU) and periodic database upgrades with minimal downtime in database environment
- 4 year degree in Computer Science or Information Technology required (or equivalent experience)
- Minimum of 4 years of experience working with Oracle database systems in a Linux/Unix environment is required
- Must have at least 1 year experience in each the following
- Eight years of related experience with implementation and administration of database systems
- Bachelor Degree or equivalent experience required
- Able to administer, manage and tune high-transaction production server environment(s)
- Able to work in a dynamic, fast paced and often changing environment
- Excellent database programming and query knowledge
- Excellent design, development, administration skills
- Excellent knowledge of database development
- Excellent knowledge of logical and physical database design
- Excellent problem solving skills and written and oral communication skills
- Knowledge of the extract, transform, load, star schema and end user access tools
- Bachelors degree in Computer Science, Information Technology, or other technical discipline; or
- Verifiable experience in the IT field (five years) with at least two years experience with Oracle
- Must be able to obtain and maintain a US Government Secret or Top Secret Clearance
- Must be able to successfully pass a CBP Background Investigation
- Two Years of Oracle Database Administration or application development experience
- Excellent ability for self managing and problem solving skills
- Excellent team player with leadership abilities
- Work as a member of a team to provide 24x7x365 support
- Maintain Oracle backup and recovery policies and procedures
- Perform database and operating system tuning and performance monitoring
- Perform database capacity planning
- Perform patch management and version control
- A good knowledge of Oracle data integrity
- Bachelor’s degree in Information Technology or related field and 1 or more Years of Experience Required or Associate’s degree and 4 or more Years of Experience
- Database query tuning
- Working knowledge of Oracle E-Business Suite
- Work as a liaison between the Data Warehouse team and the Global Distributed DBA team
- Be responsible for installation and support of vendor products that require an Oracle repository
- Participate in Oracle database upgrades
- Assist the application group with migrating database objects through the development regions
- Review current database concepts and propose where new Oracle functionality can replace old methodologies. Participate with the application group in troubleshooting any production issues
- A Bachelor’s Degree in Computer Science or related field
- Minimum 3 years’ database administration experience
- Minimum 3 years’ experience with Oracle 11g platform
- Experience with PL/SQL, Stored Procedures, Triggers and views
- Experience with index tuning
- Experience with Oracle OEM monitoring platform
- Experience with shell scripting on Solaris and Linux
- Excellent in English
- Basic experience in 10g, 11g and 12c on *NIX platforms (Solaris / Linux)
- Standby databases (Data guard)
- Patching and upgrading databases
- UNIX scripting for DB administration
- Responsible for day to day support, documentation and execution of standard operation procedures
- May be responsible for delivering some level of conceptual design, logical database, capacity planning, external data interface specifications, data loading plan, data maintenance plan and security policy
- May perform some program coding and identify logical processes on technical platform
- Builds window, screen and reports for clients if required
- Participates in quality assurance and develops test applications for client server environment
- Responsible for negotiating any tables and fields provided in the database
- The present job description is not exhaustive. The employee will fulfill other professional activities, tasks and responsibilities that will be communicated by the direct manager and are not mentioned in the present document
- You should, by study or training, have experience in Oracle database administration, and a determination to learn about Database and RDBMS concepts
- You should have some understanding of SQL query
- You should have in-depth knowledge of Relational Database and its Structuring
- Knowledge of Unix and Windows operation systems
- 24/7 on call and scheduled work outside normal business hours is to be expected
- Participate in on-site duty also on weekends (day time)
- Involved in consolidation, automation and performance optimization
- Documentation of operations and services Provide guidance and counselling
- Experience with Dell Foglight
- Experience with OEM Cloud Control 12c
- Experience with TDE
- Manage multiple Oracle, MySQL and Mongo DB databases, ensuring that all servers are operational 24x7x365 and all scheduled jobs and backups are consistently completed
- Responsible to implement very large data warehouses consisting of structured relational and non-relational data from Research and Scientific sources
- Provide consultation to Enterprise Architects, Solution Architects and Engineers in the area of emerging database technologies and lead hands-on Proof-of-Concept and implementations that include range of RDBMS and NoSQL solutions
- Perform physical implementation of database design from Oracle installation to database creation
- Install, manage, maintain, and troubleshoot databases that support business, web, and data warehouse applications
- Assume responsibility for backup and recovery, sizing, security, replication, database optimization, schema creation and maintenance
- Perform database monitoring, maintenance, reorganizations, resource management, schema management, and capacity planning and performance tuning
- Lead small to medium projects including direct interactions with customers
- Complies with OLAs and Quality/Validation requirements
- Ensures ITSM framework, processes, tools and SOPs are implemented, utilized and supported end to end
- Provide first-level application support: Resolve problems and answer questions related to the Oracle RDBMS and platform environment; contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiency
- Identify and implement team operational efficiencies by automation & process improvements opportunities and / or implementing new technologies
- Oracle RDBMS performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency
- Maintain database backup/recovery environment: Respond quickly to refresh data; verify implementation of correct backup strategy, develop recovery procedures; support recovery from loss of data caused by user or system error
- Install and upgrade Oracle RDBMS and related products: Keep Oracle RDBMS at current release and maintenance levels; provide current & stable production and development environments
- Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or de-fragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance
- Perform database refreshes upon request: refresh data from one environment to another at the request of the application development staff, execute necessary tasks to accomplish this, to minimize impact provide application development staff optimal development environment with current data
- Provide assistance in database design as needed: Research and recommend optimal design criteria; publish standards and work with development staff standardize environment and improve efficiency
- Experience working closely with a matrix team consisting of employees, contractors, and vendors with various skills and disciplines
- Ensure database availability, performance, and supportability can meet application requirements. Ability to work with application groups to determine those requirements
- Performance tuning experience including performance issue identification and tuning
- Tier 2/3 troubleshooting. When technical issues are escalated internally, you are able to work until resolution
- Clearly articulate requirements, issues, project status, etc. to non-technical management personnel
- Identify and communicate licensing, sizing, upgrades, etc. requirements to technology vendors
- Standard DBA tasks – installation, space management, backup & recovery, patching, upgrades, etc. within Oracle environments
- Participate in 24/7 on-call rotation
- Mentoring of junior Database Administrators
- Assist with developing and maintaining a DBA technical roadmap including proposals for financial capital planning
- Writes and maintain documentation for standard procedures
- Bachelor degree in computer science, mathematics or similar discipline
- Oracle Certified Professional DBA in Oracle Database 11g or 12c
- 5-8 years of RDBMS experience (Oracle databases)
- Experience required with all of the following…
- Supports the Database Administration functions of the system. Designs and implements modifications or enhancements to forms, menus, and reports
- Implements processes for data management including data standardization and cleansing initiatives as part of the overall design, development, fielding, and sustainment of a system
- Executes advanced database concepts, practices and procedures
- Monitor and tune database management systems
- Manage the database structure, its physical and logical descriptions, standards and tools, security and reorganization and backup/recovery procedures
- Analyze database performance and recommend enhancements as appropriate
- Analyze Database security, including security hardening
- Monitor database growth and provide input to overall system capacity planning
- Proactively review SQL code to ensure efficient database access
- Monitor data usage to ensure correct use by applications and to minimize redundancy
- Proactively provide database related support for application development team
- Assist in the evaluation of application requirements as it relates to the database environment
- Participate in 24 X 7 on call rotation and periodic off hours support
- Implements and maintains the necessary controls and procedures to cost-effectively protect information systems assets from intentional or inadvertent modification, disclosure, or destruction. Provides guidance and direction for the protection of information systems assets to other areas as needed
- Architects, designs, and coordinates installation and configuration of real-time and warehouse databases in a high volume multi-terabyte redundant environment
- Consults on Data Definition Language (DDL) and Data Manipulation Language (DML) design and development opportunities
- Contributes to the overall construction of logical, functional, and physical database and application designs and features, and ensures adherence to project deadlines, specifications, and budget
- Designs and administers performance tuning enhancements for the databases, and assists on database environment upgrades and support
- Ensures databases are maintained in compliance with regulatory requirements and guidelines including but not limited to SarbanesOxley (SOX)
- Participates in or leads the planning, design, installation, configuration and implementation of database replication software
- Performs backup and recovery on Database Management Systems. Scales and clusters data for high availability
- Performs database architecture design reviews to identify enhancements to current database structures and processes
- Performs more complex SQL tuning including programming and ways to optimize SQL code
- Participates in after-hours/weekend on-call rotation
- 3 - 5+ Years of experience in Database Administration that directly aligns with the specific responsibilities for this position.(Required)
- At least three years of progressively responsible experience in
- Oracle Database 11g or 12c administration in high volume, multi-terabyte, redundant environments
- Troubleshooting and optimizing complex SQL queries
- Utilizing Oracle Golden Gate, Oracle Data Guard, Real Application Clusters (RAC), RMAN, ASM and Oracle Enterprise Manager
- Ensuring databases are maintained in compliance with regulatory requirements and guidelines including for example Sarbanes–Oxley (SOX)
- Some exposure to the following is desirable
- 10+ years of experience with Oracle databases
- Experienced Oracle Data guard, RMAN, ASM
- Very strong in SQL and PL/SQL
- Self motivated and has ability to succeed in dynamic, fast paced environment
- Improve efficiency of database management support
- Experience in managing/tuning/upgrading databases over 5TB
- 11g database,12c cloud control experience
- Strong Oracle internals
- Experience in Oracle virtual machines is a plus
- Ability to succeed in dynamic, rapidly changing environment
- Oracle RAC, replication technologies
- Experience in MySQL, postgres and Green Plum is a plus
- Proficient in Oracle performance tuning(proficiency in using AWR,ADDM)
- Review performance and capacity trends and provide recommendations
- Troubleshoot database issues and coordinate with Oracle support as required
- Peer review technical documentation
Experienced Oracle Database Administrator Resume Examples & Samples
- Professional experience working on a multi-terabyte, high volume enterprise data warehouse implementation
- Practical experience in the following DBA areas
- Solid database design and SQL experience
- Working with logical and physical data models
- Maintaining and scheduling backup and archiving (BAR) processes
- Designing and implementing indexing, archiving and partitioning strategies
- Updating statistics and performance optimisation of long running queries
- Operational maintenance e.g. patching and failovers
- Implement policies and procedures for ensuring the security and integrity of the corporate data warehouse
- Database Performance tuning ( StatsPack & AWR)
- Flashback Technologies
- SQL/PLSQL scripting skills
- UNIX shell scripting skill
- Able to work with structured frameworks, methodologies and best practices
- Practical experience using Oracle 11g 12c: -
- Practical experience using Teradata
- Oracle Database Management (Installation, Backup/Recovery, User Account mgt, Development to Testing) – Minimum 3 years experience
- Oracle Capacity Planning – Minimum 1 year experience
- Performance Tuning – Minimum 1 year experience
- Oracle Database Security – Minimum 1 year experience
- Database Monitoring – Minimum 1 year experience
- Experience working with a college or university system – 2 years of experience
- Army background and security clearance (current or past) – 1 year of experience
- Excellent written and oral communication skills – 3 years of experience
Oracle Database Administrator Level Resume Examples & Samples
- Controls migrations of programs, database changes, reference data changes and menu changes through the development cycle
- Evaluates releases of Oracle and its tools, and third party products to ensure that the siteis running the products that are most appropriate
- Address requests for incident resolution, problem determination, and root-cause analysis of application issues causing outage or performance degradation
- DBA Level II: Bachelor’s degree with 3 years of work related experience, or 1 year with a Master’s degree, or 7 years work related experience in lieu of a degree
- DBA Level III: Bachelor’s degree with 6 years of work related experience, or 4 years with a Master’s degree, or 10 years of work related experience in lieu of a degree
- Specific contract requirements regarding education and experience will prevail
- Active TS/SCI clearance (required to start work). Must be able to pass a CI Polygraph
- Must possess a Security+ certification
- Excellent knowledge of Oracle backup and recovery scenarios
- Must possess strong customer service experience
- Experience with Agile project management methodologies, including SCRUM
- Maintains database availability and recoverability
- Preserves the integrity and design of the databases to support mission-critical databases necessary for business operations
- Accountable for, and executes, deliverables that alignment with the company strategic objectives
- Investigates root cause analysis for issues / problems, and recommend preventative measures
- Update and maintain documentation to ensure database manageability
- Bachelor’s or Master’s degree in Management Information Systems, Computer Information. Systems, Computer Science, or Engineering, or a combination of equivalent education, training, and experience
- 3-6 years of hands-on database administration experience using Oracle 11g and 12c
- Experience with Oracle RAC, Grid Infrastructure, and ASM
- Well versed in disaster recovery procedures and database backup / recovery utilities including RMAN, Data Pump, Flashback technologies, and media management integration
- Experience with advanced database replication solutions including materialized views and DataGuard
- Excellent understanding of database security management practices
- Experience the database monitoring / alerting software including Oracle Enterprise Manager (OEM) / Grid Control / Cloud Control and Solarwinds Database Performance Analyzer
- Skilled in scripting languages including Shell and Perl
- Programming experience in SQL and PL / SQL
- Ability to conduct and direct research into IT issues and products
- Ability to effectively communicate with technical staff and management
- Proven analytical and problem solving skills with ability to adapt in a dynamic environment
- Self-motivated and self-directed with attention to detail
- English fluency; written and verbal/spoken
- On call rotation and after hours’ support required on a limited basis
- Preferred Knowledge, Skills and Abilities
- Exposure to Exadata
- Administration of Linux and Solaris
- Administration and support of MS SQLServer 2012, 2014
- Experience working in SOX compliant environments preferred
- Responsible for installing, configuring, deploying, sustaining, and providing reliable access to Joint Staff Support Center (JSSC) databases
- Maintaining and systems availability, in order to achieve the business needs of our customer organization
- BA/BS in computer science, engineering related disciplines or 10 years' equivalent experience
- Working knowledge of Oracle Database Administration
- 1 -2 years of SQL scripting experience
- Working knowledge of Oracle 11g and 12g
- Sybase Database knowledge or willingness to learn
- Global Command & Control System(GCCS) experience is a plus
- Global Command & Control System-Top Secret(GCCS-T) system experience is a plus
- Joint Operation Planning and Execution System (JOPES) experience is a plus
- Status of Resources and Training System (SORTS)Common Operational Picture (COP) experience is a plus
- Provide guidance and clarification toward Database design and implementation
- Interface with Oracle technical support
- On call with possible 12-hour shift
- Bachelor’s degree in Information Technology or related field and 2 or more Years of Experience Required or Associate’s degree and 4 or more Years of Experience
- Excellent communications skills, both oral and written, at all levels of the organization
- Ability to work independently and as a member of a team
- Database administration for Oracle databases as well as support for installed applications, including complex setups with high availability / disaster recovery requirements (Oracle RAC, Oracle DataGuard)
- Autonomous planning and implementation of new database systems in close cooperation with customers
- Processing of incidents and changes within the defined operational processes (ISO 20000)
- Autonomous analysis and resolution of complex service problems
- Development and implementation of backup / restore concepts
- Autonomous development and implementation of monitoring solutions for databases
- Autonomous development of scripts to optimise the operational processes
- Detailed documentation of rules, work instructions, concepts, scripts
- Close corporation with other support teams globally
- Provide standby duty outside office hours
- Degree in computer science, IT specialist apprenticeship or comparable education
- Oracle Certified Professional DBA (OCP) with at least 6 years experience on one or more technologies
- Several years of experience in design, sizing, implementation and tuning of Oracle database
- In-depth knowledge of all administrative activities for Oracle databases within a Unix/Linux and Windows environment
- In-depth knowledge of all Oracle database administration tools
- Excellent Oracle RAC and DataGuard skills (versions 10g, 11g, 12c)
- Good Knowledge of 12c and/or 13c Cloud Control
- Good Knowledge of various Performance Tuning technics
- Knowledge of SQL and basics of database programming (PL/SQL)
- Knowledge of ITIL process models
- Very good English language skills (spoken and written)
- Independent and autonomous working style
- Ability to work under varying degrees of pressure
- Ability to communicate on different levels to different customers and internal teams
- Ability to be responsible and take ownership of issues
- Strong service-oriented attitude
- Knowledge of My SQL, or other database systems
- Knowledge of Linux server administration
- Experience with storage and backup management
- Knowledge of installation and administration of oracle databases within a MS Windows environment
- Experience with Java bases middleware products
- Open to learn new rdbms technologies
- Bachelors and 9+ years of experience; OR, High School equivalent and 13+ years of experience
- Experience working with regular DBA activities like installing Oracle 12c/11g software, Database creation, patching and upgrades
- Hands-on experience with Oracle 12C and Oracle RAC
- Creating User accounts, Roles, granting privileges and resolving Security vulnerabilities
- Experience developing SQL*loader Data loading/unloading scripts, stored procedures that process and modify existing data
- Experience with UNIX shell scripting for automating regular data loading and other database maintenance activities
- Experience working in Oracle environment on Red Hat Linux platform
- Critical thinking and problem solving abilities to address complex issues involving data movement and data replication
- Proven ability to resolve architectural issues in the environment and database infrastructure, as well as develop and maintain an in-depth understanding of the database architecture and the application functionality
- Experience working with Oracle 12c OEM for database monitoring
- Provide 24*7 supports for production, development, and test databases
- Upgrades, Migrations using RAT to performance benchmark
- Grid Control (OEM12c) - monitoring, configuration and deployment
- Experienced using tools/utilities: AWR, ADDM, Statspack, OEM, RMAN, SQL*Loader, export/import, Data pump
- Problem Solving / Troubleshooting: Demonstrates ability to resolve issues quickly and efficiently
- Knowledgeable of Oracle security and policy base process and procedures
- Supports OS upgrades for Windows, AIX and Linux servers
- Provides disaster recovery support by testing, reviewing, and supporting disaster recovery plans on a routine basis
- Supports projects at the request of business partners
- Strong knowledge of Linux, Solaris, and AIX operating systems
- Support Linux Patching and OS upgrade
- Experienced with Oracle data replication technologies: Data Guard, Active Data Guard and Goldengate
- In depth knowledge of Oracle internals (latches, system waits, resource allocation, data dictionary, table and index storage and access parameters)
- Experienced with Oracle failover and switchover concepts using Oracle Role based services with F5 GTM
- ASM and GI configuration and management
- Knowledge of Cluster Ready Services, Oracle Notification Services, Virtual IP
- Expertise in performance tuning of SQL statements, reports, Oracle database and Database server
- Provides technical guidance, oversight, and mentoring to team members as a subject matter expert
- Knowledge of Instance Tuning, Memory Tuning and SQL Tuning
- Experienced architecting, configuring, designing and deploying Oracle databases for OLTP, DW and datamarts usage and including HA, failover for maximum availability architecture
- Additional Desirable Skills: UNIX scripting, Java/Perl Script, PL/SQL, MySQL, Tivoli, Servicenow, EMC/Data Domain, CyberArk, Hadoop Filesystem and a financial background
- Knowledgeable of change management, incident and problem management, follows escalation protocol
- Continual service improvement and recommendations for database technologies
- 5 years of experience administering and supporting Oracle Databases version 10gR2 and above. Experience must include working with the installation of Oracle software, applying Patch Set Updates, and working with ASM disk storage
- 5 years of experience in the administration and support of Oracle RAC and DataGuard (versions 10g, 11g, and 12c)
- 5 years of experience installing and configuring Oracle 11g and 12c Grid Infrastructure and Oracle 11g and 12c Database software, in an IBM AIX environment
- 1 year of DBA experience with Oracle 12c databases and Grid Infrastructure. (clustered or standalone)
- 5 years of experience administering clustered Oracle databases on IBM PowerHA and Oracle RAC
- 4 years of experience using Oracle Enterprise Manager and Grid Control (version 11g or higher)
- Oracle Certified Professional - OCP certification – version 11g
- 6-8 years of DBA experience
- Minimum of 7 years of experience working in IT infrastructure supporting Intel based server hardware, TCP/IP networking and Microsoft Operating systems
- Must demonstrate a code of ethics and maintain the highest standards of confidentiality in dealing with sensitive data and proprietary information
- Superior customer service skills
- Experience in Oracle (10x and 11x) and/or MS SQL Server (200x). Proficiency in Shell/Perl scripting, RMAN, import/export, hot backups, RAC, materialized view replication, standbys, Dataguard/Databroker, high-availability clustering and performance tuning
- Working TCP/IP knowledge
- Experience with JBoss, WebLogic, WebSphere, Apache
- Must be able to work nights and weekends as required
- Must be able to fulfill on-call duties as required
- Defining and creating database tables, schemas, and indexes; normalizing database design and providing first line of support for production Oracle database system
- Monitoring database health, including I/O and CPU utilization, user accounts, and backup strategies as well as defining and implementing processes when needed
- Oracle Unix management in Microsoft Azure
- Working with Application Team to define and implement database optimization strategies and best practices from concept to implementation as needed based on monitoring of usage
- Gathering and reviewing the business rules/requirements, converting them into technical requirements documents (i.e. source to target)
- Creating data models and table design
- Collaborating and working with the Agile project teams, creating user stories and test cases in order to develop, analyze and validate solutions from the source database
- Processing data and developing reports using SQL, Excel, and other BI tools in order to review and analyze information using various statistical methods such as regression analysis and other graphical techniques such as scatter plots, bar charts, trend lines, etc
- Analyzing identifying various trends in data or process issues that need to be researched and resolved
- Writing technical reports detailing procedures, outcomes, and observations and making recommendations
- 3-7 years’ experience in managing Oracle databases as an administrator
- Experience in Oracle ASM management
- Defining and creating database tables, schemas, indexes, normalizing database design
- Monitoring database health, including I/O and CPU utilization
- Bachelor's degree in Information Technology, Information Systems, Business or a related discipline required. An equivalent combination of education and work experience may be taken into consideration in lieu of a degree
- Strong background and knowledge of SQL and relational databases
- Ability to manage competing deadlines, manage variances in schedules and resources
- Limited travel
- Production Operations tasks
- Provide 24x7x365/On Call support within a rotation
- Contribute towards new and ongoing Technology projects in areas of Scalability, Performance and High Availability
- Responsible for space management, back-up, monitoring, and DB performance
- US Citizenship or Green Card status is required
- 5-7 years experience as an Oracle DBA
- Experience implementing a variety of data models, data access, and table maintenance codes
- Extensive experience with Oracle RAC
- Experience with Oracle Dataguard
- Extensive experience resolving moderate to complex db performance and capacity issues, replications, etc
- Experience in configuration, upgrade, maintenance and security
- Experience executing an Oracle database restore
- Advanced level knowledge of SQL and PL/SQL skills
- Networking Experience - TCP/IP, Database Connectivity
- Experience with mongodb
- Strong scripting skills in any UNIX shell, Perl, and/or Python
- Ability to develop requirements for the tool-sets needed to streamline and automate system installation and configuration procedures
- Experience with process automation as it applies to the provisioning of resources within Db Engineering
- Understanding of Unix Operating System and Oracle 10g/11g databases. It would be great if you also had
- Excellent planning and time-management skills
- Adherence to established policies and directives
- Ability to monitor application related jobs and data replication activities
- Understanding of database object creation
- Knowledge of Oracle E-Business Suite. Other qualifications include
- User Management (60%) – Monitor the Database Infrastructure performance and health and remediate if there are any events indicating any degradation of database services
- Event Management (20%) – Monitor the Database Infrastructure performance and health and remediate if there are any events indicating any degradation of database services
- Incident Management (10%) – Handle the database Issues reported either by the end users, application owners or other support teams (Including the events) and drive it to resolution/restoration of services
- Change Management (10%) – Implement the technical changes/ configuration changes at the database level (Account provisioning, schema releases, database configuration changes)
- –Basic and Core knowledge of Database technology - Oracle
- Good understanding of database architecture, system process
- Have a good understanding of Database utilities and tools and its usage
- Working experience in a fast paced Database Operation environment
- Knowledge of multiple database technology would be an added advantage
- Promote the use of technical standards, procedures and best practice and maximize the use of toolsets and automation,
- Work with regional 1st and 2nd line teams to drive problem management/event reduction
- Manage incidents /problems/changes recorded. Analysis of incoming incidents and alerts and ensure quality delivery within defined service levels
- Oracle 11g and/or 12c database (at least 5 years of experience)
- Exadata Database
- DBA-Oracle-Core skills are mandatory for following
- Oracle Grid Infrastructure
- Troubleshooting Oracle performance (statistics, indexes, partitioning, NET8 debugging)
- Basic knowledge of Operating Systems (Windows, UNIX, AIX, Linux), IP Services
- Basic experience in systems and network monitoring
- Provides senior level technical and operational database administration
- Installs, maintains, develops and implements policies and procedures for ensuring the security, availability and integrity of the company databases and large data warehouse database environments
- Provides analysis and definitions of technical standards related to database resources
- Provides analysis and design function for new and existing systems
- Applies knowledge in the area of physical database design, performance and tuning, backup and recovery procedures in order to resolve database performance issues, database capacity issues, replication, and other distributed data issues
- 10+ years Oracle database administration experience
- Experience with Golden Gate
- Prior support experience in a SAAS environment
- Assess, design, plan, and implement complex infrastructure projects
- Experience with deployment and deployment management of Databases on Unix, AIX, Solaris and other unices as well as on windows systems
- Implementing Backup Solutions with native tools as well as RMAN with 3rd Party Backup solutions like Omni back Data protector, Veritas NetBackup, etc
- Knowledge of SAN backup tools like BCV, snap backup, Snap clone, etc
- Hands on expertise on HA environment - RAC, OPFS as well as sound understanding of OS Clustering - HACMP, MC SG, SGERAC and other high-availability/ fault-tolerance technologies
- Knowledge of virtualization and system consolidation. Cloud computing knowledge will be a huge plus
- Knowledge of DNS, DHCP, NFS, TCP/IP and networking services
- Extensive Knowledge of UNIX, shell/Perl Scripting and kernel Parameters
- Work on incident root cause and pre-emptive incident reduction strategies
- Support the development team, advising on topics of database design, security & performance, and validating code quality
- Work closely with the application support team, sharing knowledge and assisting in the resolution of database related issues
- Assist the infrastructure team managing, troubleshooting & upgrading IT systems
- Support data and code deployments
- Create and maintain documentation of DBA processes and procedures
- Routine database maintenance, ensuring highest levels of performance, availability & security
- Proven experience working as a senior Oracle Database Administrator role on Unix systems in a production capacity
- In-depth knowledge of Oracle 12c including SQL & PL/SQL
- Advanced performance tuning, query optimisation and troubleshooting skills
- Strong Unix shell scripting
- Experience of Installations/upgrades/patching/cloning
- Good knowledge on all incident, change, problem management process & compliance process
- Knowledge and experience of some of the following: Partitioning, GoldenGate, RMAN, Advanced Queues, DataGuard, Enterprise Manager 13c, Advanced Security, Real Application Testing (RAT)
- Able to prioritise and manage own workload, reporting back on completion
- Ability to cope with demands & time-scales
- Highly organised
- Able to create processes and introduce efficiencies where needed
- Ability to cope in a very busy environment and to perform in high-pressured situations
- To have initiative, but also be able to respond to direction
- Flexible approach and willingness to do whatever is required to deliver the role
- Self-starting attitude to work
- Good interpersonal skills (particularly across different teams)
- Exposure to databases on cloud (RDS, Redshift Aurora etc.)
- E-Business suite
- Oracle 11g upgrade process to 12c and from 12cR1 to 12cR2
- Oracle Enterprise Manager (OEM)13c
- Interest in broadcast television and technology
- Possess a keen attitude and a willingness to learn
- Service oriented and excellent customer facing skills
- Good SQL and scripting language (Perl, shell) knowledge
- Understanding of Oracle Internet Directory, and Active Directory
- Experience in Automation, Testing and Packaging (MSI, RPM’s)
- Exposure to Application/Middleware Server software
- Capacity Planning & Asset Management
- Professional DBA (Oracle 11g, 12c) with experience in some of the following disciplines
Related Job Titles
![oracle sample resume for 3 years experience hire-it-people logo](https://www.hireitpeople.com/images/logo.png)
We provide IT Staff Augmentation Services!
Oracle database administrator resume.
PROFESSIONAL SUMMARY
- Over 7+ years of experience as a Oracle DBA (11g, 10g, 9i) in IT industry.
- Expertise in Oracle 11g, 10g, 9i on various Unix platforms (Linux, HP-UX, Solaris, AIX), windows NT 4.0/2000/2003 in the areas of database creation, refreshing database, user management, RMAN, Export and Import utility .
- Experience Perl and shell scripting and other Oracle tools and utilities like Oracle OEM, SQL Navigator and TOAD .
- Involved in Installation, Performance Tuning , Backup and Recovery, RDBMS Patching , Security, Oracle Enterprise Manager (OEM), Standby Database , Database Upgrade from 9i to 11g, troubleshooting and basic knowledge of networking and security.
- Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK
- Creation of databases, instances, table spaces, data files, rollback segments.
- Creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers and procedures.
- Design and implementation of Backup & Recovery using RMAN and SQL scripts .
- Proficiency in using Log miner, SQL *Loader and Export/Import utilities.
- Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
- Setting up Standby Database / Oracle DataGuard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
- Experience in Migration of Oracle 9i and 10g databases to 11gr2.
- Experience in installation and configuration of Oracle RAC .
- Experience working on PL/SQL programming on different databases like Oracle8i /9i/ 10g/ 11g.
- Experience as 24x7 Production DBA as well as application (development) DBA .
- Knowledge on Golden Gate with installation, configuration and troubleshooting various issues.
- Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures
- Scheduling Jobs and Alerting using SQL Server Agent
- Installing and Configuring SQL Server 2005 successfully. Transforming data from various data sources using OLEDB connection by creating various DTS packages.
- Monitoring and managing the use of disk space, memory and connections, Initializing database devices, Disk mirroring for recovery, creating, enlarging and removing user database and transaction log, Creating and using segments.
- Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash.
- Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables
- Proactive and efficient in timely delivery of all assignments, always enthusiast to take up new challenges.
- Motivated team player and an adaptable individual with good analytical and strong interpersonal skills.
- Excellent written and verbal communication skills.
Operating System: Solaris, Linux, HP-UX, AIX, Windows 2000 server, Windows 95/98/2000/NT/XP, VMware Databases: ORACLE 11g, 10g, 9i, 8i, MS Access, DB Tools: SQL*Plus, SQL*Loader, Export & Import utility, OEM, Database Configuration Assistant, RMAN, Toad, PL/SQL developer, AWR, ADDM, DataGuard Languages: SQL, PL/SQL, HTML, Java, C, C++, Perl Scripting, K sh. C shell Internet: ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript, Flash MX Software Applications: MS Office, Dream Weaver MX, Adobe Photoshop, MS FrontPage GUI Tools: Oracle Enterprise Manager, Visual Basic 6.0
TECHNICAL EXPERIENCE
Confidential, Irving, TX Sep 2011- Present Oracle DBA Responsibilities:
- Installed, configured and maintained oracle databases on Linux and Solaris environment.
- Created Database as per requirements using DBCA and scripts.
- Startup and Shutdown of individual instance on RAC 2 node environments.
- Implemented and supported two node RAC environments.
- Managed ASM diskgroups via asmcmd and database control.
- Worked on replication technologies such as Shareplex and Dataguard.
- Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, Implemented scripts/tools to help rollout and manage Oracle in a global distributed environment.
- Migrated and upgraded oracle database from 9i to 10g on Veritas Cluster environment.
- Setup jobs and events using Enterprise Manager (OEM) console.
- Implemented dataguard (physical) for high availability/disaster recovery solution.
- Used Import/Export and SQL * Loader utilities to move data and objects Configured and Tested Backups for Oracle Databases by restoration and recovery
- Wrote shell scripts and scheduled them in CRON for monitoring and health checks of database
- Monitoring Database growth and space administration.
- Frequent analysis of objects and schemas.
- Experience in developing, maintaining and debugging procedures, packages and functions using sql developer.
- Export & import at full, schema, tablespace and object level.
- Responsible for Online/Offline database backups and managing Database recovery with RMAN
- Worked on backup and recovery strategies using RMAN.
- Performed database tape backups using netbackup and RMAN.
- Installed, configured and resolved issues on golden gate replication technology.
- Refreshing or cloning databases from production to development using RMAN and OS level scripts
- 24X7 support for databases and production operations teams
- Interacted with Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database
Environment : Oracle 9i, 10g, 11g, RMAN, Solaris, Linux, HP-AX, VMware, RMAN, RAC, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, Shareplex replication.
Confidential, Franklin Lakes, NJ Jul 2010 – Aug 2011 Oracle DBA Responsibilities:
- Perform installation, configuration and of Oracle databases on Solaris, Linux, HP-UX and VMware.
- Determined and implemented best practices for Oracle Setup, Installation, Configuration, Monitoring, Sizing, Capacity Planning, Backup and Recovery strategies
- Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, Implemented scripts/tools to help rollout and manage Oracle in a global distributed environment
- Setup jobs and events using Enterprise Manager(OEM) console, enrolled users and maintained system security by controlling and monitoring user access to the database
- Responsible for developing different databases at various stages of implementation of Projects (Databases for conversion of data, interfaces, training and development)
- Used Import/Export and SQL * Loader utilities to move data and objects
- Monitored and maintained database growth and tablespace utilization
- Devised backup/recovery strategies and implemented it in line with Business requirements (RMAN)
- Configured and Tested Backups for Oracle Databases by restoration and recovery
- Involved in the performance tuning and query optimization
- Experience in Performance Tuning by using tools/utilities by Automated Workload Repository (AWR)
- Installed and Configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (DataGuard) using CRS and ASM .
- Upgraded Oracle Database from 9i to 10g and 11g
- Code reviews of host and interface applications to ensure optimum database connections, resource usages, locks, query response times
- Designed and Implemented Oracle Disaster Recovery Solutions for customers
- Applied patches in production and test instances
- Managing Database (User management, Table space management, Performance related issues).
- Knowledge on basic architecture and functioning of Golden Gate technology.
- Strong hands-on partitioning and performance tuning skills
- Strong SQL and UNIX scripting skills
- Assisting Developers in writing and tuning their queries
Environment : Oracle 9i, 10g, 11g, Solaris, HP-UX, Linux, VMware, RMAN, RAC, SQL*Plus, SQL, AWR, Toad, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, Data Guard, SQL, SQL Server.
Confidential, Redlands, CA Sep 2009- Jun 2010 Oracle DBA Responsibilities:
- Supported more than 40 databases size 1 GB to 1.1 TB having maximum 3 instances for each database. Experience in taking Daily and Weekly Physical backups using RMAN
- Involved in writing korn shell scripts for daily RMAN backups, tape backups, Index rebuilding and to generate Multi-Master Replication. Databases are reorganized to improve performance
- Developed and maintained stored procedures, functions, packages, and triggers and used Oracle standard packages. Daily monitoring Alert logs, growth of table spaces, size of the tables, top sessions and top 10 SQLs
- Developed complex queries and PL/SQL procedures on Data Warehousing environment to facilitate strategic plans to higher levels of management. Created Oracle database redo log members and groups managed on-line redo log files. Responsible for Oracle database performance tuning.
- Cloning of production database to the test environment using Recovery Manager (RMAN)
- Database Administration and Planning including logical design, physical design, backup & recovery
- Implemented DataGuard (Standby) for high availability/disaster recovery purpose
- Developing a backup and recovery strategy and tested several recovery scenarios
- Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc
- Installation of Microsoft SQL Server and Backup Server.
- Database Planning and designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions
- Creation of Database Devices and Databases.
- Configured, implemented, supported, and maintained physical and logical databases.
- Data transfers using BCP. Granting roles and permissions to SQL server users, fixing super user permission, granting & removing permissions of all users, providing security administration by creating groups, users with appropriate roles checking the database Consistency.
- Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash
- Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables.
- Environment: Oracle 11g/10g/9i, Red Hat Linux, AIX, WINDOWS NT/2000, RMAN, RAC, Data Guard, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, SQL Server 2000, SQL Diagnostic Manager, SQL Compliance Manager.
Confidential, Pittsburgh, PA Sep 2008 – Feb 2009 Oracle DBA Responsibilities:
- Installation, up gradation and Maintenances of Oracle RDBMS on Linux & Windows platforms.
- Worked on preparing cluster, configuring and Installation of Cluster ware and Oracle RAC on Red Hat Linux.
- Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
- Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
- Restore and Recovery of database in case of database crash, disk/media failure.
- Created mappings using transformations to load the data into the target.
- Installed and configured Standby database (Data Guard) for high availability/disaster recovery purpose
- Applying patches and works closely with Oracle to make Application environment Up to date.
- Backups & Recovery Maintenance, Databases Performance Tuning.
- Typically involved in database Designing, creation and maintenance.
- Good working knowledge of SQL, PL/SQL, and shell scripting.
- Created users and grant privileges according to the requirements.
- Export and import of database objects using Data pump utilities EXPDP and IMPDP.
- Developed shell scripts and PL/SQL procedures and scheduled CRON jobs and DBMS_JOBS to monitor the database performance and for user management.
- Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
- Provided System support for both development and 24*7 production environments.
Environment : Oracle 11g/10g/9i, Red Hat Linux, AIX, WINDOWS NT/2000, CRON, RMAN, RAC, SQL*Plus, Data Guard, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, STATSPACK.
Confidential, Bangalore, India Sep 2006 – Aug 2008 Oracle DBA Responsibilities:
- Worked in Geographically distributed Onsite - offshore Model.
- Planning for Oracle DB creation on Linux, UNIX and Solaris environment by providing the requested user with the Database creation template and getting all the required information from the users
- Oracle Client and Server installation on Solaris development, acceptance and production server
- Write scripts for database backup using perl and shell scripting language
- Monitoring Database growth and space administration
- Wrote scripts to analyze objects and schemas of Oracle databases
- Resolved performance related and connectivity issues using pl/sql queries for developers.
- Involved in User management, creating role, profile, dblink, synonyms and materialized views.
- Performed RMAN backup & Recovery for development, acceptance and production servers
- Refreshing or cloning databases from production to development
- Wrote Unix shell scripts & PL/SQL scripts for daily system performance & health checks.
- Successfully manipulated Stored Procedures, Functions, Triggers and packages using TOAD and pl/sql developer.
- Developed stored procedures and triggers to facilitate consistent data entry into the database
- Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages
- Wrote XML scripts for the application as per the customer requirements
- Creating HTML pages for the front end as per the customer requirements
- Trained junior database administrators and developers on DB tools and techniques
- Frequently interacted with users and customers regularly.
Environment: Oracle 9i, 10g, Solaris, Linux, PL/SQL, TOAD, PL/SQL developer, UNIX scripting, Html, XML, Import/Export Datapump. Confidential, India Jun 2005- Aug 2006 Oracle DBA
Responsibilities:
- Monitored all the activities of production, test and development databases of BT.
- Installed, configured and upgraded oracle software on different operating systems.
- Database designing and implementation.
- Database creation as per organizational needs.
- Database security by creating users, roles and grants on objects
- Applied the patches on all databases.
- Granted quotas to users on different tablespaces.
- Creation and management of logical and physical objects
- Created profiles and granting to users to protect system resources
- Taken Online, offline and logical backups.
- Monitoring night jobs and scripts for automation of backup and other jobs.
- Performed application tuning by using explain plan and analyzing objects
- Performed database tuning by using tools like tkprof and stats pack.
- Added or altered the DB parameters at session and instance level dynamically and or in offline.
- DB links creation for all remote databases.
- Monitored alert log for any database issues.
- Configured the Enterprise manager and monitoring database activities.
- Designed cloning strategy from production databases to development databases.
- Daily conference with onsite project manager regarding issues and whiteboard activities.
- Preparing the documentation as per the organization standards given.
Environment: Sun Solaris 2.8, Windows NT/2000, Oracle 8.1.x/9.0.1/9.2.0, PL/SQL, SQL, OEM
REFERENCES Available upon request
We'd love your feedback!
![oracle sample resume for 3 years experience oracle sample resume for 3 years experience](https://www.hireitpeople.com/assets/img/privacy-policy-icon.png)
Resume Categories
- .NET Developers/Architects Resumes
- Java Developers/Architects Resumes
- Informatica Developers/Architects Resumes
- Business Analyst (BA) Resumes
- Quality Assurance (QA) Resumes
- Network and Systems Administrators Resumes
- Help Desk and Support specialists Resumes
- Oracle Developers Resumes
- SAP Resumes
- Web Developer Resumes
- Datawarehousing, ETL, Informatica Resumes
- Business Intelligence, Business Object Resumes
- MainFrame Resumes
- Network Admin Resumes
- Oracle Resumes
- ORACLE DBA Resumes
- Other Resumes
- Peoplesoft Resumes
- Project Manager Resumes
- Quality Assurance Resumes
- Recruiter Resumes
- SAS Resumes
- Sharepoint Resumes
- SQL Developers Resumes
- Technical Writers Resumes
- WebSphere Resumes
- Hot Resumes
![oracle sample resume for 3 years experience Are you Hiring?](https://www.hireitpeople.com/img/resume.png)
Are you Hiring?
Talk to a Recruitment Specialist Call: (800) 693-8939
![oracle sample resume for 3 years experience oracle sample resume for 3 years experience](https://www.hireitpeople.com/images/logo-white.png)
- Schedule A Meeting
- Franchise Opportunity
- LCA Posting Notices
- Hire IT Global, Inc - LCA Posting Notices
- Electronic PERM posting Notice
Client Services
- IT Staff Augmentation
- Hire Programmers
- Government Services
- IT Project Management
- Industry Expertise
- Resume Database
Job Seekers
- Browse Jobs
- Upload Resume
- Employee Benefits
- Resume Marketing
- Us Citizens/Green Cards
Visa Sponsorship
- Employer on Record Services (EOR)
- Forms Checklists
- H1B Visa Transfer
- E3 Visa Sponsorship
- TN Visa Sponsorship
- EB3 to EB2 Porting
- Green Card Sponsorship
Resume Worded | Proven Resume Examples
- Resume Examples
- Engineering Resumes
- Oracle Resume Guide & Examples
Oracle Database Administrator Resume Examples: Proven To Get You Hired In 2024
![oracle sample resume for 3 years experience Hiring Manager for Oracle Database Administrator Roles](https://resumeworded.com/assets/images/kimberley-tyler-smith.png)
Jump to a template:
- Oracle Database Administrator
- Database Administrator
Get advice on each section of your resume:
Jump to a resource:
- Oracle Database Administrator Resume Tips
Oracle Database Administrator Resume Template
Download in google doc, word or pdf for free. designed to pass resume screening software in 2022., oracle database administrator resume sample.
A database administrator maintains, organizes, and configures databases in the Oracle management system. They are also responsible for user authorization, data retrieving, network management, etc. Their role is to improve security, accessibility, and data efficiency. Considering the amount of data that companies handle nowadays, this occupation has become more in demand than ever before. To become a database administrator, you can consider getting a college diploma in a CS-related field and getting an Oracle Database management certification. If you need help when preparing for the certification exam, you can find advanced training online.
![Oracle Database Administrator resume example An Oracle database administrator resume example that prioritizes work experience](https://resumeworded.com/assets/images/resume-guides/oracle-database-administrator.png)
We're just getting the template ready for you, just a second left.
Recruiter Insight: Why this resume works in 2022
Tips to help you write your oracle database administrator resume in 2024, create an ats-friendly oracle dba title..
Your title is the first thing that recruiters look at when reviewing your resume, but it’s also the first thing that Applicant Tracking Systems (ATSs) scan. Usually, ATSs are the first filter in the recruitment process, so it’s important to get past them. You should try to include Oracle DBA keywords in your title.
![oracle sample resume for 3 years experience Create an ATS-friendly Oracle DBA title. - Oracle Database Administrator Resume](https://resumeworded.com/assets/images/resume-guides/how-to-images/job-title-resume-title.jpg?job-title=oracle-database-administrator)
Use a strong bulleted list with precise action verbs that describe your role as an Oracle DBA.
Using a bullet list is a great way to optimize your resume. They visually distribute information, so it’s easier to read your responsibilities. DBA is a highly complex career, so it’s important to write clear phrases. Using strong action verbs will help you explain your duties in past roles.
![oracle sample resume for 3 years experience Use a strong bulleted list with precise action verbs that describe your role as an Oracle DBA. - Oracle Database Administrator Resume](https://resumeworded.com/assets/images/resume-guides/how-to-images/action-verbs.jpg?job-title=oracle-database-administrator)
Database Administrator Resume Sample
As a hiring manager who has recruited Oracle Database Administrators at companies like Oracle, Microsoft, and Amazon, I've reviewed hundreds of resumes. The best resumes that lead to interviews and job offers have several things in common. In this article, we'll cover what those are with examples, so you can learn from them and improve your own resume.
Highlight your database performance tuning skills
Companies look for DBAs who can optimize database performance. Show specific examples of how you improved performance:
- Implemented database indexing strategy that reduced query response times by 50%
- Tuned SQL queries to improve application load times from 5 sec to 1 sec
- Optimized database parameters resulting in 30% higher throughput
Contrast this with weak, unspecific examples:
- Responsible for performance tuning
- Worked on optimizing SQL queries
![oracle sample resume for 3 years experience Bullet Point Samples for Oracle Database Administrator](https://resumeworded.com/assets/images/resume-guides/bullet-point-samples/oracle-database-administrator.jpeg)
Provide details on the scale of databases you managed
Hiring managers look for DBAs who have experience managing large, complex databases. Quantify the size and scale of the Oracle databases you worked with:
- Managed 10 Oracle databases, each 500 GB - 1 TB in size
- Administered databases supporting applications with 10,000 concurrent users
- Responsible for 24x7 uptime of mission-critical Oracle databases
Leaving out these specifics makes your experience seem limited:
- Managed several Oracle databases
- Worked on production databases
Demonstrate your problem-solving skills with specific examples
The best DBAs are great problem solvers. Showcase your troubleshooting skills with concrete examples of complex issues you resolved:
- Diagnosed and resolved a critical performance issue in production databases by identifying a missing index in a large table
- Troubleshot and fixed data corruption issues caused by faulty application code
- Worked with developers to identify and resolve SQL queries causing database deadlocks
Generic statements like these don't convey much:
- Problem-solving skills
- Handled database issues
- Worked with developers to fix problems
Mention your experience with high availability and disaster recovery
Companies need DBAs who can ensure databases are always available and have disaster recovery plans. Highlight your skills in this area:
- Implemented Oracle Data Guard for database high availability and disaster recovery
- Set up daily hot backups and quarterly disaster recovery drills
- Configured Oracle RAC clusters for zero downtime during maintenance
Talking about these skills vaguely is not impactful:
- Worked on high availability
- Responsible for backups
- Used Oracle RAC
Showcase your skills in database security and compliance
Database security is a top priority for every company. Demonstrate your knowledge in securing Oracle databases:
- Implemented database encryption for PII data to comply with GDPR
- Conducted regular database security audits and remediated vulnerabilities
- Set up role-based access control and least-privilege user access
Bland, generic mentions of security don't tell the full story:
- Worked on database security
- Responsible for ensuring compliance
- Managed user access
Highlight your collaboration and communication skills
Successful DBAs work closely with application developers, system admins, and business stakeholders. Show how you collaborated cross-functionally:
- Worked with developers to review SQL code and suggest query optimizations
- Partnered with system admins to plan database server patching and upgrades
- Communicated regularly with business users to understand data requirements
Collaboration skills are important; don't just mention them in passing:
- Team player
- Good communication skills
By highlighting these key areas in your Oracle DBA resume with specific, impactful examples, you'll show hiring managers you have the right skills and experience for the job. Use the tips and examples above to make your resume stand out.
Writing Your Oracle Database Administrator Resume: Section By Section
summary.
A resume summary for an Oracle Database Administrator is optional, but it can be a great way to provide additional context about your experience and skills that may not be immediately apparent from the rest of your resume. It's especially useful if you're changing careers or have a lot of experience to summarize. However, avoid using an objective statement, as they are outdated and not helpful for hiring managers.
When writing your summary, focus on highlighting your most relevant skills and experiences for the Oracle Database Administrator role. Avoid repeating information that's already covered in other sections of your resume, and keep it concise - aim for no more than a short paragraph. Remember to naturally incorporate keywords from the job description to help with applicant tracking systems (ATS).
![oracle sample resume for 3 years experience How to write a resume summary if you are applying for an Oracle Database Administrator resume](https://resumeworded.com/assets/images/resume-guides/how-to-images/resume-summary.png?job-title=oracle-database-administrator)
To learn how to write an effective resume summary for your Oracle Database Administrator resume, or figure out if you need one, please read Oracle Database Administrator Resume Summary Examples , or Oracle Database Administrator Resume Objective Examples .
1. Highlight your Oracle database expertise
Your summary is the perfect place to showcase your expertise with Oracle databases. Mention the specific versions of Oracle you have worked with, as well as any certifications or training you have completed.
Avoid generic statements like:
- Experienced database administrator with strong technical skills
- Proven track record of managing databases
Instead, provide specific details that demonstrate your Oracle proficiency:
- Oracle Certified Professional with 5+ years of experience managing Oracle 11g and 12c databases
- Skilled in Oracle performance tuning, backup and recovery, and database security
Make sure to tailor your summary to the specific requirements of the job you're applying for. Our Targeted Resume tool can help you check if your resume has the right skills and keywords for a given job description.
2. Emphasize your impact and achievements
Use your summary to highlight the impact you've made in previous roles. Quantify your achievements whenever possible to give hiring managers a clear picture of your capabilities.
Oracle DBA with experience managing multiple databases. Responsible for ensuring data integrity and optimizing database performance. Strong problem-solving skills and ability to work independently.
While this summary touches on some key responsibilities, it doesn't provide any concrete examples of the candidate's impact. A more effective summary would look like this:
Results-driven Oracle DBA with 7+ years of experience managing high-volume databases. Implemented performance tuning strategies that reduced query response times by 50%. Developed automated backup and recovery processes that minimized downtime and ensured 99.9% data availability. Collaborated with development teams to design and optimize database schemas for new applications.
Avoid using buzzwords like "team player" or "self-starter" in your summary. Instead, let your achievements speak for themselves. Highlight specific projects or initiatives you've led and the measurable results you achieved.
Experience
Your work experience section is the heart of your resume. It's where you show hiring managers what you've accomplished in your career and how you've directly impacted the companies you've worked for. Oracle database administrators should focus on highlighting their technical skills, problem-solving abilities, and experience managing complex database systems.
Here are some key tips to keep in mind when writing your work experience section:
1. Use strong, Oracle-specific action verbs
When describing your work experience, use strong action verbs that are specific to your role as an Oracle database administrator. This helps paint a clear picture of your responsibilities and accomplishments. For example:
- Designed and implemented a high-availability Oracle database architecture, reducing downtime by 90%
- Optimized SQL queries, improving database performance by 50%
- Migrated legacy databases to Oracle 19c, ensuring a smooth transition with minimal disruption
Avoid using weak, generic verbs that don't showcase your technical expertise:
- Worked on database projects
- Helped with database management tasks
- Responsible for SQL queries
![oracle sample resume for 3 years experience Action Verbs for Oracle Database Administrator](https://resumeworded.com/assets/images/resume-guides/bullet-point-samples-action-verbs/oracle-database-administrator.jpeg)
2. Quantify your accomplishments with metrics
Whenever possible, use specific metrics to quantify your accomplishments. This helps hiring managers understand the scope and impact of your work. For example:
- Implemented a data backup and recovery strategy, reducing data loss incidents from 5 per year to zero
- Developed a database monitoring system that identified and resolved 95% of performance issues before end-users were impacted
- Led a team of 5 database administrators, supporting 200+ databases across multiple business units
If you don't have access to specific metrics, use numbers to provide context:
- Managed 15 Oracle databases, ensuring 99.9% uptime for critical business applications
- Created and maintained documentation for 50+ database procedures and best practices
3. Showcase your experience with Oracle tools and technologies
As an Oracle database administrator, it's crucial to showcase your proficiency with Oracle-specific tools and technologies. This helps demonstrate your technical expertise to potential employers. Some key tools and technologies to mention:
- Oracle Database (e.g., 11g, 12c, 19c)
- Oracle SQL Developer
- Oracle Enterprise Manager
- Oracle Data Guard
- Oracle Real Application Clusters (RAC)
When mentioning these tools, provide context on how you used them to solve problems or improve processes. For example:
Utilized Oracle Enterprise Manager to monitor and tune database performance, resulting in a 30% reduction in average query response times.
4. Highlight your career progression and promotions
Employers value candidates who have a track record of growth and advancement. If you've been promoted or taken on increasing responsibilities in your previous roles, make sure to highlight this in your work experience section. For example:
Database Administrator, ABC Company (2018-2021) Senior Database Administrator, ABC Company (2021-Present) - Promoted to Senior DBA role after demonstrating strong leadership skills and technical expertise - Mentored junior DBAs, helping them develop their skills and advance their careers - Spearheaded a database consolidation project, reducing infrastructure costs by 25%
By showcasing your career progression, you demonstrate your ability to take on new challenges and grow within an organization.
Education
Your education section is a crucial part of your Oracle database administrator resume. It shows hiring managers that you have the necessary background and training for the role. Follow these tips to write an effective education section that will impress employers and help you land the job.
![oracle sample resume for 3 years experience How To Write An Education Section - Oracle Database Administrator Roles](https://resumeworded.com/assets/images/resume-guides/education-samples/oracle-database-administrator.jpeg)
1. Put your degree first if you're a recent graduate
If you earned your degree within the past few years, list your education at the top of your resume. This is especially important if you don't have much work experience yet.
Include the following details:
- Name of your degree (e.g. Bachelor of Science in Computer Science)
- University name and location
- Graduation year
You can also add relevant coursework, projects, or achievements if they relate to Oracle database administration. For example:
Bachelor of Science in Computer Science University of California, Los Angeles (UCLA) Graduated: June 2022 Relevant Coursework: Database Systems Data Structures and Algorithms Operating Systems Senior Project: Developed a relational database management system using Oracle SQL and PL/SQL
2. Keep your education section concise if you're experienced
Once you have several years of work experience, your education becomes less important on your resume. Hiring managers will be more interested in the skills and knowledge you've gained on the job.
If you're a mid-level or senior Oracle DBA, you can keep your education section short:
- Master of Science in Information Technology, ABC University
- Bachelor of Science in Computer Science, XYZ College
There's no need to include graduation years, coursework or other details. The exception is if you completed a degree recently that's highly relevant to your current career goals.
Avoid listing outdated or irrelevant education like this:
- Associate of Arts in Business Administration, Community College (1995-1997)
- Online course in WordPress Development (2018)
3. Add Oracle certifications to showcase your expertise
Oracle offers many certifications that validate your skills in database administration. Adding relevant certifications to your education section can make your resume stand out, especially if the job description lists them as a requirement or preference.
Some of the top Oracle DBA certifications include:
- Oracle Database Administration Certified Professional
- Oracle Certified Master
- Oracle Database Cloud Administration Certified Associate
- Oracle Autonomous Database Cloud Specialist
Bachelor of Science in Information Technology Oracle Database Administration Certified Professional Oracle Database Cloud Administration Certified Associate
If you have multiple certifications, consider creating a separate "Certifications" section to highlight them. Only include current, relevant certifications from accredited organizations.
Skills
The skills section on your Oracle Database Administrator resume is critical to getting past Applicant Tracking Systems (ATS) and impressing hiring managers. It's where you highlight your technical abilities and show that you have the right qualifications for the job.
Here are some key tips to keep in mind as you write your skills section:
![oracle sample resume for 3 years experience How To Write Your Skills Section - Oracle Database Administrator Roles](https://resumeworded.com/assets/images/resume-guides/skills-section-samples/oracle-database-administrator.jpeg)
1. Understand how ATS works
Many companies use Applicant Tracking Systems (ATS) to automatically scan resumes for specific skills and keywords. If your resume doesn't contain the skills the ATS is looking for, it may never make it to a human reader.
To get past ATS, carefully review the job description and make sure you include relevant skills from it on your resume. For example, if the job description mentions specific Oracle database versions like 11g or 12c, include those on your resume.
Oracle Database (11g, 12c, 19c) SQL PL/SQL Data modeling Performance tuning
Not sure if your resume will get past ATS? Try out Resume Worded's Targeted Resume tool. It analyzes your resume against a specific job description and provides feedback on which skills you may be missing.
2. Categorize your skills
Grouping your skills into categories makes them easier for hiring managers to quickly skim and understand. As an Oracle DBA, consider categories like:
- Databases : Oracle 11g, 12c, 19c, SQL Server, MySQL
- Programming : SQL, PL/SQL, Python, Shell Scripting
- Tools : RMAN, Data Pump, Oracle Enterprise Manager, Toad
Avoid just listing skills out in a long bulleted list with no organization, like this:
Oracle SQL Linux Disaster recovery Data modeling ETL
When grouping your skills, put the most important and relevant categories first. For an Oracle DBA role, that usually means starting with your database skills.
3. Focus on technical skills
As a technical role, the skills section of your Oracle DBA resume should focus heavily on your hard technical skills. Avoid listing soft skills like "communication" or "problem solving" - those are important, but should be demonstrated through your work experience.
Some key technical skills to consider including:
- Specific Oracle database versions (11g, 12c, 19c)
- Programming languages (SQL, PL/SQL, shell scripting)
- Database backup and recovery (RMAN)
- Performance tuning
- Data modeling
- Cloud databases (Oracle Cloud, AWS RDS)
Not sure which skills are your strongest? Paste your resume into Resume Worded's Score My Resume tool for an instant analysis of your technical skills and other key factors hiring managers look for.
4. Be specific
When listing your skills, be as specific as possible. Instead of just saying "Oracle", list out the specific versions you have experience with.
Similarly, instead of just "programming", call out specific languages like SQL, PL/SQL, Python, etc.
Databases : Oracle 11g, 12c, 19c, PostgreSQL, MySQL Languages : SQL, PL/SQL, Python, Bash Tools : RMAN, Data Pump, Enterprise Manager, Toad, Ansible
This level of detail gives hiring managers a much clearer picture of your abilities compared to something vague like:
Databases Programming Database tools
Listing outdated skills can make you seem behind the times. Avoid including old versions (e.g Oracle 8i) or obsolete technologies on your resume, unless the job description specifically mentions them.
Skills For Oracle Database Administrator Resumes
Here are examples of popular skills from Oracle Database Administrator job descriptions that you can include on your resume.
- Oracle Fusion Middleware
- Oracle Financials
- Business Analysis
- Oracle Cloud
- Shell Scripting
- Enterprise Resource Planning (ERP)
- Requirements Analysis
Skills Word Cloud For Oracle Database Administrator Resumes
This word cloud highlights the important keywords that appear on Oracle Database Administrator job descriptions and resumes. The bigger the word, the more frequently it appears on job postings, and the more likely you should include it in your resume.
![oracle sample resume for 3 years experience Top Oracle Database Administrator Skills and Keywords to Include On Your Resume](https://resumeworded.com/skills-and-keywords/img/oracle-specialist.jpeg)
How to use these skills?
Similar resume templates, contract specialist.
![Contract Manager Resume Sample A professionally crafted resume highlighting relevant skills and experiences for a Contract Manager role.](https://resumeworded.com/assets/images/resume-guides/contract-manager.png)
Office Manager
![Front Office Manager Resume Sample Front Office Manager resume example](https://resumeworded.com/assets/images/resume-guides/front-office-manager.png)
Project Administrator
![Construction Project Administrator Resume Sample A construction project administrator resume template that accentuates technical skills.](https://resumeworded.com/assets/images/resume-guides/construction-project-administrator.png)
- Software Engineer Resume Guide
- Full Stack Developer Resume Guide
- Node.js Resume Guide
- Scrum Master Resume Guide
- Environmental Engineer Resume Guide
Resume Guide: Detailed Insights From Recruiters
- Oracle Resume Guide & Examples for 2022
Improve your Oracle Database Administrator resume, instantly.
Use our free resume checker to get expert feedback on your resume. You will:
• Get a resume score compared to other Oracle Database Administrator resumes in your industry.
• Fix all your resume's mistakes.
• Find the Oracle Database Administrator skills your resume is missing.
• Get rid of hidden red flags the hiring managers and resume screeners look for.
It's instant, free and trusted by 1+ million job seekers globally. Get a better resume, guaranteed .
![oracle sample resume for 3 years experience Improve your resume with the Oracle Database Administrator resume checker](https://resumeworded.com/assets/images/smr-showcase.png)
Oracle Database Administrator Resumes
- Template #1: Oracle Database Administrator
- Template #2: Oracle Database Administrator
- Template #3: Database Administrator
- Skills for Oracle Database Administrator Resumes
- Free Oracle Database Administrator Resume Review
- Other Engineering Resumes
- Oracle Database Administrator Interview Guide
- Oracle Database Administrator Sample Cover Letters
- Alternative Careers to a Oracle Specialist
- All Resumes
- Resume Action Verbs
Download this PDF template.
Creating an account is free and takes five seconds. you'll get access to the pdf version of this resume template., choose an option..
- Have an account? Sign in
E-mail Please enter a valid email address This email address hasn't been signed up yet, or it has already been signed up with Facebook or Google login.
Password Show Your password needs to be between 6 and 50 characters long, and must contain at least 1 letter and 1 number. It looks like your password is incorrect.
Remember me
Forgot your password?
Sign up to get access to Resume Worded's Career Coaching platform in less than 2 minutes
Name Please enter your name correctly
E-mail Remember to use a real email address that you have access to. You will need to confirm your email address before you get access to our features, so please enter it correctly. Please enter a valid email address, or another email address to sign up. We unfortunately can't accept that email domain right now. This email address has already been taken, or you've already signed up via Google or Facebook login. We currently are experiencing a very high server load so Email signup is currently disabled for the next 24 hours. Please sign up with Google or Facebook to continue! We apologize for the inconvenience!
Password Show Your password needs to be between 6 and 50 characters long, and must contain at least 1 letter and 1 number.
Receive resume templates, real resume samples, and updates monthly via email
By continuing, you agree to our Terms and Conditions and Privacy Policy .
Lost your password? Please enter the email address you used when you signed up. We'll send you a link to create a new password.
E-mail This email address either hasn't been signed up yet, or you signed up with Facebook or Google. This email address doesn't look valid.
Back to log-in
These professional templates are optimized to beat resume screeners (i.e. the Applicant Tracking System). You can download the templates in Word, Google Docs, or PDF. For free (limited time).
access samples from top resumes, get inspired by real bullet points that helped candidates get into top companies., get a resume score., find out how effective your resume really is. you'll get access to our confidential resume review tool which will tell you how recruiters see your resume..
![oracle sample resume for 3 years experience oracle sample resume for 3 years experience](https://resumeworded.com/assets/images/maria-img-reviewer.png)
Writing an effective resume has never been easier .
Upgrade to resume worded pro to unlock your full resume review., get this resume template (+ 2 others), plus proven bullet points., for a small one-time fee, you'll get everything you need to write a winning resume in your industry., here's what you'll get:.
- 📄 Get the editable resume template in Google Docs + Word . Plus, you'll also get all 2 other templates .
- ✍️ Get sample bullet points that worked for others in your industry . Copy proven lines and tailor them to your resume.
- 🎯 Optimized to pass all resume screeners (i.e. ATS) . All templates have been professionally designed by recruiters and 100% readable by ATS.
Buy now. Instant delivery via email.
instant access. one-time only., what's your email address.
![oracle sample resume for 3 years experience oracle sample resume for 3 years experience](https://resumeworded.com/assets/images/trustpilot-review-revamped-checkout.png)
I had a clear uptick in responses after using your template. I got many compliments on it from senior hiring staff, and my resume scored way higher when I ran it through ATS resume scanners because it was more readable. Thank you!
![oracle sample resume for 3 years experience oracle sample resume for 3 years experience](https://resumeworded.com/assets/images/updated-trustpilot-bigger-review.png)
Thank you for the checklist! I realized I was making so many mistakes on my resume that I've now fixed. I'm much more confident in my resume now.
![oracle sample resume for 3 years experience oracle sample resume for 3 years experience](https://resumeworded.com/assets/images/resume-guides/authors-14.jpeg)
![](http://nandemo.space/777/templates/cheerup1/res/banner1.gif)
IMAGES
VIDEO
COMMENTS
It analyzes your resume against the job description, identifying key skills and keywords to include for better alignment. 2. Highlight your most relevant Oracle skills and certifications. In your resume summary, emphasize the Oracle skills and certifications that are most relevant to the role you're pursuing.
If you're a recent graduate or have less than 3 years of work experience, put your education section above your work history. ... Skills Word Cloud For Oracle PL/SQL Developer Resumes. This word cloud highlights the important keywords that appear on Oracle PL/SQL Developer job descriptions and resumes. The bigger the word, the more frequently ...
Oracle Pl/sql Developer Resume. 4.50/5 (Submit Your Rating) Hire Now. Professional Summary: Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Involved in all phases of the SDLC (Software Development ...
Whenever possible, use metrics and data to quantify your achievements as an Oracle SQL Developer. This helps hiring managers understand the scope and impact of your work. For example: Optimized SQL queries to improve database performance by 30%, reducing average query runtime from 5 seconds to 3.5 seconds.
Hands-on ability with installation and building database structures. Proficiency developing and maintaining shell scripts as well as programming in PL/SQL. Good analytical and problem solving skills. Ability to perform backup and recovery tasks. Create a Resume in Minutes. 9 Oracle Database Developer resume templates.
3+ year experience in Oracle ERP (PS, EBS) configuration management and migrations 3+ years experience in implementing, administering, troubleshooting and monitoring real time and batch integrations 25 Oracle Database Technical Architect Resume Examples & Samples.
In your resume summary, briefly create an overview of your professional experience and key qualifications. Mention the number of years of experience you have in SQL programming and Oracle PL/SQL development in particular, and highlight any of your notable achievements in the field. Use action words to showcase your proficiency in database ...
Oracle DBA Resume Examples & Samples. Expert in working with Vendor technical support staff, including vendor development teams. Expertise in defining technical plans and procedures. Expert in multiple versions of oracle - 9i, 10g, 11g, 12c plus strong working knowledge of at least one other database technology.
Search for resumes by industry, job title or keyword. search. pl sql developer resume example with 2+ years of experience. Jessica. Claire. [email protected] ... (AR, AP, GL modules of Oracle Applications 11i in multi Org, multicurrency environment. *Hands-on experience with Oracle APEX 5.0.3 (Oracle Application Express). Core ...
A good objective should succinctly demonstrate that you have the necessary skills and experience to excel in the role. Here are a few examples of objectives for Oracle Developer resumes: To leverage 6 years of Oracle development experience to secure a challenging and fulfilling position as an Oracle Developer in a leading organization.
Perfect the header, personal information, and profile title in oracle DBA resumes. The first three must-have resume sections of your database administrator resume are: Header; Personal Information; ... Write a data management resume summary only if you have 3+ years of work experience. For freshers and entry-level professionals, a data ...
PL / SQL Developer. 06/2009 - 05/2016. Boston, MA. Informatica experience. Deep knowledge of SQL and best practices. Demonstrate intermediate (to advanced) understanding of data modeling, schema design and ETL processes. Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions.
For example, if the job description emphasizes experience with Oracle databases, PL/SQL programming, and ETL processes, make sure to highlight your relevant expertise in these areas. Here's an example of a tailored summary: Experienced PL/SQL Developer with 5+ years of experience in designing, developing, and maintaining Oracle databases.
Oracle PL/SQL Developer Resume. Headline : About 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Data Modeling (Logical and Physical).Development of client/server, multi-tiered applications using the Oracle Relational Database Management System (RDBMS), SQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX, and Linux.
Minimum 4-7 years experience in coding, testing and or debugging skills Minimum 4-7 years experience with Oracle, writing PL/SQL packages/procedures, XML, high volume data management Minimum 3+ year experience with UNIX/linux, ksh scripting Having SAS or Java experience is a plus Experience is production support
Search for resumes by industry, job title or keyword. search. oracle pl sql developer resume example with 12+ years of experience. Jessica Claire. Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., ... Oracle PL/SQL specialist; Experience in using SQL Navigator, TOAD for Oracle, SQL Developer, and Eclipse developing tools ...
In that way, oracle database administrator resumes become more focused on strengths and skills ; Transferrable skills - or ones obtained thanks to work and life experience - have become the core of the resume ; ... As a software engineer with 8 years of experience, now specialized in Oracle Database Administration for the past 4 years, I have ...
Hire Now. PROFILE: Around 6 Years of IT experience, 5.8 Years of Oracle PL/SQL Programming experience. 3 years of Strong Unix Shell Programming Experience. 1.6 year of Informatica Experience. Building software components using Oracle 9i, 10g, 11g (SQL, PL/SQL). Involved in tuning of Data Base. Performing Unit Test for the software components ...
Template 3 of 14: Junior SQL Developer Resume Example. A junior SQL developer is an entry level role and a great way to kickstart a career in SQL development. SQL developers create and maintain databases for an organization. These databases help organizations compile data in a more secure and cost-effective way.
Oracle Pl/sql Developer Resume. 3.00 /5 (Submit Your Rating) Hire Now. Summary. 8 years of working experience in Oracle 8i,9i,10G,11G, SQL and PL/SQL procedures, functions, packages, triggers, cursors, view etc. Good experience in PL/SQL and ETL scripting and query optimization. I used Informatica Tool for ETL Process.
At least 3 years experience in Oracle (Grid Infrastructure / Computer Reservations System) aka RAC At least 2 years experience in Oracle Cloud Control 12c At least 2 years experience in Red Hat Enterprise Linux 5.8 and 6.2 39 Oracle Database Administrator Resume Examples & Samples.
Oracle Database Administrator Resume. 3.89 /5 (Submit Your Rating) Hire Now. PROFESSIONAL SUMMARY. Over 7+ years of experience as a Oracle DBA (11g, 10g, 9i) in IT industry. Expertise in Oracle 11g, 10g, 9i on various Unix platforms (Linux, HP-UX, Solaris, AIX), windows NT 4./2000/2003 in the areas of database creation, refreshing database ...
Results-driven Oracle DBA with 7+ years of experience managing high-volume databases. Implemented performance tuning strategies that reduced query response times by 50%. ... Skills Word Cloud For Oracle Database Administrator Resumes. This word cloud highlights the important keywords that appear on Oracle Database Administrator job descriptions ...