Hire the best Database Programmers

Check out Database Programmers with the skills you need for your next job.
Clients rate Database Programmers
Rating is 4.8 out of 5.
4.8/5
based on 898 client reviews
  • $150 hourly
    ✅ I'm the highest-rated and highest-earning SQL Server DBA freelancer on Upwork, with more than 100 5-star reviews and overwhelmingly positive feedback. I've solved customer-facing SQL Server bottlenecks and made massive performance improvements for Fortune 500 companies and well-known organizations, including the following to illustrate some of them: ✅ Oracle Cerner (Fortune 500 Company) ✅ CBRE (Fortune 500 Company) ✅ Stanford University ✅ Alltech Inc. (~2.5 Billion Estimated Revenue per Year) ✅ Viega (~150 Million Estimated Revenue per Year) I was featured as the top freelancer in the IT and networking category on Upwork, which has over 116,000 Freelancers in the category (refer to the portfolio section of my profile for details). ⭐ Here's what I can bring to your project ⭐ ✅ Top-notch experience in all versions of SQL Server (2000 - 2022) and cloud platforms ✅ Extensive experience working with large enterprise transactional databases ✅ Expert understanding of data security best practices when working with PII and PHI data ✅ Ability to quickly diagnose SQL performance issues and identify query pain points ✅ Expert ability in designing ETL processes for data warehouses and BI databases ✅ 24/7 ultra-reliable communication: you will always be aware of the project status ✅ Someone who cares about helping you succeed and bringing value to your business ⭐ Why you should choose me over other freelancers ⭐ ✅ Client Reviews: I focus on providing value to all of my clients and earning their TRUST. ✅ Over-Delivering: this is core to my work as a freelancer. My focus is on giving more than what I expect to receive. I take pride in leaving all of my clients saying "WOW" ✅ Responsiveness: being extremely responsive and keeping all lines of communication readily open with my clients. ✅ Resilience: reach out to any of my current or former clients and ask them about my resilience. For any issue that my clients face, I attack them and find a solution. ✅ Kindness: one of the main aspects of my life that I implement in every facet. Treating everyone with respect, understanding all situations with empathy, and genuinely wanting to improve my client's situations. 🏆 Reviews and feedback from high-profile clients 🏆 The client reviews below (also in my work history section) describe the quality of work and value that you can expect from working with me. ⭐⭐⭐⭐⭐ "I've been very impressed working with Josh on a SQL Server DBA project for Stanford University. He took seriously the concerns we had when handling HIPPA-related data. He's professional, detail-minded, and eager to assist other technologists. I definitely will be reaching out to Josh when I need freelance work in the future." - Noah Abrahamson, Stanford University ⭐⭐⭐⭐⭐ "We were in need of a SQL Server DBA to assist us in the upgrade of our CRM and Josh was able to come in and assist us and performed beyond our expectations. He worked on the schedule we needed him to and we are now keeping him on stand-by for future SQL work. If we could give Josh 10 stars we would, he knows what he is doing and genuinely wanted to help us get our migration completed successfully." - Adam Siegel, CBRE ⭐⭐⭐⭐⭐ "Josh is a rockstar. We've used him on a number of projects and thought it was time to close this one and give him the 5-stars that he deserves. He's sliced through everything we've asked of him...replication, high availability, fixing previous DBA sins, optimizing queries and databases, backups, cloud migrations, you name it. Nailed every bit of it." - Anthony Presley, Truno
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Database Management System
    SQL Server Reporting Services
    SQL Server Integration Services
    Database
    Business Intelligence
    Microsoft Azure SQL Database
    Microsoft SQL Server Programming
    Microsoft SQL Server Administration
    Database Security
    Database Optimization
    SQL
    Database Administration
    Database Maintenance
    Performance Optimization
    Microsoft SQL Server
  • $95 hourly
    I love to create and maintain Microsoft Office solutions with the intent to increase interoffice efficiency by utilizing existing technology and customer input to reduce overall cost for the customer. Particular areas of expertise include SQL Server, Microsoft Access, and Visual Basic for Applications (VBA), especially with Microsoft Excel and Access. I have over 30 years of experience with Microsoft Office and including Access and Excel and the VBA language. I have over 20 years of experience with the SQL language. I also have over a decade of experience with social media management and classic web technologies such as ASP classic, HTML, and JavaScript as well as Visual Basic. I also have two decades of training as an educator in technological fields, end user training, and K-12 learning. I can create training videos for technical training as well as training videos for the custom applications that I create. I have worked with a wide spectrum of clients, including those from manufacturing, quality control, distribution, food, pharmaceuticals, health care, financial, media, education, real estate, and service organizations. I am able to implement the entire technical solution from the initial specifications from the customer to the final implementation with training. Clients I have worked with include Avery Dennison, DRS Power Technology, North Central Mass Chamber of Commerce, Johnny Appleseed Visitor Center, City of Westhampton, Standard Register Corporation, Hillshire Farms & Kahn’s, Square D Company, Gallatin Steel, Dwyer Concrete Lifting, Procter & Gamble, Gibson Greetings, H.P. Hood Inc., Skyline Chili, Good Samaritan Hospital, Cincinnati Financial Corporation, Great American Insurance, American Annuity Group, Huff Realty, Q102 Radio Station, Dayton Public Schools, Electronic Classroom of Tomorrow (eCot), IBM Global Services, Hardware Deployment for GE Capital, Xerox Connect, Xerox, City of Louisville, MAX Technical Training, HCCM CHEC and MACH homeschooling organizations, BBC and HBC churches, Worcester Polytechnic Institute, and The University of Cincinnati.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Visual Basic for Applications
    Database Design
    Automation
    Microsoft Excel
    Microsoft Access Programming
    Microsoft Access
    Microsoft SQL Server
  • $125 hourly
    I have been doing software development for over 20 years. I also have a background in Business Analysis and Data Architecture. I am familiar with the entire software development life cycle and can follow a project from gathering requirements through development, testing and support. I am one of those developers that actually enjoys doing the documentation, I find it makes the final project easier to support. I am fluent in MS Access (All versions), Excel, VBA, VB.Net, Sql Server T.-Sql, Oracle PLSql as well as some more obscure languages. For the last 20 years or so, I have been working as a Developer, Business Analyst and Data Architect, usually in the same role. I graduated from Augsburg College in Minnesota with a degree in Computer Science. I have also been through the Oracle Data Architecture course.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Visual Basic
    Visual Basic for Applications
    Microsoft SQL Server
    Microsoft SQL Server Programming
    Microsoft Access Programming
    Oracle PLSQL
    Microsoft Excel
    SQL Programming
  • $55 hourly
    25+ years experience with MS Access design and development, SQL, Excel, data conversions, integration with Peachtree, Quickbooks and Sage. Developed projects in a range of business environments including Manufacturing, Process Handling/Control, BarCoding, Association Management, Heat Treating, Payroll, Time Card Processing, Web Site Design/Management, Data interface between in-house or web-based systems. Services offered include: - extensive analysis of manual procedures - analysis of industry requirements including ISO conformity and certification - analysis of hardware/software requirements - Design of custom software - Upgrades to existing software - Modifications to existing software - Porting data to or from different formats - Installation and implementation of completed systems - Training of shop floor, office, and management personnel - Customer support via phone, internet, or on site, when location permits. Proficiencies include: - Strong knowledge of MS Access 95 – 2016, Excel, and SQL - Extensive VBA (Visual Basic) Coding, VBA Scripting - Integration of data into Quickbooks, Peachtree, Sage 50 - Data export/import to or from web-based, mySQL or in-house databases. - Graphical representation of data using MS Access or Excel - Automation of manual processes - Dashboard creation, data collection, report generation - ISO conformity and certification. - E-commerce packages – installations, upgrades, customizations - Zen Cart web-design, data conversions, installation of plugins - Creation of end user documentation - Training and seminar classes attended by 1 to 20 plus. - Ease in communication with end users, technicians and management. Please note: the data displayed within portfolios screen-shots is completely fictitious and does not represent any specific person or company. Many forms and reports are proprietary and may not be available here. If you have a specific request, please contact me and I will be happy to assist you.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Visual Basic for Applications
    Data Analysis
    Microsoft Access Programming
    Visual Basic
    Microsoft Excel
    Database Administration
    Database Design
    Microsoft Access
    SQL
  • $80 hourly
    Senior Expert Access/Excel/VBA/SQL Server Developer/Dot.Net Web/MVC/EF/Azure, Troubleshooter, Optimizer, UI Enhancements, etc... I have 34+ years of experience working with Access, Excel, and then integrating them into harmonious fluid applications, whether it be for the Desktop, or on a WAN. I have developed using every version of Microsoft Office and SQL Server since inception. I specialize in Finance and Manufacturing, including CRM, Inventory and Work Order Management, Job Costing, AR, AP, Purchasing and Sales Forecast Automation, etc. I feel those environments are structurally synonymous with most any other scenario. My current experience involves Loan Origination and Servicing. Working in Finance and Manufacturing, I could not afford to make mistakes. My work ethic developed beginning with my father and being in the Military, in the field of Aviation, where a tiny mistake could cost lives. I am detail oriented with an eye for efficient user friendly complete, from the ground up, to the most custom application imaginable. I have proven complex methods that are far more efficient than the conventional developer, regardless of how well they score on a test; I am the person that goes the extra mile(s) to adhere to the rules of development while maintaining a fluid user friendly interface. I develop from the ground up or customize pre-existing systems. Whether I am developing in Access or Excel, I always structure the data for easy possible future migration, regardless of the interface. An interface can be easily replicated, but carelessly stored data can be very costly. My interfaces are fluid and user friendly. They utilize as much as the available functionality permits, by using Drop-down and List Boxes, and applying Event Code to link to related data without having to return to a menu or dashboard. I am extremely fluent in VBA, using various Object Models, i.e. Access, Excel, DAO, ADO, SQL, Class Modules, SQL Server T-SQL, Stored Procedures and Custom Functions and Triggers, SSMS, SSRS, and SSIS, etc. I write code that a lay person can understand. Where this is not possible, I comment the purpose and flow of the Code. I do not implement limitations, as a lot of developers do, that force the Client to always call on the developer every time a little change is needed. I develop in such a way that considers future expansion. The only time I would ever need to be called upon is to implement new functionality. I prefer to teach Clients the basics so that they can make the subtle physical design changes to the interface that they want, without destroying the integrity of the system. Because I follow the rules of development, the system is straight forward and easily understood.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Transact-SQL
    Database Development
    Office 365
    Microsoft Azure SQL Database
    Microsoft Azure
    Stored Procedure Development
    Visual Basic for Applications
    Microsoft SQL Server Programming
    Database Architecture
    Microsoft SQL Server
    Microsoft Excel
    Database Design
    Microsoft Access Programming
    Microsoft Access
    SQL
  • $45 hourly
    My experience includes Powerbuilder (PB) v8 thru PB2019 working with PB Classic, PFC. Please take a moment to view my Portfolio below. It demonstrates window design, Application Design, PB Scripting, and Database skills. The application has been deployed and the EXE has been tested. I have written test plans, Experience with a variety of version control products. Have worked with Upwork and also the Time Tracker. With this background and my extensive working experience, I am able to be productive immediately. A Verified Billing Method is appreciated. Application experience includes working with the 3rd Party PB application, DIAMOND(R) Enterprise System [Health Care]. Industry Experience: Health Insurance, Manufacturing, Mortgage, Compliance Reporting, Employee Surveillance I do not own a version of the Powerbuilder Software. All remote employment has been completed using a remote connection. Ideally, the Client should have all of the Application PBL’s. Projects Available for but not limited to: New Development, Enhancements, The review of an existing application and to document the functionality, Existing Application, determine functionality, Comment Scripts, Assist Business Analysts in finding the functionality for proposed enhancements, Application Migration. Home Office is complete with Audio/Video for meetings and collaboration. Work experience using MS Teams, Webex and Zoom. Thank you for your time. Looking forward to helping you. My goal is to provide excellent work in a timely fashion at a reasonable rate. Not just done, done right. I am a lifelong resident of Pennsylvania, USA.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Sybase Programming
    Data Entry
    PowerBuilder
    SQL
  • $125 hourly
    ✅ TOP RATED Consultant on UpWork | *100% Client Recommendation Score* My name is Ryan, and I am one of Upwork's highest rated SQL Server DBA (Database Administrator) and Developers. I've worked with numerous companies on projects including database administration, optimization, performance tuning, automation, and SQL programming. If you are having a database issue, you have come to the right place for help. Unlike other database professionals, I am able to effectively communicate to understand your business needs and technical architecture in order to meet your deliverables. I keep my high Job Success Score and Five-Star Feedback rating by accepting only the jobs I know myself to be the best person for. If I'm not completely confident in delivering you the perfect job, I'll let you know and steer you in the right direction. Thank you for reading this far, and I look forward to discussing your project together. Technical Skills: Twelve (12) years of experience in SQL Server versions from 2005-2022, and over 7 years working with Azure and AWS. Certifications: • MCSE: Microsoft SQL Server 2016/2012 Systems Expert Data Platform • MCSA: Microsoft SQL Server 2016/2012 Certified Solutions Associate • MCITP: Microsoft SQL Server 2008 Database Administrator • MCITP: Microsoft SQL Server 2008 Business Intelligence Developer • MCSA: Microsoft SQL Server 2008 Certified Solutions Associate
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Database Architecture
    Database Maintenance
    SQL Programming
    Microsoft Azure
    Amazon RDS
    Database Management
    Microsoft SQL SSAS
    Microsoft SQL Server Reporting Services
    Transact-SQL
    Database Optimization
    SQL Server Integration Services
    Microsoft Azure SQL Database
    Microsoft SQL Server Administration
    Microsoft SQL Server Programming
    Microsoft SQL Server
    SQL
  • $130 hourly
    Hello, If you are looking for database architecture, DBA work (database migration, database optimization), data warehousing, data engineering, and data analysis expertise, you have come to the right place. Data Strategy Our data experts design a custom-tailored data strategy to future-proof your business and take advantage of new opportunities and technologies that give your business a competitive edge. With a clear data strategy roadmap, we help your business turn your data into actionable insights that help reduce costs, improve efficiency, and increase ROI. Data Management Our Data Management consulting services provide a set of practices, processes, and technologies to help you acquire, store, organize, maintain, and ensure the quality of your data within your organization. From the architecture and structuring of your data to the storage of data in your data warehouse, and finally, the data analytics and visualization to gain insights from your data, our data management services play a crucial role in implementing and executing your data strategy effectively. Database Consulting Our consulting services for databases cover a broad range of offerings designed to assist your organization in managing, optimizing, and maximizing the potential of your database systems. We offer a variety of database solutions, including database architecture, database performance optimization, database migration, and database high availability. Our team has expertise in various database technologies, such as Mysql Proxy, MariaDB, MS-SQL, MongoDB, Clickhouse, AWS Aurora MySQL, AWS RDS Mysql, SingleStore, Postgres, Snowflake, and AWS Redshift. Data Architecture Modern data architectures have become essential for business strategic decision-making and competitive advantage. Our consulting services help your business leverage your data with an efficient blueprint. We use DBT and have experience with FiveTran, Airbyte, and Stitch data to create a single source of truth and modern analytics workflow. Data Warehousing We offer guidance on choosing and implementing data warehousing solutions, including traditional data warehouses or cloud-based options like Snowflake and Amazon Redshift. Our approach to data warehousing includes critical pillars such as Data Integration, Data Quality, Dimensional Modeling, BI Integration and transformation, and User Accessibility. Our Data Warehousing consulting services are sought-after organizations like yours that need an organized data management plan for their data strategy. Data Integration Revamp your data processes, enhance data quality, and streamline data flow within your ecosystem with Data-Sleek's top-notch data integration consulting services. Our team of experts will help you unlock the true potential of your data by leveraging cutting-edge technologies and best practices. Contact us today to learn how we can confidently empower your business to make data-driven decisions. Data Transformation Our team is confident in our ability to provide top-notch full-scale data transformation services that will help you modernize and unleash the full potential of your data systems. With our cutting-edge technologies and expertise, you can take your data to the next level and stay ahead of the competition. Let's work together to elevate your data systems and achieve your goals confidently. Data Migration Data-Sleek offers data migration consulting services to transfer your data without any downtime. We can assist you in transitioning from legacy systems to new platforms, migrating to cloud services, or adopting modern applications. Our team of experts can also help you consolidate your data and improve accessibility and data consistency. A little bit about Franck, Data-Sleek CEO: I have over 30 years of expertise in database technologies and data modeling. As a Sr MySQL DBA (15 years of XP), I have been involved in various projects for Fortune 500 companies and independent businesses in the entertainment industry, and I lead projects for database management for Acura, Variety, Lexus, ChromeRiver, Rubicon Project, TrueCar, ZipRecruiter, Wag, and recently Hulu. In 2018, I started teaching a Data Management class at UCLA Anderson where I could share my professional experience with the students and use the latest database technologies for Big Data and Business Intelligence, such as Snowflake, DBT, Fivetran, and Singlestore.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Data Warehousing
    PostgreSQL
    Amazon RDS
    MySQL
    MongoDB
    Big Data
    Database Optimization
    Amazon Web Services
    Data Modeling
    Snowflake
    dbt
    Data Visualization
    ETL Pipeline
    Data Engineering
    Tableau
    AWS Glue
  • $160 hourly
    I'm a data engineer and database expert with a passion for data and extensive experience across a broad skill set: * Expert in SQL (Oracle, Postgres, MySQL, Redshift, SQL Server, Snowflake, Clickhouse), PL/SQL / PL/pgSQL, Data Modelling, Data Warehousing, query optimization / performance tuning, and Oracle APEX. * Competent across the following cloud platforms - AWS, Azure and OCI. * Good knowledge of Python, Terraform, Kafka, DBT, NoSQL and graph databases (MongoDB, Neo4J), Azure Devops Pipelines / CI/CD, Kubernetes, Docker, orchestration tools (Airflow, Prefect) I'm a great communicator and have a proven track record of exceeding client expectations. I'm a native English speaker and I believe communication is key, especially when working remote. I look forward to speaking with you.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Snowflake
    Amazon Redshift
    ETL
    Apache Kafka
    Data Warehousing
    Data Modeling
    Database
    Oracle APEX
    Oracle Database
    PostgreSQL
    SQL
    Python
    MongoDB
    MySQL
  • $50 hourly
    Expertise in -- Design and Development of Analytical dashboards on Google Sheets / MS-Excel connecting to PostgreSQL / MySQL database -- Google Sheets development using charts, formulae & query and Apps scripts -- MS Excel development using Charts, Power Query, Power Pivot and Pivot Table Analysis -- Oracle/PostgreSQL/MySQL Database Design, stored procedure development, analytical query development, Query and Database optimization/tuning -- Design and host Postgres or MySQL databases on public cloud providers like AWS or GCP -- Database migration - on-premises to cloud --Automation of DB admin activities like installation, backup/restore using Ansible/Python
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Microsoft Excel
    Google Sheets Automation
    Oracle Database Administration
    Python
    Amazon RDS
    Bash Programming
    Visual Basic
    MongoDB
    MySQL
    Data Migration
    Database Administration
    Database Design
    SQL
    Oracle Database
  • $150 hourly
    Are you struggling with aligning technology investments with business objectives and ensuring a return on investment in your technology-driven business? 𝗪𝗛𝗔𝗧 𝗜 𝗗𝗢: I help technology-driven industries align their technology investments with business objectives and achieve a return on investment by developing tailored technology strategies, fostering collaborative partnerships, and providing ongoing support throughout the implementation process. This approach ensures that technology investments are directly aligned with business goals, leading to enhanced operational efficiency, improved customer experiences, increased innovation, and a competitive edge in the market. By working closely with clients and continuously adapting strategies as their business evolves, I help them obtain a greater return on investment and accomplish more of their objectives with less effort. 𝗛𝗢𝗪 𝗜’𝗩𝗘 𝗗𝗢𝗡𝗘 𝗜𝗧: I was brought in as a technical advisor/Interim CTO when a client faced challenges and lacked confidence in their app developer agency. By immediately assessing the situation and understanding the client's goals, I steered the project in the right direction. Through this process, I identified the need for a new agency to support the next phase of development and recommended necessary infrastructure changes. I also ensured clear communication between the client and the agency, leading to the app being built correctly and aligned with the desired functionalities. As a result of these actions, the owner gained confidence in the app development process. The app was not only built correctly but also delivered on time and with transparency. The client felt assured that their goals were met and that the app was developed to support all desired functionalities. The client expressed their regret in not hiring me from the beginning, as my involvement made a significant positive impact on the project. 𝗪𝗛𝗔𝗧 𝗠𝗬 𝗖𝗟𝗜𝗘𝗡𝗧𝗦 𝗔𝗥𝗘 𝗦𝗔𝗬𝗜𝗡𝗚: “We knew within a few minutes of talking to Daniel that we had (after many failed attempts) found a developer/consultant that is an expert in the field and could lead us in getting our project to launch. Daniel is detail oriented, professional, responsive and has excellent communication skills that have been invaluable to us in many aspects of our project. Daniel is knowledgeable, experienced and an efficient team leader. We recommend him without reservation.” Jen, GoShimmy “Finding Daniel was like hitting "Triple 7's" on the slots! Right out of the gate he was able to take a very broad project concept and grasped the essence of the system we intended to build. He then turned around and provided extremely valuable insight. We then tasked him with the job of helping us find and vet a top-tier development team. Armed with our list of requirements, he methodically vetted many teams until he found one that that was the perfect fit for our project. I can say with earnest that without Dan's assistance I do not believe we would have been able to achieve the inroads we have up to this point. I cannot give Dan enough praise nor recommend him highly enough. Dan is a true master of his trade.” Steve, ZinZuu Technologies “In the first few minutes of our call Daniel immediately showed us the true professional and expert he is in his field. He provided us with more value than we could have asked for on this call and really simplified complex technical things In terms that our whole team was able to understand. I would highly recommend him to any team or business looking to get advice on new development projects and or improving existing developments. Thank you Daniel and we are looking forward to our next call!” Robert, Private - Startup Initiative “I hired Daniel to develop a Windows desktop application which required deep understanding of low level IoT device I/O, programming, and configuration. Daniel took loose specifications along with hardware devices and was able to unravel all of the technical design details and develop a solution that was fast, reliable, and efficient. I would highly recommend Danial as a Sr. level engineer capable of taking on projects of any magnitude.” Heath, Mueller Water Products 𝗪𝗔𝗡𝗧 𝗧𝗢 𝗟𝗘𝗔𝗥𝗡 𝗠𝗢𝗥𝗘? Contact me today!
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Business Strategy
    Innovation Strategy
    Executive Coaching
    Startup Consulting
    Project Management
    ASP.NET
    Visual Basic
    API Development
    Software Architecture & Design
    Software Consultation
    Desktop Application
    .NET Core
    Web Application
    JavaScript
  • $110 hourly
    Everyone believes in the value of data, and I can help you realize that value. My purpose and passion is helping you meet design and performance issues for both operational and BI/analytic data solutions as well as helping you gain valuable insight from your data with data exploration and visualization solutions. I strive to create long-term relationships with clients, helping you to grow with your data rather than quick one-of projects. First defining the need and designing an appropriate solution rather than letting the solution and technology defining the need. I also strongly believe knowledge sharing with employees are the key to an organization's growth and developing employees through training, coaching and mentoring is fundamental to real success. I have mentored many employees in my career and always enjoy opportunities to lead and mentor in the data management space. I look forward to working with you and helping you achieve success with your data.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Snowflake
    Data Modeling
    Microsoft SQL Server
    Data Integration
    Data Management
    Database Design
    SQL Server Integration Services
    Data Analysis
    Business Intelligence
    Power Query
    SQL
    Tableau
    Data Visualization
    Microsoft Power BI
  • $100 hourly
    Useful communication, in language that's easy to understand. I've been into programming since I was in grade school. 25 years of diverse project experience. My fundamentals are good (four year Computer Science degree). Upwork Expert-Vetted*. --- I can help you with: ✔ Performance tuning for SQL databases ✔ MySQL / MariaDB / Postgres / Oracle / BigQuery / other SQL ✔ Python ✔ Linux and shell scripting ✔ Server configuration ✔ Cloud platforms (Google Cloud, Amazon AWS) ✔ Data analytics and pipelines ✔ Algorithms and CS fundamentals ✔ Cryptocurrency mining and scripting (Binance Smart Chain) ✔ Pair programming and tutoring ✔ Improving and optimizing the speed of your site * "Expert-Vetted highlights talent that has gone through a thorough pre-screening process by experts in their field. These elite freelancers and agencies have been evaluated by our technical Talent Managers for their expertise and excellent soft skills. They represent the top 1% of talent on Upwork."
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Docker
    Cryptocurrency
    Linear Programming
    Linux System Administration
    Database Optimization
    Performance Optimization
    Google Cloud Platform
    Unix
    MySQL
    PostgreSQL
    Amazon Web Services
    Query Tuning
    SQL
    Python
  • $30 hourly
    I have been developing data-centric desktop and web applications utilizing Microsoft technologies since 1999. I am proficient in GUI design and UX with MVC and Blazor. Experienced in: - Microsoft SQL Server/T-SQL databases - Migrating data from various sources into a relational data model - ASP.NET Web API/MVC - Visual Studio - Visual Studio Code - Entity Framework - Bootstrap - CSS - HTML - JavaScript - JSON - PWA - Blazor WASM - Blazor Server - Blazor Hybrid
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Automatic Speech Recognition
    Blazor
    Database Design
    Microsoft Azure
    RESTful Architecture
    SQL
    Transact-SQL
    ASP.NET MVC
    JavaScript
    HTML
    jQuery
    CSS
    C#
  • $120 hourly
    I'm a developer with experience across many industries and technologies, having worked in IT for more than 20 years. My attention to detail, passion for coding and quick understanding of your domain help me to very successfully develop and consult on any kind of application. Whether you have detailed specifications and need them coded or require a guide through the whole software development process, I can help you. At any stage you will receive advice from me to make your project successful. I'm currently specializing in: - Single Page Application (SPA) development with React.js / JavaScript - Server side development with Node.js / JavaScript - Any database related work or consulting for PostgreSQL - Cloud infrastructure in AWS
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    PostGIS
    Database Optimization
    ETL
    Data Migration
    Linux
    Database Administration
    Query Tuning
    Amazon
    Database Design
    JavaScript
    SQL
    Node.js
    PostgreSQL
    React
  • $75 hourly
    “Eugene has been wonderful throughout the entire process of Access development, implementation, and maintenance/upgrades. Eugene has always worked to support us and continues to be our primary Database Resource (i.e. the first person we call)!” - Mitchell D., MilliporeSigma (A Merck Company) I have worked extensively as an Independent Microsoft Access Developer for the past 19 years and am proficient in database design, custom reporting, troubleshooting, and data visualization. As a Certified Technical Trainer, I teach private Access Beginner's, Intermediate and Advanced VBA Programming courses to corporate clients. I have created custom databases in Access as well as DevExpress/XAF for a variety of industries in the US and internationally including: Manufacturing, Medical, Education, Forestry, Real Estate, Financial, Retail Sales, Life Science and Automotive. I am your resource for: * Existing Database Modifications, Troubleshooting & Repair * Integration of Excel/Access * Analytics (Power BI, DevExpress BI, Dashboards, Scorecards/KPI) * Custom Reports (Ad Hoc, Automated Email Distribution, Parameterized) * One-on-One Access Coaching (Video calls, Screen Share) * On-Site Corporate Training in MS Access (Multi day flexible schedules) * Software Development MS Access, VBA, C#, SQL, MySQL, SQL Server, Azure SQL Database, Azure Web Apps, WinForms, DevExpress XAF/XPO, Entity Framework, ASP.net, MVC Here are a sampling of some of the database applications I have created: * Energy Consumption Analytics - Boston Public School System * Airbag Inspection Database - Takata Industries * Quality Control Application - MilliporeSigma (Merck) * Industrial Moisture Monitoring - Sanmina Corporation * Industrial PLC Data Collection - Plymouth Tube * Inventory Control System - Ben Hogan Golf ......................and many, many other projects I pride myself on having 100% satisfied clients, and value honesty, hard work, and reliability. I look forward to working with you on your project!
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Data Modeling
    DevExpress
    Desktop Application
    Database Development
    Bug Fix
    ODBC
    Visual Basic for Applications
    Microsoft Access Programming
    Microsoft Access
    Microsoft Excel
    SQL
  • $50 hourly
    For the past 20+ years, I have been developing MS Access applications with all versions of Access (starting with the '95 version). I specialize in Access, and do not split my time on other disciplines (such as websites). During my 10+ years on Upwork (and elance and oDesk), I've successfully completed 80+ projects, totaling more than 1900 hours (1300+ hours on 'hourly' jobs & 600+ hrs on fixed-price jobs). 33% of these projects have been with repeat clients. Because of this experience, I have accumulated a toolbox of forms, queries, functions & subroutines that I can re-use on new applications. This enables me to keep the client costs down when developing new, or enhancing existing, applications. I have a job success rate of upwards of 90%, which is clearly reflected in my verbal & numeric feedback. I offer the following types of services: 1. Create turnkey database applications using MS Access (conceptualization, design, development & deployment). 2. Design normalized database structures. 3. Convert Excel-based applications to Access. 4a. Convert dBase & Lotus Approach applications to Access. 4b. Convert ADP projects to accdb databases 4c. Convert legacy mdb databases to accdb 5. Use Access VBA to import data from, and export to, Excel, CSV, text files & other Access DBs 6. Use Access VBA to automate creation of documents with MS Word mail merge & templates. 7. Deploy applications to the Cloud (via Citrix & Sharepoint). 8. Create documentation: System Manuals and User Manuals. 9. Deploy applications to tablet computers. 10. Create macros in Excel, Word & Outlook to automate various actions 11. Use VBA to control the contents and printing of labels to DYMO printers. 12. Use VBA Automation to control Excel, Word & Outlook. 13. Use Zebra label Designer software to connect to Access database & automate printout of labels. 14. Specialize in cracking legacy applications whose life has expired, and which are passworded. This includes applications based on Access and Word.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Visual Basic for Applications
    Database Development
    Microsoft Access Programming
    Mail Merge
    Desktop Application
    IBM Lotus Approach
    Microsoft Word
    Database Design
    Business with 1-9 Employees
    Microsoft Access
  • $75 hourly
    Expert in Google sheets, forms, Google app scripts, and Google web apps. Successfully completed >100 data management systems for small and large corporations using my background in Aerospace Engineering Management.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Database
    Database Design
    Google Sites Administration
    Microsoft Excel
    Google Docs
    Google Sheets
    Google Apps Script
  • $30 hourly
    Delphi from 1.0 to XE 10.3 Rio for Desktop solutions. For mobile we can use FireMonkey for creations multiplatform applications for iOS, Android, OS X and Windows or create Native applications via Java and Kotlin for Android. REST, SOAP, DataSnap, XML and JSON - we can use all of them. Experience in 3D engines, HTTP, SMTP and other protocols. We have experience with lot of DataBases from old Paradox and dBASE, exotic NexusDB and DBISAM, popular Firebase, Mongo, MySQL (MariaDB), MSSQL and Postgress to power Oracle and Sybase.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    SQL
    Delphi
  • $75 hourly
    I have 14+ years of data analysis and programming experience. On a daily basis I work on a variety of tasks. Sometimes I will be focusing on writing many complex SQL queries from scratch. Other times I will be working on a cool complex VBA project for automation. I am all about automation. Everyday I work with data and analyzing it to see what it can tell me. I enjoy the challenge of being inventive and designing a solution to complex problems. Because I do this on a daily basis, I am constantly learning things I didn't know. I am an expert in Excel/Google Sheets and excellent in many different forms of SQL (ex. Oracle, MySQL, Teradata, SQL Server). I am also an expert in visualization. With all the data analysis experience I have learned how to structure data to create the visuals you are looking for. I am an expert in PowerBI, Looker Studio, and AWS Quicksight. Combining all my technical skills with my personality of detailed oriented and proficient in meeting strict deadlines makes me the perfect professional to complete your project.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Oracle PLSQL
    Database Design
    Spreadsheet Software
    SQL
    Microsoft Outlook
    MySQL Programming
    SQL Programming
    Microsoft Access Programming
    Microsoft Office
    Microsoft Excel
    Google Sheets
  • $40 hourly
    Раssionate developer from Ukraine 🇺🇦 I am available to develop projects from inception to final delivery 📬 The main stack of technologies I specialize in is PHP and its frameworks, mainly Laravel My fields of expertise⚔️🛡️ 📌Backend: • PHP 7, 8 Laravel, Symfony, Yii • NodeJS, Express • NestJS 📌Frontend: • HTML + CSS (basic LESS/SASS) + Bootstrap • JQuery, AJAX, JSON, XML 
• ES6 features and higher order functions React.js, Vue.js Angular 📌Databases: • PostgreSQL • MySQL • MongoDB 📌Also Experienced in: •IDE: PHPStorm 
•Git • WebRTC •Usage of cloud technologies: Gmail • Web Sockets •Docker, CI/CD - Jenkins Feel free to get in touch with me and let's turn your ideas into reality🌌
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Docker Compose
    PhpStorm
    CI/CD
    Linux
    Yii
    Vue.js
    Docker
    PHP
    Laravel
    MySQL
    NGINX
    React
    Symfony
    SQL
  • $120 hourly
    My goal is to provide solutions that meet or exceed my clients' expectations. I have a B.S. in Computer Science and a Minor in Mathematics. I have developed applications and scripts using over a dozen programming languages, and specialize in working with data. I am an Excel/Access expert and can automate these applications. I have worked with relational databases, including Microsoft SQL Server (2005, 2008R2, 2014, and 2017). I have reporting and data visualization experience using SSRS, Excel and Tableau. Additionally, I have experience working with APIs, Google Sheets, and App Scripts. I welcome any requests, big or small.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Computer Skills
    Visual Basic for Applications
    Relational Database
    Microsoft SQL Server Administration
    Data Cleaning
    Microsoft SQL Server Reporting Services
    MySQL Programming
    SQL Programming
    PostgreSQL Programming
    Microsoft Access Programming
    Microsoft VBScript
    API Integration
    Data Visualization
    Microsoft Excel
    JavaScript
    SQL
  • $125 hourly
    With over 15 years of expertise in FileMaker Pro and full-stack development, I specialize in modernizing outdated systems and driving efficiency through custom automation. My strength lies in crafting tailored solutions that align with your business goals, helping you overcome challenges and seize new opportunities. Key Accomplishments: Successfully integrated complex REST APIs, including OAuth 2.0, into existing systems, enhancing functionality and security. Led projects that streamlined operations for businesses, resulting in a significant increase in productivity and reduced operational costs. Earned a Computer Science degree and FileMaker certification, underscoring my technical foundation and commitment to excellence. Core Skills: Database Management: FileMaker Pro, SQL Web Development: PHP, JavaScript, HTML5 Automation & Integration: Claris Connect, Zapier, REST API Payment Integration: Stripe, PayPal, Authorize.Net Let’s collaborate to elevate your business with innovative, efficient solutions. I’m here to turn your vision into reality.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    AWS Development
    UX & UI Design
    Project Management Software
    Automation
    API Integration
    Artificial Intelligence
    SQL Programming
    Data Migration
    Database Development
    FileMaker WebDirect
    Full-Stack Development
    Claris FileMaker
    PHP
    HTML5
  • $70 hourly
    17+ years experience as a Microsoft SQL Server DBA working with SQL versions 2000 through 2022 on-premise and in the cloud. I have spent my career solving complex issues within SQL Server using nothing but free, native tools and techniques. Performance Tuning, migrations, HA and health checks are my specialties, but I've worked with over 80 different clients on a variety of projects. In addition to resolving problems within SQL Server, I'm also an active member of the SQL Server community in which I've written over 65 technical articles for MSSQLTips.com and my blog. 🌟 sqlbrady.com 🌟 mssqltips.com/sqlserverauthor/69/brady-upton/ You can also view my website here: sqlfreelancer.com 🙋🏼‍♂️I'm excited to get the chance to speak with you and discuss your challenges and how we can work together to achieve success!
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Microsoft SQL Server Reporting Services
    Performance Optimization
    Microsoft Power BI
    Microsoft Azure
    Microsoft Azure SQL Database
    Microsoft SQL Server Administration
    Microsoft SQL Server Programming
    SQL Server Integration Services
    Database Optimization
    Transact-SQL
    Database Administration
    SQL
    Microsoft SQL Server
  • $45 hourly
    Do you have departmental workflow and/or business application project requirements. No project too small or too large. Is your organization ready for true information collaboration. I will help you define your business requirements and then build and test the application that meets your needs. With low code application development platforms like Salesforce, QuickBase, Kintone, Caspio, Knack, AirTable, Zoho Creator or QlikView, there is no longer a need to buy an off the shelf solution that meets 80% of your needs where the 20% functionality sits on the shelf wasting away. I have been developing applications for my clients in the low code cloud based collaborative application development platform since 2001. My adoption rate has been 100%. If your project plan is not going to easily be adopted, maybe because your user culture is not ready for collaboration, then I will let you know early in the process so that: 1. You don't waste time and money on more "shelfware". 2. I maintain my reputation for building applications with 100% adoption. No Code application development platforms like QuickBase, Kintone, Caspio, Knack, Tableau, Zoho Creator, AirTable and Qlikview are disrupting the business application development industry and I have been on that bandwagon since 2001. In recent years I have helped my clients leverage their business data by implementing datawarehouse tools e.g. MS PowerBI and Tableau. Do you need help determining which platform is best for your needs. I can help you make that determination. I look forward to helping you with your next mission critical business application requirement.
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Cloud Computing
    Salesforce
    Database Design
    ETL
    Database Testing
    Database Report
    Database Maintenance
    Database Architecture
    Microsoft Access Programming
    API Development
    Zoho Creator
    QuickBase
    Business Analysis
    Microsoft Excel
    QlikView
    Tableau
  • $60 hourly
    Build web site, web services, API, web based application and reporting service reports(SSRS) Technologies: C# and .NET technologies ASP.NET, JQuery, XML, HTML, CSS, Telerik, API, SQL 2012/2016/2019/2022, VS2019/2022. 25+ years of software development experience 15+ years of web development/design skills Specializing in Microsoft SQL scripts, stored procedure, functions, triggers, Microsoft SQL Reporting Services Report(SSRS) MS SQL/SSRS installation/configuration/agent job creation/maintenance plan AI Evaluation Automation -- Audio file to transcripts to evaluation result(score/comments/summary) SSRS Demo: http://66.94.122.184/sandbox/default.aspx
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Transact-SQL
    Data Scraping
    SQL Server Reporting Services
    SQL
    JSON API
    Web Application
    AJAX
    ASP.NET
    jQuery
    Microsoft SQL Server Programming
    Microsoft SQL Server Reporting Services
    Telerik
    C#
    Kendo UI
  • $100 hourly
    I love MS Access and VBA, they've been my passion for over 25 years and I've become a pro at developing amazing apps and automating. My apps are top quality: user-friendly, very well thought out, packed with functionality yet simple to use, and are developed with an eye towards minimal clicking and thinking for the user. Automation and streamlining is a constant theme in everything I do. I believe that you and people in your company shouldn't do ANY manual repeating tasks because they can all be automated. I'm excellent at automation, I will ask a ton of questions to learn your workflow and will then develop an app that will do most of your work for you. I can also do anything you need when it comes to updating existing MS Access applications, automating your workflow, converting Excel sheets to MS Access applications, converting MS Access applications to SQL or to newer versions of MS Access, and writing Excel macros. I'm quick to reply to messages I'm easy to work with, no condescension here :) I have many libraries of reusable VBA code, forms, and reports, which greatly speed up development
    vsuc_fltilesrefresh_TrophyIcon Database Programming
    Database Design
    SQL Programming
    MySQL
    SQL
    Data Migration
    Data Analysis
    Microsoft Access
    Microsoft Access Programming
    Oracle PLSQL
    Visual Basic for Applications
    Microsoft Excel
    Automation
  • Want to browse more freelancers?
    Sign up

