Database Consultant (Oracle, SQL Server)
Technovalley Softwares Pvt Ltd
Total years of experience :6 years, 7 Months
• Designing Database, Installation, Configuration : Processing systems,
database schemas and storage scalable, normalized and aligned with
business requirements.
• Database management system (DBMS) : (Oracle, MS SQL Server,
MySQL, PostgresSQL) with deep understanding of each.
• Availability Check and management: Proficient in implementing failover
and disaster recovery for highly available and scalable databases.Plan
for Data continuity during disasters.
• Operating Systems and Cloud : Experience in Linux (CentOS, Ubuntu,
Redhat) and Windows Environments, OCI
• Establish and maintain backup and recovery policies and procedures to
ensure data preservation.
• Security Implementation : User Security measures using encryption,
protocols, access controls with roles and privileges with support of
regulations.
• Resource allocation: Pre-calculation of resource requirement and allocation
using capacity planning.
• Plan and implement upgrades of database management system software
to enhance database performance.
• Architecture Documentation : maintain clear, readable documentations
of the design and standards and maintain reports and logs.
• Performance Optimization : Tuning, Optimizing, monitoring and troubleshooting.
Identify and solve bottlenecks in TBs of Data.
• Creating audits, indexes and job scheduling
• Support, Training and consultation : Provision of Training, technical help
, Certification support for co-employees.
• Gathering Requirements: gathering and documenting business requirements for new projects, conducting interviews with stakeholders and documenting requirements.
• Analyzing Data: work with datasets to identify trends, forecast future performance, and make data-driven recommendations to improve business processes or strategies.
• Facilitating Communication: Effective communication, facilitate communication between stakeholders, project managers, and development teams, build clear understanding of project objectives, timelines, and deliverables.
• Solution Design: collaborate with technical teams to design solutions that meet business requirements. This may involve creating user stories or process flow diagrams.
• Testing and Validation: participate in testing and validation activities to ensure that it meets quality standards.
• Continuous Improvement: Drive continuous improvement within organization. Monitoring key performance indicators (KPIs), identifying areas for optimization.
• Subject Matter Expertise: Develop deep expertise in specific domains, staying updated on industry trends, regulations, and best practices.
Awards: Topper ( 90 % ) , Highest percentage ( 97 % ) for semester IV Completed project based on protein drug relationship using big data technologies.