Software Programmer

• Jun 2023 - Present

DevOps/ Database developer

• Jan 2023 - Jun 2023

Work as a Database Developer at the Client Side DO&IT (JAIPUR). • Manage Oracle database. • Experience in performance tuning and query optimization • Working on Government project ‘SIPF(State Insurance Provident Fund) and handle its eco-system databases on Oracle and SQL Server(includes database associated storage connections, performance, back-ups, etc.) • Worked on numerous Store procedures, Triggers, Sequences, Schedulers. • Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes • Used to write stored procedures, wrote new stored procedures, modified existing ones, and tuned the such that they perform well Show less

Oracle Database Developer

• Jun 2022 - Jan 2023

Work As a Database Developer at the Client Side DO&IT (JAIPUR). • Manage SQL Server databases. • Tuning of Database for Fast Access. • Working on Government project ‘AADHAAR’ and handle its eco-system databases on Oracle and SQL Server(includes database associated storage connections, performance, back-ups, etc.) • Worked on numerous Store procedures, Triggers, Sequences, Schedulers. • Worked on Partitioning of table in oracle. • Displayed a High Level of Multitasking skills to meet up Business requirements. • Perform analytical, technical, and administrative work in planning, designing, and supporting new and existing database processes • Perform data loads and routine updates on an ongoing basis. • Used to write stored procedures, wrote new stored procedures, modified existing ones, and tuned the such that they perform well • Have good knowledge of ETL(SSIS) , Data profiling, data quality and cleanups for SSIS packages Show less

Technical Support Engineer

• Mar 2020 - Mar 2021

Work as a Database Support Engineer in ApplicateAI, Gurugram. • Working within defined change management process • Perform analytical, technical, and administrative work in planning, installing, designing, and supporting new and existing database processes • Develop strategic roadmaps for tools, content and reporting in order to drive continuous improvement • To assist and support departmental users in resolving issues, providing solutions, offering advice and technical solutions to departmental challenges • Working with processors to resolve data issues • Other duties as requested by management. Show less

Database Analyst

• Jan 2018 - Jun 2019

• Wrote SQL queries in MSSQL Server. • Perform data loads and routine updates on an ongoing basis. • Work with business analyst groups to ascertain their database reporting needs. • Installed, configured and maintained oracle databases on Linux environment. • Created Database as per requirements. • Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, Implemented scripts/tools to help rollout and manage Oracle in a global distributed environment. • Monitoring Database growth and space administration. • Frequent analysis of objects and schemas. • Served as the initial contact person for all SQL support queries. • Performed updates to the SQL system as assigned by management. • Collaborated with business support professionals to provide full system maintenance. Show less

Internship

• Jan 2016 - Aug 2016

• Performance tuning and optimization, query tuning, supported analysts to help identity SQL issues. • Best practices document creation for developers and administrators. Support development activities in writing and assisting developers in complex SQL queries and procedures. • Writing and assisting developers in complex SQL queries and procedures. • Performance tuning and optimization, query tuning, supported analysts to help identity SQL issues. • Best practices document creation for developers and administrators. Support development activities in writing and assisting developers in complex SQL queries and procedures. • Writing and assisting developers in complex SQL queries and procedures.