Database Engineer

company banner
Interactive Business Systems
Agile, Automated, Customer Service, Database, Development, Ecommerce, Hadoop, Lifecycle, MySQL, mysql, NoSQL, Oracle, PostgreSQL, PowerShell, Project, Research, SQL, SQL Server, Testing, Visual Basic
Full Time
Work from home not available Travel not required

Job Description



Job Description



Job Summary:


The Database Engineer II is tasked with developing high profile and mission critical solutions leveraging database systems e.g. RDBMS, NoSQL technologies. This role is responsible for database design, data access components, development and performance/tuning of database solutions. This role involves close interaction with architects, internal software development groups and operational DBAs, focusing on development and implementation of our web-based eCommerce product and our server-based transactions systems.

Major Duties & Responsibilities
  • Design and develop database components.
    • Design and create data models and database schemas.
    • Write and Troubleshoot SQL code on a variety of platforms (MS SQL Server, PostgreSQL, etc )
    • Design, development and maintain ETL and data replication processes.
    • Research and help identify opportunities for leveraging open-source database solutions (PostgreSQL, Cassandra, Hadoop) in our environment
    • Participate in development and continual refinement of database standards and best practices.
  • Optimize database performance.
    • Database performance diagnosis. Troubleshoot performance bottlenecks, read query plans, review SQL response logs, traces etc.
    • Act as the third tier of escalation in support of the database infrastructure.
  • Manage database project lifecycle.
    • Monitor usage trends and suggest improvements. Drive continuous improvement in service delivery quality with emphasis on performance, availability and customer service.
    • Inventory systems and retire unused items.
    • Refactor systems to improve data quality and reduce maintenance costs.
  • Develop and implement procedures for automated testing, build and deployment.


Qualifications

Required Knowledge, Skills & Abilities
  • Bachelor's degree in Computer Science, Computer Engineering or Software Engineering
  • 5+ years of professional software engineering experience
  • 3+ years of experience with Microsoft SQL Server or other RDBMS system (Oracle).
  • Advanced software development skills e.g. C#, C++, PowerShell, Visual Basic
  • Experience using open source database system PostgreSQL or MySQL.
  • Able to work in an Agile environment.


Preferred Skills:
  • Knowledge of NoSQL database platforms Cassandra or RavenDB.
  • Knowledge and experience working with Big Data Hadoop.
  • Knowledge and experience with monitoring systems and framework (MS SCOM, Zabbix, Nagios)



Company Information

For over 35 years, our business model has been based on developing strong relationships with both our clients and our consultants. Armed with knowledge and vision, IBS works with IT decision makers to identify just the right IT staffing or solutions-based consulting services that get the job done right the first time.
Dice Id : cxibscgo
Position Id : J3R06X6HGPTVCXVLK1V

Similar Positions at Interactive Business Systems

Systems Engineer (Linux)
  • Pleasant Prairie, WI
  • 2 days ago
Senior Engineer
  • Chicago, IL
  • 2 days ago
Data Analyst
  • Chicago, IL
  • 2 days ago