How it works

1. Post a job

Tell us what you need. Provide as many details as possible, but don’t worry about getting it perfect.

2. Talent comes to you

Get qualified proposals within 24 hours, and meet the candidates you’re excited about. Hire as soon as you’re ready.

3. Collaborate easily

Use Upwork to chat or video call, share files, and track project progress right from the app.

4. Payment simplified

Receive invoices and make payments through Upwork. Only pay for work you authorize.

Trusted by

A Guide to Database Technology

Databases store, organize, and process information in a way that makes it easy for us to go back and find what we’re looking for. We encounter databases, both simple and complex, all the time, whether in the form of library card catalogs, financial records, employee directories, and even phone books. 

But, what are databases in the context of a website? In this quick guide to modern database technology, you’ll get an understanding of how databases work, common terms to know, a look at SQL vs. NoSQL, and how to determine which database is best for your web application.

A quick overview of modern database technology

Spreadsheets process numbers, databases process information—specifically, structured information. Databases can be designed to do just about anything with information—track, organize, and edit data; collect data and produce reports; or, be the foundation for information-rich, dynamic websites.

Increasing complexity: Single-file vs. Multi-file databases

Take the phone book, for example: It’s got items of information like names, addresses, and phone numbers, all organized in the same format. In database terms, the book is the table, each person is a record, and their name, address, and phone number are all fields. The last name—how the book is organized, alphabetically—is the key field, which sorts the records. 

