ORACLE DBA – Logical
The focus of your role within Capgemini, what you do:
Production and non-production DBA support for Oracle databases in a fast-paced environment. Performance tuning of database, SQL, PL/SQL, materialized views, BI applications. Analysis of SQL trace and TKPROF output. Review DDLs, database logon triggers, audit triggers, etc. Analysis of alert log errors. Analysis of “Snapshot too old” errors and “running out of TEMP tablespace” errors caused by poorly written SQL or insufficient stats; work with application teams to take corrective action. Work with application teams to improve PL/SQL performance. Provide monitoring and tuning for application-specific problems such as long-running jobs and take corrective action. Perform DBA tasks such as Oracle install, patching databases, RMAN refresh, export/import, RMAN backup and recovery. Provide database problem definition, analysis and tuning of performance problems specific to database engine i.e. database locks Monitor “health” of Oracle database; take corrective action.
What you bring:
8+ years’ experience with on-premises administration of Oracle databases
MUST be a US Citizen or Permanent Resident due to ITAR restrictions
Strong technical knowledge of SQL & PL/SQL performance tuning with BI applications and materialized views
Strong knowledge with OEM, Diagnostic & Tuning packs, stats, AWR, ASH, tkprof
Familiarity with DDL, database logon triggers, audit triggers, etc.
Hands-on experience with Oracle development tools on Windows
Hands-on experience with Oracle databases in UNIX/Linux environments
Must understand logical and physical data modelling design concepts
Monitor various coding and job design implementations as per documented standards
Strong knowledge of Multi-Tier (Web, Apps, Database and DMZ Tiers) application environment
Manage backup, restore, and disaster recovery processes and procedures
Manage deployments of code and patching cycles through non-production and production environments
Participate in On-call rotation
Proficiency with Linux/Unix shell scripting
Proficiency with Windows batch scripting
Hands on experience with Oracle database upgrades and migrations
Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.
Applicants for employment in the US must have valid work authorization that does not now require sponsorship of a visa for employment authorization in the US by Capgemini.
With more than 190,000 people, Capgemini is present in over 40 countries and celebrates its 50th Anniversary year in 2017. A global leader in consulting, technology and outsourcing services, the Group reported 2016 global revenues of EUR 12.5 billion (about $13.8 billion USD at 2016 average rate). Together with its clients, Capgemini creates and delivers business, technology and digital solutions that fit their needs, enabling them to achieve innovation and competitiveness. A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model..
Learn more about us at www.capgemini.com.
Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Click the following link for more information on your rights as an Applicant: http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law