Find Jobs
Hire Freelancers

DB Architect:

₹75000-150000 INR

Closed
Posted 2 months ago

₹75000-150000 INR

Paid on delivery
Requirement is very clear I need DB Architect: Start Date – Immediate Work Mode – Remote Work Hours : 11.30 AM to 8.30 PM ( May stretch depending on deliverables) Exp: 12 YRS (Minimum) ü Proven expert at writing SQL code with at least 10 years of experience. ü Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü Proven expert in Modeling enterprise-grade databases and architecture. Very strong at Entity Relationship. ü 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. ü 3+ years of proven expert in working with large Data Warehouse. ü Must have ability to conceptualize ideas and data streams to schemas. ü Expert at ETL transformations using SSIS. ü Good knowledge of analytics tool like AWS Quick Sight. ü 4+ Years of proven experience working with high volume multi-client SAAS solutions. ü Must be expert at communicating technical issues to non-business users. ü Must have business-oriented thought process. ü Proven expert at setting up standards and coding process ü Must have worked with Source Code Control tools like Bitbucket/GIT. ü Must have done code reviews for the team. Desirable: Ø Prior experience working in utility domain. Ø Any DB/DW certifications from Microsoft or equivalent. Ø Any knowledge of Data Science and Statistics is a plus Ø Tools used: MySQL, AWS – DW Ø PostgreSQL Let me know if you have this profile
Project ID: 37788897

About the project

