Jitendra Kumar Singh Email & Phone Number

Pune, Maharashtra, India

• Worked on large production databases, performing various DBA roles across a multitude of platforms (LINUX and Windows) in production, development and testing environments. • Experienced in PostgreSQL Community and Enterprise Edition version 9.6 to 13, CPU patches, Database Upgrades from 9.6 to 13, Migration, Backup, Recovery, Security.• Experienced in migrating from on Premise Postgresql, MySQL,SQL Server Databases to RDS.• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, performance tuning and data integrity.• Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements. SQL reviews.• Evaluates and recommends the purchase of AWS RDS instance based on requirements like class size.• Experience in Performance Monitoring and Tuning of Database and SQL by optimising postgresql.conf, Parameter group, Explain Plan.• Setting up alerts to Slack from New Relic in case of high CPU Utilisation, Low memory, IOPs etc.• Managing roles and permissions using SQL scripts, Teleport, Ansible.• Used utilities like pg_dump, pg_restore, psql, pg_repack(to address bloat in tables).• Responsible for monitoring environments using monitoring tool viz. Datadog, New relic and other supporting tools like AWS logs and pgBadger as a log analyser.• Increased database performance by utilising MySQL config changes, multiple instances and by upgrading hardware. schema and Percona toolkit to identify redundant and unused indexes.• Utilised performance New Relic to monitor database and find out slow queries to tune further.• Maintaining documentation and standards for Database.• Scheduling Point in time recovery (PITR) to the development environment for proper product testing.• Work with developers and analysts to support development efforts.

Pune Area, India

• Managed team of developers and analysts in an Agile Software Development process which includes daily standups, presentations to clients, reviews of code and SQL changes.• Monitoring the alerts triggerd in Datadog like for free storage, high CPU, IOP burst etc.• DB code commit in repository, creating PRs in github, jenkins jobs.• Requests from support/developers/product like review/performance test the SQL query, cleanup tasks, executing queries across all DBs in the project.• Managing user's roles and permissions.• Maintenance of RDS instances. • Designed and upgraded web applications to improve usability, support, and maintenance of the application.• Experience in writing database objects (Stored Procedures, Functions, and Triggers).• Provided database solutions for application development.• Perform database administration activities such as storage management, backup, recovery, and performance tuning.• Conduct code, design, and process reviews, including code sampling design reviews, code profiling, unit test reviews, and process adherence for source code control and builds.• Mentor junior-level developers on Software development process, improved technical expertise to handle large scale projects.• Coordinated QA and development efforts. Facilitated QA engineer in the determination of test methods for each developed component.• Worked closely with the customer throughout the development cycle ensuring the proposed design met customer requirements.

Pune Area, India

• Worked in technologies like Asp.net MVC, Python, AngularJS 7 and Node.js. Have good experience in SQL Server, MySQL and MongoDB. • Widely used AngularJS UI-bootstrap components with ASP.NET MVC.• Expertise in creating complex SQL queries, Stored Procedures, Indexes, Views, Cursors, Triggers, and User-Defined Functions.• Maintained a high degree of competency across the Microsoft Application Platform, focusing on .NET Framework and Microsoft .• Experience in writing database objects (Stored Procedures, Functions, and Triggers).• Strong experience in writing LINQ to SQL 2005/2008 queries.• Setup and managed the web application in IIS.• Cold Fusion 11 and 16 with FuseBox and Cold Spring framework.• Develop software and systems on test driven development and continuous integration practices.• Strong understanding of how to maximize SQL Server application scalability, performance, recoverability, and maintainability.• Having experience in Agile Methodologies, Scrum stories, and sprints experience in a Python based environment. • Hands-on working with Python frameworks, SVN, Git, JIRA, Amazon EC2/S3 in some of the internal projects.• Created complex SQL queries, Stored Procedures, Indexes, Views, Cursors, Triggers, and User Defined Functions.

Jaipur Area, India

• Worked in Microsoft technologies like Asp.net MVC and SQL Server 2012 with CSS, XML, Java Script, JQuery, AJAX, Bootstrap, Rest API .• Creating complex SQL queries, Stored Procedures, Indexes, Views, Cursors, Triggers, and User Defined Functions in SQL Server 2012. • Created database objects like Stored Procedures, Functions, and Triggers.• Written LINQ to SQL 2005/2008 queries and Entity Framework.• Communicated with the clients to understand the project requirements.• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

Jaipur Area, India

• Worked in MySQL to monitor the database health for the OmniFin (finance) project, performed EOD BOD tasks on a daily basis, and patched the DB as per the requirement or in case of any errors.• Designing and implementing backup and recovery strategies to ensure our data is highly available, secure, and recoverable.• Created, modified, and updated packages, stored procedures and database triggers.• Performed tuning, backups, and troubleshooting of MySQL DB.• Worked in technologies like Asp.net Web Forms, HTML, CSS, XML, JavaScript, JQuery, AJAX, Bootstrap to create in-house web projects.• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing, and Maintenance.

Ranchi Area, India

• Worked in technologies like Asp.net Web Forms,HTML, CSS, XML and Java Script to create in-house website• Written database objects (Stored Procedures, Functions, and Triggers) for the projects.• Provided web development training to the trainees.

Master’S Degree, Mca, A

Activities and Societies: Participated in Intra College Co-Curricular activities like debate,games and project development in my Post.

Bachelor’S Degree, Computer And Information Sciences, A