Lead Data Architect and Database Developer-Schaumburg, IL - Mailing list pgsql-jobs

Lead Data Architect and Database Developer-Schaumburg, IL

Data Modeling, Database, Postgres, SQL, PSQL, Linux

Responsibilities:

• Lead the data modeling and RDBMS design for our high-volume data warehouse application and establish standards across modules
• Develop stored functions and triggers using PSQL and BASH Scripts with CRON to automate as part of our application needs
• Oversee development and production database and server performance with improvements
• Perform code reviews of SQL and offer performance related improvements to the team as needed
• Define database backup and recovery practices
• Investigate and recommend third-party reporting solutions with an overall strategy for their integration

Qualifications:

• BS in Computer Science or higher.
• 5 years professional development experience, with 1+ years’ experience with Postgres or Oracle
• Practical experience developing a data warehouse using dimensional modeling techniques
• Experience with data modeling design (CASE) tools (Erwin, Toad Schema Modeler, etc.)
• Highly proficient with SQL and PSQL and related tuning with indexes and database parameters
• Proficient with developing methods of loading large volumes of data automatically into a database
• Experience with table partitioning strategies and related implementation
• Proficient with interpreting query explain plans, reviewing data within tables and recommending indexing strategies
• Experience with establishing methods for base-lining database performance and measuring improvements with changes
• Experience with spatial data types (SDO_Geometry or public.geometry) and related functions (optional)
• Capable of setting up database servers and instances from scratch on linux (optional)
• Experience in recommending and configuring optimal hardware solutions including storage area networks (optional)
• Experience with Agile development practices and Scrum (optional)

Compensation: Market Competitive

Applications should be sent to jobs@nexgenwireless.com

Karin Svenningsen

Nexgen Wireless, Inc.

1701 E. Woodfield  Rd.

Suite 600

Schaumburg, IL  60173

Office:(847)874-7050 ext 133

Fax:(847)906-0684

karin@nexgenwireless.com

http://www.linkedin.com/pub/karin-svenningsen/55/a26/71

Awarded One of the Fastest Growing Private Companies by Inc. 5000