15 proposals
Remote project
Active 26 days ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average ₹128,000 INR for this job
User Avatar
Hi. I am vinay having more then 13 yrs of experience in database administration Currenrly i am working as data architect in MNC company I have vast experience in datawarehouse system which have TB of data and done migration and performance tunning on it. Currently working on AWS technoloy where we are bringing data from different source using DMs and EMR , further after computation sending data in postgres and redhsift datawearehouse system. I am SQL expert certified Oracle certified Aws solution arch certified
₹112,500 INR in 7 days
4.6 (57 reviews)
5.4
5.4
User Avatar
As an experienced DB Architect, I'd be an excellent fit for your project. Having developed databases for over a decade, I satisfy the 12 years of experience you've stated. In particular, my 5+ years' work with large data with transactions similar to your order of magnitude equips me with unique insights into optimizing performance - balancing tasks like tuning, managing deadlocks, and utilizing triggers. What sets me apart is my ability to not just understand your requirements but think proactively to develop models that are tailor-made for high-volume, multi-client SAAS solutions in various sectors including utility domains - a valuable plus point you've mentioned. I am also adept at using leading tools like MySQL, AWS-DW, PostgreSQL in conjunction with ETL transformations using SSIS to optimize data management. My knowledge also extends seamlessly from the database field into the realm of analytics - fortifying your project's foundations. It isn't only about technical proficiency but about timely communication and syncing with non-business users as well. In every project, I set up and enforce rigorous coding standards ensuring the smooth functioning of every element down to the code level. That combined with my experience in working with source code control tools like Bitbucket/GIT enables me to provide efficient reviews not just for individual performance but for team collaboration as well. Let's Optimize your DB as you optimize your business!
₹75,000 INR in 5 days
2.2 (4 reviews)
4.7
4.7
User Avatar
Given my broad, 7+ years of experience as a Full-Stack Developer and Solution Architect, I am confident in my ability to fulfill all the requirements of your DB Architect role with proficiency. I know the gravity of having a robust and efficient database system, especially when handling large data size and multiple clients, and my experience in writing SQL code and working with Large Data Warehouses demonstrates this perfectly. Furthermore, I have demonstrated expertise in modelling enterprise-grade databases with an exceptional understanding of Entity Relationship and transactional processes. My extensive background in performance tuning, Dead Lock management, and setting up industry-standard coding processes would be invaluable to your project. Finally, I have hands-on experience using MySQL, AWS - DW, and PostgreSQL for working with tera or petabytes worth of data transfers. Additionally, my knowledge of ETL transformations using SSIS and analytics tool like AWS Quick Sight will complement your project effectively. My past successes include rationalizing business operations while simultaneously driving improved revenue growth - quintessential skills that make me an ideal candidate for your team. Let's commence our project together! An individual who is professional,capable,timeous with a proven tract record ,Recruit me. I look forward to making an impact on your business operations as we transform your digital aspirations into reality.
₹112,500 INR in 7 days
4.9 (4 reviews)
1.9
1.9
User Avatar
As a seasoned database architect with over twelve years of experience, including five-plus years in modeling loosely coupled databases to manage massive volumes of data, I possess the skills and expertise you require for your project. My forte lies in not just handling large-scale databases but also optimizing performance through expert SQL coding and robust ER methodologies. Throughout my career, I've honed my abilities to model enterprise-grade databases crucial to handling transactions of the magnitude you mentioned. Furthermore, I have comprehensive knowledge in key areas like ETL transformation using SSIS and high-volume multi-client SAAS solutions, both necessary for the success of your project. Working in tandem with these proficiencies, I am skilled at utilizing analytics tools like AWS Quick Sight to extract meaningful insights from large datasets. Lastly, my commitment towards setting up coding standards, performing thorough code reviews, and my expertise working with Source Code Control tools is pivotal in ensuring smooth coordination within teams - a factor that ¬definitely plays a role when working remotely. Choosing me for this project would not only guarantee a seamless delivery within an exceptionally tight work schedule but also bring on board a professional who understands the intricacies of constructing robust architectures capable of storing colossal data while focusing on successful business outcomes.
₹112,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
13+ years of experience in ORACLE Database Administration on Production and Development Databases. More than 4 years of experience in MYSQL, MariaDB and PostgreSQL Database administration.
₹112,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have competence in this work and I have the ability to complete the work in a short time. I have previous work in all branches of the field of data entry, and I am honored to work with you. Thank you.
₹112,500 INR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey there! I came across your post, and it resonated with my experience and skill set. I'm Dipak, a Fullstack Developer with over 7 years in the industry, specializing in creating interactive applications that redefine user experiences. I bring a wealth of expertise in designing and constructing robust web platforms with scalable architectures, leveraging my strong technical and logical skills. My proficiency spans HTML, CSS, Javascript, jQuery, MySQL, and Mongo DB, with a focus on frameworks such as React JS, Angular JS, Node JS, and Type Script. I've successfully integrated Payment Gateways, SMS Gateways, and implemented Socket-based programming across various industries, including eCommerce, Food Delivery, and Chat Messenger platforms. I've optimized microservices architecture for scalability, proficiently used Docker for seamless deployment, and managed AWS services like EC2, S3, Lambda, RDS, and ELB. Why Choose Me? I thrive on transforming complex ideas into user-friendly applications. Whether you want to enhance your web presence, boost application performance, or streamline DevOps processes, I'm here to turn your vision into reality. Let's collaborate and create something extraordinary. Feel free to reach out to discuss your project requirements or explore how I can contribute to your development. Looking forward to the opportunity!
₹112,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As an experienced web and app developer with a passion for demanding tasks, I am thrilled about the opportunity to bring my skills to your project as a DB Architect. Over my 12-year journey in the field, I have fine-tuned my expertise in SQL code, modeled enterprise-grade databases and worked extensively with large-scale data. Notably, for over 5 years I have managed transactions on datasets boasting 10+ million records and up to petabytes sizes with ease. A key strength of mine is my ability to communicate intricate technical concepts to non-technical users - a quality asserted by your requirement. In line with this, I have always conceptualized data streams into schemas, calming complexity into simple solutions. Plus, my experience using tools like AWS Quick Sight and hands-on knowledge of data analytics will contribute significantly towards capturing utility domain-related insights from your project's data. Furthermore, my dedication towards setting up standards and coding processes aligns well with your technical needs. My familiarity with source code control tools like Bitbucket/GIT along with code reviewing experience will ensure efficiency, reliability and robustness throughout our collaboration. After all, as I understand from the tone of this description that you are not just looking for any skilled DB Architect but someone who can handle complex data operations in SAAS solutions stably and expertly - that's me!
₹112,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I'm Soni, an EDB PostgreSQL Certified Professional (highest level of PostgreSQL Certification from the most reputable PostgreSQL Certification provider), 11+ years experience in computer Industry, mostly spend my career as PostgreSQL DBA and SQL Developer. I have experience in designing database, know database normalization, table and column constraints, primary keys and foreign keys, trigger functions, views, materialized views, indexing strategy, etc. I also have much experience with producing reports on sql databases, know advanced query technique, query execution plan and can fine tune query for performance. I have also ever been involved in data analytics project using Looker and AWS Redshift (based on PostgreSQL 8.0) around 4 months, redesign table structure, and creating queries, including involved in migrating SQL Server database to PostgreSQL. I've been in projects regarding SQL Developer. I have been working as PostgreSQL DBA on USIC since January 2014, here I have been also helping with query tuning. I have been managing about 6 PostgreSQL DB servers, including production DB (sized around 5 TB, 32 core, 145 GB RAM), slony replica, streaming replica, GIS DB, monitoring DB, and developer DB. Here I have done with performance tuning, production DB migration, and also PostgreSQL datacenter migration (complete migration of all PostgreSQL DB servers), routine maintenance, troubleshooting, and daily DBA task.
₹100,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
With over a decade of experience in designing and managing complex systems on the AWS platform, I am confident that my skills make me an excellent fit for the DB Architect role you are seeking to fill. Not only have I gained comprehensive expertise in SQL over the years, but my abilities extend to performance tuning, transaction management, entity relationship modeling, and ETL transformations using SSIS - all essential components of successful database architecture. In particular, I have hands-on experience working with large data sets similar to yours, harnessing transactions ranging from 5-10 million records. Moreover, as a seasoned AWS DevOps Engineer with migration project experience from on-premises data centers to the cloud, I can ensure that your data management system is not only scalable and secure but also optimally leverages the AWS technologies you use (such as MySQL and AWS DW). My excellence in utilizing collaboration tools like BitBucket/GIT will further facilitate seamless code reviews and guarantee that industry-approved standards and processes are established for your database architecture. Finally, my certifications stand as testaments to my ongoing commitment to professional growth. I hold certifications from AWS, Kubernetes, and Red Hat among others which speak to my extensive knowledge and understanding of cutting-edge technologies. Regards Prateek.
₹200,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am Manisa Mund, I represent a team of SQL, MSBI and Data experts having 16+ years of industry experience who worked extensively in the field of Business Intelligence, Database Development, Data warehousing, Data Lake and Lake House in different MNCs. We have worked in different domains like: Banking, Finance, Healthcare, Energy, Retail and HR. We are data engineers/analysts who have delivered multiple mid/large size projects by giving our best to deliver the projects with high quality ahead of schedule. I have come across your job requirement for DB Architect and we are excited to pursue the opportunity with you having an extensive background on the same with a commitment to deliver high quality products by giving the best. Kindly let me know if we can connect to discuss in detail via zoom or any other online mode to take this forward, also please feel free to call me or whatsapp on my India number +91-8197178780. Looking forward for working with you! Thanks & Regards, Manisa
₹112,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
visakhapatnam, India
5.0
1
Payment method verified
Member since Nov 1, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.