Omkar R Email & Phone Number

🌟 Experienced Data Engineer | Python Enthusiast | Database Guru 🌟With a strong background in Python programming and database management, I specialize in making data work smarter, not harder. My expertise spans across SQL Server, PostgreSQL, and MySQL, and I love diving into ETL processes, database administration, and performance optimization.What I Bring to the Table:🔧 Database Wizardry: Developed a centralized monitoring solution for SQL Server 2017, MySQL, and PostgreSQL servers, efficiently tracking key metrics. Led a successful SQL Server separation and upgrade project, implementing the BYOL model, and managed server migrations, SSIS packages, databases, and logins.🐍 Python Prodigy: Built Python programs to automate data transactions, ensuring data integrity and consistency. Designed Python interfaces for seamless data loading, automated report creation, and engineered robust ETL pipelines handling data extraction, transformation, and loading from diverse sources like AWS S3 Buckets, Redshift, SQL Servers, and AWS Lambda.⚡ Performance Optimizer: Enhanced data protection with strategic backup methodologies and secure S3 transfers. Implemented automated monitoring alarms within ETL pipelines to ensure immediate issue notification and resolution.I thrive in collaborative environments and am passionate about implementing new technologies to solve complex problems. Whether it's optimizing database performance or developing sophisticated data pipelines, I'm all about leveraging my skills to deliver innovative solutions.Tech Stack: Python, PowerShell, HTML, Java, SQL Server, PostgreSQL, MySQL, SSIS, IIS Server, T-SQL, ETL, Performance Tuning, Dbeaver, SSMS, AWS, VS Code, Visual Studio, PyCharm, MySQL WorkBench, pgAdmin.When I'm not immersed in data, you can find me biking through scenic routes 🚴‍♂️, traveling to new destinations ✈️, or indulging in painting 🎨 – hobbies that fuel my creativity and problem-solving skills.Let's connect and explore how we can leverage data for impactful solutions!

• 

  Saptagiri College Of Engineering

  Information Technology