Shalem Raju

Installation and configuration of MS-SQL Servers. Creating user databases, ensuring file group creations, and placing files in appropriate locations. Created new user accounts, profiles, and roles and assigned them to different users and enabled auditing to monitor the system privileges and roles granted. Log shipping configuring and monitoring. Managing replication in SQL Server 2016/2017/2019/2022 and monitoring replication server. SQL Setup, troubleshooting, maintenance & upgrade. Solving different database-related issues like taking care of different processes consuming high CPU resources, and blocking and running queries. Creating procedures and SSIS packages. Monitoring SQL Server Backups, upgrades to the new version, applying service packs to correct server bugs and troubleshooting SQL Server issues. Monitor the status of scheduled jobs - on daily and weekend tasks rebuilding indexes, defragmenting databases, shrinking databases, and database complete backup. Communicating regularly with all teams to ensure database integrity and security. Have created jobs, alerts, SQL Mail Agent and scheduling DTS.

Experience in SQL Server 2008/2008R2/2012/2016/2017/2019 implementation and Maintenance. Creating user databases, ensuring file group creations, and placing files in appropriate locations. Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions. Experience in Database Migration Activity from one Data Centre to another. Planning backup and recovery strategies for various database environments. Performed different file recoveries in the database. Space monitoring and adding space to the database when needed. Performing SQL server daily health check and preparing a report based on it Creating linked servers. Scheduling jobs. Reviewing SQL Server and SQL Server Agent Error Logs. Interacting with other teams frequently to resolve different issues. Demonstrate mastery in collecting and extracting financial data from Quarterly, Half-yearly, and Annual reports of assigned companies, spanning an impressive five-year period. Proficiently apply subject blocks and tags, while effectively assigning period, currency, and quantum attributes to align data with the original financial reports, ensuring data accuracy.

Executed manual testing to ensure data integrity and quality for diverse client databases. Collaborated with cross-functional teams to resolve performance and security issues, integrating quality standards. Conducted root cause analysis and implemented suitable actions to minimize recurring issues and optimize performance. Performed Data Quality Dashboard check for the developed financial data. Real-time delivery of Financials as and when it reports within the SLA. Mastered collecting and extracting financial data from periodic reports, ensuring accuracy over five years. Applied subject blocks, tags, and attributes to align financial data with original reports, ensuring precision.

Executed manual testing to ensure data integrity and quality for diverse client databases. Collaborated with cross-functional teams to resolve performance and security issues, integrating quality standards. Performed Quality Dashboard checks on financial data and ensured real-time delivery of financial reports within SLA. Mastered collecting and extracting financial data from periodic reports, ensuring accuracy over 5 years. Applied subject blocks, tags, and attributes to align financial data with original reports, ensuring precision.