Lead Data Architect and Database Developer-Schaumburg, IL

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(at)nexgenwireless(dot)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

<http://www(dot)karin(at)nexgenwireless(dot)com> karin(at)nexgenwireless(dot)com

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

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

cid:image004(dot)png(at)01CD287B(dot)24030AC0