Database Administrator

Tata Consultancy Services Limited
Irving, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 115K

Job location

Irving, United States of America

Tech stack

Amazon Web Services (AWS)
Build Automation
Databases
Data Definition Language
ETL
Relational Databases
Database Design
Software Debugging
DevOps
Web Development
File Systems
PostgreSQL
Microsoft SQL Server
MongoDB
Oracle Applications
Systems Development Life Cycle
Red Hat Enterprise Linux - RHEL
Regression Testing
Standard Sql
Reverse Engineering
Software Engineering
Data Streaming
Lightspeed
Software Application Programming
Technical Debt
Information Technology
Star Schema
Software Version Control

Job description

  • 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

Requirements

Do you have a Bachelor's degree?, 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., Qualifications : BACHELOR OF COMPUTER SCIENCE

Apply for this position