Job Type: Permanent Location: Hyderabad, India Salary: Competitive based on experience Company: Realpage Inc<http://www.realpage.com/> JOB Details: The Database Administrator/Developer is responsible for the design, development and maintenance of databases which will support the products and services developed by the Product Development Team. The DBA/Developer will work with the Product Development Manager in the planning, design, development, testing and deploying database projects. Close contact will be required with the entire Product Development Staff to ensure that the programmers' activities are in line with the goals of larger projects involving multiple programmers. Maintaining set design standards for the larger project to ensure compatibility will be essential for this position. YieldStar places a strong emphasis on client service, so the DBA/Developer, while not a frontline customer contact, will interact with customers to ensure that their requirements are met in the most efficient manner. PRIMARY RESPONSIBILITIES * Design logical and physical databases within primarily in PostgreSQL ecosystem * Manage existing data models and create models for new databases. * Generate and maintain data dictionaries. * Work with business analysts and various groups to collect requirements and translate those into logical database models. * Extensive database programming using PostegreSQL and other SQL server utilities. * Troubleshoot problems reported by clients in the data warehouse systems. * Identify potential performance and process improvements. * Conduct data analysis, design and execution architecture training, as required. * Develop new and manage existing ETLs for the warehouse databases. * Provide SQL / database support to the application developers. * Manage the databases in development and QA environments. * Monitor and manage the production data warehousing processes.
