Senior Database Developer (MS SQL) / Ecentria / Possible relocation to Chicago (offline)

What You'll Do Here:

The Database Performance Expert ensures the current database systems are properly utilized and accurately plans for future expansion based on a fluid, agile environment

The role ensures timely response to production performance issues in a matrix-based responsibility model, and collaborates continuously with other teams to ensure consistent delivery across all development teams, avoiding duplication of efforts

This position is responsible for database performance, monitoring, collaboration with the development team as they introduce new applications and infrastructure as well as the Global Technology Services (GTS) team to coordinate maintenance, backup and patching of the different database platforms.

Primary Duties and Responsibilities:

Develop complex stored procedures, functions, triggers, views and queries in support of application development
Participate in application development projects and be responsible for the database architecture and design
Review and optimize existing stored procedures, functions, triggers and queries
Convert existing embedded SQL code into stored procedures
Develop custom scripts to automate various database management processes
Develop PowerBI reports
Define and review best practice standards for data integrity
Develop various ETL jobs for our Data Warehouse

Skills & Requirements:

At least 5 years of professional work experience
Strong problem solving skills
Positive attitude and strong work ethic
Strong written and verbal English communications skills
A degree in Computer Science, IT or related field is considered a plus

Qualification:

Strong experience in T-SQL, procedures, functions, triggers, views and queries
Experience with Microsoft SQL Server 2012/2014/2016 and newer
Knowledge of PowerBI is considered a plus
Experience with SSRS, SSAS, SSIS, & SSDT
Working knowledge of MySQL databases
Knowledge and experience of Data Warehouse concepts

We provide:

Agile culture, continuous improvement process
Friendly and highly-qualified colleagues
Challenging international projects
Competitive salary, yearly reviewed
Real possibilities of growth
full social-security, paid vacations & sick leaves
Excellent working conditions
Powerful hardware, best software/tools
Free snacks and variety of drinks in the office
Monthly company events
Large Summer & Winter parties
Learning and innovations - internal demos & trainings, individual mentorship
Potential business trips to USA
Ability to attend local & international conferences



About OpticsPlanet

When it comes to high-performance technical gear, the most discerning customers choose OpticsPlanet for our unmatched value proposition of great prices, free shipping on most orders, the widest selection (over 1 million products) and excellent customer service. We’re proud of all that – and what makes it possible is that the most talented professionals in the Chicago area choose to work at OpticsPlanet.

OpticsPlanet is a leading internet retailer devoted to the passions and professions of our customers. From hunting or sports shooting to service in the military or law enforcement, we are a destination for millions of people each month. For over fifteen years, we've built a cutting-edge platform that powers ecommerce heavyweights such as OpticsPlanet.com and Dvor.com. We are experiencing a new phase of explosive growth and opportunity, and that means adding more talented and passionate individuals to our existing diverse and professional team. Our casual, fast-paced environment has seen us recognized as one of the "100 Best Companies to Work For" by the Chicago Tribune! In addition to a challenging position, employees at all levels can find extensive opportunities for advancement and career growth, and full-time employees enjoy a popular set of benefits and perks. OpticsPlanet is an Equal Opportunity Employer.

About Softesis

We are a company based in Odessa that specializes in creating and running dedicated teams and offshore sites for our US customers. We’ve been on the market for 3+ years and already have multiple divisions and 100+ people on board.

We truly believe that the best way to do business is to concentrate on long-term partnerships vs. short term projects, that’s why all our team members are hired solely for a particular customer and work directly with customer’s team. Both us and our customers treat every person not as a human resource and but as a team member that is involved and appreciated.

We’re constantly expanding and looking for talents for both on-site and remote cooperation. Check out the list below for something that might be relevant for you. Look forward to hearing from you.

Company website:
https://softesis.com/jobs

DOU company page:
https://jobs.dou.ua/companies/softesis/