Configure and manage SQL server databases and processes. Design, develop and implement database systems based on customer requirements. Monitor system's health and performance. Ensure high levels of performance, availability, sustainability and security. Analyze, solve, and correct issues in real time. Provide suggestions for solutions. Refine and automate regular processes, track issues, and document changes. Develop stored procedures, functions, packages, triggers and views using T-SQL. Maintaining ETL scripts and packages and writing test cases algorithm with the ability to perform automated testing to get a deeper understanding of the software. Fraud detection in Health Insurance system SQL business logic development (Visio based algorithm structure to stored procedure conversion). Review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working at peak levels. Coordinate with customers and Business Analysts to determine business data reporting and analysis requirements. Optimize database systems for performance efficiency. Prepare design specifications and functional documentations for assigned database projects. Perform space management and capacity planning for database systems. Develop database tables and dictionaries. Identify any issues related to database performance and provide corrective measures. Create complex functions, scripts, stored procedures and triggers to support application development. Participate in database design and architecture to support application development projects. Perform data back-up on regular basis. Troubleshoot database related issues in a timely fashion. Develop security procedures to protect databases from unauthorized usage.