Because the last name was chosen as the key field, that’s how the phone book is sorted—sorting by phone number or house number wouldn’t generate what we were looking for, and we’d never find anything out of the thousands of entries. And that’s one cornerstone of database technology—smart sorting.

But a phone book is just a flat, single-file database. When would you need more complex databases with multiple tables that can interact with one another? Say you want a shipment status update on an order you placed with an e-commerce site. That website has multi-file databases set up for orders, dates, payments, shipment tracking, inventory, suppliers, and customers. By linking these tables together, if a query is made about an order’s status, the database can generate a report with data from the tables:

“[Customer]’s order of [product] purchased with a [payment method] on [purchase date] is being shipped to [address] via [method], due to arrive [tracking date].”

That, in a nutshell, is a relational database.

Relational Databases and Database Management Systems: Building Powerful Data-Driven Websites

The foundation for modern database technology began in the 1970s with the first “relational data model.” Its emphasis was on careful organization. Today, relational databases remain important to how websites are built: any website that displays data from a database has to have (a) server-side scripting, (b) HTML & CSS, (c) SQL, a database language, and (d) a database management system (DBMS).

Relational databases consist of two or more tables with connected information, each with columns and rows. These connected tables are called database objects, and in order to create them and manage them, you need a relational database management system (RDBMS). One example of an RDBMS is Microsoft's SQL Server. RDBMSs allow relational database developers to create and maintain a database program, including tools to:

  • Query data
  • Sort and edit data
  • Design the entire database structure
  • Produce reports
  • Validate data points and check for inconsistencies
  • And, they often include a built-in programming language to automate some of these functions, such as SQL.

