Db architect jobs

I'm seeking an experienced architect who can create high-end, contemporary designs for a luxury home. These designs will include blueprints and should represent a modern, stylish, and lavish aesthetic. Key features: - Living Room - Kitchen - Bedrooms - Gym - Outdoor Patio Area The successful freelancer must have a well-versed understanding and experience in contemporary architectural design. Full comprehension of the dynamics and requirements for the listed rooms and areas is critical. Exceptional detail, creativity, and the ability to effectively interpret my vision are necessary to bring this project to life. Providing blueprints alongside the design is an absolute requirement. Let's create a home that represents the future of luxury living!

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurately is crucial. Access & Support: - I ...

I'm in need of a professional architect to make renders ( exteriors and interior , and for the masterplan) and design the final board presentation . *important point * - You should have Revit 2024 (as the files were created in Revit 2024) - you should be professional in using Photoshop ( as you should design the board in photoshop) -You should use Lumion to make the renders. Your scope : 1) renders for 6 exterior , 3-4 interiors , and render for the masterplan 2) design the final presentation board. *Work should be done totally in* Sunday 12/5/2014

I am looking for a full stack web developer to creat...Loginpage login (create user/password in the backend) 2. Dashbord one - prints rows of a table (buttons to add/delete/update table rows) 3. Dashboard two will have 6 tables, each of the table entries will have few configurable(will be configured through pop up window) , stats, logs , status 4. One of the table could have a flow table just for read only 5. THere should be back end persistent DB which saves all the data 6. THere should be method to bring down this and powered back any time Acceptance criteria 1. NDA signing 2. Web page working conditions and exceptions taken care on AWS/ local machine 4. UI page design will be approved in each stage of development 5. well written code with enough comments

Proposal Traditional Residential Architect 600 USD stage 1: Cover, siteplan, floorplan, elevations 800 USD stage 2: Sections, Roofplan, Trussplan, Electrical plan 700 USD stage 3: plumbing plan, waste plan, Framing wall plan, Details, Hvac plan, Exit plan 650 USD Stage 4: stamps 10:25 A 900 USD Stage 5: approved project

I'm looking for a skilled React.Js and Mongo DB developer to create a matrimony web app that includes user registration, profile creation and match recommendations. Key Features: - User Registration and Login: Users should be able to create accounts and log in securely. - Profile Creation and Customization: Users should be able to create detailed profiles with customization options. - Match Recommendations: The app should have a feature that suggests potential matches based on user activity. Design Preferences: - I would like the design to be 'Colorful and vibrant'. A modern, visually appealing and engaging design is crucial for a successful matrimony web app. Match Recommendations: - The match recommendations feature is an essential part of the app. It should wor...

I need a skilled architect or draftsperson to produce detailed cross section drawings for a building construction project. These drawings will be integral to the construction process and need to be clear, accurate and comprehensive. Key Requirements: - Expertise in creating cross section drawings specifically for building construction. - Proficiency in including detailed dimensions and materials. - Strong understanding of construction processes and requirements. - Attention to detail and precision is essential. - Experience in architecture and design projects is a must. Please only apply if you have a proven track record in creating high quality, detailed cross section drawings for similar projects.

Looking for a skilled architect to create precise, detailed blueprints for my single-family house which I can use to self-build and which my bank will approve. Your design should closely follow the floor plan which I have given: - Four bedrooms - Two bathrooms - Pole barn style frame - Metal sheeting for roof and siding - Concrete Slab floors with Radiant heating - scissor trusses with ability to hang sheetrock on it Experience in residential architecture is a must, particularly creating blueprints for single-family houses is ideal. Your design must maximize live-ability and functionality while being economical. Ability to work with strict deadlines is necessary as we’re excited to get started.

I am in need of a talented architect or interior designer who can provide top-notch 3D rendering for both interior and exterior spaces of my residential project. Key Responsibilities: - Creating photorealistic 3D renders for both interior and exterior of a residential space Ideal Skills and Experience: - Proficiency in 3D rendering software and tools - A strong portfolio showcasing previous work in residential projects - Attention to detail and ability to create high-quality, photorealistic renders Please note, the successful candidate will be required to sign a non-disclosure agreement to protect the integrity of the project.

