Company

Tech MahindraSee more

addressAddressSydney, NSW
CategoryMechanical

Job description

Designation / Job title: Database Programmer/Developer_261312-Developer Programmer

Primary or Mandatory skills:

  • Migrated SQL on-prem databases on to Azure Cloud.
  • Providing 24x7 support for Claims DB Servers on DEV/SYS/Training/UAT and Perf environment SQL Servers.
  • Upgrading SQL Server from SQL 2012 to SQL 2017, 2019.
  • Installing and Configuring SQL Server 2019 Enterprise edition.

Good to have skills:

  • Monitoring all DB server using RedGate Monitoring tool. 
  • Working on Tickets which were raised in Service. 
  • Configuring Backups on Cohesity tool. 
  • Configuring Nagios Alerts. 
  • Monitoring SQL Server performance using perfmon, Profiler, DBCC Commands and DMV’s. 
  • Monitoring windows event viewer, SQL logs and job histories for troubleshooting. 
  • Tuning SQL Queries & improving the performance of the Database. 
  • Involving in Disaster Recovery testing. 

Detailed Job description : -

  • Design database systems. Database Developers’ main responsibility is to analyze the needs of an organization and produce an effective database system according to their needs and specifications. This includes collecting data, analyzing the data, designing algorithms, drawing flowcharts and implementing code for the logic developed through the algorithms and flowcharts.
  • Test databases. A database developer must be able to run performance testing procedures to ensure the proper operations of a database and to ensure that it’s error-free. If any errors are thrown when the code runs, they need to be corrected and the code needs to be re-tested. This involves troubleshooting any potential problems, creating and submitting test reports and database improvement.
  • Develop database documentation. As a database is developed, the database developer must write documentation about the system and put together an operational manual. The documentation must include information regarding changes or improvements to the database as they are implemented.
  • Work with the front-end development team. Once the databases are ready, and the front-end development is complete, a database developer must work with the front-end development team to integrate the modules together. Once this is done, the integrated code must again be tested, and any errors must be fixed.
  • Involved in migrating Vendor data into Target system, Troubleshooting and fixing the issues.
  • Performing health checks and monitoring
  • Performing Maintenance tasks like rebuilding, reorganizing indexes, update statistics and checking database integrity at regular intervals.
  • Building High availability Clusters using Availability Groups.
  • Migrating Claims GASP data into Fineos Databases
  • Working on Jira tickets raised by testers and developers.
  • Refreshing lower environments whenever vendor gives a new release.
  • Monitor the jobs on lower environments.
  • Working closely with the application team in resolving their issues.
  • Monitoring Daily Maintenance Jobs which were configured for Health checks, Space alerts, Database stats, Backups, and integration jobs.
Refer code: 2240861. Tech Mahindra - The previous day - 2024-05-22 23:05

Tech Mahindra

Sydney, NSW
Jobs feed

Amazon Delivery Driver

Amazon Flex

Armadale, WA

Medical Laboratory Scientist - Research Assistant

Nsw Health Pathology

Sydney, NSW

Safety & Compliance Officer - Goondiwindi

National Heavy Vehicle Regulator

Goondiwindi, QLD

Research Assistant - EECS, Faculty of EAIT

The University Of Queensland

Queensland

Coordinator

Bunnings Warehouse

Mount Isa, QLD

Maintenance Team Leader - Residential Aged Care

Baptistcare Nsw & Act

Point Clare, NSW

Airport Services Officer

Shire Of Wyndham East Kimberley

Broome, WA

Warehousing Assistant

Flexiforce Australia

Goulburn, NSW

Sheet Metal Fabricator

Hays Recruitment

Parramatta, NSW

Sales Representative

Conquest Personnel

Altona, VIC

Share jobs with friends

Related jobs

Database Programmer/Developer_261312-Developer Programmer

Developer Programmer-261312/Database Programmer

Tech Mahindra

$100,000 per year

Macquarie Park, NSW

4 months ago - seen

Developer Programmer- 261312 / Database Programmer / Developer

Tech Mahindra

$80,001-100,000 per year

Macquarie Park, NSW

5 months ago - seen