Senior DBA 2- Logical DBA PL/SQL - Virtual

Capgemini - Phoenix, AZ3.8

30+ days ago
Who we are?
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. 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/us-en/

Rightshore® is a trademark belonging to Capgemini
Within Capgemini, the Cloud Infrastructure Services business provides leading solutions to large global customers through an integrated global sales and delivery model. We are a global team of committed professionals who advise, transform and run client IT services. We help organizations meet their business goals by transforming and managing their IT infrastructure landscape – leveraging innovations notably in automation and the cloud.

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

ORACLE DBA - Logical

Location: Virtual

Travel: 10%

The focus of your role within Capgemini, what you do:
Production and non-production DBA support for Oracle databases in a fast-paced environment. Database and application performance tuning, support database problem resolution with OEM and sqlplus. Provide database object management monitoring and analysis. Analysis and tuning of SQL query, PL/SQL, indexes, materialized views utilizing SQL trace and TKPROF. Analysis of alert log errors with efficiency. Communicate and provide support for 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 database installation, patching, database replication, export/import, RMAN backup and recovery. Configure database backups with rman and netbackup. Comfortably monitor "health" of complex multi-database environment.

Click the following link for more information on your rights as an Applicant -http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law

Qualifications

What you bring:
8+ years’ experience with administration of Oracle databases
MUST be a US Citizen or Permanent Resident due to ITAR restrictions
Strong technical knowledge of performance tuning of BI applications utilizing sqlplus and explain plan.
Strong knowledge with OEM, Diagnostic & Tuning packs, stats, AWR, ASH and sql profile
Familiarity with all functions of database objects and manipulation.
Hands-on experience with Oracle development tools
Hands-on experience with Oracle databases in UNIX/Linux and Windows 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 architecture (Web, Apps, Database and DMZ Tiers) application environment
Maintain and manage database security policy and procedures
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
Ability to communicate effectively in stressful situations.

Preferred:
Proficiency with Linux/Unix shell scripting
Proficiency with Windows batch scripting
Strong proficiency in SQL tuning
Hands on experience with Oracle database upgrades and migrations

What we offer:
Your career matters to you and is important to us too. Because your goals and needs are constantly evolving, we offer visibility, leeway and support to help you grow and progress in your career. This approach builds notably on our comprehensive competency framework, our personal development, training and career management programs, and our University innovative and business-focused learning curriculums.
We promote a culture of diversity. We believe working with talented individuals from different backgrounds and points of view is a strategic advantage and an ongoing opportunity. Diversity enriches our creative solutions and adds value for our clients.
Our Shared values have been at the heart of the group since our formation. They are honesty, boldness, trust, freedom, team spirit, modesty and fun. These values influence the way we meet client needs while respecting the regulatory requirements of each country in which we operate, and the way we promote ethically sound practices within Capgemini and in our partnerships.
Capgemini America Inc. and its U.S. affiliates are EEO/AA employers. Capgemini conducts all employment-related activities without regard to race, religion, color, national origin, age, sex, marital status, sexual orientation, gender identity/expression, disability, citizenship status, genetics, or status as a Vietnam-era, special disabled and other covered veteran status. Capgemini is a Drug-Free Workplace employer.
Capgemini is committed to building a workforce of employees with diverse backgrounds and work experiences. We strongly encourage veterans and active military service personnel to apply.
  • LI-CV1