...cluster. - Microservices experience: An understanding of microservices architecture and best practices will be critical. - Troubleshooting skills: Assist in identifying and fixing any issues that may arise during the deployment process. Please note that I already have Docker images for my microservices. The primary focus will be configuring these services on the Kubernetes cluster. I had my architect send me some bullets on his specific needs: Identifying root causes of POD failure, was it caused by the code, kubernetes resources limits, nodes architecture, etc. Monitoring POD resources, capturing Memory/CPU usage and analyzing usage patterns, deciding the best resource allocations. Sizing nodes based on IPAS usage patterns. Analyze network issues between different PODs and ...

We are looking for an architect to assist with the design of a residential home in Sydney that will be a duplex. Previous experience is essential including experience in completing designs for residential homes in Sydney. The architect must have experience using software (ideally chief architect or other similar software such as archicad) After the successful achitect is chosen we will discuss the proposal and the number of hours required for the different stages until completion. To be eligible you must also complete the following test:

I'm looking for a talented landscape architect to design a natural and rustic landscape for a lake project. My vision is to predominantly incorporate local plants and trees. Even though, I've chosen to skip the specific features I'd like to add, I'm open to innovative suggestions that align with the desired theme. Ideal Skills and Experience: - Proficiency in landscape architecture - Strong knowledge of local plant species - A creative approach to rustic design - Prior experience with lake or similar projects

I'm in need of an architect to design a modern single-story residential building. Key requirements: - Proficient in architectural design, particularly for residential projects - Expertise in modern architecture - Ability to work with a single-story building - Strong design and spatial planning skills Please get in touch if you have experience in this area and can deliver a modern, single-story residential design.

I require a proficient architect who specializes in commercial interior redesign. Project Scope: - The project involves a commercial property which is less than 10,000 sq ft in total size. Skills Required: - Comprehensive experience in commercial architecture - Sound knowledge of interior redesign techniques - Proven ability to manage small-scale projects The ideal candidate will have substantial experience in maximizing the use of space while creating modern and professional aesthetics. Please provide examples of previous work in your bid.

I'm seeking a skilled interior designer/architect to help me completely replan my house. The project will involve a full overhaul of the living room, kitchen, and bathroom. Key Tasks: - **Living Room**: I'd like to create an open floor plan with better lighting and new furniture, enhancing the overall aesthetics and functionality. - **Kitchen**: I'm looking for an improved layout, optimizing the space for better practicality and flow. Ideal Skills and Experience: - Proven experience in house replanning or interior design. - Proficiency in creating open floor plans and optimizing space. - Ability to source and recommend new furniture and lighting fixtures. If you have a strong portfolio in similar projects and are confident in your ability to deliver a fresh, mode...

****  BUDGET $350  **** DO NOT BID UNLESS YOU ARE AN ARCHITECT or CIVIL/STRUCTURAL ENGINEER THAT CAN DO STRUCTURAL CALCULATIONS, and have STEEPLY SLOPE EXPERIENCE + REVIEW +++ PLEASE READ ENTIRE POST BEFORE SUBMITTING A QUOTE  +++ !!!! FOUNDATION STRUCTURAL CALCULATIONS WILL BE NEEDED FOR BOTH BUILDINGS !!!! If you submit a fee, then increase it after we discuss, I will say goodbye to you!!!! **** ALL TASKS ARE STATED HERE ***** VIEW ALL ATTACHMENTS BEFORE YOU BID!!! +++  DELIVER DWG and PDF files in ARCH D 24" x 36" format, Scale is 1/4 inch = 1 foot +++ 1. CREATE TWO (2) NEW Foundation Plan with STRUCTURAL CALCULATIONS plus Elevations (in relation to land contour/slope), Section and Roof Plan with STRUCTURAL CALCULATIONS for 2(TWO) Buildings :: ...