SQL: The Language of Database Access

Structured Query Language (SQL) is a standardized programming language for accessing and manipulating databases. In an RDBMS like MySQL, Sybase, Oracle, or IMB DM2, SQL writes programming that can manage data and stream data processing. SQL is like a database’s own version of a server-side script and is responsible for:

  • Executing queries, which are “questions” asked of the database
  • Retrieving data
  • Editing data: inserting, updating, deleting, or creating new records
  • Creating views
  • Setting permissions
  • Creating new databases

SQL is a standard programming language, but has a number of variations—including some databases’ own proprietary SQL extensions.

Note: When it comes to creating new databases from the ground up, planning ahead is key. In the same way you need to plan ahead for the future of your site when choosing a software stack, how your database is structured from day one will have major implications for the health of your site down the road. Questions to consider include: What information will you have? How should it be stored? What data will your site need to retrieve regularly, and how?

NoSQL database: Non-relational and distributed data

Relational databases are great at organizing and retrieving structured data, but what happens when your data is inconsistent, incomplete, or massive? 

In these cases, you need a more flexible database solution. As the kinds and amounts of data that we gather has exploded, the NoSQL database has evolved to solve the challenges of Big Data. NoSQL means “Not only SQL.” These databases are non-relational and distributed. They deviate from the traditional relational model, addressing the issue that most modern data harvested from the web is not structured information. NoSQL lends flexibility, scalability, and variety—major advantages from a business standpoint, when you consider that growing data is a direct result of a growing business.

How does a NoSQL database work? Instead of tables, NoSQL databases are document-oriented. This way, non-structured data (such as articles, photos, social media data, videos, for example, an entire blog post) can be stored in a single document that can be easily found but isn’t necessarily categorized into a bunch of pre-set fields. It’s more intuitive, but note that storing data in bulk like this requires extra processing effort and more storage than the highly organized SQL data. That’s why Hadoop—an open-source computing platform—is so helpful and often integrated into database platforms.

Common database terms to know

Here are a few major database features that are helpful to know when weighing one database against another—things like how databases grow, protect against failure, duplicate data for speed, safety, and accessibility.

Scalability

How much do you expect your data to grow (and how soon)? Do you need a highly scalable database that will be reliable even as the amount of data you’re processing grows exponentially? Will one server be enough, or do you anticipate needing to add additional ones? Horizontal scaling spreads data out across a distributed network of affordable commodity hardware rather than concentrating it in one massive (and expensive) server.

Sharding

Related to horizontal scaling, sharding is a technique for storing massive databases across multiple servers. It achieves this by breaking splitting different rows into different tables. For instance, a database of customer names might store customers with last names A-M on one shard, while N-Z are stored on another. Sharding can help minimize response times for queries while also allowing data to be stored across a large number of cost-effective servers.

Replication

Does your app need real-time access to update and synchronize data? Replication is the process of frequent copying of data from one database onto databases on other servers. When data is replicated from an app’s primary server, it’s synchronized with secondary database servers, making that information accessible in real-time (and safe, in the event of a crash). Queries to this secondary database won’t slow the network or the performance of the app.

Latency

Latency refers to the time it takes for data to complete a “round trip” between the database server and the application server. When an app queries its database for data, this is how long it takes the server to return that data. The lower the latency, the better, but low latency often comes at a cost to other features, like consistency and availability.

Consistency

When writing to a database, it’s important that changes to the data don’t violate the rules of the database. Consistency ensures that transactions don’t produce errors that can make the entire database invalid. A fully consistent system means that as soon you successfully write a record to a database you’ll also be able to request it. This is especially important for things like financial transactions. Consistency comes at a cost to speed and availability, however. That’s why many NoSQL databases opt for an eventually consistent model that allows for faster reading and writing.

Availability

Availability refers to whether or not the system is able to quickly respond to a request, even when failures occur. In databases that are spread across multiple servers, this can result in out-of-date or incorrect data being displayed, especially in an eventually consistent system. Depending on your business needs, however, slightly out-of-date data may be preferable to delays that prevent the whole system from functioning.

Fault-tolerance

Failures are inevitable, but there are plenty of contingency plans you can put in place to ensure that data is still available and your app doesn’t crash. Having “no single point of failure” ensures that an app can keep functioning without interruption, usually through replication or redundancy. Databases do this differently, with varying degrees of cost and footprint.

View less
Schedule a call