Deloitte Oracle DBA in Mechanicsburg, Pennsylvania
Are you an experienced, passionate pioneer in technology a solutions builder, a roll-up-your-sleeves technologist who wants a daily collaborative environment, think-tank feel and share new ideas with your colleagues - without the extensive demands of travel? If so, consider an opportunity with our US Delivery Center we are breaking the mold of a typical Delivery Center.
Our US Delivery Centers have been growing since 2014 with significant, continued growth on the horizon. Interested? Read more about our opportunity below
Work you will do
The Oracle DBA will be part of a team responsible for the implementation, configuration, maintenance, and performance of critical Oracle Database systems, ensuring high availability and consistent performance of our mission-critical applications in a service provider model. This position requires solid technical, interpersonal and communication skills. In addition, this is an operational support role, so periodic flexible schedule (ie evenings, weekends, etc) is required.
Ensures all databases are efficiently tuned and optimized in order to enhance database performance.
Provides daily administration and performance monitoring of database related systems.
Maximize database availability and performance to meet or exceed defined SLA's.
Create new database environments (DEV/QA/UAT/Production/Standby) to support development and product progression.
Identify and recommend solutions to performance issues on Oracle DBs.
Responsible for the installation, upgrade and patching of database systems.
Provide knowledge and recommendations on SQL tuning.
Ensures reliable database backups via recovery manager (RMAN). Checks the integrity of the backups by carrying out regular restores.
Assist as needed in investigating, troubleshooting and resolving database incidents/problems.
Design, tune and support Production and Disaster Recovery hierarchies.
Develop methods for monitoring database capacity and usage.
Has a solid understanding of Unix, Linux and Windows servers.
Automate regular database tasks.
Provides on call support as needed.
Perform scheduled maintenance and support release deployment activities after hours.
Manage and monitor alerts for all DBs using OEM13c.
Supports additional Oracle products such as dataguard and oracle enterprise manager 13c.
Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
From our centers, we work with Deloitte consultants to design, develop and build solutionsto help clients reimagine, reshape and rewire the competitive fabric of entire industries. Our centers house a multitude of specialists, ranging from systems designers, architects and integrators, to creative digital experts, to cyber risk and human capital professionals. All work together on diverse projects from advanced preconfigured solutions and methodologies, to brand-building and campaign management. We are a unique blend of skills and experiences, yet we underline the value of each individual, providing customized career paths, fostering innovation and knowledge development with a focus on quality. The US Delivery Center supports a collaborativeteam culture where we work and live close to home with limited travel.
3 years of experience in managing Oracle databases on Solaris/ Linux / Windows platforms.
3 years of experience developing Unix Shell scripts and setting up cronjobs
Database performance expertise
Setup client authentication
Hands on experience with Setup and maintenance of Oracle Data Guard
experience tuning SQL queries.
Root cause analysis of database issues - session and trace data analysis
Import and export of schema or objects.
Analyzing ADDM/AWR/ASH reports.
Experience with Oracle 11g or Higher, installations, upgrades and security patches
Implement database security for test case& execution management
Knowledge of SQL and PL/SQL Commands
Excellent interpersonal and communication skills
Be a team player working with a diverse group of team members
Backup and restore of database
Limited sponsorship maybe available for the role
Additional US Delivery Center Requirements:
Must be willing to live and work in Lake Mary, FL or Mechanicsburg, PA
How you ll grow
At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there s always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.
At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits.
Deloitte s culture
Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives.
Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte s impact on the world. at http://www2.deloitte.com/us/en/pages/about-deloitte/articles/deloitte-corporate-citizenship.html
We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you re applying to. Check out recruiting tips from Deloitte professionals. at http://www2.deloitte.com/us/en/pages/careers/topics/recruiting-tips.html
Category: Information Technology
As used in this document, Deloitte means Deloitte LLP and its subsidiaries. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.
- Deloitte Jobs