Hi, I need two black and white adds created for a local community brochure. The add for "Pro meats" is to be 9cmx14cm and is to include a banner "20% discount when mentioning this add" The add for "Willoughby Architect" is to be 14cmx18cm, similar to the existing one but with a new image. Existing add needs also to be reformated to suit the above size Mention "272" in your response

I have a digital residential floorplan 6 images that I need an expert architect to review for potential errors and circle them in red. Please briefly share what is wrong with it. I'm looking for a professional who can carefully examine all areas of a residential floorplan, including room layouts, electrical installations, plumbing systems, footings, hvac, site plan, sections and circle any errors on design. If no erros please share what was done correctly. You should have a keen eye for detail and a solid understanding of residential building codes and standards. Your feedback will be invaluable to ensure the plan is error-free and optimized for its intended use. Previous experience with similar projects is highly desirable. Please include examples of your past work in y...

...appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 4- Packages Load from APIs instead of loading from DB (2 APIs) 5- SubscribedPackages Call API instead of inserting into a DB (1 API) 6- Schemes Load from APIs instead of loading from DB (1 API) 7- Uploads Call API instead of inserting into a DB (1 API) 8- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# Blazor experience. Project Code : ------------------------------------------------------------------------------------------------------------------------- I urgently need expertise in fixing...

I am in need of an expert cloud architect skilled in AWS . Your primary responsibilities will include: Teaching me Landing Zones Mentoring Cloud architect Regular consultation in shaping up the cloud architecture as we evolve as a business cost vs performance vs business needs Solution architect Please note: - I am seeking an individual, not a company. Only industry professionals need apply. - You should be able to provide a practical demonstration of your skills in these areas. - Your proficiency with cloud Architect and Cloud operations will be a critical factor in the selection process. NOTE: STRICTLY NO BEGINNERS OR RANDOM WEB DEVELOPERS OR EASY MONEY ATTITUDE PERSONALITIES DO NOT APPLY FOR THIS If you meet these criteria, please apply with details...

I'm looking for a skilled architect or draftsperson who can assist me with detailed floor plans for a renovation project. Specifically, I need: - Detailed floor plans with measurements and annotations of an existing property for renovation purposes. Your expertise should include: - Proficiency in creating architectural drawings, particularly detailed floor plans. - Experience in renovation projects, particularly understanding of measurements and annotations. - A keen eye for detail and ability to capture a space accurately.

I'm looking for a skilled individual who can help me read a file and extract specific data from it. Key Requirements: - Extraction of File names, File sizes, File creation dates, and messages stored in the DB file. - Ability to adapt to extracting all messages or specific ones, depending on my future needs. - Delivery of the extracted data in a Spreadsheet format, preferably Excel or Google Sheets. Ideal Skills and Experience: - Proficiency in reading and interpreting files. - Advanced skills in data extraction, particularly from database files. - Experience in delivering data in a spreadsheet format. - Flexibility to accommodate future changes in the extraction requirements. - Strong communication skills to clarify requirements and deliverables.

I am in need of an experienced ASP.NET MVC C# developer to create a web application that connects to AWS RDS ...application should allow for user to login, with different roles such as Admin, Regular User, and Guest. - Dashboard: The dashboard should be read-only and include elements such as charts and graphs, recent activities, notifications, reports, and filters. The ideal freelancer for this project should have: - Proven experience with ASP.NET MVC C# - Strong understanding of AWS RDS and OpenSearch DB - Experience with login systems and user policies - Previous work involving the creation of read-only dashboards If you have the necessary skills and are confident in your ability to deliver a high-quality web application that meets these requirements, I look forward to hearing...

I need an architect or experienced draftsperson to design a medium-sized granny flat with separate rooms. The design needs to accommodate a kitchen, bathroom, laundry area, and two bedrooms within a space roughly 10m x 5m. Particular emphasis will be placed on maximizing space and creating a functional, cozy environment. Key Skills and Experience: - Experience in residential architecture, specifically compact designs such as granny flats - Proven ability to create practical, efficient layouts - Strong understanding of structural integrity and building regulations - Ability to work within specified dimensions and requirements - Proficient in CAD or similar design software

I need an architect or experienced draftsperson to design a medium-sized granny flat with separate rooms. The design needs to accommodate a kitchen, bathroom, laundry area, and two bedrooms within a space roughly 10m x 5m. Particular emphasis will be placed on maximizing space and creating a functional, cozy environment. Key Skills and Experience: - Experience in residential architecture, specifically compact designs such as granny flats - Proven ability to create practical, efficient layouts - Strong understanding of structural integrity and building regulations - Ability to work within specified dimensions and requirements - Proficient in CAD or similar design software

I'm in need of a skilled architect or structural engineer to create a detailed pole barn design for my new garage. This will be a 30' deep by 40' wide structure with 3 overhead doors. It will be attached to my house. Per local building code I can do so as long as I use pre-cast perma columns into the ground. I want a 5/12 pitch on the roof. 10' walls, there will be steel on the roof with perlings. It will be sided so will be putting plywood or zip system on the exterior. The attached design is pretty much what I'm looking for other than I have changed to a 5/12 pitch. On the right side I need it to be a bit wider as that's the side that will be attached to the house and will need to put stairs inside for entry to the back mudroom. Key Requirem...

Seeking a skilled architect to complete drawings for a 400 sq ft pool house. The basic floor plan and elevations are already sketched, but need to be re-drawn by a professional. We also need a wall section, foundation plan and roof plan. Must have experience in residential architectural design, attention to detail, and strong communication skills. Georgia-based architect with successful residential projects and experience in obtaining building permits preferred.

I'm seeking an experienced architect who has background in designing medium-sized (1000-2000 sq ft) rustic homes. The objective is to create a simple and warm cabin-like house following key specifications: - Comply with the current British Columbia Building Code (stage 3 efficiency) - Must have 3 bedrooms and 2 bathrooms Your role will also involve assisting me through the process of obtaining a building permit. Familiarity with this process in British Columbia is a major plus. Ideally, you should have previously designed homes that fit within these building codes and weather conditions. Please provide examples of similar work in your proposal.

I'm looking for an experienced architect to assist with final revisions of both construction plans and interior designs for a project. The specialist should be proficient in AutoCAD, as the project drawings are already in the final revision stage. Your role will be to make the necessary edits to the plans and designs, ensuring that they are ready for implementation. Ideal Experience: - Proficiency in AutoCAD - Experience in the architecture field - Strong attention to detail - Ability to work with and interpret construction plans and interior design

I'm searching for an architect experienced in airport renovation projects, specifically concerning interior design and professional finishing. Key tasks will focus on: - Creating structural shop drawings displaying the chosen interior design concepts and finishing techniques. - Offering recommendation and assistance with selecting appropriate furnishings to fit the style and functionality needed for an airport setting. - Formulating an appealing and practical color scheme aligned with the airport's branding. - Designing efficient and attractive lighting arrangements to enhance the ambiance and provide necessary illumination. The specific space for this renovation project is the airport's kitchen, living room, and bathroom. Ideal candidates should have a demonstrate...

I'm seeking a skilled architect/designer who's proficient in modern, minimalist design to create an enticing design for a 6500 ft2 house. Key elements of the project include: * Four bedrooms: Thoughtful placement and design of each room is crucial. * Gym: A specially designed room to accommodate a home gym. * Preferred Style: Minimalist. The design should embody the whole house unhindered by unnecessary complications, with functionality at its core. In your bid, please include examples of your past minimalist design projects. Preference will be given to those with experience in designing houses of similar size and amenities. I look forward to seeing your innovative design solutions!

I'm in need of a professional architect to make renders ( exteriors and interior , and for the masterplan) and design the final board presentation ( the project is a university project ) *important point * - You should have Revit 2024 (as the files were created in Revit 2024) - you should be professional in using Photoshop ( as you should design the board in photoshop) -You should use Lumion to make the renders. Your scope : 1) renders for 6 exterior , 3-4 interiors , and render for the masterplan 2) design the final presentation board.

No UI needed, db ready. Login, Product, Order, Staff tables. CRUD Able to start immediately. It is just very small project only. I need developer who can follow one by one.

I have a complete PDF map and require an architect to upload it to the LDA portal. Key tasks: - Upload the existing PDF map to the LDA portal without any modifications or updates. Ideal skills and experience: - Prior experience uploading maps or similar documents to the LDA portal. - Understanding of the architectural or land development industry. - Familiarity with PDF file formats and the specific requirements of the LDA portal. Please ensure you have the expertise and access to fulfill the requirements of this project before submitting your proposal. Thank you.

I need a proficient HTML developer to construct a detailed contact ...uploads are permitted. - Auto-Response: Configure the form to send an automated reply once a customer fills it out. This reaction should reassure the client that their message has successfully been received. - Database Utility: Arrange for all submitted information through the form to be securely stored in a database. This will streamline tracking and handling of client queries. Details of the DB structure will be provided. - Security Measures: Implement Captcha security to filter out any potential spam or automated entries. - Skills Required: Deep understanding of HTML, CSS, JavaScript, and server-side scripting languages. Familiarity with database management and maintaining website security protocols is al...

Tasked with migrating our existing PHP/Apache project files and DB database from our live server to a new vendor server. This positions requires: - Working hands-on with Unix servers - Strong understanding of PHP 7.0, the version currently utilized on our live server - Familiarity with Apache 2.4, the version currently running on our live server - Capable of accurately inputting database credentials - Ensuring the project is fully functional on both web and mobile platforms Ideal candidate will exhibit expertise in server administration, specifically Unix. Familiarity with PHP 7.0 and Apache 2.4 is required. Knowledge of databases, particularly inputting credentials, is appreciated. Experience in ensuring cross-platform functionality on web and mobile applications is a huge plus.

We are seeking a skilled full-stack developer with 3+ year experienced for a SAAS-based Electronic Medical Records (EMR) system. Responsibilities: -Architect and develop scalable and efficient services using Node.js, -Implement intuitive UI/UX using Vue.js and Tailwind Css. -Implement RESTful APIs and integrate third-party services -Optimize application performance and ensure code quality and debugging issues reported by users or tester -Plan, develop, and implement microservices Requirements: -Minimum 3 years experience in Node.js and Vue.js. -Proficiency in building and consuming RESTful APIs, and experience with API design principles. -Previous experience in SAAS based EMRs, Seeder, Data migration and Functional module development Use of freelancer's desktop time trackin...

I'm looking for an architect to design building plans for an 18 foot habitation box for my expedition vehicle, ensuring it's equipped with all necessary systems for a comfortable journey. Key Points: - **Power System:** It's crucial that this habitation box has a reliable and versatile power system. I need it to include solar panels, a battery bank, and a generator. The architect should ensure that these systems are integrated seamlessly within the design, considering factors like space, weight distribution and ease of access for maintenance. - **Water System:** The design should factor in space and weight considerations for the habitation box's water system. I'd like to have a freshwater tank, greywater tank, and a water filtration system included...

I'm in need of a professional architect to make renders ( exteriors and interior , and for the masterplan) and design the final board presentation ( the project is a university project ) *important point * - You should have Revit 2024 (as the files were created in Revit 2024) - you should be professional in using Photoshop ( as you should design the board in photoshop) -You should use Lumion to make the renders. Your scope : 1) renders for 6 exterior , 3-4 interiors , and render for the masterplan 2) design the final presentation board.

...AI/ML models. • Known for providing solutions with Natural Language Processing (NLP) capabilities, recommendation systems, data analysis, and data visualization. • Proficiency with QR, WhatsApp, LLM, DB, managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and del...

I have a simple PHP Guestbook script with a flat file Db. I need someone to add more entries in the posting form, see my example attachment. Including making the necessary changes and validations in the script for these new entries. Please make necessary adjustments in Admin Panel to reflect these new added entries, as needbe. Also, I would like the post results (Current Entries) displayed on a separate landing page. Not on the same page that is below the posting form. Please test out script on your own server.... Thank you

I'm looking for experienced freelancer who can help me optimize my WordPress d...can help me optimize my WordPress database. The site is currently facing performance challenges like slow loading times and high CPU usage while some DB operations (post/comment multiply deleting). Requirements: - Proven experience in optimizing WordPress databases - Strong understanding of MySQL/MariaDB As a client, I have full access to the hosting server and database configuration settings, so you'll have the necessary access to make the changes required. Please only bid if you have the relevant experience and can deliver results efficiently. Plz no "manage" bids, the funds are limited & we need to discuss a lot f tech questions about DB, so you will waste YOUR and...

I'm in search of a skilled and experienced interior designer or architect to conceptualize a layout for an apartment with separate rooms. The apartment must feature: - Living Room: A space for entertainment and relaxation. - Kitchen: Compact, functional, and modern. - Bedroom: Promoting tranquility and peacefulness. Ideal fit is someone with a keen eye for detail, understands space utilization, and can create a harmonious separation of rooms. Experience in residential design is a must. Share your portfolio showcasing similar work. Prompt communication and professional inputs are appreciated.

I'm in need of an architect to design a single-story building for services with a contemporary style. The project will involve creating both the floor plan and exterior design. Key Requirements: - Architectural Floor Plan: You'll be required to create a comprehensive floor plan that maximizes space and functionality. The layout should be suitable for a single-story residential building. - Exterior Design: The design should reflect a contemporary style, incorporating modern elements and aesthetics. Ideal Skills and Experience: - Proven experience in residential architectural design, especially single-story buildings. - Strong understanding of contemporary architecture, with a portfolio that showcases similar projects. - Proficiency in using architectural design software. ...

Change framework only. Same UI and DB. Ftp only. We will go module by module.

Kotylin and JAVA engineer is wanted for crypto wallet. 1. Detect the location in the files where connection information to DB is defined and analyze how app and DB are connected. 2. Change DB name and password on app and DB sides without causing any trouble and make the system work.

I'm in need of a talented and experienced landscape architect or designer to help me with the site design and layout services for an RV park project. The creative input required is mainly around the specific configuration of RV slots, as I'm aiming for a linear setup. Experience and Skills Needed: - Strong knowledge of landscape architecture or design - Previous work in RV park planning or similar is advantageous - Understanding of spatial principles, specifically around layout configuration - Ability to generate plans in a linear arrangement Deliverables: 1. Complete Site Design and Layout: The main focus is the RV slot configuration which has to follow a linear arrangement. 2. Detailed Blueprint: Submit a comprehensive plan showing the proposed layout that adheres to...

We're looking for an experienced architect who can bring our vision of a modern high school building to life. Key aspects: - The school needs to have more than 20 classrooms, highlighting our commitment to small class sizes and personalized education. - Alongside classrooms, the design should incorporate a gymnasium, a library, and science labs. Your challenge will be to create a cohesive, well-designed space that accommodates all these features seamlessly. Skills and Experience: - Proven experience in designing large scale buildings, specifically educational institutes would be invaluable. - Knowledge of regulations applicable to high schools. - Capacity to imagine creative solutions to maximize the utility of space would set your proposal apart. We look forward to your in...

**Description:** I am embarking on an exciting venture to create an innovative Airbnb resort using converted shipping containers as villas. While I am only in the initial stages and have not secured land yet, I am are eager to begin the design process to bring my vision to life. **Scope of Work:** I am searching for a talented and experienced architect or designer who specializes in container architecture and hospitality design to help create a concept for an Airbnb resort. The main objective is to design a modern and functional layout that maximizes space while providing a unique and comfortable experience for my guests. **Key Requirements:** - Expertise in container architecture and hospitality design - Ability to create detailed floor plans and 3D renderings - Experience des...

I'm in need of a licensed structural engineer based in Texas. The main task will be to review and stamp framing plans produced by an architect for 2 small residential addition and remodel projects. The job requires the following: - Ensure Structural Integrity: You will need to thoroughly review the plans to ensure that they meet all structural integrity requirements. - Compliance with Building Codes: The plans need to comply with all relevant building codes in Texas. You should have a deep understanding of these codes and be able to ensure that the plans adhere to them. - Room Additions: The projects involve room additions. It is crucial that the framing plans are suited to support these new structures. The ideal candidate will have: - A license as a structural engineer...