Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Oracle Database Administrator
Job
Tata Consultancy Services
Grand Prairie, TX (In Person)
$107,500 Salary, Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
72
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Oracle Database Administrator at Tata Consultancy Services Oracle Database Administrator at Tata Consultancy Services in Grand Prairie, Texas Posted in 1 day ago.
Type:
full-timeJob Description:
Must Have Technical/Functional Skills:
- 5+ years of Oracle PL/SQL development experience in web application development.
- Expertise in logical and physical data models, maintenance of DDLs.
- Expertise in Oracle objects, PL/SQL code, and abilities to write complex SQLs.
- Must collaborate with server side/UI developers, and DBAs to develop end-to-end solution.
- Familiarity with AWS cloud, prepare to migrate applications, services, and data to AWS.
- Familiarity with ETLs, data migrations
- Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout.
- Experience with building Database warehouse Solution.
- Extensive experience with Database compression and purging techniques.
- Experience with MSSQL, mongoDB and postgres will be an added advantage.
- Working knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle
ASM & ACFS.
Roles & Responsibilities- Work in an agile environment following through the best practices of agile Scrum.
- Analyze the requirements, seek clarifications, contribute to good acceptance criteria, estimate, and be committed.
- Take pride in designing solutions, developing the code free from defects and vulnerabilities, meeting functional and non-functional requirements by following modern engineering practices, reducing rework, continuously addressing technical debt.
- Contribute to overall team performance by helping others, peer reviewing the code diligently.
- Bring agility to application development through DevOps practices - automated builds, unit/functional tests, static/dynamic scans, regression tests etc.
- Lookout for providing best possible customer support by troubleshooting, resolving production incidents and by eliminating the problems from the root level.
- Bring innovative solutions to reduce the operational risks by automating mundane repetitive tasks across SDLC.
- Learn to become full stack developer to address end-to-end delivery of user stories.
- Make changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages using CI/CD pipelines such as LightSpeed and promote them to higher environments (UAT, Production and Cob) following SDLC using Release on Demand.
- Help in finding current performance bottlenecks and provide solutions to improve performance
- Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions.
- Change Control Management using Source Control System
- Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
- Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint
- Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation