Database Developer

Full–time
Job Description-

Role Category: Programming & Design

Role: Database Developer

Requirements:
• 2 to 7 years of relevant experience of Greenplum, PostgreSQL, Oracle, MS SQL database skills (SQL, PL/SQL, TSQL).
• Must have good experience in writing SQL queries, SQL performance tuning.
• Experience of ETL tools is must.

➢ Experience into SQL server 2008/2012.

• Designing databases and ensuring their stability, reliability, and performance.

• Design, create, and implement database systems based on the end user's requirements.

• Improve application's performances.

• Prepare documentations for database applications.

• Develop database objects such as schema, tables, Views, Functions, Stored Procedures,

dictionaries.

• Ensure the data quality and integrity in databases.

• Fix any issues related to database performance and provide corrective measures.

• Create complex functions, scripts, stored procedures and triggers to support application

development.

• Provide authentication and authorizations for users in SQL Server/DB level.

• Develop best practices for database design and development activities.

• Should have some experience in performance tuning, Transaction and deadlock analysis.

• Must have some experience in Index management including maintenance.

➢ Experience into PostgreSQL.

• Designing databases and ensuring their stability, reliability, and performance.

• Design, create, and implement database systems based on the end user's requirements.

• Improve application's performances.

• Prepare documentations for database applications.

• Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.

• Knowledge of JSON and PostgreSQL support for JSON.

• PostGIS proficiency and grasp of core geospatial concepts.

• Develop best practices for database design and development activities.

➢ Experience into Greenplum (good to have)

Skills & Qualifications:

• Good to have working experience in MDX queries.

• Preferable Client facing experience.

• Leadership capabilities.

• Strong logical and debugging skills.

• Good reputed college

• MUST have excellent English (verbal and written).

Company URL: http://www.infoobjects.com/

About Us

InfoObjects (a CMMi Level-5, Certified Company) was formed in 2005 to provide software engineering services focused on cutting-edge database, middleware and web-tier application development. Combining our passion for open source technologies with rapid, agile development techniques, we’ve earned a reputation for being a reliable software development partner and attribute our success to the core values of our business: Our team is family – we are proud of our awards for Best Place to Work in the Bay Area by the San Francisco Business Times and Silicon Valley Business Journal.

Our US-based consultants and Jaipur development organization are growing rapidly because of the opportunities for personal and professional growth we offer our team members. Known for our intensive technical education and training (especially in Java and the Hadoop ecosystem), we have been an INC 5000 fastest growing company the last 3 years running, and ranked No. 22 in Silicon Valley last year