Lead Data Architect and Database Developer-Schaumburg, IL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxx

 

 

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@xxxxxxxxxxxxxxxxxx

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

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

cid:image004.png@01CD287B.24030AC0

 

 

 


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql Admin]     [PHP Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux