Position: Senior Database Developer (MS SQL) / Ecentria / Possible relocation to Chicago
Company: Softesis
Experience required: 5y
English level: intermediate

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.