Database Adminstration Jobs

6 were found based on your criteria {{|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Intermediate ($$) - Est. Budget: $200 - Posted
We currently have an application that is deployed on a Win Server 2008 system using WAR and MySQL files. Once deployed, the system is accessed via the internet for use. We use Apache-Tomcat for the web server component. The database and web server are on the same physical machine. This is our development configuration. We wish to change the configuration so that there will be dedicated Web server and a separate database server. Each of these is using the Windows Server 2008 operating system. The database server is Apache-Tomcat. This is intended to be the commercial deployment configuration for this database application. These each have internal IP addresses, but share one external IP address via the firewall to the outside world. It is intended that this will be accessed via an SSL connection from the outside world. The application also uses Java, XHTML, and Jasper reports. The work we are requesting is to develop a written procedure to identify changes that are required for the application to operate in this new configuration including: 1) specify reconfiguration required for the mySQL and WAR files to be able to communicate between servers, and from the outside world to the web server. 2) write deployment instructions for the application as they would apply to the separate server configuration. Deployment instructions should include checks at each significant step to verify that the prior steps performed were successful. So basically, how to convert a SQL/WAR file application to run on separate servers. We already have the application running with a single server configuration. We use Eclipse as our IDE for this project and to generate the WAR files.
Skills: Database Administration
Fixed-Price - Expert ($$$) - Est. Budget: $200 - Posted
Looking to migrate a complex excel spreasheet to an MS Access Database. Since I am not an expert I am here, looks like it involves data modelling, data cleaning , drawing up an ERD and then populating the data base with the excel file. Right now I do not have the sample file. But will upload soon.
Skills: Database Administration
Fixed-Price - Intermediate ($$) - Est. Budget: $40 - Posted
We have a need to establish a long term relationship with someone that is skilled in large data management, and database administration. We are currently using Microsoft Access for our reporting and data maintenance, but we will soon be transitioning to MySQL or another setup that allows us to more efficiently store, analyze, and retrieve data. As an attempt to get quick insight into your skill set, we have an initial task we are seeking assistance with. 1. Assist in opening and filtering a large file (4.5 GB, and 13 million records) so that we can narrow it down to a smaller sized file. Once applied, the query should filter the file to around 2 million records. Note that the file is available to us via FTP (and was originally a .dat format). The need is simply to apply the following filter to the text file: (A). On Hand Quantity > "00000000" (B). Price >50 (C). Select ALL columns (or simply the following columns, if it makes it easier: GTIN Prefix, ISBN-10, Price, On-Hand Quantity, Discount Level, Publication Date, On Sale Date, Product Classification Type, and Product Type 2. Ensure that we are able to access the resulting reduced file within Microsoft Access, whether through an ODBC connection, link to txt file, or placing the file directly in Access Thanks for your interest in working with us. We hope you can use this task to establish a long term relationship and help us craft a long term strategy for managing our data.
Skills: Database Administration Big Data Database design Hadoop
Fixed Price Budget - Intermediate ($$) - $30 to $50 - Posted
Hi, We are in search of expert DBA for maintaining our Database and guide our Technical team how to optimized performance. This is a short term project. As database is growing we need some expert advice for maintaining database operations. Role - We have a list of queries and will share developing database so he/she has to check database and tell our developer team what is correct and what is not correct? - What steps required for maintaining database ex: shrink db logs...etc - We have a list of queries, so he has to analysis the queries and give suggestion to overcome those issue. Please mention your total years of experience with detail portfolio. Thanks
Skills: Database Administration Microsoft SQL Server Administration