Database Administrator

Tata Consultancy Services Ltd

Irving, TX

JOB DETAILS
SALARY
$95,000–$115,000 Per Year
SKILLS
Acceptance Testing, Amazon Web Services (AWS), Best Practices, Blueprints, Business Analysis, Change Control, Cloud Computing, Code Reviews, Coding Standards, Computer Security, Continuous Deployment/Delivery, Continuous Integration, Customer Support/Service, Data Migration, Data Modeling, Data Modeling Tools, Data Processing, Data Warehousing, Database Administration, Database Design, Database Technology, Debugging Skills, DevOps, Functional Testing, Identify Issues, Industry Standards, Linux File Systems, Microsoft SQL Server, MongoDB, Oracle, Oracle PL-SQL, Oracle RAC (Real Application Clusters), Performance Analysis, Performance Management, PostgreSQL, Process Analysis, Process Flow, Red Hat Linux Operating System, Regression Testing, Relational Databases (RDBMS), Requirements Management, Reverse Engineering, Risk Management, Scrum Project Management and Software Development, Server Programming/Applications, Software Design, Software Development, Software Development Lifecycle (SDLC), Software Engineering, Source Code Control System (SCCS), Star Schema, Systems Administration/Management, Testing, Unit Test, User Interface/Experience (UI/UX), Web Programming, Writing Skills
LOCATION
Irving, TX
POSTED
23 days ago

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

Salary Range: $95,000 to $115,000 per year

About the Company

T

Tata Consultancy Services Ltd