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 PostgreSQL and MS SQL environments.
• 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.
• Develop procedures to DTS data from multi-sources.
• 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.

REQUIRED KNOWLEDGE/SKILLS/ ABILITIES
• College degree in computer related field or equivalent experience required.
• Demonstrated experience in database design, schema development, optimization/ tuning and maintenance of databases. Specifically, PostgreSQL and SQL Server knowledge is required.
• 5+ years of proven experience including a broad range of Database Administration and Development.
• Minimum 2 years of proven experience of Database Development
• Minimum 5 years MS SQL Server as a designer and DBA highly desired.
• Minimum 5 years SQL programming experience highly desired.
• Expertise in data modeling tools is required.
• Linux OS knowledge, shell scripting knowledge is a huge plus.
• Demonstrated interest in, knowledge of, and enthusiasm for Internet and Open Source technologies
• Must be analytical, flexible, innovative, and self-motivated
• Must be able to succeed in a dynamic team environment and be open to overtime when necessary
• Strong verbal and written communication skills, team player with excellent interpersonal skills.
• Ability to effectively manage multiple priorities with minimal supervision

Please include salary requirements and email your resume to:

kim.stephen@ realpage.com