SR. Database Administrator
- Camp Dresser
- 4 to 6 Yrs
- Bengaluru
- 5 years ago
- Email to a friend
- Report this job
Job Description
Senior Applications Database Administrator
Seeking a Senior DBA for primary support of Oracle E- Business Suite environments and secondary support of AWS, SQL and third- party products. Candidate should exhibit technical proficiency at proactively supporting recoverable applications and databases in a 24/ 7 hosting environment. Individual must possess excellent verbal and written communication skills.
Oracle E- Business Suite (R12.2 and 11i) Application Administration:
Perform major EBS environment upgrades and migrations with minimal downtime.
Coordinate with deployment teams to promote code based on formal Change Management process to user test and production environments with minimal disruption to user productivity.
Refresh Non- Production instances from Production.
Perform application patch analysis, install and resolve patch install issues.
System Administration such as Oracle Workflow support, add new accounts or roles, set profiles and grant user privileges at appropriate levels of access.
Assist in installing new Products/ Modules as per business requirement.
Support and maintain high availability architecture load balancing/ failover.
Database Administration:
Provide Production and Non- Production database access.
Backup, restore Oracle databases and resolve backup issues.
Coordinate with Unix, Storage and Network teams in planning/ executing DBA tasks.
Excellent experience in Oracle developer software tools like TOAD.
Patch analysis, planning and executing database patches after due testing and approvals.
Provide sizing/ capacity planning recommendations.
Performance Tuning:
Identifying poorly performing Concurrent Programs/ SQL queries and work with technical teams to tune SQL queries/ procedures.
Diagnose and present effective solutions for application and database performance issues supported by empirical evidence.
Optimize the Database and Application Components and parameters for sustained performance and avoiding performance bottlenecks.
Review and generate database statistics.
Service Desk Support:
Triage, escalate and troubleshoot user issues and resolve service incidents.
Assist IT business analyst and development teams.
Create and manage Oracle Support service requests for database and application issues.
Assist in supporting third- party products and external interfaces.
Requisition ID:
21605BR
Business Unit:
COR
Job Title:
SR. Database Administrator - Oracle Applications
Group:
COR
CDM Smith Employment Type:
Regular
Minimum Qualifications:
Bachelor s degree or equivalent (CS, CE, CIS, IS, MIS or engineering discipline).
8 plus years of experience in Oracle EBS (11i & R12) Applications DBA support.
Strong experience in Oracle EBS R12.2 patching and cloning a must.
Hands on working knowledge of database SQL commands and scripting.
Knowledge of Linux operating system commands, cron jobs, utilities.
Effective written skills to create and maintain high quality documents in a shared knowledge climate.
Available to work US shift: 6:30 pm to 3:30 am IST (9 am to 6 pm EST) from office.
Available off hours for occasional critical support and maintenance.
Preferred Qualifications:
Development experience (SQL, PL/ SQL, Unix Shells, Python, Lambda, PowerShell, VBScript) for administration automation.
Provide secondary support for AWS Redshift and Microsoft SQL Server Databases.
Ability to configure alerts using OEM and scripts to monitor system health and proactively identify issues and harmful trends.
Experience in implementing operational automation and scheduling tasks.
Critical thinking skills, able to analyze situations, challenge assumptions, develop methodologies, present and defend conclusions and recommend action plans.
Highly cautious, disciplined approach to security administration and data protection per mandatory legal requirements.
Self- motivated and fosters a cooperative work environment. Ideal candidate should be able to work either as part of a global, diverse team or independently with minimum supervision.
Intellectual curiosity and willingness to delve into a problem and understand the root cause.
Ability to prioritize and manage multiple short term and long- term tasks.
Contributes to the culture by supporting and contributing to process and quality improvement and offering innovative business solutions.
Why CDM Smith:
CDM Smith provides lasting and integrated solutions in water, environment, transportation, energy and facilities to public and private clients worldwide. As a full- service consulting, engineering, construction, and operations firm, we deliver exceptional client service, quality results and enduring value across the entire project life cycle.
Job Site Location:
India - Bangalore
Agency Disclaimer:
All vendors must have a signed CDM Smith Placement Agreement from the CDM Smith Recruitment Center Manager to receive payment for your placement. Verbal or written commitments from any other member of the CDM Smith staff will not be considered binding terms. All unsolicited resumes sent to CDM Smith and any resume submitted to any employee outside of CDM Smith Recruiting Center Team (RCT) will be considered property of CDM Smith. CDM Smith will not be held liable to pay a placement fee.,
Employement Category:
Employement Type: Full timeIndustry: BPO / Call Center
Role Category: Network / System Administration
Functional Area: Not Applicable
Role/Responsibilies: SR. Database Administrator
Contact Details:
Company Name: Camp DresserLocation(s): Bengaluru
Keyskills: working knowledge
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in
