MANOJ KUMAR K 8438991496
SQL / PL SQL DEVELOPER
manojkumar551496@[Link]
Summation Skills
SQL and PL/SQL Programming
3.5 years of professional experience as an SQL/PLSQL
developer. Expertise in database design and Database Design and Management
management, including data modeling and Data Warehousing
performance tuning.
Stored Procedures, Functions, and
Proficient in writing stored procedures, functions, and
triggers to implement business logic in databases. Packages
Strong knowledge of performance tuning and Triggers
optimization techniques for enhancing query
Performance Tuning and Optimization
performance and system efficiency.
Proficient in data analysis and reporting, providing Data Analysis and Reporting
actionable insights to stakeholders. Cross-Functional Collaboration
Experienced in collaborating with cross-functional Oracle Database Management
teams to understand and fulfill their data requirements.
Data Modeling
Knowledgeable in Oracle database management,
including administration tasks and ensuring data UNIX/Linux Operating Systems
integrity and security. Shell Scripting
Skilled in writing complex SQL queries for data
Agile Methodology
retrieval, manipulation, and analysis.
Experienced in database design and development, Graduation
ensuring efficient and scalable structures for data
Bachelor of Engineering(CS)
storage.
Anna University
Familiarity with UNIX/Linux operating systems and 2020(6.75 CGPA)
shell scripting for automation and task scheduling.
Strong understanding of Agile methodology and
working in iterative development cycles. Organization
Continuous learner, staying updated with the latest MOUNTPOINT TECHNOLOGIES
advancements in database technologies and PVT LTD
programming practices. Bangalore
Excellent problem-solving and troubleshooting skills for June 2020 - Present
resolving complex database issues.
Ongoing Project
E-COMMERCE
MOUNTPOINT TECHNOLOGIES PVT LTD
Jan 2022 -Till Date
[Link]
[Link] is an online retailer specializing in a wide range of luggage, bags, and travel
accessories. It offers an extensive selection of products from various brands, catering to the needs
of travelers and commuters alike.
On [Link], customers can browse through a diverse assortment of bags for different
purposes, including backpacks, handbags, briefcases, duffel bags, and luggage set
Roles and Responsibilities
Monitor and manage database performance in real time, proactively identifying and resolving
any issues to minimize downtimeand ensure optimalsystem performance.
Respond to and resolve database-related incidentsand outages promptly,following established
incident management processes and procedures.
Collaborate with system administrators and network teams to ensure smooth integration and
operation of databases withinthe overall IT infrastructure.
Conduct regular database health checks and system audits to identify areas for improvement,
implement corrective actions, and ensurecompliance with securityand regulatory standards.
Develop and maintain databasedocumentation, including data dictionaries, configuration guides,
and operational procedures, to ensureaccurate and up-to-date information is available to
stakeholders.
Collaborate with business stakeholders to gather and analyze requirements, propose database
solutions, and providetechnical guidance on data-related matters.
Perform data analysis and data profilingtasks to identifypatterns, trends, and anomalies,
assistingin business decision-making and troubleshooting data-related issues.
Design and implement database securitymeasures, including user access controls, encryption, and
auditing, to protect sensitivedata from unauthorized access or breaches.
Stay up to date with industry trends and best practices in database management, recommending
and implementing new technologies or techniques to improve efficiency and performance.
Assist in capacity planning and database scaling activities, analyzing usage patterns and growth
projections to ensure the database infrastructure can handle future requirements.
Project - 1
HEALTHCARE
MOUNTPOINT TECHNOLOGIES PVT LTD
June 2020 - Dec 2021
unum
Unum is a leading insurance company that specializes in employee benefits and financial
protection. The company provides a wide range of insurance products and services, including
disability insurance, life insurance, critical illness coverage, and dental insurance.
Unum primarily operates in the United States and the United Kingdom, serving millions of
individuals and businesses.
Roles and Responsibilities
Collaborate with cross-functional teams to understand their real-time data processing requirements
and translate them into efficient database solutions.
Design and develop real-time SQL databases that are capable of handling high volumes of data
and processing it in real-time.
Create robust and scalable data models that support fast and continuous data ingestion, ensuring
the database can handle the velocity of incoming data.
Optimize the real-time database schema to ensure consistency and efficient data processing for
real-time applications.
Write complex SQL queries, stored procedures, functions, and triggers to manipulate and process
real- time data effectively.
Implement real-time data quality checks to ensure data integrity and security, preventing issues
caused by erroneous or malicious data.
Monitor and optimize the performance of real-time SQL queries, indexes,and data models to
ensure fast data retrieval and processing.
Troubleshoot and resolve real-time database-related issues promptly, such as data ingestion
failures or performance bottlenecks, to minimizedowntime.
Analyze real-time data and generate real-time reports that provideimmediate insights for timely
decision- making.
Implement real-time data integration processes using tools like Informatica or other real-time data
streaming frameworks to facilitate seamlessdata flow.
Adhere to best practicesfor real-time data warehousing to meet businessrequirements and ensure
data consistency and availability.
Declaration
I hereby declare that the information stated above is true to the best of my knowledge and belief.
MANOJ KUMAR K