Duties & responsibilities
As Senior DBA - responsible for maintaining and tuning or database environment.
The DBA will work with other infrastructure team members and support vendors to ensure that the environment is operating as efficiently as possible.
Willing to work in a 24x7 production mission critical environment, including weekends
Alert and diagnostic monitoring
Work closely with development team to analyse performance issues and provide feedback to improve PeopleSoft performance
Develop administration automation and monitoring scripts as needed
Preparation of performance reports and assessment of load metrics.
Develop and maintain Standard Operating Procedures / documentation
Proactively diagnosing and resolving problems affecting database systems
Provide escalation support for database related issues with Oracle support
Share knowledge and mentor junior team members as needed
Attend weekly team meetings and participate team building activities
Knowledge with Salesforce platform production deployments and working in an agile methodology environment.
Experience with Peoplesoft 9.2 Database Administrator.
Experience with Oracle database 11g, 12c, 18c, RAC, ASM, Data Guard and Performance tuning
Experience in administration, configuration and troubleshooting of Exadata machine components including Cell Server, Infiniband switch, Cisco switch, PDU, KVM.
Hands on experience in Exadata patching and upgrade of Cell server, compute node, grid database, Infiniband switch, Cisco switch in Exadata / RAC environment.
Configuring the monitoring the cell server thresholds and the cell server, InfiniBand, cisco switch, RAC interconnect issues.
Experience in troubleshooting network and I / O related issues in the Exadata environment.
In Depth understanding of performance tuning in Exadata using Smart Scan, Storage Index, HCC, IORM, Flash Cache etc.
Experience with Oracle Enterprise Manager for monitoring and administering mission critical databases
Experience in configuring Database Backup and Recovery using RMAN and recovery for databases in TBs.
Practical exposure to Data Guard setup, switch over, fail over and gap resolution.
Experience with Oracle database patching and upgrades
In depth knowledge of query tuning using Explain plan, segment level tuning and server / database tuning using the Automatic Workload Repository (AWR), Huge pages, and OS commands.
Good communication and inter personal skills.
Database Administration for PeopleSoft application : 6+ years’ experience
Oracle Database Administration : 8+ years’ experience
Oracle Exadata Administration : 5+ years’ experience
Linux shell scripting : 5+ years’ experience
BS in Business or Computer Science or equivalent experience
Oracle Exadata Training and Certification
Oracle Database Training and Certification
JLL Privacy Notice
Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services.
We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process.
We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons.
We will then delete it safely and securely.
For more information about how JLL processes your personal data, please view our Candidate Privacy Statement.
For additional details please see our career site pages for each country.
For employees in the United States, please see a fully copy of our Equal Employment Opportunity and Affirmative Action policy here.
Jones Lang LaSalle ( JLL ) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities.
If you need a reasonable accommodation because of a disability for any part of the employment process including the online application and / or overall selection process you may email us at Accommodation.
Reques am.jl..com. This email is only to request an accommodation. Please direct any other general recruiting inquiries to our Contact Us page >
I want to work for JLL.