Software Engineer - II
Total years of experience :15 years, 8 Months
Microsoft - (Hyderabad, India)
SDS (Casino - System Software)
Worked on the database requirement for the casino slot management system application which
includes slot monitoring, slot accounting, slot operations, cashless transfer, ticketing, jackpots,
promotional coupons, redemptions etc.
Role and Responsibilities:
•Design and development database objects and schema for product enhancements/releases.
•Writing Stored Procedures, Views, Functions and other T-SQL for the product requirement.
•Writing Upgrade Scripts for each product versions and handling multiple database version Upgrade.
•DB Upgrade script testing (Data and Schema comparison) and releasing DB build in different envt.
•Performance Tuning and optimization of Database queries and related objects.
•Handling the Backup/Restore and Maintenance of the Database in Dev. and QA environment.
•Database Administration activities including Monitoring DB Server, Configuring and Managing Jobs, SQL Replication, Always ON, Backup/Restore, DB Re-Indexing and Statistics update for the database. Developed own tool for the DB Maintenance activity.
•Developed the DWH/ETL Solution (SSIS) for the business report requirement of the Product.
•SunGard (FIS
AG (Workflow Product)
Worked on the database requirement for Product AG, which is basically a workflow product
that helps multiple business organization to control the flow of work within their organization
having full control and track on each activity.
Role and Responsibilities:
•Design and development database objects and schema for product enhancements/releases.
•Writing Stored Procedures, Views, Functions and other T-Sql for the product requirement.
•Writing Upgrade Scripts for each product versions and handling multiple database version Upgrade.
•DB Upgrade script testing (Data & Schema comparison) and releasing DB build in different envt.
•Performance Tuning and optimization of Database queries and related objects.
•Handling the Backup/Restore and Maintenance of the Database in Dev. and QA environment.