Database Developer
Job Description
Informiam, the leading provider of on-demand and on-premises business intelligence and performance analytics products for Contact Centers and IT Organizations, seeks a Database Developer with experience in designing, tuning, and managing high demand transactional database systems and OLAP data marts. The database systems you design and manage will power business intelligence and reporting analytics products used by some of the largest IT companies in the world.
Join the company that is revolutionizing the way software and data are designed, managed, and delivered. Work on high-end and high demand systems that are used by fortune 500 companies. We are a growing, energetic, and dynamic organization and the established leader in our market. We provide an exciting, fast-paced, hyper-casual environment in which we demand personal creativity and innovation. We are looking for talented and motivated individuals to help us ensure our database systems are capable of meeting ever-growing demand. If you want to work on the cutting edge of high demand database systems, then read on.
This position is responsible for helping manage and build the database systems and utilities that enable our product to run efficiently and reliably. You will interface with different parts of the organization to understand business requirements. Work with production engineers, QA engineers, and software engineers to address tactical objectives as well as long-term strategic initiatives. Focus on database analysis, administration, and programming tasks. You must have an eye for detail and a determination to do the little things to insure that our data and products run optimally.
Primary Responsibilities:
- Work with applications team to meet product release requirements and deliverables
- Work with production team to insure that our database infrastructure is operating at optimal performance
- Insure that our database infrastructure, both software and hardware, are capable of meeting customer/user needs
- Insuring all reporting and database intensive applications are capable are running efficiently
- Develop and enhance internal tools and applications for managing database infrastructure
- Develop and perform data analysis operations on the database to insure integrity and consistency
- Assist software developers in modeling and optimizing database schema and SQL
- Coordinating on going tuning and scaling of production, development, and QA databases
- Run, manage and develop various database migration and configuration tools and scripts
- Manage, configure, and tune internal database infrastructure
- Debug and fix production database bugs
Experience Required
- Experience in tuning and running high volume databases
- Capable of modeling, developing, and tuning very complex SQL
- Experience working with large-scale Unix platform
- Experience with multiple databases (Oracle/DB2/SqlServer/MySql/Postgres)
- Experience in developing high demand OLTP Internet application infrastructure
- Experience with database replication, fault tolerant systems, and distributed architectures
- Familiar with high-end storage systems
- Experience with OLAP products and tools
- Experience with star-schema databases designs in data warehouse systems
- Extensive hands-on knowledge of database modeling and design
- Experience with distributed database products and middleware a big plus
- Experience with major ERP products/databases a big plus
Keys to Success
- Must be able to deliver and manage short-term and long-term goals
- Must be an excellent problem solver with a can do attitude
- Insure that our data center and applications can scale to support millions of users and giga bytes of data
- Capable of working in a fast paced environment
- Experience with and have a good understanding of standard software engineering practices, and a strong commitment to product quality
Technical Skills
- 2+ with writing and tuning complex SQL
- Sound programming/scripting skills in at least one of C, Java, or Perl
- Accomplished at Unix shell programming and scripting (bash/sh/ksh)
- Working knowledge of HTML and javascript programming
- Experience with products such as ERWIN
- Experience with JDBC, ODBC, PL/SQL etc
- Oracle, SQL Server, or DB2 in high-end configurations
- Experience with ETL tools such as Informatica, Ardent, and/or Sagent
- OLAP tools such as BO or Cognos a big plus
- Reporting tools such as Cognos, Business Objects, and Microstrategy