Sitaram Sharma

Senior Database Developer

Times Internet Ltd•  June 2020 - Present

Writing stored procedures, triggers, cursors, functions and modifying existing one as per requirements. Writing and deploying the SQL patches in the production environment. Perform the indexing, re-indexing and query rewriting or optimization of slow queries/ low performance queries in Application. Proactively participate in schema changes , code reviews and query optimization. Keep a check on slow queries and database server stats and respond proactively in case of any alert. Writing complex queries for Analytics and Business Intelligence. Design and development of the Jasper report and their deployment. Ensuring the performance of the queries before pushing to production environments. Provide the support on holidays and weekends in case of any production issue arises. Collaborate with the product managers and support teams to understand the client requirements Troubleshoot critical performance bottlenecks for MySQL databases before it causes downtime. Review and assess the impact of database schema design, topology changes prior to their implementation.

Senior Database Develoepr

Passion Gaming Pvt Ltd•  October 2019 - June 2020

Writing stored procedures, triggers, cursors, functions and modifying existing one as per requirements. Also perform DML, DDL, TCL, DCL Operations on Production and non- production DB environments. Mentor on database standards and best practices to junior developer and internal users. Identify and assist in improving Infrastructure tools/services with automation and process enhancements. Maintain availability, reliability, security and data integrity standards across database hosting environments. Ensure databases are highly scalable and deploy able using configuration tools. Stay updated of new technologies and of changes in technologies that affect back-end and front-end web development Troubleshoot critical production and testing environments. Address performance and tuning issues whenever and wherever they occur. Identify recurring issues and collaborate with other teams on resolution plans.

Senior Database Developer

Baazi Games•  September 2018 - October 2019

Writing and optimizing in-application SQL statements and stored procedures. Perform DML, DDL, TCL, DCL Operations. Driving code reviews, design reviews, architecture discussions. Setting up best practices to help the team achieve the above and constantly thinking about improving technology use are your responsibilities. Driving the adoption of these best practices around coding, quality, performance in your team, and influence them for the entire organization are also expectations from you. Drive the implementation of long-term technology vision for your product & team. Drive a culture of curiosity and active debate around technology. Experiment with new & relevant technologies, and drive adoption while measuring on the impact. Writing and optimizing SQL Queries, procedure, functions, views. Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support.

Software Engineer III (BI)

Finxera•  August 2017 - August 2018

Writing simple to complicated & efficient MYSQL queries for real time reporting. Assist in designing and developing the data warehousing. Writing queries for the reporting from the Data Warehousing. Creating view, stored procedure & function for the Dimensional Modeling. Develop a dashboard on SiSense for the different stakeholders. Perform query optimized for the performance enhancement. Prepare documentation (DLD & HLD) regarding database design and change management tasks as per requirements. Diagnose database performance issues using performance monitors and various tuning techniques. Identify areas of opportunity and recommend appropriate improvement suggestions. Handle database procedures such as data migration etc. Demonstrated experience with relational database physical design. Experience with relational database performance tuning & capacity planning especially on MySQL based environments Proficient in writing and optimizing SQL statements

SQL Developer

Biz2Credit Info Solution Pvt. Ltd•  June 2015 - August 2017

Writing SQL queries for ad hoc & BI reporting. Ensure data integrity and quality and availability of data in the database system. Collaborate with other teams QA and development to modify code and test changes. Maintain all databases required for development, testing and 24x7 production usage. Perform ongoing tuning of database instances and their related SQL based queries. Edit database objects as required to improve performance and ensure maximum uptime. Support a large number of concurrent users. Engineer's build solutions to address availability and data durability. Guarantee service uptime and build innovative solutions to reduce component failure. Build test suites to ensure the system boundaries are tested. Build innovative monitoring systems that monitors the Computing infrastructure