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.